MySQL4 to MySQL5.x !

Hallo earlyhost

ich muss folgende sql in einem mysql 5. datenbank einspielen allerdings bekomme ich immer fehler. Könntest du mal blick reinwerfen wo ich was ändern muss damit es klappt?

Herzlichen dank

CREATE TABLE `movies` (
  `fid` smallint(5) unsigned NOT NULL auto_increment,    # pk
  `id` mediumint(7) unsigned zerofill NOT NULL default '0000000', # imdb-key
  `nr` smallint(3) unsigned zerofill NOT NULL default '000',
  `runtime` smallint(4) unsigned NOT NULL default '0',
  `inserted` date default NULL,
  `year` year(4) default NULL,
  `genre` set('Action','Adult','Adventure','Animation','Comedy','Crime','Documentary','Drama','Family','Fantasy','Film-Noir','Horror','Music','Musical','Mystery','Romance','Sci-Fi','Short','Thriller',' War','Western') default NULL,
  `lang` set('DE','EN','ES','FR','IT','RU','TR','?') default 'EN',
  `audio` enum('AC3','DTS','MP2','MP3','AAC','ATRAC','AMR','OGG','WMA') NOT NULL default 'AC3',
  `channel` enum('1.0','1/1','2.0','2.1','3.0','3.1','4.0','5.1','6.1','7.1') NOT NULL default '5.1',
  `herz` enum('24.0','32.0','44.1','48.0','96.0') NOT NULL default '48.0',
  `video` enum('MPEG-1','MPEG-2','MPEG-4','DivX','Xvid','3ivx','h263','h264','WMV') NOT NULL default 'MPEG-2',
  `width` mediumint(4) unsigned default NULL,
  `height` mediumint(4) unsigned default NULL,
  `container` enum('MPEG-1','MPEG-2','MP4','AVI','ASF','MOV','OGG','3GP') NOT NULL default 'MPEG-2',
  `ratio` enum('16:9','4:3','LetterBox','Pan&Scan','Flexibly') NOT NULL default '16:9',
  `format` enum('PAL','NTSC','FILM','15','20','24','25','30','50','60') NOT NULL default 'PAL',
  `medium` enum('VideoDVD','ISO-DVD','MiniDVD','ISO-CD','VideoCD','SuperVCD','UMD','BD','HD-DVD','Disk','Stick','Card') NOT NULL default 'VideoDVD',
  `type` enum('-R','+R','-RW','+RW','Ram','Rom','Worm','-') NOT NULL default '-R',
  `disks` tinyint(2) unsigned NOT NULL default '1',
  `rating` tinyint(2) unsigned default NULL,
  `name` varchar(100) NOT NULL default '',
  `local` varchar(100) default NULL,
  `aka` varchar(200) default NULL,
  `country` varchar(200) default NULL,
  `cat` varchar(10) default NULL,
  `comment` varchar(200) default NULL,
  `avail` tinyint(1) unsigned default '1',
  `lentsince` date default NULL,
  `lentto` tinyint(2) unsigned default NULL,
  `poster` blob,
  PRIMARY KEY  (`fid`),
  KEY `nr` (`nr`),
  FULLTEXT KEY `name` (`name`,`local`,`aka`)
) TYPE=MyISAM;

Das ist die Fehlermeldung:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Fehler bei der Anfrage:

CREATE TABLE `movies` ( `fid` smallint(5) unsigned NOT NULL auto_increment, # pk `id` mediumint(7) unsigned zerofill NOT NULL default '0000000', # imdb-key `nr` smallint(3) unsigned zerofill NOT NULL default '000', `runtime` smallint(4) unsigned NOT NULL default '0', `inserted` date default NULL, `year` year(4) default NULL, `genre` set('Action','Adult','Adventure','Animation','Comedy','Crime','Documentary','Drama','Family','Fantasy','Film-Noir','Horror','Music','Musical','Mystery','Romance','Sci-Fi','Short','Thriller',' War','Western') default NULL, `lang` set('DE','EN','ES','FR','IT','RU','TR','?') default 'EN', `audio` enum('AC3','DTS','MP2','MP3','AAC','ATRAC','AMR','OGG','WMA') NOT NULL default 'AC3', `channel` enum('1.0','1/1','2.0','2.1','3.0','3.1','4.0','5.1','6.1','7.1') NOT NULL default '5.1', `herz` enum('24.0','32.0','44.1','48.0','96.0') NOT NULL default '48.0', `video` enum('MPEG-1','MPEG-2','MPEG-4','DivX','Xvid','3ivx','h263','h264','WMV') NOT NULL default 'MPEG-2', `width` mediumint(4) unsigned default NULL, `height` mediumint(4) unsigned default NULL, `container` enum('MPEG-1','MPEG-2','MP4','AVI','ASF','MOV','OGG','3GP') NOT NULL default 'MPEG-2', `ratio` enum('16:9','4:3','LetterBox','Pan&Scan','Flexibly') NOT NULL default '16:9', `format` enum('PAL','NTSC','FILM','15','20','24','25','30','50','60') NOT NULL default 'PAL', `medium` enum('VideoDVD','ISO-DVD','MiniDVD','ISO-CD','VideoCD','SuperVCD','UMD','BD','HD-DVD','Disk','Stick','Card') NOT NULL default 'VideoDVD', `type` enum('-R','+R','-RW','+RW','Ram','Rom','Worm','-') NOT NULL default '-R', `disks` tinyint(2) unsigned NOT NULL default '1', `rating` tinyint(2) unsigned default NULL, `name` varchar(100) NOT NULL default '', `local` varchar(100) default NULL, `aka` varchar(200) default NULL, `country` varchar(200) default NULL, `cat` varchar(10) default NULL, `comment` varchar(200) default NULL, `avail` tinyint(1) unsigned default '1', `lentsince` date default NULL, `lentto` tinyint(2) unsigned default NULL, `poster` blob, PRIMARY KEY (`fid`), KEY `nr` (`nr`), FULLTEXT KEY `name` (`name`,`local`,`aka`)) TYPE=MyISAM

MySQL meldet:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

hättest du ne iddee warum das kommt earlyhost?