From b80df612d5453a44fff473ad9fe8be86a17c6516 Mon Sep 17 00:00:00 2001 From: cweiske 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