EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Bug Reports (https://www.eqemulator.org/forums/forumdisplay.php?f=591)
-   -   SQL Bug on REV 964 (https://www.eqemulator.org/forums/showthread.php?t=29355)

drakelord 08-27-2009 01:25 PM

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`)


All times are GMT -4. The time now is 09:28 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.