summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2008-04-30 07:35:30 +0100
committerAndrew Dolgov <[email protected]>2008-04-30 07:35:30 +0100
commitfdb7b03fc0e3fc1df83ee99257843e2dcfde223b (patch)
tree06b18905feb06049700bbdcef0de944e6d79f095 /schema
parentafb6038e47f07f3225d783f6ae10c13ef486f89e (diff)
add new filter action: modify score
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql3
-rw-r--r--schema/ttrss_schema_pgsql.sql3
-rw-r--r--schema/versions/mysql/36.sql3
-rw-r--r--schema/versions/pgsql/36.sql3
4 files changed, 12 insertions, 0 deletions
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;