*************************** 1. row *************************** Table: turbine_information Create Table: CREATE TABLE `turbine_information` ( `turbine_id` int(11) NOT NULL AUTO_INCREMENT, `turbine_serial` char(20) COLLATE latin1_general_ci NOT NULL, `site_index` int(11) NOT NULL, `turbine_name` char(32) COLLATE latin1_general_ci NOT NULL, `configuration_name` char(64) COLLATE latin1_general_ci NOT NULL, `turbine_note` text COLLATE latin1_general_ci, `duplicated` tinyint(1) DEFAULT '0', `duplicated_details` char(128) COLLATE latin1_general_ci DEFAULT NULL, `display_name` varchar(32) COLLATE latin1_general_ci DEFAULT NULL, PRIMARY KEY (`turbine_id`,`site_index`), UNIQUE KEY `turbine_id` (`turbine_id`), UNIQUE KEY `turbine_serial` (`turbine_serial`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci