From 153cb6d30510f9804fe596ac6777bc2f35111ae2 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 17 Aug 2017 14:40:21 +0300 Subject: add support for http 304 not modified (no timestamp calculation bullshit like last time) --- schema/ttrss_schema_mysql.sql | 3 ++- schema/ttrss_schema_pgsql.sql | 3 ++- schema/versions/mysql/132.sql | 10 ++++++++++ schema/versions/pgsql/132.sql | 10 ++++++++++ 4 files changed, 24 insertions(+), 2 deletions(-) create mode 100644 schema/versions/mysql/132.sql create mode 100644 schema/versions/pgsql/132.sql (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 1ec409661..67a22e6d9 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -103,6 +103,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, purge_interval integer not null default 0, last_updated datetime default null, last_error varchar(250) not null default '', + last_modified varchar(250) not null default '', favicon_avg_color varchar(11) default null, site_url varchar(250) not null default '', auth_login varchar(250) not null default '', @@ -282,7 +283,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; -insert into ttrss_version values (131); +insert into ttrss_version values (132); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 6db73cd51..7870b4b37 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -73,6 +73,7 @@ create table ttrss_feeds (id serial not null primary key, purge_interval integer not null default 0, last_updated timestamp default null, last_error text not null default '', + last_modified text not null default '', favicon_avg_color varchar(11) default null, site_url varchar(250) not null default '', auth_login varchar(250) not null default '', @@ -264,7 +265,7 @@ create index ttrss_tags_post_int_id_idx on ttrss_tags(post_int_id); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (131); +insert into ttrss_version values (132); create table ttrss_enclosures (id serial not null primary key, content_url text not null, diff --git a/schema/versions/mysql/132.sql b/schema/versions/mysql/132.sql new file mode 100644 index 000000000..1f1fb5901 --- /dev/null +++ b/schema/versions/mysql/132.sql @@ -0,0 +1,10 @@ +begin; + +alter table ttrss_feeds add column last_modified varchar(250); +update ttrss_feeds set last_modified = ''; +alter table ttrss_feeds change last_modified last_modified varchar(250) not null; +alter table ttrss_feeds alter column last_modified set default ''; + +UPDATE ttrss_version SET schema_version = 132; + +commit; diff --git a/schema/versions/pgsql/132.sql b/schema/versions/pgsql/132.sql new file mode 100644 index 000000000..e6b4bd13f --- /dev/null +++ b/schema/versions/pgsql/132.sql @@ -0,0 +1,10 @@ +begin; + +alter table ttrss_feeds add column last_modified text; +update ttrss_feeds set last_modified = ''; +alter table ttrss_feeds alter column last_modified set not null; +alter table ttrss_feeds alter column last_modified set default ''; + +UPDATE ttrss_version SET schema_version = 132; + +commit; -- cgit v1.2.3