· 8 years ago · Jun 14, 2018, 12:18 PM
1-- Структура таблицы `Authme`
2--
3
4CREATE TABLE IF NOT EXISTS `Authme` (
5`id` int(11) NOT NULL,
6 `username` varchar(50) CHARACTER SET latin1 NOT NULL,
7 `realname` varchar(255) NOT NULL,
8 `password` varchar(255) CHARACTER SET latin1 NOT NULL,
9 `ip` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
10 `lastlogin` bigint(20) DEFAULT NULL,
11 `x` double NOT NULL DEFAULT '0',
12 `y` double NOT NULL DEFAULT '0',
13 `z` double NOT NULL DEFAULT '0',
14 `Spawn` varchar(255) NOT NULL DEFAULT 'world',
15 `regdate` bigint(20) NOT NULL DEFAULT '0',
16 `regip` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
17 `yaw` float DEFAULT NULL,
18 `pitch` float DEFAULT NULL,
19 `email` varchar(255) DEFAULT NULL,
20 `isLogged` smallint(6) NOT NULL DEFAULT '0',
21 `hasSession` smallint(6) NOT NULL DEFAULT '0'
22) ENGINE=InnoDB AUTO_INCREMENT=3170772 DEFAULT CHARSET=utf8;