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




--
-- Database: `tatasky_discovery`
--

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

--
-- Table structure for table `fx_admin_users`
--

CREATE TABLE IF NOT EXISTS `fx_admin_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) NOT NULL,
  `code` varchar(20) DEFAULT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `contact_name` text,
  `mobile` varchar(20) DEFAULT NULL,
  `mobile2` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` text,
  `avatar` text,
  `address1` longtext,
  `address2` longtext,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `country` int(11) DEFAULT NULL,
  `zipcode` text,
  `gender` text,
  `user_type` varchar(20) NOT NULL,
  `role` int(11) DEFAULT '0',
  `sendemailflg` int(11) DEFAULT '0',
  `createdon` bigint(20) DEFAULT '0',
  `createdby` int(11) DEFAULT '0',
  `updatedon` bigint(20) DEFAULT '0',
  `updatedby` int(11) DEFAULT '0',
  `isactive` int(11) DEFAULT '0',
  `isdelete` int(11) DEFAULT '0',
  `abn` text COMMENT 'Australian Business Number',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=7 ;

--
-- Dumping data for table `fx_admin_users`
--

INSERT INTO `fx_admin_users` (`user_id`, `store_id`, `code`, `first_name`, `last_name`, `company_name`, `contact_name`, `mobile`, `mobile2`, `email`, `password`, `avatar`, `address1`, `address2`, `city`, `state`, `country`, `zipcode`, `gender`, `user_type`, `role`, `sendemailflg`, `createdon`, `createdby`, `updatedon`, `updatedby`, `isactive`, `isdelete`, `abn`) VALUES
(1, 0, '', 'Super', 'Admin', 'SuperAdmin', NULL, '1', '1', 'admin@gmail.com', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', '', '', '', '', '', 0, '', '0', '1', 1, 0, 0, 0, 0, 0, 1, 0, NULL),
(2, 0, '2342', 'Test', 'testl', '', NULL, 'test', '', 'test@test.com', 'test', '', 'asdf', 'asdf', 'asdf', 'asdf', 0, 'asdf', '0', 'Supplier', 0, NULL, 0, 0, 0, 0, 0, 0, NULL),
(3, 0, 'Test Decorator', 'Decorator', 'Test', 'sdf', NULL, '888888888', '', 'test@test.com', '123456', '', 'rw', 'ww', 'w', 'w', 0, '424001', '0', 'Supplier', 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(4, 0, '', 'Name', 'Only', '', NULL, '', '', '', '', '', '', '', '', '', 1, '', '0', 'Supplier', 0, 0, 1587017570, 1, 1590499971, 1, 1, 1, NULL),
(5, 0, '', 'Only name', NULL, NULL, NULL, '', NULL, '', '', NULL, '', '', '', 'Qld', 1, '', 'male', 'Supplier', 0, 0, 1587020937, 1, 1589974576, 1, 1, 1, 'FDSA987'),
(6, 0, NULL, 'Only name', '', '', '', '', NULL, '', '', NULL, '', '', '', 'NT', 1, '', NULL, 'StoreAdmin', 0, 0, 1587023329, 1, 1587023927, 1, 1, 0, NULL);

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

--
-- 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);

