summaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-12-18 11:03:40 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-12-18 11:03:40 +0000
commit4d122aa3fca560f9b93bfb5a8abe6feee96d9e61 (patch)
tree6a4e115cb6a6acfec68fe18cc330089725bdfae7 /tables.sql
parentd8a5adc285fbd9237d7c3140f6d6a11b6eceaaee (diff)
downloadsemanticscuttle-4d122aa3fca560f9b93bfb5a8abe6feee96d9e61.tar.gz
semanticscuttle-4d122aa3fca560f9b93bfb5a8abe6feee96d9e61.tar.bz2
Major refactoring: add a cache table to accelerate the search of linked tags by inference (children and synonyms)
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@204 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 cf12636..9e5f5c4 100644
--- a/tables.sql
+++ b/tables.sql
@@ -122,6 +122,22 @@ CREATE TABLE `sc_tagsstats` (
-- --------------------------------------------------------
--
+-- Table structure for table `sc_tagscache`
+--
+
+CREATE TABLE `sc_tagscache` (
+ `tcId` int(11) NOT NULL auto_increment,
+ `tag1` varchar(100) NOT NULL default '',
+ `tag2` varchar(100) NOT NULL default '',
+ `relationType` varchar(32) NOT NULL default '',
+ `uId` int(11) NOT NULL default '0',
+ PRIMARY KEY (`tcId`),
+ UNIQUE KEY `sc_tagscache_tag1_tag2_type_uId` (`tag1`,`tag2`,`relationType`,`uId`)
+);
+
+-- --------------------------------------------------------
+
+--
-- Table structure for table `sc_commondescription`
--