X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=59c27c52e6d71cc9910eca33a61cd325b943003a;hp=0f5809aa26326734dc9a3f902c484cdc67029b47;hb=bf5043964b3e42ea76e79b1c04f30d1c9ccd1dd3;hpb=1933c0d5ec4d949c2c487d9256b91e1dad4939e4 diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 0f5809aa..59c27c52 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -171,6 +171,7 @@ ALTER TABLE Office ADD COLUMN phone varchar(32) NOT NULL DEFAULT ''; ALTER TABLE Office ADD COLUMN fax varchar(32) NOT NULL DEFAULT ''; 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; CREATE TABLE Person (