From 5e513d7c037c16e6c2c670545acd7c4b9deb3579 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 4 Jan 2013 10:31:20 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 8d1f08ac..671dbff6 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -16,7 +16,6 @@ ALTER TABLE Companies ADD COLUMN email varchar(128) default NULL; --ALTER TABLE Companies ADD COLUMN isOwner int(11) default NULL; ALTER TABLE Companies ADD COLUMN logo_id INT(11) NOT NULL DEFAULT 0;; ALTER TABLE Companies ADD COLUMN background_color varchar(8) NOT NULL; -ALTER TABLE Companies ADD COLUMN comptype varchar(32) NOT NULL DEFAULT ''; ALTER TABLE Companies ADD COLUMN url varchar(254) NOT NULL DEFAULT ''; ALTER TABLE Companies ADD COLUMN main_office_id int(11) NOT NULL DEFAULT 0; ALTER TABLE Companies ADD COLUMN created_by int(11) NOT NULL DEFAULT 0; @@ -28,10 +27,13 @@ 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; + ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11); ALTER TABLE Companies CHANGE COLUMN comptype comptype VARCHAR(32) DEFAULT ''; -ALTER TABLE Companies ADD COLUMN comptype_id INT(11) DEFAULT 0; -- postres --ALTER TABLE Companies ALTER isOwner TYPE int(11); ALTER TABLE Companies ALTER owner_id SET DEFAULT 0; -- 2.39.2