Jump to content

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


Recommended Posts

Posted
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;
+

Posted

s0041_10254_01_characters_auctionhouse.sql already have

DROP TABLE IF EXISTS auction;

RENAME TABLE auctionhouse TO auction;

and it added to mangos-0.12 sql updates

So i not understand about what you talk also...

[added]

Oh, I see now.... sometime my brain stuck ;)

Posted

Oh, I see now.... sometime my brain stuck ;)

This is natural after hard work in programing ;)

I see you simultaneous working in several branchs and i very thankful to you for working in 0.12 branch :)

Good luck .

×
×
  • 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