X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=schema%2Fttrss_schema_pgsql.sql;h=c75e210f16f043dfe7d3cc33365207a3d3091bbb;hb=203610630a5c2d077cbfb1d69e89c1e60d8b074e;hp=b08644581723b11c04c56284269a6e823c8c27db;hpb=3dd9183cd603df99ae8d2bf5cb536b24bc030e20;p=tt-rss.git diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index b0864458..c75e210f 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -25,6 +25,9 @@ create table ttrss_themes(id serial not null primary key, theme_path varchar(200) not null); insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat'); +insert into ttrss_themes (theme_name, theme_path) values ('Graycube', 'graycube'); +insert into ttrss_themes (theme_name, theme_path) values ('Default (Compact)', 'compact'); +insert into ttrss_themes (theme_name, theme_path) values ('Three-pane', '3pane'); create table ttrss_users (id serial not null primary key, login varchar(120) not null unique, @@ -61,18 +64,17 @@ create table ttrss_feeds (id serial not null primary key, auth_pass varchar(250) not null default '', hidden boolean not null default false, include_in_digest boolean not null default true, - rtl_content boolean not null default false); + rtl_content boolean not null default false, + cache_images boolean not null default false, + auth_pass_encrypted boolean not null default false); create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid); -insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Footnotes', 'http://gnomedesktop.org/node/feed'); -insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Latest Linux Kernel Versions','http://kernel.org/kdist/rss.xml'); -insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'RPGDot Newsfeed', - 'http://www.rpgdot.com/team/rss/rss0.xml'); -insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Digg.com News', - 'http://digg.com/rss/index.xml'); -insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Technocrat.net', - 'http://syndication.technocrat.net/rss'); +insert into ttrss_feeds (owner_uid, title, feed_url) values + (1, 'Tiny Tiny RSS: New Releases', 'http://tt-rss.spb.ru/releases.rss'); + +insert into ttrss_feeds (owner_uid, title, feed_url) values + (1, 'Tiny Tiny RSS: Forum', 'http://tt-rss.spb.ru/forum/rss.php'); create table ttrss_entries (id serial not null primary key, title text not null, @@ -89,7 +91,7 @@ create table ttrss_entries (id serial not null primary key, create index ttrss_entries_guid_index on ttrss_entries(guid); -- create index ttrss_entries_title_index on ttrss_entries(title); --- create index ttrss_entries_date_entered_index on ttrss_entries(date_entered); +create index ttrss_entries_date_entered_index on ttrss_entries(date_entered); create table ttrss_user_entries ( int_id serial not null primary key, @@ -97,6 +99,7 @@ create table ttrss_user_entries ( feed_id int references ttrss_feeds(id) ON DELETE CASCADE not null, owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE, marked boolean not null default false, + published boolean not null default false, last_read timestamp, unread boolean not null default true); @@ -138,13 +141,21 @@ insert into ttrss_filter_actions (id,name,description) values (2, 'catchup', insert into ttrss_filter_actions (id,name,description) values (3, 'mark', 'Set starred'); +insert into ttrss_filter_actions (id,name,description) values (4, 'tag', + 'Assign tags'); + +insert into ttrss_filter_actions (id,name,description) values (5, 'publish', + 'Publish article'); + create table ttrss_filters (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, feed_id integer references ttrss_feeds(id) on delete cascade default null, filter_type integer not null references ttrss_filter_types(id), reg_exp varchar(250) not null, enabled boolean not null default true, - action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade); + inverse boolean not null default false, + action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade, + action_param varchar(250) not null default ''); create table ttrss_labels (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, @@ -168,7 +179,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (10); +insert into ttrss_version values (25); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null); @@ -198,15 +209,11 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_ 'Experimental support for virtual feeds based on user crafted SQL queries. This feature is highly experimental and at this point not user friendly. Use with caution.'); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DEFAULT_UPDATE_INTERVAL', 3, '30', 'Default interval between feed updates (in minutes)',1); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DISPLAY_HEADER', 1, 'true', 'Display header',2); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DISPLAY_FOOTER', 1, 'true', 'Display footer',2); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('USE_COMPACT_STYLESHEET', 1, 'false', 'Use compact stylesheet by default',2); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DEFAULT_ARTICLE_LIMIT', 3, '0', 'Default article limit',2, 'Default limit for articles to display, any custom number you like (0 - disables).'); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ALLOW_DUPLICATE_POSTS', 1, 'true', 'Allow duplicate posts',1, - 'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. - When disabled, it forces same posts from different feeds to appear only once.'); + 'This option is useful when you are reading several planet-type aggregators with partially colliding userbase. When disabled, it forces same posts from different feeds to appear only once.'); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('USER_STYLESHEET_URL', 2, '', 'User stylesheet URL',2, 'Link to user stylesheet to override default style, disabled if empty.'); @@ -223,8 +230,6 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) valu insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('COMBINED_DISPLAY_MODE', 1, 'false', 'Combined feed display',2, 'Display expanded list of feed articles, instead of separate displays for headlines and article content'); -insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',3); - insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2); insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('OPEN_LINKS_IN_NEW_WINDOW', 1, 'true', 'Open article links in new browser window',2); @@ -243,6 +248,37 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) valu insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1, 'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address'); +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('CONFIRM_FEED_CATCHUP', 1, 'true', 'Confirm marking feed as read',3); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('CDM_AUTO_CATCHUP', 1, 'false', 'Mark articles as read automatically',2, +'This option enables marking articles as read automatically in combined mode while you scroll article list.'); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_DEFAULT_VIEW_MODE', 2, 'adaptive', '', 1); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_DEFAULT_VIEW_LIMIT', 3, '30', '', 1); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_ACTIVE_TAB', 2, '', '', 1); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_INFOBOX_DISABLE_OVERLAY', 1, 'false', '', 1); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('STRIP_UNSAFE_TAGS', 1, 'true', 'Strip unsafe tags from articles', 3, +'Strip all but most common HTML tags when reading articles.'); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('BLACKLISTED_TAGS', 2, 'main, generic, misc', 'Blacklisted tags', 3, +'When auto-detecting tags in articles these tags will not be applied (comma-separated list).'); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_ENABLE_PAGINATION', 2, '', '', 1); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_PUBLISH_KEY', 2, '', '', 1); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('FRESH_ARTICLE_MAX_AGE', 3, '24', 'Maximum age of fresh articles (in hours)',2); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('DIGEST_CATCHUP', 1, 'false', 'Mark articles in e-mail digest as read',1); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('CDM_EXPANDED', 1, 'true', 'Automatically expand articles in combined mode',3); + create table ttrss_user_prefs ( owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE, pref_name varchar(250) not null references ttrss_prefs(pref_name) ON DELETE CASCADE,