-CREATE TABLE Companies (
+CREATE TABLE core_company (
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 '';
+ALTER TABLE core_company ADD COLUMN code varchar(32) NOT NULL DEFAULT '';;
+ALTER TABLE core_company ADD COLUMN name varchar(128) default NULL ;
+ALTER TABLE core_company ADD COLUMN remarks text ;
+ALTER TABLE core_company ADD COLUMN owner_id int(11) NOT NULL DEFAULT 0 ;
+ALTER TABLE core_company ADD COLUMN address text ;
+ALTER TABLE core_company ADD COLUMN tel varchar(32) default NULL;
+ALTER TABLE core_company ADD COLUMN fax varchar(32) default NULL;
+ALTER TABLE core_company ADD COLUMN email varchar(128) default NULL;
+-- ALTER TABLE core_company ADD COLUMN isOwner int(11) default NULL;
+ALTER TABLE core_company ADD COLUMN logo_id INT(11) NOT NULL DEFAULT 0;;
+ALTER TABLE core_company ADD COLUMN background_color varchar(8) NOT NULL;
+ALTER TABLE core_company ADD COLUMN url varchar(254) NOT NULL DEFAULT '';
+ALTER TABLE core_company ADD COLUMN main_office_id int(11) NOT NULL DEFAULT 0;
+ALTER TABLE core_company ADD COLUMN created_by int(11) NOT NULL DEFAULT 0;
+ALTER TABLE core_company ADD COLUMN created_dt datetime NOT NULL;
+ALTER TABLE core_company ADD COLUMN updated_by int(11) NOT NULL DEFAULT 0;
+ALTER TABLE core_company ADD COLUMN updated_dt datetime NOT NULL;
+ALTER TABLE core_company ADD COLUMN passwd varchar(64) NOT NULL DEFAULT '';
+ALTER TABLE core_company ADD COLUMN dispatch_port varchar(255) NOT NULL DEFAULT '';
+ALTER TABLE core_company ADD COLUMN province varchar(255) NOT NULL DEFAULT '';
+ALTER TABLE core_company ADD COLUMN country varchar(4) NOT NULL DEFAULT '';
+
+
+ALTER TABLE core_company 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 core_company 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 core_company CHANGE COLUMN isOwner isOwner int(11);
+ALTER TABLE core_company 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 core_company ALTER isOwner TYPE int(11);
+ALTER TABLE core_company ALTER owner_id SET DEFAULT 0;
+ALTER TABLE core_company 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 core_company ADD COLUMN address1 text ;
+ALTER TABLE core_company ADD COLUMN address2 text ;
+ALTER TABLE core_company ADD COLUMN address3 text ;
+ALTER TABLE core_company ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028
-ALTER TABLE Companies ADD INDEX name_lookup (name);
+ALTER TABLE core_company ADD INDEX name_lookup (name);
+
+ALTER TABLE core_company ADD COLUMN deleted_by INT(11) NOT NULL DEFAULT 0;
+
+ALTER TABLE core_company ADD COLUMN deleted_dt DATETIME NOT NULL DEFAULT '0000-00-00';
+
+ALTER TABLE core_company ADD INDEX lookup_owner_id (owner_id);
-- our new code should have this fixed now..
--- UPDATE Companies set comptype='OWNER' where isOwner=1;
+-- UPDATE core_company set comptype='OWNER' where isOwner=1;