Lines 1746-1752
CREATE TABLE IF NOT EXISTS `search_history` (
Link Here
|
1746 |
`userid` int(11) NOT NULL, |
1746 |
`userid` int(11) NOT NULL, |
1747 |
`sessionid` varchar(32) NOT NULL, |
1747 |
`sessionid` varchar(32) NOT NULL, |
1748 |
`query_desc` varchar(255) NOT NULL, |
1748 |
`query_desc` varchar(255) NOT NULL, |
1749 |
`query_cgi` varchar(255) NOT NULL, |
1749 |
`query_cgi` text NOT NULL, |
1750 |
`total` int(11) NOT NULL, |
1750 |
`total` int(11) NOT NULL, |
1751 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, |
1751 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, |
1752 |
KEY `userid` (`userid`), |
1752 |
KEY `userid` (`userid`), |