-- postres
-- ALTER TABLE core_company ALTER isOwner TYPE int(11);
ALTER TABLE core_company ALTER owner_id SET DEFAULT 0;
ALTER TABLE core_company ALTER url SET DEFAULT '';
-- postres
-- ALTER TABLE core_company ALTER isOwner TYPE int(11);
ALTER TABLE core_company ALTER owner_id SET DEFAULT 0;
ALTER TABLE core_company ALTER url SET DEFAULT '';
ALTER TABLE core_company ADD COLUMN address1 text ;
ALTER TABLE core_company ADD COLUMN address2 text ;
ALTER TABLE core_company ADD COLUMN address3 text ;
ALTER TABLE core_company ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028
ALTER TABLE core_company ADD COLUMN address1 text ;
ALTER TABLE core_company ADD COLUMN address2 text ;
ALTER TABLE core_company ADD COLUMN address3 text ;
ALTER TABLE core_company ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028
ALTER TABLE core_company ADD INDEX lookup_owner_id (owner_id);
-- our new code should have this fixed now..
ALTER TABLE core_company ADD INDEX lookup_owner_id (owner_id);
-- our new code should have this fixed now..