CREATE TABLE IF NOT EXISTS licenses (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 license_key VARCHAR(80) NOT NULL UNIQUE,
 customer_name VARCHAR(190) NOT NULL,
 status ENUM('active','suspended','revoked') NOT NULL DEFAULT 'active',
 bound_domain VARCHAR(255) DEFAULT NULL,
 expires_at DATETIME DEFAULT NULL,
 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
 activated_at DATETIME DEFAULT NULL,
 last_check_at DATETIME DEFAULT NULL,
 INDEX idx_status(status), INDEX idx_domain(bound_domain)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;