CREATE TABLE `Amenities` ( `ID` INT  NOT NULL  AUTO_INCREMENT ,
`Amenities` TINYTEXT  NOT NULL ,
`A1` TINYTEXT  NOT NULL ,
`A1sp` TINYTEXT  NOT NULL ,
`A1vt` TINYTEXT  NOT NULL ,
`A2` TINYTEXT  NOT NULL ,
`A2sp` TINYTEXT  NOT NULL ,
`A2vt` TINYTEXT  NOT NULL ,
`A3` TINYTEXT  NOT NULL ,
`A3sp` TINYTEXT  NOT NULL ,
`A3vt` TINYTEXT  NOT NULL ,
`A4` TINYTEXT  NOT NULL ,
`A4sp` TINYTEXT  NOT NULL ,
`A4vt` TINYTEXT  NOT NULL ,
`A5` TINYTEXT  NOT NULL ,
`A5sp` TINYTEXT  NOT NULL ,
`A5vt` TINYTEXT  NOT NULL ,
`A6` TINYTEXT  NOT NULL ,
`A6sp` TINYTEXT  NOT NULL ,
`A6vt` TINYTEXT  NOT NULL ,
`A7` TINYTEXT  NOT NULL ,
`A7sp` TINYTEXT  NOT NULL ,
`A7vt` TINYTEXT  NOT NULL ,
`A8` TINYTEXT  NOT NULL ,
`A8sp` TINYTEXT  NOT NULL ,
`A8vt` TINYTEXT  NOT NULL ,
`A9` TINYTEXT  NOT NULL ,
`A9sp` TINYTEXT  NOT NULL ,
`A9vt` TINYTEXT  NOT NULL ,
`A10` TINYTEXT  NOT NULL ,
`A10sp` TINYTEXT  NOT NULL ,
`A10vt` TINYTEXT  NOT NULL ,
`A11` TINYTEXT  NOT NULL ,
`A11sp` TINYTEXT  NOT NULL ,
`A11vt` TINYTEXT  NOT NULL ,
`A12` TINYTEXT  NOT NULL ,
`A12sp` TINYTEXT  NOT NULL ,
`A12vt` TINYTEXT  NOT NULL ,
`A13` TINYTEXT  NOT NULL ,
`A13sp` TINYTEXT  NOT NULL ,
`A13vt` TINYTEXT  NOT NULL ,
`A14` TINYTEXT  NOT NULL ,
`A14sp` TINYTEXT  NOT NULL ,
`A14vt` TINYTEXT  NOT NULL ,
`A15` TINYTEXT  NOT NULL ,
`A15sp` TINYTEXT  NOT NULL ,
`A15vt` TINYTEXT  NOT NULL ,
`A16` TINYTEXT  NOT NULL ,
`A16sp` TINYTEXT  NOT NULL ,
`A16vt` TINYTEXT  NOT NULL ,
PRIMARY KEY (`ID`) );
INSERT INTO `Amenities` (`Amenities`, `A1`, `A1sp`, `A1vt`, `A2`, `A2sp`, `A2vt`, `A3`, `A3sp`, `A3vt`, `A4`, `A4sp`, `A4vt`, `A5`, `A5sp`, `A5vt`, `A6`, `A6sp`, `A6vt`, `A7`, `A7sp`, `A7vt`, `A8`, `A8sp`, `A8vt`, `A9`, `A9sp`, `A9vt`, `A10`, `A10sp`, `A10vt`, `A11`, `A11sp`, `A11vt`, `A12`, `A12sp`, `A12vt`, `A13`, `A13sp`, `A13vt`, `A14`, `A14sp`, `A14vt`, `A15`, `A15sp`, `A15vt`, `A16`, `A16sp`, `A16vt`) VALUES  ('villageAtWildDunes', 'The Village At Wild Dunes', '3415_0907', '', 'Pavillian Lake', '3300_0907', '3269_0907', 'Pavillian Lake', '3302_0907', '3273_0907', 'Pavillian Lake', '3316_0907', '3275_0907', 'The Pavillion', '3088_0907', '', 'The Plaza', '3080_0907', '', 'The Plaza', '3311_0907', '', 'The Plaza', '3517_0907', '', 'The Plaza', '3338_0907', '', 'Guest Services', '3327_0907', '', 'The Lettered Olive', '3305_0907', '', 'The Lettered Olive', '3344_0907', '', 'The Fitness Center', '3325_0907', '', 'Wild Dunes Real Estate', '3335_0907', '', 'The Lake', '3496_0907', '', 'The Lake', '3497_0907', '');