-- phpMyAdmin SQL Dump
-- version 4.4.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 23, 2015 at 04:51 PM
-- Server version: 5.6.25
-- PHP Version: 5.6.11

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 utf8mb4 */;

--
-- Database: `fbquiz`
--

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

--
-- Table structure for table `email_settings`
--

CREATE TABLE IF NOT EXISTS `email_settings` (
  `id` int(11) NOT NULL,
  `email_address` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `smtp_address` varchar(200) NOT NULL,
  `port` varchar(10) NOT NULL,
  `driver` varchar(40) NOT NULL,
  `sender_email` varchar(200) NOT NULL,
  `sender_name` varchar(100) NOT NULL,
  `signup_text` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` (`id`, `email_address`, `password`, `smtp_address`, `port`, `driver`, `sender_email`, `sender_name`, `signup_text`) VALUES
(1, 'sales@vinnorokom.com', 'Sales12!@', 'smtp.arirah.com', '587', 'smtp', 'sales@vinnorokom.com', 'Vinnorokom', 'Hello  {name} , <br>\r\nYour account has been created successfully ! <br>\r\n\r\nThanks <br>\r\nMail sent from <br>\r\n{url}');

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

--
-- Table structure for table `media_files`
--

CREATE TABLE IF NOT EXISTS `media_files` (
  `file_id` int(11) NOT NULL,
  `file_name` varchar(400) NOT NULL,
  `file_type` varchar(30) NOT NULL,
  `uploaded_at` datetime NOT NULL,
  `uploaded_by` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `media_files`
--

INSERT INTO `media_files` (`file_id`, `file_name`, `file_type`, `uploaded_at`, `uploaded_by`) VALUES
(61, 'facebook-boost-ad.png', 'image/png', '2015-06-02 23:54:00', 6),
(62, 'viral-marketing.png', 'image/png', '2015-06-02 23:57:00', 6),
(63, 'promot.png', 'image/png', '2015-06-02 23:57:00', 6),
(64, 'post.jpg', 'image/jpeg', '2015-06-02 23:57:00', 6),
(65, 'banner590x300.png', 'image/png', '2015-06-02 23:58:00', 6),
(66, 'slider.png', 'image/png', '2015-06-03 00:01:00', 6),
(67, 'slider1.png', 'image/png', '2015-06-03 00:02:00', 6),
(68, 'hrithik-roshan-sexy-photos-0158.jpg', 'image/jpeg', '2015-09-23 01:37:00', 6);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2014_06_20_205603_create_fb', 1),
('2015_02_14_070603_table', 2);

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL,
  `fbid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `gender` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_level` tinyint(4) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=721 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `users` (`id`, `fbid`, `password`, `name`, `remember_token`, `email`, `gender`, `created_at`, `updated_at`, `user_level`, `status`) VALUES
(6, '4', '$2y$08$HUsVX5XNPzCQeGfjLg97Mu6sCOpSRhEzQrnQdRTTLBJD0a.O99sWe', 'admin', '9L6Xjc6rDFtES7LtmrUqDG6Nv04rDhzOwCyuoxOYkYphDrli8NQapiwpkyUO', 'admin@admin.com', '', '2015-09-23 14:49:20', '2015-09-23 14:49:20', 1, 1),
(720, '1516190378', '', 'Ari Rah', '', 'hmarifur@gmail.com', 'male', '2015-09-23 14:49:50', '2015-09-23 14:49:50', 0, 1);

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

--
-- Table structure for table `user_pages`
--

CREATE TABLE IF NOT EXISTS `user_pages` (
  `page_id` int(11) NOT NULL,
  `page_name` varchar(500) NOT NULL,
  `slug` varchar(500) NOT NULL,
  `content` text NOT NULL,
  `page_type` int(11) NOT NULL DEFAULT '0' COMMENT '1-Page , 2-Blog',
  `added_to` int(11) NOT NULL DEFAULT '0' COMMENT '1-Navbar  ,2- Sub menu page',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `featured_image` varchar(500) NOT NULL,
  `is_featured` int(11) NOT NULL DEFAULT '0',
  `published` int(11) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_pages`
--

INSERT INTO `user_pages` (`page_id`, `page_name`, `slug`, `content`, `page_type`, `added_to`, `parent_id`, `featured_image`, `is_featured`, `published`, `created_at`) VALUES
(21, 'Blog', 'blog', '', 1, 1, 0, '', 0, 1, '2015-05-01 00:00:00'),
(22, 'How to generate highly potential traffic in the viral way', 'how-to-generate-highly-potential-traffic-in-the-viral-way', '<p>If you are really worried about how to generate potential traffic to your website, this article should help&nbsp; you to kick the worry out from your shoulder.</p>\r\n<p>Are you thinking on how is it possible right ? <img class="wp-smiley" src="http://www.vinnorokom.com/wp-includes/images/smilies/icon_wink.gif" alt=";)" /> let me bring you to the point.</p>\r\n<p>Now&nbsp; a days , people try hundred of ways to generate potential traffic to the website .</p>\r\n<p>Facebook paying Ad and Google adsense are the most popular marketing systems out of all. But the fact is that you will have to pay to run one of them for per click or per website visit.</p>\r\n<p>Because of so called user activities of&nbsp; Facebook, it is sometime boring to the people.&nbsp; People like to make fun as well as to know the unknown things.</p>\r\n<p>Now let&rsquo;s come to the solution !!</p>\r\n<p>If you run some fan making stuff such as quiz, funny quiz, some interesting survey that would be more interesting to the people than any other so called facebook activities.</p>\r\n<p>Are you able to install a simple quiz script to your website?</p>\r\n<p>If your answer is yes, let me explain how <img class="wp-smiley" src="http://www.vinnorokom.com/wp-includes/images/smilies/icon_smile.gif" alt=":)" /> .</p>\r\n<p>If you have a small local business and you have a restaurant or fast food shop, you can install such simple quiz script to your website. Now I am gonna show you some example quiz which you can run.</p>\r\n<ol>\r\n<li>Where is the busiest McDonald in the world?</li>\r\n<li>Munich</li>\r\n<li>Tokyo</li>\r\n<li>New York</li>\r\n<li>Toronto</li>\r\n<li>Which food contains natural antibiotic?</li>\r\n<li>Water</li>\r\n<li>Honey</li>\r\n<li>Carrot</li>\r\n<li>Kiwi</li>\r\n</ol>\r\n<p>Waw looking interesting?It sounds great right? Yes you can install ans set up some quiz on your website and run it in your facebook.</p>\r\n<p>Tips: A simple tip what i can suggest you to make quiz is just make some google search funny quistions to the google.com and set them up to your quiz group. Or think a few minutes you can make it yourself also.</p>\r\n<p>Now your next question should be like</p>\r\n<ol>\r\n<li>Which quiz application should I install?</li>\r\n<li>Is it easy to install?</li>\r\n<li>Does&nbsp; it have a proper support?</li>\r\n<li>Does it have a demo quiz?</li>\r\n<li>Does it have a step by step installation quid line?</li>\r\n<li>How the Quiz app goes viral?</li>\r\n<li>How does it bring a potential traffic to my website?</li>\r\n<li>Does it help to generate potential lead or user base?</li>\r\n</ol>\r\n<p>Answers:</p>\r\n<ol>\r\n<li>Which quiz application should I install?</li>\r\n</ol>\r\n<p>I can suggest <a href="http://codecanyon.net/item/vinnorokom-facebook-quiz-viral-app/10869572">vonnorokom viral facebook marketing quiz app</a>, a <a href="http://codecanyon.net/item/vinnorokom-facebook-quiz-viral-app/10869572">simple facebook viral marketing quiz application.</a></p>\r\n<ol start="2">\r\n<li>Is it easy to install?</li>\r\n</ol>\r\n<p>Yes. It is very easy</p>\r\n<p>The main app page will give you all information and answers please <a href="http://codecanyon.net/item/vinnorokom-facebook-quiz-viral-app/10869572">click here</a></p>\r\n<p>Hope the article will help you to recognize the right way to your website marketing.</p>', 1, 2, 21, 'http://quiz2.vinnorokom.com/public/media/slider1.png', 0, 1, '2015-05-01 00:00:00'),
(23, 'Quiz Viral Marketing Idea ', 'quiz-viral-marketing-idea-', '<p>Do you like an online marketing app for your small business?</p>\r\n<p>Do you think that your business should be dynamic?</p>\r\n<p>Do you think about the revenue of your business might be boosted?</p>\r\n<p>Have you ever thought about your website could have a milion of potential traffic?</p>\r\n<p>We have some exciting answer and solution for you here.</p>\r\n<p>You may run some funny app over your website for example quiz application. there are a lot of quiz application over facebook.</p>\r\n<p>Do you know why?</p>\r\n<p>With the development of facebook and it&acute;s milions of traffic, people some time become boared due to it&acute;s so called news feed,chatting tagging and so and so. Therefore they seek for some funny stuff or application to play and share with his/her friends.</p>\r\n<p>If you are someone who can make a custom and very interesting&nbsp; quiz and run it over your website , you are definitly going to receive a lot of traffic every day. People will play quizzes and share it to the facebook and the more people from facebook will return to your website to play the quizzes to get more point than others.</p>\r\n<p>Do you wanna make a contact base of potential traffic?</p>\r\n<p>We experienced a lot of funny app over internet. Some of them are really very cool, some of them are really difficult to get it to understand.</p>\r\n<p>We can tell you about such a funny quiz application which deals with some awesome feature overthere.</p>\r\n<h2>What is <a href="http://codecanyon.net/item/vinnorokom-facebook-quiz-viral-app/10869572"><em><strong>vinnorokom facebook viral app</strong></em></a>?</h2>\r\n<p>Its a app which can bring a solution of all of your burning questions and discussions above.</p>\r\n<p>The conditional login system of <strong><a href="http://codecanyon.net/item/vinnorokom-facebook-quiz-viral-app/10869572">vinnorokom facebook viral app</a></strong> with&nbsp; facebook login system brings you contactbase of potential traffic.</p>\r\n<p>Wanna have a details about the app?</p>\r\n<p>Follow the link here:</p>\r\n<h2><strong><a href="http://shakileee.tumblr.com/post/115124631690/do-you-like-a-online-marketing-app-for-your-small">Vinnorokom facebook viral app</a></strong></h2>\r\n<h2><strong>See Demo Link below:</strong></h2>\r\n<p>Website : <a href="../">http://quiz.vinnorokom.com</a><br />Admin Demo : <a href="../admin-login">http://quiz.vinnorokom.com/admin-login</a><br />Admin user : <a href="mailto:admin@admin.com">admin@admin.com</a><br />Pass : 12345678</p>', 2, 2, 21, 'http://quiz.vinnorokom.com/public/media/tablte.jpg', 1, 1, '2015-05-01 00:00:00'),
(32, 'How to make a poll interesting and viral', 'how-to-make-a-poll-interesting-and-viral', '<p>Hi guys in our last article we discussed on <a href="http://www.vinnorokom.com/how-to-make-a-poll-ineresting-and-viral/">How to generate highly potential traffic in the viral way</a>.<br /><br />Definitely that article was in term of facebook quiz application I mean how to generate potential traffic implementing a facebook quiz application and I also suggested<a href="http://codecanyon.net/item/vinnorokom-facebook-quiz-and-poll-viral-app/10869572"> vinnorokom facebook viral quiz apps.</a><br /><br />Today we are going to discuss on how to make a poll viral or what is poll marketing.<br /><br />Well, now days, one of the most sounded phrases over internet is viral marketing and how to make a thing viral. Poll is however, such a tool which can easily get a solution to your problem on era of viral marketing.<br /><br />If you have facebook then you might saw that many people are playing poll or performing online voting on a lot of interesting things. And they are really viral having millions of traffic. However, a question definitely comes to the mind is that what is the benefit or outcome of playing poll?<br /><br />The answer is SIMPLE!!<br /><br />People and owner of the poll both are benefited in that case. Are you thinking about how that is?<br /><br />Well, People are playing poll to know about what people think about the interesting poll. People play poll provide vote and share it on social media. People have fun on it and that is the benefit of user.<br /><br />Owner of the poll is also benefited on the other way. The poll owners are getting benefit in two ways.<br /><br />Firstly, if the owner has a website containing lots of interesting, intriguing, fascinating poll, people definitely will come to the website repeatedly to play the polls. Due to the viral characteristic of the poll play and sharing system, the potential traffic will increase in the exponent<br /><br />Secondly, if the poll has facebook login system, there will be a high probability of getting a list of user information i.e email, profile, mobile number etc. which will be used for the further email marketing.<br /><br />Now you can naturally ask us that how is it possible to make a poll interesting, fascinating, and intriguing?<br /><br />Let&rsquo;s come to the point, if you want to make a interesting and effective poll and trying to attract potential traffic to you poll, if you are very targeted audience oriented, I am recommending you to select some highly targeted poll title or question. For instance,<br /><br />If you have a restaurant business you may select the poll title or question like<br /><br />``What you usually eat as a breakfast?`` The options would be<br /><br />1. Cold cereal<br /><br />2. Hot cereal<br /><br />3. Bacon and eggs<br /><br />4. Eggs<br /><br />5. Bacon<br /><br />6. Ham and eggs<br /><br />7. Toast<br /><br />8. Bagel<br /><br />9. French toast<br /><br />10. Muffins<br /><br />11. Other pastry<br /><br />12. Pancakes<br /><br />13. Waffles<br /><br />14. Fruit<br /><br />15. Banana(s)<br /><br />16. Orange(s) *<br /><br />17. Yogurt<br /><br />18. Smoothie<br /><br />19. Variety of things<br /><br />20. Other<br /><br />21. No opinion.<br /><br />One more example<br /><br />``Have you ever had cold pizza in the breakfast?`` the options could be<br /><br />Yes. B. Never and C. No opinion<br /><br /><br /><br />If you have real-estate business, you may choose the questions like<br /><br />``Do the Real-Estate companies workable for you?`` the options or answers should be like<br /><br />Yes&nbsp; B. No. C. I have my own house.<br /><br />If you have Health care or weight loss business, you can commission the poll title in the following way:<br /><br />```What are the most effective way to weight loss?` the option should be<br /><br />Go walking regularly<br /><br />Avoid all fatty food.<br /><br />Do not take fast/junk food.<br /><br />Have physical exercise regular basis.<br /><br />If you have Website marketing provider, then following thing suits you.<br /><br />`` Which is the best way for you to get potential traffic?``<br /><br />Social Media Marketing (SMM).<br /><br />Search Engine Optimization (SEO).<br /><br />Search Engine Marketing.<br /><br />Only Facebook marketing.<br /><br />We may recommend you a quiz and poll application: vinnorokom viral marketing poll and quiz apps.<br /><br />Hope the article will helps you in decision making for launching a poll and quiz website.<br /><br /><br /><br />Vinnorokom Team</p>', 2, 2, 21, 'http://quiz.vinnorokom.com/public/media/post.jpg', 1, 1, '2015-05-02 00:00:00'),
(33, 'New idea about Viral Marketing Application', 'new-idea-about-viral-marketing-application', '<p>Vinnorokom team announced new version of Vinnorokom Quiz Facebook Viral app .&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>New version V.2.0.0 is released with lots of features &nbsp;, Main key features are given below :</p>\r\n<ul>\r\n<li>Poll and voting&nbsp;</li>\r\n<li>User can vote and share every poll via facebook&nbsp;</li>\r\n<li>User profile upgraded&nbsp;</li>\r\n<li>User can play multiple quiz group</li>\r\n<li>Quiz app and poll pages are now full web page view&nbsp;</li>\r\n<li>Pages are more functional</li>\r\n<li>Improve page perfomance by Ajax loading&nbsp;</li>\r\n</ul>\r\n<p><strong>Admin panel is now more power full with lots of tools</strong></p>\r\n<ul>\r\n<li>Poll add remove functions</li>\r\n<li>Facebook Share Opengraph image change option</li>\r\n<li>Quiz result text share option is more customizable</li>\r\n<li>Media file archive with uploader</li>\r\n<li>Page / Blog option added</li>\r\n<li>Global page setting upgraded</li>\r\n<li>Home page Slider image change option</li>\r\n<li>Advertisment image and link added option</li>\r\n</ul>\r\n<p>&nbsp;</p>', 2, 2, 21, 'http://quiz.vinnorokom.com/public/media/seo-758264_1280.jpg', 1, 1, '2015-05-02 00:00:00'),
(34, 'Vinnorokom Quiz App V.2.0.0 Released ', 'vinnorokom-quiz-app-v200-released-', '<p>Vinnorokom team announced new version of Vinnorokom Quiz Facebook Viral app .&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>New version V.2.0.0 is released with lots of features &nbsp;, Main key features are given below :</p>\r\n<ul>\r\n<li>Poll and voting&nbsp;</li>\r\n<li>User can vote and share every poll via facebook&nbsp;</li>\r\n<li>User profile upgraded&nbsp;</li>\r\n<li>User can play multiple quiz group</li>\r\n<li>Quiz app and poll pages are now full web page view&nbsp;</li>\r\n<li>Pages are more functional</li>\r\n<li>Improve page perfomance by Ajax loading&nbsp;</li>\r\n</ul>\r\n<p><strong>Admin panel is now more power full with lots of tools</strong></p>\r\n<ul>\r\n<li>Poll add remove functions</li>\r\n<li>Facebook Share Opengraph image change option</li>\r\n<li>Quiz result text share option is more customizable</li>\r\n<li>Media file archive with uploader</li>\r\n<li>Page / Blog option added</li>\r\n<li>Global page setting upgraded</li>\r\n<li>Home page Slider image change option</li>\r\n<li>Advertisment image and link added option</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>', 2, 0, 21, 'http://quiz.vinnorokom.com/public/media/smartphoddd1920.jpg', 1, 1, '2015-05-02 00:00:00');

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

--
-- Table structure for table `user_page_setting`
--

CREATE TABLE IF NOT EXISTS `user_page_setting` (
  `page_id` int(11) NOT NULL,
  `header_image` varchar(300) NOT NULL,
  `footer_image` varchar(300) NOT NULL,
  `footer_image_link` text NOT NULL,
  `site_name` varchar(300) NOT NULL,
  `site_title` varchar(300) NOT NULL,
  `welcome_text` text NOT NULL,
  `home_page_slider` text NOT NULL,
  `custom_share_text` text NOT NULL,
  `custom_details_text` text NOT NULL,
  `facebook` varchar(400) NOT NULL,
  `google` varchar(400) NOT NULL,
  `linkedin` varchar(400) NOT NULL,
  `analytics_code` text NOT NULL,
  `guess_number` varchar(10) NOT NULL,
  `guess_number_status` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_page_setting`
--

INSERT INTO `user_page_setting` (`page_id`, `header_image`, `footer_image`, `footer_image_link`, `site_name`, `site_title`, `welcome_text`, `home_page_slider`, `custom_share_text`, `custom_details_text`, `facebook`, `google`, `linkedin`, `analytics_code`, `guess_number`, `guess_number_status`) VALUES
(3, '1_1_1_Vinnorokom-300px.png', 'viral-marketig-quiz.png', 'http://codecanyon.net/item/vinnorokom-facebook-quiz-viral-app/10869572', 'Vinnrokom Quiz', 'Play and win game', '<h3><em><strong>Welcome to vinnorokom quiz.</strong></em></h3>\r\n<p><em>Welcome to vinnorokom online quiz and poll page. Here you can vote and participate many quizzes campaigns . Lets start right now !</em></p>', 'a:3:{i:0;s:46:"http://www.fbquiz.com/public/media/slider1.png";i:1;s:45:"http://www.fbquiz.com/public/media/slider.png";i:2;s:0:"";}', '{name} got {score}% , Would you like to bid this score ?', 'Play and share quiz  , Make more fun your facebook time , And invite your friends for getting vote from them ? Tell them vote for your link ?  Make it more viral by sharing', 'http://facebook.com', 'http://google.com', 'http://linkedin.com', '  (function(i,s,o,g,r,a,m){i[''GoogleAnalyticsObject'']=r;i[r]=i[r]||function(){\r\n  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),\r\n  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)\r\n  })(window,document,''script'',''//www.google-analytics.com/analytics.js'',''ga'');\r\n\r\n  ga(''create'', ''UA-60781188-1'', ''auto'');\r\n  ga(''send'', ''pageview'');\r\n\r\nvar infolinks_pid = 391017;\r\nvar infolinks_wsid = 3;\r\n', '1,900', 1);

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

--
-- Table structure for table `user_polls`
--

CREATE TABLE IF NOT EXISTS `user_polls` (
  `poll_id` int(11) NOT NULL,
  `poll_text` varchar(400) NOT NULL,
  `created_at` datetime NOT NULL,
  `publish_date` datetime NOT NULL,
  `voting_last_date` datetime DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `image_path` text NOT NULL,
  `short_code` varchar(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_polls`
--

INSERT INTO `user_polls` (`poll_id`, `poll_text`, `created_at`, `publish_date`, `voting_last_date`, `is_featured`, `image_path`, `short_code`, `status`) VALUES
(19, 'How satisfied are you with your service from VINNOROKOM?', '2015-05-04 00:39:56', '0000-00-00 00:00:00', '2015-12-31 00:00:48', 1, 'http://quiz2.vinnorokom.com/public/media/viral-marketig.png', 'HOkUg', 0),
(20, 'Would you recommend Vinnorokom to a friend?', '2015-05-04 01:04:28', '0000-00-00 00:00:00', '2015-09-30 00:00:58', 1, 'http://quiz2.vinnorokom.com/public/media/viral-marketig-quiz.png', 'd@Gyl', 1),
(21, 'How many hours per week do you spend on Facebook?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2015-09-06 23:30:35', 1, 'http://quiz2.vinnorokom.com/public/media/501ffaae9b1a0477f75898926fe0708c.jpg', 'Ytauu', 1),
(22, 'How do you feel when some one block you @ facebook ? :P', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2015-11-08 00:00:25', 1, 'http://quiz2.vinnorokom.com/public/media/501ffaae9b1a0477f75898926fe0708c.jpg', 'Ul54T', 1),
(23, 'Watching a movie ,a very scary scene comes ?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2015-10-31 00:00:16', 1, 'http://quiz2.vinnorokom.com/public/media/501ffaae9b1a0477f75898926fe0708c.jpg', 'WPu3g', 1),
(26, 'If you are at home and suddenly  earthquake starts. what should you do?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-05-11 10:50:47', 1, 'http://quiz.vinnorokom.com/public/media/url.jpg', 'WbX6N', 1),
(27, 'What Makes You Happy?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2016-05-16 03:10:47', 1, 'http://quiz.vinnorokom.com/public/media/banner-1.jpg', '0LAEi', 1),
(28, 'What do you do if you have an unknown friend request on facebook?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-03-15 03:10:33', 1, 'http://quiz.vinnorokom.com/public/media/3711810903_79e6047d5c.jpg', '2PR8L', 1),
(29, 'Which type of girl do you like?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-01-18 08:25:51', 1, 'http://quiz.vinnorokom.com/public/media/view-lilo-stitch-3816748-600x338.jpg', '8PMQW', 1),
(30, 'What will you do if your parents dont like your bf/gf?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-04-05 03:10:08', 1, 'http://quiz.vinnorokom.com/public/media/la-et-south-park-.jpg', 'QBEMh', 1),
(31, 'Have you ever had cold pizza in the breakfast?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-05-09 02:05:05', 1, 'http://quiz.vinnorokom.com/public/media/pizza-329523_1280.jpg', 'rVkgt', 1),
(32, 'What you usually eat as a breakfast?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-05-02 02:05:12', 1, 'http://quiz.vinnorokom.com/public/media/pizza-329523_1280.jpg', 'meNuK', 1),
(33, 'Do the Real-Estate companies workable for you?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-05-03 03:10:00', 0, 'http://quiz.vinnorokom.com/public/media/realstate.jpg', 'ksYjW', 1),
(34, 'What are the most effective way to weight loss?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-08-08 02:05:06', 0, 'http://quiz.vinnorokom.com/public/media/burger-500054_1280.jpg', 'WuEgR', 1),
(35, 'Which is the best way for you to get potential traffic?', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-05-10 09:30:34', 1, 'http://quiz.vinnorokom.com/public/media/seo-758264_1280.jpg', '*QzwA', 1);

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

--
-- Table structure for table `user_poll_options`
--

CREATE TABLE IF NOT EXISTS `user_poll_options` (
  `poll_option_id` int(11) NOT NULL,
  `poll_id` int(11) NOT NULL,
  `poll_option_text` varchar(300) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_poll_options`
--

INSERT INTO `user_poll_options` (`poll_option_id`, `poll_id`, `poll_option_text`) VALUES
(1, 1, 'Eating '),
(2, 1, 'Facebook Poking :)'),
(3, 1, 'Nothing is easy !'),
(4, 2, 'Laravel'),
(5, 2, 'Kohona'),
(6, 2, 'Codeigniter'),
(7, 2, 'Falcon'),
(8, 2, 'Slim'),
(9, 2, 'Zend'),
(10, 3, 'Zend'),
(11, 4, 'Zend'),
(12, 3, 'CAKE PHP'),
(13, 3, 'Own Framwork'),
(14, 4, 'Kohana'),
(15, 4, 'Codeigniter'),
(22, 7, 'Arnold'),
(23, 7, 'James Cameron'),
(24, 7, 'Arirah'),
(25, 8, 'Cocacola'),
(26, 8, 'Pepsi'),
(27, 8, 'Fanta'),
(28, 8, 'Mountain Dew'),
(29, 9, 'Samsung'),
(30, 9, 'Nokia'),
(31, 9, 'Sony'),
(32, 9, 'Motorola'),
(33, 10, '10'),
(34, 10, '30'),
(35, 10, '50'),
(36, 10, '100'),
(37, 11, ''),
(38, 11, ''),
(39, 12, ''),
(40, 12, ''),
(41, 13, ''),
(42, 13, ''),
(43, 14, 'AAA'),
(44, 14, 'AA'),
(45, 15, 'sss'),
(46, 15, 'sss'),
(47, 16, 'ssss'),
(48, 16, 'ssssss'),
(50, 17, 'Firefox'),
(51, 17, 'Safari'),
(52, 17, 'Internet Explorer'),
(53, 18, 'NOKIA'),
(54, 18, 'SAMSUNG'),
(55, 18, 'MOTOROLA'),
(56, 18, 'HTC'),
(57, 18, 'GOOGLE NEXUS'),
(58, 18, 'IPHONE'),
(59, 18, 'NONE OF THEM '),
(64, 17, 'Chrome'),
(65, 17, 'Opera'),
(74, 19, 'Extremely satisfied'),
(75, 19, 'Very satisfied'),
(76, 19, 'Neutral'),
(77, 19, 'Very dissatisfied'),
(78, 19, 'Extremely dissatisfied'),
(79, 20, 'Yes'),
(80, 20, 'NO'),
(89, 21, '1-3 hrs'),
(90, 21, '4-8 hrs'),
(91, 21, '8-12 hrs'),
(92, 21, '12-20 hrs'),
(93, 21, 'more than 20 hrs'),
(94, 22, 'Very Bad :('),
(95, 22, 'Very Sad :''('),
(96, 22, 'Feel Guilty :-|'),
(97, 22, 'Feel Angry >:('),
(98, 22, 'Very Good :D'),
(99, 23, 'Start Screaming loud and disturb others'),
(100, 23, 'Bite the sitting next by stranger'),
(101, 23, 'Just run away and move out of the movie'),
(102, 23, 'Just sit n watch the movie'),
(103, 24, 'qwe'),
(104, 24, 'eqwe'),
(105, 25, 'asdsa'),
(106, 25, 'dasd'),
(107, 26, 'Run and go out of home'),
(108, 26, 'Dont be excited and Stay quiet at the home'),
(109, 26, 'Cover your head with your hand'),
(110, 26, 'Cover your head  and hold under the table.'),
(111, 26, 'Stay under your bed.'),
(112, 27, 'Facebook browsing'),
(113, 27, 'Watching TV'),
(114, 27, 'Gossiping with friends'),
(115, 27, 'To stay with someone special'),
(116, 28, 'Deny the request'),
(117, 28, 'Ask him/her if you know.'),
(118, 28, 'Take no action'),
(119, 28, 'Block him/her'),
(120, 29, 'Calm and Gentle'),
(121, 29, 'Naughty and Crazy'),
(122, 29, 'None of them'),
(123, 29, 'Calm but Naughty'),
(124, 30, 'Go to argument with parents'),
(125, 30, 'Decision to breakup'),
(126, 30, 'Keep going the relation although'),
(127, 30, 'Take time to solve everything'),
(128, 31, 'Yes'),
(129, 31, 'Never'),
(130, 31, 'No opinion'),
(131, 32, 'Cold cereal '),
(132, 32, 'Hot cereal '),
(133, 32, 'Eggs '),
(134, 32, 'Banana(s) '),
(135, 32, 'Yogurt'),
(136, 32, 'Bacon and eggs'),
(137, 32, 'Pancakes '),
(138, 32, 'Waffles '),
(139, 32, 'Fruit'),
(140, 32, 'French toast '),
(141, 32, 'Muffins'),
(142, 32, 'Other pastry '),
(143, 32, 'Hot Coffee'),
(144, 32, 'Cold Coffee'),
(145, 32, 'Bagel '),
(146, 32, 'Bacon '),
(147, 32, 'Ham and eggs '),
(148, 32, 'Toast'),
(149, 32, 'Other '),
(150, 32, 'Variety of things '),
(151, 33, 'Yes'),
(152, 33, 'No'),
(153, 33, 'I have my own house'),
(154, 34, 'Go walking regularly'),
(155, 34, 'Avoid all fatty food'),
(156, 34, 'Take vegetable instead of meat.'),
(157, 34, 'Do not take fast/junk food'),
(158, 34, 'Have physical exercise regular basis'),
(159, 35, 'Social Media Marketing (SMM)'),
(160, 35, 'Search Engine Optimization (SEO)'),
(161, 35, 'Tele-marketing'),
(162, 35, 'Email Marketing'),
(163, 35, 'Facebook Quiz and Poll marketing'),
(164, 35, 'Search Engine Marketing'),
(165, 35, 'Only Facebook marketing');

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

--
-- Table structure for table `user_poll_voters`
--

CREATE TABLE IF NOT EXISTS `user_poll_voters` (
  `poll_voter_id` int(11) NOT NULL,
  `poll_id` int(11) NOT NULL,
  `poll_option_id` int(11) NOT NULL,
  `fbid` bigint(90) NOT NULL,
  `ip` varchar(250) NOT NULL,
  `number` int(11) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_quiz`
--

CREATE TABLE IF NOT EXISTS `user_quiz` (
  `id` int(200) NOT NULL,
  `group_id` int(11) NOT NULL,
  `text` varchar(4000) CHARACTER SET utf8 NOT NULL,
  `ans` varchar(200) NOT NULL,
  `user` varchar(200) NOT NULL,
  `is_public` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz`
--

INSERT INTO `user_quiz` (`id`, `group_id`, `text`, `ans`, `user`, `is_public`) VALUES
(73, 11, 'What is the color of Ocean ? ', '168', '', 1),
(74, 11, 'What is the color of water?', '171', '', 1),
(75, 11, 'What is the color of sky ?', '178', '', 1),
(83, 11, 'What is the color of air ?', '208', '', 1),
(84, 13, 'What is EURO ?', '211', '', 1),
(85, 12, 'FIFA World Cup 2014 began on ?', '214', '', 1),
(86, 1, 'Official schedule for the ICC Cricket World Cup?', '218', '', 1),
(87, 18, 'The MacBook is a brand of notebook computers manufactured by ?', '221', '', 1),
(88, 16, 'What is the brand logo of Apple Company?', '227', '', 1),
(89, 19, 'Monday is to Sunday as Fall is to which season?', '228', '', 1),
(90, 19, 'Following the pattern 2, 7, 13, 20, 28, ___. Fill in the gap.', '234', '', 1),
(91, 19, 'Which one is not following other?', '237', '', 1),
(92, 19, 'F6, 10J, 14N, 18R, Which one will be as the next one?', '240', '', 1),
(93, 19, 'Select a letter listed below which one can not be turned upside down even if reflects in the mirror but still looks correct?', '246', '', 1),
(94, 19, 'By rearranging the letters "Nearby Priests"  you can generate a name of famous person. who is this?', '250', '', 1),
(95, 19, 'Which one does not match others?', '252', '', 1),
(96, 19, 'A, S, D, F, G, H, J. Which letter comes next in this sequence?', '257', '', 1),
(97, 19, 'Dome is to Mountain as Redwood is to _____?', '261', '', 1),
(98, 19, 'water, paperclip, business cards, ____, computer. Which should be the 4th one?', '267', '', 1),
(99, 20, 'What is the biggest planet in our solar system?', '268', '', 1),
(100, 20, 'What is the chemical symbol for the element oxygen?', '272', '', 1),
(101, 20, 'The highest mountain on earth is?', '275', '', 1),
(102, 20, 'Pure water has a pH level of a around?', '281', '', 1),
(103, 20, 'What famous scientist was awarded the 1921 Nobel Prize in Physics for his work on theoretical physics?', '284', '', 1),
(104, 21, 'What does HTML stand for?', '290', '', 1),
(105, 22, 'Which Team won the Worldcup Football 2014?', '293', '', 1),
(106, 22, 'Where took place the FIFA 2014?', '296', '', 1),
(107, 22, 'Which teams played the 1st match?', '299', '', 1),
(108, 22, 'How many matches took place in the FIFA 2014', '306', '', 1),
(109, 22, 'Who was the top scorer of FIFA 2014?', '307', '', 1),
(110, 23, 'What kind of restaurant McDonald''s is?', '311', '', 1),
(111, 23, 'Where is the headquarter of McDonald''s?', '316', '', 1),
(112, 23, 'What is the special Item of McDonald''s?', '319', '', 1),
(113, 23, 'Does McDonald''s sell any soft drink?', '323', '', 1),
(114, 23, 'How many colors are in McDonald''s logo?', '326', '', 1),
(116, 16, 'Will you like a date with me?', '333', '', 1),
(120, 21, 'What is Javascript ?', '343', '', 1);

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

--
-- Table structure for table `user_quiz_admin`
--

CREATE TABLE IF NOT EXISTS `user_quiz_admin` (
  `id` int(200) NOT NULL,
  `user` varchar(200) NOT NULL,
  `pass` varchar(400) NOT NULL,
  `role` varchar(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz_admin`
--

INSERT INTO `user_quiz_admin` (`id`, `user`, `pass`, `role`) VALUES
(1, 'admin', '123456', 'admin');

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

--
-- Table structure for table `user_quiz_group`
--

CREATE TABLE IF NOT EXISTS `user_quiz_group` (
  `group_id` int(11) NOT NULL,
  `group_name` varchar(100) DEFAULT NULL,
  `image_path` varchar(500) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `is_public` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz_group`
--

INSERT INTO `user_quiz_group` (`group_id`, `group_name`, `image_path`, `status`, `is_public`) VALUES
(1, 'ICC Cup 2015', 'http://quiz2.vinnorokom.com/public/media/viral-marketig.png', 1, 0),
(11, 'Daily Quiz ', 'http://quiz2.vinnorokom.com/public/media/Vinnorokom-Quiz.png', 1, 0),
(12, 'FIFA 2015', 'http://quiz2.vinnorokom.com/public/media/viral-marketig-quiz.png', 1, 0),
(13, 'EURO CUP', 'http://quiz2.vinnorokom.com/public/media/Vinnorokom-Quiz.png', 1, 0),
(16, 'Win A iPhone', 'http://quiz2.vinnorokom.com/public/media/Vinnorokom-Quiz.png', 0, 0),
(17, 'Win and Get 30% bundle offer', 'http://quiz2.vinnorokom.com/public/media/viral-marketig.png', 0, 0),
(18, 'Win a Laptop', 'http://quiz2.vinnorokom.com/public/media/viral-marketig-quiz.png', 0, 0),
(19, 'IQ Easy', 'http://quiz2.vinnorokom.com/public/media/elections-536656_1280.png', 1, 0),
(20, 'General Science', 'http://quiz2.vinnorokom.com/public/media/space-station-485590_1280.jpg', 1, 1),
(21, 'HTML Test', 'http://quiz2.vinnorokom.com/public/media/Vinnorokom-banner_2_2.png', 1, 1),
(22, 'FIFA 2014', 'http://placehold.it/600x350', 1, 1),
(23, 'McDonald''s', 'http://quiz2.vinnorokom.com/public/media/mcdonald.jpg', 1, 1);

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

--
-- Table structure for table `user_quiz_info`
--

CREATE TABLE IF NOT EXISTS `user_quiz_info` (
  `id` int(200) NOT NULL,
  `name` varchar(400) NOT NULL,
  `fbid` varchar(200) NOT NULL,
  `email` varchar(400) NOT NULL,
  `join_date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_quiz_options`
--

CREATE TABLE IF NOT EXISTS `user_quiz_options` (
  `id` int(200) NOT NULL,
  `qid` varchar(200) NOT NULL,
  `qtext` varchar(4000) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=344 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz_options`
--

INSERT INTO `user_quiz_options` (`id`, `qid`, `qtext`) VALUES
(167, '73', 'Yellow'),
(168, '73', 'Blue'),
(169, '73', 'Violet'),
(170, '73', 'Green'),
(171, '74', 'None'),
(172, '74', 'Blue'),
(173, '74', 'White'),
(174, '74', 'Water'),
(175, '75', 'Red'),
(176, '75', 'Black'),
(177, '75', 'Blue'),
(178, '75', 'Ocean Blue'),
(207, '83', 'Red'),
(208, '83', 'None'),
(209, '83', 'Yellow'),
(210, '83', 'white'),
(211, '84', 'The UEFA European Championship'),
(212, '84', 'Europian Football Cup'),
(213, '84', 'East West Cup'),
(214, '85', 'Thursday, June 12 , 2014'),
(215, '85', 'Thursday, June 13, 2014'),
(216, '85', 'Friday , June 13, 2014'),
(217, '86', '14 Feb-28 Apr, 2015'),
(218, '86', '14 Feb-28 Mar, 2015'),
(219, '86', '14 Feb-28 Feb, 2015'),
(220, '87', 'DELL'),
(221, '87', 'APPLE'),
(222, '87', 'INTEL'),
(223, '87', 'MICROSOFT'),
(224, '88', 'Banana'),
(225, '88', 'Orange'),
(226, '88', 'PineApple'),
(227, '88', 'Apple'),
(228, '89', 'Summer'),
(229, '89', 'Winter'),
(230, '89', 'Spring'),
(231, '89', 'Autumn'),
(232, '90', '41'),
(233, '90', '50'),
(234, '90', '37'),
(235, '90', '31'),
(236, '91', 'Yahoo.com'),
(237, '91', 'Ask.com'),
(238, '91', 'Gmail.com'),
(239, '91', 'Hotmail.com'),
(240, '92', 'V'),
(241, '92', 'X'),
(242, '92', 'U'),
(243, '92', 'Y'),
(244, '93', 'M'),
(245, '93', 'P'),
(246, '93', 'O'),
(247, '93', 'B'),
(248, '94', 'A baseball player '),
(249, '94', 'A famous scientist '),
(250, '94', 'A famous pop princess'),
(251, '94', 'A Great Footballer'),
(252, '95', 'Post-it note '),
(253, '95', 'Computer '),
(254, '95', 'Cell phone '),
(255, '95', 'Typewriter'),
(256, '96', 'W'),
(257, '96', 'K'),
(258, '96', 'V'),
(259, '96', 'M'),
(260, '97', 'Animal'),
(261, '97', 'Tree'),
(262, '97', 'Forest'),
(263, '97', 'Paper'),
(264, '98', 'magnets '),
(265, '98', 'pushpins '),
(266, '98', 'executive desk furniture '),
(267, '98', 'cell phone'),
(268, '99', 'Jupiter'),
(269, '99', 'Neptune'),
(270, '99', 'Earth'),
(271, '99', 'Mars'),
(272, '100', 'O'),
(273, '100', 'H2O'),
(274, '100', 'O2'),
(275, '101', 'Mount Everest'),
(276, '101', 'Godwin Austen'),
(277, '101', 'Kangchenjunga'),
(278, '101', 'Lhotse'),
(279, '102', '5'),
(280, '102', '6'),
(281, '102', '7'),
(282, '102', '8'),
(283, '102', '9'),
(284, '103', 'Albert Einstein'),
(285, '103', 'John dalton'),
(286, '103', 'Radarford'),
(287, '103', 'Ibn al-Haytham'),
(288, '104', 'Hyperlinks and Text Markup Language'),
(289, '104', 'Hyper Text Markup Language'),
(290, '104', 'Home Tool Markup Language'),
(291, '105', 'Argentina'),
(292, '105', 'Brazil'),
(293, '105', 'Germany'),
(294, '105', 'Netherlands'),
(295, '106', 'Germany'),
(296, '106', 'Brazil'),
(297, '106', 'Argentina'),
(298, '106', 'France'),
(299, '107', 'Brazil-Croatia'),
(300, '107', 'Spain- Netherlands'),
(301, '107', 'England-Italy'),
(302, '107', 'Mexico-Cameroon'),
(303, '108', '60'),
(304, '108', '66'),
(305, '108', '57'),
(306, '108', '64'),
(307, '109', 'James Rodríguez'),
(308, '109', 'Thomas Müller'),
(309, '109', 'Neymar'),
(310, '109', 'Lionel Messi'),
(311, '110', 'Fast food restaurant'),
(312, '110', 'Chinis restaurant'),
(313, '110', 'Treditional restaurant'),
(314, '110', 'Local restaurant'),
(315, '111', 'California,U.S'),
(316, '111', 'Illinois, U.S.'),
(317, '111', 'Utah,U.S'),
(318, '111', 'Chicago,U.S'),
(319, '112', 'Hamburgers'),
(320, '112', 'Chicken Fry'),
(321, '112', 'Salad'),
(322, '112', 'Chicken Buegers'),
(323, '113', 'Yes'),
(324, '113', 'No'),
(325, '114', '3'),
(326, '114', '2'),
(327, '114', '4'),
(328, '114', '1'),
(332, '116', 'yes'),
(333, '116', 'no'),
(334, '116', 'may be'),
(341, '120', 'Short form of  java'),
(342, '120', 'HTML code'),
(343, '120', 'None');

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

--
-- Table structure for table `user_quiz_result`
--

CREATE TABLE IF NOT EXISTS `user_quiz_result` (
  `id` int(200) NOT NULL,
  `fid` varchar(200) NOT NULL,
  `true_ans` varchar(200) NOT NULL,
  `false_ans` varchar(200) NOT NULL,
  `avg_grade` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `timestamp` varchar(20) DEFAULT NULL,
  `group_id` int(11) NOT NULL,
  `is_shared` tinyint(4) NOT NULL,
  `quiz_date` varchar(200) NOT NULL,
  `session_id` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=364 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz_result`
--

INSERT INTO `user_quiz_result` (`id`, `fid`, `true_ans`, `false_ans`, `avg_grade`, `total`, `timestamp`, `group_id`, `is_shared`, `quiz_date`, `session_id`) VALUES
(363, '1516190378', '1', '4', 20, 5, '20150923204909', 20, 0, '2015-09-23 20:49:55', 'domcnc80ud068a9fomilas1bk5');

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

--
-- Table structure for table `user_quiz_retake`
--

CREATE TABLE IF NOT EXISTS `user_quiz_retake` (
  `id` int(200) NOT NULL,
  `fbid` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_quiz_schedule`
--

CREATE TABLE IF NOT EXISTS `user_quiz_schedule` (
  `schedule_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz_schedule`
--

INSERT INTO `user_quiz_schedule` (`schedule_id`, `group_id`, `start_date`, `end_date`, `created_at`) VALUES
(19, 0, '2015-05-01 00:00:07', '2015-10-31 12:00:53', '2015-05-13 02:21:00'),
(20, 18, '2015-05-01 00:00:07', '2015-11-13 00:00:53', '2015-05-23 20:06:18'),
(21, 12, '2015-05-01 00:00:07', '2015-11-13 00:00:53', '2015-05-23 20:06:25'),
(22, 17, '2015-05-01 00:00:07', '2015-11-13 00:00:53', '2015-06-02 23:52:39'),
(23, 16, '2015-09-16 11:46:41', '2016-02-29 00:00:53', '0000-00-00 00:00:00'),
(24, 13, '2015-09-16 11:46:41', '2016-02-29 00:00:53', '0000-00-00 00:00:00'),
(25, 1, '2015-09-16 11:46:41', '2016-02-29 00:00:53', '0000-00-00 00:00:00');

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

--
-- Table structure for table `user_quiz_setting`
--

CREATE TABLE IF NOT EXISTS `user_quiz_setting` (
  `quiz_setting_id` int(11) NOT NULL,
  `default_group` int(11) NOT NULL,
  `publish_from` datetime DEFAULT NULL,
  `publish_to` datetime DEFAULT NULL,
  `random_options` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz_setting`
--

INSERT INTO `user_quiz_setting` (`quiz_setting_id`, `default_group`, `publish_from`, `publish_to`, `random_options`) VALUES
(1, 1, '2015-09-16 11:46:41', '2016-02-29 00:00:53', 1);

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

--
-- Table structure for table `user_quiz_temp`
--

CREATE TABLE IF NOT EXISTS `user_quiz_temp` (
  `id` int(200) NOT NULL,
  `uid` varchar(200) NOT NULL,
  `ur_ans` varchar(200) NOT NULL,
  `qid` varchar(200) NOT NULL,
  `session_id` varchar(300) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=1917 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_quiz_temp`
--

INSERT INTO `user_quiz_temp` (`id`, `uid`, `ur_ans`, `qid`, `session_id`, `date`) VALUES
(1912, '1516190378', '269', '99', 'domcnc80ud068a9fomilas1bk5', '2015-09-22 18:00:00'),
(1913, '1516190378', '273', '100', 'domcnc80ud068a9fomilas1bk5', '2015-09-22 18:00:00'),
(1914, '1516190378', '277', '101', 'domcnc80ud068a9fomilas1bk5', '2015-09-22 18:00:00'),
(1915, '1516190378', '281', '102', 'domcnc80ud068a9fomilas1bk5', '2015-09-22 18:00:00'),
(1916, '1516190378', '286', '103', 'domcnc80ud068a9fomilas1bk5', '2015-09-22 18:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `email_settings`
--
ALTER TABLE `email_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `media_files`
--
ALTER TABLE `media_files`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_userid_unique` (`fbid`);

--
-- Indexes for table `user_pages`
--
ALTER TABLE `user_pages`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `user_page_setting`
--
ALTER TABLE `user_page_setting`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `user_polls`
--
ALTER TABLE `user_polls`
  ADD PRIMARY KEY (`poll_id`),
  ADD UNIQUE KEY `short_code` (`short_code`);

--
-- Indexes for table `user_poll_options`
--
ALTER TABLE `user_poll_options`
  ADD PRIMARY KEY (`poll_option_id`);

--
-- Indexes for table `user_poll_voters`
--
ALTER TABLE `user_poll_voters`
  ADD PRIMARY KEY (`poll_voter_id`);

--
-- Indexes for table `user_quiz`
--
ALTER TABLE `user_quiz`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_quiz_admin`
--
ALTER TABLE `user_quiz_admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_quiz_group`
--
ALTER TABLE `user_quiz_group`
  ADD PRIMARY KEY (`group_id`);

--
-- Indexes for table `user_quiz_info`
--
ALTER TABLE `user_quiz_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_quiz_options`
--
ALTER TABLE `user_quiz_options`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_quiz_result`
--
ALTER TABLE `user_quiz_result`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_quiz_retake`
--
ALTER TABLE `user_quiz_retake`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_quiz_schedule`
--
ALTER TABLE `user_quiz_schedule`
  ADD PRIMARY KEY (`schedule_id`);

--
-- Indexes for table `user_quiz_setting`
--
ALTER TABLE `user_quiz_setting`
  ADD PRIMARY KEY (`quiz_setting_id`);

--
-- Indexes for table `user_quiz_temp`
--
ALTER TABLE `user_quiz_temp`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `email_settings`
--
ALTER TABLE `email_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `media_files`
--
ALTER TABLE `media_files`
  MODIFY `file_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=69;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=721;
--
-- AUTO_INCREMENT for table `user_pages`
--
ALTER TABLE `user_pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=35;
--
-- AUTO_INCREMENT for table `user_page_setting`
--
ALTER TABLE `user_page_setting`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `user_polls`
--
ALTER TABLE `user_polls`
  MODIFY `poll_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `user_poll_options`
--
ALTER TABLE `user_poll_options`
  MODIFY `poll_option_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=166;
--
-- AUTO_INCREMENT for table `user_poll_voters`
--
ALTER TABLE `user_poll_voters`
  MODIFY `poll_voter_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=111;
--
-- AUTO_INCREMENT for table `user_quiz`
--
ALTER TABLE `user_quiz`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=121;
--
-- AUTO_INCREMENT for table `user_quiz_admin`
--
ALTER TABLE `user_quiz_admin`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user_quiz_group`
--
ALTER TABLE `user_quiz_group`
  MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `user_quiz_info`
--
ALTER TABLE `user_quiz_info`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_quiz_options`
--
ALTER TABLE `user_quiz_options`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=344;
--
-- AUTO_INCREMENT for table `user_quiz_result`
--
ALTER TABLE `user_quiz_result`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=364;
--
-- AUTO_INCREMENT for table `user_quiz_retake`
--
ALTER TABLE `user_quiz_retake`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `user_quiz_schedule`
--
ALTER TABLE `user_quiz_schedule`
  MODIFY `schedule_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `user_quiz_setting`
--
ALTER TABLE `user_quiz_setting`
  MODIFY `quiz_setting_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user_quiz_temp`
--
ALTER TABLE `user_quiz_temp`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1917;
/*!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 */;
