diff options
| author | Shauren <shauren.trinity@gmail.com> | 2014-06-08 13:02:16 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2014-06-08 13:02:16 +0200 |
| commit | 372f043a68788f1903232392546c0d386b9fc248 (patch) | |
| tree | 6c7607a022e220261a79b3e3eaa81628d368ba75 /sql/base | |
| parent | 6eee75a4f76b1965708ee52fa785d8d7555c0a16 (diff) | |
SQL: Sorted out temporary names and added missing statements
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 2d217dabe91..7ab0c855f45 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -46,8 +46,10 @@ CREATE TABLE `account` ( `locale` tinyint(3) unsigned NOT NULL DEFAULT '0', `os` varchar(3) NOT NULL DEFAULT '', `recruiter` int(10) unsigned NOT NULL DEFAULT '0', + `battlenet_account` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), - UNIQUE KEY `idx_username` (`username`) + UNIQUE KEY `idx_username` (`username`), + CONSTRAINT `fk_bnet_acc` FOREIGN KEY (`battlenet_account`) REFERENCES `battlenet_accounts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account System'; /*!40101 SET character_set_client = @saved_cs_client */; |