ttrss_filters: add tag action

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 384bd1e8e06ef22d00263387861bce0d86cae690..b65162820c97ebfbc6655b0d6ba42530cdfb7f61 100644 (file)
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -146,6 +146,9 @@ insert into ttrss_filter_actions (id,name,description) values (2, 'catchup',
 insert into ttrss_filter_actions (id,name,description) values (3, 'mark', 
        'Set starred');
 
+insert into ttrss_filter_actions (id,name,description) values (4, 'tag', 
+       'Assign tag');
+
 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 b0cd36d8e773bdede69fd51e052ec5842f7fc783..5bec8723f4ec7847b639b58f217f5212adce6d18 100644 (file)
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -140,6 +140,9 @@ insert into ttrss_filter_actions (id,name,description) values (2, 'catchup',
 insert into ttrss_filter_actions (id,name,description) values (3, 'mark', 
        'Set starred');
 
+insert into ttrss_filter_actions (id,name,description) values (4, 'tag', 
+       'Assign tag');
+
 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/upgrade-1.2.4-1.2.6-mysql.sql b/schema/upgrade-1.2.4-1.2.6-mysql.sql
index 2b100d1756e202f97dfe628656fa2324ff721fc7..10b571d786ae868ecebc59c333f5dd415a83616f 100644 (file)
--- a/schema/upgrade-1.2.4-1.2.6-mysql.sql
+++ b/schema/upgrade-1.2.4-1.2.6-mysql.sql
@@ -5,5 +5,8 @@ update ttrss_filters set action_param = '';
 alter table ttrss_filters change action_param action_param varchar(200) not null;
 alter table ttrss_filters alter column action_param set default '';
 
+insert into ttrss_filter_actions (id,name,description) values (4, 'tag', 
+               'Assign tag');
+
 update ttrss_version set schema_version = 12;
 

diff --git a/schema/upgrade-1.2.4-1.2.6-pgsql.sql b/schema/upgrade-1.2.4-1.2.6-pgsql.sql
index 07ded63c08fdfffe291ad320bafec24a63b3d905..71b4634dd42191d37417ed377acdb70407f69ddc 100644 (file)
--- a/schema/upgrade-1.2.4-1.2.6-pgsql.sql
+++ b/schema/upgrade-1.2.4-1.2.6-pgsql.sql
@@ -7,6 +7,9 @@ update ttrss_filters set action_param = '';
 alter table ttrss_filters alter column action_param set not null;
 alter table ttrss_filters alter column action_param set default '';
 
+insert into ttrss_filter_actions (id,name,description) values (4, 'tag', 
+               'Assign tag');
+
 update ttrss_version set schema_version = 12;
 
 commit;