diff options
Diffstat (limited to 'install/postgres.sql')
-rw-r--r-- | install/postgres.sql | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/install/postgres.sql b/install/postgres.sql index 9e0e8276..fe8f559c 100644 --- a/install/postgres.sql +++ b/install/postgres.sql | |||
@@ -27,4 +27,15 @@ CREATE TABLE users_config ( | |||
27 | user_id integer NOT NULL, | 27 | user_id integer NOT NULL, |
28 | name varchar(255) NOT NULL, | 28 | name varchar(255) NOT NULL, |
29 | value varchar(255) NOT NULL | 29 | value varchar(255) NOT NULL |
30 | ); \ No newline at end of file | 30 | ); |
31 | |||
32 | CREATE TABLE tags ( | ||
33 | id bigserial primary key, | ||
34 | value varchar(255) NOT NULL | ||
35 | ); | ||
36 | |||
37 | CREATE TABLE tags_entries ( | ||
38 | id bigserial primary key, | ||
39 | entry_id integer NOT NULL, | ||
40 | tag_id integer NOT NULL | ||
41 | ) \ No newline at end of file | ||