From 75fa1e31266b55ea502876dae9b14474bd58bf9a Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 13 Dec 2008 12:57:01 +0100 Subject: [PATCH] schema: add new filter type (refs #225) --- schema/ttrss_schema_mysql.sql | 4 +++- schema/ttrss_schema_pgsql.sql | 4 +++- schema/versions/mysql/46.sql | 4 ++++ schema/versions/pgsql/46.sql | 5 +++++ 4 files changed, 15 insertions(+), 2 deletions(-) create mode 100644 schema/versions/mysql/46.sql create mode 100644 schema/versions/pgsql/46.sql diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index e4fdfcca..6934440a 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -154,6 +154,8 @@ insert into ttrss_filter_types (id,name,description) values (3, 'both', 'Title or Content'); insert into ttrss_filter_types (id,name,description) values (4, 'link', 'Link'); +insert into ttrss_filter_types (id,name,description) values (5, 'date', + 'Article Date'); create table ttrss_filter_actions (id integer not null primary key, name varchar(120) unique not null, @@ -219,7 +221,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) TYPE=InnoDB; -insert into ttrss_version values (45); +insert into ttrss_version values (46); create table ttrss_enclosures (id serial not null primary key, content_url text not null, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 5b40fab3..2efcaf7f 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -141,6 +141,8 @@ insert into ttrss_filter_types (id,name,description) values (3, 'both', 'Title or Content'); insert into ttrss_filter_types (id,name,description) values (4, 'link', 'Link'); +insert into ttrss_filter_types (id,name,description) values (5, 'date', + 'Article Date'); create table ttrss_filter_actions (id integer not null primary key, name varchar(120) unique not null, @@ -196,7 +198,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (45); +insert into ttrss_version values (46); create table ttrss_enclosures (id serial not null primary key, content_url text not null, diff --git a/schema/versions/mysql/46.sql b/schema/versions/mysql/46.sql new file mode 100644 index 00000000..8bf25629 --- /dev/null +++ b/schema/versions/mysql/46.sql @@ -0,0 +1,4 @@ +insert into ttrss_filter_types (id,name,description) values (5, 'date', + 'Article Date'); + +update ttrss_version set schema_version = 46; diff --git a/schema/versions/pgsql/46.sql b/schema/versions/pgsql/46.sql new file mode 100644 index 00000000..007824f7 --- /dev/null +++ b/schema/versions/pgsql/46.sql @@ -0,0 +1,5 @@ + +insert into ttrss_filter_types (id,name,description) values (5, 'date', + 'Article Date'); + +update ttrss_version set schema_version = 46; -- 2.39.5