1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
create table rsstg_updates (owner integer, update jsonb);
create unique index rsstg_updates__id on rsstg_updates(update->>'update_id');
create table rsstg_source (
source_id serial,
channel text not null,
channel_id integer not null,
url text not null,
last_scrape not null timestamptz default now(),
enabled boolean not null default true,
iv_hash text,
owner bigint not null);
create unique index rsstg_source__source_id on rsstg_source(source_id);
create unique index rsstg_source__channel_id__owner on rsstg_source(channel_id, owner);
create index rsstg_source__owner on rsstg_source(owner);
create table rsstg_post (
source_id integer not null,
posted timestamptz not null,
|
|
>
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
create table rsstg_updates (owner integer, update jsonb);
create unique index rsstg_updates__id on rsstg_updates(update->>'update_id');
create table rsstg_source (
source_id serial,
channel text not null,
channel_id integer not null,
url text not null,
last_scrape not null timestamptz default now(),
enabled boolean not null default true,
iv_hash text,
owner bigint not null,
url_re text);
create unique index rsstg_source__source_id on rsstg_source(source_id);
create unique index rsstg_source__channel_id__owner on rsstg_source(channel_id, owner);
create index rsstg_source__owner on rsstg_source(owner);
create table rsstg_post (
source_id integer not null,
posted timestamptz not null,
|