projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
4060657
)
DataObjects/core.sql
author
Alan Knowles
<alan@akbkhome.com>
Mon, 14 Mar 2011 10:45:21 +0000
(18:45 +0800)
committer
Alan Knowles
<alan@akbkhome.com>
Mon, 14 Mar 2011 10:45:21 +0000
(18:45 +0800)
DataObjects/core.sql
patch
|
blob
|
history
diff --git
a/DataObjects/core.sql
b/DataObjects/core.sql
index
5074144
..
c0b73b4
100644
(file)
--- a/
DataObjects/core.sql
+++ b/
DataObjects/core.sql
@@
-302,16
+302,15
@@
CREATE TABLE `core_watch` (
ALTER TABLE core_watch ADD INDEX qlookup (`ontable`,`onid`,`user_id`,`event`,`medium`);
ALTER TABLE core_watch ADD INDEX qlookup (`ontable`,`onid`,`user_id`,`event`,`medium`);
-
-ALTER TABLE core_watch change change column user_id person_id int(11);
-ALTER TABLE core_watch change alter column onid int(11);
+
# - used by email / tracker to handle alises
CREATE TABLE `core_person_aliases` (
# - used by email / tracker to handle alises
CREATE TABLE `core_person_aliases` (
-
+ `id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` varchar(128) DEFAULT NULL,
`alias` varchar(254) NOT NULL,
PRIMARY KEY (`alias`)
`person_id` varchar(128) DEFAULT NULL,
`alias` varchar(254) NOT NULL,
PRIMARY KEY (`alias`)
-) ;
\ No newline at end of file
+) ;
+ALTER TABLE core_watch ADD INDEX qlookup (`alias`);