KhwJQmj0

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Reneage Server Game
5Source Server Version : 50149
6Source Host           : 46.149.46.174:3306
7Source Database       : reneagegame
8
9Target Server Type    : MYSQL
10Target Server Version : 50149
11File Encoding         : 65001
12
13Date: 2012-01-26 20:26:18
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `account_data`
20-- ----------------------------
21DROP TABLE IF EXISTS `account_data`;
22CREATE TABLE `account_data` (
23  `account_name` varchar(32) NOT NULL,
24  `valueName` varchar(32) NOT NULL,
25  `valueData` varchar(250) DEFAULT NULL,
26  PRIMARY KEY (`account_name`,`valueName`)
27) ENGINE=MyISAM DEFAULT CHARSET=utf8;
28
29-- ----------------------------
30-- Records of account_data
31-- ----------------------------
32INSERT INTO `account_data` VALUES ('01296', 'hwbind', '1059f25716abdc8e2c768a375d8e0fc2');
33
34-- ----------------------------
35-- Table structure for `accounts`
36-- ----------------------------
37DROP TABLE IF EXISTS `accounts`;
38CREATE TABLE `accounts` (
39  `login` varchar(45) NOT NULL DEFAULT '',
40  `password` varchar(45) DEFAULT NULL,
41  `lastactive` decimal(20,0) DEFAULT NULL,
42  `accessLevel` int(11) NOT NULL DEFAULT '0',
43  `lastIP` varchar(20) DEFAULT NULL,
44  `lastServerId` int(11) NOT NULL DEFAULT '1',
45  `allowed_ip` varchar(20) NOT NULL DEFAULT '*',
46  `allowed_hwid` varchar(250) NOT NULL DEFAULT '*',
47  `l2answer` varchar(100) NOT NULL DEFAULT '',
48  `l2question` varchar(100) NOT NULL DEFAULT '',
49  `l2email` varchar(100) NOT NULL DEFAULT 'null@null',
50  `l2money` double(10,2) NOT NULL DEFAULT '0.00',
51  PRIMARY KEY (`login`)
52) ENGINE=MyISAM DEFAULT CHARSET=utf8;
53
54-- ----------------------------
55-- Records of accounts
56-- ----------------------------
57INSERT INTO `accounts` VALUES ('01296', 'uXm57g2yZiMwApZh7hOKJvbJAuY=', '1327592119', '100', '91.223.246.43', '1', '91.223.246.43', '*', '', '', 'prikvik@gmail.com', '0.00');
58INSERT INTO `accounts` VALUES ('bigmmm', '1', '1327521091', '0', '77.232.143.45', '1', '*', '*', '', '', 'stalker-cs@email.ua', '0.00');