summaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
authormensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-02-13 17:34:18 +0000
committermensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>2008-02-13 17:34:18 +0000
commit484de2408fc42d8f5a25af53df159b2baa42c334 (patch)
treefc70f582126132ea3863f3734af686a762fc95d6 /tables.sql
parente8e5209d51b999f0672e53b368da9046b0a219b9 (diff)
downloadsemanticscuttle-484de2408fc42d8f5a25af53df159b2baa42c334.tar.gz
semanticscuttle-484de2408fc42d8f5a25af53df159b2baa42c334.tar.bz2
new feature: collaborative description for tags and bookmarks
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@36 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'tables.sql')
-rw-r--r--tables.sql19
1 files changed, 19 insertions, 0 deletions
diff --git a/tables.sql b/tables.sql
index 3dd7bab..5adb492 100644
--- a/tables.sql
+++ b/tables.sql
@@ -100,3 +100,22 @@ CREATE TABLE `sc_tagsstats` (
PRIMARY KEY (`tstId`),
UNIQUE KEY `sc_tagsstats_tag1_type_uId` (`tag1`,`relationType`,`uId`)
);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sc_commondescription`
+--
+
+CREATE TABLE `sc_commondescription` (
+ `cdId` int(11) NOT NULL auto_increment,
+ `uId` int(11) NOT NULL default '0',
+ `tag` varchar(32) NOT NULL default '',
+ `bHash` varchar(32) NOT NULL default '',
+ `cdTitle` varchar(255) NOT NULL default '',
+ `cdDescription` varchar(2000) default NULL,
+ `cdDatetime` datetime NOT NULL default '0000-00-00 00:00:00',
+ PRIMARY KEY (`cdId`),
+ UNIQUE KEY `sc_commondescription_tag_datetime` (`tag`,`cdDatetime`),
+ UNIQUE KEY `sc_commondescription_bookmark_datetime` (`bHash`,`cdDatetime`)
+);