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

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `seo_keywords` varchar(255) NOT NULL,
  `seo_description` varchar(255) NOT NULL,
  `category_order` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;


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

--
-- Table structure for table `channels`
--

CREATE TABLE IF NOT EXISTS `channels` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `video_site` varchar(20) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `category_id` int(12) NOT NULL,
  `media_number` int(12) NOT NULL,
  `add_time` int(12) NOT NULL,
  `latest_activity` int(12) NOT NULL,
  `auto_update` int(1) NOT NULL,
  `auto_update_period` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;


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

--
-- Table structure for table `lists`
--

CREATE TABLE IF NOT EXISTS `lists` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `user_id` int(12) NOT NULL,
  `create_datetime` int(12) NOT NULL,
  `privacy` int(1) NOT NULL,
  `hits` int(12) NOT NULL,
  `featured` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;


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

--
-- Table structure for table `lists_media`
--

CREATE TABLE IF NOT EXISTS `lists_media` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `list_id` int(12) NOT NULL,
  `user_id` int(12) NOT NULL,
  `media_id` int(12) NOT NULL,
  `media_order` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;


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

--
-- Table structure for table `media`
--

CREATE TABLE IF NOT EXISTS `media` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `user_id` int(12) NOT NULL,
  `channel_id` int(12) NOT NULL,
  `title` varchar(255) NOT NULL,
  `video_site` varchar(20) NOT NULL,
  `permalink` varchar(255) NOT NULL,
  `details` text NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  `category_id` int(12) NOT NULL,
  `datetime` int(12) NOT NULL,
  `publish_time` int(12) NOT NULL,
  `day` int(2) NOT NULL,
  `month` int(2) NOT NULL,
  `year` int(4) NOT NULL,
  `hits` int(12) NOT NULL,
  `published` int(1) NOT NULL,
  `deleted` int(1) NOT NULL,
  `tags` varchar(255) NOT NULL,
  `video_id` varchar(255) NOT NULL,
  `duration` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=188 ;

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

--
-- Table structure for table `options`
--

