From 7edd108b2e577478dffd67f9818f3e31ccb1ae28 Mon Sep 17 00:00:00 2001 From: Edward Date: Wed, 16 Apr 2014 17:49:40 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 50 -------------------------------------------- 1 file changed, 50 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 26c1eb5c..f1cbfb95 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -1,54 +1,4 @@ -CREATE TABLE Companies ( - id int(11) NOT NULL auto_increment, - PRIMARY KEY (id) -); - - -ALTER TABLE Companies ADD COLUMN code varchar(32) NOT NULL DEFAULT '';; -ALTER TABLE Companies ADD COLUMN name varchar(128) default NULL ; -ALTER TABLE Companies ADD COLUMN remarks text ; -ALTER TABLE Companies ADD COLUMN owner_id int(11) NOT NULL DEFAULT 0 ; -ALTER TABLE Companies ADD COLUMN address text ; -ALTER TABLE Companies ADD COLUMN tel varchar(32) default NULL; -ALTER TABLE Companies ADD COLUMN fax varchar(32) default NULL; -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 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; -ALTER TABLE Companies ADD COLUMN created_dt datetime NOT NULL; -ALTER TABLE Companies ADD COLUMN updated_by int(11) NOT NULL DEFAULT 0; -ALTER TABLE Companies ADD COLUMN updated_dt datetime NOT NULL; -ALTER TABLE Companies ADD COLUMN passwd varchar(64) NOT NULL DEFAULT ''; -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 ''; - - -ALTER TABLE Companies ADD COLUMN comptype varchar(32) NOT NULL DEFAULT ''; --- not sure if this needs to change.. << there is code in core/update that fills this in?? -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 ''; --- postres ---ALTER TABLE Companies ALTER isOwner TYPE int(11); -ALTER TABLE Companies ALTER owner_id SET DEFAULT 0; -ALTER TABLE Companies ALTER url SET DEFAULT ''; - -ALTER TABLE Companies ADD COLUMN address1 text ; -ALTER TABLE Companies ADD COLUMN address2 text ; -ALTER TABLE Companies ADD COLUMN address3 text ; -ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028 - - -ALTER TABLE Companies ADD INDEX name_lookup (name); - - -- our new code should have this fixed now.. -- UPDATE Companies set comptype='OWNER' where isOwner=1; -- 2.39.2