From 0c4811be712318a19176b68fb77f0cd3a5b6eb29 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 9 Aug 2007 14:38:59 +0100 Subject: [PATCH] schema: new filter, publish --- schema/ttrss_schema_mysql.sql | 3 +++ schema/ttrss_schema_pgsql.sql | 3 +++ schema/versions/mysql/19.sql | 3 +++ schema/versions/pgsql/19.sql | 3 +++ 4 files changed, 12 insertions(+) diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 8666a755..2fd4abb6 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -148,6 +148,9 @@ insert into ttrss_filter_actions (id,name,description) values (3, 'mark', insert into ttrss_filter_actions (id,name,description) values (4, 'tag', 'Assign tags'); +insert into ttrss_filter_actions (id,name,description) values (5, 'publish', + 'Publish article'); + 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 71af0237..7550cadc 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -142,6 +142,9 @@ insert into ttrss_filter_actions (id,name,description) values (3, 'mark', insert into ttrss_filter_actions (id,name,description) values (4, 'tag', 'Assign tags'); +insert into ttrss_filter_actions (id,name,description) values (5, 'publish', + 'Publish article'); + 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/19.sql b/schema/versions/mysql/19.sql index db4237da..ce727174 100644 --- a/schema/versions/mysql/19.sql +++ b/schema/versions/mysql/19.sql @@ -5,4 +5,7 @@ update ttrss_user_entries set published = false; alter table ttrss_user_entries change published published bool not null; alter table ttrss_user_entries alter column published set default false; +insert into ttrss_filter_actions (id,name,description) values (5, 'publish', + 'Publish article'); + update ttrss_version set schema_version = 19; diff --git a/schema/versions/pgsql/19.sql b/schema/versions/pgsql/19.sql index 79e62846..15c12ca3 100644 --- a/schema/versions/pgsql/19.sql +++ b/schema/versions/pgsql/19.sql @@ -5,4 +5,7 @@ update ttrss_user_entries set published = false; alter table ttrss_user_entries alter column published set not null; alter table ttrss_user_entries alter column published set default false; +insert into ttrss_filter_actions (id,name,description) values (5, 'publish', + 'Publish article'); + update ttrss_version set schema_version = 19; -- 2.39.5