diff options
author | Andrew Dolgov <[email protected]> | 2005-11-19 06:10:00 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-11-19 06:10:00 +0100 |
commit | 8bbb8466df5047ee13c0b8a6c796ac63b578f10f (patch) | |
tree | 9da4bb5f927cefeeafb4df49352fb4d4e7165006 /schema/ttrss_schema_pgsql.sql | |
parent | 93d40f50ba79703664d4d1cfef89210b114eee28 (diff) |
update schema to split ttrss_entries
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 18 |
1 files changed, 11 insertions, 7 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 4cc6bbb14..f9a4900d5 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -1,4 +1,5 @@ drop table ttrss_tags; +drop table ttrss_user_entries; drop table ttrss_entries; drop table ttrss_feeds; drop table ttrss_labels; @@ -36,19 +37,22 @@ insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Technocrat.net', 'http://syndication.technocrat.net/rss'); create table ttrss_entries (id serial not null primary key, - owner_uid integer not null references ttrss_users(id) on delete cascade, feed_id int references ttrss_feeds(id) ON DELETE CASCADE not null, - updated timestamp not null, title text not null, - guid text not null, + guid text not null unique, link text not null, + updated timestamp not null, content text not null, content_hash varchar(250) not null, - last_read timestamp, - marked boolean not null default false, - date_entered timestamp not null default NOW(), no_orig_date boolean not null default false, - comments varchar(250) not null default '', + date_entered timestamp not null default NOW(), + comments varchar(250) not null default ''); + +create table ttrss_user_entries ( + id integer unique not null references ttrss_entries(id) ON DELETE CASCADE, + owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE, + marked boolean not null default false, + last_read timestamp, unread boolean not null default true); drop table ttrss_filters; |