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. Top 10 Best Online Backup Providers

Best 10 "Online Backup Providers" Reviewed

Online Backup is now a everyday must have. Without Online Backup you are at risk of potentially losing irreplaceable documents, photos, files, music and more. Online backup is now mainly referred to as cloud storage or online storage but essentially you are backing up all your computer files online so you can access the files from anywhere at any time. This website is a Online Backup review guide, reviewing the best Online Backup providers. So if you are looking to backup your entire digital life but not sure company is right for you then use our recommended online backup list, comparison chart, and online backup reviews to make your decision. View the top 10 list below:

Let us find the best Online Backup company for you, so you don't have to...

 
The Top 10 Best Online Backup List
Last Update 22nd December 2014
 
Rank Online Backup Provider Price Score Review
 
 

Top Ranked Online Backup For December -

This month, MyPC Backup takes the award again as the top Online Backup solution as voted by you! MyPCBackup.com has dominated our site for 10 months running and the great feedback that we receive each day hasn't slowed down one bit.

MyPC Backup is leading the way in the Online Backup industry with their award winning Online Backup service. Their unique 'Set and Forget' method makes MyPCBackup.com the most user friendly backup service on the internet today.

About Best 10 Online Backup Companies

So who are we and how do we know so much about Online Backup? Well unlike other data backup review sites, our list is ranked on actual reviews and experiences by real users worldwide. We let the customers decide who the best backup service is around. So if you are new to data backup and are looking for a service to backup your files online, or if you just want to switch providers then our reviews should be easy to follow and make sure you find the best data backup company to suit all your backup needs.

Our top10 table and customer reviews are regularly updated, so read all our reviews and we welcome any reviews you would like to submit about your experiences with any of the 10 providers on our site.

This year alone Top-10-Online-Backup.com has helped over 4,500 computer users find the best data backup solutions to suit their backup needs. This figure is going up daily and with your help and reviews it will continue to grow. If you have any comments about this website we always welcome feedback please. Please head over to the contact us page to get in touch!

www.Top-10-Online-Backup.com

Online Backup FAQ's