View | Details | Raw Unified | Return to bug 10807
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1904-1910 CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history Link Here
1904
  `sessionid` varchar(32) NOT NULL, -- a system generated session id
1904
  `sessionid` varchar(32) NOT NULL, -- a system generated session id
1905
  `query_desc` varchar(255) NOT NULL, -- the search that was performed
1905
  `query_desc` varchar(255) NOT NULL, -- the search that was performed
1906
  `query_cgi` text NOT NULL, -- the string to append to the search url to rerun the search
1906
  `query_cgi` text NOT NULL, -- the string to append to the search url to rerun the search
1907
  `type` varchar(255) NOT NULL DEFAULT 'biblio', -- search type, must be 'biblio' or 'authority'
1907
  `type` varchar(16) NOT NULL DEFAULT 'biblio', -- search type, must be 'biblio' or 'authority'
1908
  `total` int(11) NOT NULL, -- the total of results found
1908
  `total` int(11) NOT NULL, -- the total of results found
1909
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1909
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1910
  KEY `userid` (`userid`),
1910
  KEY `userid` (`userid`),
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 8206-8212 if ( CheckVersion($DBversion) ) { Link Here
8206
$DBversion = "3.15.00.XXX";
8206
$DBversion = "3.15.00.XXX";
8207
if ( CheckVersion($DBversion) ) {
8207
if ( CheckVersion($DBversion) ) {
8208
    $dbh->do(q|
8208
    $dbh->do(q|
8209
        ALTER TABLE search_history ADD COLUMN type VARCHAR(255) NOT NULL DEFAULT 'biblio' AFTER query_cgi
8209
        ALTER TABLE search_history ADD COLUMN type VARCHAR(16) NOT NULL DEFAULT 'biblio' AFTER query_cgi
8210
    |);
8210
    |);
8211
    print "Upgrade to $DBversion done (Bug 10807 - Add db field search_history.type)\n";
8211
    print "Upgrade to $DBversion done (Bug 10807 - Add db field search_history.type)\n";
8212
    SetVersion($DBversion);
8212
    SetVersion($DBversion);
8213
- 

Return to bug 10807