#1060 - Duplicate column name 'topic_id' , für Testsytem

[Gutschy]

Wieso soll topic_id doppelt sein?? Googel brachte den Ratschlag einfach einen Teil zu löschen

Also

Code: Alles auswählen

PRIMARY KEY ( `topic_id` , `topic_id` ) ,

in

Code: Alles auswählen

PRIMARY KEY ( `topic_id` ) ,

Aber das Teil kommt so im Original von meinem Lamp Host mit MySQL 3.21, mein Testsystem ist in ein Lampp mit MySQL 5.0.18. Warum, warum??

Hier mal die ganze Tabelle

Code: Alles auswählen

# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `phpbb_topics`
#
# Erzeugt am: 17. Februar 2006 um 21:45
# Aktualisiert am: 10. März 2006 um 13:17
# Letzter Check am: 17. Februar 2006 um 21:45
#
CREATE TABLE `phpbb_topics` (
`topic_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`forum_id` smallint( 8 ) unsigned NOT NULL default '0',
`topic_eventid` int( 6 ) NOT NULL default '-1',
`topic_title` varchar( 60 ) NOT NULL default '',
`topic_datum` int( 11 ) NOT NULL default '0',
`topic_ort` varchar( 40 ) NOT NULL default '',
`topic_strasse` varchar( 40 ) NOT NULL default '',
`topic_tel` varchar( 20 ) NOT NULL default '',
`topic_beschreibung` varchar( 60 ) NOT NULL default '',
`topic_uhrzeit` varchar( 60 ) NOT NULL default '',
`topic_preis` varchar( 60 ) NOT NULL default '',
`topic_poster` mediumint( 8 ) NOT NULL default '0',
`topic_time` int( 11 ) NOT NULL default '0',
`topic_views` mediumint( 8 ) unsigned NOT NULL default '0',
`topic_replies` mediumint( 8 ) unsigned NOT NULL default '0',
`topic_status` tinyint( 3 ) NOT NULL default '0',
`topic_vote` tinyint( 1 ) NOT NULL default '0',
`topic_type` tinyint( 3 ) NOT NULL default '0',
`topic_first_post_id` mediumint( 8 ) unsigned NOT NULL default '0',
`topic_last_post_id` mediumint( 8 ) unsigned NOT NULL default '0',
`topic_moved_id` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `topic_id` , `topic_id` ) ,
UNIQUE KEY `topic_id` ( `topic_id` ) ,
KEY `forum_id` ( `forum_id` ) ,
KEY `topic_moved_id` ( `topic_moved_id` ) ,
KEY `topic_status` ( `topic_status` ) ,
KEY `topic_type` ( `topic_type` )
) TYPE = MYISAM AUTO_INCREMENT =1682;