Create table drives (TSM 5.3-MySQL)

CREATE TABLE `drives` (
  `library_name` varchar(30) NOT NULL default ,
  `drive_name` varchar(30) NOT NULL default ,
  `device_type` varchar(16) NOT NULL default ,
  `online` varchar(40) NOT NULL default ,
  `element` smallint(6) default NULL,
  `acs_drive_id` varchar(15) default NULL,
  `allocated_to` varchar(64) default NULL,
  `last_update_by` varchar(64) NOT NULL default ,
  `last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  `clean_freq` varchar(10) default NULL,
  `drive_serial` varchar(64) NOT NULL default ,
  `volume_name` text,
  PRIMARY KEY  (`library_name`,`drive_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1