-- Golden Signals PHP/MySQL. Run in phpMyAdmin with the target database selected.
CREATE TABLE IF NOT EXISTS gs_settings (name VARCHAR(100) NOT NULL PRIMARY KEY, data_json LONGTEXT NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_invites (code VARCHAR(32) NOT NULL PRIMARY KEY, note VARCHAR(255) NOT NULL DEFAULT '', used TINYINT NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, used_at DATETIME NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_analyses (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, data_json LONGTEXT NOT NULL, created_at DATETIME NOT NULL, INDEX (created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_status (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, data_json LONGTEXT NOT NULL, created_at DATETIME NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_pending (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, data_json LONGTEXT NOT NULL, created_at DATETIME NOT NULL, INDEX (created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_m1_bulletins (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, data_json LONGTEXT NOT NULL, created_at DATETIME NOT NULL, INDEX (created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_m1_stats (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, data_json LONGTEXT NOT NULL, created_at DATETIME NOT NULL, INDEX (created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_cache (cache_key VARCHAR(180) NOT NULL PRIMARY KEY, value_json LONGTEXT NOT NULL, expires_at DATETIME NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS gs_cron_locks (job_name VARCHAR(80) NOT NULL PRIMARY KEY, expires_at DATETIME NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;