[github/wallabag/wallabag.git] / install / postgres.sql

CREATE TABLE config (
    id bigserial primary key,
    name varchar(255) NOT NULL,
    value varchar(255) NOT NULL
);

CREATE TABLE entries (
    id bigserial primary key,
    title varchar(255) NOT NULL,
    url varchar(255) NOT NULL,
    is_read boolean DEFAULT false,
    is_fav boolean DEFAULT false,
    content TEXT,
    user_id integer NOT NULL
);

CREATE TABLE users (
    id bigserial primary key,
    username varchar(255) NOT NULL,
    password varchar(255) NOT NULL,
    name varchar(255) NOT NULL,
    email varchar(255) NOT NULL
);

CREATE TABLE users_config (
    id bigserial primary key,
    user_id integer NOT NULL,
    name varchar(255) NOT NULL,
    value varchar(255) NOT NULL
);
Commit	Line	Data
f3e4f109 NF	1	CREATE TABLE config (
	2	id bigserial primary key,
	3	name varchar(255) NOT NULL,
	4	value varchar(255) NOT NULL
	5	);
	6
	7	CREATE TABLE 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 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 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	);