PHP Classes

File: reviews.sql

Recommend this page to a friend!
  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: 14 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;