text: CREATE TABLE `personal_db`.`example_coupon` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `amount` float DEFAULT NULL,
    `coupon_code` varchar(25) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `coupon_type` tinyint(1) DEFAULT NULL,
    `coupon_counter` int(11) DEFAULT NULL,
    `unique_user` longtext,
    `date_generated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `start_date` timestamp NULL DEFAULT NULL,
    `end_date` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_advertisers_coupon_coupon_code` (`coupon_code`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  CREATE TABLE `personal_db`.`example_redeemed_coupons` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `advertiser_id` int(11) NOT NULL,
    `coupon_id` int(11) NOT NULL,
    `date_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `coupon_id_advertiser_id` (`coupon_id`,`advertiser_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  CREATE TABLE `personal_db`.`example_coupon_attempts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `advertiser_id` int(11) NOT NULL,
    `first_failed_attempt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `counter` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;