add another example label in default schema

2 files changed, 6 insertions, 0 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 408402c70..7abccc305 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -73,6 +73,9 @@ create table ttrss_labels (id integer primary key auto_increment,
 insert into ttrss_labels (sql_exp,description) values ('unread = true', 
 	'Unread articles');
 
+insert into ttrss_labels (sql_exp,description) values (
+	'last_read is null and unread = false', 'Updated articles');
+
 create table ttrss_tags (id integer primary key auto_increment, 
 	tag_name varchar(250) not null,
 	post_id integer not null,
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 085bcc675..bb971d2dd 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -70,6 +70,9 @@ create table ttrss_labels (id serial primary key,
 insert into ttrss_labels (sql_exp,description) values ('unread = true', 
 	'Unread articles');
 
+insert into ttrss_labels (sql_exp,description) values (
+	'last_read is null and unread = false', 'Updated articles');
+
 create table ttrss_tags (id serial primary key, 
 	tag_name varchar(250) not null,
 	post_id integer references ttrss_entries(id) ON DELETE CASCADE not null);