Structured tags '>' for each user

git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@3 b3834d28-1941-0410-a4f8-b48e95affb8f

1 files changed, 17 insertions, 1 deletions

diff --git a/tables.sql b/tables.sql
index 578fa06..fc38621 100644
--- a/tables.sql
+++ b/tables.sql
@@ -65,4 +65,20 @@ CREATE TABLE `sc_watched` (
   `watched` int(11) NOT NULL default '0',
   PRIMARY KEY  (`wId`),
   KEY `sc_watched_uId` (`uId`)
-);
\ No newline at end of file
+);
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `sc_tags_tags`
+-- 
+
+CREATE TABLE `sc_tags2tags` (
+  `ttId` int(11) NOT NULL auto_increment,
+  `tag1` varchar(32) NOT NULL default '',
+  `tag2` varchar(32) NOT NULL default '',
+  `relationType` varchar(32) NOT NULL default '',
+  `uId` int(11) NOT NULL default '0',
+  PRIMARY KEY (`ttId`),
+  UNIQUE KEY `sc_tags2tags_tag1_tag2_uId` (`tag1`,`tag2`,`relationType`,`uId`)
+);