SQL: Sorted out temporary names and added missing statements

2 files changed, 4 insertions, 0 deletions

diff --git a/sql/updates/auth/2014_xx_xx_00_auth_battlenet.sql b/sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql
index 141c21dde54..f4410c58976 100644
--- a/sql/updates/auth/2014_xx_xx_00_auth_battlenet.sql
+++ b/sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql
@@ -1,3 +1,7 @@
+ALTER TABLE `account`
+  ADD `battlenet_account` int(10) unsigned DEFAULT NULL AFTER `recruiter`,
+  ADD CONSTRAINT `fk_bnet_acc` FOREIGN KEY (`battlenet_account`) REFERENCES `battlenet_accounts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
+
 ALTER TABLE `realmlist`
   ADD `Region` tinyint(3) UNSIGNED NOT NULL DEFAULT 2 AFTER `gamebuild`,
   ADD `Battlegroup` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 AFTER `Region`;
diff --git a/sql/updates/auth/2014_xx_xx_01_auth_battlenet.sql b/sql/updates/auth/2014_06_01_00_auth_battlenet_434.sql
index ee88c91b323..ee88c91b323 100644
--- a/sql/updates/auth/2014_xx_xx_01_auth_battlenet.sql
+++ b/sql/updates/auth/2014_06_01_00_auth_battlenet_434.sql