diff options
Diffstat (limited to 'install/postgres.sql')
-rw-r--r-- | install/postgres.sql | 41 |
1 files changed, 0 insertions, 41 deletions
diff --git a/install/postgres.sql b/install/postgres.sql deleted file mode 100644 index 1d73dfcb..00000000 --- a/install/postgres.sql +++ /dev/null | |||
@@ -1,41 +0,0 @@ | |||
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 | ) | ||