From df630421c89956b8d8158d58c8c0bade7e0164b7 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Tue, 7 Aug 2007 12:56:51 -0500 Subject: [PATCH] Changing sessions table to work with CGI::Session No longer need all the extra columns, its stored in the a_session, and with CGI::Session you get back a session object which you can do things like my $userid = $session->param('userid'); Signed-off-by: kados --- installer/kohastructure.sql | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index e8d7374020..fd47e19063 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -1374,13 +1374,11 @@ CREATE TABLE `sessionqueries` ( -- Table structure for table `sessions` -- -DROP TABLE IF EXISTS `sessions`; -CREATE TABLE `sessions` ( - `sessionID` varchar(255) NOT NULL default '', - `userid` varchar(255) default NULL, - `ip` varchar(16) default NULL, - `lasttime` int(11) default NULL, - PRIMARY KEY (`sessionID`) +DROP TABLE IF EXISTS sessions; +CREATE TABLE sessions ( + `id` char(32) NOT NULL, + `a_session` text NOT NULL, + UNIQUE KEY id (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 2.39.5