From 374feb9abd0929769f17b6e1049abaf15f0d1c9d Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 9 Jul 2012 13:20:28 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 754065cb..247452ca 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -66,10 +66,10 @@ ALTER TABLE Events ADD COLUMN person_table varchar(64) default NULL; ALTER TABLE Events ADD COLUMN remarks text ; -#very old code.. +--#very old code.. ALTER TABLE Events CHANGE COLUMN EventID id INT(11) AUTO_INCREMENT NOT NULL; -# this are for pre-postgres support code.. +--# this are for pre-postgres support code.. ALTER TABLE Events CHANGE COLUMN User person_name VARCHAR(128); ALTER TABLE Events RENAME COLUMN User TO person_name; ALTER TABLE Events CHANGE COLUMN Date event_when DATETIME ; @@ -85,6 +85,7 @@ ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_ ALTER TABLE Events ADD INDEX lookuppt ( person_table); +--# speeding up lookups. ALTER TABLE Events ADD INDEX lookup_when( person_id, event_id ); -- 2.39.2