From: Chris Date: Tue, 18 Mar 2014 08:17:24 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a5d19398269a4e7d2c6f6d68770b44db32a61e4e DataObjects/core.sql --- 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 '';