Update character set and collation for GitHub signature table

[guibranco]

Description

• Enhanced the github_signature table by changing the default character set to utf8mb4 and specifying the collation.
• This change improves compatibility with a wider range of characters.

---

Changes walkthrough 📝

	Relevant files
Configuration changes	004.create_github_signature_table.sql Update character set and collation for GitHub signature table Sql/004.create_github_signature_table.sql Changed the default character set to utf8mb4. Updated the table creation statement to include collation. +1/-3

[deepsource-io[bot]]

Here's the code health analysis summary for commits ff4abf6..04b5667. View details on DeepSource ↗.

Analysis Summary

Analyzer	Status	Summary	Link
Docker	✅ Success		View Check ↗
PHP	✅ Success		View Check ↗
Secrets	✅ Success		View Check ↗
SQL	✅ Success		View Check ↗

---

💡 If you’re a repository administrator, you can configure the quality gates from the settings.

[penify-dev[bot]]

PR Review 🔍

⏱️ Estimated effort to review [1-5]	1, because the changes are straightforward and involve a simple character set and collation update.
🧪 Relevant tests	No
⚡ Possible issues	No
🔒 Security concerns	No

[penify-dev[bot]]

PR Code Suggestions ✨

Category	Suggestion	Score
Maintainability	Remove the redundant ALTER TABLE statement for character set conversion ___ **Consider removing the ALTER TABLE statement as it is redundant with the new character set and collation specified in the table creation.** [Sql/004.create_github_signature_table.sql [27]](https://github.com/guibranco/gstraccini-bot/pull/489/files#diff-59b01a1f84648b6209b0bc21a2a61ca1becf1c0f9fb57146961b6b0c857510daR27-R27) ```diff -ALTER TABLE `github_signature` CONVERT TO CHARACTER SET utf8; +-- This line can be removed as the character set is already defined in the table creation. ``` Suggestion importance[1-10]: 8 Why: The suggestion correctly identifies that the `ALTER TABLE` statement is unnecessary due to the new character set and collation being defined in the table creation, improving maintainability.	8

[github-actions[bot]]

Infisical secrets check: :white_check_mark: No secrets leaked!

Scan results:

2:44PM INF scanning for exposed secrets...
2:44PM INF 426 commits scanned.
2:44PM INF scan completed in 117ms
2:44PM INF no leaks found

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud