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`), |