From 4d122aa3fca560f9b93bfb5a8abe6feee96d9e61 Mon Sep 17 00:00:00 2001 From: mensonge Date: Thu, 18 Dec 2008 11:03:40 +0000 Subject: 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 --- tables.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'tables.sql') diff --git a/tables.sql b/tables.sql index cf12636..9e5f5c4 100644 --- a/tables.sql +++ b/tables.sql @@ -121,6 +121,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` -- -- cgit v1.2.3