From 04febb0429adb24da43ac33bc6d925d450e10b60 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 2 Mar 2006 13:15:28 +0100 Subject: [PATCH] shrink session id length in db --- schema/ttrss_schema_mysql.sql | 2 +- schema/ttrss_schema_pgsql.sql | 2 +- schema/upgrade-1.1.3-1.1.4-mysql.sql | 4 ++-- schema/upgrade-1.1.3-1.1.4-pgsql.sql | 2 +- 4 files changed, 5 insertions(+), 5 deletions(-) diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 671577cf..b9e1a08e 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -256,7 +256,7 @@ create table ttrss_scheduled_updates (id integer not null primary key auto_incre foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE, foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE) TYPE=InnoDB; -create table ttrss_sessions (id varchar(300) unique not null primary key, +create table ttrss_sessions (id varchar(250) unique not null primary key, data text, expire integer not null, ip_address varchar(15) not null default '', diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index e393353a..8db25bd6 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -231,7 +231,7 @@ 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 (id varchar(300) unique not null primary key, +create table ttrss_sessions (id varchar(250) unique not null primary key, data text, expire integer not null, ip_address varchar(15) not null default ''); diff --git a/schema/upgrade-1.1.3-1.1.4-mysql.sql b/schema/upgrade-1.1.3-1.1.4-mysql.sql index 37b3674d..329a297c 100644 --- a/schema/upgrade-1.1.3-1.1.4-mysql.sql +++ b/schema/upgrade-1.1.3-1.1.4-mysql.sql @@ -5,11 +5,11 @@ update ttrss_entries set author = ''; alter table ttrss_entries change author author varchar(250) not null; alter table ttrss_entries alter column author set default ''; -create table ttrss_sessions (id varchar(300) unique not null primary key, +create table ttrss_sessions (id varchar(250) not null primary key, data text, expire integer not null, ip_address varchar(15) not null default '', - index (id), + index (id), index (expire)) TYPE=InnoDB; update ttrss_version set schema_version = 6; 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 0191d6ed..4e81bb45 100644 --- a/schema/upgrade-1.1.3-1.1.4-pgsql.sql +++ b/schema/upgrade-1.1.3-1.1.4-pgsql.sql @@ -7,7 +7,7 @@ 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 (id varchar(300) unique not null primary key, +create table ttrss_sessions (id varchar(250) unique not null primary key, data text, expire integer not null, ip_address varchar(15) not null default ''); -- 2.39.5