2 -- // core comapy types - use core enums (Company Type)
3 DROP TABLE core_company_type;
6 CREATE TABLE core_event_audit (
7 id int(11) NOT NULL AUTO_INCREMENT,
11 ALTER TABLE core_event_audit ADD COLUMN event_id int(11) NOT NULL DEFAULT 0;
12 ALTER TABLE core_event_audit ADD COLUMN name varchar(128) NOT NULL DEFAULT '';
13 ALTER TABLE core_event_audit ADD COLUMN old_audit_id int(11) NOT NULL DEFAULT 0;
14 ALTER TABLE core_event_audit ADD COLUMN newvalue BLOB NOT NULL DEFAULT '';
15 ALTER TABLE core_event_audit ADD INDEX lookup(event_id, name, old_audit_id);
18 RENAME TABLE Group_Members TO group_members;
20 CREATE TABLE group_members (
21 id int(11) NOT NULL AUTO_INCREMENT,
24 ALTER TABLE group_members ADD COLUMN group_id int(11) default NULL;
25 ALTER TABLE group_members ADD COLUMN user_id int(11) NOT NULL default 0;
33 -- we duplicate office_id and company_id here...
34 -- not sure if we should keep doing that in the new design...
35 -- we should improve our links code to handle this..
39 --// old core image type - merged into enum.
40 DROP TABLE core_image_type;
48 -- ----------------------------