CREATE TABLE IF NOT EXISTS `options` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `option_name` varchar(100) NOT NULL,
  `option_value` text NOT NULL,
  `option_default` text NOT NULL,
  `option_set` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`id`, `option_name`, `option_value`, `option_default`, `option_set`) VALUES
						(1, 'siteurl', 'http://www.site.com', 'http://www.site.com', 'General'),
						(2, 'seo_title', 'MediaCloud', 'MediaCloud', 'General'),
						(3, 'seo_keywords', 'youtube,vimeo,dailymotion', 'youtube,vimeo,dailymotion', 'General'),
						(4, 'seo_description', 'mediacloud script allow you to create multi-sources video cms that import videos from youtube, vimeo and dailymotion.', 'mediacloud script allow you to create multi-sources video cms that import videos from youtube, vimeo and dailymotion.', 'General'),
						(5, 'site_language', 'english', 'english', 'General'),
						(6, 'site_theme', 'default', 'default', 'General'),
						(7, 'category_sitemap', '1', '1', 'General'),
						(8, 'lists_sitemap', '1', '1', 'General'),
						(9, 'sitemap_items', '1000', '1000', 'General'),
						(10, 'activate_new_users', 'direct', 'direct', 'Users'),
						(11, 'cookie_name', 'MediaCloud', 'MediaCloud', 'Users'),
						(12, 'cookie_expiration_time', '3', '3', 'Users'),
						(13, 'facebook_app_id', '', '', 'Users'),
						(14, 'facebook_app_secret', '', '', 'Users'),
						(15, 'twitter_consumer_key', '', '', 'Users'),
						(16, 'twitter_consumer_secret', '', '', 'Users'),
						(17, 'media_publishing', '1', '1', 'Users'),
						(18, 'max_lists_number', '10', '10', 'Users'),
						(19, 'max_media_list_number', '24', '24', 'Users'),
						(20, 'site_logo', '&lt;i class=&quot;fa fa-cloud&quot;&gt;&lt;/i&gt; MediaCloud', '&lt;i class=&quot;fa fa-cloud&quot;&gt;&lt;/i&gt; MediaCloud', 'Theme'),
						(21, 'pagination_load', 'ajax', 'ajax', 'Theme'),
						(22, 'display_featured_slider', '1', '1', 'Theme'),
						(23, 'featured_content', 'media', 'media', 'Theme'),
						(24, 'featured_slider_items_number', '12', '12', 'Theme'),
						(25, 'home_media_number', '24', '24', 'Theme'),
						(26, 'category_media_number', '24', '24', 'Theme'),
						(27, 'search_media_number', '24', '24', 'Theme'),
						(28, 'related_media_number', '12', '12', 'Theme'),
						(29, 'public_lists_number', '24', '24', 'Theme'),
						(30, 'user_lists_number', '24', '24', 'Theme'),
						(31, 'active_instant_search', '1', '1', 'Theme'),
						(32, 'display_media_video_site', '1', '1', 'Theme'),
						(33, 'facebook_account', 'http://facebook.com', 'http://facebook.com', 'Social'),
						(34, 'twitter_account', 'http://twitter.com', 'http://twitter.com', 'Social'),
						(35, 'google_plus_account', 'http://google.com', 'http://google.com', 'Social'),
						(36, 'youtube_account', 'http://youtube.com', 'http://youtube.com', 'Social'),
						(37, 'vimeo_account', 'http://vimeo.com', 'http://vimeo.com', 'Social'),
						(38, 'dailymotion_account', 'http://dailymotion.com', 'http://dailymotion.com', 'Social'),
						(39, 'disqus_shortname', '', '', 'Comments'),
						(40, 'recaptcha_public', '', '', 'API'),
						(41, 'recaptcha_private', '', '', 'API'),
						(42, 'youtube_apikey', '', '', 'API'),
						(43, 'mail_method', 'mail', 'mail', 'Mail'),
						(44, 'send_email', 'site@email.com', 'site@email.com', 'Mail'),
						(45, 'smtp_host', '', '', 'Mail'),
						(46, 'smtp_port', '', '', 'Mail'),
						(47, 'smtp_username', '', '', 'Mail'),
						(48, 'smtp_password', '', '', 'Mail');

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

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `seo_keywords` varchar(255) NOT NULL,
  `seo_description` varchar(255) NOT NULL,
  `page_order` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;


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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `username` varchar(40) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `avatar` varchar(255) NOT NULL,
  `provider` varchar(30) NOT NULL,
  `social_id` varchar(255) NOT NULL,
  `datetime` int(12) NOT NULL,
  `last_login` int(12) NOT NULL,
  `activation_code` varchar(255) NOT NULL,
  `ip_address` varchar(50) NOT NULL,
  `active` int(1) NOT NULL,
  `day` int(2) NOT NULL,
  `month` int(2) NOT NULL,
  `year` int(4) NOT NULL,
  `super_admin` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `email`, `avatar`, `provider`, `social_id`, `datetime`, `last_login`, `activation_code`, `ip_address`, `active`, `day`, `month`, `year`, `super_admin`) VALUES
(1, 'admin', '4253dfc1e6a2e8626f13696efe4f3c4ba4fc036a9dc31082639b9984bdd09150', 'admin@site.com', '', 'site', '', 1435810213, 1443251488, 'JTS5KPY6I59KVPPS7QVGRIG', '127.0.0.1', 1, 1, 10, 2015, 1);

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

--
-- Table structure for table `user_votes`
--

CREATE TABLE IF NOT EXISTS `user_votes` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `media_id` int(12) NOT NULL,
  `user_id` int(12) NOT NULL,
  `vote_up` int(12) NOT NULL,
  `vote_down` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
