summaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-03-14 10:32:00 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-03-14 10:32:00 +0000
commit219888d4899fa1704452ed7169b718f6766aaa07 (patch)
tree5584dabf3b28af36af08ebbb55878fdf06103a29 /tables.sql
parent6ab15b1c291b35bcb2564ae5a20e10ef19a208e9 (diff)
downloadsemanticscuttle-219888d4899fa1704452ed7169b718f6766aaa07.tar.gz
semanticscuttle-219888d4899fa1704452ed7169b718f6766aaa07.tar.bz2
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
Diffstat (limited to 'tables.sql')
-rw-r--r--tables.sql16
1 files changed, 16 insertions, 0 deletions
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`)
+);