bin/postgres.sql

   1 CREATE TABLE IF NOT EXISTS config (
   2     id bigserial primary key,
   3     name varchar(255) NOT NULL,
   4     value varchar(255) NOT NULL
   5 );
   6
   7 CREATE TABLE IF NOT EXISTS entries (
   8     id bigserial primary key,
   9     title varchar(255) NOT NULL,
  10     url varchar(255) NOT NULL,
  11     is_read boolean DEFAULT false,
  12     is_fav boolean DEFAULT false,
  13     content TEXT,
  14     user_id integer NOT NULL
  15 );
  16
  17 CREATE TABLE IF NOT EXISTS users (
  18     id bigserial primary key,
  19     username varchar(255) NOT NULL,
  20     password varchar(255) NOT NULL,
  21     name varchar(255) NOT NULL,
  22     email varchar(255) NOT NULL
  23 );
  24
  25 CREATE TABLE IF NOT EXISTS users_config (
  26     id bigserial primary key,
  27     user_id integer NOT NULL,
  28     name varchar(255) NOT NULL,
  29     value varchar(255) NOT NULL
  30 );
  31
  32 CREATE TABLE IF NOT EXISTS tags (
  33   id bigserial primary key,
  34   value varchar(255) NOT NULL
  35 );
  36
  37 CREATE TABLE IF NOT EXISTS tags_entries (
  38   id bigserial primary key,
  39   entry_id integer NOT NULL,
  40   tag_id integer NOT NULL
  41 )