From: Alan Knowles <alan@roojs.com>
Date: Wed, 7 Mar 2018 09:12:18 +0000 (+0800)
Subject: sql/core_event_audit_archive.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=049a121f006835c17657669f7e6ba221a71e0a05

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);
+
+
+
+ 
+