I have XAMPP working and configured correctly. Does XAMPP include the InnoDB engine for MySQL?
I'm using the code:
/*Table structure for table `data_validation_type` */
DROP TABLE IF EXISTS `data_validation_type`;
CREATE TABLE `data_validation_type` (
`data_validation_type_ID` bigint(20) NOT NULL auto_increment COMMENT 'The ID of the data validation type',
`data_validation_type_Name` text collate utf8_unicode_ci NOT NULL COMMENT 'The Name of the data validation type',
`data_validation_type_Description` longtext collate utf8_unicode_ci NOT NULL COMMENT 'The Description of the data validation type',
PRIMARY KEY (`data_validation_type_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
But it inserts as 'MYISAM' instead.