Create table stgpools (TSM 5.3-MySQL)

From Wikistix
CREATE TABLE `stgpools` (
  `stgpool_name` varchar(31) NOT NULL default ,
  `pooltype` varchar(31) NOT NULL default ,
  `devclass` varchar(31) NOT NULL default ,
  `est_capacity_mb` bigint(20) NOT NULL default '0',
  `pct_utilized` float NOT NULL default '0',
  `pct_migr` float default NULL,
  `pct_logical` float NOT NULL default '0',
  `highmig` tinyint(4) default NULL,
  `lowmig` tinyint(4) default NULL,
  `migprocess` smallint(6) default NULL,
  `nextstgpool` varchar(31) default NULL,
  `maxsize` bigint(20) default NULL,
  `access` varchar(15) default NULL,
  `description` varchar(255) default NULL,
  `ovflocation` varchar(255) default NULL,
  `cache` char(3) default NULL,
  `collocate` varchar(20) default NULL,
  `reclaim` smallint(6) default NULL,
  `maxscratch` smallint(6) default NULL,
  `reusedelay` smallint(6) default NULL,
  `migr_running` varchar(20) default NULL,
  `migr_mb` float default NULL,
  `migr_seconds` smallint(6) default NULL,
  `recl_running` varchar(20) default NULL,
  `chg_time` datetime default NULL,
  `chg_admin` varchar(30) default NULL,
  `reclaimstgpool` varchar(31) default NULL,
  `migdelay` smallint(6) default NULL,
  `migcontinue` varchar(20) default NULL,
  `dataformat` varchar(12) default NULL,
  `copystgpools` text,
  `copycontinue` varchar(20) default NULL,
  `crcdata` varchar(9) default NULL,
  `reclaimprocess` smallint(6) default NULL,
  `offsiterclmlimit` varchar(8) default NULL,
  `reclamationtype` varchar(9) NOT NULL default ,
  PRIMARY KEY  (`stgpool_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1