EnjKSvXH

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-07-23 05:42:07
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) unsigned 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=utf8;
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=utf8;
50
51-- ----------------------------
52-- Records of Applications
53-- ----------------------------
54INSERT INTO `Applications` VALUES ('WoW', 'xx', 'xx', '23178');
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=utf8;
64
65-- ----------------------------
66-- Records of BnetVersions
67-- ----------------------------
68INSERT INTO `BnetVersions` VALUES ('Battle.net Game Service SDK v1.6.4 \\\"5cf152fa90\\\"/92 (Dec  5 2016 13:50:37)');
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=utf8;
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  `Population` int(11) NOT NULL,
105  PRIMARY KEY (`Id`)
106) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
107
108-- ----------------------------
109-- Records of Realms
110-- ----------------------------
111INSERT INTO `Realms` VALUES ('1', 'Arctium Emulation', '4', '1', '1', '1', '1', '0', '0');
112
113-- ----------------------------
114-- Table structure for RealmVersions
115-- ----------------------------
116DROP TABLE IF EXISTS `RealmVersions`;
117CREATE TABLE `RealmVersions` (
118  `Id` int(11) unsigned NOT NULL,
119  `Major` int(11) NOT NULL,
120  `Minor` int(11) NOT NULL,
121  `Revision` int(11) NOT NULL,
122  `Build` int(11) NOT NULL,
123  UNIQUE KEY `Id` (`Id`,`Build`),
124  FOREIGN KEY (`Id`) REFERENCES `Realms` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
125) ENGINE=InnoDB DEFAULT CHARSET=utf8;
126
127-- ----------------------------
128-- Records of RealmVersions
129-- ----------------------------
130INSERT INTO `RealmVersions` VALUES ('1', '7', '1', '5', '23178');
131SET FOREIGN_KEY_CHECKS=1;