From 245bc2f335f8c1589bed87f00ab9efa0b0c1eb00 Mon Sep 17 00:00:00 2001 From: Matthias Meusburger Date: Fri, 12 Jun 2009 14:27:06 +0200 Subject: [PATCH] MT1109 , follow-up to 888cde546e5c62d71f312755f4a1dbc8631626eb Missing MySQL statements to add search_history table Signed-off-by: Henri-Damien LAURENT --- installer/data/mysql/kohastructure.sql | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index be888ddd95..fcc15ca89b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1536,7 +1536,24 @@ CREATE TABLE saved_reports ( `date_run` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; - + + +-- +-- Table structure for table `search_history` +-- + +DROP TABLE IF EXISTS `search_history`; +CREATE TABLE IF NOT EXISTS `search_history` ( + `userid` int(11) NOT NULL, + `sessionid` varchar(32) NOT NULL, + `query_desc` varchar(255) NOT NULL, + `query_cgi` varchar(255) NOT NULL, + `total` int(11) NOT NULL, + `time` timestamp NOT NULL default CURRENT_TIMESTAMP, + KEY `userid` (`userid`), + KEY `sessionid` (`sessionid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results'; + -- -- Table structure for table `serial` -- 2.39.2