-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `fx_questions`
--

CREATE TABLE IF NOT EXISTS `fx_questions` (
  `questionID` int(11) NOT NULL AUTO_INCREMENT,
  `question` text,
  `optionOne` text,
  `optionTwo` text,
  `optionThree` text,
  `optionFour` text,
  `correctAnswer` text,
  `status` int(11) NOT NULL DEFAULT '1',
  `dateAdded` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  PRIMARY KEY (`questionID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `fx_questions`
--

INSERT INTO `fx_questions` (`questionID`, `question`, `optionOne`, `optionTwo`, `optionThree`, `optionFour`, `correctAnswer`, `status`, `dateAdded`, `dateModified`) VALUES
(1, 'testdf', 'tsdsf', 'testdsf', 'testcxv', 'testdsfd', '3', 0, NULL, '2020-07-10 12:44:31'),
(2, 'The Indo-Tibetan Border Police were given a tight deadline for what reason?', 'To set up testing halls', 'To set up a hospital', 'To set up quarantine halls', 'To find COVID-19 victims', '3', 1, '2020-07-10 14:22:46', '2020-07-10 14:55:10'),
(3, 'What is the outer layer or fringe of the virus called?', 'Corona', 'Tendril', 'Viral coat', 'Virion', '1', 1, '2020-07-10 14:23:15', '2020-07-10 14:56:06'),
(4, 'Where was the first COVID-19 casualty in India?', 'Madurai, Tamil Nadu', 'Kalburgi, Karnataka', 'Mumbai, Maharashtra', 'Hyderabad, Telangana', '2', 1, '2020-07-10 14:23:44', '2020-07-10 14:58:35'),
(5, 'As of 14th April, which continent had no reported cases of COVID-19?', 'Australia', 'Antarctica', 'South America', 'Africa', '2', 1, '2020-07-10 14:24:13', '2020-07-10 15:00:01'),
(6, 'The Vande Bharat Mission was initiated to bring home how many Indians stranded abroad?', 'More than 200,000', 'More than 50,000', 'More than 1,000,000', 'More than 10,000', '1', 1, '2020-07-10 14:24:50', '2020-07-10 15:01:01');

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

--
-- Table structure for table `fx_user_answer`
--

CREATE TABLE IF NOT EXISTS `fx_user_answer` (
  `userAnswerID` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL DEFAULT '0',
  `questionID` int(11) NOT NULL DEFAULT '0',
  `answer` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  `dateAdded` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  PRIMARY KEY (`userAnswerID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `fx_user_answer`
--

INSERT INTO `fx_user_answer` (`userAnswerID`, `userID`, `questionID`, `answer`, `status`, `dateAdded`, `dateModified`) VALUES
(1, 789123, 2, 3, 1, '2020-07-11 16:04:04', NULL),
(2, 789123, 4, 2, 1, '2020-07-11 16:04:17', NULL),
(3, 789123, 3, 1, 1, '2020-07-11 16:04:33', NULL),
(4, 789123, 5, 2, 1, '2020-07-11 16:50:52', NULL),
(5, 789123, 6, 1, 1, '2020-07-11 16:50:55', NULL);

