diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/world_database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 8c9028499b5..8b7682b148b 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -26721,11 +26721,13 @@ DROP TABLE IF EXISTS `transports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transports` ( + `guid` int(10) unsigned NOT NULL AUTO_INCREMENT, `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` text, `period` mediumint(8) unsigned NOT NULL DEFAULT '0', `ScriptName` char(64) NOT NULL DEFAULT '', - PRIMARY KEY (`entry`) + PRIMARY KEY (`guid`), + UNIQUE INDEX `idx_entry` (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports'; /*!40101 SET character_set_client = @saved_cs_client */; |