· 7 years ago · Sep 12, 2018, 03:04 PM
1CREATE TABLE IF NOT EXISTS `admin` (
2 `Name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
3 `level` int(2) NOT NULL,
4 `password` varchar(32) NOT NULL DEFAULT 'qwerty',
5 `LastCon` varchar(32) NOT NULL,
6 `Postavil` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
7 `Data` varchar(32) NOT NULL,
8 `kick` int(6) NOT NULL DEFAULT '0',
9 `ban` int(6) NOT NULL DEFAULT '0',
10 `mute` int(6) NOT NULL DEFAULT '0',
11 `pm` int(6) NOT NULL DEFAULT '0',
12 `warn` int(6) NOT NULL DEFAULT '0',
13 `jail` int(6) NOT NULL DEFAULT '0',
14 `kickset` int(2) NOT NULL,
15 `banedset` int(2) NOT NULL,
16 `muteset` int(2) NOT NULL,
17 `pmset` int(2) NOT NULL,
18 `warnset` int(2) NOT NULL,
19 `jailset` int(2) NOT NULL,
20 `admset` int(2) NOT NULL,
21 `CMDaccess` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '00000000000000000000000000000000'
22) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23
24--
25-- Дамп данных таблицы `admin`
26--
27
28INSERT INTO `admin` (`Name`, `level`, `password`, `LastCon`, `Postavil`, `Data`, `kick`, `ban`, `mute`, `pm`, `warn`, `jail`, `kickset`, `banedset`, `muteset`, `pmset`, `warnset`, `jailset`, `admset`, `CMDaccess`) VALUES
29('Andy_White', 14, 'qweqweqwe123', '25/9/2017', 'Andy_White', '07.07.2017', 2, 2, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1111001001');