From: Chris <chris@roojs.com>
Date: Wed, 19 Dec 2012 09:59:47 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=6f451313121e6a6d8b58c6ceb1307d3e8661fd8c

DataObjects/core.sql
---

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 '';