summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2006-12-08 07:34:59 +0100
committerAndrew Dolgov <[email protected]>2006-12-08 07:34:59 +0100
commit7cb9311ba13df7fec30fe498578089398785e48d (patch)
tree6c8b810e0f8640a8f20108752f5568fe910b242b /schema
parent9ebaec057c6c9e1644eb7673ddb3f709b9874bb8 (diff)
ttrss_filters: add tag action
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql3
-rw-r--r--schema/ttrss_schema_pgsql.sql3
-rw-r--r--schema/upgrade-1.2.4-1.2.6-mysql.sql3
-rw-r--r--schema/upgrade-1.2.4-1.2.6-pgsql.sql3
4 files changed, 12 insertions, 0 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 384bd1e8e..b65162820 100644
--- 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 b0cd36d8e..5bec8723f 100644
--- 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 2b100d175..10b571d78 100644
--- 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 07ded63c0..71b4634dd 100644
--- 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;