diff options
| author | M'Dic <joshua.lee.betts@gmail.com> | 2022-08-23 11:48:14 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-08-23 17:48:14 +0200 |
| commit | e0b7c7d0d3b1ea65860439add2c676b3e18f8f8b (patch) | |
| tree | 8e6d81d8ebe967c13ff0ba6f489ec94e9bcfd241 /data/sql/base/db_characters | |
| parent | 9b740ea58695f924f5861193e42b7a5f141f7ef5 (diff) | |
fix(sql): Squash fix for mariadb (#12830)
Update log_money.sql
Diffstat (limited to 'data/sql/base/db_characters')
| -rw-r--r-- | data/sql/base/db_characters/log_money.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/data/sql/base/db_characters/log_money.sql b/data/sql/base/db_characters/log_money.sql index abfff2e6e9..3f12715684 100644 --- a/data/sql/base/db_characters/log_money.sql +++ b/data/sql/base/db_characters/log_money.sql @@ -17,15 +17,15 @@ DROP TABLE IF EXISTS `log_money`; CREATE TABLE IF NOT EXISTS `log_money` ( `sender_acc` int unsigned NOT NULL, `sender_guid` int unsigned NOT NULL, - `sender_name` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, - `sender_ip` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `sender_name` text NOT NULL, + `sender_ip` text NOT NULL, `receiver_acc` int unsigned NOT NULL, - `receiver_name` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `receiver_name` text NOT NULL, `money` bigint unsigned NOT NULL, - `topic` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `topic` text NOT NULL, `date` datetime NOT NULL, `type` tinyint NOT NULL COMMENT '1=COD,2=AH,3=GB DEPOSIT,4=GB WITHDRAW,5=MAIL,6=TRADE' -) ENGINE=MyISAM DEFAULT CHARSET=latin1; +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; -- Dumpar data för tabell acore_characters.log_money: 0 rows DELETE FROM `log_money`; |