From b80df612d5453a44fff473ad9fe8be86a17c6516 Mon Sep 17 00:00:00 2001
From: cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>
Date: Tue, 3 Nov 2009 09:14:30 +0000
Subject: 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
---
 data/tables.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'data/tables.sql')

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`),
-- 
cgit v1.2.3

