-- PostgreSQL dump
-- Server: leviathan-prod
-- Database: leviathan_prod

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  username VARCHAR(255),
  email VARCHAR(255),
  password_hash VARCHAR(255),
  role VARCHAR(50)
);

INSERT INTO users VALUES (1, 'admin', 'admin@ackermann.media', '$2b$12$fnord23EwigeBlumenkraftKallistiHashedPw', 'superadmin');
INSERT INTO users VALUES (2, 'hagbard', 'hagbard@leviathan.discordia', '$2b$12$GoldenAppleDiscordianSociety23Hash', 'admin');
INSERT INTO users VALUES (3, 'eris', 'eris@chaos.olympus', '$2b$12$KallistiForThePrettiestOneHash23', 'goddess');

CREATE TABLE api_keys (
  id SERIAL PRIMARY KEY,
  user_id INTEGER,
  key VARCHAR(255)
);

INSERT INTO api_keys VALUES (1, 1, 'sk_live_fnord23EwigeBlumenkraft5517');
INSERT INTO api_keys VALUES (2, 2, 'sk_live_HagbardCelineGoldenSubmarine');
