diff options
| author | Shauren <shauren.trinity@gmail.com> | 2019-06-25 22:51:56 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2019-06-25 22:51:56 +0200 |
| commit | dbf59c0b67dcbcfa7d0fae7861eb6c565de527b5 (patch) | |
| tree | ac4190aa3fcf3e46acfb7cff1449f486da1bce08 | |
| parent | 9bb85965e10924554b087eb5ae94e6e4fa970ae9 (diff) | |
Core/Guilds: Extend motd size to 256 characters
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2019_06_25_00_characters.sql | 1 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 0989c18f49a..64578e24507 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2148,7 +2148,7 @@ CREATE TABLE `guild` ( `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0', `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0', `info` varchar(500) NOT NULL DEFAULT '', - `motd` varchar(128) NOT NULL DEFAULT '', + `motd` varchar(256) NOT NULL DEFAULT '', `createdate` int(10) unsigned NOT NULL DEFAULT '0', `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`) @@ -3568,7 +3568,8 @@ INSERT INTO `updates` VALUES ('2018_12_09_01_characters.sql','C80B936AAD94C58A0F33382CED08CFB4E0B6AC34','RELEASED','2018-10-10 22:05:28',0), ('2018_12_09_02_characters.sql','DBBA0C06985CE8AC4E6E7E94BD6B2673E9ADFAE2','RELEASED','2018-12-02 17:32:31',0), ('2019_06_08_00_characters.sql','6C5AF52AEF03BC019B96E7A07592C22660F9327B','RELEASED','2019-06-03 20:04:47',0), -('2019_06_08_01_characters.sql','55076AFAF4B55DB4E34029C269EE0C84315C31BA','RELEASED','2019-06-04 22:11:47',0); +('2019_06_08_01_characters.sql','55076AFAF4B55DB4E34029C269EE0C84315C31BA','RELEASED','2019-06-04 22:11:47',0), +('2019_06_25_00_characters.sql','B8CBF79DEE02B40B01424327D31E52C70335BEC6','RELEASED','2019-06-25 22:40:37',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2019_06_25_00_characters.sql b/sql/updates/characters/master/2019_06_25_00_characters.sql new file mode 100644 index 00000000000..e0386fb11a1 --- /dev/null +++ b/sql/updates/characters/master/2019_06_25_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `guild` MODIFY COLUMN `motd` varchar(256) NOT NULL DEFAULT '' AFTER `info`; |