38471-vm/db/migrations/20260218_create_license_table.sql
2026-02-18 10:48:24 +00:00

14 lines
491 B
SQL

-- Migration: Create system_license table
-- Created at: 2026-02-18
CREATE TABLE IF NOT EXISTS system_license (
id INT AUTO_INCREMENT PRIMARY KEY,
license_key VARCHAR(255) NOT NULL,
activation_token TEXT DEFAULT NULL,
fingerprint VARCHAR(255) DEFAULT NULL,
status ENUM('pending', 'active', 'expired', 'suspended') DEFAULT 'pending',
activated_at DATETIME DEFAULT NULL,
last_checked_at DATETIME DEFAULT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);