· 7 years ago · Dec 16, 2018, 07:20 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Wersja serwera: 10.1.25-MariaDB - mariadb.org binary distribution
4-- Serwer OS: Win32
5-- HeidiSQL Wersja: 9.5.0.5196
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-- Zrzut struktury bazy danych lsvrp_test
16CREATE DATABASE IF NOT EXISTS `lsvrp_test` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `lsvrp_test`;
18
19-- Zrzut struktury tabela lsvrp_test.lsvrpcore_members
20CREATE TABLE IF NOT EXISTS `lsvrpcore_members` (
21 `member_id` int(11) NOT NULL AUTO_INCREMENT,
22 `AdminFlags` text,
23 `AdminLevel` int(11) NOT NULL,
24 `donateTime` int(11) NOT NULL,
25 `name` text,
26 `vPoints` int(11) NOT NULL,
27 PRIMARY KEY (`member_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30-- Zrzucanie danych dla tabeli lsvrp_test.lsvrpcore_members: ~0 rows (około)
31DELETE FROM `lsvrpcore_members`;
32/*!40000 ALTER TABLE `lsvrpcore_members` DISABLE KEYS */;
33/*!40000 ALTER TABLE `lsvrpcore_members` ENABLE KEYS */;
34
35-- Zrzut struktury tabela lsvrp_test.lsvrp_247_products
36CREATE TABLE IF NOT EXISTS `lsvrp_247_products` (
37 `Id` int(11) NOT NULL AUTO_INCREMENT,
38 `Name` text,
39 `Price` int(11) NOT NULL,
40 `ShopID` int(11) NOT NULL,
41 `Type` int(11) NOT NULL,
42 `Value1` int(11) NOT NULL,
43 `Value2` int(11) NOT NULL,
44 `Value3` text,
45 PRIMARY KEY (`Id`)
46) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47
48-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_247_products: ~0 rows (około)
49DELETE FROM `lsvrp_247_products`;
50/*!40000 ALTER TABLE `lsvrp_247_products` DISABLE KEYS */;
51/*!40000 ALTER TABLE `lsvrp_247_products` ENABLE KEYS */;
52
53-- Zrzut struktury tabela lsvrp_test.lsvrp_247_shops
54CREATE TABLE IF NOT EXISTS `lsvrp_247_shops` (
55 `Id` int(11) NOT NULL AUTO_INCREMENT,
56 `Name` text,
57 `ShopType` int(11) NOT NULL,
58 `X` float NOT NULL,
59 `Y` float NOT NULL,
60 `Z` float NOT NULL,
61 PRIMARY KEY (`Id`)
62) ENGINE=InnoDB DEFAULT CHARSET=latin1;
63
64-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_247_shops: ~0 rows (około)
65DELETE FROM `lsvrp_247_shops`;
66/*!40000 ALTER TABLE `lsvrp_247_shops` DISABLE KEYS */;
67/*!40000 ALTER TABLE `lsvrp_247_shops` ENABLE KEYS */;
68
69-- Zrzut struktury tabela lsvrp_test.lsvrp_admins_duty
70CREATE TABLE IF NOT EXISTS `lsvrp_admins_duty` (
71 `Id` int(11) NOT NULL AUTO_INCREMENT,
72 `AdminCharID` int(11) NOT NULL,
73 `AdminGlobalID` int(11) NOT NULL,
74 `EndTime` int(11) NOT NULL,
75 `StartTime` int(11) NOT NULL,
76 PRIMARY KEY (`Id`)
77) ENGINE=InnoDB DEFAULT CHARSET=latin1;
78
79-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_admins_duty: ~0 rows (około)
80DELETE FROM `lsvrp_admins_duty`;
81/*!40000 ALTER TABLE `lsvrp_admins_duty` DISABLE KEYS */;
82/*!40000 ALTER TABLE `lsvrp_admins_duty` ENABLE KEYS */;
83
84-- Zrzut struktury tabela lsvrp_test.lsvrp_animations
85CREATE TABLE IF NOT EXISTS `lsvrp_animations` (
86 `Id` int(11) NOT NULL AUTO_INCREMENT,
87 `AllowPlayerControl` bit(1) NOT NULL,
88 `AnimationCommand` text,
89 `AnimationDictionary` text,
90 `AnimationName` text,
91 `Cancellable` bit(1) NOT NULL,
92 `ItemBoneName` text,
93 `ItemID` int(11) NOT NULL,
94 `ItemRotX` float NOT NULL,
95 `ItemRotY` float NOT NULL,
96 `ItemRotZ` float NOT NULL,
97 `ItemX` float NOT NULL,
98 `ItemY` float NOT NULL,
99 `ItemZ` float NOT NULL,
100 `Loop` bit(1) NOT NULL,
101 `OnlyAnimateUpperBody` bit(1) NOT NULL,
102 `StopOnLastFrame` bit(1) NOT NULL,
103 PRIMARY KEY (`Id`)
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105
106-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_animations: ~0 rows (około)
107DELETE FROM `lsvrp_animations`;
108/*!40000 ALTER TABLE `lsvrp_animations` DISABLE KEYS */;
109/*!40000 ALTER TABLE `lsvrp_animations` ENABLE KEYS */;
110
111-- Zrzut struktury tabela lsvrp_test.lsvrp_bans
112CREATE TABLE IF NOT EXISTS `lsvrp_bans` (
113 `Id` int(11) NOT NULL AUTO_INCREMENT,
114 `AdminID` int(11) NOT NULL,
115 `Canceled` bit(1) NOT NULL,
116 `Expire` int(11) NOT NULL,
117 `Ip` text,
118 `MemberID` int(11) NOT NULL,
119 `Reason` text,
120 `Serial` text,
121 `SocialClubName` text,
122 PRIMARY KEY (`Id`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124
125-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_bans: ~0 rows (około)
126DELETE FROM `lsvrp_bans`;
127/*!40000 ALTER TABLE `lsvrp_bans` DISABLE KEYS */;
128/*!40000 ALTER TABLE `lsvrp_bans` ENABLE KEYS */;
129
130-- Zrzut struktury tabela lsvrp_test.lsvrp_blips
131CREATE TABLE IF NOT EXISTS `lsvrp_blips` (
132 `Id` int(11) NOT NULL AUTO_INCREMENT,
133 `Alpha` int(11) NOT NULL,
134 `ColorID` int(11) NOT NULL,
135 `CreatedAt` int(11) NOT NULL,
136 `CreatedBy` int(11) NOT NULL,
137 `Dimension` int(11) NOT NULL,
138 `Name` text,
139 `Scale` float NOT NULL,
140 `SpriteID` int(11) NOT NULL,
141 `X` float NOT NULL,
142 `Y` float NOT NULL,
143 `Z` float NOT NULL,
144 PRIMARY KEY (`Id`)
145) ENGINE=InnoDB DEFAULT CHARSET=latin1;
146
147-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_blips: ~0 rows (około)
148DELETE FROM `lsvrp_blips`;
149/*!40000 ALTER TABLE `lsvrp_blips` DISABLE KEYS */;
150/*!40000 ALTER TABLE `lsvrp_blips` ENABLE KEYS */;
151
152-- Zrzut struktury tabela lsvrp_test.lsvrp_bodies
153CREATE TABLE IF NOT EXISTS `lsvrp_bodies` (
154 `Id` int(11) NOT NULL AUTO_INCREMENT,
155 `CharId` int(11) NOT NULL,
156 `DeathReason` int(11) NOT NULL,
157 `Description` text,
158 `Dna` text,
159 `ItemId` int(11) NOT NULL,
160 `KillerDna` text,
161 `Timestamp` int(11) NOT NULL,
162 PRIMARY KEY (`Id`)
163) ENGINE=InnoDB DEFAULT CHARSET=latin1;
164
165-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_bodies: ~0 rows (około)
166DELETE FROM `lsvrp_bodies`;
167/*!40000 ALTER TABLE `lsvrp_bodies` DISABLE KEYS */;
168/*!40000 ALTER TABLE `lsvrp_bodies` ENABLE KEYS */;
169
170-- Zrzut struktury tabela lsvrp_test.lsvrp_characters
171CREATE TABLE IF NOT EXISTS `lsvrp_characters` (
172 `Id` int(11) NOT NULL AUTO_INCREMENT,
173 `AccountBalance` int(11) NOT NULL,
174 `AccountID` bigint(20) NOT NULL,
175 `AdminJailTime` int(11) NOT NULL,
176 `AfkTime` int(11) NOT NULL,
177 `Blemishes` int(11) NOT NULL,
178 `BlockSpeed` int(11) NOT NULL,
179 `Blocked` bit(1) NOT NULL,
180 `BwTime` int(11) NOT NULL,
181 `Cash` int(11) NOT NULL,
182 `ClothSet` int(11) NOT NULL,
183 `creator` bit(1) NOT NULL,
184 `DefaultSkinName` text,
185 `DefaultSpawn` int(11) DEFAULT NULL,
186 `detentionDoorId` int(11) NOT NULL,
187 `DetentionTime` int(11) NOT NULL,
188 `dimension` int(11) NOT NULL,
189 `DNA` text,
190 `DriverLicense` bit(1) NOT NULL,
191 `DriverLicenseDate` int(11) NOT NULL,
192 `EyeBrows` int(11) NOT NULL,
193 `FaceID` int(11) NOT NULL,
194 `FacialHair` int(11) NOT NULL,
195 `FatherId` int(11) NOT NULL,
196 `FatherModel` int(11) NOT NULL,
197 `FatherSkin` int(11) NOT NULL,
198 `FishLimit` int(11) NOT NULL,
199 `HairColor` int(11) NOT NULL,
200 `HairId` int(11) NOT NULL,
201 `HairModel` int(11) NOT NULL,
202 `HairStyle` int(11) NOT NULL,
203 `Health` double NOT NULL,
204 `InGame` bit(1) NOT NULL,
205 `JobID` int(11) NOT NULL,
206 `LastCustomization` int(11) NOT NULL,
207 `LastDoors` int(11) NOT NULL,
208 `LastFishing` int(11) NOT NULL,
209 `LastLogin` int(11) NOT NULL,
210 `lastX` float NOT NULL,
211 `lastY` float NOT NULL,
212 `lastZ` float NOT NULL,
213 `Lastname` text,
214 `LoginCount` int(11) NOT NULL,
215 `MemberId` int(11) NOT NULL,
216 `MotherId` int(11) NOT NULL,
217 `MotherModel` int(11) NOT NULL,
218 `MotherSkin` int(11) NOT NULL,
219 `Name` text,
220 `NoseBridge` float NOT NULL,
221 `NoseBridgeShift` float NOT NULL,
222 `NoseHeight` float NOT NULL,
223 `NoseLength` float NOT NULL,
224 `NoseTip` float NOT NULL,
225 `NoseWidth` float NOT NULL,
226 `OnlineTime` int(11) NOT NULL,
227 `OOCBlockTime` int(11) NOT NULL,
228 `OverlayColor` int(11) NOT NULL,
229 `Sex` int(11) NOT NULL,
230 `ShapeMix` float NOT NULL,
231 `ShortDNA` text,
232 `SkinColor` int(11) NOT NULL,
233 `SkinData` text,
234 `SkinMix` float NOT NULL,
235 `SkinName` text,
236 `SpawnInfo` int(11) NOT NULL,
237 `SpawnType` int(11) NOT NULL,
238 `SSN` int(11) NOT NULL,
239 `SSNDate` int(11) DEFAULT NULL,
240 `Strength` int(11) NOT NULL,
241 `Tutorial` bit(1) NOT NULL,
242 `VehicleBlockTime` int(11) NOT NULL,
243 `WalkingStyle` int(11) NOT NULL,
244 `Wardrobe` int(11) NOT NULL,
245 PRIMARY KEY (`Id`)
246) ENGINE=InnoDB DEFAULT CHARSET=latin1;
247
248-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_characters: ~0 rows (około)
249DELETE FROM `lsvrp_characters`;
250/*!40000 ALTER TABLE `lsvrp_characters` DISABLE KEYS */;
251/*!40000 ALTER TABLE `lsvrp_characters` ENABLE KEYS */;
252
253-- Zrzut struktury tabela lsvrp_test.lsvrp_characters_drugs
254CREATE TABLE IF NOT EXISTS `lsvrp_characters_drugs` (
255 `Id` int(11) NOT NULL AUTO_INCREMENT,
256 `Amphetamine` int(11) NOT NULL,
257 `AmphetamineTime` int(11) NOT NULL,
258 `CharId` int(11) NOT NULL,
259 `Cocaine` int(11) NOT NULL,
260 `CocaineTime` int(11) NOT NULL,
261 `Hash` int(11) NOT NULL,
262 `HashTime` int(11) NOT NULL,
263 `Heroin` int(11) NOT NULL,
264 `HeroinTime` int(11) NOT NULL,
265 `Lsd` int(11) NOT NULL,
266 `LsdTime` int(11) NOT NULL,
267 `Marijuana` int(11) NOT NULL,
268 `MarijuanaTime` int(11) NOT NULL,
269 `MetaAmphetamine` int(11) NOT NULL,
270 `MetaAmphetamineTime` int(11) NOT NULL,
271 `Opium` int(11) NOT NULL,
272 `OpiumTime` int(11) NOT NULL,
273 PRIMARY KEY (`Id`)
274) ENGINE=InnoDB DEFAULT CHARSET=latin1;
275
276-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_characters_drugs: ~0 rows (około)
277DELETE FROM `lsvrp_characters_drugs`;
278/*!40000 ALTER TABLE `lsvrp_characters_drugs` DISABLE KEYS */;
279/*!40000 ALTER TABLE `lsvrp_characters_drugs` ENABLE KEYS */;
280
281-- Zrzut struktury tabela lsvrp_test.lsvrp_characters_groups
282CREATE TABLE IF NOT EXISTS `lsvrp_characters_groups` (
283 `Id` int(11) NOT NULL AUTO_INCREMENT,
284 `CharacterID` int(11) NOT NULL,
285 `CreatedAt` int(11) NOT NULL,
286 `DutyTime` int(11) NOT NULL,
287 `GroupID` int(11) NOT NULL,
288 `Payday` int(11) NOT NULL,
289 `PaydayAdded` int(11) NOT NULL,
290 `paydayDay` int(11) NOT NULL,
291 `PaydayTimestamp` int(11) NOT NULL,
292 `RankID` int(11) NOT NULL,
293 PRIMARY KEY (`Id`)
294) ENGINE=InnoDB DEFAULT CHARSET=latin1;
295
296-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_characters_groups: ~0 rows (około)
297DELETE FROM `lsvrp_characters_groups`;
298/*!40000 ALTER TABLE `lsvrp_characters_groups` DISABLE KEYS */;
299/*!40000 ALTER TABLE `lsvrp_characters_groups` ENABLE KEYS */;
300
301-- Zrzut struktury tabela lsvrp_test.lsvrp_characters_look
302CREATE TABLE IF NOT EXISTS `lsvrp_characters_look` (
303 `Id` int(11) NOT NULL AUTO_INCREMENT,
304 `Aging` int(11) NOT NULL,
305 `Beard` int(11) NOT NULL,
306 `BeardColor` int(11) NOT NULL,
307 `Blush` int(11) NOT NULL,
308 `BlushColor` int(11) NOT NULL,
309 `BoneHeight` float NOT NULL,
310 `BoneWidth` float NOT NULL,
311 `Burns` int(11) NOT NULL,
312 `CharId` int(11) NOT NULL,
313 `CheeksWidth` float NOT NULL,
314 `Chesthair` int(11) NOT NULL,
315 `ChesthairColor` int(11) NOT NULL,
316 `ChinLength` float NOT NULL,
317 `ChinPosition` float NOT NULL,
318 `ChinShape` float NOT NULL,
319 `ChinWidth` float NOT NULL,
320 `ColorMix` float NOT NULL,
321 `Complexion` int(11) NOT NULL,
322 `Eyebrows` int(11) NOT NULL,
323 `EyebrowsColor` int(11) NOT NULL,
324 `EyebrowsHeight` float NOT NULL,
325 `EyebrowsWidth` float NOT NULL,
326 `EyesWidth` float NOT NULL,
327 `Father` int(11) NOT NULL,
328 `Freckles` int(11) NOT NULL,
329 `Hair` int(11) NOT NULL,
330 `HairColor` int(11) NOT NULL,
331 `JawHeight` float NOT NULL,
332 `JawWidth` float NOT NULL,
333 `LipsWidth` float NOT NULL,
334 `Lipstick` int(11) NOT NULL,
335 `LipstickColor` int(11) NOT NULL,
336 `Makeup` int(11) NOT NULL,
337 `Mother` int(11) NOT NULL,
338 `NeckLength` float NOT NULL,
339 `NoseBridge` float NOT NULL,
340 `NoseEnd` float NOT NULL,
341 `NoseHeight` float NOT NULL,
342 `NoseLength` float NOT NULL,
343 `NoseShift` float NOT NULL,
344 `NoseWidth` float NOT NULL,
345 `Scars` int(11) NOT NULL,
346 `SkinMix` float NOT NULL,
347 PRIMARY KEY (`Id`)
348) ENGINE=InnoDB DEFAULT CHARSET=latin1;
349
350-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_characters_look: ~0 rows (około)
351DELETE FROM `lsvrp_characters_look`;
352/*!40000 ALTER TABLE `lsvrp_characters_look` DISABLE KEYS */;
353/*!40000 ALTER TABLE `lsvrp_characters_look` ENABLE KEYS */;
354
355-- Zrzut struktury tabela lsvrp_test.lsvrp_character_tattoos
356CREATE TABLE IF NOT EXISTS `lsvrp_character_tattoos` (
357 `Id` int(11) NOT NULL AUTO_INCREMENT,
358 `CharId` int(11) NOT NULL,
359 `TattooId` int(11) NOT NULL,
360 PRIMARY KEY (`Id`)
361) ENGINE=InnoDB DEFAULT CHARSET=latin1;
362
363-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_character_tattoos: ~0 rows (około)
364DELETE FROM `lsvrp_character_tattoos`;
365/*!40000 ALTER TABLE `lsvrp_character_tattoos` DISABLE KEYS */;
366/*!40000 ALTER TABLE `lsvrp_character_tattoos` ENABLE KEYS */;
367
368-- Zrzut struktury tabela lsvrp_test.lsvrp_clothset
369CREATE TABLE IF NOT EXISTS `lsvrp_clothset` (
370 `Id` int(11) NOT NULL AUTO_INCREMENT,
371 `Accessories` int(11) NOT NULL,
372 `AccessoriesTexture` int(11) NOT NULL,
373 `Boots` int(11) NOT NULL,
374 `BootsTexture` int(11) NOT NULL,
375 `CharId` int(11) NOT NULL,
376 `Ears` int(11) NOT NULL,
377 `EarsTexture` int(11) NOT NULL,
378 `Glasses` int(11) NOT NULL,
379 `GlassesTexture` int(11) NOT NULL,
380 `Hat` int(11) NOT NULL,
381 `HatTexture` int(11) NOT NULL,
382 `Legs` int(11) NOT NULL,
383 `LegsTexture` int(11) NOT NULL,
384 `Name` text,
385 `Tops` int(11) NOT NULL,
386 `TopsTexture` int(11) NOT NULL,
387 `TorsoId` int(11) NOT NULL,
388 `Undershirt` int(11) NOT NULL,
389 `UndershirtTexture` int(11) NOT NULL,
390 PRIMARY KEY (`Id`)
391) ENGINE=InnoDB DEFAULT CHARSET=latin1;
392
393-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_clothset: ~0 rows (około)
394DELETE FROM `lsvrp_clothset`;
395/*!40000 ALTER TABLE `lsvrp_clothset` DISABLE KEYS */;
396/*!40000 ALTER TABLE `lsvrp_clothset` ENABLE KEYS */;
397
398-- Zrzut struktury tabela lsvrp_test.lsvrp_corners
399CREATE TABLE IF NOT EXISTS `lsvrp_corners` (
400 `Id` int(11) NOT NULL AUTO_INCREMENT,
401 `Dimension` int(11) NOT NULL,
402 `HighRisk` bit(1) NOT NULL,
403 `Name` text,
404 `Owner` int(11) NOT NULL,
405 `X` double NOT NULL,
406 `Y` double NOT NULL,
407 `Z` double NOT NULL,
408 PRIMARY KEY (`Id`)
409) ENGINE=InnoDB DEFAULT CHARSET=latin1;
410
411-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_corners: ~0 rows (około)
412DELETE FROM `lsvrp_corners`;
413/*!40000 ALTER TABLE `lsvrp_corners` DISABLE KEYS */;
414/*!40000 ALTER TABLE `lsvrp_corners` ENABLE KEYS */;
415
416-- Zrzut struktury tabela lsvrp_test.lsvrp_drugs_effects
417CREATE TABLE IF NOT EXISTS `lsvrp_drugs_effects` (
418 `Id` int(11) NOT NULL AUTO_INCREMENT,
419 `EffectName` text,
420 PRIMARY KEY (`Id`)
421) ENGINE=InnoDB DEFAULT CHARSET=latin1;
422
423-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_drugs_effects: ~0 rows (około)
424DELETE FROM `lsvrp_drugs_effects`;
425/*!40000 ALTER TABLE `lsvrp_drugs_effects` DISABLE KEYS */;
426/*!40000 ALTER TABLE `lsvrp_drugs_effects` ENABLE KEYS */;
427
428-- Zrzut struktury tabela lsvrp_test.lsvrp_groups
429CREATE TABLE IF NOT EXISTS `lsvrp_groups` (
430 `Id` int(11) NOT NULL AUTO_INCREMENT,
431 `Cash` int(11) NOT NULL,
432 `Code` text,
433 `ColorB` int(11) NOT NULL,
434 `ColorG` int(11) NOT NULL,
435 `ColorR` int(11) NOT NULL,
436 `CreatedAt` int(11) NOT NULL,
437 `DefaultRank` int(11) NOT NULL,
438 `Donation` int(11) NOT NULL,
439 `Name` text,
440 `ordersType` int(11) NOT NULL,
441 `Permissions` text,
442 `SpawnDimension` int(11) NOT NULL,
443 `SpawnX` double NOT NULL,
444 `SpawnY` double NOT NULL,
445 `SpawnZ` double NOT NULL,
446 `Status` int(11) NOT NULL,
447 `SuperLeaderID` int(11) NOT NULL,
448 `Type` int(11) NOT NULL,
449 PRIMARY KEY (`Id`)
450) ENGINE=InnoDB DEFAULT CHARSET=latin1;
451
452-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_groups: ~0 rows (około)
453DELETE FROM `lsvrp_groups`;
454/*!40000 ALTER TABLE `lsvrp_groups` DISABLE KEYS */;
455/*!40000 ALTER TABLE `lsvrp_groups` ENABLE KEYS */;
456
457-- Zrzut struktury tabela lsvrp_test.lsvrp_groups_account_logs
458CREATE TABLE IF NOT EXISTS `lsvrp_groups_account_logs` (
459 `Id` int(11) NOT NULL AUTO_INCREMENT,
460 `Change` int(11) NOT NULL,
461 `GroupID` int(11) NOT NULL,
462 `Message` text,
463 `NewBalance` int(11) NOT NULL,
464 `Timestamp` int(11) NOT NULL,
465 PRIMARY KEY (`Id`)
466) ENGINE=InnoDB DEFAULT CHARSET=latin1;
467
468-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_groups_account_logs: ~0 rows (około)
469DELETE FROM `lsvrp_groups_account_logs`;
470/*!40000 ALTER TABLE `lsvrp_groups_account_logs` DISABLE KEYS */;
471/*!40000 ALTER TABLE `lsvrp_groups_account_logs` ENABLE KEYS */;
472
473-- Zrzut struktury tabela lsvrp_test.lsvrp_groups_duty
474CREATE TABLE IF NOT EXISTS `lsvrp_groups_duty` (
475 `Id` int(11) NOT NULL AUTO_INCREMENT,
476 `CharID` int(11) NOT NULL,
477 `EndTime` int(11) NOT NULL,
478 `GroupID` int(11) NOT NULL,
479 `StartTime` int(11) NOT NULL,
480 PRIMARY KEY (`Id`)
481) ENGINE=InnoDB DEFAULT CHARSET=latin1;
482
483-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_groups_duty: ~0 rows (około)
484DELETE FROM `lsvrp_groups_duty`;
485/*!40000 ALTER TABLE `lsvrp_groups_duty` DISABLE KEYS */;
486/*!40000 ALTER TABLE `lsvrp_groups_duty` ENABLE KEYS */;
487
488-- Zrzut struktury tabela lsvrp_test.lsvrp_groups_ranks
489CREATE TABLE IF NOT EXISTS `lsvrp_groups_ranks` (
490 `Id` int(11) NOT NULL AUTO_INCREMENT,
491 `CreatedAt` int(11) NOT NULL,
492 `GroupID` int(11) NOT NULL,
493 `Level` int(11) NOT NULL,
494 `Name` text,
495 `Permissions` text,
496 PRIMARY KEY (`Id`)
497) ENGINE=InnoDB DEFAULT CHARSET=latin1;
498
499-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_groups_ranks: ~0 rows (około)
500DELETE FROM `lsvrp_groups_ranks`;
501/*!40000 ALTER TABLE `lsvrp_groups_ranks` DISABLE KEYS */;
502/*!40000 ALTER TABLE `lsvrp_groups_ranks` ENABLE KEYS */;
503
504-- Zrzut struktury tabela lsvrp_test.lsvrp_houses
505CREATE TABLE IF NOT EXISTS `lsvrp_houses` (
506 `Id` int(11) NOT NULL AUTO_INCREMENT,
507 `BoughtTimestamp` int(11) NOT NULL,
508 `Dimension` int(11) NOT NULL,
509 `Name` text,
510 `Price` int(11) NOT NULL,
511 PRIMARY KEY (`Id`)
512) ENGINE=InnoDB DEFAULT CHARSET=latin1;
513
514-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_houses: ~0 rows (około)
515DELETE FROM `lsvrp_houses`;
516/*!40000 ALTER TABLE `lsvrp_houses` DISABLE KEYS */;
517/*!40000 ALTER TABLE `lsvrp_houses` ENABLE KEYS */;
518
519-- Zrzut struktury tabela lsvrp_test.lsvrp_interiors
520CREATE TABLE IF NOT EXISTS `lsvrp_interiors` (
521 `Id` int(11) NOT NULL AUTO_INCREMENT,
522 `Created` int(11) NOT NULL,
523 `Dimension` int(11) NOT NULL,
524 `ForSale` bit(1) NOT NULL,
525 `Name` text,
526 `Owner` int(11) NOT NULL,
527 `OwnerType` int(11) NOT NULL,
528 `SalePrice` int(11) NOT NULL,
529 PRIMARY KEY (`Id`)
530) ENGINE=InnoDB DEFAULT CHARSET=latin1;
531
532-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_interiors: ~0 rows (około)
533DELETE FROM `lsvrp_interiors`;
534/*!40000 ALTER TABLE `lsvrp_interiors` DISABLE KEYS */;
535/*!40000 ALTER TABLE `lsvrp_interiors` ENABLE KEYS */;
536
537-- Zrzut struktury tabela lsvrp_test.lsvrp_interiors_doors
538CREATE TABLE IF NOT EXISTS `lsvrp_interiors_doors` (
539 `Id` int(11) NOT NULL AUTO_INCREMENT,
540 `Blip` int(11) NOT NULL,
541 `Created` int(11) NOT NULL,
542 `InAngle` float NOT NULL,
543 `InDim` int(11) NOT NULL,
544 `InX` float NOT NULL,
545 `InY` float NOT NULL,
546 `InZ` float NOT NULL,
547 `Locked` bit(1) NOT NULL,
548 `Name` text,
549 `OutAngle` float NOT NULL,
550 `OutDim` int(11) NOT NULL,
551 `OutX` float NOT NULL,
552 `OutY` float NOT NULL,
553 `OutZ` float NOT NULL,
554 `ParentID` int(11) NOT NULL,
555 `Vehicles` int(11) NOT NULL,
556 PRIMARY KEY (`Id`)
557) ENGINE=InnoDB DEFAULT CHARSET=latin1;
558
559-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_interiors_doors: ~0 rows (około)
560DELETE FROM `lsvrp_interiors_doors`;
561/*!40000 ALTER TABLE `lsvrp_interiors_doors` DISABLE KEYS */;
562/*!40000 ALTER TABLE `lsvrp_interiors_doors` ENABLE KEYS */;
563
564-- Zrzut struktury tabela lsvrp_test.lsvrp_items
565CREATE TABLE IF NOT EXISTS `lsvrp_items` (
566 `Id` int(11) NOT NULL AUTO_INCREMENT,
567 `Dimension` int(11) NOT NULL,
568 `Flag` int(11) NOT NULL,
569 `FlagType` int(11) NOT NULL,
570 `LastUsed` int(11) NOT NULL,
571 `Name` varchar(255) DEFAULT NULL,
572 `Owner` int(11) NOT NULL,
573 `OwnerType` int(11) NOT NULL,
574 `RotZ` double NOT NULL,
575 `Type` int(11) NOT NULL,
576 `Value1` int(11) NOT NULL,
577 `Value2` int(11) NOT NULL,
578 `Value3` text,
579 `X` double NOT NULL,
580 `Y` double NOT NULL,
581 `Z` double NOT NULL,
582 PRIMARY KEY (`Id`)
583) ENGINE=InnoDB DEFAULT CHARSET=latin1;
584
585-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_items: ~0 rows (około)
586DELETE FROM `lsvrp_items`;
587/*!40000 ALTER TABLE `lsvrp_items` DISABLE KEYS */;
588/*!40000 ALTER TABLE `lsvrp_items` ENABLE KEYS */;
589
590-- Zrzut struktury tabela lsvrp_test.lsvrp_login_logs
591CREATE TABLE IF NOT EXISTS `lsvrp_login_logs` (
592 `Id` int(11) NOT NULL AUTO_INCREMENT,
593 `ip` text,
594 `memberID` int(11) NOT NULL,
595 `serial` text,
596 `success` bit(1) NOT NULL,
597 `time` int(11) NOT NULL,
598 PRIMARY KEY (`Id`)
599) ENGINE=InnoDB DEFAULT CHARSET=latin1;
600
601-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_login_logs: ~0 rows (około)
602DELETE FROM `lsvrp_login_logs`;
603/*!40000 ALTER TABLE `lsvrp_login_logs` DISABLE KEYS */;
604/*!40000 ALTER TABLE `lsvrp_login_logs` ENABLE KEYS */;
605
606-- Zrzut struktury tabela lsvrp_test.lsvrp_logs
607CREATE TABLE IF NOT EXISTS `lsvrp_logs` (
608 `Id` int(11) NOT NULL AUTO_INCREMENT,
609 `LogContent` text,
610 `LogOwner` int(11) NOT NULL,
611 `LogOwnerType` int(11) NOT NULL,
612 `LogTime` int(11) NOT NULL,
613 `LogType` text,
614 PRIMARY KEY (`Id`)
615) ENGINE=InnoDB DEFAULT CHARSET=latin1;
616
617-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_logs: ~0 rows (około)
618DELETE FROM `lsvrp_logs`;
619/*!40000 ALTER TABLE `lsvrp_logs` DISABLE KEYS */;
620/*!40000 ALTER TABLE `lsvrp_logs` ENABLE KEYS */;
621
622-- Zrzut struktury tabela lsvrp_test.lsvrp_magazines
623CREATE TABLE IF NOT EXISTS `lsvrp_magazines` (
624 `Id` int(11) NOT NULL AUTO_INCREMENT,
625 `FlagType` bit(1) NOT NULL,
626 `GroupID` int(11) NOT NULL,
627 `ItemName` text,
628 `ItemType` int(11) NOT NULL,
629 `ItemValue1` int(11) NOT NULL,
630 `ItemValue2` int(11) NOT NULL,
631 `ItemValue3` text,
632 `Price` int(11) NOT NULL,
633 `Stock` int(11) NOT NULL,
634 PRIMARY KEY (`Id`)
635) ENGINE=InnoDB DEFAULT CHARSET=latin1;
636
637-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_magazines: ~0 rows (około)
638DELETE FROM `lsvrp_magazines`;
639/*!40000 ALTER TABLE `lsvrp_magazines` DISABLE KEYS */;
640/*!40000 ALTER TABLE `lsvrp_magazines` ENABLE KEYS */;
641
642-- Zrzut struktury tabela lsvrp_test.lsvrp_objects
643CREATE TABLE IF NOT EXISTS `lsvrp_objects` (
644 `Id` int(11) NOT NULL AUTO_INCREMENT,
645 `Alpha` int(11) NOT NULL,
646 `VirtualWorld` int(11) NOT NULL,
647 `Doors` int(11) NOT NULL,
648 `Model` int(11) NOT NULL,
649 `PosX` float NOT NULL,
650 `PosY` float NOT NULL,
651 `PosZ` float NOT NULL,
652 `RotX` float NOT NULL,
653 `RotY` float NOT NULL,
654 `RotZ` float NOT NULL,
655 PRIMARY KEY (`Id`)
656) ENGINE=InnoDB DEFAULT CHARSET=latin1;
657
658-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_objects: ~0 rows (około)
659DELETE FROM `lsvrp_objects`;
660/*!40000 ALTER TABLE `lsvrp_objects` DISABLE KEYS */;
661/*!40000 ALTER TABLE `lsvrp_objects` ENABLE KEYS */;
662
663-- Zrzut struktury tabela lsvrp_test.lsvrp_orders
664CREATE TABLE IF NOT EXISTS `lsvrp_orders` (
665 `Id` int(11) NOT NULL AUTO_INCREMENT,
666 `Flag` bit(1) NOT NULL,
667 `GroupId` int(11) NOT NULL,
668 `Name` text,
669 `Price` int(11) NOT NULL,
670 `Type` int(11) NOT NULL,
671 `Value1` int(11) NOT NULL,
672 `Value2` int(11) NOT NULL,
673 `Value3` text,
674 PRIMARY KEY (`Id`)
675) ENGINE=InnoDB DEFAULT CHARSET=latin1;
676
677-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_orders: ~0 rows (około)
678DELETE FROM `lsvrp_orders`;
679/*!40000 ALTER TABLE `lsvrp_orders` DISABLE KEYS */;
680/*!40000 ALTER TABLE `lsvrp_orders` ENABLE KEYS */;
681
682-- Zrzut struktury tabela lsvrp_test.lsvrp_orders_pending
683CREATE TABLE IF NOT EXISTS `lsvrp_orders_pending` (
684 `Id` int(11) NOT NULL AUTO_INCREMENT,
685 `Count` int(11) NOT NULL,
686 `CreatedAt` int(11) NOT NULL,
687 `GroupId` int(11) NOT NULL,
688 `Name` text,
689 `OrderId` int(11) NOT NULL,
690 PRIMARY KEY (`Id`)
691) ENGINE=InnoDB DEFAULT CHARSET=latin1;
692
693-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_orders_pending: ~0 rows (około)
694DELETE FROM `lsvrp_orders_pending`;
695/*!40000 ALTER TABLE `lsvrp_orders_pending` DISABLE KEYS */;
696/*!40000 ALTER TABLE `lsvrp_orders_pending` ENABLE KEYS */;
697
698-- Zrzut struktury tabela lsvrp_test.lsvrp_penalties
699CREATE TABLE IF NOT EXISTS `lsvrp_penalties` (
700 `Id` int(11) NOT NULL AUTO_INCREMENT,
701 `AdminID` int(11) NOT NULL,
702 `Expired` int(11) NOT NULL,
703 `Reason` text,
704 `TargetGlobalID` int(11) NOT NULL,
705 `TargetID` int(11) NOT NULL,
706 `TimeStamp` int(11) NOT NULL,
707 `Type` int(11) NOT NULL,
708 PRIMARY KEY (`Id`)
709) ENGINE=InnoDB DEFAULT CHARSET=latin1;
710
711-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_penalties: ~0 rows (około)
712DELETE FROM `lsvrp_penalties`;
713/*!40000 ALTER TABLE `lsvrp_penalties` DISABLE KEYS */;
714/*!40000 ALTER TABLE `lsvrp_penalties` ENABLE KEYS */;
715
716-- Zrzut struktury tabela lsvrp_test.lsvrp_vehicles
717CREATE TABLE IF NOT EXISTS `lsvrp_vehicles` (
718 `Id` int(11) NOT NULL AUTO_INCREMENT,
719 `AssigningId` int(11) NOT NULL,
720 `BlockValue` int(11) NOT NULL,
721 `Blocked` bit(1) NOT NULL,
722 `closed` bit(1) NOT NULL,
723 `Cruise` int(11) NOT NULL,
724 `dimension` int(11) NOT NULL,
725 `Extras` text,
726 `color1` int(11) NOT NULL,
727 `Fuel` double NOT NULL,
728 `FuelMultiplier` double NOT NULL,
729 `Health` float NOT NULL,
730 `Livery` int(11) NOT NULL,
731 `MaxFuel` double NOT NULL,
732 `Mileage` double NOT NULL,
733 `Modifications` text,
734 `Name` text,
735 `plate` text,
736 `Owner` int(11) NOT NULL,
737 `OwnerType` int(11) NOT NULL,
738 `PlateType` int(11) NOT NULL,
739 `RX` float NOT NULL,
740 `RY` float NOT NULL,
741 `RZ` float NOT NULL,
742 `color2` int(11) NOT NULL,
743 `spawned` bit(1) NOT NULL,
744 `VehicleHash` bigint(20) NOT NULL,
745 `X` float NOT NULL,
746 `Y` float NOT NULL,
747 `Z` float NOT NULL,
748 PRIMARY KEY (`Id`)
749) ENGINE=InnoDB DEFAULT CHARSET=latin1;
750
751-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_vehicles: ~0 rows (około)
752DELETE FROM `lsvrp_vehicles`;
753/*!40000 ALTER TABLE `lsvrp_vehicles` DISABLE KEYS */;
754/*!40000 ALTER TABLE `lsvrp_vehicles` ENABLE KEYS */;
755
756-- Zrzut struktury tabela lsvrp_test.lsvrp_vehicles_fuel
757CREATE TABLE IF NOT EXISTS `lsvrp_vehicles_fuel` (
758 `VehicleName` varchar(767) NOT NULL,
759 `Consumption` float NOT NULL,
760 `MaxFuel` int(11) NOT NULL,
761 PRIMARY KEY (`VehicleName`)
762) ENGINE=InnoDB DEFAULT CHARSET=latin1;
763
764-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_vehicles_fuel: ~0 rows (około)
765DELETE FROM `lsvrp_vehicles_fuel`;
766/*!40000 ALTER TABLE `lsvrp_vehicles_fuel` DISABLE KEYS */;
767/*!40000 ALTER TABLE `lsvrp_vehicles_fuel` ENABLE KEYS */;
768
769-- Zrzut struktury tabela lsvrp_test.lsvrp_vehicle_mods
770CREATE TABLE IF NOT EXISTS `lsvrp_vehicle_mods` (
771 `Id` int(11) NOT NULL AUTO_INCREMENT,
772 `ModId` int(11) NOT NULL,
773 `ModVal` int(11) NOT NULL,
774 `VehicleId` int(11) NOT NULL,
775 PRIMARY KEY (`Id`)
776) ENGINE=InnoDB DEFAULT CHARSET=latin1;
777
778-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_vehicle_mods: ~0 rows (około)
779DELETE FROM `lsvrp_vehicle_mods`;
780/*!40000 ALTER TABLE `lsvrp_vehicle_mods` DISABLE KEYS */;
781/*!40000 ALTER TABLE `lsvrp_vehicle_mods` ENABLE KEYS */;
782
783-- Zrzut struktury tabela lsvrp_test.lsvrp_walkingstyles
784CREATE TABLE IF NOT EXISTS `lsvrp_walkingstyles` (
785 `Id` int(11) NOT NULL AUTO_INCREMENT,
786 `AnimName` text,
787 `Name` text,
788 PRIMARY KEY (`Id`)
789) ENGINE=InnoDB DEFAULT CHARSET=latin1;
790
791-- Zrzucanie danych dla tabeli lsvrp_test.lsvrp_walkingstyles: ~0 rows (około)
792DELETE FROM `lsvrp_walkingstyles`;
793/*!40000 ALTER TABLE `lsvrp_walkingstyles` DISABLE KEYS */;
794/*!40000 ALTER TABLE `lsvrp_walkingstyles` ENABLE KEYS */;
795
796-- Zrzut struktury tabela lsvrp_test.__efmigrationshistory
797CREATE TABLE IF NOT EXISTS `__efmigrationshistory` (
798 `MigrationId` varchar(150) NOT NULL,
799 `ContextKey` varchar(300) NOT NULL,
800 `Model` longblob NOT NULL,
801 `ProductVersion` varchar(32) NOT NULL
802) ENGINE=InnoDB DEFAULT CHARSET=utf8;
803
804-- Zrzucanie danych dla tabeli lsvrp_test.__efmigrationshistory: ~1 rows (około)
805DELETE FROM `__efmigrationshistory`;
806/*!40000 ALTER TABLE `__efmigrationshistory` DISABLE KEYS */;
807INSERT INTO `__efmigrationshistory` (`MigrationId`, `ContextKey`, `Model`, `ProductVersion`) VALUES
808 ('20181216122958_baza', '', _binary '', '2.0.3-rtm-10026');
809/*!40000 ALTER TABLE `__efmigrationshistory` ENABLE KEYS */;
810
811/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
812/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
813/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;