summaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-01-09 15:51:35 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-01-09 15:51:35 +0000
commitef9143907f1ea6600a6c66065f0e18ac42f3535b (patch)
tree37382b6d5b8df60670cd5efecbcfd388d68d06e8 /tables.sql
parentb1c3fbad478b43080e7506243d3fb77465a599d4 (diff)
downloadsemanticscuttle-ef9143907f1ea6600a6c66065f0e18ac42f3535b.tar.gz
semanticscuttle-ef9143907f1ea6600a6c66065f0e18ac42f3535b.tar.bz2
Structured tags '>' for each user
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@3 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'tables.sql')
-rw-r--r--tables.sql18
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`)
+);