yeeZ4qfH

1ROP TABLE IF EXISTS tags_books;
2DROP TABLE IF EXISTS tags_articles;
3DROP TABLE IF EXISTS tags;
4DROP TABLE IF EXISTS books;
5DROP TABLE IF EXISTS articles;
6
7CREATE TABLE tags (
8  id INTEGER PRIMARY KEY, 
9  name TEXT NOT NULL,
10  created_at DATETIME,
11  updated_at DATETIME
12);
13
14CREATE TABLE books (
15  id INTEGER PRIMARY KEY, 
16  title TEXT NOT NULL,
17  created_at DATETIME,
18  updated_at DATETIME
19);
20
21CREATE TABLE articles (
22  id INTEGER PRIMARY KEY, 
23  title TEXT NOT NULL,
24  created_at DATETIME,
25  updated_at DATETIME
26);
27
28
29CREATE TABLE tags_books (
30  idtag INTEGER,
31  idbook INTEGER,
32  created_at DATETIME,
33  updated_at DATETIME,
34  PRIMARY KEY (idtag, idbook)
35);