From 83cd33fcec05473bf2bd00836c7eaa7d9b584461 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 4 Oct 2011 13:11:07 +0400 Subject: implement sharing articles by unique url --- schema/ttrss_schema_mysql.sql | 3 ++- schema/ttrss_schema_pgsql.sql | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 66f5f4b29..a8f9939da 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -152,6 +152,7 @@ create index ttrss_entries_updated_idx on ttrss_entries(updated); create table ttrss_user_entries ( int_id integer not null primary key auto_increment, ref_id integer not null, + uuid varchar(200) not null, feed_id int, orig_feed_id int, owner_uid integer not null, @@ -254,7 +255,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; -insert into ttrss_version values (85); +insert into ttrss_version values (86); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, 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, -- cgit v1.2.3