Login   Register  
PHP Classes
elePHPant
Icontem

File: reviews.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Manish Khanchandani  >  Reviews  >  reviews.sql  >  Download  
File: reviews.sql
Role: Auxiliary data
Content type: text/plain
Description: Sql File
Class: Reviews
Store and retrieve reviews of products in MySQL
Author: By
Last change:
Date: 5 years ago
Size: 861 bytes
 

Contents

Class file image Download
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;