1 CREATE TABLE Companies (
2 id int(11) NOT NULL auto_increment,
7 ALTER TABLE Companies ADD COLUMN code varchar(32) NOT NULL DEFAULT '';;
8 ALTER TABLE Companies ADD COLUMN name varchar(128) default NULL ;
9 ALTER TABLE Companies ADD COLUMN remarks text ;
10 ALTER TABLE Companies ADD COLUMN owner_id int(11) NOT NULL DEFAULT 0 ;
11 ALTER TABLE Companies ADD COLUMN address text ;
12 ALTER TABLE Companies ADD COLUMN tel varchar(32) default NULL;
13 ALTER TABLE Companies ADD COLUMN fax varchar(32) default NULL;
14 ALTER TABLE Companies ADD COLUMN email varchar(128) default NULL;
15 --ALTER TABLE Companies ADD COLUMN isOwner int(11) default NULL;
16 ALTER TABLE Companies ADD COLUMN logo_id INT(11) NOT NULL DEFAULT 0;;
17 ALTER TABLE Companies ADD COLUMN background_color varchar(8) NOT NULL;
18 ALTER TABLE Companies ADD COLUMN url varchar(254) NOT NULL DEFAULT '';
19 ALTER TABLE Companies ADD COLUMN main_office_id int(11) NOT NULL DEFAULT 0;
20 ALTER TABLE Companies ADD COLUMN created_by int(11) NOT NULL DEFAULT 0;
21 ALTER TABLE Companies ADD COLUMN created_dt datetime NOT NULL;
22 ALTER TABLE Companies ADD COLUMN updated_by int(11) NOT NULL DEFAULT 0;
23 ALTER TABLE Companies ADD COLUMN updated_dt datetime NOT NULL;
24 ALTER TABLE Companies ADD COLUMN passwd varchar(64) NOT NULL DEFAULT '';
25 ALTER TABLE Companies ADD COLUMN dispatch_port varchar(255) NOT NULL DEFAULT '';
26 ALTER TABLE Companies ADD COLUMN province varchar(255) NOT NULL DEFAULT '';
27 ALTER TABLE Companies ADD COLUMN country varchar(4) NOT NULL DEFAULT '';
30 ALTER TABLE Companies ADD COLUMN comptype varchar(32) NOT NULL DEFAULT '';
31 -- not sure if this needs to change.. << there is code in core/update that fills this in??
32 ALTER TABLE Companies ADD COLUMN comptype_id INT(11) DEFAULT 0;
35 ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11);
36 ALTER TABLE Companies CHANGE COLUMN comptype comptype VARCHAR(32) DEFAULT '';
38 --ALTER TABLE Companies ALTER isOwner TYPE int(11);
39 ALTER TABLE Companies ALTER owner_id SET DEFAULT 0;
40 ALTER TABLE Companies ALTER url SET DEFAULT '';
42 ALTER TABLE Companies ADD COLUMN address1 text ;
43 ALTER TABLE Companies ADD COLUMN address2 text ;
44 ALTER TABLE Companies ADD COLUMN address3 text ;
45 ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028
47 ALTER TABLE Companies ADD INDEX name_lookup (name);
49 -- our new code should have this fixed now..
50 -- UPDATE Companies set comptype='OWNER' where isOwner=1;