diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2016-04-11 02:42:03 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2016-04-11 02:42:03 +0100 |
| commit | a1f59c9d8d9351bd4373e1e4355eee09369c589f (patch) | |
| tree | 367eb1eb8ad29763cabcf5c66f6958721e4e3337 /sql/base/auth_database.sql | |
| parent | 580773dc1a52cf6c8177647baf15afccd557be60 (diff) | |
TDB 6.04 - 2016/04/11TDB6.04
Diffstat (limited to 'sql/base/auth_database.sql')
| -rw-r--r-- | sql/base/auth_database.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 35af91a9e5b..ca33fc2cdbe 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -127,11 +127,11 @@ CREATE TABLE `account_last_played_character` ( `accountId` int(10) unsigned NOT NULL, `region` tinyint(3) unsigned NOT NULL, `battlegroup` tinyint(3) unsigned NOT NULL, - `realmId` int(10) unsigned, - `characterName` varchar(12), - `characterGUID` bigint(20) unsigned, - `lastPlayedTime` int(10) unsigned, - PRIMARY KEY(`accountId`,`region`,`battlegroup`) + `realmId` int(10) unsigned DEFAULT NULL, + `characterName` varchar(12) DEFAULT NULL, + `characterGUID` bigint(20) unsigned DEFAULT NULL, + `lastPlayedTime` int(10) unsigned DEFAULT NULL, + PRIMARY KEY (`accountId`,`region`,`battlegroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -747,4 +747,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2015-11-08 1:52:10 +-- Dump completed on 2016-04-11 2:02:45 |