1 CREATE TABLE core_events_archive (
2 id int(11) NOT NULL AUTO_INCREMENT,
3 person_name varchar(128) NOT NULL DEFAULT '',
4 event_when datetime NOT NULL ,
5 action varchar(64) NOT NULL DEFAULT '',
6 ipaddr varchar(16) NOT NULL DEFAULT '',
7 on_id int(11) NOT NULL DEFAULT 0,
8 on_table varchar(64) NOT NULL DEFAULT '',
9 person_id int(11) NOT NULL DEFAULT 0,
10 remarks text NOT NULL,
11 person_table varchar(64) NOT NULL DEFAULT '',
12 dupe_id int(11) NOT NULL DEFAULT '0',
16 ALTER TABLE core_events_archive ADD INDEX lookup (on_id,on_table,person_id,event_when);
18 ALTER TABLE core_events_archive ADD INDEX lookuppt (person_table);
20 ALTER TABLE core_events_archive ADD INDEX lookup_when (person_id,event_when);
22 ALTER TABLE core_events_archive ADD INDEX lookup_action (action);
24 ALTER TABLE core_events_archive ADD INDEX lookup_on_table (on_table);
26 ALTER TABLE core_events_archive ADD INDEX lookup_action_person (action,person_id);
28 ALTER TABLE core_events_archive ADD INDEX lookup_affects (on_table,person_table);
30 ALTER TABLE core_events_archive ADD INDEX lookup_actions (person_id,person_table,action);
32 ALTER TABLE core_events_archive ADD INDEX lookupf (on_id,action,on_table,person_id,event_when);