Lines 1881-1887
CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history
Link Here
|
1881 |
`sessionid` varchar(32) NOT NULL, -- a system generated session id |
1881 |
`sessionid` varchar(32) NOT NULL, -- a system generated session id |
1882 |
`query_desc` varchar(255) NOT NULL, -- the search that was performed |
1882 |
`query_desc` varchar(255) NOT NULL, -- the search that was performed |
1883 |
`query_cgi` text NOT NULL, -- the string to append to the search url to rerun the search |
1883 |
`query_cgi` text NOT NULL, -- the string to append to the search url to rerun the search |
1884 |
`type` varchar(255) NOT NULL DEFAULT 'biblio', -- search type, must be 'biblio' or 'authority' |
1884 |
`type` varchar(16) NOT NULL DEFAULT 'biblio', -- search type, must be 'biblio' or 'authority' |
1885 |
`total` int(11) NOT NULL, -- the total of results found |
1885 |
`total` int(11) NOT NULL, -- the total of results found |
1886 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1886 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1887 |
KEY `userid` (`userid`), |
1887 |
KEY `userid` (`userid`), |