Auto Cars Makes And Models SQL DataBase Free

Download free Auto Cars Makes And Models SQL DataBase

Free database of cars, models, year, body type, engine type and more.

+9000 records in the database.

SQl example

 `trim_id` int(11) DEFAULT NULL,
  `trim` varchar(255) NOT NULL,
  `trim_ru` varchar(255) NOT NULL,
  `make_id` int(11) NOT NULL,
  `make` varchar(255) NOT NULL,
  `make_ru` varchar(255) NOT NULL,
  `model_id` int(11) NOT NULL,
  `model` varchar(255) NOT NULL,
  `model_ru` varchar(255) NOT NULL,
  `generation_id` int(11) NOT NULL,
  `generation` varchar(255) NOT NULL,
  `generation_ru` varchar(255) NOT NULL,
  `body_id` int(11) NOT NULL,
  `body` varchar(255) NOT NULL,
  `body_ru` varchar(255) NOT NULL,
  `drive_id` int(11) NOT NULL,
  `drive` varchar(255) NOT NULL,
  `drive_ru` varchar(255) NOT NULL,
  `gearbox_id` int(11) NOT NULL,
  `gearbox` varchar(255) NOT NULL,
  `gearbox_ru` varchar(255) NOT NULL,
  `engine_type_id` int(11) NOT NULL,
  `engine_type` varchar(255) NOT NULL,
  `engine_type_ru` varchar(255) NOT NULL,
  `engine_volume` int(11) NOT NULL,
  `engine_power` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date_update` date NOT NULL,
  `is_active` int(1) NOT NULL DEFAULT '1',
  `old_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Use when updating the database'

REPLACE INTO `auto_databases_one` VALUES(3632, '116i 1.6 AT (115 Hp)', '116i 1.6 AT (115 л.с.)', 16, 'BMW', 'БМВ', 1042, '1er', '1er', 366, 'I (E81/E82/E87/E88)', 'I (E81/E82/E87/E88)', 3, 'Hatchback 5-Door', 'Хэтчбек 5 дв.', 1, 'RWD', 'Задний', 2, 'Automatic', 'Автоматическая', 1, 'Gasoline', 'Бензин', 1596, 115, 2004, 'bmw-1er-i-e87-hatchback-5-door-2004', '2016-11-17', 1, 0);
REPLACE INTO `auto_databases_one` VALUES(3633, '116i 1.6 MT (115 Hp)', '116i 1.6 MT (115 л.с.)', 16, 'BMW', 'БМВ', 1042, '1er', '1er', 366, 'I (E81/E82/E87/E88)', 'I (E81/E82/E87/E88)', 3, 'Hatchback 5-Door', 'Хэтчбек 5 дв.', 1, 'RWD', 'Задний', 1, 'Manual', 'Механическая', 1, 'Gasoline', 'Бензин', 1596, 115, 2004, 'bmw-1er-i-e87-hatchback-5-door-2004', '2016-11-17', 1, 0);