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