diff options
| author | RealLushen <53633753+RealLushen@users.noreply.github.com> | 2020-12-12 23:13:07 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2020-12-23 00:04:43 +0100 |
| commit | 01af07c20bb1122408fd229b6149a35f4c1a8b13 (patch) | |
| tree | 476963a8cc572d0819bf2164d6766a805d1b9099 | |
| parent | c8228392ea19e35ed7f21b1cbf21043d2d8a5320 (diff) | |
DB/Auth: Corrected expansion NOT NULL DEFAULT to 8 (Shadowlands)
| -rw-r--r-- | sql/base/auth_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/auth/master/2020_12_22_00_auth.sql | 1 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 04d677aead2..7fdcad9e7dd 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -43,7 +43,7 @@ CREATE TABLE `account` ( `lock_country` varchar(2) NOT NULL DEFAULT '00', `last_login` timestamp NULL DEFAULT NULL, `online` tinyint(3) unsigned NOT NULL DEFAULT '0', - `expansion` tinyint(3) unsigned NOT NULL DEFAULT '7', + `expansion` tinyint(3) unsigned NOT NULL DEFAULT '8', `mutetime` bigint(20) NOT NULL DEFAULT '0', `mutereason` varchar(255) NOT NULL DEFAULT '', `muteby` varchar(50) NOT NULL DEFAULT '', @@ -2386,7 +2386,8 @@ INSERT INTO `updates` VALUES ('2020_10_20_00_auth.sql','1835C5EFD5816DEF914F27E867C8C8D5E08B3F68','ARCHIVED','2020-10-20 21:36:49',0), ('2020_12_06_00_auth.sql','FA254400D3D7D53E9C350EABFEABFF4EC3AD40DA','RELEASED','2020-12-06 20:25:10',0), ('2020_12_07_00_auth.sql','23626805735CB9BEEEBD756D4A39AFBCDA6E366C','RELEASED','2020-12-07 21:12:53',0), -('2020_12_15_00_auth.sql','37DA3C4830ABA30C49370A8647F5B6B3E1821E57','RELEASED','2020-12-15 19:33:15',0); +('2020_12_15_00_auth.sql','37DA3C4830ABA30C49370A8647F5B6B3E1821E57','RELEASED','2020-12-15 19:33:15',0), +('2020_12_22_00_auth.sql','1AED5AD7D93C30CF75E62EBEBCC64FFEDC58F00A','RELEASED','2020-12-22 22:00:39',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2020_12_22_00_auth.sql b/sql/updates/auth/master/2020_12_22_00_auth.sql new file mode 100644 index 00000000000..f60d40c31f0 --- /dev/null +++ b/sql/updates/auth/master/2020_12_22_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `account` CHANGE `expansion` `expansion` tinyint(3) unsigned NOT NULL DEFAULT '8'; |