use cmon; CREATE TABLE `diskdata` ( `nodeid` int(11) NOT NULL AUTO_INCREMENT, `file_name` varchar(64) NOT NULL, `ts_name` varchar(64) NOT NULL, `type` varchar(64) NOT NULL, `logfile_group_name` varchar(64) NOT NULL, `free_extents` bigint(20) unsigned NOT NULL, `total_extents` bigint(20) unsigned NOT NULL, `extent_size` bigint(20) unsigned NOT NULL, `initial_size` bigint(20) unsigned NOT NULL, `maximum_size` bigint(20) unsigned NOT NULL, `undo_buffer_size` bigint(20) unsigned NOT NULL, `report_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`nodeid`,`file_name`) ) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=latin1;