X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=install%2Fpostgres.sql;h=fe8f559ca29c31925a69b88d0d2cab5d815f117a;hb=0b57c6825aa0bf88d10a2c420875f6cf9afe17c5;hp=9e0e82763058cc483423b65a7a7b5c80fd5f5273;hpb=9a8b4ff4edf84d7df60de1b6fd1e493b59f88273;p=github%2Fwallabag%2Fwallabag.git

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 (
     user_id integer NOT NULL,
     name varchar(255) NOT NULL,
     value varchar(255) NOT NULL
-);
\ No newline at end of file
+);
+
+CREATE TABLE tags (
+  id bigserial primary key,
+  value varchar(255) NOT NULL
+);
+
+CREATE TABLE tags_entries (
+  id bigserial primary key,
+  entry_id integer NOT NULL,
+  tag_id integer NOT NULL
+)
\ No newline at end of file