add ttrss_feeds.last_unconditional (schema bump)

diff --git a/include/functions.php b/include/functions.php
index ed6f78eefe14ef451b94ce3d6cfd844d4592a448..6c7a6de5f378f0b434bd1bffa607911bc3bc22a2 100644 (file)
--- a/include/functions.php
+++ b/include/functions.php
@@ -1,6 +1,6 @@
 <?php
        define('EXPECTED_CONFIG_VERSION', 26);
-       define('SCHEMA_VERSION', 132);
+       define('SCHEMA_VERSION', 133);
 
        define('LABEL_BASE_INDEX', -1024);
        define('PLUGIN_FEED_BASE_INDEX', -128);

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 67a22e6d92232c859c0aec0480ead0f267bdf3e9..ce299f4e0156b373bab314d17585d6d75c8c9c3d 100644 (file)
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -102,6 +102,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key,
        update_interval integer not null default 0,
        purge_interval integer not null default 0,
        last_updated datetime default null,
+       last_unconditional datetime default null,
        last_error varchar(250) not null default '',
        last_modified varchar(250) not null default '',
        favicon_avg_color varchar(11) default null,
@@ -283,7 +284,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 (132);
+insert into ttrss_version values (133);
 
 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 7870b4b37e90532b5b3d29d4b891f15390ef0887..9f397535357c17e88c0b5b670abf23de28aa84a0 100644 (file)
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -72,6 +72,7 @@ create table ttrss_feeds (id serial not null primary key,
        update_interval integer not null default 0,
        purge_interval integer not null default 0,
        last_updated timestamp default null,
+       last_unconditional timestamp default null,
        last_error text not null default '',
        last_modified text not null default '',
        favicon_avg_color varchar(11) default null,
@@ -265,7 +266,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 (132);
+insert into ttrss_version values (133);
 
 create table ttrss_enclosures (id serial not null primary key,
        content_url text not null,

diff --git a/schema/versions/mysql/133.sql b/schema/versions/mysql/133.sql
new file mode 100644 (file)
index 0000000..e1693a9
--- /dev/null
+++ b/schema/versions/mysql/133.sql
@@ -0,0 +1,7 @@
+begin;
+
+alter table ttrss_feeds add column last_unconditional datetime null;
+
+UPDATE ttrss_version SET schema_version = 133;
+
+commit;

diff --git a/schema/versions/pgsql/133.sql b/schema/versions/pgsql/133.sql
new file mode 100644 (file)
index 0000000..7bf2f9f
--- /dev/null
+++ b/schema/versions/pgsql/133.sql
@@ -0,0 +1,7 @@
+begin;
+
+alter table ttrss_feeds add column last_unconditional timestamp null;
+
+UPDATE ttrss_version SET schema_version = 133;
+
+commit;