insert into categoria (cd_categoria, ds_categoria)
values (01, 'Hatche'),
(02, 'Sedan'),
(03, 'Minivan'),
(04, 'Perua'),
(05, 'Picape'),
(06, 'Esportivo');


insert into marca (cd_marca, ds_marca)
values (01, 'Alfa Romeo'),
(02, 'Audi'),
(03, 'BMW'),
(04, 'Chevrolet'),
(05, 'Citroen'),
(06, 'Dodge'),
(07, 'Ferrari'),
(08, 'Fiat'),
(09, 'Ford'),
(10, 'Honda'),
(11, 'Hyundai'),
(12, 'Jaguar'),
(13, 'Lamborghini'),
(14, 'Madza'),
(15, 'Mercedes-Benz'),
(16, 'Mitsubishi'),
(17, 'Nissan'),
(18, 'Peugeot'),
(19, 'Porsche'),
(20, 'Kia'),
(21, 'Renault'),
(22, 'Toyota'),
(23, 'Volvo'),
(24, 'Volkswagen');


insert into modelo (cd_modelo, ds_modelo, cd_marca)
values (01, 'Gol', 24),
(02, 'Uno', 08),
(03, 'Fox', 24),
(04, 'Celta', 04),
(05, 'Peugeot 207', 18),
(06, 'Corsa', 04),
(07, 'Picanto', 20),
(08, 'Agile', 04),
(09, 'Stilo', 08),
(10, 'Sandero', 21),
(11, 'Golf', 24),
(12, 'Linea', 08),    
(13, 'Corolla', 22),
(14, 'C5', 05),
(15, 'Sentra', 17),
(16, 'Cerato', 20),
(17, 'Civic', 10),
(18, 'Classe S', 15),
(19, 'Azera', 11),
(20, 'A8', 02),
(21, 'Meriva', 04),
(22, 'Fit', 10),
(23, 'Zafira', 04),
(24, 'Idea', 08),
(25, 'Parati', 24),
(26, 'SpaceFox', 24),
(27, 'Palio weekend', 08),
(28, 'Montana', 04),
(29, 'Frontier', 17),
(30, 'L200', 16),
(31, 'Hilux', 22),
(32, 'Ecosport', 09),
(33, 'Vera Cruz', 11),
(34, 'Sorento', 20),
(35, 'Captiva', 04),
(36, 'Pajero', 16),
(37, 'Santa Fé', 11);


insert into cat_mod (cd_categoria, cd_modelo)
values (01, 01),
(01, 02),
(01, 03),
(01, 04),
(01, 05),
(01, 06),
(01, 07),
(01, 08),
(01, 09),
(01, 10),
(01, 11),
(02, 12),
(02, 13),
(02, 14),
(02, 15),
(02, 16),
(02, 17),
(02, 18),
(02, 19),
(02, 20),
(03, 21),
(03, 22),
(03, 23),
(03, 24),
(04, 25),
(04, 26),
(04, 27),
(05, 28),
(05, 29),
(05, 30),
(05, 31),
(05, 32),
(05, 33),
(05, 34),
(05, 35),
(05, 36),
(05, 37);


insert into configuracao (cd_conf, n_portas, cor, motor, opcionais)
values (01, 4, 'Prata', 'xyz', 'Ar condicionado, Direção hidraulica'),
(02, 2, 'Prata', 'xyz', 'Não Contém'),
(03, 4, 'Branco', 'xyz', 'Ar condicionado, Trava elétrica'),
(04, 2, 'Preto', 'xyz', 'Vidro elétrico'),
(05, 4, 'Preto', 'xyz', 'Ar condicionado'),
(06, 2, 'Vermelho', 'xyz', 'Direção Hidraulica'),
(07, 4, 'Branco', 'xyz', 'Direção hidraulica,vidro elétrico,ar condicionado');


insert into mod_conf (cd_modelo, cd_conf, qtde_estoque, valor)
values (01, 03, 10, '24.500'),
(02, 02, 6, '17.000,00'),
(03, 04, 8, '27.700,00'),
(04, 06, 4, '18.000,00'),
(05, 04, 5, '20.000,00'),
(06, 05, 10, '22.000,00'),
(07, 03, 3, '34.000,00'),
(08, 03, 5, '37.500,00'),
(09, 07, 8, '42.690,00'),
(10, 04, 5, '28.700,00'),
(11, 07, 3, '50.900,00'),
(12, 07, 2, '72.500,00'),
(13, 05, 6, '63.850,00'),
(14, 07, 3, '92.000,00'),
(15, 05, 5, '54.500,00'),
(16, 03, 5, '53.000,00'),
(17, 07, 3, '85.000,00'),
(18, 07, 2, '258.000,00'),
(19, 05, 4, '46.000,00'),
(20, 07, 1, '155.000,00'),
(21, 05, 6, '47.000,00'),
(22, 03, 8, '52.450,00'),
(23, 05, 4, '69.000,00'),
(24, 05, 9, '56.990,00'),
(25, 02, 2, '11.900,00'),
(26, 06, 7, '44.500,00'),
(27, 01, 5, '42.450,00'),
(28, 04, 4, '31.700,00'),
(29, 04, 6, '85.600,00'),
(30, 07, 5, '119.000,00'),
(31, 04, 3, '165.680,00'),
(32, 06, 2, '45.680,00'),
(33, 01, 4, '135.000,00'),
(34, 01, 2, '110.000,00'),
(35, 07, 6, '120.000,00'),
(36, 01, 8, '58.000,00'),
(37, 07, 4, '66.980,00');