Create table nodes (TSM 5.3-MySQL)

CREATE TABLE `nodes` (
  `id` int(11) NOT NULL auto_increment,
  `node_name` varchar(64) NOT NULL default ,
  `platform_name` varchar(16) default NULL,
  `domain_name` varchar(30) NOT NULL default ,
  `pwset_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `invalid_pw_count` int(11) NOT NULL default '0',
  `contact` text NOT NULL,
  `compression` enum('NO','YES','CLIENT') NOT NULL default 'NO',
  `archdelete` enum('YES','NO') NOT NULL default 'YES',
  `backdelete` enum('YES','NO') NOT NULL default 'YES',
  `locked` enum('YES','NO') NOT NULL default 'YES',
  `lastacc_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `reg_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `reg_admin` varchar(64) NOT NULL default ,
  `lastsess_commmeth` varchar(8) default NULL,
  `lastsess_recvd` bigint(20) NOT NULL default '0',
  `lastsess_sent` bigint(20) NOT NULL default '0',
  `lastsess_duration` int(11) NOT NULL default '0',
  `lastsess_idlewait` int(11) NOT NULL default '0',
  `lastsess_commwait` int(11) NOT NULL default '0',
  `lastsess_mediawait` int(11) NOT NULL default '0',
  `client_version` smallint(6) default NULL,
  `client_release` smallint(6) default NULL,
  `client_level` smallint(6) default NULL,
  `client_sublevel` smallint(6) default NULL,
  `client_os_level` varchar(20) default NULL,
  `option_set` varchar(64) default NULL,
  `aggregation` enum('YES','NO') NOT NULL default 'YES',
  `url` varchar(200) default NULL,
  `nodetype` varchar(8) NOT NULL default ,
  `passexp` int(11) default NULL,
  `keep_mp` enum('YES','NO') NOT NULL default 'YES',
  `max_mp_allowed` int(11) NOT NULL default '0',
  `auto_fs_rename` enum('NO','YES','CLIENT') default 'NO',
  `validateprotocol` varchar(8) default NULL,
  `tcp_name` varchar(64) default NULL,
  `tcp_address` varchar(64) default NULL,
  `guid` varchar(48) default NULL,
  `txngroupmax` int(11) default NULL,
  `datawritepath` varchar(12) default NULL,
  `datareadpath` varchar(12) default NULL,
  `session_initiation` varchar(255) default NULL,
  `client_hla` varchar(64) default NULL,
  `client_lla` varchar(64) default NULL,
  `collocgroup_name` varchar(30) default NULL,
  `proxy_target` text,
  `proxy_agent` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ind1` (`node_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1