Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* details */
- category TINYINT NOT NULL,
- brand INT NOT NULL,
- model INT NOT NULL,
- model_detail VARCHAR(255) NOT NULL,
- title VARCHAR(255) NOT NULL,
- registration_date DATE NOT NULL,
- production_year INT NOT NULL,
- mileage INT NOT NULL,
- power SMALLINT NOT NULL,
- fuel TINYINT NOT NULL,
- cylinder TINYINT NOT NULL,
- capacity INT NOT NULL,
- shifting TINYINT NOT NULL,
- type TINTYINT NOT NULL,
- doors TINYINT NOT NULL,
- vin INT NOT NULL,
- auhu_new BOOL NOT NULL,
- hu_date DATE NOT NULL,
- au_date DATE NOT NULL,
- exhaust_norm TINYINT NOT NULL,
- enviroment_badge TINYINT NOT NULL,
- co2_emissions INT NOT NULL,
- fuel_consumption_city INT NOT NULL,
- fuel_consumption_rural INT NOT NULL,
- fuel_consumption_combined INT NOT NULL,
- guarantee INT NOT NULL,
- color_exterior INT NOT NULL,
- color_interior INT NOT NULL,
- color_producer VARCHAR(100) NOT NULL,
- ancestors TINYINT NOT NULL,
- /* komfort */
- seat INT NOT NULL,
- air_con INT NOT NULL,
- cushoning INT NOT NULL,
- navigation INT NOT NULL,
- telephone INT NOT NULL,
- distance_automatic BOOL NOT NULL,
- distance_automatic_plus BOOL NOT NULL,
- charcoal_filter BOOL NOT NULL,
- mirror_dimming BOOL NOT NULL,
- mirror_heating BOOL NOT NULL,
- mirror_electronic BOOL NOT NULL,
- mirror_electronic_fold BOOL NOT NULL,
- aux_in BOOL NOT NULL,
- seat_ventilation_front BOOL NOT NULL,
- seat_ventilation_rear BOOL NOT NULL,
- downhill_assistance BOOL NOT NULL,
- uphill_assistance BOOL NOT NULL,
- cd_changer BOOL NOT NULL,
- glass_colored BOOL NOT NULL,
- glass_doubled BOOL NOT NULL,
- dvd_changer BOOL NOT NULL,
- parking_assistance BOOL NOT NULL,
- windows_electric BOOL NOT NULL,
- backdoor_electric BOOL NOT NULL,
- seats_electric_front BOOL NOT NULL,
- seats_electric_rear BOOL NOT NULL,
- back_blind_electric BOOL NOT NULL,
- follow_me_home BOOL NOT NULL,
- fond_entertainment BOOL NOT NULL,
- windscreen_heated BOOL NOT NULL,
- garage_opener BOOL NOT NULL,
- back_blind BOOL NOT NULL,
- air_filter BOOL NOT NULL,
- rearmirror_blind BOOL NOT NULL,
- folding_table BOOL NOT NULL,
- fridge BOOL NOT NULL,
- wheel_leather BOOL NOT NULL,
- wheel_heated BOOL NOT NULL,
- wheel_position_electric BOOL NOT NULL,
- wheel_position BOOL NOT NULL,
- lights_automatic BOOL NOT NULL,
- linguatronic BOOL NOT NULL,
- can_holder_front BOOL NOT NULL,
- can_holder_rear BOOL NOT NULL,
- seats_massage BOOL NOT NULL,
- armrest BOOL NOT NULL,
- wheel_multifunction BOOL NOT NULL,
- seats_multicontour BOOL NOT NULL,
- neck_heating BOOL NOT NULL,
- radio BOOL NOT NULL,
- radio_tape BOOL NOT NULL,
- radio_cd BOOL NOT NULL,
- radio_dvd BOOL NOT NULL,
- radio_mp3 BOOL NOT NULL,
- radio_soundsytem TINYINT NOT NULL,
- rainsensor BOOL NOT NULL,
- back_camera BOOL NOT NULL,
- sliding_doors BOOL NOT NULL,
- sliding_doors_electric BOOL NOT NULL,
- servo_steering BOOL NOT NULL,
- servo_locks BOOL NOT NULL,
- servotronic BOOL NOT NULL,
- seats_rear_divided BOOL NOT NULL,
- seats_rear_electric BOOL NOT NULL,
- seats_heated_front BOOL NOT NULL,
- seats_heated_rear BOOL NOT NULL,
- auxilary_heating BOOL NOT NULL,
- start_stop_automatic BOOL NOT NULL,
- cruise_control BOOL NOT NULL,
- division_wall BOOL NOT NULL,
- tv_analog BOOL NOT NULL,
- tv_digital BOOL NOT NULL,
- usb BOOL NOT NULL,
- composite vitrification BOOL NOT NULL,
- lock_central BOOL NOT NULL,
- /* sport/tuning */
- wide_base_tires BOOL NOT NULL,
- carbon_breaks BOOL NOT NULL,
- spoiler BOOL NOT NULL,
- sport_exhaust BOOL NOT NULL,
- sport_breaks BOOL NOT NULL,
- sport_carriage BOOL NOT NULL,
- sport_wheel BOOL NOT NULL,
- sport_air_filter BOOL NOT NULL,
- sport_seats BOOL NOT NULL,
- /* fahrzeug allgemein */
- wheel_position INT NOT NULL,
- suspension INT NOT NULL,
- roof INT NOT NULL,
- hitch INT NOT NULL,
- 12v_supply BOOL NOT NULL,
- seats_3rd_row BOOL NOT NULL,
- niveau_regulation BOOL NOT NULL,
- 4x4 BOOL NOT NULL,
- temperature_exterior BOOL NOT NULL,
- boardcomputer BOOL NOT NULL,
- drive_front BOOL NOT NULL,
- drive_rear BOOL NOT NULL,
- lugage_net BOOL NOT NULL,
- seats_emergency BOOL NOT NULL,
- particle_filter BOOL NOT NULL,
- winch BOOL NOT NULL,
- ski_bag BOOL NOT NULL,
- division_fence BOOL NOT NULL,
- footboards BOOL NOT NULL,
- turbo BOOL NOT NULL,
- turbo_bi BOOL NOT NULL,
- seats_foldable BOOL NOT NULL,
- /* sicherheit */
- 3rd_breaking_ligth BOOL NOT NULL,
- headrest_active_front BOOL NOT NULL,
- headrest_active_read BOOL NOT NULL,
- abs BOOL NOT NULL,
- bump_lights BOOL NOT NULL,
- alarm_system BOOL NOT NULL,
- /* antriebsschupfregelung */
- differential_lock BOOL NOT NULL,
- immobilizer BOOL NOT NULL,
- esp BOOL NOT NULL,
- hud BOOL NOT NULL,
- isofix BOOL NOT NULL,
- seats_children BOOL NOT NULL,
- headrests_rear BOOL NOT NULL,
- nightvision_assistance BOOL NOT NULL,
- lights_fog BOOL NOT NULL,
- fender BOOL NOT NULL,
- tire_pressure_control BOOL NOT NULL,
- window_cleaning_heated BOOL NOT NULL,
- light_cleaning BOOL NOT NULL,
- daylight_light BOOL NOT NULL,
- daylight_light_led BOOL NOT NULL,
- blind_angle_assistant BOOL NOT NULL,
- tires_winter BOOL NOT NULL,
- lights_xenon BOOL NOT NULL,
- lights_xenon_bi BOOL NOT NULL,
- lights_extra BOOL NOT NULL,
- /* aribags */
- airbag_codriver BOOL NOT NULL,
- airbag_driver BOOL NOT NULL,
- airbag_frontal_rear BOOL NOT NULL,
- airbag_knee_driver BOOL NOT NULL,
- airbag_knee_codriver BOOL NOT NULL,
- airbag_side_rear BOOL NOT NULL,
- airbag_side_front BOOL NOT NULL,
- airbag_head_rear BOOL NOT NULL,
- airbag_head_front BOOL NOT NULL,
- /* optik */
- condition_optical TINYINT NOT NULL,
- condition_technical TINYINT NOT NULL,
- rims_alu BOOL NOT NULL,
- windows_dimed_rear BOOL NOT NULL,
- rims_alu_chrome BOOL NOT NULL,
- ambient BOOL NOT NULL,
- bar_chrome BOOL NOT NULL,
- alcantara BOOL NOT NULL,
- roof_rack_colored BOOL NOT NULL,
- roof_rack_black BOOL NOT NULL,
- roof_rack_chrome BOOL NOT NULL,
- interior_wood BOOL NOT NULL,
- interior_wood_classy BOOL NOT NULL,
- shadowline BOOL NOT NULL,
- /* sonstiges */
- length INT NOT NULL,
- armor INT NOT NULL,
- non_smoking BOOL NOT NULL,
- handicaped_accessibel BOOL NOT NULL,
- agency BOOL NOT NULL,
- e10 BOOL NOT NULL,
- rental BOOL NOT NULL,
- check_book BOOL NOT NULL,
- special BOOL NOT NULL,
- taxi BOOL NOT NULL,
- pro_renovation BOOL NOT NULL,
- hail_dammage BOOL NOT NULL,
- trade_in BOOL NOT NULL,
- shipping INT NOT NULL,
- /* bemerkungen */
- comment TEXT,
Add Comment
Please, Sign In to add comment