DELIMITER $$
DROP TABLE IF EXISTS carros;
CREATE TABLE carros(
id INT PRIMARY KEY AUTO_INCREMENT,
clave VARCHAR(10) NOT NULL,
predio INT NOT NULL,
placa BLOB NOT NULL,
modelo BLOB NOT NULL,
marca INT NOT NULL,
color INT NOT NULL,
periodo INT,
holograma INT DEFAULT(0),
nota TEXT NULL,
estado INT DEFAULT(11),
registro DATETIME DEFAULT(NOW())
);
$$

DELIMITER $$
DROP TABLE IF EXISTS colores;
CREATE TABLE colores(
id INT PRIMARY KEY AUTO_INCREMENT,
clave VARCHAR(10) UNIQUE NOT NULL,
descripcion VARCHAR(200) NOT NULL
);
$$

DELIMITER $$
DROP TABLE IF EXISTS marcas;
CREATE TABLE marcas(
id INT PRIMARY KEY AUTO_INCREMENT,
clave VARCHAR(10) UNIQUE NOT NULL,
descripcion VARCHAR(200) NOT NULL
);
$$

DELIMITER $$
DROP TABLE IF EXISTS imagenes;
CREATE TABLE imagenes(
carro INT NOT NULL,
descripcion VARCHAR(100) NOT NULL,
imagen VARCHAR(20) NOT NULL
);
$$

INSERT INTO colores(id, clave, descripcion) VALUES
(15,'080800A8', 'OTRO'),
(1,'1012DDF6','BLANCO'),
(2,'70A6A066','PLATA'),
(3,'91F4C8FC','GRIS'),
(4,'ECA29184','NEGRO'),
(5,'E50A5FB3','ROJO'),
(6,'AA55B941','OBSCURO'),
(7,'715358DF','AZUL'),
(8,'66659829','AMARILLO'),
(9,'3D97D4AE','VERDE'),
(10,'0CD53C2B','CAFE'),
(11,'424AE4E1','ROSA'),
(12,'49180211','PURPURA'),
(13,'F61900E7','GRIS OBSCURO'),
(14,'59EA29F6','CELESTE');

