From 3e4326e34dcb4a9eb922c6d212fd05a58a11b124 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 6 Dec 2018 19:37:20 +0300 Subject: add ttrss_filters2.last_triggered (bump schema version) --- schema/ttrss_schema_mysql.sql | 3 ++- schema/ttrss_schema_pgsql.sql | 3 ++- schema/versions/mysql/135.sql | 8 ++++++++ schema/versions/pgsql/135.sql | 8 ++++++++ 4 files changed, 20 insertions(+), 2 deletions(-) create mode 100644 schema/versions/mysql/135.sql create mode 100644 schema/versions/pgsql/135.sql (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index a1b45efbb..81f941127 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -244,6 +244,7 @@ create table ttrss_filters2(id integer primary key auto_increment, inverse bool not null default false, title varchar(250) not null default '', order_id integer not null default 0, + last_triggered datetime default null, foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8; create table ttrss_filters2_rules(id integer primary key auto_increment, @@ -284,7 +285,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 (134); +insert into ttrss_version values (135); 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 dead2c762..3f0e012b3 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -239,6 +239,7 @@ create table ttrss_filters2(id serial not null primary key, inverse boolean not null default false, title varchar(250) not null default '', order_id integer not null default 0, + last_triggered timestamp default null, enabled boolean not null default true); create table ttrss_filters2_rules(id serial not null primary key, @@ -266,7 +267,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 (134); +insert into ttrss_version values (135); create table ttrss_enclosures (id serial not null primary key, content_url text not null, diff --git a/schema/versions/mysql/135.sql b/schema/versions/mysql/135.sql new file mode 100644 index 000000000..6d9d41ba6 --- /dev/null +++ b/schema/versions/mysql/135.sql @@ -0,0 +1,8 @@ +begin; + +alter table ttrss_filters2 add column last_triggered datetime; +alter table ttrss_filters2 alter column last_triggered set default null; + +update ttrss_version set schema_version = 135; + +commit; diff --git a/schema/versions/pgsql/135.sql b/schema/versions/pgsql/135.sql new file mode 100644 index 000000000..b1ec70505 --- /dev/null +++ b/schema/versions/pgsql/135.sql @@ -0,0 +1,8 @@ +begin; + +alter table ttrss_filters2 add column last_triggered timestamp; +alter table ttrss_filters2 alter column last_triggered set default null; + +update ttrss_version set schema_version = 135; + +commit; -- cgit v1.2.3