-- phpMyAdmin SQL Dump
-- version 4.0.6deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 21, 2014 at 05:15 AM
-- Server version: 5.5.35-0ubuntu0.13.10.2
-- PHP Version: 5.5.3-1ubuntu2.2
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: `nisge_gold`
--
-- --------------------------------------------------------
--
-- Table structure for table `gold_blocks`
--
CREATE TABLE IF NOT EXISTS `gold_blocks` (
`block_id` int(11) NOT NULL AUTO_INCREMENT,
`block_type` varchar(100) NOT NULL,
`block_title` varchar(1000) NOT NULL,
`block_name` varchar(100) NOT NULL,
`block_position` bigint(20) NOT NULL,
`block_status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`block_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `gold_blocks`
--
INSERT INTO `gold_blocks` (`block_id`, `block_type`, `block_title`, `block_name`, `block_position`, `block_status`) VALUES
(1, 'main', 'Profile Box', 'profile_box', 1, 1),
(2, 'main', 'Related Media', 'related_media', 7, 1),
(3, 'main', 'Top Media', 'top_media', 5, 0),
(4, 'main', 'Top Users', 'top_users', 4, 1),
(5, 'main', 'Newest Users', 'newest_users', 3, 0),
(6, 'main', 'Popular Tags', 'popular_tags', 8, 1),
(7, 'main', 'Recent Tags', 'recent_tags', 6, 0),
(8, 'profile', 'Score Box', 'score_box', 1, 1),
(9, 'profile', 'Top Users', 'top_users', 2, 1),
(10, 'profile', 'Newest Users', 'newest_users', 3, 1),
(11, 'main', 'Facebook Box', 'facebook_box', 9, 0),
(12, 'main', 'Twitter Box', 'twitter_box', 10, 0),
(13, 'profile', 'Facebook Box', 'facebook_box', 4, 1),
(14, 'profile', 'Twitter Box', 'twitter_box', 5, 0),
(15, 'main', 'Sidebar Advert', 'sidebar_advert', 2, 1),
(16, 'profile', 'Sidebar Advert', 'sidebar_advert', 4, 1),
(17, 'post', 'Site Comments', 'site_comments', 1, 1),
(18, 'post', 'FB Comments', 'fb_comments', 2, 1);
-- --------------------------------------------------------
--
-- Table structure for table `gold_categories`
--
CREATE TABLE IF NOT EXISTS `gold_categories` (
`category_id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` varchar(100) NOT NULL,
`title` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `gold_categories`
--
INSERT INTO `gold_categories` (`category_id`, `parent_id`, `title`, `name`, `status`) VALUES
(1, '', 'Images', 'images', 1),
(2, '', 'Youtube', 'youtube', 1),
(3, '', 'Vimeo', 'vimeo', 1),
(4, '', 'Vine', 'vine', 1),
(5, '', 'Dailymotion', 'dailymotion', 1),
(6, '', 'Metacafe', 'metacafe', 1),
(7, '', 'Instagram', 'instagram', 1),
(8, '', 'Facebook', 'facebook', 1),
(9, '1', 'Gif', 'gif', 1);
-- --------------------------------------------------------
--
-- Table structure for table `gold_comments`
--
CREATE TABLE IF NOT EXISTS `gold_comments` (
`comment_id` int(11) NOT NULL AUTO_INCREMENT,
`post_id` int(11) NOT NULL,
`comment_reply` int(11) NOT NULL DEFAULT '0',
`comment_author` int(11) NOT NULL DEFAULT '0',
`comment_author_ip` varchar(100) NOT NULL,
`comment_content` text NOT NULL,
`comment_date` datetime NOT NULL,
`comment_reports` int(11) NOT NULL DEFAULT '0',
`comment_status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `gold_flags`
--
CREATE TABLE IF NOT EXISTS `gold_flags` (
`flag_id` int(11) NOT NULL AUTO_INCREMENT,
`flag_type` varchar(100) NOT NULL,
`post_id` int(11) NOT NULL,
`user_ip` varchar(100) NOT NULL,
`user_id` int(11) NOT NULL,
`flag_status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`flag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `gold_groups`
--
CREATE TABLE IF NOT EXISTS `gold_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` bigint(20) NOT NULL,
`group_name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `gold_groups`
--
INSERT INTO `gold_groups` (`id`, `group_id`, `group_name`) VALUES
(1, 1, 'Administrator'),
(2, 2, 'Moderator'),
(3, 3, 'Member');
-- --------------------------------------------------------
--
-- Table structure for table `gold_levels`
--
CREATE TABLE IF NOT EXISTS `gold_levels` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level_id` bigint(20) NOT NULL,
`level_points` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `gold_levels`
--
INSERT INTO `gold_levels` (`id`, `level_id`, `level_points`) VALUES
(1, 1, 100),
(2, 2, 200),
(5, 3, 500),
(6, 4, 1000),
(7, 5, 5000);
-- --------------------------------------------------------
--
-- Table structure for table `gold_menu`
--
CREATE TABLE IF NOT EXISTS `gold_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`menu_id` varchar(100) NOT NULL,
`menu_name` text NOT NULL,
`menu_status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `gold_menu`
--
INSERT INTO `gold_menu` (`id`, `menu_id`, `menu_name`, `menu_status`) VALUES
(1, '1', 'Categories', 1),
(2, '2', 'Hot', 1),
(3, '4', 'Tags', 1),
(4, '3', 'Top_users', 1),
(5, '5', 'Pages', 1),
(6, '6', 'Feedback', 1);
-- --------------------------------------------------------
--
-- Table structure for table `gold_multiple`
--
CREATE TABLE IF NOT EXISTS `gold_multiple` (
`media_id` int(5) NOT NULL AUTO_INCREMENT,
`post_name` longtext NOT NULL,
`file_name` varchar(200) NOT NULL,
`file_size` varchar(200) NOT NULL,
`file_type` varchar(200) NOT NULL,
PRIMARY KEY (`media_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
--
-- Dumping data for table `gold_multiple`
--
INSERT INTO `gold_multiple` (`media_id`, `post_name`, `file_name`, `file_size`, `file_type`) VALUES
(1, 'georgia-photo-bundle', 'geKOLhRkuAtdoT5nX4Hbw3rClFqWmS.jpg', '124271', 'image/jpeg'),
(15, 'google-glasses', 'pB6oSH2uFE3mb0NWlQeGJ7rdYhaVsx.jpg', '228043', 'image/jpeg'),
(17, 'funny-gif-of-whiskey', 'TamrJt8jRuzD9ogLw7BYIUx23iQkq4.gif', '133787', 'image/gif'),
(18, 'best-basketballer', 'y9lXnK3ScJaOpHNTrGvqC5sh6joPIz.gif', '956279', 'image/gif'),
(19, 'funny-gif-whisky', 'mLW7FXbewzKhOa9BCI5cnA0osErY3Q.gif', '133787', 'image/gif'),
(20, 'sun-also-rises', 'WR9pd7DExSIKs20Yr4j8ZvaJGwM6bT.jpg', '118510', 'image/jpeg'),
(21, 'wall-of-art', 'bRweQNBJP4aM9Xgjzdr5l0yAFS61fK.jpg', '93291', 'image/jpeg'),
(22, 'warning-break-pen-oppp', 'PF5943gbH7deyTRuprWBtGKEOIvM8N.jpg', '255330', 'image/jpeg'),
(23, 'rescuer-dog', 'yjShprR1s8TfUn6qAm7gt0WLiY9kdO.jpg', '209783', 'image/jpeg'),
(24, 'wonderful', 't0VcKwgehCnEDfoIAQm2FbuWix1s7L.jpg', '98846', 'image/jpeg'),
(25, 'wonderful', 'x0Fz2P5LUk3tD6XmVCHa7nY9Bp4GrJ.jpg', '144066', 'image/jpeg'),
(26, 'wonderful', 'UTojMmbBG9AeSOR7pWs6taC5kgDuQq.jpg', '68358', 'image/jpeg');
-- --------------------------------------------------------
--
-- Table structure for table `gold_pages`
--
CREATE TABLE IF NOT EXISTS `gold_pages` (
`page_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) NOT NULL,
`title` varchar(500) NOT NULL,
`content` text NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `gold_pages`
--
INSERT INTO `gold_pages` (`page_id`, `name`, `title`, `content`, `status`) VALUES
(1, 'about-us', 'About us', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 1),
(2, 'feedback', 'Feedback', '<form method="post" id="contact_form" action="../gold-app/gold-includes/GOLD.php"><b class="success">Your message successfully sent!</b><p><label>Your Name <span class="req">*</span><em id="err_full_name" class="error">required</em></label><input type="text" id="full_name" name="full_name" class="text req_class"></p><p><label>Email Address <span class="req">*</span><em id="err_email" class="error">required</em></label><input type="text" id="email" name="email" class="text req_class"></p><p><label>Comments <span class="req">*</span><em id="err_comments" class="error">required</em></label><textarea id="comments" name="comments" rows="5" cols="50" class="req_class" style="outline: 0px; line-height: 25px; height: 160px; margin-top: 0px; margin-bottom: 12px;"></textarea></p> <p class="button"><input type="submit" value="Submit" name="submit_feedback" id="contact_btn" class="btn ajax_submit_btn" style="padding: 6px 20px; margin: 10px 0px;border: none;"></p></form><style>select, textarea, input[type="text"], input[type="password"], input[type="datetime"], input[type="datetime-local"], input[type="date"], input[type="month"], input[type="time"], input[type="week"], input[type="number"], input[type="email"], input[type="url"], input[type="search"], input[type="tel"], input[type="color"], .field { border: 2px solid rgb(177, 178, 179); } .wrap input:focus { border: 2px solid #EC3A39; } .wrap textarea:focus { border: 2px solid #EC3A39; }</style>', 1);
-- --------------------------------------------------------
--
-- Table structure for table `gold_plugins`
--
CREATE TABLE IF NOT EXISTS `gold_plugins` (
`plugin_id` int(11) NOT NULL AUTO_INCREMENT,
`plugin_title` varchar(1000) NOT NULL,
`plugin_position` varchar(1000) NOT NULL,
`plugin_status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`plugin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `gold_plugins`
--
INSERT INTO `gold_plugins` (`plugin_id`, `plugin_title`, `plugin_position`, `plugin_status`) VALUES
(1, 'SocialLogin', 'plugin', 1);
-- --------------------------------------------------------
--
-- Table structure for table `gold_plugins_settings`
--
CREATE TABLE IF NOT EXISTS `gold_plugins_settings` (
`set_id` int(11) NOT NULL AUTO_INCREMENT,
`plugin_name` varchar(1000) NOT NULL,
`plugin_title` varchar(1000) NOT NULL,
`set_name` varchar(1000) NOT NULL,
`set_content` text NOT NULL,
`set_status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `gold_plugins_settings`
--
INSERT INTO `gold_plugins_settings` (`set_id`, `plugin_name`, `plugin_title`, `set_name`, `set_content`, `set_status`) VALUES
(1, 'SocialLogin', 'Facebook ID', 'fb_id', '', 1),
(2, 'SocialLogin', 'Facebook Secret', 'fb_secret', '', 1),
(3, 'SocialLogin', 'Twitter Key', 'twitter_key', '', 1),
(4, 'SocialLogin', 'Twitter Secret', 'twitter_secret', '', 1),
(5, 'SocialLogin', 'Google ID', 'google_id', '', 1),
(6, 'SocialLogin', 'Google Secret', 'google_secret', '', 1),
(7, 'SocialLogin', 'LinkedIn Key', 'linkedin_key', '', 1),
(8, 'SocialLogin', 'LinkedIn Secret', 'linkedin_secret', '', 1),
(9, 'SocialLogin', 'Live ID', 'live_id', '', 1),
(10, 'SocialLogin', 'Live Secret', 'live_secret', '', 1),
(11, 'SocialLogin', 'Tumblr ID', 'tumblr_id', '', 1),
(12, 'SocialLogin', 'Tumblr Secret', 'tumblr_secret', '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `gold_posts`
--
CREATE TABLE IF NOT EXISTS `gold_posts` (
`post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`post_type` int(1) NOT NULL DEFAULT '0',
`category_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`user_ip` varchar(100) NOT NULL,
`post_views` int(10) unsigned NOT NULL DEFAULT '0',
`post_flags` tinyint(4) NOT NULL DEFAULT '0',
`post_created` datetime NOT NULL,
`post_updated` datetime NOT NULL,
`post_title` varchar(1000) NOT NULL,
`post_name` varchar(1000) NOT NULL,
`post_content` text NOT NULL,
`post_thumb` varchar(1000) NOT NULL,
`post_img` varchar(1000) NOT NULL,
`post_filename` varchar(1000) NOT NULL,
`post_tags` varchar(1000) NOT NULL,
`post_status` int(10) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`post_id`),
FULLTEXT KEY `post_title` (`post_title`,`post_content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=26 ;
--
-- Dumping data for table `gold_posts`
--
INSERT INTO `gold_posts` (`post_id`, `post_type`, `category_id`, `user_id`, `user_ip`, `post_views`, `post_flags`, `post_created`, `post_updated`, `post_title`, `post_name`, `post_content`, `post_thumb`, `post_img`, `post_filename`, `post_tags`, `post_status`) VALUES
(1, 0, 1, 1, '88.198.87.104', 818, 0, '2014-08-12 09:20:40', '2014-08-12 09:20:40', 'Girl, who dream in this road ...', 'girl-who-dream-in-this-road', 'Girl, who dream in this road ...', 'thumb_prWHewIzufgOmjMCSl3Fo8t1R95PYx.jpg', 'prWHewIzufgOmjMCSl3Fo8t1R95PYx.jpg', '', '', 1),
(2, 0, 1, 1, '88.198.87.104', 35, 0, '2014-08-14 09:53:58', '2014-08-14 09:53:58', 'Non-Famous Building', 'non-famous-building', 'Non-Famous Building ...', 'thumb_geKOLhRkuAtdoT5nX4Hbw3rClFqWmS.jpg', 'geKOLhRkuAtdoT5nX4Hbw3rClFqWmS.jpg', '', '', 1),
(3, 1, 3, 1, '88.198.87.104', 10, 0, '2014-08-26 05:37:37', '2014-08-26 05:37:37', '8 Hours in Brooklyn', '8-hours-in-brooklyn', '8 Hours in Brooklyn is comprised of footage from a high-speed camera, all shot within an eight hour span in Brooklyn, New York. The high-speed footage and the awesome camera work lets us slow down a city that''s known for its fast-paced lifestyle. Suddenly, things like shooting hoops and riding your board add much to the beauty of the borough.', 'http://i.vimeocdn.com/video/180844662_200x150.jpg', 'http://i.vimeocdn.com/video/180844662_200x150.jpg', 'http://vimeo.com/27260633', '', 1),
(4, 1, 8, 1, '88.198.87.104', 16, 0, '2014-08-26 05:46:38', '2014-08-26 05:46:38', 'Wow looks so real!!!', 'wow-looks-so-real', '', 'http://graph.facebook.com/449819958494073/picture', 'http://graph.facebook.com/449819958494073/picture', 'https://www.facebook.com/photo.php?v=449819958494073&set=vb.216492975160107&type=2&theater', '', 1),
(5, 1, 4, 1, '88.198.87.104', 11, 0, '2014-08-26 06:23:55', '2014-08-26 06:23:55', 'We''re test-driving MaverX electric skateboard. Whee!', 'we-re-test-driving-maverx-electric-skateboard-whee', '', 'https://v.cdn.vine.co/r/thumbs/2C9422D0431037801323573522432_1e3d740f337.4.7.17282528638514921040.mp4_psJr.ANHRCyJ709vPznndyTA5e4B2AZu9S3vtGZIKXWleCWOEzBNzmXK.BsuJmZi.jpg?versionId=.sAf4g7qlwTwu10gbg.JldP4urMSea53', 'https://v.cdn.vine.co/r/thumbs/2C9422D0431037801323573522432_1e3d740f337.4.7.17282528638514921040.mp4_psJr.ANHRCyJ709vPznndyTA5e4B2AZu9S3vtGZIKXWleCWOEzBNzmXK.BsuJmZi.jpg?versionId=.sAf4g7qlwTwu10gbg.JldP4urMSea53', 'https://vine.co/v/MBeZaPZ0m6X', '', 1),
(6, 1, 5, 1, '88.198.87.104', 7, 0, '2014-08-26 06:46:46', '2014-08-26 06:46:46', 'Emmys – 5 Things to Look Forward To', 'emmys-ndash-5-things-to-look-forward-to', '', 'http://www.dailymotion.com/thumbnail/video/x24bwg1_emmys-5-things-to-look-forward-to_news', 'http://www.dailymotion.com/thumbnail/video/x24bwg1_emmys-5-things-to-look-forward-to_news', 'http://www.dailymotion.com/video/x24bwg1_emmys-5-things-to-look-forward-to_news', '', 1),
(17, 1, 6, 1, '88.198.87.104', 16, 0, '2014-08-26 07:01:11', '2014-08-26 07:01:11', 'Get the Most out of Your Nexus 7', 'get-the-most-out-of-your-nexus-7', '', 'http://s4.mcstatic.com/thumb/9821764/0/6/videos/0/6/ipad_5_and_the_next_nexus_7_technobuffalo.jpg', 'http://s4.mcstatic.com/thumb/9821764/0/6/videos/0/6/ipad_5_and_the_next_nexus_7_technobuffalo.jpg', 'http://www.metacafe.com/watch/9821764/ipad_5_and_the_next_nexus_7_technobuffalo/', '', 1),
(8, 1, 7, 1, '88.198.87.104', 64, 0, '2014-08-26 07:07:27', '2014-08-26 07:07:27', 'If I had not auditioned for a little off-Broadway show called Rent, then I would not be in If/Then today', 'if-i-had-not-auditioned-for-a-little-off-broadway-show-called-rent-then-i-would-not-be-in-if-then-today', '', 'http://instagr.am/p/ns8zAttQDy/media/', 'http://instagr.am/p/ns8zAttQDy/media/', 'http://instagram.com/p/ns8zAttQDy/', '', 1),
(10, 1, 5, 1, '88.198.87.104', 5, 0, '2014-09-03 08:28:49', '2014-09-03 08:28:49', 'The Penguins of Madagascar - Trailer', 'the-penguins-of-madagascar-trailer', '', 'http://www.dailymotion.com/thumbnail/video/x23llt5_the-penguins-of-madagascar-trailer-2-vo-hd_shortfilms', 'http://www.dailymotion.com/thumbnail/video/x23llt5_the-penguins-of-madagascar-trailer-2-vo-hd_shortfilms', 'http://www.dailymotion.com/video/x23llt5_the-penguins-of-madagascar-trailer-2-vo-hd_shortfilms', '', 1),
(11, 1, 5, 1, '88.198.87.104', 60, 0, '2014-09-03 08:32:51', '2014-09-03 08:32:51', 'The SpongeBob Movie: Sponge Out of Water - Trailer', 'the-spongebob-movie-sponge-out-of-water-trailer', '', 'http://www.dailymotion.com/thumbnail/video/x22jphv_the-spongebob-movie-sponge-out-of-water-trailer-1-vo-hd_shortfilms', 'http://www.dailymotion.com/thumbnail/video/x22jphv_the-spongebob-movie-sponge-out-of-water-trailer-1-vo-hd_shortfilms', 'http://www.dailymotion.com/video/x22jphv_the-spongebob-movie-sponge-out-of-water-trailer-1-vo-hd_shortfilms', '', 1),
(12, 1, 5, 1, '88.198.87.104', 4, 0, '2014-09-03 08:45:42', '2014-09-03 08:45:42', 'Untitled Planet of the Apes Sequel', 'untitled-planet-of-the-apes-sequel', '', 'http://www.dailymotion.com/thumbnail/video/x1ztswx_la-planete-des-singes-l-affrontement-bande-annonce-finale-vf-hd_shortfilms', 'http://www.dailymotion.com/thumbnail/video/x1ztswx_la-planete-des-singes-l-affrontement-bande-annonce-finale-vf-hd_shortfilms', 'http://www.dailymotion.com/video/x1ztswx_la-planete-des-singes-l-affrontement-bande-annonce-finale-vf-hd_shortfilms', '', 1),
(14, 1, 5, 1, '88.198.87.104', 28, 0, '2014-09-03 08:48:37', '2014-09-03 08:48:37', 'Transformers: Age of Extinction - International Trailer', 'transformers-age-of-extinction-international-trailer', '', 'http://www.dailymotion.com/thumbnail/video/x1yq0g8_transformers-age-of-extinction-international-trailer-2-ru-hd_shortfilms', 'http://www.dailymotion.com/thumbnail/video/x1yq0g8_transformers-age-of-extinction-international-trailer-2-ru-hd_shortfilms', 'http://www.dailymotion.com/video/x1yq0g8_transformers-age-of-extinction-international-trailer-2-ru-hd_shortfilms', '', 1),
(15, 1, 5, 1, '88.198.87.104', 19, 0, '2014-09-03 08:53:25', '2014-09-03 08:53:25', 'Hercule - Bande Annonce Trailer', 'hercule-bande-annonce-trailer', '', 'http://www.dailymotion.com/thumbnail/video/x1r0rbz_hercule-bande-annonce-1-vf-hd_shortfilms', 'http://www.dailymotion.com/thumbnail/video/x1r0rbz_hercule-bande-annonce-1-vf-hd_shortfilms', 'http://www.dailymotion.com/video/x1r0rbz_hercule-bande-annonce-1-vf-hd_shortfilms', '', 1),
(22, 1, 5, 1, '88.198.87.104', 48, 0, '2014-09-03 08:55:37', '2014-09-03 08:55:37', 'Jupiter Ascending - Trailer', 'jupiter-ascending-trailer', '', 'http://www.dailymotion.com/thumbnail/video/x1jx8kl_jupiter-ascending-trailer-2-vo-hd_shortfilms', 'http://www.dailymotion.com/thumbnail/video/x1jx8kl_jupiter-ascending-trailer-2-vo-hd_shortfilms', 'http://www.dailymotion.com/video/x1jx8kl_jupiter-ascending-trailer-2-vo-hd_shortfilms', '', 1),
(16, 1, 5, 1, '88.198.87.104', 188, 0, '2014-09-03 08:56:19', '2014-09-03 08:56:19', 'Planes: Fire & Rescue - Trailer', 'planes-fire-amp-rescue-trailer', '', 'http://www.dailymotion.com/thumbnail/video/x1mvqnh_planes-fire-rescue-trailer-2-vo-hd_shortfilms', 'http://www.dailymotion.com/thumbnail/video/x1mvqnh_planes-fire-rescue-trailer-2-vo-hd_shortfilms', 'http://www.dailymotion.com/video/x1mvqnh_planes-fire-rescue-trailer-2-vo-hd_shortfilms', '', 1),
(25, 0, 1, 1, '88.198.87.104', 8, 0, '2014-09-21 04:37:01', '2014-09-21 04:37:01', 'Rescuer Dog', 'rescuer-dog', 'I can help you ...', 'thumb_yjShprR1s8TfUn6qAm7gt0WLiY9kdO.jpg', 'yjShprR1s8TfUn6qAm7gt0WLiY9kdO.jpg', '', '', 1),
(7, 0, 1, 1, '88.198.87.104', 6, 0, '2014-09-20 22:30:45', '2014-09-20 22:30:45', 'Google Glasses', 'google-glasses', 'Interesting Side of See', 'thumb_pB6oSH2uFE3mb0NWlQeGJ7rdYhaVsx.jpg', 'pB6oSH2uFE3mb0NWlQeGJ7rdYhaVsx.jpg', '', '', 1),
(24, 0, 1, 1, '88.198.87.104', 5, 0, '2014-09-21 04:35:40', '2014-09-21 04:35:40', 'Warning! Break Pen! OPPP ...', 'warning-break-pen-oppp', 'Warning! Break Pen! OPPP ...', 'thumb_PF5943gbH7deyTRuprWBtGKEOIvM8N.jpg', 'PF5943gbH7deyTRuprWBtGKEOIvM8N.jpg', '', '', 1),
(18, 0, 9, 1, '88.198.87.104', 5, 0, '2014-09-21 04:12:19', '2014-09-21 04:12:19', 'Football Funny Moment', 'football-funny-moment', '', 'thumb_V2ibD0kvnYer3sGKLaOFScxlBUyIXf.gif', 'V2ibD0kvnYer3sGKLaOFScxlBUyIXf.gif', '', '', 1),
(19, 0, 9, 1, '88.198.87.104', 4, 0, '2014-09-21 04:17:03', '2014-09-21 04:17:03', 'Best Basketballer', 'best-basketballer', '', 'thumb_y9lXnK3ScJaOpHNTrGvqC5sh6joPIz.gif', 'y9lXnK3ScJaOpHNTrGvqC5sh6joPIz.gif', '', '', 1),
(20, 0, 1, 1, '88.198.87.104', 2, 0, '2014-09-21 04:18:46', '2014-09-21 04:18:46', 'Funny Gif Whisky', 'funny-gif-whisky', 'Cool!', 'thumb_mLW7FXbewzKhOa9BCI5cnA0osErY3Q.gif', 'mLW7FXbewzKhOa9BCI5cnA0osErY3Q.gif', '', '', 1),
(21, 0, 1, 1, '88.198.87.104', 5, 0, '2014-09-21 04:25:45', '2014-09-21 04:25:45', 'Sun Also Rises', 'sun-also-rises', '', 'thumb_WR9pd7DExSIKs20Yr4j8ZvaJGwM6bT.jpg', 'WR9pd7DExSIKs20Yr4j8ZvaJGwM6bT.jpg', '', '', 1),
(23, 0, 1, 1, '88.198.87.104', 6, 0, '2014-09-21 04:27:47', '2014-09-21 04:27:47', 'Wall of Art', 'wall-of-art', '', 'thumb_bRweQNBJP4aM9Xgjzdr5l0yAFS61fK.jpg', 'bRweQNBJP4aM9Xgjzdr5l0yAFS61fK.jpg', '', '', 1),
(13, 0, 1, 1, '88.198.87.104', 14, 0, '2014-09-21 05:00:42', '2014-09-21 05:00:42', 'Wonderful', 'wonderful', '', 'thumb_t0VcKwgehCnEDfoIAQm2FbuWix1s7L.jpg', 't0VcKwgehCnEDfoIAQm2FbuWix1s7L.jpg', '', '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `gold_settings`
--
CREATE TABLE IF NOT EXISTS `gold_settings` (
`set_id` int(11) NOT NULL AUTO_INCREMENT,
`set_name` varchar(1000) NOT NULL,
`set_content` text NOT NULL,
PRIMARY KEY (`set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
--
-- Dumping data for table `gold_settings`
--
INSERT INTO `gold_settings` (`set_id`, `set_name`, `set_content`) VALUES
(1, 'gold_email', 'info@themesgold.com'),
(2, 'gold_rows', '30'),
(3, 'gold_logo', 'logo.png'),
(4, 'gold_email_template_register_title', 'Registration'),
(5, "gold_email_template_register", ''),
(6, 'gold_email_template_forgot_title', 'Forgot Password'),
(7, "gold_email_template_forgot", ''),
(8, 'gold_website_title', 'Gold MEDIA'),
(9, 'gold_website_description', 'Gold MEDIA - SHARE MEDIA SCRIPT'),
(10, 'gold_website_keywords', 'Gold MEDIA, Gold, Media, Share Media Script, Share Media, MEDIA SCRIPT'),
(11, 'gold_max_related_media', '10'),
(12, 'gold_max_tags', '20'),
(13, 'gold_skin', 'default'),
(14, 'gold_lang', 'en'),
(15, 'points_posting_a_media', '2'),
(16, 'points_per_up_vote_on_your_media', '1'),
(17, 'points_per_down_vote_on_your_media', '1'),
(18, 'points_posting_a_comment', '4'),
(19, 'points_per_up_vote_on_your_comment', '2'),
(20, 'points_per_down_vote_on_your_comment', '2'),
(21, 'points_voting_up_a_media', '1'),
(22, 'points_voting_down_a_media', '1'),
(23, 'points_voting_up_a_comment', '1'),
(24, 'points_voting_down_a_comment', '1'),
(25, 'points_add_for_all_users', '100'),
(26, 'points_add_for_every_login', '5');
-- --------------------------------------------------------
--
-- Table structure for table `gold_tags`
--
CREATE TABLE IF NOT EXISTS `gold_tags` (
`tag_id` int(11) NOT NULL AUTO_INCREMENT,
`tag_name` varchar(100) NOT NULL,
`post_id` int(11) NOT NULL,
PRIMARY KEY (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=64 ;
--
-- Dumping data for table `gold_tags`
--
INSERT INTO `gold_tags` (`tag_id`, `tag_name`, `post_id`) VALUES
(1, 'Dailymotion', 10),
(2, ' The Penguins', 10),
(3, ' Penguins of Madagascar', 10),
(4, ' Trailer', 10),
(5, 'Dailymotion', 11),
(6, ' The SpongeBob Movie', 11),
(7, ' Sponge Out of Water', 11),
(8, ' Trailer', 11),
(9, 'Untitled Planet of the Apes Sequel', 12),
(10, 'Transformers: Age of Extinction - International Trailer', 12),
(11, ' Trailer', 12),
(12, 'Dailymotion', 13),
(13, ' Bande Announce', 14),
(14, ' Hercule', 14),
(15, ' Trailer', 14),
(16, 'Dailymotion', 15),
(17, ' Trailer', 15),
(18, ' Jupiter Ascending', 15),
(19, 'Dailymotion', 16),
(20, ' Trailer', 16),
(21, ' Planes', 16),
(22, ' Fire & Rescue', 16),
(23, 'Dailymotion', 17),
(24, ' Trailer', 17),
(25, ' A Million Ways To Die In The West', 17),
(26, ' Jupiter Ascending', 18),
(27, ' ', 18),
(28, 'Glasses', 19),
(29, ' Google', 19),
(30, ' Funny', 19),
(31, ' Abstract', 19),
(32, 'Mr. Bean', 20),
(33, ' Launch', 20),
(34, ' Funny Gif', 20),
(35, 'Funny', 22),
(36, ' Football Moment', 22),
(37, ' Moment', 22),
(38, 'Funny', 23),
(39, ' Sports', 23),
(40, ' Men', 23),
(41, 'Funny', 24),
(42, ' Best', 24),
(43, ' Basketballer', 24),
(44, 'Funny', 25),
(45, ' Gif', 25),
(46, ' Whiskey', 25),
(47, ' Best', 25),
(48, 'Funny', 25),
(49, ' Gif', 25),
(50, ' Whiskey', 25),
(51, ' Best', 25),
(52, 'Sun', 26),
(53, ' Rise', 26),
(54, ' Images', 26),
(55, 'Wall of Art', 27),
(56, ' Art', 27),
(57, ' Wall', 27),
(58, 'Warning', 28),
(59, ' Pen', 28),
(60, 'Rescuer Dog', 29),
(61, ' Dog', 29),
(62, 'Wonderful', 25),
(63, 'Super Yigma Mahnilar 2014', 241);
-- --------------------------------------------------------
--
-- Table structure for table `gold_users`
--
CREATE TABLE IF NOT EXISTS `gold_users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_type` varchar(100) NOT NULL DEFAULT '',
`user_identifier` varchar(100) NOT NULL,
`user_loggedin` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_login_ip` varchar(100) NOT NULL,
`user_confirmation_code` varchar(100) CHARACTER SET ascii NOT NULL,
`user_active` int(1) NOT NULL DEFAULT '1',
`user_created` datetime NOT NULL,
`user_create_ip` varchar(100) NOT NULL,
`user_username` varchar(500) NOT NULL,
`user_fullname` varchar(500) NOT NULL,
`user_email` varchar(500) NOT NULL,
`user_password` varchar(100) NOT NULL,
`user_location` varchar(100) NOT NULL,
`user_website` varchar(100) NOT NULL,
`user_about` text NOT NULL,
`user_avatar` varchar(500) NOT NULL DEFAULT 'avatar.png',
`user_cover` varchar(1000) NOT NULL DEFAULT 'default.jpg',
`user_points` varchar(5000) NOT NULL DEFAULT '0',
`user_group` enum('1','2','3') NOT NULL DEFAULT '3',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `gold_users`
--
INSERT INTO `gold_users` (`user_id`, `user_type`, `user_identifier`, `user_loggedin`, `user_login_ip`, `user_confirmation_code`, `user_active`, `user_created`, `user_create_ip`, `user_username`, `user_fullname`, `user_email`, `user_password`, `user_location`, `user_website`, `user_about`, `user_avatar`, `user_cover`, `user_points`, `user_group`) VALUES
(1, '', '', '2014-09-21 05:13:12', '0', '', 1, '2014-09-01 13:36:38', '0', 'admin', 'Admin Fullname', 'info@themesgold.com', '5bc1da026c2f35564589c73108808c84', 'USA', '', 'I am web-developer.', 'avatar.png', 'default.jpg', '0', '1'),
(2, '', '', '2014-09-21 05:12:51', '0', '', 1, '2014-09-20 21:38:17', '0', 'john', 'John Piterson', 'john@site.com', '5bc1da026c2f35564589c73108808c84', 'USA', 'http://Piterson.com', 'I am Piterson ! People!', 'avatar.png', 'default.jpg', '179', '3');
-- --------------------------------------------------------
--
-- Table structure for table `gold_votes`
--
CREATE TABLE IF NOT EXISTS `gold_votes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vote_type` varchar(100) NOT NULL,
`post_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `gold_widgets`
--
CREATE TABLE IF NOT EXISTS `gold_widgets` (
`widget_id` int(11) NOT NULL AUTO_INCREMENT,
`widget_title` varchar(500) NOT NULL,
`widget_status` int(1) NOT NULL DEFAULT '1',
`widget_code` text NOT NULL,
PRIMARY KEY (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `gold_widgets`
--
INSERT INTO `gold_widgets` (`widget_id`, `widget_title`, `widget_status`, `widget_code`) VALUES
(1, 'CenterAdvert', 1, ''),
(2, 'SidebarAdvert', 1, ''),
(3, 'PostAdvert', 1, ''),
(4, 'FacebookBox', 1, 'https://www.facebook.com/envato'),
(5, 'TwitterBox', 1, 'https://twitter.com/envato');
/*!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 */;