Create table volumes (TSM 5.3-MySQL)

From Wikistix
CREATE TABLE `volumes` (
  `id` int(11) NOT NULL auto_increment,
  `volume_name` varchar(255) NOT NULL default ,
  `stgpool_name` varchar(31) NOT NULL default ,
  `devclass_name` varchar(31) NOT NULL default ,
  `est_capacity_mb` int(11) default NULL,
  `pct_utilized` float default NULL,
  `status` varchar(20) default NULL,
  `access` varchar(20) default NULL,
  `pct_reclaim` float default NULL,
  `scratch` varchar(20) default NULL,
  `error_state` varchar(20) default NULL,
  `num_sides` smallint(6) default NULL,
  `times_mounted` int(11) default NULL,
  `write_pass` int(11) default NULL,
  `last_write_date` datetime default NULL,
  `last_read_date` datetime default NULL,
  `pending_date` datetime default NULL,
  `write_errors` int(11) default NULL,
  `read_errors` int(11) default NULL,
  `location` varchar(255) default NULL,
  `mvslf_capable` char(3) NOT NULL default ,
  `chg_time` datetime default NULL,
  `chg_admin` varchar(30) default NULL,
  `begin_rclm_date` datetime default NULL,
  `end_rclm_date` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `volume_name` (`volume_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1