From a2a751b9d6ee3a86045cca2e1444499bd290708b Mon Sep 17 00:00:00 2001 From: laserjet Date: Sat, 23 Apr 2011 10:56:04 +0200 Subject: DB: Fixed comments in character_banned table Closes #1273 --- sql/base/characters_database.sql | 2 +- sql/updates/auth_char/2011_04_23_01_characters_character_banned.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 sql/updates/auth_char/2011_04_23_01_characters_character_banned.sql (limited to 'sql') 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'; -- cgit v1.2.3