· 6 years ago · Apr 02, 2019, 09:16 PM
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);
8
9CREATE TABLE post (
10 id INTEGER PRIMARY KEY AUTOINCREMENT,
11 author_id INTEGER NOT NULL,
12 created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
13 title TEXT NOT NULL,
14 body TEXT NOT NULL,
15 FOREIGN KEY (author_id) REFERENCES user (id)
16);