CREATE DATABASE IF NOT EXISTS `my_license_db`
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

USE `my_license_db`;

CREATE TABLE IF NOT EXISTS `licenses` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `license_code` VARCHAR(255) NOT NULL,
  `purchase_code` VARCHAR(255) NOT NULL,
  `domain` VARCHAR(255) DEFAULT NULL,
  `status` ENUM('active','inactive','expired') NOT NULL DEFAULT 'active',
  `expires_at` DATETIME DEFAULT NULL,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_license_code` (`license_code`),
  KEY `idx_purchase_code` (`purchase_code`),
  KEY `idx_domain` (`domain`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `licenses`
(`license_code`,`purchase_code`,`domain`,`status`,`expires_at`)
VALUES
('UNIMAID-VARIENT-2026-ABC123',
 'UNIMAID-PURCHASE-2026-001',
 'test.unimaid.info',
 'active',
 '2027-12-31 23:59:59');