· 8 years ago · Jan 05, 2018, 06:54 AM
1CREATE TABLE IF NOT EXISTS `torrents_lock` (
2 `torrent_id` int(18) NOT NULL,
3 `tracker_id` int(8) NOT NULL,
4 `serv` varchar(64) NOT NULL,
5 PRIMARY KEY (`torrent_id`,`tracker_id`)
6) ENGINE=MEMORY DEFAULT CHARSET=latin1;
7
8CREATE UNIQUE INDEX locks_torrent_tracker ON torrents_lock(torrent_id, tracker_id);