· 7 years ago · Jan 22, 2019, 06:36 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.5.22 - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL version: 7.0.0.4053
6-- Date/time: 2012-10-16 04:05:02
7-- --------------------------------------------------------
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
12
13-- Dumping structure for table bliss.vehicle
14CREATE TABLE IF NOT EXISTS `vehicle` (
15 `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
16 `class_name` varchar(100) DEFAULT NULL,
17 `damage_min` decimal(4,3) NOT NULL DEFAULT '0.100',
18 `damage_max` decimal(4,3) NOT NULL DEFAULT '0.700',
19 `fuel_min` decimal(4,3) NOT NULL DEFAULT '0.200',
20 `fuel_max` decimal(4,3) NOT NULL DEFAULT '0.800',
21 `limit_min` tinyint(3) unsigned NOT NULL DEFAULT '0',
22 `limit_max` tinyint(3) unsigned NOT NULL DEFAULT '0',
23 `parts` varchar(1024) DEFAULT NULL,
24 `inventory` varchar(2048) NOT NULL DEFAULT '[]',
25 PRIMARY KEY (`id`),
26 UNIQUE KEY `uq1_vehicle` (`class_name`),
27 KEY `idx1_vehicle` (`class_name`)
28) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;
29
30-- Dumping data for table bliss.vehicle: ~33 rows (approximately)
31/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
32INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES
33 (1, 'UAZ_Unarmed_TK_EP1', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["20Rnd_762x51_DMR"], [5]], [[], []]]'),
34 (2, 'UAZ_Unarmed_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["10Rnd_127x99_m107"], [5]], [[], []]]'),
35 (3, 'UAZ_Unarmed_UN_EP1', 0.100, 0.700, 0.200, 0.800, 1, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["30Rnd_556x45_StanagSD"], [5]], [[], []]]'),
36 (4, 'UAZ_RU', 0.100, 0.700, 0.200, 0.800, 1, 3, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["HandGrenade_east"], [5]], [[], []]]'),
37 (5, 'ATV_US_EP1', 0.100, 0.700, 0.200, 0.800, 1, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemTent", "ItemMatchbox"], [1, 1]], [[], []]]'),
38 (6, 'ATV_CZ_EP1', 0.100, 0.700, 0.200, 0.800, 1, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["Skin_Camo1_DZ", "ItemCompass"], [1, 1]], [[], []]]'),
39 (7, 'SkodaBlue', 0.100, 0.700, 0.200, 0.800, 1, 3, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemWatch", "ItemKnife"], [1, 1]], [[], []]]'),
40 (8, 'Skoda', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[["Binocular"], [1]], [[], []], [["CZ_VestPouch_EP1"], [1]]]'),
41 (9, 'SkodaGreen', 0.100, 0.700, 0.200, 0.800, 1, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemMatchbox", "ItemMap"], [1, 1]], [[], []]]'),
42 (10, 'TT650_Ins', 0.100, 0.700, 0.200, 0.800, 1, 1, 'motor', '[[[], []], [["ItemJerrycan"], [1]], [[], []]]'),
43 (11, 'TT650_TK_EP1', 0.100, 0.700, 0.200, 0.800, 1, 2, 'motor', '[[[], []], [["PartGeneric"], [1]], [[], []]]'),
44 (12, 'TT650_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 1, 5, 'motor', '[[[], []], [["PartWheel"], [1]], [[], []]]'),
45 (13, 'Old_bike_TK_CIV_EP1', 0.000, 0.000, 0.000, 0.000, 5, 5, NULL, '[]'),
46 (14, 'Old_bike_TK_INS_EP1', 0.000, 0.000, 0.000, 0.000, 5, 5, NULL, '[]'),
47 (15, 'UH1H_DZ', 0.100, 0.700, 0.200, 0.800, 1, 3, 'motor,elektronika,mala vrtule,velka vrtule', '[[[], []], [["ItemSodaCoke"], [5]], [[], []]]'),
48 (16, 'hilux1_civil_3_open', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartFueltank", "PartWheel"], [1, 1]], [[], []]]'),
49 (17, 'Ikarus_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 1, 1, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemWatch", "ItemSodaPepsi"], [1, 3]], [[], []]]'),
50 (18, 'Ikarus', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartWheel", "ItemSodaCoke"], [1, 3]], [[], []]]'),
51 (19, 'Tractor', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemWire", "ItemJerrycan"], [1, 1]], [[], []]]'),
52 (20, 'S1203_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 1, 3, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[["Makarov"], [1]], [["FoodCanBakedBeans"], [3]], [[], []]]'),
53 (21, 'V3S_Civ', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[["MR43"], [1]], [["PartEngine"], [1]], [[], []]]'),
54 (22, 'UralCivil', 0.100, 0.700, 0.200, 0.800, 1, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartWheel", "ItemToolbox", "ItemTankTrap"], [1, 1, 1]], [[], []]]'),
55 (23, 'car_hatchback', 0.100, 0.700, 0.200, 0.800, 1, 1, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[["LeeEnfield"], [1]], [["5x_22_LR_17_HMR"], [3]], [[], []]]'),
56 (24, 'Fishing_Boat', 0.100, 0.700, 0.200, 0.800, 1, 2, 'motor', '[]'),
57 (25, 'PBX', 0.100, 0.700, 0.200, 0.800, 1, 1, 'motor', '[[[], []], [["ItemFlashlightRed"], [1]], [["DZ_Backpack_EP1"], [1]]]'),
58 (26, 'Smallboat_1', 0.100, 0.700, 0.200, 0.800, 1, 5, 'motor', '[]'),
59 (27, 'Volha_2_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 1, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemSodaPepsi", "FoodCanFrankBeans"], [3, 3]], [[], []]]'),
60 (28, 'Volha_1_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 1, 1, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemSodaCoke", "FoodCanBakedBeans"], [3, 3]], [[], []]]'),
61 (29, 'SUV_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 1, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["Pipebomb"], [1]], [[], []]]'),
62 (30, 'car_sedan', 0.100, 0.700, 0.200, 0.800, 1, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemFlashlight", "ItemMap"], [1, 1]], [["DZ_ALICE_Pack_EP1"], [1]]]'),
63 (31, 'hilux1_civil_3_open_EP1', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartEngine", "ItemJerrycan"], [1, 1]], [[], []]]'),
64 (32, 'UralCivil2', 0.100, 0.700, 0.200, 0.800, 1, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartVRotor", "ItemMorphine", "FoodCanPasta"], [1, 1, 1]], [[], []]]'),
65 (33, 'LandRover_CZ_EP1', 0.100, 0.700, 0.200, 0.800, 1, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[["AK_47_M"], [1]], [["ItemPainkiller"], [1]], [[], []]]');
66/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
67/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
68/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;