· 9 years ago · Nov 09, 2016, 05:50 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4CREATE TABLE IF NOT EXISTS `banned` (
5 `id` int(30) NOT NULL AUTO_INCREMENT,
6 `steamid` varchar(20) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1071 ;
9
10CREATE TABLE IF NOT EXISTS `en_messages` (
11 `id` int(11) NOT NULL AUTO_INCREMENT,
12 `user_name` varchar(30) CHARACTER SET utf8 NOT NULL,
13 `user_avatar` varchar(150) CHARACTER SET utf8 NOT NULL,
14 `user_message` varchar(200) CHARACTER SET utf8 NOT NULL,
15 `ip` varchar(30) CHARACTER SET utf8 NOT NULL,
16 `steamid` varchar(30) CHARACTER SET utf8 NOT NULL,
17 `date` varchar(30) CHARACTER SET utf8 NOT NULL,
18 PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1421 ;
20
21CREATE TABLE IF NOT EXISTS `pl_messages` (
22 `id` int(11) NOT NULL AUTO_INCREMENT,
23 `user_name` varchar(30) CHARACTER SET utf8 NOT NULL,
24 `user_avatar` varchar(150) CHARACTER SET utf8 NOT NULL,
25 `user_message` varchar(200) CHARACTER SET utf8 NOT NULL,
26 `ip` varchar(30) CHARACTER SET utf8 NOT NULL,
27 `steamid` varchar(30) CHARACTER SET utf8 NOT NULL,
28 `date` varchar(30) CHARACTER SET utf8 NOT NULL,
29 PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1000000857 ;
31
32CREATE TABLE IF NOT EXISTS `ru_messages` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `user_name` varchar(30) CHARACTER SET utf8 NOT NULL,
35 `user_avatar` varchar(150) CHARACTER SET utf8 NOT NULL,
36 `user_message` varchar(200) CHARACTER SET utf8 NOT NULL,
37 `ip` varchar(30) CHARACTER SET utf8 NOT NULL,
38 `steamid` varchar(30) CHARACTER SET utf8 NOT NULL,
39 `date` varchar(30) CHARACTER SET utf8 NOT NULL,
40 PRIMARY KEY (`id`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1000003139 ;