From fdb7b03fc0e3fc1df83ee99257843e2dcfde223b Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 30 Apr 2008 07:35:30 +0100 Subject: add new filter action: modify score --- schema/ttrss_schema_mysql.sql | 3 +++ schema/ttrss_schema_pgsql.sql | 3 +++ schema/versions/mysql/36.sql | 3 +++ schema/versions/pgsql/36.sql | 3 +++ 4 files changed, 12 insertions(+) (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 819ee216a..293830910 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -164,6 +164,9 @@ insert into ttrss_filter_actions (id,name,description) values (4, 'tag', insert into ttrss_filter_actions (id,name,description) values (5, 'publish', 'Publish article'); +insert into ttrss_filter_actions (id,name,description) values (6, 'score', + 'Modify score'); + create table ttrss_filters (id integer not null primary key auto_increment, owner_uid integer not null, feed_id integer default null, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 0bfe4d8b1..7e991d69f 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -154,6 +154,9 @@ insert into ttrss_filter_actions (id,name,description) values (4, 'tag', insert into ttrss_filter_actions (id,name,description) values (5, 'publish', 'Publish article'); +insert into ttrss_filter_actions (id,name,description) values (6, 'score', + 'Modify score'); + create table ttrss_filters (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, feed_id integer references ttrss_feeds(id) on delete cascade default null, diff --git a/schema/versions/mysql/36.sql b/schema/versions/mysql/36.sql index 09bea8e17..d92da2880 100644 --- a/schema/versions/mysql/36.sql +++ b/schema/versions/mysql/36.sql @@ -3,4 +3,7 @@ update ttrss_user_entries set score = 0; alter table ttrss_user_entries change score score integer not null; alter table ttrss_user_entries alter column score set default 0; +insert into ttrss_filter_actions (id,name,description) values (6, 'score', + 'Modify score'); + update ttrss_version set schema_version = 36; diff --git a/schema/versions/pgsql/36.sql b/schema/versions/pgsql/36.sql index 6b61cadf7..1e4a460ee 100644 --- a/schema/versions/pgsql/36.sql +++ b/schema/versions/pgsql/36.sql @@ -3,4 +3,7 @@ update ttrss_user_entries set score = 0; alter table ttrss_user_entries alter column score set not null; alter table ttrss_user_entries alter column score set default 0; +insert into ttrss_filter_actions (id,name,description) values (6, 'score', + 'Modify score'); + update ttrss_version set schema_version = 36; -- cgit v1.2.3