rastrillo / idear Public

Download this file

1	CREATE TABLE IF NOT EXISTS users (
2	id INTEGER PRIMARY KEY AUTOINCREMENT,
3	email TEXT,
4	password_hash TEXT,
5	created_at DATETIME
6	);
7
8	CREATE UNIQUE INDEX IF NOT EXISTS idx_users_email ON users (email);
9
10	CREATE TABLE IF NOT EXISTS posts (
11	id INTEGER PRIMARY KEY AUTOINCREMENT,
12	author_id INTEGER,
13	author TEXT,
14	body TEXT,
15	created_at DATETIME
16	);
17
18	CREATE INDEX IF NOT EXISTS idx_posts_author_id ON posts (author_id);
19