-CREATE TABLE `Companies` (
- `code` varchar(32) NOT NULL,
- `name` varchar(128) default NULL,
- `remarks` text ,
- `owner_id` int(11) NOT NULL,
- `address` text ,
- `tel` varchar(32) default NULL,
- `fax` varchar(32) default NULL,
- `email` varchar(128) default NULL,
- `id` int(11) NOT NULL auto_increment,
- `isOwner` int(11) default NULL,
- PRIMARY KEY (`id`)
+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 comptype varchar(8) NOT NULL DEFAULT '';
+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 CHANGE COLUMN isOwner isOwner int(11);
+-- 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 INDEX name_lookup (name);
+
+
+UPDATE Companies set comptype='OWNER' where isOwner=1;
+
+-- // core comapy types - use core enums (Company Type)
+DROP TABLE core_company_type;
+
+
+CREATE TABLE Events (
+ id int(11) NOT NULL auto_increment,