X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;fp=DataObjects%2Fcore.sql;h=f1cbfb9528e98b9838155e062be2e9caf6eec7a9;hp=26c1eb5c1ef5ca40dd982c3c563831dcaef063ca;hb=7edd108b2e577478dffd67f9818f3e31ccb1ae28;hpb=976576654e1231612d8043eccd0958479252ef11

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;