diff options
Diffstat (limited to 'schema/upgrade-1.1.3-1.1.4-pgsql.sql')
| -rw-r--r-- | schema/upgrade-1.1.3-1.1.4-pgsql.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/schema/upgrade-1.1.3-1.1.4-pgsql.sql b/schema/upgrade-1.1.3-1.1.4-pgsql.sql index 92025c4af..6a0f46b55 100644 --- a/schema/upgrade-1.1.3-1.1.4-pgsql.sql +++ b/schema/upgrade-1.1.3-1.1.4-pgsql.sql @@ -7,6 +7,14 @@ update ttrss_entries set author = ''; alter table ttrss_entries alter column author set not null; alter table ttrss_entries alter column author set default ''; +create table ttrss_sessions (int_id serial not null primary key, + id varchar(300) unique not null, + data text, + expire integer not null); + +create index ttrss_sessions_id_index on ttrss_sessions(id); +create index ttrss_sessions_expire_index on ttrss_sessions(expire); + update ttrss_version set schema_version = 6; commit; |