TysuB9U9

1DROP TABLE IF EXISTS `offensive_subscriptions`;
2CREATE TABLE `offensive_subscriptions` (
3  `id` int(11) NOT NULL auto_increment,
4  `userid` int(11) NOT NULL default '0',
5  `fileid` int(11) NOT NULL default '0',
6  PRIMARY KEY  (`id`),
7  KEY `userid` (`userid`,`fileid`),
8  KEY `fileid_index___added_by_dreamhost` (`fileid`)
9) ENGINE=MyISAM AUTO_INCREMENT=1686421 DEFAULT CHARSET=latin1;
10DROP TABLE IF EXISTS `offensive_bookmarks`;
11CREATE TABLE `offensive_bookmarks` (
12  `id` int(11) NOT NULL auto_increment,
13  `userid` int(11) NOT NULL default '0',
14  `fileid` int(11) NOT NULL default '0',
15  `type` enum('auto','manual') NOT NULL default 'auto',
16  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
17  `commentid` int(11) default NULL,
18  PRIMARY KEY  (`id`),
19  KEY `userid` (`userid`,`fileid`),
20  KEY `fileid` (`fileid`),
21  KEY `commentid` (`commentid`),
22  KEY `userid_fileid` (`userid`,`fileid`)
23) ENGINE=MyISAM AUTO_INCREMENT=2037752888 DEFAULT CHARSET=latin1;
24INSERT INTO offensive_subscriptions(userid, fileid) VALUES(2 , 221960);
25INSERT INTO offensive_subscriptions(userid, fileid) VALUES(2 , 221960);
26INSERT INTO offensive_subscriptions(userid, fileid) VALUES(2 , 221960);
27INSERT INTO offensive_bookmarks(userid, fileid, commentid) VALUES( 2, 221960, 5908962);
28INSERT INTO offensive_bookmarks(userid, fileid, commentid) VALUES( 2, 221960, 5908963);
29INSERT INTO offensive_bookmarks(userid, fileid, commentid) VALUES( 2, 221960, 5908964);
30SELECT * FROM offensive_bookmarks;
31SELECT * FROM offensive_subscriptions;