delete older sql and run this sql in phpmyadmin
CREATE TABLE `reward_codes` (
`promo` varchar(26) NOT NULL DEFAULT '',
`nameid` int UNSIGNED NOT NULL DEFAULT '0',
`item_name` varchar(50) NOT NULL DEFAULT '',
`amount` smallint UNSIGNED NOT NULL DEFAULT '0',
`time_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`limit` int UNSIGNED NOT NULL DEFAULT '0',
`pool` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `reward_logs` (
`account_id` int UNSIGNED NOT NULL DEFAULT '0',
`last_ip` varchar(15) NOT NULL,
`code` varchar(26) NOT NULL,
`redeem_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`claim` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
Please let me know if this code doesn't work
