Jump to content

[s0073][Mangos-0.12] missed part of [s0041]


Guest mns

Recommended Posts

diff --git a/sql/updates/before_upgrade_to_0.13/Makefile.am b/sql/updates/before_upgrade_to_0.13/Makefile.am
index 3fd0aa7..6a23474 100644
--- a/sql/updates/before_upgrade_to_0.13/Makefile.am
+++ b/sql/updates/before_upgrade_to_0.13/Makefile.am
@@ -42,6 +42,7 @@ pkgdata_DATA = \\
 111_9767_03_characters_characters.sql \\
 112_8874_01_characters_character_skills.sql \\
 114_9849_01_characters_saved_variables.sql \\
+ s0041_10254_01_characters_auctionhouse.sql \\
 README

## Additional files to include when running 'make dist'
@@ -64,4 +65,5 @@ EXTRA_DIST = \\
 111_9767_03_characters_characters.sql \\
 112_8874_01_characters_character_skills.sql \\
 114_9849_01_characters_saved_variables.sql \\
+ s0041_10254_01_characters_auctionhouse.sql \\
 README
diff --git a/sql/updates/before_upgrade_to_0.13/s0041_10254_01_characters_auctionhouse.sql b/sql/updates/before_upgrade_to_0.13/s0041_10254_01_characters_auctionhouse.sql
new file mode 100644
index 0000000..ee2551d
--- /dev/null
+++ b/sql/updates/before_upgrade_to_0.13/s0041_10254_01_characters_auctionhouse.sql
@@ -0,0 +1,16 @@
+ALTER TABLE character_db_version CHANGE COLUMN required_s0041_10254_01_characters_auctionhouse required_114_9849_01_characters_saved_variables bit;
+
+DROP TABLE IF EXISTS auctionhouse;
+RENAME TABLE auction TO auctionhouse;
+
+ALTER TABLE auctionhouse
+  ADD COLUMN location tinyint(3) unsigned NOT NULL DEFAULT '3' AFTER deposit;
+
+ALTER TABLE auctionhouse
+  ADD COLUMN auctioneerguid int(11) unsigned NOT NULL DEFAULT '0' AFTER id;
+
+UPDATE auctionhouse SET  location = houseid;
+
+ALTER TABLE auctionhouse
+  DROP COLUMN houseid;
+

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use