diff options
| author | Spp <none@none> | 2010-09-10 13:37:33 +0200 |
|---|---|---|
| committer | Spp <none@none> | 2010-09-10 13:37:33 +0200 |
| commit | fd14d7195f19fcff4fb5f68caf85062fcc2c8406 (patch) | |
| tree | a73dca68d4d28eef8837235cd4b4c0e6d847a443 /sql/base | |
| parent | 842a79d38c3a837a455e9b27d26c5578b86fa58f (diff) | |
Core: Minor code cleanup before next commits
--HG--
branch : trunk
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index dc19205cbd6..abe3ffebc1a 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2,7 +2,7 @@ -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 5.0.45-Debian_1ubuntu3.1-log +-- Server version 5.0.45-Debian_1ubuntu3.1-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -1452,7 +1452,7 @@ CREATE TABLE `guild_bank_eventlog` ( `DestTabId` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Destination Tab Id', `TimeStamp` bigint(20) unsigned NOT NULL default '0' COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`,`TabId`), - KEY `guildid_key` (`guildid`), + KEY `guildid_key` (`guildid`), INDEX `Idx_PlayerGuid`(`PlayerGuid`), INDEX `Idx_LogGuid`(`LogGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -1481,7 +1481,7 @@ CREATE TABLE `guild_bank_item` ( `item_guid` int(11) unsigned NOT NULL default '0', `item_entry` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`guildid`,`tabid`,`slotid`), - KEY `guildid_key` (`guildid`), + KEY `guildid_key` (`guildid`), INDEX `Idx_item_guid`(`item_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1977,7 +1977,7 @@ CREATE TABLE `petition_sign` ( `player_account` int(11) unsigned NOT NULL default '0', `type` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`petitionguid`,`playerguid`), - INDEX `Idx_playerguid`(`playerguid`), + INDEX `Idx_playerguid`(`playerguid`), INDEX `Idx_ownerguid`(`ownerguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; |
