aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2014-06-11 20:54:18 +0200
committerShauren <shauren.trinity@gmail.com>2014-06-11 20:54:18 +0200
commit3ba12323102f31b184ee4604cd36d0c95e3e570b (patch)
tree390f1b7eb49bcfc2a842aa45e3df676106948a54
parent2b6575692b932fd70758f1fb8ce3b05cdf9c4f4a (diff)
SQL: Reordered statements to fix import
-rw-r--r--sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql7
1 files changed, 3 insertions, 4 deletions
diff --git a/sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql b/sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql
index f4410c58976..704902e9742 100644
--- a/sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql
+++ b/sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql
@@ -1,7 +1,3 @@
-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`;
@@ -146,3 +142,6 @@ INSERT INTO `battlenet_modules` VALUES
/*!40000 ALTER TABLE `battlenet_modules` ENABLE KEYS */;
UNLOCK TABLES;
+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;