· 7 years ago · Feb 21, 2019, 06:16 AM
1CREATE TABLE IF NOT EXISTS `server` (
2 `id` INT(255) NOT NULL AUTO_INCREMENT,
3 `name` varchar(32) NOT NULL,
4 `ip` varchar(32) NOT NULL,
5 `password` varchar(32) NOT NULL,
6 `port` varchar(32) NOT NULL,
7 `loader` varchar(320) NOT NULL,
8 `html` text(32000) NOT NULL,
9 `prem` varchar(32) NOT NULL,
10 `desc` text(50000) NOT NULL,
11 `tags` varchar(50) NOT NULL,
12 `owner` varchar(32) NOT NULL,
13 `site` varchar(255) NOT NULL,
14 `votes` int(255) NOT NULL,
15 `banner` varchar(255) NOT NULL,
16 `rev` varchar(4) NOT NULL,
17 `cat` varchar(100) NOT NULL,
18 PRIMARY KEY (`id`)
19) ENGINE=MyISAM DEFAULT CHARSET=latin1;
20
21CREATE TABLE IF NOT EXISTS `id` (
22 `ID` int(255) NOT NULL,
23 `ip` varchar(255) NOT NULL,
24 `edate` varchar(255) NOT NULL,
25 `Name` varchar(255) NOT NULL
26) ENGINE=MyISAM DEFAULT CHARSET=latin1;