18ydTFCL

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : local
5Source Server Version : 50505
6Source Host           : localhost:3306
7Source Database       : factions
8
9Target Server Type    : MYSQL
10Target Server Version : 50505
11File Encoding         : 65001
12
13Date: 2019-07-13 22:11:25
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for allies_info
20-- ----------------------------
21DROP TABLE IF EXISTS `allies_info`;
22CREATE TABLE `allies_info` (
23  `faction_id` int(11) NOT NULL,
24  `ally_id` int(11) NOT NULL,
25  PRIMARY KEY (`faction_id`)
26) ENGINE=InnoDB DEFAULT CHARSET=latin1;
27
28-- ----------------------------
29-- Table structure for enemies_info
30-- ----------------------------
31DROP TABLE IF EXISTS `enemies_info`;
32CREATE TABLE `enemies_info` (
33  `faction_id` int(11) NOT NULL,
34  `enemy_id` int(11) NOT NULL,
35  PRIMARY KEY (`faction_id`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38-- ----------------------------
39-- Table structure for faction_info
40-- ----------------------------
41DROP TABLE IF EXISTS `faction_info`;
42CREATE TABLE `faction_info` (
43  `id` int(11) NOT NULL AUTO_INCREMENT,
44  `name` varchar(255) NOT NULL,
45  `admin_id` int(11) NOT NULL,
46  `power` int(11) NOT NULL DEFAULT '0',
47  `tokens` int(11) NOT NULL DEFAULT '0',
48  `permissions` bit(1) NOT NULL DEFAULT b'0',
49  `extra_slot` int(11) NOT NULL DEFAULT '0',
50  `extra_warp` int(11) NOT NULL DEFAULT '0',
51  `potion_booster` bit(1) NOT NULL DEFAULT b'0',
52  `spawner_booster` bit(1) NOT NULL DEFAULT b'0',
53  `storage_upgrade` bit(1) NOT NULL DEFAULT b'0',
54  `speed` int(11) NOT NULL DEFAULT '0',
55  `jump_boost` int(11) NOT NULL DEFAULT '0',
56  `regeneration` int(11) NOT NULL DEFAULT '0',
57  `haste` int(11) NOT NULL DEFAULT '0',
58  `strength` int(11) NOT NULL DEFAULT '0',
59  PRIMARY KEY (`id`,`name`)
60) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
61
62-- ----------------------------
63-- Table structure for player_info
64-- ----------------------------
65DROP TABLE IF EXISTS `player_info`;
66CREATE TABLE `player_info` (
67  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
68  `name` varchar(255) NOT NULL,
69  `username` varchar(255) NOT NULL,
70  `password` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
71  `faction_id` int(11) NOT NULL DEFAULT '0',
72  `isAdmin` bit(1) NOT NULL DEFAULT b'0',
73  `isMod` bit(1) NOT NULL DEFAULT b'0',
74  `isElder` bit(1) NOT NULL DEFAULT b'0',
75  `ip` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
76  `lastlogin` bigint(20) DEFAULT NULL,
77  `x` double NOT NULL DEFAULT '0',
78  `y` double NOT NULL DEFAULT '0',
79  `z` double NOT NULL DEFAULT '0',
80  `world` varchar(255) NOT NULL DEFAULT 'world',
81  `regdate` bigint(20) NOT NULL DEFAULT '0',
82  `regip` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
83  `yaw` float DEFAULT NULL,
84  `pitch` float DEFAULT NULL,
85  `email` varchar(255) DEFAULT NULL,
86  `isLogged` smallint(6) NOT NULL DEFAULT '0',
87  `hasSession` smallint(6) NOT NULL DEFAULT '0',
88  `totp` varchar(16) DEFAULT NULL,
89  PRIMARY KEY (`id`),
90  UNIQUE KEY `name` (`name`)
91) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;