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