summaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-01-22 16:16:06 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-01-22 16:16:06 +0000
commit2aed4f1f9f71e668c9c60449a12847ea171d1812 (patch)
tree08f65bdc393c667985a97356cbed49b324fc2fa1 /tables.sql
parentb3b802434f4f1a17467baacd34c551885b7c9f37 (diff)
downloadsemanticscuttle-2aed4f1f9f71e668c9c60449a12847ea171d1812.tar.gz
semanticscuttle-2aed4f1f9f71e668c9c60449a12847ea171d1812.tar.bz2
add stats to tags relation and use them to display tags
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@21 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'tables.sql')
-rw-r--r--tables.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/tables.sql b/tables.sql
index 1968507..3dd7bab 100644
--- a/tables.sql
+++ b/tables.sql
@@ -82,3 +82,21 @@ CREATE TABLE `sc_tags2tags` (
PRIMARY KEY (`ttId`),
UNIQUE KEY `sc_tags2tags_tag1_tag2_uId` (`tag1`,`tag2`,`relationType`,`uId`)
);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sc_tagsstats`
+--
+
+CREATE TABLE `sc_tagsstats` (
+ `tstId` int(11) NOT NULL auto_increment,
+ `tag1` varchar(32) NOT NULL default '',
+ `relationType` varchar(32) NOT NULL default '',
+ `uId` int(11) NOT NULL default '0',
+ `nb` int(11) NOT NULL default '0',
+ `depth` int(11) NOT NULL default '0',
+ `nbupdate` int(11) NOT NULL default '0',
+ PRIMARY KEY (`tstId`),
+ UNIQUE KEY `sc_tagsstats_tag1_type_uId` (`tag1`,`relationType`,`uId`)
+);