2 CREATE TABLE core_event_audit (
3 id int(11) NOT NULL AUTO_INCREMENT,
7 ALTER TABLE core_event_audit ADD COLUMN event_id int(11) NOT NULL DEFAULT 0;
8 ALTER TABLE core_event_audit ADD COLUMN name varchar(128) NOT NULL DEFAULT '';
9 ALTER TABLE core_event_audit ADD COLUMN old_audit_id int(11) NOT NULL DEFAULT 0;
10 ALTER TABLE core_event_audit ADD COLUMN newvalue BLOB NOT NULL DEFAULT '';
11 ALTER TABLE core_event_audit ADD INDEX lookup(event_id, name, old_audit_id);