/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50051
Source Host           : localhost:3306
Source Database       : accounts

Target Server Type    : MYSQL
Target Server Version : 50051
File Encoding         : 65001

Date: 2018-04-21 02:08:41
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `accounts`
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `ID` bigint(255) NOT NULL auto_increment,
  `Username` varchar(16) NOT NULL default '',
  `Password` varchar(16) NOT NULL default '',
  `Email` varchar(100) default '',
  `Question` varchar(100) default NULL,
  `answer` varchar(30) default NULL,
  `Country` varchar(110) default NULL,
  `City` varchar(100) default NULL,
  `IP` varchar(100) default NULL,
  `phone` varchar(15) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `f43f43` (`ID`),
  KEY `ggg` (`Username`)
) ENGINE=MyISAM AUTO_INCREMENT=1016519 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of accounts
-- ----------------------------

-- ----------------------------
-- Table structure for `arena`
-- ----------------------------
DROP TABLE IF EXISTS `arena`;
CREATE TABLE `arena` (
  `EntityID` int(10) unsigned NOT NULL default '0',
  `EntityName` char(45) NOT NULL default '',
  `CurrentHonor` int(10) unsigned default '0',
  `Level` int(10) unsigned default '0',
  `Class` int(10) unsigned default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of arena
-- ----------------------------

-- ----------------------------
-- Table structure for `cps_rank`
-- ----------------------------
DROP TABLE IF EXISTS `cps_rank`;
CREATE TABLE `cps_rank` (
  `UID` bigint(16) unsigned default NULL,
  `Name` varchar(32) default NULL,
  `cps` bigint(16) default NULL,
  `Class` bigint(16) default NULL,
  `Level` bigint(16) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cps_rank
-- ----------------------------

-- ----------------------------
-- Table structure for `ctfranks`
-- ----------------------------
DROP TABLE IF EXISTS `ctfranks`;
CREATE TABLE `ctfranks` (
  `UID` bigint(16) default NULL,
  `GuildName` varchar(25) default NULL,
  `GuildLeader` varchar(25) default NULL,
  `CTFPoints` bigint(16) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ctfranks
-- ----------------------------

-- ----------------------------
-- Table structure for `donation_paypal`
-- ----------------------------
DROP TABLE IF EXISTS `donation_paypal`;
CREATE TABLE `donation_paypal` (
  `id_pay` int(5) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `account_name` varchar(60) NOT NULL,
  `pachet_id` varchar(255) NOT NULL,
  `sv_id` varchar(255) NOT NULL,
  `successed` varchar(255) NOT NULL,
  PRIMARY KEY  (`id_pay`)
) ENGINE=MyISAM AUTO_INCREMENT=2139106 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of donation_paypal
-- ----------------------------

-- ----------------------------
-- Table structure for `entities`
-- ----------------------------
DROP TABLE IF EXISTS `entities`;
CREATE TABLE `entities` (
  `UID` bigint(18) unsigned NOT NULL default '0',
  `Name` varchar(16) NOT NULL default '',
  `Class` tinyint(5) unsigned NOT NULL default '10',
  `Level` tinyint(5) unsigned default '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of entities
-- ----------------------------

-- ----------------------------
-- Table structure for `guilds`
-- ----------------------------
DROP TABLE IF EXISTS `guilds`;
CREATE TABLE `guilds` (
  `UID` int(10) unsigned NOT NULL default '0',
  `Name` varchar(45) NOT NULL default '',
  `Wins` bigint(255) unsigned default '0',
  `LeaderName` varchar(45) NOT NULL default '0',
  `WinSuperGW` bigint(16) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of guilds
-- ----------------------------

-- ----------------------------
-- Table structure for `nobility`
-- ----------------------------
DROP TABLE IF EXISTS `nobility`;
CREATE TABLE `nobility` (
  `EntityUID` bigint(255) unsigned NOT NULL default '0',
  `EntityName` varchar(16) NOT NULL default '',
  `Donation` bigint(255) unsigned default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nobility
-- ----------------------------

-- ----------------------------
-- Table structure for `playersonline`
-- ----------------------------
DROP TABLE IF EXISTS `playersonline`;
CREATE TABLE `playersonline` (
  `UID` int(32) unsigned default '0',
  `Online` int(32) unsigned default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of playersonline
-- ----------------------------