INSERT INTO marcas(id, clave, descripcion) VALUES
(1,'79C34450','WALKSWAGEN'),
(2,'4ADF08F4','BUICK'),
(3,'BC050A36','BMW'),
(4,'4BC18096','HONDA'),
(5,'F2025249','PEUGEOT'),
(6,'D12E74EF','TOYOTA'),
(7,'603A779C','FORD'),
(8,'03E8C310','NISSAN'),
(9,'63E7CA0F','AUDI'),
(10,'E2F8DFE4','MAZDA'),
(11,'68D8FA50','CHEVROLET'),
(12,'3851F44D','CITROEN'),
(13,'49FE0744','HYUNDAI'),
(14,'2118B71A','CHERY'),
(15,'A560F3BC','KIA'),
(16,'8D6C1BA5','ROEWE'),
(17,'A1196E55','MITSUBISHI'),
(18,'AD780B52','SKODA'),
(19,'4FC80D6D','GEELY'),
(20,'43E7B5B2','ZHONGHUA'),
(21,'AEE880EB','VOLVO'),
(22,'AC12CED0','LEXUS'),
(23,'C5453FE3','FIAT'),
(24,'037EAE50','GEELY EMGRAND'),
(25,'6EB38D47','DONGFENG'),
(26,'1D4E55F7','BYD'),
(27,'8B5E837F','SUZUKI'),
(28,'6EC45469','JINBEI'),
(29,'B528445A','HAIMA'),
(30,'707F0212','SGMW'),
(31,'04C65585','JAC'),
(32,'C7AAC2A5','SUBARU'),
(33,'806CB18C','ENGLON'),
(34,'DA7B72FE','GREAT WALL'),
(35,'AD9A68AA','HAFEI'),
(36,'539657B2','QINGLING/ISUZU'),
(37,'90F948C1','SOUTHEAST'),
(38,'2200A992','CHANGAN'),
(39,'2372D74F','FOTON'),
(40,'14457853','XIALI'),
(41,'CBC5E8CD','BENZ'),
(42,'13B4A17C','FAW'),
(43,'6C9AE57E','IVECO'),
(44,'A3D86EAD','LIFAN'),
(45,'05B40C74','BESTURN'),
(46,'D8C1FC34','CROWN'),
(47,'31DEF012','RENAULT'),
(48,'E6F12F84','JMC'),
(49,'05D92CAF','MG'),
(50,'6B2B13D3','KAMA'),
(51,'67246678','ZOTYE'),
(52,'2E9C1253','CHANGHE'),
(53,'509EBBDA','XIAMEN JINLONG/JINGLV'),
(54,'59658F3D','SHANGHAI HUIZHONG'),
(55,'1D4A30CA','SUZHOU JINGLONG'),
(56,'5DB0FC57','HIGER'),
(57,'6AE14FFB','YUTONG'),
(58,'8172C719','CNHTC'),
(59,'0F2275E5','BEIBEN HEAVY TRUCK'),
(60,'AB7DAF6E','HUALING XINGMA MOTOR'),
(61,'F302036A','YUEJIN MOTOR'),
(62,'7C24862F','HUANGHAI MOTOR'),
(63,'B49CE88C','OLD STYLE CHANGCHENG'),
(64,'453164EE','CHANGAN COMMERCIAL'),
(65,'77F8DD97','PORSCHE'),
(66,'208D5DBB','CADILLAC'),
(67,'F30EA0CF','INFINITI'),
(68,'56D2C0CE','GEELY GLOBAL HAWK'),
(69,'628EAD72','JEEP'),
(70,'0E82F8CA','LAND ROVER'),
(71,'C4962A21','CHANGFENG'),
(72,'B2880EB4','CHANG AN BENBEN'),
(73,'821D4D75','FUKUDA SHIDAI'),
(74,'1A49256A','CHANA TAURI STAR'),
(75,'7B5C0D35','CHANA EADO'),
(76,'4FEC9883','SHAANXI MOTOR'),
(77,'D0354FCB','HONGYAN MOTOR'),
(78,'9ACBE878','BALONG MOTOR'),
(79,'EC25FCB2','JIANGHUAI JAC'),
(80,'4247AB1C','JIANGHUAI XIANDAI BUS'),
(81,'9BD27528','ANKAI PASSENGER BUS'),
(82,'7015C49B','SHENLONG BUS'),
(83,'53061142','DAYU BUS'),
(84,'DAEE7600','WUZHENG MOTOR'),
(85,'25811D5E','MAN MOTOR'),
(86,'9ECDCBBE','ZHONGTONG BUS'),
(87,'424F3900','BAOJUN'),
(88,'7CCF5219','BEIJING WEIWANG'),
(89,'7621A423','TRUMPCHI'),
(90,'F2AE1CF4','LANDWIND'),
(91,'DFEA8AFC','ZHENGZHOU HIPPOCAMPUS/HAIMA COMMERCIAL VEHICLE'),
(92,'51498D79','BEIJING MOTOR'),
(93,'4BF9A355','ZHONGSHUN'),
(94,'6A1AD678','WEILING MOTOR'),
(95,'8F60DDC3','OPEL'),
(96,'6FCEA2D0','KAIRUI'),
(97,'B74334AC','HUAPU MOTOR'),
(98,'3D925C21','HUAPU MOTOR WENZI SMA'),
(99,'B600D1E6','JIANGLINGYUSHENG'),
(100,'83D250F0','BMW MINI'),
(101,'13ADF228','TOYOTA MARKX'),
(102,'20A23F29','HAVAL'),
(103,'7CB5691E','ACURA'),
(104,'6CFB9CD1','VENUCIA'),
(105,'AE34755A','BYD STYLE'),
(106,'5EA7440D','BENZ SMART'),
(107,'92079A47','BEIJING VEHICLE MANUFACTURE/BAW'),
(108,'52A2D1C2','LUXGEN'),
(109,'267C0137','MUSTANG'),
(110,'1FA67093','ZHONGXING'),
(111,'99B171CC','LINIAN'),
(112,'37A57EC2','CHRYSLER'),
(113,'60852BF2','JI AO'),
(114,'016C4840','SONG HUA JIANG'),
(115,'4EC9F85A','RUILING'),
(116,'71255B08','FUDA'),
(117,'671FBC7E','JAGUAR'),
(118,'80D55E0C','HEIBAO'),
(119,'B74F8231','TANGJUN'),
(120,'4AB99D52','TANGJUN WENZI'),
(121,'AB320333','FUDI'),
(122,'F12B15C0','LIANHUA MOTOR'),
(123,'44270D7B','NANJUN'),
(124,'DDD72B09','SHUANGHUAN MOTOR'),
(125,'4B4E0F1F','HAFEI SAIBAO'),
(126,'B8614CDC','HUATAI'),
(127,'CDF7F4F3','YONGYUAN FEIDIE'),
(128,'38DA14B5','YONGYUAN MOTOR'),
(129,'96020D9E','FLM'),
(130,'E6BA5BC3','HUAILI'),
(131,'67A1300E','JIANGHUAI ANCHI'),
(132,'7182B54D','PAIXI'),
(133,'8F89122C','HIGER WENZI'),
(134,'63E0B2F1','GUANGQI RIYE LIGHT TRUCK'),
(135,'584E11F4','GUANGQI RIYE HEAVY TRUCK'),
(136,'BE5633BA','JIANGNAN'),
(137,'E3D98510','OLD STYLE ZHONGTAI'),
(138,'071A6334','OLD STYLE XIALI'),
(139,'D771644A','NEW AOCHI'),
(140,'657B6448','ZHONGQI WANGPAI'),
(141,'AD30BCD8','ZHONGQI WANGPAI WENZI'),
(142,'2D311FE4','HONDA CIIMO'),
(143,'901202FD','CHANG AN DI AI SHI'),
(144,'FB23E6C9','DODGE'),
(145,'5048BD56','ROHE COUPE'),
(146,'1BAFE8D0','YANTAI'),
(147,'391F7F4D','SHUANGLONG'),
(148,'CB5D59F1','SHIDAI FENGLING/SHIFENG'),
(149,'D9F15A89','XINKAI'),
(150,'114DBBAC','GMC'),
(151,'B927E2C1','SAIC DATONG'),
(152,'68BFDAF3','BEIQI YINXIANG'),
(153,'769C0F9E','NEW QIRUI'),
(154,'AD07A03A','WUDAN'),
(155,'0135BA73','DAYUN MOTOR'),
(156,'1EA68AB0','DONGWO MOTOR'),
(157,'6D6AC7E8','UNION MOTOR'),
(158,'4454D99C','CHUNZHOU BUS'),
(159,'289F3314','SANY HEAVY INDUSTRY'),
(160,'F9986F12','YAXING BUS'),
(161,'867B4B25','HENTONG BUS'),
(162,'22FE05CA','SHAOLIN BUS'),
(163,'212BC4C5','YOUTH BUS'),
(164,'57DBD341','SHITONG'),
(165,'2EDA757F','SANHUAN'),
(166,'B7D2B9E3','XUGONG'),
(167,'23083294','BEIFANG MOTOR'),
(168,'99598485','JIANGHUAN TRUCK'),
(169,'09ADB332','BEIJING ARGRICULTURAL MOTOR'),
(170,'52B4B4F7','XIN DADI MOTOR'),
(171,'8B730032','SHENGWO BUS'),
(172,'DF3196A1','YINGTIAN'),
(173,'93A3881B','QINGQI'),
(174,'C5F5D017','CHUFENG MOTOR'),
(175,'250A1E46','SCANIA'),
(176,'84B22CF2','JIULONG BUS'),
(177,'4630B446','YOUYI BUS'),
(178,'7E5E9BB1','SHANGRAO BUS'),
(179,'106F199A','JIJIANG'),
(180,'6235E9C2','YANGZI BUS'),
(181,'4974DBC0','XIWO BUS'),
(182,'CE60DB62','CHANGJIANG BUS'),
(183,'38BC25F5','WUYI'),
(184,'902AD83F','CHENGDU BUS'),
(185,'A5DED324','TIANMA'),
(186,'69268D6D','BLONG'),
(187,'3848440B','SOYAT'),
(188,'BB21AFEB','KIA BORREGO'),
(189,'B747194B','GUANZHI'),
(190,'C8FBEF9C','SEAT'),
(191,'9D3F7990','BENTLEY'),
(192,'B0DE97B0','DADI'),
(193,'773EA221','FUDGE'),
(194,'9747FAE9','HANGTIAN MOTOR'),
(195,'80BF28F8','HENGTIAN MOTOR'),
(196,'C01A0961','JIANGLING QINGQI'),
(197,'1EC2D28B','CARLSON MOTOR'),
(198,'BC868827','KAWEI MOTOR'),
(199,'4CF7A3B9','LAMBORGHINI'),
(200,'0087E4A9','MASERATI'),
(201,'F3D38D84','SHUCHI BUS'),
(202,'0556F1E1','SHILI BUS'),
(203,'35C22220','ZHONGKE HUABEI'),
(204,'2853B2AA','SAIC YIZHENG'),
(205,'A03BA6D3','CHUNLAN MOTOR'),
(206,'7939F3D1','DAFA MOTOR'),
(207,'AA597AD6','SHENYE MOTOR'),
(208,'BBA7B1D9','FERRARI'),
(209,'DD118612','FUXING MOTOR'),
(210,'266F4C7C','ANYUAN BUS'),
(211,'6399F14F','JINGHUA BUS'),
(212,'71E56EA0','TAIHU BUS'),
(213,'F2AD3A0E','WU ZHOU LONG'),
(214,'0FAA3A84','CHANGLONG BUS'),
(215,'44ED6A8C','YUEXI BUS'),
(216,'ABA42240','SHENMA BUS'),
(217,'8CDD0DFF','LUSHAN'),
(218,'B303C44C','WANFENG'),
(219,'4E3FD4EA','GUANGZHOU YUNBAO'),
(220,'47C10F89','ZHONGDA MOTOR'),
(221,'D79A959E','TRICYCLE'),
(222,'B25802C1','TWO-WHEELER'),
(223,'3274F187','JBC'),
(224,'CD41ECB8','YANGTSE BUS'),
(225,'EBD19EDF','CNJ'),
(226,'E7990C09','FUTIAN SHIDAI WENZI'),
(227,'28F49773','AGRICULTURAL VEHICLE'),
(228,'601178A6','DONG FANG HONG MOTOR'),
(229,'9F440BC6','STEY MOTOR'),
(230,'DD4951F4','HONGQI MOTOR'),
(1025,'9CA53EC2','AC_SCHNITZER'),
(1026,'B2F57D48','ALFA ROMEO'),
(1027,'BA19AE21','ASTON MARTIN'),
(1029,'30CD08B9','LA JOYA'),
(1041,'FBFF292E','BRABUS'),
(1042,'C0563106','BUGATTI'),
(1047,'70BBB1B3','CHANGFENG LIEBAO'),
(1049,'9DFDC76F','CHANGAN SALOON'),
(1055,'9CCA30A4','DETROIT ELECTRIC'),
(1057,'7DB6B926','DADI'),
(1062,'3045A7E9','FORMASARI'),
(1068,'964BB138','FISKER'),
(1069,'63B796E2','MITSUOKA'),
(1073,'809517A0','GUANGSHENG'),
(1075,'5B8DCF54','HUABEI'),
(1079,'A2854B04','HUMMER'),
(1091,'FCEB3694','KANDI'),
(1092,'D26E2A82','KOENIGSEGG'),
(1095,'841B8A74','ROLLS-ROYCE'),
(1096,'EEFB985B','LINCOLN'),
(1099,'A95226B9','LANCIA'),
(1100,'C8A90818','LOTUS NYO'),
(1109,'D2054121','MEIYA'),
(1110,'E6F696CC','MCLAREN'),
(1111,'B45EF6D4','MAYBACH'),
(1113,'E437B151','MORGAN'),
(1115,'09113F90','NANJING JINLONG'),
(1118,'BD11267B','PGO'),
(1122,'9222C31D','QIANTU'),
(1126,'655EF4FE','RUF'),
(1130,'B8415AB3','SPYKER'),
(1135,'B3D68C58','SAAB'),
(1136,'655BBB2F','CIIMO'),
(1137,'C788E428','STARTECH'),
(1139,'29FB79F2','TESLA'),
(1140,'D1DC4604','TECHART'),
(1141,'20033F9C','DENZA'),
(1142,'EE25F654','WIESMANN'),
(1155,'17D30B2D','ETERNITI'),
(1158,'4EDF8E4D','YOUXIA'),
(1159,'74810F7B','YOGOMO'),
(1164,'113A4562','ZHIDOU'),
(1165,'3756A900','KAIYI'),
(1166,'3F0B3541','HUASONG'),
(1167,'EEC330C2','ISUZU'),
(1168,'D7C47EF7','BORGWARD'),
(1169,'F80E7513','SHANQI'),
(1170,'C3E970A9','HANJIANG'),
(1171,'86C5DEFE','ZHINUO'),
(1172,'A5D52064','GREENWHEEL'),
(1173,'FB0FE0E1','HANTENG'),
(1174,'AC908A3C','LEVDEO'),
(1176,'ADEBBEB4','SWM'),
(1177,'70267EEC','FQT'),
(1178,'34E7F8C2','QOROS'),
(1179,'0E5BBC5D','JMC'),
(1180,'775E11F4','BISU'),
(1181,'206F2B3D','CAKY'),
(1182,'CF19A624','HAIMA'),
(1183,'BB0AD736','OURUI'),
(1540,'EB8CB324','BEIBEN'),
(1541,'ACB0379D','NORTH BUS'),
(1544,'9056EE50','BALONG'),
(1546,'1D27E16F','SUCCEEDED'),
(1556,'5E1229FC','DIMA'),
(1573,'4662ADA3','HAIOU'),
(1574,'BBF4C2E9','HANGTIAN YUANTONG'),
(1583,'3D1931C3','GOLDEN DRAGON'),
(1595,'C31393E9','NAVECO'),
(1598,'EAB15918','YOUNG MAN'),
(1607,'E209AF46','FORLAND'),
(1618,'F69717CB','TONGXIN BUS'),
(1624,'07082333','WUHUAN'),
(1643,'5CA6C9A5','CDW'),
(1645,'CD6807E8','CRANTON'),
(1652,'A6A4B075','MUDAN'),
(1656,'38FDAB69','YUEXI'),
(1659,'BA0CDD95','SHUNFENG'),
(1660,'64E36C2B','HENGSHAN'),
(1675,'5F305F84','NEOPLAN'),
(1681,'F81A8E39','WANDA'),
(1682,'FA90EDF4','CHANG AN SUZUKI'),
(1683,'6B4635E8','GUILIN'),
(1684,'495E3951','SICHUAN HYUNDAI'),
(1685,'944ABA42','AOCHI'),
(1686,'864ED71F','DENWAY BUS'),
(1687,'A583536C','FAW-LIUT'),
(1688,'846845D1','WANXIANG'),
(1690,'91D4C9D6','SOJEN'),
(1692,'CA4A09EF','ZOOMLION'),
(1693,'40963B19','YINLONG'),
(1694,'45E48317','JIACHUAN AUTO'),
(1695,'18037EFD','YIXING'),
(1698,'AEE0A91C','SUITONG'),
(1701,'4CCC5455','QINGDAO JIEFANG'),
(1702,'139B6E5A','ZTRV'),
(1703,'F05DE761','WANDA'),
(1704,'E0A249DF','SHANGRAO'),
(1705,'F74130BD','ZEV'),
(1706,'26F22C63','EVCRRC'),
(1708,'E1FDED7B','GONGLU BUS'),
(1711,'BEA29D60','NEOPLAN'),
(1712,'FFC6A8A0','HUACHUAN'),
(1713,'7A52D6AD','YOUYI'),
(1714,'02748FB2','TONGXIN'),
(1716,'AB9E23D4','JIACHUAN'),
(1717,'B2DABD85','NVSHEN'),
(1718,'26CD54B9','SHILI'),
(1719,'93667994','SHAOLIN'),
(1720,'693FCCD8','CHUANJIAO'),
(1721,'28C02703','CHUANMA'),
(1722,'5B880BC8','GAC'),
(1723,'A91246A0','HINO'),
(1724,'DF527FB9','KANDI'),
(1725,'CB167B9E','CHTC'),
(1726,'41848782','HENTONG'),
(1728,'E9F64B42','NLM'),
(1729,'7C600F4F','CHUNLAN'),
(1730,'3B00A6FF','CHUFENG'),
(1731,'C8AAF972','JMMC'),
(1732,'705AC93D','JMC'),
(1733,'21963047','SEAGULL'),
(1736,'8F9E5C4D','SHENLONG'),
(1738,'C6CD8869','HONGXING'),
(1739,'512C0C50','SHUCHI'),
(1741,'8FCC3741','HENGSHAN'),
(1743,'CF02739F','YUANCHENG'),
(1745,'776AD92E','CHANGAN OUSHANG'),
(1747,'D08666F4','LYNK & CO'),
(1749,'2C8EB6A6','FEICHI'),
(1750,'C1F927FD','LISHAN'),
(1751,'512FBB8D','DENWAY'),
(1752,'9FD6A3C6','NANJING AUTO'),
(1753,'5B1FBE0C','DAHAN'),
(1755,'A0DDB1BB','DEARCC'),
(1756,'B5593D3C','WANSHAN'),
(1757,'10D31683','CENTRAL EUROPE BENZ RV'),
(1758,'FFF7A878','YUDO'),
(1759,'584DBF83','JUNMA'),
(1760,'AB619684','GUOJIN'),
(1761,'ED1A9C35','WELTMEITER'),
(1762,'8994C1AE','ORA'),
(1763,'E961CB83','NIO'),
(1764,'A3088C25','LADA'),
(1765,'5EA16316','JETOUR'),
(1766,'A11CD519','FORO'),
(1767,'DFBD9163','HICOM'),
(1771,'7D2852A1','PERODUA'),
(1772,'32A1AF1E','UD'),
(1775,'57584314','ISUZU'),
(1776,'486E80F6','ROHENS'),
(1783,'A1C187DA','PROTON'),
(1786,'7AA89442','EMGRAND'),
(1787,'BDF72406','HINO'),
(1792,'871DADCA','ALFA'),
(1793,'76397869','EQUUS'),
(1794,'0A76D2A9','RENAULT SAMSUNG'),
(1796,'C434378C','OUSHANG'),
(1797,'58D9C07E','BONLUCK'),
(1798,'36DEFBF2','QILING'),
(1800,'FC13B658','SATE'),
(1801,'COS88888', 'OTRA');
