Vehicles SQL

Heres my current dump, which doesnt look right to me, so I am after replacing it with an untouched dump if you know what I mean.

Code:
--
-- Dumping data for table `vehicle`
--
 
INSERT INTO `vehicle` (`id`, `class_name`, `damage_min`, `damage_max`, `fuel_min`, `fuel_max`, `limit_min`, `limit_max`, `parts`, `inventory`) VALUES
(1, 'UAZ_Unarmed_TK_EP1', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["20Rnd_762x51_DMR"], [5]], [[], []]]'),
(2, 'UAZ_Unarmed_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 0, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["10Rnd_127x99_m107"], [5]], [[], []]]'),
(3, 'UAZ_Unarmed_UN_EP1', 0.100, 0.700, 0.200, 0.800, 0, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["30Rnd_556x45_StanagSD"], [5]], [[], []]]'),
(4, 'UAZ_RU', 0.100, 0.700, 0.200, 0.800, 0, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["HandGrenade_west"], [5]], [[], []]]'),
(5, 'ATV_US_EP1', 0.100, 0.700, 0.200, 0.800, 0, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemTent", "ItemMatchbox"], [1, 1]], [[], []]]'),
(6, 'ATV_CZ_EP1', 0.100, 0.700, 0.200, 0.800, 0, 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]], [[], []]]'),
(7, 'SkodaBlue', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemWatch", "ItemKnife"], [1, 1]], [[], []]]'),
(8, 'Skoda', 0.100, 0.700, 0.200, 0.800, 0, 2, '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]]]'),
(9, 'SkodaGreen', 0.100, 0.700, 0.200, 0.800, 0, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemMatchbox", "ItemMap"], [1, 1]], [[], []]]'),
(10, 'TT650_Ins', 0.100, 0.700, 0.200, 0.800, 0, 3, 'motor', '[[[], []], [["ItemJerrycan"], [1]], [[], []]]'),
(11, 'TT650_TK_EP1', 0.100, 0.700, 0.200, 0.800, 0, 4, 'motor', '[[[], []], [["PartGeneric"], [1]], [[], []]]'),
(12, 'TT650_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 0, 3, 'motor', '[[[], []], [["PartWheel"], [1]], [[], []]]'),
(13, 'Old_bike_TK_CIV_EP1', 0.000, 0.000, 0.000, 0.000, 5, 5, NULL, '[]'),
(14, 'Old_bike_TK_INS_EP1', 0.000, 0.000, 0.000, 0.000, 5, 5, NULL, '[]'),
(15, 'UH1H_DZ', 0.100, 0.700, 0.200, 0.800, 0, 4, 'motor,elektronika,mala vrtule,velka vrtule', '[[[], []], [["ItemSodaCoke"], [5]], [[], []]]'),
(16, 'hilux1_civil_3_open', 0.100, 0.700, 0.200, 0.800, 0, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartFueltank", "PartWheel"], [1, 1]], [[], []]]'),
(17, 'Ikarus_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 0, 1, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemWatch", "ItemSodaPepsi"], [1, 3]], [[], []]]'),
(18, 'Ikarus', 0.100, 0.700, 0.200, 0.800, 0, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartWheel", "ItemSodaCoke"], [1, 3]], [[], []]]'),
(19, 'Tractor', 0.100, 0.700, 0.200, 0.800, 0, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemWire", "ItemJerrycan"], [1, 1]], [[], []]]'),
(20, 'S1203_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 0, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[["Makarov"], [1]], [["FoodCanBakedBeans"], [3]], [[], []]]'),
(21, 'V3S_Civ', 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', '[[["MR43"], [1]], [["PartEngine"], [1]], [[], []]]'),
(22, 'UralCivil', 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', '[[[], []], [["PartWheel", "ItemToolbox", "ItemTankTrap"], [1, 1, 1]], [[], []]]'),
(23, 'car_hatchback', 0.100, 0.700, 0.200, 0.800, 0, 5, '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]], [[], []]]'),
(24, 'Fishing_Boat', 0.100, 0.700, 0.200, 0.800, 0, 2, 'motor', '[]'),
(25, 'PBX', 0.100, 0.700, 0.200, 0.800, 1, 1, 'motor', '[[[], []], [["ItemFlashlightRed"], [1]], [["DZ_Backpack_EP1"], [1]]]'),
(26, 'Smallboat_1', 0.100, 0.700, 0.200, 0.800, 0, 1, 'motor', '[]'),
(27, 'Volha_2_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 0, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemSodaPepsi", "FoodCanFrankBeans"], [3, 3]], [[], []]]'),
(28, 'Volha_1_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 0, 2, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["ItemSodaCoke", "FoodCanBakedBeans"], [3, 3]], [[], []]]'),
(29, 'SUV_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', '[[[], []], [["Pipebomb"], [1]], [[], []]]'),
(30, 'car_sedan', 0.100, 0.700, 0.200, 0.800, 0, 4, '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]]]'),
(31, 'hilux1_civil_3_open_EP1', 0.100, 0.700, 0.200, 0.800, 0, 4, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[[[], []], [["PartEngine", "ItemJerrycan"], [1, 1]], [[], []]]'),
(32, 'UralCivil2', 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', '[[[], []], [["PartVRotor", "ItemMorphine", "FoodCanPasta"], [1, 1, 1]], [[], []]]'),
(33, 'LandRover_CZ_EP1', 0.100, 0.700, 0.200, 0.800, 0, 3, '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]], [[], []]]'),
(34, 'Ka60_GL_NAC', 0.100, 0.700, 0.200, 0.800, 1, 1, 'motor,elektronika,mala vrtule,velka vrtule', '[]'),
(35, 'Mi17_Civilian_Nam', 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', '[]'),
(36, 'BW_Ikarus1', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(37, 'BW_Ikarus2', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(38, 'kpfs_golf_g', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(39, 'kpfs_golf_p', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(40, 'kpfs_golf_post', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(41, 'kpfs_golf_tk', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(42, 'Lada1_GDR', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(43, 'Lada2_GDR', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(44, 'Lada2_TK_CIV_EP1', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(45, 'Lada4_GDR', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(46, 'Lada5_GDR', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(47, 'TT650_Civ', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(48, 'TT650_Gue', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(49, 'MTVR', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(50, 'M1030_US_DES_EP1', 0.100, 0.700, 0.200, 0.800, 0, 5, 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]'),
(51, 'smallboat_2', 0.100, 0.700, 0.200, 0.800, 0, 5, 'motor', '[]'),
(52, 'Post_bike_E', 0.100, 0.700, 0.200, 0.800, 0, 5, '', '[]'),
(16988, 'UAZ_CDF', 0.000, 0.000, 1.000, 1.000, 0, 10, NULL, '[]'),
(31288, 'Mi17_DZ', 0.000, 0.000, 1.000, 1.000, 0, 5, NULL, '[]'),
(44380, 'AH6X_DZ', 0.000, 0.000, 1.000, 1.000, 0, 3, NULL, '[]');
 
thats not unmodified.. you are running reality i guess?

the ones i posted are from the vanilla chernarus :)
 
Back
Top