Create table filespaces (TSM 5.3-MySQL)

CREATE TABLE `filespaces` (
  `id` int(11) NOT NULL auto_increment,
  `node_name` varchar(64) NOT NULL default ,
  `filespace_name` text NOT NULL,
  `filespace_id` int(11) NOT NULL default '0',
  `filespace_type` varchar(32) NOT NULL default ,
  `capacity` double NOT NULL default '0',
  `pct_util` double NOT NULL default '0',
  `backup_start` datetime default NULL,
  `backup_end` datetime default NULL,
  `delete_occurred` datetime default NULL,
  `unicode_filespace` enum('YES','NO') default NULL,
  `filespace_hexname` text,
  PRIMARY KEY  (`id`),
  KEY `node_name` (`node_name`,`filespace_name`(255),`filespace_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1