From 219888d4899fa1704452ed7169b718f6766aaa07 Mon Sep 17 00:00:00 2001 From: mensonge Date: Fri, 14 Mar 2008 10:32:00 +0000 Subject: New Feature: save searches (and display a searchhistory box) git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@80 b3834d28-1941-0410-a4f8-b48e95affb8f --- tables.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'tables.sql') diff --git a/tables.sql b/tables.sql index 64a7ec9..92c42c7 100644 --- a/tables.sql +++ b/tables.sql @@ -121,3 +121,19 @@ CREATE TABLE `sc_commondescription` ( UNIQUE KEY `sc_commondescription_tag_datetime` (`tag`,`cdDatetime`), UNIQUE KEY `sc_commondescription_bookmark_datetime` (`bHash`,`cdDatetime`) ); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `sc_searchhistory` +-- + +CREATE TABLE `sc_searchhistory` ( + `shId` int(11) NOT NULL auto_increment, + `shTerms` varchar(255) NOT NULL default '', + `shRange` varchar(32) NOT NULL default '', + `shDatetime` datetime NOT NULL default '0000-00-00 00:00:00', + `shNbResults` int(6) NOT NULL default '0', + `uId` int(11) NOT NULL default '0', + PRIMARY KEY (`shId`) +); -- cgit v1.2.3