From bf5043964b3e42ea76e79b1c04f30d1c9ccd1dd3 Mon Sep 17 00:00:00 2001 From: Chris Date: Thu, 3 Jan 2013 15:17:10 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 1 + 1 file changed, 1 insertion(+) 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 ( -- 2.39.2