26 lines
508 B
SQL
26 lines
508 B
SQL
-- 0001_schema.sql
|
|
CREATE TABLE IF NOT EXISTS users (
|
|
id TEXT PRIMARY KEY,
|
|
username TEXT NOT NULL UNIQUE,
|
|
password_hash TEXT,
|
|
role TEXT,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS pools (
|
|
name TEXT PRIMARY KEY,
|
|
guid TEXT,
|
|
health TEXT,
|
|
capacity TEXT
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS jobs (
|
|
id TEXT PRIMARY KEY,
|
|
type TEXT,
|
|
status TEXT,
|
|
progress INTEGER DEFAULT 0,
|
|
owner TEXT,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at DATETIME
|
|
);
|