projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
9174573
)
DataObjects/core.sql
author
Alan Knowles
<alan@roojs.com>
Mon, 9 Jul 2012 05:20:28 +0000
(13:20 +0800)
committer
Alan Knowles
<alan@roojs.com>
Mon, 9 Jul 2012 05:20:28 +0000
(13:20 +0800)
DataObjects/core.sql
patch
|
blob
|
history
diff --git
a/DataObjects/core.sql
b/DataObjects/core.sql
index
754065c
..
247452c
100644
(file)
--- 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 ;
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;
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 ;
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);
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_id );