summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2013-03-31 19:28:36 +0400
committerAndrew Dolgov <[email protected]>2013-03-31 19:28:36 +0400
commit5e736e4592d27107d69d9b7fbd19ae91b209956e (patch)
tree5ab7f9e709ce2d76ed5c53df60e92b023c58c2e5 /schema
parent133420aa8d9bb2e30775e50f37738d628fc8f42c (diff)
implement stop action
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql5
-rw-r--r--schema/ttrss_schema_pgsql.sql5
-rw-r--r--schema/versions/mysql/113.sql8
-rw-r--r--schema/versions/pgsql/113.sql8
4 files changed, 24 insertions, 2 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 40d5c67f5..9e1725f33 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -246,6 +246,9 @@ insert into ttrss_filter_actions (id,name,description) values (6, 'score',
insert into ttrss_filter_actions (id,name,description) values (7, 'label',
'Assign label');
+insert into ttrss_filter_actions (id,name,description) values (8, 'stop',
+ 'Stop / Do nothing');
+
create table ttrss_filters2(id integer primary key auto_increment,
owner_uid integer not null,
match_any_rule boolean not null default false,
@@ -293,7 +296,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 (112);
+insert into ttrss_version values (113);
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 711a35968..c977cf0bf 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -219,6 +219,9 @@ insert into ttrss_filter_actions (id,name,description) values (6, 'score',
insert into ttrss_filter_actions (id,name,description) values (7, 'label',
'Assign label');
+insert into ttrss_filter_actions (id,name,description) values (8, 'stop',
+ 'Stop / Do nothing');
+
create table ttrss_filters2(id serial not null primary key,
owner_uid integer not null references ttrss_users(id) on delete cascade,
match_any_rule boolean not null default false,
@@ -251,7 +254,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 (112);
+insert into ttrss_version values (113);
create table ttrss_enclosures (id serial not null primary key,
content_url text not null,
diff --git a/schema/versions/mysql/113.sql b/schema/versions/mysql/113.sql
new file mode 100644
index 000000000..3c0d00563
--- /dev/null
+++ b/schema/versions/mysql/113.sql
@@ -0,0 +1,8 @@
+begin;
+
+insert into ttrss_filter_actions (id,name,description) values (8, 'stop',
+ 'Stop / Do nothing');
+
+update ttrss_version set schema_version = 113;
+
+commit;
diff --git a/schema/versions/pgsql/113.sql b/schema/versions/pgsql/113.sql
new file mode 100644
index 000000000..3c0d00563
--- /dev/null
+++ b/schema/versions/pgsql/113.sql
@@ -0,0 +1,8 @@
+begin;
+
+insert into ttrss_filter_actions (id,name,description) values (8, 'stop',
+ 'Stop / Do nothing');
+
+update ttrss_version set schema_version = 113;
+
+commit;