diff options
author | Andrew Dolgov <[email protected]> | 2006-12-08 07:34:59 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-12-08 07:34:59 +0100 |
commit | 7cb9311ba13df7fec30fe498578089398785e48d (patch) | |
tree | 6c8b810e0f8640a8f20108752f5568fe910b242b /schema | |
parent | 9ebaec057c6c9e1644eb7673ddb3f709b9874bb8 (diff) |
ttrss_filters: add tag action
Diffstat (limited to 'schema')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 3 | ||||
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 3 | ||||
-rw-r--r-- | schema/upgrade-1.2.4-1.2.6-mysql.sql | 3 | ||||
-rw-r--r-- | schema/upgrade-1.2.4-1.2.6-pgsql.sql | 3 |
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; |