diff options
| author | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-23 16:53:18 +0000 |
|---|---|---|
| committer | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-23 16:53:18 +0000 |
| commit | 3350658545a4645eb7eeea6323636b79310a18cc (patch) | |
| tree | 9ab4e57c5b340768820d45a1103eb2790debb734 /data/tables.sql | |
| parent | 97e702d088251e1c1d0dc92b5f4a231d96741087 (diff) | |
| download | semanticscuttle-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.sql | 10 |
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 |