diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2022-04-24 16:08:33 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-04-24 16:08:33 +0200 |
| commit | 62f6513c9a79e24fa295b9c16eed99d46eda2185 (patch) | |
| tree | 0c76e98c64c2bdaf68c7c62d169c7f9ea49b6c76 /data/sql/base/db_characters | |
| parent | 97a65f96282d6df6eb2fa6f9c64b857a0b875fc1 (diff) | |
fix(DB): Weird leftover (#11518)
Diffstat (limited to 'data/sql/base/db_characters')
| -rw-r--r-- | data/sql/base/db_characters/log_money.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/data/sql/base/db_characters/log_money.sql b/data/sql/base/db_characters/log_money.sql index 95dcbea224..bb1c29e583 100644 --- a/data/sql/base/db_characters/log_money.sql +++ b/data/sql/base/db_characters/log_money.sql @@ -17,12 +17,12 @@ 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` char(32) CHARACTER SET utf8mb4 NOT NULL, + `sender_ip` char(32) CHARACTER SET utf8mb4 NOT NULL, `receiver_acc` INT unsigned NOT NULL, - `receiver_name` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `receiver_name` char(32) CHARACTER SET utf8mb4 NOT NULL, `money` BIGINT unsigned NOT NULL, - `topic` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, + `topic` char(255) CHARACTER SET utf8mb4 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; |