%META:TOPICINFO{author="TWikiContributor" date="1296361838" format="1.1" version="1"}%
---+ Peer Review !MySQL Setup

Get !MySQL from http://www.mysql.com/ and follow the install instructions.

Create a new database using something like...

=/path/to/mysql/bin/mysqladmin -u root -p rootpassword create Peer=

Then go to the mysql command line for the database with something like...

=mysql -u username -p password Peer=

Create a new user account using something like...

<verbatim>
GRANT ALL
    ON Peer.*
    TO username IDENTIFIED BY 'password'
</verbatim>

Make sure that the plugin configure variables match the database setup:

<verbatim>
my $reviewTable = "reviews";
my $tempTable   = "temp";
my $tempOutTable= "tempout";
my $tempCountTable = "tempcount";
my $tempBestTable = "tempbest";
my $dataBase    = "dbi:mysql:Peer";
my $dbUsername  = "username";
my $dbPassword  = "password";
</verbatim>

The following table needS to be created manually:

<verbatim>
CREATE TABLE reviews
(Reviewer VARCHAR(255) NOT NULL,
Topic VARCHAR(255) NOT NULL,
TopicRev INT,
Notify INT NOT NULL,
Quality INT NOT NULL,
Relevance INT,
Completeness INT,
Timeliness INT,
Comment VARCHAR(255),
DateTime DATETIME)
</verbatim>

The following tables are automatically created by Review.pm - this allows each connection to have private tables with the same name...make sure that the user has create privileges.

<verbatim>
CREATE TEMPORARY TABLE temp
(Reviewer VARCHAR(255) NOT NULL,
Topic VARCHAR(255) NOT NULL,
TopicRev INT,
Notify INT NOT NULL,
Quality INT NOT NULL,
Relevance INT,
Completeness INT,
Timeliness INT,
Comment VARCHAR(255),
DateTime DATETIME)

CREATE TEMPORARY TABLE tempout
(Reviewer VARCHAR(255) NOT NULL,
Topic VARCHAR(255) NOT NULL,
TopicRev INT,
Notify INT NOT NULL,
Quality INT NOT NULL,
Relevance INT,
Completeness INT,
Timeliness INT,
Comment VARCHAR(255),
DateTime DATETIME)

CREATE TEMPORARY TABLE tempcount
(Topic VARCHAR(255),
Count INT)

CREATE TEMPORARY TABLE tempbest
(Topic VARCHAR(255),
Quality INT,
Metric INT)
</verbatim>

Back to PeerReviewInstall

-- TWiki:Main.StephenRoe - 27 Jun 2001
