From ca4d9ac2bcb9beefaf70afe8a6502742b85ca2fe Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 13 Jan 2012 17:54:51 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) 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 ; -- 2.39.2