nhY46Bzy

1
2
3CREATE TABLE IF NOT EXISTS `authme` (
4`id` mediumint(8) unsigned NOT NULL,
5  `username` varchar(255) NOT NULL,
6  `realname` varchar(255) NOT NULL,
7  `password` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
8  `ip` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
9  `lastlogin` bigint(20) DEFAULT NULL,
10  `x` double NOT NULL DEFAULT '0',
11  `y` double NOT NULL DEFAULT '0',
12  `z` double NOT NULL DEFAULT '0',
13  `world` varchar(255) NOT NULL DEFAULT 'world',
14  `regdate` bigint(20) NOT NULL DEFAULT '0',
15  `regip` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
16  `yaw` float DEFAULT NULL,
17  `pitch` float DEFAULT NULL,
18  `email` varchar(255) DEFAULT NULL,
19  `isLogged` smallint(6) NOT NULL DEFAULT '0',
20  `hasSession` smallint(6) NOT NULL DEFAULT '0'
21) ENGINE=InnoDB AUTO_INCREMENT=12682 DEFAULT CHARSET=utf8;
22
23--
24-- Дамп данных таблицы `authme`
25--
26
27INSERT INTO `authme` (`id`, `username`, `realname`, `password`, `ip`, `lastlogin`, `x`, `y`, `z`, `world`, `regdate`, `regip`, `yaw`, `pitch`, `email`, `isLogged`, `hasSession`) VALUES