Changing sessions table to work with CGI::Session

[koha.git] / installer / kohastructure.sql

diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql
index f7a9a23..fd47e19 100644 (file)
--- a/installer/kohastructure.sql
+++ b/installer/kohastructure.sql
@@ -417,13 +417,13 @@ CREATE TABLE `biblioitems` (
   `issn` varchar(9) default NULL,
   `dewey` varchar(30) default '',
   `subclass` varchar(3) default NULL,
-  `publicationyear` smallint(6) default NULL,
+  `publicationyear` text,
   `publishercode` varchar(255) default NULL,
   `volumedate` date default NULL,
-  `volumeddesc` varchar(255) default NULL,
-  `seriestitle` text NOT NULL,
-  `seriesissn` text NOT NULL,
-  `seriesvolume` text NOT NULL,
+  `volumeddesc` text,
+  `collectiontitle` mediumtext NOT NULL,
+  `collectionissn` text NOT NULL,
+  `collectionvolume` mediumtext NOT NULL,
   `editionstatement` text NOT NULL,
   `editionreponsability` text NOT NULL,
   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
@@ -433,7 +433,7 @@ CREATE TABLE `biblioitems` (
   `size` varchar(255) default NULL,
   `place` varchar(255) default NULL,
   `lccn` varchar(25) default NULL,
-  `marc` blob,
+  `marc` longblob,
   `url` varchar(255) default NULL,
   `lcsort` varchar(25) default NULL,
   `ccode` varchar(4) default NULL,
@@ -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;
 
 --