· 9 years ago · Dec 02, 2016, 05:04 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : arctium
5Source Server Version : 50549
6Source Host : localhost:3306
7Source Database : AuthDB
8
9Target Server Type : MYSQL
10Target Server Version : 50549
11File Encoding : 65001
12
13Date: 2016-06-05 03:10:50
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for Accounts
20-- ----------------------------
21DROP TABLE IF EXISTS `Accounts`;
22CREATE TABLE `Accounts` (
23 `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
24 `Email` varchar(320) NOT NULL,
25 `Tag` varchar(50) DEFAULT '',
26 `Region` tinyint(4) NOT NULL,
27 `Locale` varchar(4) DEFAULT NULL,
28 `PasswordVerifier` varchar(256) DEFAULT NULL,
29 `Salt` varchar(64) DEFAULT NULL,
30 `IP` varchar(15) DEFAULT NULL,
31 `LoginFailures` int(11) NOT NULL DEFAULT '0',
32 PRIMARY KEY (`Id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35-- ----------------------------
36-- Records of Accounts
37-- ----------------------------
38
39-- ----------------------------
40-- Table structure for Applications
41-- ----------------------------
42DROP TABLE IF EXISTS `Applications`;
43CREATE TABLE `Applications` (
44 `Program` varchar(4) NOT NULL,
45 `Platform` varchar(4) NOT NULL,
46 `Locale` varchar(4) NOT NULL,
47 `Version` int(11) NOT NULL,
48 UNIQUE KEY `Program` (`Program`,`Platform`,`Locale`,`Version`) USING BTREE
49) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50
51-- ----------------------------
52-- Records of Applications
53-- ----------------------------
54INSERT INTO `Applications` VALUES ('WoW', 'xx', 'xx', '21863');
55
56-- ----------------------------
57-- Table structure for BnetVersions
58-- ----------------------------
59DROP TABLE IF EXISTS `BnetVersions`;
60CREATE TABLE `BnetVersions` (
61 `Version` varchar(255) NOT NULL,
62 PRIMARY KEY (`Version`)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1;
64
65-- ----------------------------
66-- Records of BnetVersions
67-- ----------------------------
68INSERT INTO `BnetVersions` VALUES ('Battle.net Game Service SDK v1.4.6 \\\"39015650a0\\\"/22 (Jun 2 2016 19:05:52)');
69
70-- ----------------------------
71-- Table structure for GameAccounts
72-- ----------------------------
73DROP TABLE IF EXISTS `GameAccounts`;
74CREATE TABLE `GameAccounts` (
75 `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
76 `AccountId` int(11) unsigned NOT NULL,
77 `Game` varchar(10) DEFAULT NULL,
78 `Index` tinyint(4) unsigned NOT NULL,
79 `Region` tinyint(4) unsigned NOT NULL,
80 `ExpansionLevel` tinyint(4) NOT NULL,
81 `Online` tinyint(1) DEFAULT '0',
82 `JoinTicket` varchar(64) DEFAULT '',
83 PRIMARY KEY (`Id`),
84 KEY `AccountId` (`AccountId`),
85 FOREIGN KEY (`AccountId`) REFERENCES `Accounts` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88-- ----------------------------
89-- Records of GameAccounts
90-- ----------------------------
91
92-- ----------------------------
93-- Table structure for Realms
94-- ----------------------------
95DROP TABLE IF EXISTS `Realms`;
96CREATE TABLE `Realms` (
97 `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
98 `Name` varchar(255) NOT NULL,
99 `Flags` int(11) NOT NULL DEFAULT '4',
100 `Type` int(11) NOT NULL,
101 `Category` int(11) NOT NULL DEFAULT '1',
102 `Timezone` int(11) NOT NULL DEFAULT '1',
103 `Language` int(11) NOT NULL DEFAULT '1',
104 `State` int(11) NOT NULL,
105 `Population` int(11) NOT NULL,
106 PRIMARY KEY (`Id`)
107) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
108
109-- ----------------------------
110-- Records of Realms
111-- ----------------------------
112INSERT INTO `Realms` VALUES ('1', 'Arctium Emulation', '4', '1', '1', '1', '1', '0', '0');
113
114-- ----------------------------
115-- Table structure for RealmVersions
116-- ----------------------------
117DROP TABLE IF EXISTS `RealmVersions`;
118CREATE TABLE `RealmVersions` (
119 `Id` int(11) unsigned NOT NULL,
120 `Major` int(11) NOT NULL,
121 `Minor` int(11) NOT NULL,
122 `Revision` int(11) NOT NULL,
123 `Build` int(11) NOT NULL,
124 UNIQUE KEY `Id` (`Id`,`Build`),
125 FOREIGN KEY (`Id`) REFERENCES `Realms` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
126) ENGINE=InnoDB DEFAULT CHARSET=latin1;
127
128-- ----------------------------
129-- Records of RealmVersions
130-- ----------------------------
131INSERT INTO `RealmVersions` VALUES ('1', '7', '0', '3', '21863');