WW6rhc9E

1-- --------------------------------------------------------
2-- Host:                         localhost
3-- Server version:               10.3.16-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL Version:             10.1.0.5464
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for uhrprage
16CREATE DATABASE IF NOT EXISTS `gta` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `gta`;
18
19-- Dumping structure for table uhrprage.v2_reports
20CREATE TABLE IF NOT EXISTS `v2_reports` (
21  `id` int(11) NOT NULL,
22  `playerId` int(11) NOT NULL,
23  `adminId` int(11) DEFAULT NULL,
24  `type` varchar(128) NOT NULL,
25  `status` tinyint(11) NOT NULL DEFAULT 0,
26  `date` int(11) DEFAULT NULL,
27  `messages` varchar(540) CHARACTER SET utf8mb4 DEFAULT NULL,
28  `text` varchar(540) CHARACTER SET utf8mb4 DEFAULT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32-- Dumping data for table uhrprage.v2_reports: ~0 rows (approximately)
33/*!40000 ALTER TABLE `v2_reports` DISABLE KEYS */;
34/*!40000 ALTER TABLE `v2_reports` ENABLE KEYS */;
35
36-- Dumping structure for table uhrprage.v2_reports_messages
37CREATE TABLE IF NOT EXISTS `v2_reports_messages` (
38  `id` int(11) NOT NULL,
39  `reportId` int(11) DEFAULT 1,
40  `name` varchar(50) DEFAULT NULL,
41  `serverId` int(11) DEFAULT NULL,
42  `playerId` int(11) DEFAULT NULL,
43  `message` varchar(540) CHARACTER SET utf8mb4 DEFAULT NULL,
44  `date` int(11) DEFAULT NULL,
45  `text` varchar(540) CHARACTER SET utf8mb4 DEFAULT NULL,
46  PRIMARY KEY (`id`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49-- Dumping data for table uhrprage.v2_reports_messages: ~0 rows (approximately)
50/*!40000 ALTER TABLE `v2_reports_messages` DISABLE KEYS */;
51/*!40000 ALTER TABLE `v2_reports_messages` ENABLE KEYS */;
52
53-- Dumping structure for table uhrprage.whitelist
54CREATE TABLE IF NOT EXISTS `whitelist` (
55  `id` int(11) NOT NULL,
56  `socialClub` varchar(128) NOT NULL,
57  `login` varchar(40) NOT NULL,
58  `email` varchar(40) NOT NULL,
59  `enabled` int(64) NOT NULL
60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61
62-- Dumping data for table uhrprage.whitelist: ~0 rows (approximately)
63/*!40000 ALTER TABLE `whitelist` DISABLE KEYS */;
64/*!40000 ALTER TABLE `whitelist` ENABLE KEYS */;
65
66/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
67/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
68/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;