diff options
author | Andrew Dolgov <[email protected]> | 2011-10-04 13:11:07 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2011-10-04 13:18:41 +0400 |
commit | 83cd33fcec05473bf2bd00836c7eaa7d9b584461 (patch) | |
tree | 024ff7b024164a27e93e362763883e66cb40fa4b /schema/ttrss_schema_pgsql.sql | |
parent | 359fc686ddfc13dc1f9ee8127fd14a13a0ede4e8 (diff) |
implement sharing articles by unique url
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 687426534..b8ede02dd 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -137,6 +137,7 @@ create index ttrss_entries_updated_idx on ttrss_entries(updated); create table ttrss_user_entries ( int_id serial not null primary key, ref_id integer not null references ttrss_entries(id) ON DELETE CASCADE, + uuid varchar(200) not null, feed_id int references ttrss_feeds(id) ON DELETE CASCADE, orig_feed_id integer references ttrss_archived_feeds(id) ON DELETE SET NULL, owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE, @@ -225,7 +226,7 @@ create index ttrss_tags_post_int_id_idx on ttrss_tags(post_int_id); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (85); +insert into ttrss_version values (86); create table ttrss_enclosures (id serial not null primary key, content_url text not null, |