Tags:
create new tag
, view all tags
MySQL

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 -ppassword Peer

Create a new user account using somthing like...

GRANT ALL
ON Peer.*
TO username IDENTIFIED BY 'password'

Make sure that the Plugin config variables match the database setup:

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";

The following table needS to be created manually:


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)

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.


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)

Topic revision: r1 - 2001-08-22 - SteveRoe
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.