/*MySQL*/CREATE TABLE _vehiclemodels ( `vmodid` INT NOT NULL AUTO_INCREMENT, `vmodname` varchar(32) NOT NULL, `vmodyear` YEAR NOT NULL, `vmanid` INT NOT NULL, FOREIGN KEY (`vmanid`) REFERENCES _vehiclemanufacturers (`vmanid`), `vmodattributes` varchar(32) NOT NULL, PRIMARY KEY(`vmodid`,`vmodname`,`vmodyear`,`vmanid`,`vmodattributes`)) TYPE=innodb;INSERT INTO _vehiclemodels (`vmodname`,`vmodyear`,`vmanid`,`vmodattributes`) VALUES ('R8',"2009","4","8 cyl, 4.2 L, Manual(M6), P ");INSERT INTO _vehiclemodels (`vmodname`,`vmodyear`,`vmanid`,`vmodattributes`) VALUES ('R8',"2009","4","8 cyl, 4.2 L, Manual(M6), P ");