LHsB4dtf

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               10.1.6-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL Version:             9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for rp_stats
14CREATE DATABASE IF NOT EXISTS `mydatabase_base` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `mydatabase_base`;
16
17-- Dumping structure for table rp_stats.player_data
18CREATE TABLE IF NOT EXISTS `player_data` (
19  `SteamID` bigint(20) NOT NULL,
20  `Name` varchar(50) NOT NULL,
21  `Money` int(11) NOT NULL,
22  PRIMARY KEY (`SteamID`)
23) ENGINE=MyISAM DEFAULT CHARSET=utf8;
24
25-- Dumping data for table rp_stats.player_data: 0 rows
26/*!40000 ALTER TABLE `player_data` DISABLE KEYS */;
27/*!40000 ALTER TABLE `player_data` ENABLE KEYS */;
28
29
30-- Dumping structure for table rp_stats.rp_doordata
31CREATE TABLE IF NOT EXISTS `rp_doordata` (
32  `Index` int(11) NOT NULL,
33  `Map` varchar(50) NOT NULL,
34  `Title` varchar(50) DEFAULT NULL,
35  `Team` varchar(50) DEFAULT NULL,
36  `Group` varchar(50) DEFAULT NULL,
37  `Ownable` int(1) DEFAULT NULL,
38  `Locked` int(1) DEFAULT NULL,
39  PRIMARY KEY (`Index`,`Map`)
40) ENGINE=MyISAM DEFAULT CHARSET=utf8;
41
42
43-- Dumping structure for table rp_stats.rp_jobspawn
44CREATE TABLE IF NOT EXISTS `rp_jobspawn` (
45  `id` int(11) NOT NULL,
46  `job` char(30) NOT NULL,
47  `map` varchar(45) NOT NULL,
48  `x` int(11) NOT NULL,
49  `y` int(11) NOT NULL,
50  `z` int(11) NOT NULL,
51  PRIMARY KEY (`id`)
52) ENGINE=MyISAM DEFAULT CHARSET=utf8;
53
54-- Dumping data for table rp_stats.rp_jobspawn: 0 rows
55/*!40000 ALTER TABLE `rp_jobspawn` DISABLE KEYS */;
56/*!40000 ALTER TABLE `rp_jobspawn` ENABLE KEYS */;
57/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
58/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
59/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;