diff options
| -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; |