X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=a0047eba7a2fa5aa590b506eb6e227b2105c106e;hp=39a9cca75468a61a94bf31f46c51587dbfc3a4fe;hb=HEAD;hpb=b06ebd333bb0a222bdd8da03c6423bb709b513b1 diff --git a/DataObjects/core.sql b/DataObjects/core.sql deleted file mode 100644 index 39a9cca7..00000000 --- a/DataObjects/core.sql +++ /dev/null @@ -1,49 +0,0 @@ - --- // core comapy types - use core enums (Company Type) -DROP TABLE core_company_type; - - -CREATE TABLE core_event_audit ( - id int(11) NOT NULL AUTO_INCREMENT, - PRIMARY KEY (id) -); - -ALTER TABLE core_event_audit ADD COLUMN event_id int(11) NOT NULL DEFAULT 0; -ALTER TABLE core_event_audit ADD COLUMN name varchar(128) NOT NULL DEFAULT ''; -ALTER TABLE core_event_audit ADD COLUMN old_audit_id int(11) NOT NULL DEFAULT 0; -ALTER TABLE core_event_audit ADD COLUMN newvalue BLOB NOT NULL DEFAULT ''; -ALTER TABLE core_event_audit ADD INDEX lookup(event_id, name, old_audit_id); - --- BC name.. -RENAME TABLE Group_Members TO group_members; - -CREATE TABLE group_members ( - id int(11) NOT NULL AUTO_INCREMENT, - PRIMARY KEY (id) -); -ALTER TABLE group_members ADD COLUMN group_id int(11) default NULL; -ALTER TABLE group_members ADD COLUMN user_id int(11) NOT NULL default 0; - - - - - - - --- we duplicate office_id and company_id here... --- not sure if we should keep doing that in the new design... --- we should improve our links code to handle this.. - - - ---// old core image type - merged into enum. -DROP TABLE core_image_type; - - - - - - - --- ---------------------------- -