diff options
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/versions/mysql/66.sql | 7 | ||||
-rw-r--r-- | schema/versions/pgsql/66.sql | 7 |
4 files changed, 18 insertions, 2 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index b9bb777ec..0f4acf900 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -183,6 +183,7 @@ insert into ttrss_filter_types (id,name,description) values (4, 'link', 'Link'); insert into ttrss_filter_types (id,name,description) values (5, 'date', 'Article Date'); +insert into ttrss_filter_types (id,name,description) values (6, 'author', 'Author'); create table ttrss_filter_actions (id integer not null primary key, name varchar(120) unique not null, @@ -239,7 +240,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) TYPE=InnoDB; -insert into ttrss_version values (65); +insert into ttrss_version values (66); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 55b07b6ea..7225f10f8 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -165,6 +165,7 @@ insert into ttrss_filter_types (id,name,description) values (4, 'link', 'Link'); insert into ttrss_filter_types (id,name,description) values (5, 'date', 'Article Date'); +insert into ttrss_filter_types (id,name,description) values (6, 'author', 'Author'); create table ttrss_filter_actions (id integer not null primary key, name varchar(120) unique not null, @@ -211,7 +212,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (65); +insert into ttrss_version values (66); create table ttrss_enclosures (id serial not null primary key, content_url text not null, diff --git a/schema/versions/mysql/66.sql b/schema/versions/mysql/66.sql new file mode 100644 index 000000000..f90c0a157 --- /dev/null +++ b/schema/versions/mysql/66.sql @@ -0,0 +1,7 @@ +begin; + +insert into ttrss_filter_types (id, name, description) values (6, 'author', 'Author'); + +update ttrss_version set schema_version = 66; + +commit; diff --git a/schema/versions/pgsql/66.sql b/schema/versions/pgsql/66.sql new file mode 100644 index 000000000..f90c0a157 --- /dev/null +++ b/schema/versions/pgsql/66.sql @@ -0,0 +1,7 @@ +begin; + +insert into ttrss_filter_types (id, name, description) values (6, 'author', 'Author'); + +update ttrss_version set schema_version = 66; + +commit; |