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 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 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 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 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
+-- UPDATE Companies set comptype='OWNER' where isOwner=1;
+