File: reviews.sql

CREATE TABLE `xoriant_reviews_ratings` (
`rating_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`item_id` int( 11 ) default NULL ,
`user_id` int( 11 ) default NULL ,
`review_title` varchar( 255 ) default NULL ,
`review_description` text,
`pros` text,
`cons` text,
`rating` tinyint( 4 ) default NULL ,
`rating_ip` varchar( 20 ) default NULL ,
`rating_date` datetime default NULL ,
PRIMARY KEY ( `rating_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;

CREATE TABLE `xoriant_reviews_ratings_confirm` (
`confirm_rating_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`item_id` int( 11 ) default NULL ,
`rating_id` int( 11 ) default NULL ,
`confirm_user_id` int( 11 ) default NULL ,
`confirm` tinyint( 1 ) default NULL ,
`confirm_ip` varchar( 20 ) default NULL ,
`confirm_date` datetime default NULL ,
PRIMARY KEY ( `confirm_rating_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;