diff options
author | Andrew Dolgov <[email protected]> | 2006-03-02 09:10:43 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-03-02 09:10:43 +0100 |
commit | 36bfab86c2682c460b197029bbae4daa6ff83ec4 (patch) | |
tree | d243e8863dd358be04b3695c0b092287657452b7 /schema/upgrade-1.1.3-1.1.4-pgsql.sql | |
parent | 36ae0574dd83d660570574ecc40d0d847dbde897 (diff) |
database backed sessions
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; |