diff options
| author | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-28 22:24:06 +0000 |
|---|---|---|
| committer | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-28 22:24:06 +0000 |
| commit | 0fcbe3158d60813b8787b9e6663550af5d868d5c (patch) | |
| tree | 9e87b57de7921037cff333560db93cab4cbfbc49 /data/tables.sql | |
| parent | 4645da95212ef87be872290a01b186eabb74bb28 (diff) | |
| download | semanticscuttle-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
Diffstat (limited to 'data/tables.sql')
| -rw-r--r-- | data/tables.sql | 10 |
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 |