CREATE TABLE IF NOT EXISTS artists (slug TEXT PRIMARY KEY, name TEXT NOT NULL, bio TEXT NOT NULL, image TEXT);
CREATE TABLE IF NOT EXISTS users (email TEXT PRIMARY KEY, password TEXT NOT NULL, slug TEXT UNIQUE REFERENCES artists(slug));
CREATE TABLE IF NOT EXISTS sessions (token TEXT PRIMARY KEY, email TEXT NOT NULL, expires INTEGER NOT NULL);
CREATE TABLE IF NOT EXISTS attempts (key TEXT PRIMARY KEY, count INTEGER NOT NULL, expires INTEGER NOT NULL);
CREATE TABLE IF NOT EXISTS items (id TEXT PRIMARY KEY, slug TEXT NOT NULL REFERENCES artists(slug), kind TEXT NOT NULL, title TEXT NOT NULL, description TEXT, price INTEGER, url TEXT, media TEXT NOT NULL, created INTEGER NOT NULL);
INSERT OR IGNORE INTO artists VALUES ('yaboy-ale', 'Yaboy Ale', 'An emerging artist on the Don’t Miss Global roster.', NULL);

