add 3pane theme

[tt-rss.git] / schema / ttrss_schema_pgsql.sql

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 94b172f3dc1a627e347840cbcc1c66d53de2bb61..c75e210f16f043dfe7d3cc33365207a3d3091bbb 100644 (file)
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -27,6 +27,7 @@ create table ttrss_themes(id serial not null primary key,
 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,
@@ -64,6 +65,7 @@ create table ttrss_feeds (id serial not null primary key,
        hidden boolean not null default false,
        include_in_digest boolean not null default true,
        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);
@@ -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);
 
@@ -141,6 +144,9 @@ insert into ttrss_filter_actions (id,name,description) values (3, 'mark',
 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,
@@ -149,7 +155,7 @@ create table ttrss_filters (id serial not null primary key,
        enabled boolean not null default true,
        inverse boolean not null default false,
        action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade,
-       action_param varchar(200) not null default '');
+       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,
@@ -173,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 (17);
+insert into ttrss_version values (25);
 
 create table ttrss_prefs_types (id integer not null primary key, 
        type_name varchar(100) not null);
@@ -207,8 +213,7 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_
        '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.');
@@ -262,6 +267,18 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_
 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,