· 9 years ago · Jan 19, 2017, 08:22 AM
1CREATE TABLE IF NOT EXISTS `accounts` (
2 `account_name` varchar(32) NOT NULL,
3 `password` varchar(255) NOT NULL,
4 `last_access` int(11) NOT NULL DEFAULT '0',
5 `access_level` int(11) NOT NULL DEFAULT '0',
6 `last_ip` varchar(15) DEFAULT NULL,
7 `last_server` int(11) NOT NULL DEFAULT '0',
8 `bonus` double NOT NULL DEFAULT '1',
9 `bonus_expire` int(11) NOT NULL DEFAULT '0',
10 `ban_expire` int(11) NOT NULL DEFAULT '0',
11 `allow_ip` varchar(255) NOT NULL DEFAULT '',
12 `points` int(11) NOT NULL default '0',
13 PRIMARY KEY (`login`),
14 KEY `last_ip` (`last_ip`)
15) DEFAULT CHARSET=utf8;