Create table libvolumes (TSM 5.3-MySQL)

CREATE TABLE `libvolumes` (
  `id` int(11) NOT NULL auto_increment,
  `library_name` varchar(30) NOT NULL default ,
  `volume_name` varchar(255) NOT NULL default ,
  `status` varchar(10) default NULL,
  `owner` varchar(64) default NULL,
  `last_use` varchar(10) default NULL,
  `home_element` int(11) default NULL,
  `cleanings_left` int(11) default NULL,
  `devtype` varchar(4) default NULL,
  `mediatype` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `library_name` (`library_name`,`volume_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1