INSTALL DB: duplicate column name error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
metadatagames |
Fix Committed
|
Critical
|
Vincent Van Uffelen |
Bug Description
When I tried setting up a new database and importing mg.mysql.0.8.2.sql, I get the following error:
Error
SQL query:
CREATE TABLE IF NOT EXISTS `game_submission` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`submission` TEXT NOT NULL ,
`turn` INT( 11 ) NOT NULL DEFAULT 0,
`session_id` INT( 11 ) NOT NULL ,
`played_game_id` INT( 11 ) NOT NULL ,
`turn` DATETIME NULL ,
PRIMARY KEY ( `id` ) ,
CONSTRAINT `fk_game_
CONSTRAINT `fk_game_
) ENGINE = InnoDB;
MySQL said: Documentation
#1060 - Duplicate column name 'turn'
Changed in metadatagames: | |
status: | New → Fix Committed |
fix commited. sha1: aea44d0fc7a04b5 210cc92ebaa4fdc af7480ee2e