sql/core_event_audit.sql

DataObjects/core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 39a9cca..dceb2c9 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -2,32 +2,6 @@
 -- // 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...

diff --git a/sql/core_event_audit.sql b/sql/core_event_audit.sql
index e69de29..6c14a87 100644 (file)
--- a/sql/core_event_audit.sql
+++ b/sql/core_event_audit.sql
@@ -0,0 +1,16 @@
+ 
+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);
+
+
+
+
+