aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorlaserjet <laserjet@trinitycore.org>2011-04-23 10:56:04 +0200
committerShauren <shauren.trinity@gmail.com>2011-04-23 10:56:04 +0200
commita2a751b9d6ee3a86045cca2e1444499bd290708b (patch)
tree3bde3bf6ac3981cb6d17716632ae4efceb59bf2e
parentca451a8cd1ea3e67a78d34db453ff8599e612c46 (diff)
DB: Fixed comments in character_banned table
Closes #1273
-rw-r--r--sql/base/characters_database.sql2
-rw-r--r--sql/updates/auth_char/2011_04_23_01_characters_character_banned.sql1
2 files changed, 2 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index c9d1bd435c1..9ae42ffc566 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -434,7 +434,7 @@ DROP TABLE IF EXISTS `character_banned`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_banned` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account id',
+ `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`bandate` int(10) unsigned NOT NULL DEFAULT '0',
`unbandate` int(10) unsigned NOT NULL DEFAULT '0',
`bannedby` varchar(50) NOT NULL,
diff --git a/sql/updates/auth_char/2011_04_23_01_characters_character_banned.sql b/sql/updates/auth_char/2011_04_23_01_characters_character_banned.sql
new file mode 100644
index 00000000000..67eee444844
--- /dev/null
+++ b/sql/updates/auth_char/2011_04_23_01_characters_character_banned.sql
@@ -0,0 +1 @@
+ALTER TABLE `character_banned` CHANGE COLUMN `guid` `guid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';