From 4060657fd666d98475190af4d6a6c76606fd0be9 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 14 Mar 2011 18:45:01 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 11 ++++++++--- 1 file changed, 8 insertions(+), 3 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 966e6e92..50741441 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -290,14 +290,18 @@ ALTER TABLE translations ADD INDEX qlookup (module, tfile, tlang, tkey); # - used to trigger emails about changes to items being watched. CREATE TABLE `core_watch` ( + `id` int(11) NOT NULL AUTO_INCREMENT, `ontable` varchar(128) NOT NULL, `onid` int(11) NOT NULL, `person_id` int(11) NOT NULL, `event` varchar(128) NOT NULL, `medium` varchar(128) NOT NULL, `active` int(11) NOT NULL DEFAULT '1', - PRIMARY KEY (`ontable`,`onid`,`user_id`,`event`,`medium`) + PRIMARY KEY (id) ) ; +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); @@ -305,8 +309,9 @@ ALTER TABLE core_watch change alter column onid int(11); # - used by email / tracker to handle alises CREATE TABLE `core_person_aliases` ( - `person_id` varchar(128) DEFAULT NULL, - `alias` varchar(128) NOT NULL, + + `person_id` varchar(128) DEFAULT NULL, + `alias` varchar(254) NOT NULL, PRIMARY KEY (`alias`) ) ; \ No newline at end of file -- 2.39.2