X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_company.sql;h=60e7f514783dfcae1ba7fb1413d570ac69f599c2;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=d2d957d90bab24961c58c6dd100271b21b5dc842;hpb=e5e256d50fbec496a89ade6ad1d1fe10aad979e8;p=Pman.Core

diff --git a/sql/core_company.sql b/sql/core_company.sql
index d2d957d9..60e7f514 100644
--- a/sql/core_company.sql
+++ b/sql/core_company.sql
@@ -1,51 +1,57 @@
-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;