X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=d5ba35d2c5d43c62bd920bd2e9cbbed59a2e2a37;hp=c1c60d83531855121d33e93521c34277cf53bfb9;hb=c12f581a7f9fda3041712388c1dfeaf141df78d9;hpb=3ef43512b67221c27f15e7559aadc5975ad432c3 diff --git a/DataObjects/core.sql b/DataObjects/core.sql index c1c60d83..d5ba35d2 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -178,6 +178,7 @@ ALTER TABLE Office ADD COLUMN email varchar(128) NOT NULL DEFAULT ''; ALTER TABLE Office ADD COLUMN role varchar(32) NOT NULL DEFAULT ''; ALTER TABLE Office ADD COLUMN country VARCHAR(4) NULL; +ALTER TABLE Office ADD COLUMN display_name VARCHAR(4) NULL; CREATE TABLE Person ( id int(11) NOT NULL auto_increment,