~~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
