CREATE DATABASE IF NOT EXISTS api CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE api;

-- you may remove the api_keys functionality if you dont want it
CREATE TABLE IF NOT EXISTS api_keys (
  id INT AUTO_INCREMENT PRIMARY KEY,
  key_hash CHAR(64) NOT NULL,
  revoked TINYINT(1) DEFAULT 0
);

-- api token: testkey (sha256 hash)
INSERT INTO api_keys (key_hash, revoked) VALUES (
  '98483c6eb40b6c31a448c22a66ded3b5e5e8d5119cac8327b655c8b5c4836489', 0
)
ON DUPLICATE KEY UPDATE revoked=VALUES(revoked);

-- proof-of-work challenges for key provision
CREATE TABLE IF NOT EXISTS pow_challenges (
  challenge CHAR(16) PRIMARY KEY,
  difficulty INT NOT NULL,
  expires_at BIGINT NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);