X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=a0047eba7a2fa5aa590b506eb6e227b2105c106e;hb=c14fed651c0fb9a87e4abb3bb8af83871baa899a;hp=39a9cca75468a61a94bf31f46c51587dbfc3a4fe;hpb=b06ebd333bb0a222bdd8da03c6423bb709b513b1;p=Pman.Core

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 39a9cca7..a0047eba 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -1,43 +1,15 @@
 
--- // 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;
-
- 
 
+-- file is not really used any more..
 
 
+-- // core comapy types - use core enums (Company Type)
+DROP TABLE IF EXISTS core_company_type;
 
-
--- 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;
+ 
+-- // old core image type - merged into enum.
+DROP TABLE IF EXISTS core_image_type;