diff options
| author | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-11-03 09:14:30 +0000 |
|---|---|---|
| committer | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-11-03 09:14:30 +0000 |
| commit | b80df612d5453a44fff473ad9fe8be86a17c6516 (patch) | |
| tree | 1120300ce9c72f168c1a32cd037b71378a939e36 /data/tables.sql | |
| parent | 02051fcf67d47ac44d9dee457ff4a2098ffae963 (diff) | |
| download | semanticscuttle-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.sql | 1 |
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`), |