-- phpMyAdmin SQL Dump 
-- version 2.9.0.2 
-- http://www.phpmyadmin.net 
-- 
-- Host: localhost 
-- Generation Time: Jun 17, 2007 at 03:21 PM 
-- Server version: 4.0.27 
-- PHP Version: 4.4.2 
-- 
-- Database: `review` 
-- 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `add_product` 
-- 

CREATE TABLE `add_product` ( 
`pid` int(11) NOT NULL auto_increment, 
`catid` varchar(50) NOT NULL default '', 
`uid` varchar(50) NOT NULL default '', 
`pname` varchar(50) NOT NULL default '', 
`pdesc` varchar(250) NOT NULL default '', 
`ptype` varchar(50) NOT NULL default '', 
`price` varchar(50) NOT NULL default '', 
`url` varchar(150) NOT NULL default '', 
`name` varchar(50) NOT NULL default '', 
`mail` varchar(50) NOT NULL default '', 
`approve` tinyint(4) NOT NULL default '0', 
PRIMARY KEY (`pid`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `add_product` 
-- 


-- -------------------------------------------------------- 

-- 
-- Table structure for table `category` 
-- 

CREATE TABLE `category` ( 
`id` int(11) NOT NULL auto_increment, 
`name` varchar(50) NOT NULL default '', 
PRIMARY KEY (`id`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `category` 
-- 

INSERT INTO `category` VALUES (2, 'Test'); 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `comment` 
-- 

CREATE TABLE `comment` ( 
`cid` int(11) NOT NULL auto_increment, 
`uid` varchar(50) NOT NULL default '0', 
`pname` varchar(50) NOT NULL default '', 
`prid` varchar(50) NOT NULL default '0', 
`catid` varchar(50) NOT NULL default '0', 
`name` varchar(50) NOT NULL default '', 
`dat` date NOT NULL default '0000-00-00', 
`image` text NOT NULL, 
`coment` varchar(250) NOT NULL default '', 
`rating` varchar(50) NOT NULL default '', 
`person` varchar(50) NOT NULL default '', 
`category` varchar(50) NOT NULL default '', 
`postdate` time NOT NULL default '00:00:00', 
`status` tinyint(4) NOT NULL default '0', 
`adminid` varchar(50) NOT NULL default '', 
PRIMARY KEY (`cid`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `comment` 
-- 


-- -------------------------------------------------------- 

-- 
-- Table structure for table `contact` 
-- 

CREATE TABLE `contact` ( 
`id` int(11) NOT NULL auto_increment, 
`title` varchar(50) NOT NULL default '', 
`mail` varchar(50) NOT NULL default '', 
`description` varchar(250) NOT NULL default '', 
PRIMARY KEY (`id`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `contact` 
-- 


-- -------------------------------------------------------- 

-- 
-- Table structure for table `country` 
-- 

CREATE TABLE `country` ( 
`id` int(11) NOT NULL auto_increment, 
`con_name` varchar(50) NOT NULL default '', 
PRIMARY KEY (`id`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `country` 
-- 

INSERT INTO `country` VALUES (2, 'USA'); 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `main_admin` 
-- 

CREATE TABLE `main_admin` ( 
`aid` int(11) NOT NULL auto_increment, 
`adminpass` varchar(50) NOT NULL default '', 
`adminname` varchar(50) NOT NULL default '', 
PRIMARY KEY (`aid`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `main_admin` 
-- 

INSERT INTO `main_admin` VALUES (1, 'admin', 'password'); 
INSERT INTO `main_admin` VALUES (2, '', 'youremail[AT]yourdomain.com'); 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `register` 
-- 

CREATE TABLE `register` ( 
`rid` int(11) NOT NULL auto_increment, 
`adminid` varchar(50) NOT NULL default '', 
`name` varchar(50) NOT NULL default '', 
`mail` varchar(50) NOT NULL default '', 
`user` varchar(50) NOT NULL default '', 
`pass` varchar(50) NOT NULL default '', 
`status` tinyint(4) NOT NULL default '0', 
`approve` tinyint(4) NOT NULL default '0', 
PRIMARY KEY (`rid`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `register` 
-- 


-- -------------------------------------------------------- 

-- 
-- Table structure for table `site_manage` 
-- 

CREATE TABLE `site_manage` ( 
`id` int(11) NOT NULL auto_increment, 
`desc` varchar(250) NOT NULL default '', 
`title` varchar(150) NOT NULL default '', 
`message` longtext NOT NULL, 
PRIMARY KEY (`id`) 
) TYPE=MyISAM; 

-- 
-- Dumping data for table `site_manage` 
--