Hot Fix: Message Content Limit

[1AhmedYasser]

• Removed idx_message_content index
• Changed message content column type to text instead of varchar to remove limit
• Created idx_message_content_hash on content to better index large content

[1AhmedYasser]

Note: this solves a problem that arrises on prod, when the content is too large the db won't add it because content was of type varchar(3000), so after consideration i converted it to text to remove the limit on it, and added a hash index on it instead of the normal index to better cope with large content for the time being, until future plans are set to better deal with this situation

[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