CREATE DATABASE  `reviewsite_main` ;
USE `reviewsite_main`;
	
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `banners` (
  `banner_id` int(10) unsigned NOT NULL auto_increment,
  `size` char(10) NOT NULL,
  `url` varchar(100) NOT NULL,
  `code` text NOT NULL,
  PRIMARY KEY  (`banner_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `order` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `coupon_id` int(10) unsigned NOT NULL auto_increment,
  `site_id` int(10) unsigned NOT NULL,
  `discount` varbinary(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `text` text NOT NULL,
  `url` varchar(200) NOT NULL,
  PRIMARY KEY  (`coupon_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `feature_id` int(10) unsigned NOT NULL auto_increment,
  `feature` varchar(50) NOT NULL,
  PRIMARY KEY  (`feature_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `meta`
--

CREATE TABLE `meta` (
  `meta_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `uri` varchar(100) NOT NULL,
  `use_tips` tinyint(1) NOT NULL default '0',
  `page_title` varchar(200) NOT NULL,
  `page_h1` varchar(200) NOT NULL,
  `html` text NOT NULL,
  `meta_desc` text NOT NULL,
  `meta_kwords` text NOT NULL,
  PRIMARY KEY  (`meta_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `signup_id` int(10) unsigned NOT NULL auto_increment,
  `email` varchar(100) NOT NULL,
  `signup_date` datetime NOT NULL,
  PRIMARY KEY  (`signup_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `site`
--

CREATE TABLE `site` (
  `site_id` int(10) unsigned NOT NULL auto_increment,
  `date_added` datetime NOT NULL,
  `title` varchar(50) NOT NULL,
  `default_url` varchar(200) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `disk_space` varchar(50) NOT NULL,
  `bandwidth` varchar(50) NOT NULL,
  `domain` varchar(50) NOT NULL,
  `setup` varchar(50) NOT NULL,
  `guarantee` varchar(50) NOT NULL,
  `score` smallint(2) unsigned NOT NULL,
  `uptime_rating` smallint(2) unsigned NOT NULL,
  `speed_rating` smallint(2) unsigned NOT NULL,
  PRIMARY KEY  (`site_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `site_categories`
--

CREATE TABLE `site_categories` (
  `category_id` int(10) unsigned NOT NULL,
  `site_id` int(10) unsigned NOT NULL,
  `order` tinyint(2) unsigned NOT NULL,
  `url` varchar(200) NOT NULL,
  PRIMARY KEY  (`category_id`,`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `site_features`
--

CREATE TABLE `site_features` (
  `site_id` int(10) unsigned NOT NULL,
  `feature_id` int(10) unsigned NOT NULL,
  `rating` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`site_id`,`feature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `site_review`
--

CREATE TABLE `site_review` (
  `site_id` int(10) unsigned NOT NULL,
  `overview` text NOT NULL,
  `features` text NOT NULL,
  `summary` text NOT NULL,
  PRIMARY KEY  (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `slugs`
--

CREATE TABLE `slugs` (
  `slug_id` int(10) unsigned NOT NULL auto_increment,
  `slug` varchar(250) NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `item_type` enum('static','directory','host','compare') NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY  (`slug_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `stats`
--

CREATE TABLE `stats` (
  `stat_id` int(10) unsigned NOT NULL auto_increment,
  `site_id` int(10) unsigned default NULL,
  `coupon_id` int(10) unsigned default NULL,
  `date` date NOT NULL,
  `clicks` tinyint(3) unsigned NOT NULL,
  `views` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`stat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `user_reviews`
--

CREATE TABLE `user_reviews` (
  `review_id` int(10) unsigned NOT NULL auto_increment,
  `site_id` int(10) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `title` varchar(150) NOT NULL,
  `text` text NOT NULL,
  `status` enum('Pending','Live') NOT NULL default 'Pending',
  `ip_addr` varchar(40) NOT NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `user_reviews_features`
--

CREATE TABLE `user_reviews_features` (
  `review_id` int(10) unsigned NOT NULL,
  `feature_id` int(10) unsigned NOT NULL,
  `rating` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`review_id`,`feature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE DATABASE  `reviewsite_wp` ;
USE `reviewsite_wp`;

Online Backup Review. Best Online Backup Providers

Not Found - 404

The requested URL /visit/carbonite-review was not found on this server.