EQEmulator Forums - SQL Bug on REV 964

With the included SQL on Revision 964, there is a minor bug.

Code:

CREATE TABLE `reports` (

  `id` int(10) unsigned NOT NULL auto_increment,

  `name` varchar(64) default NULL,

  `reported` varchar(64) default NULL,

  `reported_text` text,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `id` (`id`),

) ENGINE=InnoDB;

This is the original. The extra comma at line 7 on the very end prevents it from being sourced correctly. It should be

Code:

UNIQUE KEY `id` (`id`)