· 8 years ago · Jun 20, 2018, 05:42 PM
1DROP TABLE IF EXISTS posts;
2
3CREATE TABLE posts (
4 id INTEGER PRIMARY_KEY,
5 text TEXT NOT NULL,
6 created_at DATETIME NOT NULL
7);
8
9DROP TABLE IF EXISTS posts_tags;
10
11CREATE TABLE posts_tags (
12 post_id INTEGER NOT NULL,
13 tag_id INTEGER NOT NULL
14);
15
16DROP TABLE IF EXISTS tags;
17
18CREATE TABLE tags (
19 id PRIMARY_KEY,
20 name STRING NOT NULL
21);