Unable to install AwoCoupon on Joomla 5.4.0

Error spotted :
CREATE TABLE IF NOT EXISTS #__awocoupon (
    ...
    `coupon_code` varchar(255) BINARY NOT NULL default '',
    ...
    KEY coupon_code (coupon_code)
);

The problem arises because in MySQL with utf8mb4 encoding (which is the default encoding in Joomla 5.4.0), each character can take up to 4 bytes. Therefore, a VARCHAR(255) can potentially require 1020 bytes (255 * 4 = 1020), which exceeds the 1000-byte limit for an index.

So to resolve this issue, probably

Modify the length of the coupon_code column to reduce its size (for example, VARCHAR(191), which will result in a maximum index size of 764 bytes with utf8mb4)

Or create a partial index on the column ?

Applied the same fix for all of those too :

1. #__awocoupon_history.user_email
2. #__awocoupon_tag.tag
3. #__awocoupon_config.name
4. #__awocoupon_giftcert_code.code et estore
5. #__awocoupon_voucher_customer_code.code

And I get an error when I want to activate my licence :
error2
An error occurred while activating the license

Activation is now successful, thank you. (I'm on a test website, in the same domain as the production one)