CREATE TABLE licenses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    code VARCHAR(50) UNIQUE,
    client VARCHAR(100),
    expires DATE NULL,
    status ENUM('active','revoked') DEFAULT 'active',
    created DATETIME DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO licenses (code,client) VALUES ('SGR2025-TEST-123','Test client');