· 6 years ago · Dec 11, 2019, 08:58 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.33-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
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 lslaweb
16CREATE DATABASE IF NOT EXISTS `lslaweb` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `lslaweb`;
18
19-- Dumping structure for table lslaweb.accounts
20CREATE TABLE IF NOT EXISTS `accounts` (
21 `accountid` int(11) NOT NULL AUTO_INCREMENT,
22 `license` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
23 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
24 `discord` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
25 `identifier` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
26 `ipAddress` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
27 `group` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'user',
28 `mtPerms` int(1) NOT NULL DEFAULT '0',
29 `barred` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Bans user from twitter',
30 `banned` int(11) NOT NULL DEFAULT '0',
31 `maxCharacters` int(11) NOT NULL DEFAULT '3',
32 PRIMARY KEY (`accountid`)
33) ENGINE=InnoDB AUTO_INCREMENT=20313 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
34
35-- Dumping data for table lslaweb.accounts: ~5 rows (approximately)
36/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
37INSERT INTO `accounts` (`accountid`, `license`, `name`, `discord`, `identifier`, `ipAddress`, `group`, `mtPerms`, `barred`, `banned`, `maxCharacters`) VALUES
38 (1, 'license:ff177c84df15841941dc7344c880445aa7c3d637', 'kn0pee', 'discord:178398237550444545', 'steam:110000105fdc62b', 'ip:193.119.77.83', 'superadmin', 1, 0, 0, 3),
39 (2, 'license:9f79b503b4aacb88c1ebb4e5dee5136db7b6d7a1', 'OzNat', 'discord:251693493078982656', 'steam:110000102b31dd6', 'ip:60.230.87.201', 'Juice', 1, 0, 0, 3),
40 (3, 'license:165433ea4c012e4bb3665c51ca62c0d6a8c273ae', 'GateheaD', NULL, 'steam:1100001000030e0', 'ip:180.150.5.221', 'user', 0, 0, 0, 3),
41 (4, 'license:ab845fdbc59dd680db846fad5f13c77d5eb7d037', 'Pengz', 'discord:231767467884544000', 'steam:110000100003f79', 'ip:124.171.162.225', 'user', 0, 0, 0, 3),
42 (20312, 'license:c89b3798b8f0707a008231fdad8661568981bebc', 'dredricunha', 'discord:444533518152761344', 'steam:110000100003a48', 'ip:127.0.0.1', 'user', 0, 0, 0, 3);
43/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
44
45-- Dumping structure for table lslaweb.adminaction
46CREATE TABLE IF NOT EXISTS `adminaction` (
47 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Auto incrementing PK',
48 `type` varchar(50) NOT NULL COMMENT 'Type of adminaction',
49 `accountid` int(11) DEFAULT NULL COMMENT 'Account ID of the banned player',
50 `playerID` varchar(50) DEFAULT NULL COMMENT 'Steam ID of the banned player',
51 `playerName` varchar(50) DEFAULT NULL COMMENT 'Name of the banned player (at the time they were banned)',
52 `playerLicense` varchar(50) DEFAULT NULL COMMENT 'License of the banned player',
53 `playerDiscord` varchar(50) DEFAULT NULL COMMENT 'Discord ID of the banned player',
54 `staffID` varchar(50) DEFAULT NULL COMMENT 'Staff steam ID',
55 `staffName` varchar(50) NOT NULL COMMENT 'Staff steam name',
56 `timedate` datetime DEFAULT NULL COMMENT 'Date of ban',
57 `reason` longtext COMMENT 'Reason for ban',
58 `expire` varchar(50) DEFAULT NULL COMMENT 'When the ban expires (NULL = no ban, perm = perm ban, number = UNIX time of unban)',
59 PRIMARY KEY (`id`),
60 KEY `expire` (`expire`)
61) ENGINE=InnoDB AUTO_INCREMENT=20872 DEFAULT CHARSET=utf8;
62
63-- Dumping data for table lslaweb.adminaction: ~8 rows (approximately)
64/*!40000 ALTER TABLE `adminaction` DISABLE KEYS */;
65INSERT INTO `adminaction` (`id`, `type`, `accountid`, `playerID`, `playerName`, `playerLicense`, `playerDiscord`, `staffID`, `staffName`, `timedate`, `reason`, `expire`) VALUES
66 (20864, 'commend', 1584, NULL, 'METRITIS', 'license:14c75f6568f23bc7e9c318d6bb06ac5d8e8d2f05', 'discord:230524412229713920', 'license:9f5c2fddd589cd611155104c6a3a8ad311b05c0c', 'Bobby Knuckles', '2019-08-22 00:20:25', 'Great RP mate. Entertaining stuff', NULL),
67 (20865, 'note', 14457, NULL, 'nathan', 'license:33d8294cede349f74d18b3efc747264de5e38869', 'discord:401633573620416513', 'license:e62952828ce092949d3886d3898547076e88566a', 'Checkable', '2019-08-22 00:31:31', 'Found multiple of his White HSV\'s abandoned outside of garages. Plate - 49KPN435. If staff keep seeing these around punish him accordingly.', NULL),
68 (20866, 'note', 19941, NULL, 'Liam', 'license:cb0b6d76bf7b93e93683e080df38dfc48d8525c5', 'discord:220460804024172546', 'license:e62952828ce092949d3886d3898547076e88566a', 'Checkable', '2019-08-22 00:44:39', 'Spoke to about not cooperating at a traffic stop. Was being pulled over for a speeding ticket and he just intiated in a pursuit and shot cops.', NULL),
69 (20867, 'kick', 20312, NULL, 'dredricunha', 'license:c89b3798b8f0707a008231fdad8661568981bebc', 'discord:444533518152761344', 'license:e61e47b9ae7d42ce1feffe79eb7c325dabc3db71', 'Kripted', '2019-08-22 00:50:39', 'Cya idiot', NULL),
70 (20868, 'ban', 20312, NULL, 'dredricunha', 'license:c89b3798b8f0707a008231fdad8661568981bebc', 'discord:444533518152761344', 'license:e62952828ce092949d3886d3898547076e88566a', 'Checkable', '2019-08-22 00:55:17', 'Hacking.', 'perm'),
71 (20869, 'kick', 20312, NULL, 'dredricunha', 'license:02a2fd35ed07f53dfe2a97dbb4183c1ab83f5b02', NULL, 'license:e62952828ce092949d3886d3898547076e88566a', 'Checkable', '2019-08-22 02:37:41', 'vdm, Read the rules. You\'ve been kicked about this before', NULL),
72 (20870, 'kick', 20312, NULL, 'dredricunha', 'license:02a2fd35ed07f53dfe2a97dbb4183c1ab83f5b02', NULL, 'license:e62952828ce092949d3886d3898547076e88566a', 'Checkable', '2019-08-22 02:37:41', 'vdm, Read the rules. You\'ve been kicked about this before', NULL),
73 (20871, 'kick', 20312, NULL, 'dredricunha', 'license:02a2fd35ed07f53dfe2a97dbb4183c1ab83f5b02', NULL, 'license:e62952828ce092949d3886d3898547076e88566a', 'Checkable', '2019-08-22 02:37:41', 'vdm, Read the rules. You\'ve been kicked about this before', NULL);
74/*!40000 ALTER TABLE `adminaction` ENABLE KEYS */;
75
76-- Dumping structure for table lslaweb.tokens
77CREATE TABLE IF NOT EXISTS `tokens` (
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `token` varchar(50) DEFAULT NULL,
80 `username` varchar(50) DEFAULT NULL,
81 PRIMARY KEY (`id`)
82) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
83
84-- Dumping data for table lslaweb.tokens: ~0 rows (approximately)
85/*!40000 ALTER TABLE `tokens` DISABLE KEYS */;
86/*!40000 ALTER TABLE `tokens` ENABLE KEYS */;
87
88-- Dumping structure for table lslaweb.users
89CREATE TABLE IF NOT EXISTS `users` (
90 `id` int(11) NOT NULL AUTO_INCREMENT,
91 `username` varchar(50) NOT NULL,
92 `password` varchar(100) NOT NULL,
93 `usergroup` varchar(50) NOT NULL DEFAULT 'user',
94 `profile_image` varchar(100) DEFAULT NULL,
95 PRIMARY KEY (`id`)
96) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4;
97
98-- Dumping data for table lslaweb.users: ~4 rows (approximately)
99/*!40000 ALTER TABLE `users` DISABLE KEYS */;
100INSERT INTO `users` (`id`, `username`, `password`, `usergroup`, `profile_image`) VALUES
101 (32, 'yadiiiig', '$5$rounds=535000$ZsHFmDHEpmn.cQ2.$bAkkuN11OGZZO036bcE7ARS6pZjmzFHmc1rw1TROhPA', 'superadmin', NULL),
102 (33, 'Martibo', '$5$rounds=535000$6VmuQVrS4dJq8CcY$2K3mZcoqQQEg.oJ4e3ZcfIAtScCeomO28sy/6hLkuH1', 'superadmin', 'https://i.imgur.com/rbXZcVH.jpg'),
103 (34, 'Bestboy', '$5$rounds=535000$6VmuQVrS4dJq8CcY$2K3mZcoqQQEg.oJ4e3ZcfIAtScCeomO28sy/6hLkuH1', 'user', NULL),
104 (35, 'Assmuffin', '$5$rounds=535000$6VmuQVrS4dJq8CcY$2K3mZcoqQQEg.oJ4e3ZcfIAtScCeomO28sy/6hLkuH1', 'admin', NULL),
105 (37, 'Testslut', '$5$rounds=535000$moR3ze3mBQEJMlky$ImFz7XxyiDmrggsthl.yHTU53IX8uOO4z0uyVJZOfS4', 'user', NULL);
106/*!40000 ALTER TABLE `users` ENABLE KEYS */;
107
108/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
109/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
110/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;