2ja7vQPc

1DROP TABLE IF EXISTS `sites`;
2CREATE TABLE `sites` (
3  `sid` int(8) NOT NULL AUTO_INCREMENT,
4  `sname` varchar(32) NOT NULL,
5  `location` varchar(20) NOT NULL DEFAULT 'NA',
6  `realLocation` varchar(2) NOT NULL DEFAULT 'XX',
7  `description` text NOT NULL,
8  `homepage` varchar(150) NOT NULL,
9  `addedby` int(12) NOT NULL,
10  `addedbyip` varchar(32) NOT NULL,
11  `addeddate` int(32) NOT NULL,
12  `status` int(11) NOT NULL DEFAULT '0',
13  `banend` char(10) NOT NULL DEFAULT '',
14  `isXpos` varchar(10) NOT NULL DEFAULT '0',
15  `isXposEnd` int(32) NOT NULL,
16  `isFeatured` int(11) NOT NULL DEFAULT '0',
17  `isFeaturedTime` int(32) NOT NULL DEFAULT '0',
18  `payment_status` int(1) NOT NULL DEFAULT '0',
19  `payment_end_date` int(32) NOT NULL DEFAULT '0',
20  `payment_br_color` varchar(10) NOT NULL DEFAULT 'silver',
21  `payment_banner` varchar(150) NOT NULL DEFAULT '0',
22  `payment_desc` text NOT NULL,
23  `game` varchar(32) NOT NULL,
24  `votes` int(8) NOT NULL DEFAULT '0',
25  `outclicks` int(10) NOT NULL DEFAULT '0',
26  `rank_date` int(32) NOT NULL,
27  `check_date` int(32) NOT NULL,
28  `admin_notes` text NOT NULL,
29  `server_notes` text NOT NULL,
30  `apikey` varchar(32) NOT NULL,
31  PRIMARY KEY (`sid`),
32  KEY `isFeatured` (`isFeatured`),
33  KEY `game` (`game`),
34  KEY `isXpos` (`isXpos`)
35) ENGINE=InnoDB AUTO_INCREMENT=101178 DEFAULT CHARSET=latin1;
36LOCK TABLES `sites` WRITE;