sql/Companies.sql

diff --git a/sql/Companies.sql b/sql/Companies.sql
index e69de29..ef75707 100644 (file)
--- a/sql/Companies.sql
+++ b/sql/Companies.sql
@@ -0,0 +1,51 @@
+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;
\ No newline at end of file