summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorcweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-10-28 22:24:06 +0000
committercweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2009-10-28 22:24:06 +0000
commit0fcbe3158d60813b8787b9e6663550af5d868d5c (patch)
tree9e87b57de7921037cff333560db93cab4cbfbc49
parent4645da95212ef87be872290a01b186eabb74bb28 (diff)
downloadsemanticscuttle-0fcbe3158d60813b8787b9e6663550af5d868d5c.tar.gz
semanticscuttle-0fcbe3158d60813b8787b9e6663550af5d868d5c.tar.bz2
rename vote table columns
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@456 b3834d28-1941-0410-a4f8-b48e95affb8f
-rw-r--r--data/tables.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/data/tables.sql b/data/tables.sql
index fab7162..9f94d3b 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -174,10 +174,10 @@ CREATE TABLE `sc_searchhistory` (
CREATE TABLE `sc_votes` (
- `bid` INT NOT NULL ,
- `uid` INT NOT NULL ,
+ `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`)
+ 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