2024-07-19 09:30:27 +02:00
|
|
|
CREATE TABLE feeds (
|
|
|
|
id serial primary key, url varchar, active boolean,
|
|
|
|
last_update int, title varchar, type varchar, allow_img boolean,
|
|
|
|
expire int, lang varchar,
|
|
|
|
decode_title boolean
|
|
|
|
);
|
2017-10-02 15:26:48 +02:00
|
|
|
CREATE TABLE items (id serial primary key, title varchar, link varchar, content varchar, issued int, seen int, feed_id integer, old int);
|
|
|
|
CREATE TABLE read(item_id integer, username varchar, foreign key (item_id) references items(id));
|
|
|
|
CREATE INDEX on items(link);
|
2017-10-02 15:22:42 +02:00
|
|
|
CREATE INDEX read_item_id_idx on read(item_id);
|
2017-10-02 15:26:48 +02:00
|
|
|
CREATE TABLE later (item_id integer, username varchar, foreign key (item_id) references items(id));
|
|
|
|
CREATE INDEX on later(item_id);
|