From ffdeeb3195bf86686398885765f6551deb0acd2e Mon Sep 17 00:00:00 2001 From: leak Date: Tue, 25 Jan 2011 14:40:05 +0100 Subject: SQL: Minor cleanup in existing roll up patches --- sql/updates/2011_01_20_0_characters_gm_tickets.sql | 2 +- sql/updates/2011_01_20_0_characters_guild.sql | 4 ++-- sql/updates/2011_01_20_0_characters_guild_rank.sql | 2 +- 3 files changed, 4 insertions(+), 4 deletions(-) (limited to 'sql') 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 -- cgit v1.2.3