From 049a121f006835c17657669f7e6ba221a71e0a05 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 7 Mar 2018 17:12:18 +0800 Subject: [PATCH] sql/core_event_audit_archive.sql --- sql/core_event_audit_archive.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/core_event_audit_archive.sql diff --git a/sql/core_event_audit_archive.sql b/sql/core_event_audit_archive.sql new file mode 100644 index 00000000..789aed5c --- /dev/null +++ b/sql/core_event_audit_archive.sql @@ -0,0 +1,16 @@ + +CREATE TABLE core_event_audit_archive ( + id int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (id) +); + +ALTER TABLE core_event_audit_archive ADD COLUMN event_id int(11) NOT NULL DEFAULT 0; +ALTER TABLE core_event_audit_archive ADD COLUMN name varchar(128) NOT NULL DEFAULT ''; +ALTER TABLE core_event_audit_archive ADD COLUMN old_audit_id int(11) NOT NULL DEFAULT 0; +ALTER TABLE core_event_audit_archive ADD COLUMN newvalue BLOB NOT NULL; +ALTER TABLE core_event_audit_archive ADD INDEX lookup(event_id, name, old_audit_id); + + + + + -- 2.39.2