-CREATE TABLE config (
+CREATE TABLE IF NOT EXISTS config (
id bigserial primary key,
name varchar(255) NOT NULL,
value varchar(255) NOT NULL
);
-CREATE TABLE entries (
+CREATE TABLE IF NOT EXISTS entries (
id bigserial primary key,
title varchar(255) NOT NULL,
url varchar(255) NOT NULL,
user_id integer NOT NULL
);
-CREATE TABLE users (
+CREATE TABLE IF NOT EXISTS users (
id bigserial primary key,
username varchar(255) NOT NULL,
password varchar(255) NOT NULL,
email varchar(255) NOT NULL
);
-CREATE TABLE users_config (
+CREATE TABLE IF NOT EXISTS users_config (
id bigserial primary key,
user_id integer NOT NULL,
name varchar(255) NOT NULL,
value varchar(255) NOT NULL
-);
\ No newline at end of file
+);
+
+CREATE TABLE IF NOT EXISTS tags (
+ id bigserial primary key,
+ value varchar(255) NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS tags_entries (
+ id bigserial primary key,
+ entry_id integer NOT NULL,
+ tag_id integer NOT NULL
+)