summaryrefslogtreecommitdiff
path: root/data/tables.sql
diff options
context:
space:
mode:
authorcweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-10-23 16:53:18 +0000
committercweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-10-23 16:53:18 +0000
commit3350658545a4645eb7eeea6323636b79310a18cc (patch)
tree9ab4e57c5b340768820d45a1103eb2790debb734 /data/tables.sql
parent97e702d088251e1c1d0dc92b5f4a231d96741087 (diff)
downloadsemanticscuttle-3350658545a4645eb7eeea6323636b79310a18cc.tar.gz
semanticscuttle-3350658545a4645eb7eeea6323636b79310a18cc.tar.bz2
voting table
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@392 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'data/tables.sql')
-rw-r--r--data/tables.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/data/tables.sql b/data/tables.sql
index ed4d6ba..eed7269 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -170,3 +170,13 @@ CREATE TABLE `sc_searchhistory` (
`uId` int(11) NOT NULL default '0',
PRIMARY KEY (`shId`)
) CHARACTER SET utf8 COLLATE utf8_general_ci ;
+
+
+CREATE TABLE `sc_votes` (
+ `bid` INT NOT NULL ,
+ `uid` INT NOT NULL ,
+ `vote` INT( 2 ) NOT NULL ,
+ UNIQUE KEY `bid_2` (`bid`,`uid`),
+ KEY `bid` (`bid`),
+ KEY `uid` (`uid`)
+) CHARACTER SET utf8 COLLATE utf8_general_ci ; \ No newline at end of file