9jUL2vcL

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : localhost_3306
5Source Server Version : 50051
6Source Host           : localhost:3306
7Source Database       : accounts
8
9Target Server Type    : MYSQL
10Target Server Version : 50051
11File Encoding         : 65001
12
13Date: 2018-04-21 02:08:41
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17-- ----------------------------
18-- Table structure for `accounts`
19-- ----------------------------
20DROP TABLE IF EXISTS `accounts`;
21CREATE TABLE `accounts` (
22  `ID` bigint(255) NOT NULL auto_increment,
23  `Username` varchar(16) NOT NULL default '',
24  `Password` varchar(16) NOT NULL default '',
25  `Email` varchar(100) default '',
26  `Question` varchar(100) default NULL,
27  `answer` varchar(30) default NULL,
28  `Country` varchar(110) default NULL,
29  `City` varchar(100) default NULL,
30  `IP` varchar(100) default NULL,
31  `phone` varchar(15) default NULL,
32  PRIMARY KEY  (`ID`),
33  UNIQUE KEY `f43f43` (`ID`),
34  KEY `ggg` (`Username`)
35) ENGINE=MyISAM AUTO_INCREMENT=1016519 DEFAULT CHARSET=utf8;
36
37-- ----------------------------
38-- Records of accounts
39-- ----------------------------
40
41-- ----------------------------
42-- Table structure for `arena`
43-- ----------------------------
44DROP TABLE IF EXISTS `arena`;
45CREATE TABLE `arena` (
46  `EntityID` int(10) unsigned NOT NULL default '0',
47  `EntityName` char(45) NOT NULL default '',
48  `CurrentHonor` int(10) unsigned default '0',
49  `Level` int(10) unsigned default '0',
50  `Class` int(10) unsigned default '0'
51) ENGINE=MyISAM DEFAULT CHARSET=utf8;
52
53-- ----------------------------
54-- Records of arena
55-- ----------------------------
56
57-- ----------------------------
58-- Table structure for `cps_rank`
59-- ----------------------------
60DROP TABLE IF EXISTS `cps_rank`;
61CREATE TABLE `cps_rank` (
62  `UID` bigint(16) unsigned default NULL,
63  `Name` varchar(32) default NULL,
64  `cps` bigint(16) default NULL,
65  `Class` bigint(16) default NULL,
66  `Level` bigint(16) default NULL
67) ENGINE=MyISAM DEFAULT CHARSET=utf8;
68
69-- ----------------------------
70-- Records of cps_rank
71-- ----------------------------
72
73-- ----------------------------
74-- Table structure for `ctfranks`
75-- ----------------------------
76DROP TABLE IF EXISTS `ctfranks`;
77CREATE TABLE `ctfranks` (
78  `UID` bigint(16) default NULL,
79  `GuildName` varchar(25) default NULL,
80  `GuildLeader` varchar(25) default NULL,
81  `CTFPoints` bigint(16) default NULL
82) ENGINE=MyISAM DEFAULT CHARSET=utf8;
83
84-- ----------------------------
85-- Records of ctfranks
86-- ----------------------------
87
88-- ----------------------------
89-- Table structure for `donation_paypal`
90-- ----------------------------
91DROP TABLE IF EXISTS `donation_paypal`;
92CREATE TABLE `donation_paypal` (
93  `id_pay` int(5) NOT NULL auto_increment,
94  `email` varchar(255) NOT NULL,
95  `time` datetime NOT NULL,
96  `account_name` varchar(60) NOT NULL,
97  `pachet_id` varchar(255) NOT NULL,
98  `sv_id` varchar(255) NOT NULL,
99  `successed` varchar(255) NOT NULL,
100  PRIMARY KEY  (`id_pay`)
101) ENGINE=MyISAM AUTO_INCREMENT=2139106 DEFAULT CHARSET=latin1;
102
103-- ----------------------------
104-- Records of donation_paypal
105-- ----------------------------
106
107-- ----------------------------
108-- Table structure for `entities`
109-- ----------------------------
110DROP TABLE IF EXISTS `entities`;
111CREATE TABLE `entities` (
112  `UID` bigint(18) unsigned NOT NULL default '0',
113  `Name` varchar(16) NOT NULL default '',
114  `Class` tinyint(5) unsigned NOT NULL default '10',
115  `Level` tinyint(5) unsigned default '1'
116) ENGINE=MyISAM DEFAULT CHARSET=utf8;
117
118-- ----------------------------
119-- Records of entities
120-- ----------------------------
121
122-- ----------------------------
123-- Table structure for `guilds`
124-- ----------------------------
125DROP TABLE IF EXISTS `guilds`;
126CREATE TABLE `guilds` (
127  `UID` int(10) unsigned NOT NULL default '0',
128  `Name` varchar(45) NOT NULL default '',
129  `Wins` bigint(255) unsigned default '0',
130  `LeaderName` varchar(45) NOT NULL default '0',
131  `WinSuperGW` bigint(16) default NULL
132) ENGINE=MyISAM DEFAULT CHARSET=utf8;
133
134-- ----------------------------
135-- Records of guilds
136-- ----------------------------
137
138-- ----------------------------
139-- Table structure for `nobility`
140-- ----------------------------
141DROP TABLE IF EXISTS `nobility`;
142CREATE TABLE `nobility` (
143  `EntityUID` bigint(255) unsigned NOT NULL default '0',
144  `EntityName` varchar(16) NOT NULL default '',
145  `Donation` bigint(255) unsigned default '0'
146) ENGINE=MyISAM DEFAULT CHARSET=utf8;
147
148-- ----------------------------
149-- Records of nobility
150-- ----------------------------
151
152-- ----------------------------
153-- Table structure for `playersonline`
154-- ----------------------------
155DROP TABLE IF EXISTS `playersonline`;
156CREATE TABLE `playersonline` (
157  `UID` int(32) unsigned default '0',
158  `Online` int(32) unsigned default '0'
159) ENGINE=MyISAM DEFAULT CHARSET=utf8;
160
161-- ----------------------------
162-- Records of playersonline
163-- ----------------------------