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;
ALTER TABLE Companies ADD INDEX name_lookup (name);
-ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;
+
-- our new code should have this fixed now..
-- UPDATE Companies set comptype='OWNER' where isOwner=1;