diff options
Diffstat (limited to 'schema')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 3 | ||||
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index e34082380..adf158c6f 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -152,6 +152,7 @@ create table ttrss_user_entries ( marked bool not null default 0, published bool not null default 0, tag_cache text not null, + label_cache text not null, last_read datetime, score int not null default 0, note longtext, @@ -245,7 +246,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) TYPE=InnoDB DEFAULT CHARSET=UTF8; -insert into ttrss_version values (73); +insert into ttrss_version values (74); 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 fc1265005..152af5dd3 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -138,6 +138,7 @@ create table ttrss_user_entries ( marked boolean not null default false, published boolean not null default false, tag_cache text not null, + label_cache text not null, last_read timestamp, score int not null default 0, note text, @@ -217,7 +218,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 (73); +insert into ttrss_version values (74); create table ttrss_enclosures (id serial not null primary key, content_url text not null, |