From f466470335b3f80216d32d8f25c7fb243e48cf5d Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 4 Jan 2013 10:32:03 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 671dbff6..e9caeb41 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -27,9 +27,10 @@ ALTER TABLE Companies ADD COLUMN dispatch_port varchar(255) NOT NULL DEFAULT ALTER TABLE Companies ADD COLUMN province varchar(255) NOT NULL DEFAULT ''; ALTER TABLE Companies ADD COLUMN country varchar(4) NOT NULL DEFAULT ''; --- comptype is quasi depricated??? + ALTER TABLE Companies ADD COLUMN comptype varchar(32) NOT NULL DEFAULT ''; -ALTER TABLE Companies ADD COLUMN comptype_id INT(11) DEFAULT 0; +-- not sure if this needs to change.. +--ALTER TABLE Companies ADD COLUMN comptype_id INT(11) DEFAULT 0; ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11); -- 2.39.2