View Single Post
  #1  
Old 08-27-2009, 01:25 PM
drakelord
Hill Giant
 
Join Date: Nov 2002
Location: NC, USA
Posts: 182
Default 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`)
__________________
Hmm.
Reply With Quote