From 0370b91039f4ca24edec14b990399898c7ca5ed5 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 3 Jun 2016 16:08:10 +0800 Subject: [PATCH] sql/core_event_audit.sql DataObjects/core.sql --- DataObjects/core.sql | 26 -------------------------- sql/core_event_audit.sql | 16 ++++++++++++++++ 2 files changed, 16 insertions(+), 26 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 39a9cca7..dceb2c91 100644 --- 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 e69de29b..6c14a87f 100644 --- 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); + + + + + -- 2.39.2