Citat: Fergosonn poslato Avgust 31, 2022, 20:00:09 POSLE PODNE
Daj kako cuvas log u mysql
ovo ili ?
[pawn]-- Table structure for table `vehicles`
--
CREATE TABLE `vehicles` (
`veh_id` int(11) NOT NULL,
`owner_sqlID` int(11) DEFAULT '0',
`v_price` int(11) NOT NULL,
`v_locked` tinyint(1) DEFAULT '0',
`v_pos_x` float NOT NULL,
`v_pos_y` float NOT NULL,
`v_pos_z` float NOT NULL,
`v_pos_a` float NOT NULL,
`v_virtualw` int(11) NOT NULL,
`v_interior` int(11) NOT NULL,
`v_usage` smallint(2) NOT NULL,
`v_organization` smallint(2) DEFAULT '0',
`v_job` smallint(2) DEFAULT '-1',
`v_fuel_station` smallint(2) DEFAULT '-1',
`v_color_1` int(11) NOT NULL,
`v_color_2` int(11) NOT NULL,
`v_model` int(11) NOT NULL,
`v_teh` smallint(2) DEFAULT '0',
`v_reg` smallint(2) DEFAULT '0',
`v_reg_vreme` smallint(3) DEFAULT '0',
`v_tablice` varchar(24) COLLATE utf8_unicode_ci DEFAULT 'NEMA',
`v_gps` smallint(2) DEFAULT '0',
`v_insurance` smallint(2) DEFAULT '0',
`v_lock` smallint(2) DEFAULT '0',
`v_alarm` smallint(2) DEFAULT '0',
`v_fuel` smallint(2) DEFAULT '40',
`v_fuel_type` smallint(2) DEFAULT '0',
`v_neon` int(11) DEFAULT '0',
`v_tuned` tinyint(1) DEFAULT '0',
`v_imobilizator` int(11) DEFAULT '0',
`v_spoiler` int(11) DEFAULT '0',
`v_hood` int(11) DEFAULT '0',
`v_roof` int(11) DEFAULT '0',
`v_skirt` int(11) DEFAULT '0',
`v_lamps` int(11) DEFAULT '0',
`v_nitro` int(11) DEFAULT '0',
`v_exhaust` int(11) DEFAULT '0',
`v_wheels` int(11) DEFAULT '0',
`v_stereo` int(11) DEFAULT '0',
`v_hydraulics` int(11) DEFAULT '0',
`v_front_bumper` int(11) DEFAULT '0',
`v_rear_bumper` int(11) DEFAULT '0',
`v_vents` int(11) DEFAULT '0',
`v_paintjob` int(11) DEFAULT '255',
`v_drug_id_6` int(11) DEFAULT '0',
`v_drug_ammount_1` int(11) DEFAULT '0',
`v_drug_ammount_2` int(11) DEFAULT '0',
`v_drug_ammount_3` int(11) DEFAULT '0',
`v_drug_ammount_4` int(11) DEFAULT '0',
`v_drug_ammount_5` int(11) DEFAULT '0',
`v_drug_ammount_6` int(11) DEFAULT '0',
`v_mats` int(11) DEFAULT '0',
`v_weapon_melee` int(11) DEFAULT '0',
`v_weapon_slot_1` int(11) DEFAULT '0',
`v_weapon_ammo_1` int(11) DEFAULT '0',
`v_weapon_slot_2` int(11) DEFAULT '0',
`v_weapon_ammo_2` int(11) DEFAULT '0',
`v_gajbica_slot_1` int(11) DEFAULT '-1',
`v_gajbica_slot_2` int(11) DEFAULT '-1',
`v_gajbica_slot_3` int(11) DEFAULT '-1',
`v_gajbica_slot_4` int(11) DEFAULT '-1',
`v_gajbica_slot_5` int(11) DEFAULT '-1',
`v_gajbica_kolicina_1` int(11) DEFAULT '0',
`v_gajbica_kolicina_2` int(11) DEFAULT '0',
`v_gajbica_kolicina_3` int(11) DEFAULT '0',
`v_gajbica_kolicina_4` int(11) DEFAULT '0',
`v_gajbica_kolicina_5` int(11) DEFAULT '0',
`v_neaktivnost` int(11) DEFAULT '0',
`v_kilometri` int(11) DEFAULT '0',
`v_metri` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;[/pawn]