From: Alan Knowles Date: Fri, 13 Jan 2012 09:54:51 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=ca4d9ac2bcb9beefaf70afe8a6502742b85ca2fe DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 8c5b4dc3..7eaf3793 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -165,10 +165,10 @@ ALTER TABLE Person ADD COLUMN owner_id int(11) NOT NULL DEFAULT 0; ALTER TABLE Person ADD COLUMN lang varchar(8) default 'en'; ALTER TABLE Person ADD COLUMN no_reset_sent int(11) default '0'; -ALTER TABLE Person ADD COLUMN action_type VARCHAR(32) DEFAULT ''; -ALTER TABLE Person ADD COLUMN project_id int(11) default 0; -ALTER TABLE Person ADD COLUMN deleted_by INT(11) NOT NULL default 0 ; -ALTER TABLE Person ADD COLUMN deleted_dt DATETIME ; +ALTER TABLE Person ADD COLUMN action_type VARCHAR(32) DEFAULT ''; +ALTER TABLE Person ADD COLUMN project_id int(11) default 0; +ALTER TABLE Person ADD COLUMN deleted_by INT(11) NOT NULL default 0 ; +ALTER TABLE Person ADD COLUMN deleted_dt DATETIME ; # old mysql alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;