diff options
Diffstat (limited to 'schema')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 1 | ||||
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 1 | ||||
-rw-r--r-- | schema/upgrade-1.2.2-1.2.3-mysql.sql | 5 | ||||
-rw-r--r-- | schema/upgrade-1.2.2-1.2.3-pgsql.sql | 5 |
4 files changed, 12 insertions, 0 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 9cd1dfba1..961abe811 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -65,6 +65,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, private bool not null default false, rtl_content bool not null default false, hidden bool not null default false, + include_in_digest boolean not null default true, index(owner_uid), foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE, index(cat_id), diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 61bb13f48..b08644581 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -60,6 +60,7 @@ create table ttrss_feeds (id serial not null primary key, private boolean not null default false, 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); create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid); diff --git a/schema/upgrade-1.2.2-1.2.3-mysql.sql b/schema/upgrade-1.2.2-1.2.3-mysql.sql index 114fa0832..5839e8faa 100644 --- a/schema/upgrade-1.2.2-1.2.3-mysql.sql +++ b/schema/upgrade-1.2.2-1.2.3-mysql.sql @@ -1,5 +1,10 @@ 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'); +alter table ttrss_feeds add column include_in_digest bool; +update ttrss_feeds set include_in_digest = true; +alter table ttrss_feeds change include_in_digest include_in_digest bool not null; +alter table ttrss_feeds alter column include_in_digest set default true; + update ttrss_version set schema_version = 10; diff --git a/schema/upgrade-1.2.2-1.2.3-pgsql.sql b/schema/upgrade-1.2.2-1.2.3-pgsql.sql index 114fa0832..9f292ec3d 100644 --- a/schema/upgrade-1.2.2-1.2.3-pgsql.sql +++ b/schema/upgrade-1.2.2-1.2.3-pgsql.sql @@ -1,5 +1,10 @@ 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'); +alter table ttrss_feeds add column include_in_digest boolean; +update ttrss_feeds set include_in_digest = true; +alter table ttrss_feeds alter column include_in_digest set not null; +alter table ttrss_feeds alter column include_in_digest set default true; + update ttrss_version set schema_version = 10; |