zNjkLpm3

1
2SET FOREIGN_KEY_CHECKS=0;
3-- ----------------------------
4-- Table structure for accounts
5-- ----------------------------
6DROP TABLE IF EXISTS `accounts`;
7CREATE TABLE `accounts` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `username` text NOT NULL,
10  `password` text NOT NULL,
11  `email` text NOT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
14
15-- ----------------------------
16-- Records of accounts
17-- ----------------------------
18INSERT INTO `accounts` VALUES ('1', 'Dv', 'Pa', 'p');
19INSERT INTO `accounts` VALUES ('2', 'Dv', 'Pz', 'p');
20
21-- ----------------------------
22-- Table structure for characters
23-- ----------------------------
24DROP TABLE IF EXISTS `characters`;
25CREATE TABLE `characters` (
26  `account` int(11) NOT NULL,
27  `guid` int(11) NOT NULL AUTO_INCREMENT,
28  `name` text NOT NULL,
29  `race` smallint(6) NOT NULL,
30  `current_health` int(11) NOT NULL,
31  `max_health` int(11) NOT NULL,
32  `current_mana` int(11) NOT NULL,
33  `max_mana` int(11) NOT NULL,
34  `level` int(11) NOT NULL,
35  PRIMARY KEY (`guid`)
36) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
37
38-- ----------------------------
39-- Records of characters
40-- ----------------------------
41INSERT INTO `characters` VALUES ('1', '1', 'Dvlpr', '0', '100', '150', '100', '150', '1');