From a5d19398269a4e7d2c6f6d68770b44db32a61e4e Mon Sep 17 00:00:00 2001 From: Chris Date: Tue, 18 Mar 2014 16:17:24 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 60c0a8b0..f86d9a4e 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -174,6 +174,10 @@ ALTER TABLE Person ADD COLUMN phone_direct varchar(32) NOT NULL DEFAULT ''; ALTER TABLE Person ADD COLUMN honor varchar(32) NOT NULL DEFAULT ''; +ALTER TABLE Person ADD COLUMN countries VARCHAR(128) NULL AFTER; + + + # old mysql alter table Person change column active active int(11) NOT NULL DEFAULT 1 ; alter table Person change role role varchar(254) NOT NULL DEFAULT ''; -- 2.39.2