Hello and thanks for your wonderfull product, I am interisted in buying the paid version, but want to test before buying. Here is a sample of my database any help with intergration would be nice! My site uses smarty for templating. http://tellyshack.com
-- phpMyAdmin SQL Dump
-- version 3.5.8.1
-- http://www.phpmyadmin.net
--
-- Host: sql206.freehostingking.com
-- Generation Time: Jul 25, 2013 at 12:23 PM
-- Server version: 5.5.30-30.2
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `fking_12676952_php`
--
-- --------------------------------------------------------
--
-- Table structure for table `activity`
--
CREATE TABLE IF NOT EXISTS `activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`user_data` text NOT NULL,
`target_data` text NOT NULL,
`target_type` tinyint(4) NOT NULL,
`event_date` datetime NOT NULL,
`event_type` tinyint(4) NOT NULL,
`event_comment` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `activity`
--
INSERT INTO `activity` (`id`, `user_id`, `target_id`, `user_data`, `target_data`, `target_type`, `event_date`, `event_type`, `event_comment`) VALUES
(1, 1, 0, '{"id":1,"username":"Catfish","email":"franselstadt@outlook.com","fb_id":"0","avatar":"nopic.jpg","fb_session":""}', '[]', 0, '2013-07-23 15:52:27', 3, 'Üdv a körünkben!');
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');
-- --------------------------------------------------------
--
-- Table structure for table `broken_episodes`
--
CREATE TABLE IF NOT EXISTS `broken_episodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episodeid` int(11) NOT NULL,
`reportdate` datetime NOT NULL,
`problem` varchar(255) NOT NULL,
`ip` varchar(30) NOT NULL,
`user_id` int(11) NOT NULL,
`user_agent` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `broken_movies`
--
CREATE TABLE IF NOT EXISTS `broken_movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movieid` int(11) NOT NULL,
`reportdate` datetime NOT NULL,
`problem` varchar(255) NOT NULL,
`ip` varchar(30) NOT NULL,
`user_id` int(11) NOT NULL,
`user_agent` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`postid` int(10) unsigned NOT NULL DEFAULT '0',
`topid` int(10) unsigned NOT NULL DEFAULT '0',
`user` int(10) NOT NULL,
`body` text COLLATE utf8_unicode_ci NOT NULL,
`dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`like` smallint(6) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=178 ;
-- --------------------------------------------------------
--
-- Table structure for table `embeds`
--
CREATE TABLE IF NOT EXISTS `embeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episode_id` int(11) NOT NULL,
`embed` text NOT NULL,
`link` varchar(255) NOT NULL,
`lang` varchar(20) NOT NULL,
`weight` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `episode_id` (`episode_id`),
KEY `lang` (`lang`),
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `episodes`
--
CREATE TABLE IF NOT EXISTS `episodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`show_id` int(11) NOT NULL,
`season` int(11) NOT NULL,
`episode` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`embed` text NOT NULL,
`date_added` datetime NOT NULL,
`thumbnail` varchar(255) NOT NULL,
`views` bigint(20) NOT NULL,
`checked` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `category_id` (`show_id`),
KEY `season` (`season`),
KEY `episode` (`episode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `friends`
--
CREATE TABLE IF NOT EXISTS `friends` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user1` int(11) NOT NULL,
`user2` int(11) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user1` (`user1`),
KEY `user2` (`user2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `likes`
--
CREATE TABLE IF NOT EXISTS `likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`target_type` tinyint(4) NOT NULL,
`comment` varchar(500) NOT NULL,
`vote` tinyint(4) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`),
KEY `target_type` (`target_type`),
KEY `date_added` (`date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `modules`
--
CREATE TABLE IF NOT EXISTS `modules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`perma` varchar(30) NOT NULL,
`title` varchar(30) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `modules`
--
INSERT INTO `modules` (`id`, `perma`, `title`, `status`) VALUES
(1, 'tv_shows', 'TV shows', 1),
(2, 'movies', 'Movies', 1),
(7, 'submit_links', 'Submit links', 1),
(6, 'requests', 'Requests', 1);
-- --------------------------------------------------------
--
-- Table structure for table `movies`
--
CREATE TABLE IF NOT EXISTS `movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`perma` varchar(50) NOT NULL,
`description` text NOT NULL,
`thumb` varchar(50) NOT NULL,
`embed` text NOT NULL,
`views` bigint(20) NOT NULL,
`imdb_id` varchar(30) NOT NULL,
`imdb_rating` float NOT NULL,
`date_added` datetime NOT NULL,
`meta` text NOT NULL,
PRIMARY KEY (`id`),
KEY `imdb_id` (`imdb_id`),
KEY `title` (`title`),
KEY `perma` (`perma`),
KEY `imdb_rating` (`imdb_rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `movies`
--
INSERT INTO `movies` (`id`, `title`, `perma`, `description`, `thumb`, `embed`, `views`, `imdb_id`, `imdb_rating`, `date_added`, `meta`) VALUES
(1, '{"en":"Turbo"}', 'turbo', '{"en":"A freak accident might just help an everyday garden snail achieve his biggest dream: winning the Indy 500."}', 'movie_6f53bfe04e78da893ba0c4f35ba6847e.jpg', '', 16, 'tt1860353', 6.4, '2013-07-24 19:41:48', '');
-- --------------------------------------------------------
--
-- Table structure for table `movie_embeds`
--
CREATE TABLE IF NOT EXISTS `movie_embeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movie_id` int(11) NOT NULL,
`embed` varchar(1024) NOT NULL,
`link` varchar(255) NOT NULL,
`lang` varchar(20) NOT NULL,
`weight` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `movie_id` (`movie_id`),
KEY `lang` (`lang`),
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `movie_embeds`
--
INSERT INTO `movie_embeds` (`id`, `movie_id`, `embed`, `link`, `lang`, `weight`) VALUES
(1, 1, '<iframe style="overflow: hidden; border: 0; width: 620px; height: 360px" src="http://embed.novamov.com/embed.php?width=620&height=360&v=&px=1" scrolling="no"></iframe>', 'http://embed.novamov.com/embed.php?width=600&height=480&v=fmz7oogpii5gj&px=1'' scrolling=''no''', 'ENG', 2);
-- --------------------------------------------------------
--
-- Table structure for table `movie_ratings`
--
CREATE TABLE IF NOT EXISTS `movie_ratings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movieid` int(11) NOT NULL,
`rating` float NOT NULL,
`ip` varchar(30) NOT NULL,
`ratingdate` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `movieid` (`movieid`),
KEY `rating` (`rating`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `movie_ratings`
--
INSERT INTO `movie_ratings` (`id`, `movieid`, `rating`, `ip`, `ratingdate`) VALUES
(1, 1, 5, '31.100.240.202', '2013-07-24 23:02:17');
-- --------------------------------------------------------
--
-- Table structure for table `movie_tags`
--
CREATE TABLE IF NOT EXISTS `movie_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(150) NOT NULL,
`perma` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `perma` (`perma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `movie_tags_join`
--
CREATE TABLE IF NOT EXISTS `movie_tags_join` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`movie_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tag_id` (`tag_id`),
KEY `movie_id` (`movie_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE IF NOT EXISTS `pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`permalink` varchar(255) NOT NULL,
`content` text NOT NULL,
`parent_id` int(11) NOT NULL,
`visible` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `permalink` (`permalink`),
KEY `parent_id` (`parent_id`),
KEY `visible` (`visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `plugins`
--
CREATE TABLE IF NOT EXISTS `plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dirname` varchar(30) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`install_url` varchar(100) NOT NULL,
`start_url` varchar(100) NOT NULL,
`author` varchar(255) NOT NULL,
`author_url` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `ratings`
--
CREATE TABLE IF NOT EXISTS `ratings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episodeid` int(11) NOT NULL,
`rating` float NOT NULL,
`ip` varchar(30) NOT NULL,
`ratingdate` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `episodeid` (`episodeid`),
KEY `rating` (`rating`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `reports`
--
CREATE TABLE IF NOT EXISTS `reports` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`commentid` int(10) DEFAULT '0',
`userid` int(10) DEFAULT '0',
`dt` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
-- --------------------------------------------------------
--
-- Table structure for table `requests`
--
CREATE TABLE IF NOT EXISTS `requests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`request_date` datetime NOT NULL,
`message` text NOT NULL,
`response` text NOT NULL,
`status` tinyint(4) NOT NULL,
`votes` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `request_votes`
--
CREATE TABLE IF NOT EXISTS `request_votes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`request_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`vote_date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `request_id` (`request_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `title`, `value`) VALUES
(1, 'default_language', 'en'),
(2, 'maxtvperpage', '50'),
(3, 'maxmoviesperpage', '50'),
(4, 'countdown_free', '30'),
(5, 'countdown_user', '0'),
(6, 'seo_links', '1'),
(7, 'smart_bar', '0');
-- --------------------------------------------------------
--
-- Table structure for table `shows`
--
CREATE TABLE IF NOT EXISTS `shows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`thumbnail` varchar(120) NOT NULL,
`permalink` varchar(255) NOT NULL,
`sidereel_url` varchar(255) NOT NULL,
`imdb_id` varchar(20) NOT NULL,
`type` tinyint(4) NOT NULL,
`featured` tinyint(4) NOT NULL DEFAULT '0',
`last_episode` datetime NOT NULL,
`imdb_rating` float NOT NULL,
`meta` text NOT NULL,
PRIMARY KEY (`id`),
KEY `permalink` (`permalink`),
KEY `title` (`title`),
KEY `featured` (`featured`),
KEY `last_episode` (`last_episode`),
KEY `imdb_id` (`imdb_id`),
KEY `imdb_rating` (`imdb_rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `similar_movies`
--
CREATE TABLE IF NOT EXISTS `similar_movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movie1` int(11) NOT NULL,
`movie2` int(11) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `movie1` (`movie1`),
KEY `movie2` (`movie2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `similar_shows`
--
CREATE TABLE IF NOT EXISTS `similar_shows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`show1` int(11) NOT NULL,
`show2` int(11) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `show1` (`show1`),
KEY `show2` (`show2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `submitted_links`
--
CREATE TABLE IF NOT EXISTS `submitted_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`imdb_id` varchar(20) NOT NULL,
`season` int(11) NOT NULL,
`episode` int(11) NOT NULL,
`link` varchar(255) NOT NULL,
`language` varchar(10) NOT NULL,
`date_submitted` datetime NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `type` (`type`),
KEY `imdb_id` (`imdb_id`),
KEY `season` (`season`),
KEY `episode` (`episode`),
KEY `language` (`language`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tv_submits`
--
CREATE TABLE IF NOT EXISTS `tv_submits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episode_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`link` varchar(255) NOT NULL,
`timestamp` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `episode_id` (`episode_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tv_tags`
--
CREATE TABLE IF NOT EXISTS `tv_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(150) NOT NULL,
`perma` varchar(100) CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `perma` (`perma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tv_tags_join`
--
CREATE TABLE IF NOT EXISTS `tv_tags_join` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`show_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tag_id` (`tag_id`),
KEY `show_id` (`show_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(25) NOT NULL,
`password` varchar(32) NOT NULL,
`email` varchar(150) NOT NULL,
`fb_id` bigint(20) NOT NULL,
`fb_session` varchar(200) NOT NULL,
`avatar` varchar(100) NOT NULL,
`notify_favorite` tinyint(4) NOT NULL DEFAULT '1',
`notify_new` tinyint(4) NOT NULL DEFAULT '1',
`language` varchar(2) NOT NULL DEFAULT 'hu',
`country` varchar(20) NOT NULL,
`dob_day` int(2) NOT NULL,
`dob_month` varchar(18) NOT NULL,
`dob_year` int(4) NOT NULL,
`gender` varchar(7) NOT NULL,
`bio` varchar(500) NOT NULL,
`admin` tinyint(1) DEFAULT '0',
`guest` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `notify_favorite` (`notify_favorite`),
KEY `notify_new` (`notify_new`),
KEY `username` (`username`),
KEY `password` (`password`),
KEY `fb_id` (`fb_id`),
KEY `language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `email`, `fb_id`, `fb_session`, `avatar`, `notify_favorite`, `notify_new`, `language`, `country`, `dob_day`, `dob_month`, `dob_year`, `gender`, `bio`, `admin`, `guest`) VALUES
(1, 'Catfish', '3c7cc88f70aea29d160b141e57997ee1', 'franselstadt@outlook.com', 0, '', '', 1, 1, 'en', 'South Africa', 1, 'September', 1995, 'Male', '', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `votes`
--
CREATE TABLE IF NOT EXISTS `votes` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`commentid` int(10) DEFAULT '0',
`userid` int(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
-- --------------------------------------------------------
--
-- Table structure for table `watches`
--
CREATE TABLE IF NOT EXISTS `watches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`target_type` tinyint(4) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`),
KEY `target_type` (`target_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Hello and thanks for your wonderfull product, I am interisted in buying the paid version, but want to test before buying. Here is a sample of my database any help with intergration would be nice! My site uses smarty for templating. http://tellyshack.com
-- phpMyAdmin SQL Dump
-- version 3.5.8.1
-- http://www.phpmyadmin.net
--
-- Host: sql206.freehostingking.com
-- Generation Time: Jul 25, 2013 at 12:23 PM
-- Server version: 5.5.30-30.2
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `fking_12676952_php`
--
-- --------------------------------------------------------
--
-- Table structure for table `activity`
--
CREATE TABLE IF NOT EXISTS `activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`user_data` text NOT NULL,
`target_data` text NOT NULL,
`target_type` tinyint(4) NOT NULL,
`event_date` datetime NOT NULL,
`event_type` tinyint(4) NOT NULL,
`event_comment` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `activity`
--
INSERT INTO `activity` (`id`, `user_id`, `target_id`, `user_data`, `target_data`, `target_type`, `event_date`, `event_type`, `event_comment`) VALUES
(1, 1, 0, '{"id":1,"username":"Catfish","email":"franselstadt@outlook.com","fb_id":"0","avatar":"nopic.jpg","fb_session":""}', '[]', 0, '2013-07-23 15:52:27', 3, 'Üdv a körünkben!');
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');
-- --------------------------------------------------------
--
-- Table structure for table `broken_episodes`
--
CREATE TABLE IF NOT EXISTS `broken_episodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episodeid` int(11) NOT NULL,
`reportdate` datetime NOT NULL,
`problem` varchar(255) NOT NULL,
`ip` varchar(30) NOT NULL,
`user_id` int(11) NOT NULL,
`user_agent` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `broken_movies`
--
CREATE TABLE IF NOT EXISTS `broken_movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movieid` int(11) NOT NULL,
`reportdate` datetime NOT NULL,
`problem` varchar(255) NOT NULL,
`ip` varchar(30) NOT NULL,
`user_id` int(11) NOT NULL,
`user_agent` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`postid` int(10) unsigned NOT NULL DEFAULT '0',
`topid` int(10) unsigned NOT NULL DEFAULT '0',
`user` int(10) NOT NULL,
`body` text COLLATE utf8_unicode_ci NOT NULL,
`dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`like` smallint(6) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=178 ;
-- --------------------------------------------------------
--
-- Table structure for table `embeds`
--
CREATE TABLE IF NOT EXISTS `embeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episode_id` int(11) NOT NULL,
`embed` text NOT NULL,
`link` varchar(255) NOT NULL,
`lang` varchar(20) NOT NULL,
`weight` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `episode_id` (`episode_id`),
KEY `lang` (`lang`),
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `episodes`
--
CREATE TABLE IF NOT EXISTS `episodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`show_id` int(11) NOT NULL,
`season` int(11) NOT NULL,
`episode` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`embed` text NOT NULL,
`date_added` datetime NOT NULL,
`thumbnail` varchar(255) NOT NULL,
`views` bigint(20) NOT NULL,
`checked` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `category_id` (`show_id`),
KEY `season` (`season`),
KEY `episode` (`episode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `friends`
--
CREATE TABLE IF NOT EXISTS `friends` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user1` int(11) NOT NULL,
`user2` int(11) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user1` (`user1`),
KEY `user2` (`user2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `likes`
--
CREATE TABLE IF NOT EXISTS `likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`target_type` tinyint(4) NOT NULL,
`comment` varchar(500) NOT NULL,
`vote` tinyint(4) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`),
KEY `target_type` (`target_type`),
KEY `date_added` (`date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `modules`
--
CREATE TABLE IF NOT EXISTS `modules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`perma` varchar(30) NOT NULL,
`title` varchar(30) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `modules`
--
INSERT INTO `modules` (`id`, `perma`, `title`, `status`) VALUES
(1, 'tv_shows', 'TV shows', 1),
(2, 'movies', 'Movies', 1),
(7, 'submit_links', 'Submit links', 1),
(6, 'requests', 'Requests', 1);
-- --------------------------------------------------------
--
-- Table structure for table `movies`
--
CREATE TABLE IF NOT EXISTS `movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`perma` varchar(50) NOT NULL,
`description` text NOT NULL,
`thumb` varchar(50) NOT NULL,
`embed` text NOT NULL,
`views` bigint(20) NOT NULL,
`imdb_id` varchar(30) NOT NULL,
`imdb_rating` float NOT NULL,
`date_added` datetime NOT NULL,
`meta` text NOT NULL,
PRIMARY KEY (`id`),
KEY `imdb_id` (`imdb_id`),
KEY `title` (`title`),
KEY `perma` (`perma`),
KEY `imdb_rating` (`imdb_rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `movies`
--
INSERT INTO `movies` (`id`, `title`, `perma`, `description`, `thumb`, `embed`, `views`, `imdb_id`, `imdb_rating`, `date_added`, `meta`) VALUES
(1, '{"en":"Turbo"}', 'turbo', '{"en":"A freak accident might just help an everyday garden snail achieve his biggest dream: winning the Indy 500."}', 'movie_6f53bfe04e78da893ba0c4f35ba6847e.jpg', '', 16, 'tt1860353', 6.4, '2013-07-24 19:41:48', '');
-- --------------------------------------------------------
--
-- Table structure for table `movie_embeds`
--
CREATE TABLE IF NOT EXISTS `movie_embeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movie_id` int(11) NOT NULL,
`embed` varchar(1024) NOT NULL,
`link` varchar(255) NOT NULL,
`lang` varchar(20) NOT NULL,
`weight` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `movie_id` (`movie_id`),
KEY `lang` (`lang`),
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `movie_embeds`
--
INSERT INTO `movie_embeds` (`id`, `movie_id`, `embed`, `link`, `lang`, `weight`) VALUES
(1, 1, '&lt;iframe style="overflow: hidden; border: 0; width: 620px; height: 360px" src="http://embed.novamov.com/embed.php?width=620&height=360&v=&px=1" scrolling="no"&gt;&lt;/iframe&gt;', 'http://embed.novamov.com/embed.php?width=600&height=480&v=fmz7oogpii5gj&px=1'' scrolling=''no''', 'ENG', 2);
-- --------------------------------------------------------
--
-- Table structure for table `movie_ratings`
--
CREATE TABLE IF NOT EXISTS `movie_ratings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movieid` int(11) NOT NULL,
`rating` float NOT NULL,
`ip` varchar(30) NOT NULL,
`ratingdate` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `movieid` (`movieid`),
KEY `rating` (`rating`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `movie_ratings`
--
INSERT INTO `movie_ratings` (`id`, `movieid`, `rating`, `ip`, `ratingdate`) VALUES
(1, 1, 5, '31.100.240.202', '2013-07-24 23:02:17');
-- --------------------------------------------------------
--
-- Table structure for table `movie_tags`
--
CREATE TABLE IF NOT EXISTS `movie_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(150) NOT NULL,
`perma` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `perma` (`perma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `movie_tags_join`
--
CREATE TABLE IF NOT EXISTS `movie_tags_join` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`movie_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tag_id` (`tag_id`),
KEY `movie_id` (`movie_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE IF NOT EXISTS `pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`permalink` varchar(255) NOT NULL,
`content` text NOT NULL,
`parent_id` int(11) NOT NULL,
`visible` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `permalink` (`permalink`),
KEY `parent_id` (`parent_id`),
KEY `visible` (`visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `plugins`
--
CREATE TABLE IF NOT EXISTS `plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dirname` varchar(30) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`install_url` varchar(100) NOT NULL,
`start_url` varchar(100) NOT NULL,
`author` varchar(255) NOT NULL,
`author_url` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `ratings`
--
CREATE TABLE IF NOT EXISTS `ratings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episodeid` int(11) NOT NULL,
`rating` float NOT NULL,
`ip` varchar(30) NOT NULL,
`ratingdate` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `episodeid` (`episodeid`),
KEY `rating` (`rating`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `reports`
--
CREATE TABLE IF NOT EXISTS `reports` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`commentid` int(10) DEFAULT '0',
`userid` int(10) DEFAULT '0',
`dt` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
-- --------------------------------------------------------
--
-- Table structure for table `requests`
--
CREATE TABLE IF NOT EXISTS `requests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`request_date` datetime NOT NULL,
`message` text NOT NULL,
`response` text NOT NULL,
`status` tinyint(4) NOT NULL,
`votes` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `request_votes`
--
CREATE TABLE IF NOT EXISTS `request_votes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`request_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`vote_date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `request_id` (`request_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `title`, `value`) VALUES
(1, 'default_language', 'en'),
(2, 'maxtvperpage', '50'),
(3, 'maxmoviesperpage', '50'),
(4, 'countdown_free', '30'),
(5, 'countdown_user', '0'),
(6, 'seo_links', '1'),
(7, 'smart_bar', '0');
-- --------------------------------------------------------
--
-- Table structure for table `shows`
--
CREATE TABLE IF NOT EXISTS `shows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`thumbnail` varchar(120) NOT NULL,
`permalink` varchar(255) NOT NULL,
`sidereel_url` varchar(255) NOT NULL,
`imdb_id` varchar(20) NOT NULL,
`type` tinyint(4) NOT NULL,
`featured` tinyint(4) NOT NULL DEFAULT '0',
`last_episode` datetime NOT NULL,
`imdb_rating` float NOT NULL,
`meta` text NOT NULL,
PRIMARY KEY (`id`),
KEY `permalink` (`permalink`),
KEY `title` (`title`),
KEY `featured` (`featured`),
KEY `last_episode` (`last_episode`),
KEY `imdb_id` (`imdb_id`),
KEY `imdb_rating` (`imdb_rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `similar_movies`
--
CREATE TABLE IF NOT EXISTS `similar_movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`movie1` int(11) NOT NULL,
`movie2` int(11) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `movie1` (`movie1`),
KEY `movie2` (`movie2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `similar_shows`
--
CREATE TABLE IF NOT EXISTS `similar_shows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`show1` int(11) NOT NULL,
`show2` int(11) NOT NULL,
`score` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `show1` (`show1`),
KEY `show2` (`show2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `submitted_links`
--
CREATE TABLE IF NOT EXISTS `submitted_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`imdb_id` varchar(20) NOT NULL,
`season` int(11) NOT NULL,
`episode` int(11) NOT NULL,
`link` varchar(255) NOT NULL,
`language` varchar(10) NOT NULL,
`date_submitted` datetime NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `type` (`type`),
KEY `imdb_id` (`imdb_id`),
KEY `season` (`season`),
KEY `episode` (`episode`),
KEY `language` (`language`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tv_submits`
--
CREATE TABLE IF NOT EXISTS `tv_submits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`episode_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`link` varchar(255) NOT NULL,
`timestamp` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `episode_id` (`episode_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tv_tags`
--
CREATE TABLE IF NOT EXISTS `tv_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(150) NOT NULL,
`perma` varchar(100) CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `perma` (`perma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tv_tags_join`
--
CREATE TABLE IF NOT EXISTS `tv_tags_join` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`show_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tag_id` (`tag_id`),
KEY `show_id` (`show_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(25) NOT NULL,
`password` varchar(32) NOT NULL,
`email` varchar(150) NOT NULL,
`fb_id` bigint(20) NOT NULL,
`fb_session` varchar(200) NOT NULL,
`avatar` varchar(100) NOT NULL,
`notify_favorite` tinyint(4) NOT NULL DEFAULT '1',
`notify_new` tinyint(4) NOT NULL DEFAULT '1',
`language` varchar(2) NOT NULL DEFAULT 'hu',
`country` varchar(20) NOT NULL,
`dob_day` int(2) NOT NULL,
`dob_month` varchar(18) NOT NULL,
`dob_year` int(4) NOT NULL,
`gender` varchar(7) NOT NULL,
`bio` varchar(500) NOT NULL,
`admin` tinyint(1) DEFAULT '0',
`guest` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `notify_favorite` (`notify_favorite`),
KEY `notify_new` (`notify_new`),
KEY `username` (`username`),
KEY `password` (`password`),
KEY `fb_id` (`fb_id`),
KEY `language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `email`, `fb_id`, `fb_session`, `avatar`, `notify_favorite`, `notify_new`, `language`, `country`, `dob_day`, `dob_month`, `dob_year`, `gender`, `bio`, `admin`, `guest`) VALUES
(1, 'Catfish', '3c7cc88f70aea29d160b141e57997ee1', 'franselstadt@outlook.com', 0, '', '', 1, 1, 'en', 'South Africa', 1, 'September', 1995, 'Male', '', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `votes`
--
CREATE TABLE IF NOT EXISTS `votes` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`commentid` int(10) DEFAULT '0',
`userid` int(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `commentid` (`commentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
-- --------------------------------------------------------
--
-- Table structure for table `watches`
--
CREATE TABLE IF NOT EXISTS `watches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`target_type` tinyint(4) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`),
KEY `target_type` (`target_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
