update schema, new option: DATABASE_BACKED_SESSIONS

[tt-rss.git] / schema / ttrss_schema_pgsql.sql

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index ec98bbb22f463b2b62cb93365cc8b468af198503..c6bc452179c9dcd00e7e6dc5ebf75ec50e89e426 100644 (file)
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -231,12 +231,10 @@ create table ttrss_scheduled_updates (id serial not null primary key,
        feed_id integer default null references ttrss_feeds(id) ON DELETE CASCADE,
        entered timestamp not null default NOW());
 
-create table ttrss_sessions (int_id serial not null primary key,
-               id varchar(300) unique not null,
-               data text,
-               expire integer not null);
+create table ttrss_sessions (id varchar(300) unique not null primary key,
+       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);
 
 commit;