X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=install%2Fpostgres.sql;h=fe8f559ca29c31925a69b88d0d2cab5d815f117a;hb=92fc97eeb3cbda0f7cee9b670c30bbf6b23b9e39;hp=9e0e82763058cc483423b65a7a7b5c80fd5f5273;hpb=01c0e050ad8eca54f115dfa21db99e4f61ab7ca7;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