diff options
Diffstat (limited to 'sql/updates')
10 files changed, 46 insertions, 0 deletions
diff --git a/sql/updates/2011_01_19_0_characters_account_data.sql b/sql/updates/2011_01_19_0_characters_account_data.sql new file mode 100644 index 00000000000..26e465268d6 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_account_data.sql @@ -0,0 +1,5 @@ +ALTER TABLE `account_data` +CHANGE `account` `account` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `data` `data` BLOB NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_addons.sql b/sql/updates/2011_01_19_0_characters_addons.sql new file mode 100644 index 00000000000..90ebbce5613 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_addons.sql @@ -0,0 +1,3 @@ +ALTER TABLE `addons` +ROW_FORMAT=DEFAULT, +CHANGE `crc` `crc` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_arena_team.sql b/sql/updates/2011_01_19_0_characters_arena_team.sql new file mode 100644 index 00000000000..5942e008bb5 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_arena_team.sql @@ -0,0 +1,4 @@ +ALTER TABLE `arena_team` +CHANGE `name` `name` VARCHAR(24) NOT NULL, +CHANGE `EmblemStyle` `EmblemStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `BorderStyle` `BorderStyle` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_auctionhouse.sql b/sql/updates/2011_01_19_0_characters_auctionhouse.sql new file mode 100644 index 00000000000..20719a2ca61 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_auctionhouse.sql @@ -0,0 +1,11 @@ +ALTER TABLE `auctionhouse` +CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `auctioneerguid` `auctioneerguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `itemguid` `itemguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `itemowner` `itemowner` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `buyoutprice` `buyoutprice` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `buyguid` `buyguid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `lastbid` `lastbid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `startbid` `startbid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `deposit` `deposit` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_bug_report.sql b/sql/updates/2011_01_19_0_characters_bug_report.sql new file mode 100644 index 00000000000..e9c40877e69 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_bug_report.sql @@ -0,0 +1 @@ +ALTER TABLE `addons` ROW_FORMAT=DEFAULT;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_bugreport.sql b/sql/updates/2011_01_19_0_characters_bugreport.sql new file mode 100644 index 00000000000..1ceb0abe429 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_bugreport.sql @@ -0,0 +1,3 @@ +ALTER TABLE `bugreport` +ROW_FORMAT=DEFAULT, +CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identifier';
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_channels.sql b/sql/updates/2011_01_19_0_characters_channels.sql new file mode 100644 index 00000000000..cd70f39e30f --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_channels.sql @@ -0,0 +1,5 @@ +ALTER TABLE `channels` +ROW_FORMAT=DEFAULT, +CHANGE `BannedList` `BannedList` TEXT, +DROP PRIMARY KEY, +ADD PRIMARY KEY (`m_name`, `m_team`);
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_account_data.sql b/sql/updates/2011_01_19_0_characters_character_account_data.sql new file mode 100644 index 00000000000..bf5898266d7 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_account_data.sql @@ -0,0 +1,5 @@ +ALTER TABLE `character_account_data` +CHANGE `guid` `guid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `type` `type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `time` `time` INT(10) UNSIGNED DEFAULT '0' NOT NULL, +CHANGE `data` `data` BLOB NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_achievement.sql b/sql/updates/2011_01_19_0_characters_character_achievement.sql new file mode 100644 index 00000000000..cbfc6e95aa8 --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_achievement.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_achievement` +CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL, +CHANGE `achievement` `achievement` SMALLINT(5) UNSIGNED NOT NULL, +CHANGE `date` `date` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file diff --git a/sql/updates/2011_01_19_0_characters_character_achievement_progress.sql b/sql/updates/2011_01_19_0_characters_character_achievement_progress.sql new file mode 100644 index 00000000000..ba91258f82d --- /dev/null +++ b/sql/updates/2011_01_19_0_characters_character_achievement_progress.sql @@ -0,0 +1,5 @@ +ALTER TABLE `character_achievement_progress` +CHANGE `guid` `guid` INT(10) UNSIGNED NOT NULL, +CHANGE `criteria` `criteria` SMALLINT(5) UNSIGNED NOT NULL, +CHANGE `counter` `counter` INT(10) UNSIGNED NOT NULL, +CHANGE `date` `date` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
\ No newline at end of file |