-- install.sql - create csa_licenses table
CREATE DATABASE IF NOT EXISTS csa_license_db;
USE csa_license_db;
CREATE TABLE IF NOT EXISTS csa_licenses (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  license_key VARCHAR(64) NOT NULL UNIQUE,
  bound_domain VARCHAR(255) DEFAULT NULL,
  active TINYINT(1) DEFAULT 1,
  created DATETIME NOT NULL,
  expires DATETIME DEFAULT NULL,
  meta TEXT DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
