/*
SQLyog Ultimate v11.33 (64 bit)
MySQL - 5.6.26-log : Database - 103BrandDataQCZJ
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`103BrandDataQCZJ` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `103BrandDataQCZJ`;
/*Table structure for table `brand` */
DROP TABLE IF EXISTS `brand`;
CREATE TABLE `brand` (
`id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`brand_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`bfirstletter` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`logo` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`,`brand_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*Data for the table `brand` */
insert into `brand`(`id`,`brand_name`,`bfirstletter`,`logo`) values ('1','大众','D','https://car3.autoimg.cn/cardfs/series/g29/M07/AF/BE/100x100_f40_autohomecar__wKgHJFs9vGCABLhjAAAxZhBm1OY195.png'),('10','雷诺','L','https://car3.autoimg.cn/cardfs/series/g27/M07/B0/59/100x100_f40_autohomecar__ChcCQFs9usKAMIvkAAAcJmbdQXE902.png'),('100','科尼赛克','K','https://car2.autoimg.cn/cardfs/series/g30/M09/B4/36/100x100_f40_autohomecar__wKgHPls-vGuARqHmAAAzgnd4H4U651.png'),('101','开瑞','K','https://car2.autoimg.cn/cardfs/series/g30/M09/AF/23/100x100_f40_autohomecar__wKgHHFs9tiSAYP7NAAAhIYl-T54441.png'),('102','威麟','W','https://car2.autoimg.cn/cardfs/series/g30/M0B/B4/36/100x100_f40_autohomecar__wKgHPls-vHKADs-qAAAt3zAmPZk863.png'),('103','瑞麒','R','https://car3.autoimg.cn/cardfs/series/g30/M04/AF/22/100x100_f40_autohomecar__wKgHHFs9thOANwxXAAAbgQiJA8Q971.png'),('108','广汽吉奥','G','https://car3.autoimg.cn/cardfs/series/g26/M0B/AF/F6/100x100_f40_autohomecar__ChcCP1s9tFuAK6vOAAAeCnZnwzg718.png'),('109','KTM','K','https://car2.autoimg.cn/cardfs/series/g26/M04/B0/01/100x100_f40_autohomecar__ChcCP1s9tgiAYT0ZAAAMMwYcMdw218.png'),('11','菲亚特','F','https://car2.autoimg.cn/cardfs/series/g27/M01/AE/EA/100x100_f40_autohomecar__wKgHE1s9usmAIAd8AAA9Rhf3SVw801.png'),('110','一汽','Y','https://car2.autoimg.cn/cardfs/series/g26/M05/AE/90/100x100_f40_autohomecar__wKgHEVs9tgCAP5I_AAArCAX8ty8224.png'),('111','野马汽车','Y','https://car2.autoimg.cn/cardfs/series/g26/M09/AE/8F/100x100_f40_autohomecar__wKgHEVs9tfeATlQrAAAeBFFXL38280.png'),('112','GMC','G','https://car3.autoimg.cn/cardfs/series/g28/M06/AE/94/100x100_f40_autohomecar__wKgHFFs9te6AToffAAAalLxEQiw361.png'),('113','东风风神','D','https://car3.autoimg.cn/cardfs/series/g28/M03/A3/2C/autohomecar__ChcCR1t2aL6Ae3I9AAAkZ9PGQfU508.png'),('114','五菱汽车','W','https://car2.autoimg.cn/cardfs/series/g27/M05/B4/23/100x100_f40_autohomecar__wKgHE1s-6bOAG1hhAAAhkQEWmWU678.png'),('115','Gumpert','G','https://car3.autoimg.cn/cardfs/series/g27/M00/B0/4E/100x100_f40_autohomecar__wKgHHls9vCGACzHOAAA0NmJHpjc098.png'),('116','光冈','G','https://car2.autoimg.cn/cardfs/series/g27/M01/AE/F4/100x100_f40_autohomecar__wKgHE1s9vBqAY6sWAAAQDMyOjUE817.png'),('117','AC Schnitzer','A','https://car3.autoimg.cn/cardfs/series/g27/M01/B0/62/100x100_f40_autohomecar__ChcCQFs9vBKAO3YSAAAW0WOWvRc555.png'),('118','Lorinser','L','https://car2.autoimg.cn/cardfs/series/g28/M03/B0/2A/100x100_f40_autohomecar__wKgHI1s9szSADVbkAAAVF5caJEs349.png'),('119','江铃','J','https://car3.autoimg.cn/cardfs/series/g27/M01/B0/4B/100x100_f40_autohomecar__wKgHHls9vAmAbQlPAAAOj143nKY495.png'),('12','现代','X','https://car3.autoimg.cn/cardfs/series/g26/M06/B4/04/100x100_f40_autohomecar__ChcCP1s-vD6ALRHvAAAre1CMIAo299.png'),('120','宝骏','B','https://car2.autoimg.cn/cardfs/series/g29/M05/B3/9D/100x100_f40_autohomecar__wKgHJFs-vLaAQEDzAAA1tc2laCI414.png'),('121','蓝旗亚','L','https://car2.autoimg.cn/cardfs/series/g28/M09/B0/6F/100x100_f40_autohomecar__wKgHI1s9u_KARXOAAAA993FaVNE504.png'),('122','启辰','Q','https://car3.autoimg.cn/cardfs/series/g28/M03/AE/BD/100x100_f40_autohomecar__wKgHFFs9u-iAMlPPAABDdd4iWaA640.png'),('124','理念','L','https://car2.autoimg.cn/cardfs/series/g30/M02/B0/A8/100x100_f40_autohomecar__ChcCSVs9sxmAek-jAAAp2Z9dqQY376.png'),('125','Tramontana','T','https://car3.autoimg.cn/cardfs/series/g30/M07/B0/A8/100x100_f40_autohomecar__ChcCSVs9sxOAfLzYAAAasBBle38800.png'),('126','MELKUS','M','https://car3.autoimg.cn/cardfs/series/g30/M04/B0/40/100x100_f40_autohomecar__wKgHPls9u9qAS_qnAAAyKjpg2QI728.png'),('127','SPIRRA','S','https://car2.autoimg.cn/cardfs/series/g30/M08/B0/00/100x100_f40_autohomecar__wKgHPls9swGAWu7TAAAvokggM9o575.png'),('129','迈凯伦','M','https://car3.autoimg.cn/cardfs/series/g26/M03/AF/EB/100x100_f40_autohomecar__ChcCP1s9svqATR_XAAAVfSUjnMI497.png'),('13','标致','B','https://car2.autoimg.cn/cardfs/series/g28/M00/AE/B3/100x100_f40_autohomecar__wKgHFFs9ut6AMOmqAAAo-NlcmyU236.png'),('130','纳智捷','N','https://car2.autoimg.cn/cardfs/series/g26/M00/AE/76/100x100_f40_autohomecar__wKgHEVs9svSAcF7rAAAc48YsMFE160.png'),('132','Fisker','F','https://car3.autoimg.cn/cardfs/series/g28/M0A/B0/0F/100x100_f40_autohomecar__ChcCR1s9vMGANSuHAAA5fcekJNE969.png'),('133','特斯拉','T','https://car2.autoimg.cn/cardfs/series/g30/M05/AF/53/100x100_f40_autohomecar__wKgHHFs9vLqASyStAAAZuDalRXk481.png'),('134','ABT','A','https://car3.autoimg.cn/cardfs/series/g30/M07/B0/47/100x100_f40_autohomecar__wKgHPls9vLOAHILAAAAWGGhA_W0282.png'),('135','TVR','T','https://car2.autoimg.cn/cardfs/series/g30/M06/B0/EB/100x100_f40_autohomecar__ChcCSVs9vKyAC_J_AAAiINHoYTw381.png'),('136','Noble','N','https://car3.autoimg.cn/cardfs/series/g26/M00/AE/70/100x100_f40_autohomecar__wKgHEVs9snyAQ8C2AAAqCNGoEp8053.png'),('137','Scion','S','https://car2.autoimg.cn/cardfs/series/g30/M04/B0/45/100x100_f40_autohomecar__wKgHPls9vKSAGIgNAAAqPGy4-VA813.png'),('138','SSC','S','https://car3.autoimg.cn/cardfs/series/g26/M07/AE/BF/100x100_f40_autohomecar__wKgHEVs9vJyAP_RKAAAzYxijdFI340.png'),('139','凯佰赫','K','https://car2.autoimg.cn/cardfs/series/g26/M0B/AE/6F/100x100_f40_autohomecar__wKgHEVs9snWARnxKAABCGJAtGEw647.png'),('14','本田','B','https://car3.autoimg.cn/cardfs/series/g29/M0B/AF/A0/100x100_f40_autohomecar__ChcCSFs9s1iAGMiNAAAlP_CBhLY618.png'),('140','巴博斯','B','https://car2.autoimg.cn/cardfs/series/g26/M08/AF/E1/100x100_f40_autohomecar__ChcCP1s9smyARYtBAAAbaaONnzg711.png'),('141','福迪','F','https://car3.autoimg.cn/cardfs/series/g27/M07/AE/AD/100x100_f40_autohomecar__wKgHE1s9smOAaFprAABBXlFoCfo726.png'),('142','东风小康','D','https://car2.autoimg.cn/cardfs/series/g29/M07/51/B9/autohomecar__ChsEflvzc-CAQAjsAAAcpo1Owuo575.png'),('143','北汽威旺','B','https://car2.autoimg.cn/cardfs/series/g27/M06/B0/01/100x100_f40_autohomecar__wKgHHls9sl2AS3ynAAAti2dtJX0432.png'),('144','依维柯','Y','https://car3.autoimg.cn/cardfs/series/g26/M0A/B0/32/100x100_f40_autohomecar__ChcCP1s9vIyATsAFAAANX6Iaj4U522.png'),('145','金龙','J','https://car3.autoimg.cn/cardfs/series/g26/M09/AF/EB/100x100_f40_autohomecar__wKgHHVs9vIWAOXGAAAAzpOY3F9U855.png'),('146','欧朗','O','https://car3.autoimg.cn/cardfs/series/g26/M08/B0/2F/100x100_f40_autohomecar__ChcCP1s9vH6AUgYgAAATwQOlBn8743.png'),('147','首望','S','https://car2.autoimg.cn/cardfs/series/g27/M05/AE/AB/100x100_f40_autohomecar__wKgHE1s9slWAFiwoAAAyEi1Gl-c198.png'),('149','陕汽通家','S','https://car2.autoimg.cn/cardfs/series/g26/M05/B0/2E/100x100_f40_autohomecar__ChcCP1s9vHeACLcVAAA4L3jCmCc497.png'),('15','宝马','B','https://car2.autoimg.cn/cardfs/series/g26/M0B/AF/DD/100x100_f40_autohomecar__wKgHHVs9uuSAdz-2AAAtY7ZwY3U416.png'),('150','海格','H','https://car2.autoimg.cn/cardfs/series/g28/M08/AE/77/100x100_f40_autohomecar__wKgHFFs9ska
评论1