Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r15246 -r15252 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15246) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15252) @@ -117,6 +117,7 @@ Description text, `Type` int(11) NOT NULL DEFAULT '0', LastChanged int(10) unsigned DEFAULT NULL, + BindToSystemEvent varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (EventId), KEY `Type` (`Type`), KEY Enabled (Enabled), @@ -139,6 +140,19 @@ KEY l5_PlainTextBody (l5_PlainTextBody(5)) ); +CREATE TABLE EmailEventSubscribers ( + SubscriptionId int(11) NOT NULL AUTO_INCREMENT, + EmailEventId int(11) DEFAULT NULL, + SubscriberEmail varchar(255) NOT NULL DEFAULT '', + UserId int(11) DEFAULT NULL, + CategoryId int(11) DEFAULT NULL, + ItemId int(11) DEFAULT NULL, + ParentItemId int(11) DEFAULT NULL, + SubscribedOn int(11) DEFAULT NULL, + PRIMARY KEY (SubscriptionId), + KEY EmailEventId (EmailEventId) +); + CREATE TABLE IdGenerator ( lastid int(11) default NULL );