jWFZqCxz

1DROP TABLE IF EXISTS user;
2DROP TABLE IF EXISTS post;
3
4CREATE TABLE user (
5  id INTEGER PRIMARY KEY AUTOINCREMENT,
6  username TEXT UNIQUE NOT NULL,
7  password TEXT NOT NULL
8);
9
10CREATE TABLE post (
11  id INTEGER PRIMARY KEY AUTOINCREMENT,
12  author_id INTEGER NOT NULL,
13  created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
14  title TEXT NOT NULL,
15  body TEXT NOT NULL,
16  FOREIGN KEY (author_id) REFERENCES user (id)
17);