aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorSpp <none@none>2010-09-10 13:37:33 +0200
committerSpp <none@none>2010-09-10 13:37:33 +0200
commitfd14d7195f19fcff4fb5f68caf85062fcc2c8406 (patch)
treea73dca68d4d28eef8837235cd4b4c0e6d847a443 /sql/base
parent842a79d38c3a837a455e9b27d26c5578b86fa58f (diff)
Core: Minor code cleanup before next commits
--HG-- branch : trunk
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql8
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 */;