From: Alan Knowles Date: Wed, 16 Jan 2013 03:01:12 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c12f581a7f9fda3041712388c1dfeaf141df78d9 DataObjects/core.sql --- 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,