[Err] 1005 - Can't Create Table '' (Errno: -1)

[rushle]

~~ERROR~~

 

 CREATE TABLE IF NOT EXISTS `rotw_entries` (

`room_id` varchar(211) NOT NULL,

`username` varchar(211) NOT NULL,

`room_name` varchar(211) NOT NULL,

`room_description` varchar(211) NOT NULL,

`state` varchar(211) NOT NULL DEFAULT 'open',

UNIQUE KEY `room_id` (`room_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[Err] 1005 - Can't create table 'rushle_dev.rotw_entries' (errno: -1)

 

~~~SQL CODE~~

 

CREATE TABLE IF NOT EXISTS `rotw_entries` (

`room_id` varchar(211) NOT NULL,

`username` varchar(211) NOT NULL,

`room_name` varchar(211) NOT NULL,

`room_description` varchar(211) NOT NULL,

`state` varchar(211) NOT NULL DEFAULT 'open',

UNIQUE KEY `room_id` (`room_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

CREATE TABLE IF NOT EXISTS `rotw_winners` (

`place` int(1) NOT NULL,

`username` varchar(211) NOT NULL,

`name` varchar(211) NOT NULL,

`description` varchar(211) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

 

INSERT INTO `rotw_winners` (`place`, `username`, `name`, `description`) VALUES

(1, '', '', ''),

(2, '', '', ''),

(3, '', '', '');

 

Best regards rushle

[yashrs]

Change the engine from InnoDB to MyISAM and the queries should work.