]>
Commit | Line | Data |
---|---|---|
1 | CREATE TABLE IF NOT EXISTS config ( | |
2 | id bigserial primary key, | |
3 | name varchar(255) NOT NULL, | |
4 | value varchar(255) NOT NULL | |
5 | ); | |
6 | ||
7 | CREATE TABLE IF NOT EXISTS entries ( | |
8 | id bigserial primary key, | |
9 | title varchar(255) NOT NULL, | |
10 | url varchar(255) NOT NULL, | |
11 | is_read boolean DEFAULT false, | |
12 | is_fav boolean DEFAULT false, | |
13 | content TEXT, | |
14 | user_id integer NOT NULL | |
15 | ); | |
16 | ||
17 | CREATE TABLE IF NOT EXISTS users ( | |
18 | id bigserial primary key, | |
19 | username varchar(255) NOT NULL, | |
20 | password varchar(255) NOT NULL, | |
21 | name varchar(255) NOT NULL, | |
22 | email varchar(255) NOT NULL | |
23 | ); | |
24 | ||
25 | CREATE TABLE IF NOT EXISTS users_config ( | |
26 | id bigserial primary key, | |
27 | user_id integer NOT NULL, | |
28 | name varchar(255) NOT NULL, | |
29 | value varchar(255) NOT NULL | |
30 | ); | |
31 | ||
32 | CREATE TABLE IF NOT EXISTS tags ( | |
33 | id bigserial primary key, | |
34 | value varchar(255) NOT NULL | |
35 | ); | |
36 | ||
37 | CREATE TABLE IF NOT EXISTS tags_entries ( | |
38 | id bigserial primary key, | |
39 | entry_id integer NOT NULL, | |
40 | tag_id integer NOT NULL | |
41 | ) |