[ ISSUE ] MySQL issues

[deadlinecode]

We have multiple problems with mysql databases I fixed most of them except one where i currently have problems with saving emojis

The error occures when saving the auth infos (since i have an account with a username containing a emoji | else it would probabbly happen later on in one of the chat, messages or group records) The error i get is ER_TRUNCATED_WRONG_VALUE_FOR_FIELD which is known for a wrong setting in relation to the collation or charset

I already tried multiple collations (like utf8mb4_unicode_ci) but didn't find anything that worked so this is still a WiP

Another general problem is that baileys key set function (for auth) tries to save to fast which results in multiple "default_auth" records (because it saves before the prev record was made)

[deadlinecode]

Fyi: Things that i already fixed (not commited or published yet)

• id fields don't auto increment
• multiple default_auth records (half fixed [upsert instead of save] > still problems with to quick saving of the auth set function)
• changed simple-enum types to integer since mysql doesn't support enums

[deadlinecode]

@izzatsenan98 @morganzysman @ahmedRSA

All issues are now resolved in https://github.com/deadlinecode/baileys-bottle/commit/21354229632fcee2894f72479d5620518ab5ac65 and will be published with some other changes soon...