From f7e5b01d6ccca0fb378c96cf67ef7d7c3092f5bb Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 30 Mar 2011 14:15:35 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index ea7eaa08..a7fd793a 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -312,6 +312,18 @@ CREATE TABLE `core_watch` ( ) ; ALTER TABLE core_watch ADD INDEX qlookup (`ontable`,`onid`,`user_id`,`event`,`medium`); +CREATE TABLE core_notify ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `act_when` datetime NOT NULL, + `onid` int(11) NOT NULL, + `ontable` int(11) NOT NULL, + `person_id` int(11) NOT NULL, + `msgid` varchar(128) NOT NULL, + PRIMARY KEY (`id`), + INDEX `lookup`(`act_when`, `msgid`) +); + + -- 2.39.2