/*
SQLyog Ultimate v9.62
MySQL - 5.1.62-0ubuntu0.11.10.1
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
create table `T` (
`ID` int (10),
`FIRST_LETTER` varchar (381),
`MAKE_NAME` varchar (381),
`MODEL_SERIES` varchar (381),
`MODEL_NAME` varchar (381),
`TYPE_SERIES` varchar (381),
`TYPE_NAME` varchar (381),
`COUNTRY` varchar (9),
`TECHNOLOGY` varchar (6),
`VEHICLE_CLASS` varchar (12),
`ENGINE_CAPACITY` varchar (15),
`TRANSMISSION` varchar (12)
);
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('1','A','奥迪','奥迪','奥迪A1(进口)','2011 款','1.4 TFSI 7档双离合 Urban款','德','进口','小型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('2','A','奥迪','奥迪','奥迪A1(进口)','2011 款','1.4 TFSI 7档双离合 Ego款','德','进口','小型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('3','A','奥迪','奥迪','奥迪A1(进口)','2011 款','1.4 TFSI 7档双离合 Ego plus款','德','进口','小型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('4','A','奥迪','奥迪','奥迪A3(进口)','2011 款','Sportback 1.4T 自动 舒适型','德','进口','紧凑型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('5','A','奥迪','奥迪','奥迪A3(进口)','2011 款','Sportback 1.4T 自动 豪华型','德','进口','紧凑型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('6','A','奥迪','奥迪','奥迪A3(进口)','2011 款','Sportback 1.8T 自动 豪华型','德','进口','紧凑型车','1800','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('7','A','奥迪','奥迪','奥迪A3(进口)','2011 款','Sportback 1.8T 自动 尊贵型','德','进口','紧凑型车','1800','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('8','A','奥迪','奥迪','奥迪A3(进口)','2011 款','Sportback 1.4T 自动 技术型','德','进口','紧凑型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('9','A','奥迪','奥迪','奥迪A3(进口)','2010 款','Sportback 1.4T 舒适型','德','进口','紧凑型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('10','A','奥迪','奥迪','奥迪A3(进口)','2010 款','Sportback 1.4T 豪华型','德','进口','紧凑型车','1400','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('11','A','奥迪','奥迪','奥迪A3(进口)','2010 款','Sportback 首发限量版舒适型','德','进口','紧凑型车','1800','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('12','A','奥迪','奥迪','奥迪A3(进口)','2010 款','Sportback 首发限量版豪华型','德','进口','紧凑型车','1800','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('13','A','奥迪','奥迪','奥迪A3(进口)','2010 款','Sportback 1.8T 豪华型','德','进口','紧凑型车','1800','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('14','A','奥迪','奥迪','奥迪A3(进口)','2010 款','Sportback 1.8T 尊贵型','德','进口','紧凑型车','1800','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('15','A','奥迪','奥迪','奥迪A4(进口)','2003 款','3.0 quattro敞蓬','德','进口','中型车','2000','手自一体');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('16','A','奥迪','奥迪','奥迪A4(进口)','2002 款','1.8T','德','进口','中型车','2000','手自一体');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('17','A','奥迪','奥迪','奥迪A4(进口)','2002 款','3.0L quattro','德','进口','中型车','2000','手自一体');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('18','A','奥迪','奥迪','奥迪A4(进口)','2000 款','2.0','德','进口','中型车','2000','手自一体');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('19','A','奥迪','奥迪','奥迪A5(进口)','2012 款','Coupe 2.0T CVT','德','进口','跑车','2000','无级变速');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('20','A','奥迪','奥迪','奥迪A5(进口)','2012 款','Coupe 2.0T 双离合 quattro','德','进口','跑车','2000','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('21','A','奥迪','奥迪','奥迪A5(进口)','2012 款','Coupe 3.0T 双离合 quattro','德','进口','跑车','3000','双离合');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('22','A','奥迪','奥迪','奥迪A5(进口)','2012 款','Cabriolet 2.0T','德','进口','跑车','2000','手自一体');
insert into `T` (`ID`, `FIRST_LETTER`, `MAKE_NAME`, `MODEL_SERIES`, `MODEL_NAME`, `TYPE_SERIES`, `TYPE_NAME`, `COUNTRY`, `TECHNOLOGY`, `VEHICLE_CLASS`, `ENGINE_CAPACITY`, `TRANSMISSION`) values('23','A','奥迪','奥迪','奥迪A5(�
