diff options
author | Shauren <shauren.trinity@gmail.com> | 2014-06-11 20:54:18 +0200 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2014-06-11 20:54:18 +0200 |
commit | 3ba12323102f31b184ee4604cd36d0c95e3e570b (patch) | |
tree | 390f1b7eb49bcfc2a842aa45e3df676106948a54 | |
parent | 2b6575692b932fd70758f1fb8ce3b05cdf9c4f4a (diff) |
SQL: Reordered statements to fix import
-rw-r--r-- | sql/updates/auth/2014_05_06_00_auth_battlenet_434.sql | 7 |
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; |