-- Gift-code archive. Expired rows are history only; they are not broadcast.
-- Code comparison is case-sensitive.

CREATE TABLE IF NOT EXISTS gift_codes (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    code VARCHAR(64) NOT NULL,
    expires_on DATE NULL,
    created_by BIGINT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY uq_gift_codes_code (code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

INSERT IGNORE INTO gift_codes (code, expires_on, created_by) VALUES
    ('K2R5M8PQ', '2026-05-09', NULL),
    ('MOMPOWER26', '2026-05-16', NULL),
    ('H4V7C2ND', '2026-05-23', NULL),
    ('B5K8M4RT', '2026-05-30', NULL),
    ('EVONYPCGEM', '2026-05-31', NULL),
    ('61HAPPY26', '2026-06-08', NULL),
    ('FRID99WQ', '2026-06-12', NULL),
    ('BN82MX51', '2026-06-19', NULL),
    ('VJ77MT31', '2026-06-26', NULL),
    ('PL42KH68', '2026-07-03', NULL),
    ('BX90QR25', '2026-07-10', NULL),
    ('MS62WK54', '2026-07-16', NULL),
    ('EMSTOREJULY', '2026-07-18', NULL),
    ('HT47BF35', '2026-07-23', NULL),
    ('EMFREEDOOM', '2026-07-31', NULL),
    ('ES74DC91', '2026-08-06', NULL),
    ('UX35BK82', '2026-08-14', NULL),
    ('KM51NX74', '2026-08-29', NULL),
    ('WF83TV95', '2026-09-05', NULL),
    ('QX49EM26', '2026-09-11', NULL),
    ('LP61MN87', '2026-09-18', NULL),
    ('SEPSUNNY04', '2026-09-23', NULL),
    ('SEPFRESH06', '2026-09-30', NULL);
