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