X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;fp=DataObjects%2Fcore.sql;h=f86d9a4e48fea6e3d0a95ceb998347ab49a1ca70;hp=60c0a8b0d1c50e70f43e96759a77e2ef63274992;hb=a5d19398269a4e7d2c6f6d68770b44db32a61e4e;hpb=b726445f4b0b6efdfc46ae6a0ca9b6ba675ac32e 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 '';