diff options
| -rw-r--r-- | sql/updates/2011_01_20_0_characters_gm_tickets.sql | 2 | ||||
| -rw-r--r-- | sql/updates/2011_01_20_0_characters_guild.sql | 4 | ||||
| -rw-r--r-- | sql/updates/2011_01_20_0_characters_guild_rank.sql | 2 |
3 files changed, 4 insertions, 4 deletions
diff --git a/sql/updates/2011_01_20_0_characters_gm_tickets.sql b/sql/updates/2011_01_20_0_characters_gm_tickets.sql index 44e88f44390..9965797cbf3 100644 --- a/sql/updates/2011_01_20_0_characters_gm_tickets.sql +++ b/sql/updates/2011_01_20_0_characters_gm_tickets.sql @@ -2,7 +2,7 @@ ALTER TABLE `gm_tickets` ROW_FORMAT=DEFAULT, CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `playerGuid` `playerGuid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, -CHANGE `name` `name` VARCHAR(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, +CHANGE `name` `name` VARCHAR(12) NOT NULL, CHANGE `createtime` `createtime` INT(10) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `map` `map` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `timestamp` `timestamp` INT(10) UNSIGNED DEFAULT '0' NOT NULL, diff --git a/sql/updates/2011_01_20_0_characters_guild.sql b/sql/updates/2011_01_20_0_characters_guild.sql index f384947a338..89b9df1bf2e 100644 --- a/sql/updates/2011_01_20_0_characters_guild.sql +++ b/sql/updates/2011_01_20_0_characters_guild.sql @@ -1,13 +1,13 @@ ALTER TABLE `guild` ROW_FORMAT=DEFAULT, CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, -CHANGE `name` `name` VARCHAR(24) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL, +CHANGE `name` `name` VARCHAR(24) DEFAULT '' NOT NULL, CHANGE `leaderguid` `leaderguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `EmblemStyle` `EmblemStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `EmblemColor` `EmblemColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `BorderStyle` `BorderStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `BorderColor` `BorderColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `BackgroundColor` `BackgroundColor` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, -CHANGE `motd` `motd` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL, +CHANGE `motd` `motd` VARCHAR(128) DEFAULT '' NOT NULL, CHANGE `createdate` `createdate` INT(10) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `BankMoney` `BankMoney` BIGINT(20) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_20_0_characters_guild_rank.sql b/sql/updates/2011_01_20_0_characters_guild_rank.sql index f66102bd112..d3adb4278a7 100644 --- a/sql/updates/2011_01_20_0_characters_guild_rank.sql +++ b/sql/updates/2011_01_20_0_characters_guild_rank.sql @@ -2,6 +2,6 @@ ALTER TABLE `guild_rank` ROW_FORMAT=DEFAULT, CHANGE `guildid` `guildid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `rid` `rid` TINYINT(3) UNSIGNED NOT NULL, -CHANGE `rname` `rname` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL, +CHANGE `rname` `rname` VARCHAR(15) DEFAULT '' NOT NULL, CHANGE `rights` `rights` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, CHANGE `BankMoneyPerDay` `BankMoneyPerDay` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file |