diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-01-01 19:36:46 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-01 19:36:46 +0100 |
| commit | f4c6e87267a9bdd20fc9ce32ad6afdc438a01353 (patch) | |
| tree | 1671b8052801709ac0bf1b82eddc270ce75cde56 /sql/base/auth_database.sql | |
| parent | 8a779268b601db28005a8348f3c21255718d4526 (diff) | |
DB: Sync structure of a shared auth table between branches
Diffstat (limited to 'sql/base/auth_database.sql')
| -rw-r--r-- | sql/base/auth_database.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 0b7a5e69f96..0c3e4cd9993 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -341,7 +341,7 @@ DROP TABLE IF EXISTS `logs_ip_actions`; CREATE TABLE `logs_ip_actions` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier', `account_id` int unsigned NOT NULL COMMENT 'Account ID', - `character_guid` int unsigned NOT NULL COMMENT 'Character Guid', + `character_guid` bigint unsigned NOT NULL COMMENT 'Character Guid', `realm_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Realm ID', `type` tinyint unsigned NOT NULL, `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', @@ -1996,7 +1996,8 @@ INSERT INTO `updates` VALUES ('2021_09_28_00_auth.sql','07B3ECF2EBAF1F1C3692059CB3A05B1088A93E18','ARCHIVED','2021-09-28 20:48:10',0), ('2021_10_15_00_auth.sql','4FFD29A3ED1DB13874E755A84BFD7ABA2DF5C2DB','ARCHIVED','2021-10-15 08:43:41',0), ('2021_11_15_00_auth.sql','82D88B06301130C7149E21A991364F62279E219B','ARCHIVED','2021-11-15 16:22:37',0), -('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0); +('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0), +('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','RELEASED','2022-01-01 19:35:19',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |