ZZQzRNVE

1alter table torrents add `LastCommentID` int(10) NOT NULL DEFAULT '0';
2
3alter table users_info add `CommentsCatchupTime` datetime DEFAULT NULL;
4
5CREATE TABLE IF NOT EXISTS `users_comments_subscriptions` (
6  `UserID` int(10) NOT NULL,
7  `GroupID` int(10) NOT NULL,
8  PRIMARY KEY (`UserID`,`GroupID`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
10
11CREATE TABLE IF NOT EXISTS `torrents_last_read_comments` (
12  `UserID` int(10) NOT NULL,
13  `GroupID` int(10) NOT NULL,
14  `CommentID` int(10) NOT NULL,
15  PRIMARY KEY (`UserID`,`GroupID`),
16  KEY `GroupID` (`GroupID`),
17  KEY `UserID` (`UserID`),
18) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;