DataObjects/core_functions.sql
DataObjects/core.sql
UpdateDatabase.php
ALTER TABLE Events ADD INDEX lookuppt ( person_table);
--# speeding up lookups.
ALTER TABLE Events ADD INDEX lookuppt ( person_table);
--# speeding up lookups.
-ALTER TABLE Events ADD INDEX lookup_when( person_id, event_id );
+ALTER TABLE Events ADD INDEX lookup_when( person_id, event_when );
ALTER TABLE Events add index lookup_event_when (event_when);
ALTER TABLE Events add index lookup_action (action);
ALTER TABLE Events add index lookup_event_when (event_when);
ALTER TABLE Events add index lookup_action (action);