diff options
| author | Andrew Dolgov <[email protected]> | 2021-03-06 11:17:15 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2021-03-06 11:17:15 +0300 |
| commit | e5469479c1ee6ddb671659dbb6362eac50f02979 (patch) | |
| tree | 42fac045821e3111fc07c8dd21f287a546edcd29 /sql | |
| parent | 42e057c8088070f9afd417d92cf6a0ebc9fdd01f (diff) | |
* don't try to update custom set feed favicons
* cleanup update_rss_feed() a bit, use ORM
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql/migrations/144.sql | 2 | ||||
| -rw-r--r-- | sql/mysql/schema.sql | 1 | ||||
| -rw-r--r-- | sql/pgsql/migrations/144.sql | 2 | ||||
| -rw-r--r-- | sql/pgsql/schema.sql | 1 |
4 files changed, 6 insertions, 0 deletions
diff --git a/sql/mysql/migrations/144.sql b/sql/mysql/migrations/144.sql new file mode 100644 index 000000000..c1932f12b --- /dev/null +++ b/sql/mysql/migrations/144.sql @@ -0,0 +1,2 @@ +alter table ttrss_feeds add column favicon_is_custom boolean; +alter table ttrss_feeds alter column favicon_is_custom set default null; diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql index 64d423f04..7ecaff32b 100644 --- a/sql/mysql/schema.sql +++ b/sql/mysql/schema.sql @@ -117,6 +117,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, last_error varchar(250) not null default '', last_modified varchar(250) not null default '', favicon_avg_color varchar(11) default null, + favicon_is_custom boolean default null, site_url varchar(250) not null default '', auth_login varchar(250) not null default '', auth_pass varchar(250) not null default '', diff --git a/sql/pgsql/migrations/144.sql b/sql/pgsql/migrations/144.sql new file mode 100644 index 000000000..c1932f12b --- /dev/null +++ b/sql/pgsql/migrations/144.sql @@ -0,0 +1,2 @@ +alter table ttrss_feeds add column favicon_is_custom boolean; +alter table ttrss_feeds alter column favicon_is_custom set default null; diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index 124b04aca..6130b633c 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -86,6 +86,7 @@ create table ttrss_feeds (id serial not null primary key, last_error text not null default '', last_modified text not null default '', favicon_avg_color varchar(11) default null, + favicon_is_custom boolean default null, site_url varchar(250) not null default '', auth_login varchar(250) not null default '', parent_feed integer default null references ttrss_feeds(id) on delete set null, |