From 6f451313121e6a6d8b58c6ceb1307d3e8661fd8c Mon Sep 17 00:00:00 2001 From: Chris Date: Wed, 19 Dec 2012 17:59:47 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index e9cbbef7..0f5809aa 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -165,6 +165,8 @@ CREATE TABLE Office ( ALTER TABLE Office ADD COLUMN company_id int(11) NOT NULL default '0'; ALTER TABLE Office ADD COLUMN name varchar(64) NOT NULL DEFAULT ''; ALTER TABLE Office ADD COLUMN address text ; +ALTER TABLE Office ADD COLUMN address2 TEXT; +ALTER TABLE Office ADD COLUMN address3 TEXT; 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 ''; -- 2.39.2