From 484de2408fc42d8f5a25af53df159b2baa42c334 Mon Sep 17 00:00:00 2001
From: mensonge
Date: Wed, 13 Feb 2008 17:34:18 +0000
Subject: 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
---
 tables.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'tables.sql')

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`)
+);
-- 
cgit v1.2.3-54-g00ecf

