SQL Marcas de Veículos (Carros, Motos e Caminhões) - Origem FIPE

veiculosMarcas.sql

--
-- Estrutura da tabela `brands`
--

CREATE TABLE `brands` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `category` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `brands`
--

INSERT INTO `brands` (`id`, `name`, `category`) VALUES
(1, 'Acura', 'car'),
(2, 'Agrale', 'car'),
(3, 'Alfa Romeo', 'car'),
(4, 'AM Gen', 'car'),
(5, 'Asia Motors', 'car'),
(6, 'Audi', 'car'),
(7, 'BMW', 'car'),
(8, 'BRM', 'car'),
(10, 'Cadillac', 'car'),
(11, 'CBT Jipe', 'car'),
(12, 'Chrysler', 'car'),
(13, 'Citroën', 'car'),
(14, 'Cross Lander', 'car'),
(15, 'Daewoo', 'car'),
(16, 'Daihatsu', 'car'),
(17, 'Dodge', 'car'),
(18, 'Engesa', 'car'),
(19, 'Envemo', 'car'),
(20, 'Ferrari', 'car'),
(21, 'Fiat', 'car'),
(22, 'Ford', 'car'),
(23, 'GM - Chevrolet', 'car'),
(24, 'Gurgel', 'car'),
(25, 'Honda', 'car'),
(26, 'Hyundai', 'car'),
(27, 'Isuzu', 'car'),
(28, 'Jaguar', 'car'),
(29, 'Jeep', 'car'),
(30, 'JPX', 'car'),
(31, 'Kia Motors', 'car'),
(32, 'Lada', 'car'),
(33, 'Land Rover', 'car'),
(34, 'Lexus', 'car'),
(35, 'Lotus', 'car'),
(36, 'Maserati', 'car'),
(37, 'Matra', 'car'),
(38, 'Mazda', 'car'),
(39, 'Mercedes-Benz', 'car'),
(40, 'Mercury', 'car'),
(41, 'Mitsubishi', 'car'),
(42, 'Miura', 'car'),
(43, 'Nissan', 'car'),
(44, 'Peugeot', 'car'),
(45, 'Plymouth', 'car'),
(46, 'Pontiac', 'car'),
(47, 'Porsche', 'car'),
(48, 'Renault', 'car'),
(49, 'Rover', 'car'),
(50, 'Saab', 'car'),
(51, 'Saturn', 'car'),
(52, 'Seat', 'car'),
(54, 'Subaru', 'car'),
(55, 'Suzuki', 'car'),
(56, 'Toyota', 'car'),
(57, 'Troller', 'car'),
(58, 'Volvo', 'car'),
(59, 'VW - VolksWagen', 'car'),
(60, 'ADLY', 'motorcycle'),
(61, 'AGRALE', 'motorcycle'),
(62, 'APRILIA', 'motorcycle'),
(63, 'ATALA', 'motorcycle'),
(64, 'BAJAJ', 'motorcycle'),
(65, 'BETA', 'motorcycle'),
(66, 'BIMOTA', 'motorcycle'),
(67, 'BMW', 'motorcycle'),
(68, 'BRANDY', 'motorcycle'),
(69, 'byCristo', 'motorcycle'),
(70, 'CAGIVA', 'motorcycle'),
(71, 'CALOI', 'motorcycle'),
(72, 'DAELIM', 'motorcycle'),
(73, 'DERBI', 'motorcycle'),
(74, 'DUCATI', 'motorcycle'),
(75, 'EMME', 'motorcycle'),
(76, 'GAS GAS', 'motorcycle'),
(77, 'HARLEY-DAVIDSON', 'motorcycle'),
(78, 'HARTFORD', 'motorcycle'),
(79, 'HERO', 'motorcycle'),
(80, 'HONDA', 'motorcycle'),
(81, 'HUSABERG', 'motorcycle'),
(82, 'HUSQVARNA', 'motorcycle'),
(85, 'KAWASAKI', 'motorcycle'),
(87, 'KTM', 'motorcycle'),
(89, 'LAVRALE', 'motorcycle'),
(90, 'MOTO GUZZI', 'motorcycle'),
(91, 'MV AGUSTA', 'motorcycle'),
(92, 'MVK', 'motorcycle'),
(93, 'ORCA', 'motorcycle'),
(94, 'PEUGEOT', 'motorcycle'),
(95, 'PIAGGIO', 'motorcycle'),
(96, 'SANYANG', 'motorcycle'),
(97, 'SIAMOTO', 'motorcycle'),
(98, 'SUNDOWN', 'motorcycle'),
(99, 'SUZUKI', 'motorcycle'),
(100, 'TRIUMPH', 'motorcycle'),
(101, 'YAMAHA', 'motorcycle'),
(102, 'AGRALE', 'truck'),
(103, 'CHEVROLET', 'truck'),
(104, 'FIAT', 'truck'),
(105, 'FORD', 'truck'),
(106, 'GMC', 'truck'),
(108, 'MARCOPOLO', 'truck'),
(109, 'MERCEDES-BENZ', 'truck'),
(110, 'NAVISTAR', 'truck'),
(111, 'NEOBUS', 'truck'),
(112, 'PUMA-ALFA', 'truck'),
(113, 'SAAB-SCANIA', 'truck'),
(114, 'SCANIA', 'truck'),
(115, 'VOLKSWAGEN', 'truck'),
(116, 'VOLVO', 'truck'),
(117, 'BUELL', 'motorcycle'),
(118, 'KASINSKI', 'motorcycle'),
(119, 'TRAXX', 'motorcycle'),
(120, 'Walk', 'car'),
(121, 'CICCOBUS', 'truck'),
(122, 'IVECO', 'truck'),
(123, 'Bugre', 'car'),
(125, 'SSANGYONG', 'car'),
(126, 'MIZA', 'motorcycle'),
(127, 'LOBINI', 'car'),
(128, 'FYM', 'motorcycle'),
(129, 'KAHENA', 'motorcycle'),
(130, 'BRAVA', 'motorcycle'),
(131, 'AMAZONAS', 'motorcycle'),
(132, 'FOX', 'motorcycle'),
(133, 'GREEN', 'motorcycle'),
(134, 'SHINERAY', 'motorcycle'),
(135, 'WUYANG', 'motorcycle'),
(136, 'CHANA', 'car'),
(137, 'DAYANG', 'motorcycle'),
(138, 'HAOBAO', 'motorcycle'),
(139, 'LERIVO', 'motorcycle'),
(140, 'Mahindra', 'car'),
(141, 'JIAPENG VOLCANO', 'motorcycle'),
(142, 'DAYUN', 'motorcycle'),
(143, 'GARINNI', 'motorcycle'),
(144, 'WALKBUS', 'truck'),
(145, 'DAFRA', 'motorcycle'),
(146, 'Malaguti', 'motorcycle'),
(147, 'EFFA', 'car'),
(148, 'Lon-V', 'motorcycle'),
(149, 'Fibravan', 'car'),
(150, 'BRP', 'motorcycle'),
(151, 'JONNY', 'motorcycle'),
(152, 'HAFEI', 'car'),
(153, 'GREAT WALL', 'car'),
(154, 'JINBEI', 'car'),
(155, 'BUENO', 'motorcycle'),
(156, 'MINI', 'car'),
(157, 'smart', 'car'),
(158, 'IROS', 'motorcycle'),
(159, 'LANDUM', 'motorcycle'),
(160, 'MRX', 'motorcycle'),
(161, 'Caoa Chery', 'car'),
(162, 'Benelli', 'motorcycle'),
(163, 'Wake', 'car'),
(164, 'PEGASSI', 'motorcycle'),
(165, 'TAC', 'car'),
(166, 'SINOTRUK', 'truck'),
(167, 'MG', 'car'),
(168, 'LIFAN', 'car'),
(170, 'Fyber', 'car'),
(171, 'LAMBORGHINI', 'car'),
(173, 'REGAL RAPTOR', 'motorcycle'),
(174, 'JOHNNYPAG', 'motorcycle'),
(175, 'MAGRÃO TRICICLOS', 'motorcycle'),
(176, 'TARGOS', 'motorcycle'),
(177, 'JAC', 'car'),
(178, 'LIFAN', 'motorcycle'),
(179, 'EFFA-JMC', 'truck'),
(180, 'VENTO', 'motorcycle'),
(181, 'HYUNDAI', 'truck'),
(182, 'CHANGAN', 'car'),
(183, 'SHINERAY', 'car'),
(184, 'MAN', 'truck'),
(185, 'RAM', 'car'),
(186, 'RELY', 'car'),
(187, 'TIGER', 'motorcycle'),
(188, 'JAC', 'truck'),
(189, 'ASTON MARTIN', 'car'),
(190, 'FOTON', 'car'),
(191, 'FOTON', 'truck'),
(192, 'Royal Enfield', 'motorcycle'),
(193, 'SHACMAN', 'truck'),
(194, 'MAXIBUS', 'truck'),
(195, 'Rolls-Royce', 'car'),
(196, 'MASCARELLO', 'truck'),
(197, 'DAF', 'truck'),
(198, 'RIGUETE', 'motorcycle'),
(199, 'GEELY', 'car'),
(200, 'MOTORINO', 'motorcycle'),
(201, 'MOTOCAR', 'motorcycle'),
(202, 'INDIAN', 'motorcycle'),
(203, 'HAOJUE', 'motorcycle'),
(204, 'KYMCO', 'motorcycle'),
(205, 'BEE', 'motorcycle'),
(206, 'BEPOBUS', 'truck'),
(207, 'Baby', 'car'),
(208, 'IVECO', 'car'),
(209, 'FUSCO MOTOSEGURA', 'motorcycle'),
(210, 'POLARIS', 'motorcycle'),
(211, 'Mclaren', 'car'),
(212, 'BULL', 'motorcycle'),
(214, 'HITECH ELECTRIC', 'car'),
(215, 'VOLTZ', 'motorcycle'),
(216, 'AVELLOZ', 'motorcycle'),
(236, 'CAB Motors', 'car'),
(237, 'SUPER SOCO', 'motorcycle');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `brands`
--
ALTER TABLE `brands`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=238;
COMMIT;