· 4 years ago · Jul 11, 2021, 03:38 PM
1-- --------------------------------------------------------
2-- Host: 217.122.173.5
3-- Server version: 10.4.6-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 tbcore
16CREATE DATABASE IF NOT EXISTS `tbcore` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `tbcore`;
18
19-- Dumping structure for table tbcore.cryptos
20CREATE TABLE IF NOT EXISTS `cryptos` (
21 `crypto` varchar(50) DEFAULT NULL,
22 `crypto_label` varchar(50) DEFAULT NULL,
23 `value` int(11) DEFAULT NULL
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25
26-- Dumping data for table tbcore.cryptos: ~1 rows (approximately)
27/*!40000 ALTER TABLE `cryptos` DISABLE KEYS */;
28INSERT INTO `cryptos` (`crypto`, `crypto_label`, `value`) VALUES
29 ('tbcoin', 'TBCoin', 4663);
30/*!40000 ALTER TABLE `cryptos` ENABLE KEYS */;
31
32-- Dumping structure for table tbcore.house_inventory
33CREATE TABLE IF NOT EXISTS `house_inventory` (
34 `house` varchar(50) DEFAULT NULL,
35 `item` varchar(50) DEFAULT NULL,
36 `amount` int(11) DEFAULT NULL,
37 `itemslot` int(11) DEFAULT NULL,
38 `type` varchar(50) DEFAULT 'item'
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40
41-- Dumping data for table tbcore.house_inventory: ~3 rows (approximately)
42/*!40000 ALTER TABLE `house_inventory` DISABLE KEYS */;
43INSERT INTO `house_inventory` (`house`, `item`, `amount`, `itemslot`, `type`) VALUES
44 ('mirrorpark01', 'water', 22, 5, 'item'),
45 ('mirrorpark01', 'radio', 22, 8, 'item'),
46 ('mirrorpark01', 'bread', 22, 4, 'item');
47/*!40000 ALTER TABLE `house_inventory` ENABLE KEYS */;
48
49-- Dumping structure for table tbcore.house_plants
50CREATE TABLE IF NOT EXISTS `house_plants` (
51 `house` varchar(50) DEFAULT NULL,
52 `stage` varchar(50) DEFAULT 'stage-e',
53 `health` int(11) DEFAULT 100,
54 `food` int(11) DEFAULT 100,
55 `coords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
56 `plantid` int(11) DEFAULT NULL,
57 `type` varchar(50) DEFAULT NULL,
58 `tops` int(11) DEFAULT 15,
59 `harvestable` varchar(50) DEFAULT 'false'
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61
62-- Dumping data for table tbcore.house_plants: ~6 rows (approximately)
63/*!40000 ALTER TABLE `house_plants` DISABLE KEYS */;
64INSERT INTO `house_plants` (`house`, `stage`, `health`, `food`, `coords`, `plantid`, `type`, `tops`, `harvestable`) VALUES
65 ('mirrorpark01', 'stage-e', 1, 1, '{"z":34.548931121826,"y":-603.32531738281,"x":894.84039306641}', 842132, 'ak47', 1, 'true'),
66 ('mirrorpark01', 'stage-e', 1, 1, '{"z":34.548931121826,"y":-603.24182128906,"x":895.93707275391}', 123321, 'amnesia', 1, 'true'),
67 ('mirrorpark01', 'stage-e', 1, 1, '{"z":34.548931121826,"y":-603.81628417969,"x":896.99505615234}', 109924, 'og-kush', 1, 'true'),
68 ('mirrorpark01', 'stage-e', 1, 1, '{"z":34.548931121826,"y":-609.87683105469,"x":895.45111083984}', 941040, 'skunk', 1, 'true'),
69 ('mirrorpark01', 'stage-e', 1, 1, '{"z":34.548946380615,"y":-605.3115234375,"x":893.34216308594}', 286071, 'amnesia', 1, 'true'),
70 ('mirrorpark01', 'stage-e', 1, 1, '{"z":34.548961639404,"y":-605.31066894531,"x":891.71765136719}', 336303, 'white-widow', 1, 'true');
71/*!40000 ALTER TABLE `house_plants` ENABLE KEYS */;
72
73-- Dumping structure for table tbcore.house_weapons
74CREATE TABLE IF NOT EXISTS `house_weapons` (
75 `house` varchar(50) DEFAULT NULL,
76 `weapon` varchar(50) DEFAULT NULL,
77 `itemslot` int(11) DEFAULT NULL,
78 `bullets` int(11) DEFAULT 0,
79 `weaponid` int(11) DEFAULT NULL
80) ENGINE=InnoDB DEFAULT CHARSET=latin1;
81
82-- Dumping data for table tbcore.house_weapons: ~1 rows (approximately)
83/*!40000 ALTER TABLE `house_weapons` DISABLE KEYS */;
84INSERT INTO `house_weapons` (`house`, `weapon`, `itemslot`, `bullets`, `weaponid`) VALUES
85 ('mirrorpark01', 'weapon_pistol', 1, 250, 234556);
86/*!40000 ALTER TABLE `house_weapons` ENABLE KEYS */;
87
88-- Dumping structure for table tbcore.players
89CREATE TABLE IF NOT EXISTS `players` (
90 `id` int(11) NOT NULL AUTO_INCREMENT,
91 `identifier` varchar(50) DEFAULT NULL,
92 `license` varchar(50) DEFAULT NULL,
93 `name` varchar(50) DEFAULT NULL,
94 `cid` int(11) DEFAULT NULL,
95 `cash` int(11) DEFAULT NULL,
96 `bank` int(11) DEFAULT NULL,
97 `bsn` varchar(50) DEFAULT NULL,
98 `banknumber` varchar(50) DEFAULT NULL,
99 `slotname` varchar(50) DEFAULT NULL,
100 `firstname` varchar(50) DEFAULT NULL,
101 `tussenvoegsel` varchar(50) DEFAULT 'n.v.t.',
102 `lastname` varchar(50) DEFAULT NULL,
103 `sex` varchar(50) DEFAULT NULL,
104 `dob` varchar(50) DEFAULT NULL,
105 `job` varchar(50) DEFAULT 'unemployed',
106 `job_grade` varchar(50) DEFAULT '0',
107 `position` text DEFAULT NULL,
108 `usergroup` varchar(50) DEFAULT 'user',
109 `phone` text DEFAULT NULL,
110 `status` text DEFAULT NULL,
111 PRIMARY KEY (`id`)
112) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
113
114-- Dumping data for table tbcore.players: ~3 rows (approximately)
115/*!40000 ALTER TABLE `players` DISABLE KEYS */;
116INSERT INTO `players` (`id`, `identifier`, `license`, `name`, `cid`, `cash`, `bank`, `bsn`, `banknumber`, `slotname`, `firstname`, `tussenvoegsel`, `lastname`, `sex`, `dob`, `job`, `job_grade`, `position`, `usergroup`, `phone`, `status`) VALUES
117 (10, 'steam:110000117fd5be8', 'license:b19a466c8a6553b860896f6724db32dfec9d5aad', 's0me1', 4, 3476, 2500, '515859985', 'NL08TB311788940429', '234234', 'werwer', 'werwer', 'werwer', '324234', '', 'unemployed', '0', '{"z":58.212516784668,"y":-607.6103515625,"x":887.36041259766}', 'user', '0677963256', NULL),
118 (11, 'steam:110000117fd5be8', 'license:b19a466c8a6553b860896f6724db32dfec9d5aad', 's0me1', 2, 110005, 3502500, '345599365', 'NL07TB629101562500', 'Yeeeeeet', 'Yeet', 'Yeet', 'Yeet', 'Man', '2000-09-13', 'unemployed', '0', '{"z":58.212516784668,"y":-607.6103515625,"x":887.36041259766}', 'admin', '0672647094', '{"thirst":10,"hunger":10}'),
119 (12, 'steam:11000011598271d', 'license:c99c19404eb2bcd7a518812d74ee455774e7a248', 'Zapherion', 1, 2500, 2500, '769342041', 'NL05TB521600341796', 'WEreldgozerds', 'Jan', 'De', 'Vries', 'man', '1222-12-12', 'unemployed', '0', '{"z":54.086296081543,"y":-202.93687438965,"x":320.33166503906}', 'admin', '0674441528', '{"thirst":0,"hunger":0}'),
120 (13, 'steam:11000010774b0a7', 'license:2c478316c7f184b066ae06fd466b736805e01e38', 'Dr. Onjo 204', 1, 2500, 2500, '256692504', 'NL07TB873025512695', 'Hey', 'Onno', 'de', 'vries', 'Manwijf', '2002-02-04', 'unemployed', '0', '{"y":-944.99450683594,"x":187.0347442627,"z":30.091930389404}', 'user', '0630398559', NULL);
121/*!40000 ALTER TABLE `players` ENABLE KEYS */;
122
123-- Dumping structure for table tbcore.player_bankaccounts
124CREATE TABLE IF NOT EXISTS `player_bankaccounts` (
125 `identifier` varchar(50) DEFAULT NULL,
126 `cid` int(11) DEFAULT NULL,
127 `name` varchar(50) DEFAULT NULL,
128 `balance` int(11) DEFAULT NULL,
129 `type` varchar(50) DEFAULT NULL,
130 `banknumber` varchar(50) DEFAULT NULL
131) ENGINE=InnoDB DEFAULT CHARSET=latin1;
132
133-- Dumping data for table tbcore.player_bankaccounts: ~2 rows (approximately)
134/*!40000 ALTER TABLE `player_bankaccounts` DISABLE KEYS */;
135INSERT INTO `player_bankaccounts` (`identifier`, `cid`, `name`, `balance`, `type`, `banknumber`) VALUES
136 ('steam:110000117fd5be8', 2, 'Yeet', 2, 'Spaarrekening', 'NLYEET01234');
137/*!40000 ALTER TABLE `player_bankaccounts` ENABLE KEYS */;
138
139-- Dumping structure for table tbcore.player_clothing
140CREATE TABLE IF NOT EXISTS `player_clothing` (
141 `identifier` varchar(255) NOT NULL,
142 `cid` int(11) NOT NULL,
143 `sex` int(11) NOT NULL,
144 `face` int(11) NOT NULL DEFAULT 0,
145 `dadmumpercent` int(11) NOT NULL DEFAULT 0,
146 `skinton` int(11) NOT NULL DEFAULT 0,
147 `eyecolor` int(11) NOT NULL DEFAULT 0,
148 `acne` int(11) NOT NULL DEFAULT 0,
149 `skinproblem` int(11) NOT NULL DEFAULT 0,
150 `freckle` int(11) NOT NULL DEFAULT 0,
151 `wrinkle` int(11) NOT NULL DEFAULT 0,
152 `wrinkleopacity` int(11) NOT NULL DEFAULT 0,
153 `eyebrow` int(11) NOT NULL DEFAULT 0,
154 `eyebrowopacity` int(11) NOT NULL DEFAULT 0,
155 `beard` int(11) NOT NULL DEFAULT 0,
156 `beardopacity` int(11) NOT NULL DEFAULT 0,
157 `beardcolor` int(11) NOT NULL DEFAULT 0,
158 `hair` int(11) NOT NULL DEFAULT 0,
159 `hairtext` int(11) NOT NULL DEFAULT 0,
160 `torso` int(11) NOT NULL DEFAULT 0,
161 `torsotext` int(11) NOT NULL DEFAULT 0,
162 `leg` int(11) NOT NULL DEFAULT 0,
163 `legtext` int(11) NOT NULL DEFAULT 0,
164 `shoes` int(11) NOT NULL DEFAULT 0,
165 `shoestext` int(11) NOT NULL DEFAULT 0,
166 `accessory` int(11) NOT NULL DEFAULT 0,
167 `accessorytext` int(11) NOT NULL DEFAULT 0,
168 `undershirt` int(11) NOT NULL DEFAULT 0,
169 `undershirttext` int(11) NOT NULL DEFAULT 0,
170 `torso2` int(11) NOT NULL DEFAULT 0,
171 `torso2text` int(11) NOT NULL DEFAULT 0,
172 `prop_hat` int(11) NOT NULL DEFAULT 0,
173 `prop_hat_text` int(11) NOT NULL DEFAULT 0,
174 `prop_glasses` int(11) NOT NULL DEFAULT 0,
175 `prop_glasses_text` int(11) NOT NULL DEFAULT 0,
176 `prop_earrings` int(11) NOT NULL DEFAULT 0,
177 `prop_earrings_text` int(11) NOT NULL DEFAULT 0,
178 `prop_watches` int(11) NOT NULL DEFAULT 0,
179 `prop_watches_text` int(11) NOT NULL DEFAULT 0
180) ENGINE=InnoDB DEFAULT CHARSET=latin1;
181
182-- Dumping data for table tbcore.player_clothing: ~0 rows (approximately)
183/*!40000 ALTER TABLE `player_clothing` DISABLE KEYS */;
184/*!40000 ALTER TABLE `player_clothing` ENABLE KEYS */;
185
186-- Dumping structure for table tbcore.player_contacts
187CREATE TABLE IF NOT EXISTS `player_contacts` (
188 `identifier` varchar(50) DEFAULT NULL,
189 `cid` int(11) DEFAULT NULL,
190 `name` varchar(50) DEFAULT NULL,
191 `number` int(10) unsigned zerofill DEFAULT NULL,
192 `color` text DEFAULT NULL
193) ENGINE=InnoDB DEFAULT CHARSET=latin1;
194
195-- Dumping data for table tbcore.player_contacts: ~2 rows (approximately)
196/*!40000 ALTER TABLE `player_contacts` DISABLE KEYS */;
197INSERT INTO `player_contacts` (`identifier`, `cid`, `name`, `number`, `color`) VALUES
198 ('steam:110000117fd5be8', 2, 'yeet', 0629482058, NULL);
199/*!40000 ALTER TABLE `player_contacts` ENABLE KEYS */;
200
201-- Dumping structure for table tbcore.player_houses
202CREATE TABLE IF NOT EXISTS `player_houses` (
203 `identifier` varchar(50) DEFAULT NULL,
204 `cid` int(11) DEFAULT NULL,
205 `house` varchar(50) DEFAULT NULL
206) ENGINE=InnoDB DEFAULT CHARSET=latin1;
207
208-- Dumping data for table tbcore.player_houses: ~2 rows (approximately)
209/*!40000 ALTER TABLE `player_houses` DISABLE KEYS */;
210INSERT INTO `player_houses` (`identifier`, `cid`, `house`) VALUES
211 ('steam:110000117fd5be8', 2, 'mirrorpark01'),
212 ('steam:110000117fd5be8', 2, 'mirrorpark02');
213/*!40000 ALTER TABLE `player_houses` ENABLE KEYS */;
214
215-- Dumping structure for table tbcore.player_inventory
216CREATE TABLE IF NOT EXISTS `player_inventory` (
217 `cid` int(11) DEFAULT NULL,
218 `identifier` varchar(50) DEFAULT NULL,
219 `item` varchar(50) DEFAULT NULL,
220 `amount` int(11) DEFAULT NULL,
221 `itemslot` int(11) DEFAULT NULL,
222 `type` varchar(50) DEFAULT 'item'
223) ENGINE=InnoDB DEFAULT CHARSET=latin1;
224
225-- Dumping data for table tbcore.player_inventory: ~10 rows (approximately)
226/*!40000 ALTER TABLE `player_inventory` DISABLE KEYS */;
227INSERT INTO `player_inventory` (`cid`, `identifier`, `item`, `amount`, `itemslot`, `type`) VALUES
228 (2, 'steam:110000117fd5be8', 'laptop', 4, 5, 'item'),
229 (1, 'steam:11000011598271d', 'laptop', 1, 1, 'item'),
230 (2, 'steam:110000117fd5be8', 'ogkush', 88, 1, 'item'),
231 (2, 'steam:110000117fd5be8', 'amnesia', 3, 7, 'item'),
232 (2, 'steam:110000117fd5be8', 'ak47', 15, 11, 'item'),
233 (2, 'steam:110000117fd5be8', 'whitewidow', 1, 20, 'item'),
234 (2, 'steam:110000117fd5be8', 'purplehaze', 17, 6, 'item'),
235 (2, 'steam:110000117fd5be8', 'bread', 11, 21, 'item'),
236 (2, 'steam:110000117fd5be8', 'skunk', 1, 25, 'item'),
237 (2, 'steam:110000117fd5be8', 'joint', 2, 2, 'item');
238/*!40000 ALTER TABLE `player_inventory` ENABLE KEYS */;
239
240-- Dumping structure for table tbcore.player_vehicles
241CREATE TABLE IF NOT EXISTS `player_vehicles` (
242 `identifier` varchar(50) DEFAULT NULL,
243 `cid` int(11) DEFAULT NULL,
244 `vehicle` varchar(50) DEFAULT NULL,
245 `plate` varchar(50) DEFAULT NULL,
246 `fakeplate` int(11) DEFAULT 0
247) ENGINE=InnoDB DEFAULT CHARSET=latin1;
248
249-- Dumping data for table tbcore.player_vehicles: ~1 rows (approximately)
250/*!40000 ALTER TABLE `player_vehicles` DISABLE KEYS */;
251INSERT INTO `player_vehicles` (`identifier`, `cid`, `vehicle`, `plate`, `fakeplate`) VALUES
252 ('steam:110000117fd5be8', 2, 'lwgtr', 'NL0123', 0);
253/*!40000 ALTER TABLE `player_vehicles` ENABLE KEYS */;
254
255-- Dumping structure for table tbcore.player_weapons
256CREATE TABLE IF NOT EXISTS `player_weapons` (
257 `cid` int(11) DEFAULT NULL,
258 `identifier` varchar(50) DEFAULT NULL,
259 `weapon` varchar(50) DEFAULT NULL,
260 `itemslot` int(11) DEFAULT NULL,
261 `bullets` int(11) DEFAULT 0,
262 `weaponid` int(11) DEFAULT NULL
263) ENGINE=InnoDB DEFAULT CHARSET=latin1;
264
265-- Dumping data for table tbcore.player_weapons: ~4 rows (approximately)
266/*!40000 ALTER TABLE `player_weapons` DISABLE KEYS */;
267INSERT INTO `player_weapons` (`cid`, `identifier`, `weapon`, `itemslot`, `bullets`, `weaponid`) VALUES
268 (2, 'steam:110000117fd5be8', 'weapon_smg', 13, 0, 584594),
269 (2, 'steam:110000117fd5be8', 'weapon_carbinerifle', 12, 0, 677185),
270 (2, 'steam:110000117fd5be8', 'weapon_pistol', 3, 6, 739166),
271 (2, 'steam:110000117fd5be8', 'weapon_carbinerifle', 17, 65, 350280);
272/*!40000 ALTER TABLE `player_weapons` ENABLE KEYS */;
273
274/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
275/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
276/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
277