owner_id = core_person:id
main_office_id = core_office:id
comptype_id = core_enum:id
+parent_id = core_company:id
[core_office]
company_id = core_company:id
ALTER TABLE core_company ADD COLUMN comptype varchar(32) NOT NULL DEFAULT '';
-- not sure if this needs to change.. << there is code in core/update that fills this in??
ALTER TABLE core_company ADD COLUMN comptype_id INT(11) DEFAULT 0;
+
+ALTER TABLE core_company ADD COLUMN parent_id NOT NULL DEFAULT 0;
+
+
ALTER TABLE core_company CHANGE COLUMN isOwner isOwner int(11);
ALTER TABLE core_company CHANGE COLUMN comptype comptype VARCHAR(32) DEFAULT '';
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 ;