aboutsummaryrefslogtreecommitdiffhomepage
path: root/install/postgres.sql
diff options
context:
space:
mode:
Diffstat (limited to 'install/postgres.sql')
-rw-r--r--install/postgres.sql13
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
32CREATE TABLE tags (
33 id bigserial primary key,
34 value varchar(255) NOT NULL
35);
36
37CREATE 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