[svenkaiser]

Hallo zusammen,
ich habe das folgende Problem mit dem Rückspielen eines Backups, diese Tabelle wird nicht angelegt, alle anderen sind da. kann mir jemand verraten wo der syntax-fehler ist? bin leider recht unbedarft :-(

SQL-Befehl :

CREATE TABLE IF NOT EXISTS `mybb_threads` (
`tid` int(10) unsigned NOT NULL auto_increment,
`fid` smallint(5) unsigned NOT NULL default '0',
`subject` varchar(120) binary NOT NULL default '',
`icon` smallint(5) unsigned NOT NULL default '0',
`poll` int(10) unsigned NOT NULL default '0',
`uid` int(10) unsigned NOT NULL default '0',
`username` varchar(80) binary NOT NULL default '',
`dateline` bigint(30) NOT NULL default '0',
`firstpost` int(10) unsigned NOT NULL default '0',
`lastpost` bigint(30) NOT NULL default '0',
`lastposter` varchar(120) binary NOT NULL default '',
`lastposteruid` int(10) unsigned NOT NULL default '0',
`views` int(100) NOT NULL default '0',
`replies` int(100) NOT NULL default '0',
`closed` varchar(30) binary NOT NULL default '',
`sticky` int(1) NOT NULL default '0',
`numratings` smallint(5) unsigned NOT NULL default '0',
`totalratings` smallint(5) unsigned NOT NULL default '0',
`notes` text NOT NULL,
`visible` int(1) NOT NULL default '0',
`unapprovedposts` int(10) unsigned NOT NULL default '0',
`attachmentcount` int(10) unsigned NOT NULL default '0',
`deletetime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tid`),
FULLTEXT KEY `subject` (`subject`)
) TYPE=MyISAM AUTO_INCREMENT=61
MySQL meldet:

Can't create table './DB132267/mybb_threads.frm' (errno: 140)

[Michael]

Versuchs mal damit:

Code:

CREATE TABLE mybb_threads (
  tid int unsigned NOT NULL auto_increment,
  fid smallint unsigned NOT NULL default '0',
  subject varchar(120) NOT NULL default '',
  icon smallint unsigned NOT NULL default '0',
  poll int unsigned NOT NULL default '0',
  uid int unsigned NOT NULL default '0',
  username varchar(80) NOT NULL default '',
  dateline bigint(30) NOT NULL default '0',
  firstpost int unsigned NOT NULL default '0',
  lastpost bigint(30) NOT NULL default '0',
  lastposter varchar(120) NOT NULL default '',
  lastposteruid int unsigned NOT NULL default '0',
  views int(100) NOT NULL default '0',
  replies int(100) NOT NULL default '0',
  closed varchar(30) NOT NULL default '',
  sticky int(1) NOT NULL default '0',
  numratings smallint unsigned NOT NULL default '0',
  totalratings smallint unsigned NOT NULL default '0',
  notes text NOT NULL,
  visible int(1) NOT NULL default '0',
  unapprovedposts int(10) unsigned NOT NULL default '0',
  attachmentcount int(10) unsigned NOT NULL default '0',
  deletetime int(10) unsigned NOT NULL default '0',
  KEY fid (fid, visible, sticky),
  KEY dateline (dateline),
  KEY lastpost (lastpost, fid),
  KEY firstpost (firstpost),
  KEY uid (uid),
  PRIMARY KEY  (tid)
) TYPE=MyISAM AUTO_INCREMENT=61;

[svenkaiser]

vielen dank. das hat so funktioniert.