rpLiKhd9

1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for `account_data`
5-- ----------------------------
6DROP TABLE IF EXISTS `account_data`;
7CREATE TABLE `account_data` (
8  `account_name` varchar(32) NOT NULL,
9  `valueName` varchar(32) NOT NULL,
10  `valueData` varchar(250) DEFAULT NULL,
11  PRIMARY KEY (`account_name`,`valueName`)
12) ENGINE=MyISAM DEFAULT CHARSET=utf8;
13
14-- ----------------------------
15-- Table structure for `accounts`
16-- ----------------------------
17DROP TABLE IF EXISTS `accounts`;
18CREATE TABLE `accounts` (
19  `login` varchar(45) NOT NULL DEFAULT '',
20  `password` varchar(45) DEFAULT NULL,
21  `lastactive` decimal(20,0) DEFAULT NULL,
22  `accessLevel` int(11) NOT NULL DEFAULT '0',
23  `lastIP` varchar(20) DEFAULT NULL,
24  `lastServerId` int(11) NOT NULL DEFAULT '1',
25  `allowed_ip` varchar(20) NOT NULL DEFAULT '*',
26  `allowed_hwid` varchar(250) NOT NULL DEFAULT '*',
27  `l2answer` varchar(100) NOT NULL DEFAULT '',
28  `l2question` varchar(100) NOT NULL DEFAULT '',
29  `l2email` varchar(100) NOT NULL DEFAULT 'null@null',
30  `l2money` double(10,2) NOT NULL DEFAULT '0.00',
31  PRIMARY KEY (`login`)
32) ENGINE=MyISAM DEFAULT CHARSET=utf8;