summaryrefslogtreecommitdiff
path: root/data/tables.sql
diff options
context:
space:
mode:
authorcweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-11-03 09:14:30 +0000
committercweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-11-03 09:14:30 +0000
commitb80df612d5453a44fff473ad9fe8be86a17c6516 (patch)
tree1120300ce9c72f168c1a32cd037b71378a939e36 /data/tables.sql
parent02051fcf67d47ac44d9dee457ff4a2098ffae963 (diff)
downloadsemanticscuttle-b80df612d5453a44fff473ad9fe8be86a17c6516.tar.gz
semanticscuttle-b80df612d5453a44fff473ad9fe8be86a17c6516.tar.bz2
add new "votes" field in bookmarks database with the total sum of votes
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@509 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'data/tables.sql')
-rw-r--r--data/tables.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/data/tables.sql b/data/tables.sql
index 9f94d3b..b028d17 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -17,6 +17,7 @@ CREATE TABLE `sc_bookmarks` (
`bDescription` text default NULL,
`bPrivateNote` text default NULL,
`bHash` varchar(32) NOT NULL default '',
+ `bVotes` int(11) NOT NULL,
`bVoting` int(11) NOT NULL,
PRIMARY KEY (`bId`),
KEY `sc_bookmarks_usd` (`uId`,`bStatus`,`bDatetime`),