daily pastebin goal
4%
SHARE
TWEET

Untitled

a guest Feb 20th, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. alter table torrents add `LastCommentID` int(10) NOT NULL DEFAULT '0';
  2.  
  3. alter table users_info add `CommentsCatchupTime` datetime DEFAULT NULL;
  4.  
  5. CREATE 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.  
  11. CREATE 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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top