-- ============================================================
-- License Server Database Schema
-- Upload this to your tmitstore.com MySQL database
-- ============================================================

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

USE `boguraj1_ispstocklis`;

CREATE TABLE IF NOT EXISTS licenses (
    id          INT           AUTO_INCREMENT PRIMARY KEY,
    license_key VARCHAR(64)   NOT NULL UNIQUE,
    domain      VARCHAR(255)  NOT NULL,
    product     VARCHAR(50)   NOT NULL DEFAULT 'isp_stock_v1',
    status      ENUM('active','suspended','expired') NOT NULL DEFAULT 'active',
    expires_at  DATE          NULL COMMENT 'NULL = lifetime license',
    customer    VARCHAR(150)  NULL COMMENT 'Customer name or company',
    notes       TEXT          NULL,
    last_check  DATETIME      NULL COMMENT 'Last time this license was verified',
    created_at  TIMESTAMP     DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_key_domain (license_key, domain),
    INDEX idx_domain (domain)
) ENGINE=InnoDB;

-- ============================================================
-- Sample: insert a test license (domain: localhost)
-- Key: TEST1-TEST2-TEST3-TEST4
-- ============================================================
-- INSERT INTO licenses (license_key, domain, product, status, customer)
-- VALUES ('TEST1-TEST2-TEST3-TEST4', 'localhost', 'isp_stock_v1', 'active', 'Test Customer');