Edit - savsoft.sql

Edit: savsoft.sql

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: `savsoft5`
--

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

--
-- Table structure for table `account_type`
--

CREATE TABLE `account_type` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT,
  `users` varchar(1000) DEFAULT NULL,
  `quiz` varchar(1000) DEFAULT NULL,
  `results` varchar(1000) DEFAULT NULL,
  `questions` varchar(1000) DEFAULT NULL,
  `account_name` varchar(1000) DEFAULT NULL,
  `setting` varchar(100) DEFAULT NULL,
  `study_material` varchar(1000) NOT NULL,
  `appointment` varchar(1000) NOT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `account_type`
--

INSERT INTO `account_type` VALUES
(1, 'Add,Edit,View,List,List_all,Myaccount,Remove', 'Attempt,Add,Edit,View,List,List_all,Remove', 'View,List,List_all,Remove', 'Add,Edit,View,list,List_all,Remove', 'Administrator', 'All', 'Add,Edit,View,List,List_all,Remove', 'List,List_all'),
(2, 'Myaccount', 'Attempt,View,List', 'View,List,Remove', '', 'User', NULL, 'View,List', 'List');

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

--
-- Table structure for table `appointment_request`
--

CREATE TABLE `appointment_request` (
  `appointment_id` int(11) NOT NULL AUTO_INCREMENT,
  `request_by` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  `appointment_timing` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `appointment_time_zone` varchar(100) NOT NULL DEFAULT 'Asia/Kolkata',
  `appointment_status` varchar(100) NOT NULL DEFAULT 'Pending',
  PRIMARY KEY (`appointment_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `appointment_request`
--

INSERT INTO `appointment_request` VALUES
(2, 9, 1, '2017-08-30 07:53:57', 'Asia/Kolkata', 'Accepted'),
(3, 1, 1, '2017-12-27 08:43:25', 'Asia/Kolkata', 'Accepted'),
(4, 1, 1, '2019-03-18 06:18:40', 'Asia/Kolkata', 'Accepted'),
(5, 5, 1, '2019-03-18 12:50:32', 'Asia/Kolkata', 'Accepted');

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
  `data` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `savsoftquiz_custom_form`
--

CREATE TABLE `savsoftquiz_custom_form` (
  `field_id` int(11) NOT NULL AUTO_INCREMENT,
  `field_title` varchar(100) NOT NULL,
  `field_type` varchar(100) NOT NULL DEFAULT 'text',
  `field_validate` varchar(1000) NOT NULL DEFAULT 'pattern="[A-Za-z0-9]{1,100}"',
  `field_value` varchar(100) DEFAULT NULL,
  `display_at` varchar(100) NOT NULL DEFAULT 'Registration',
  PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `savsoftquiz_setting`
--

CREATE TABLE `savsoftquiz_setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(1000) NOT NULL,
  `setting_value` varchar(1000) DEFAULT 'true',
  `setting_group_name` varchar(100) NOT NULL DEFAULT 'General',
  `order_by` int(11) NOT NULL,
  `setting_description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;

--
-- Dumping data for table `savsoftquiz_setting`
--

INSERT INTO `savsoftquiz_setting` VALUES
(1, 'App_Name', '', 'General', 1, NULL),
(2, 'App_title', '', 'General', 1, NULL),
(3, 'SMTP_hostname', 'ssl://smtp.gmail.com', 'Email', 2, NULL),
(4, 'SMTP_username', '', 'Email', 2, NULL),
(5, 'SMTP_password', '', 'Email', 2, NULL),
(6, 'SMTP_port', '465', 'Email', 2, NULL),
(7, 'Language_direction', 'ltr', 'General', 1, NULL),
(8, 'Enable_web_cam', 'true', 'General', 1, NULL),
(9, 'Enable_google_chart', 'true', 'General', 1, NULL),
(10, 'Enable_dompdf', 'true', 'General', 1, NULL),
(11, 'Enable_user_registration', 'true', 'General', 1, NULL),
(12, 'Verify_user_email', 'true', 'Email', 2, NULL),
(13, 'Tinymce_editor', 'true', 'Editor', 3, NULL),
(14, 'Tinymce_eqneditor_plugin', 'true', 'Editor', 3, NULL),
(15, 'Tinymce_wiris_plugin', 'true', 'Editor', 3, NULL),
(16, 'Mathjax', 'true', 'Editor', 3, NULL),
(17, 'Default_group_id', '1', 'General', 1, NULL),
(18, 'Enable_open_quiz', 'true', 'General', 1, NULL),
(19, 'Enable_sharethis', 'true', 'General', 1, NULL),
(20, 'Sharethis_property_id', '', 'General', 1, NULL),
(21, 'Advertisement_display_after_seconds', '60', 'General', 1, NULL),
(22, 'Advertisement_display_for_seconds', '10', 'General', 1, NULL),
(23, 'Android_API_key', '', 'General', 1, NULL),
(25, 'Email_protocol', 'mail', 'Email', 2, NULL),
(26, 'SMTP_mailtype', 'text', 'Email', 2, NULL),
(28, 'Activation_email_subject', 'Action required to verify your account', 'Email', 2, NULL),
(29, 'Activation_email_message', 'Hi, \\r\\n Thank you for registering with us. Please click below link to verify your email address.\\r\\n <a href=''[verilink]''>[verilink]</a> \\r\\n or \\r\\n Copy below link and visit in browser \\r\\n [verilink] \\r\\n \\r\\n Thanks', 'Email', 2, NULL),
(30, 'Password_change_subject', 'Password Changed', 'Email', 2, NULL),
(31, 'Password_change_message', 'Hi, \\r\\n Your New Password is: [new_password] \\r\\n Thanks', 'Email', 2, NULL),
(32, 'Send_result_email', 'true', 'Email', 2, NULL),
(33, 'Result_email_subject', 'Result generated for quiz [quiz_name]', 'Email', 2, NULL),
(34, 'Result_email_message', 'Hi [last_name],\\r\\n \\r\\n You have [result_status] Quiz: ''[quiz_name]'' and obtained [percentage_obtained]% marks. To get more information please login to your quiz portal.\\r\\n \\r\\n Thanks', 'Email', 2, NULL),
(35, 'Master_password', 'savsoftquiz', 'General', 1, NULL),
(36, 'Base_currency_prefix', '$', 'Payment_Gateway', 4, NULL),
(37, 'Base_currency_sufix', 'USD', 'Payment_Gateway', 4, NULL),
(38, 'Payment_gateways', 'paypal,checkout,payumoney,paytm', 'Payment_Gateway', 4, 'Comma separated'),
(39, 'Default_gateway', 'paypal', 'Payment_Gateway', 4, NULL),
(40, 'Enable_paypal', 'true', 'Payment_Gateway', 4, NULL),
(41, 'Paypal_environment', '', 'Payment_Gateway', 4, 'Empty for real or sandbox '),
(42, 'Paypal_receiver', '', 'Payment_Gateway', 4, 'Paypal email id'),
(43, 'Paypal_currency_prefix', '$', 'Payment_Gateway', 4, NULL),
(44, 'Paypal_currency_sufix', 'USD', 'Payment_Gateway', 4, NULL),
(45, 'Paypal_conversion', '1', 'Payment_Gateway', 4, '1 if base currency is same'),
(46, 'Enable_checkout', 'true', 'Payment_Gateway', 4, NULL),
(47, 'Checkout_environment', '', 'Payment_Gateway', 4, NULL),
(48, 'Checkout_sid', '', 'Payment_Gateway', 4, NULL),
(49, 'Checkout_SecretWord', '', 'Payment_Gateway', 4, ''),
(50, 'Checkout_receiver', '', 'Payment_Gateway', 4, NULL),
(51, 'Checkout_currency_prefix', '$', 'Payment_Gateway', 4, NULL),
(52, 'Checkout_currency_sufix', 'USD', 'Payment_Gateway', 4, NULL),
(53, 'Checkout_conversion', '1', 'Payment_Gateway', 4, NULL),
(54, 'Enable_payumoney', 'false', 'Payment_Gateway', 4, NULL),
(55, 'Payu_merchant_key', '', 'Payment_Gateway', 4, NULL),
(56, 'Payu_salt', '', 'Payment_Gateway', 4, NULL),
(57, 'Payumoney_currency_prefix', 'Rs', 'Payment_Gateway', 4, NULL),
(58, 'Payumoney_currency_sufix', 'INR', 'Payment_Gateway', 4, NULL),
(59, 'Payumoney_conversion', '66', 'Payment_Gateway', 4, NULL),
(60, 'Enable_paytm', 'false', 'Payment_Gateway', 4, NULL),
(61, 'Paytm_environment', 'Test', 'Payment_Gateway', 4, NULL),
(62, 'Paytm_merchant_key', '', 'Payment_Gateway', 4, NULL),
(63, 'Paytm_merchant_id', '', 'Payment_Gateway', 4, NULL),
(64, 'Paytm_merchant_website', 'WEB_STAGING', 'Payment_Gateway', 4, NULL),
(65, 'Paytm_currency_prefix', 'Rs', 'Payment_Gateway', 4, NULL),
(66, 'Paytm_currency_sufix', 'INR', 'Payment_Gateway', 4, NULL),
(67, 'Paytm_conversion', '', 'Payment_Gateway', 4, NULL);

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

--
-- Table structure for table `savsoft_add`
--

CREATE TABLE `savsoft_add` (
  `add_id` int(11) NOT NULL AUTO_INCREMENT,
  `advertisement_code` text NOT NULL,
  `banner` varchar(1000) NOT NULL,
  `banner_link` varchar(1000) DEFAULT NULL,
  `position` varchar(100) NOT NULL,
  `add_status` varchar(100) NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`add_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `savsoft_add`
--

INSERT INTO `savsoft_add` VALUES
(1, '', '1501084226.jpg', 'https://savsoftquiz.com', 'Top', 'Inactive'),
(2, '	', '1501084206.jpg', 'https://savsoftquiz.com', 'Bottom', 'Active'),
(3, '', '1501084197.jpg', 'https://savsoftquiz.com', 'Center_Result', 'Active'),
(4, '', '1501084258.jpg', 'https://savsoftquiz.com', 'During_Quiz', 'Active');

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

--
-- Table structure for table `savsoft_answers`
--

CREATE TABLE `savsoft_answers` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `qid` int(11) NOT NULL,
  `q_option` text NOT NULL,
  `uid` int(11) NOT NULL,
  `score_u` float NOT NULL DEFAULT '0',
  `rid` int(11) NOT NULL,
  `qn` int(11) NOT NULL,
  PRIMARY KEY (`aid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=151 ;

--
-- Dumping data for table `savsoft_answers`
--

INSERT INTO `savsoft_answers` VALUES
(8, 79, '300', 1, 1, 1, 0),
(9, 80, '304', 1, 1, 1, 0),
(10, 81, '317', 1, 0.5, 1, 0),
(11, 81, '319', 1, 0.5, 1, 0),
(15, 81, '317', 1, 0.5, 3, 0),
(16, 79, '302', 1, 0, 3, 0),
(24, 79, '300', 1, 1, 4, 0),
(25, 80, '304', 1, 1, 4, 0),
(26, 81, '317', 1, 0.5, 4, 0),
(27, 81, '319', 1, 0.5, 4, 0),
(34, 79, '300', 1, 1, 5, 0),
(35, 80, '305', 1, 0, 5, 0),
(36, 81, '317', 1, 0.5, 5, 0),
(43, 79, '300', 1, 1, 6, 0),
(44, 80, '305', 1, 0, 6, 0),
(45, 81, '317', 1, 0.5, 6, 0),
(52, 79, '301', 1, 0, 7, 0),
(53, 80, '305', 1, 0, 7, 0),
(54, 81, '318', 1, 0, 7, 0),
(64, 79, '300', 1, 1, 8, 0),
(65, 80, '305', 1, 0, 8, 0),
(66, 81, '318', 1, 0, 8, 0),
(106, 79, '300', 1, 1, 9, 0),
(107, 81, '317', 1, 0.5, 9, 0),
(114, 79, '301', 5, 0, 10, 0),
(115, 80, '306', 5, 0, 10, 0),
(116, 81, '318', 5, 0, 10, 0),
(118, 79, '303', 1, 0, 11, 0),
(120, 79, '303', 1, 0, 12, 0),
(123, 115, '465', 1, 0, 13, 0),
(137, 81, '318', 1, 0, 14, 0),
(138, 79, '302', 1, 0, 14, 0),
(139, 81, '316', 1, 0, 15, 0),
(143, 79, '300', 1, 1, 15, 1),
(144, 81, '317', 1, 0.5, 16, 0),
(145, 81, '319', 1, 0.5, 16, 0),
(146, 79, '301', 13, 0, 17, 0),
(147, 80, '305', 13, 0, 17, 1),
(148, 79, '301', 1, 0, 18, 0),
(150, 80, '306', 1, 0, 18, 1);

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

--
-- Table structure for table `savsoft_category`
--

CREATE TABLE `savsoft_category` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(1000) NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `savsoft_category`
--

INSERT INTO `savsoft_category` VALUES
(1, 'General knowledge'),
(2, 'Math');

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

--
-- Table structure for table `savsoft_group`
--

CREATE TABLE `savsoft_group` (
  `gid` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(1000) NOT NULL,
  `price` float NOT NULL,
  `valid_for_days` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `savsoft_group`
--

INSERT INTO `savsoft_group` VALUES
(1, 'Free', 0, 0, '10 Free quiz'),
(3, 'Premium-1', 100, 90, '100 Quizzes'),
(4, 'Group 3', 2500, 90, 'Unlimites quizzes.\r\nPhone support');

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

--
-- Table structure for table `savsoft_level`
--

CREATE TABLE `savsoft_level` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `level_name` varchar(1000) NOT NULL,
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `savsoft_level`
--

INSERT INTO `savsoft_level` VALUES
(1, 'Easy'),
(2, 'Difficult');

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

--
-- Table structure for table `savsoft_notification`
--

CREATE TABLE `savsoft_notification` (
  `nid` int(11) NOT NULL AUTO_INCREMENT,
  `notification_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `title` varchar(100) DEFAULT NULL,
  `message` varchar(1000) DEFAULT NULL,
  `click_action` varchar(100) DEFAULT NULL,
  `notification_to` varchar(1000) DEFAULT NULL,
  `response` text,
  `uid` int(11) NOT NULL,
  `viewed` int(11) NOT NULL,
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `savsoft_notification`
--

INSERT INTO `savsoft_notification` VALUES
(1, '2019-03-18 06:20:37', 'Developer', 'test', 'http://localhost/savsoftquiz_v5/', '/topics/SavsoftQuiz', '<HTML>\n<HEAD>\n<TITLE>Invalid (legacy) Server-key delivered or Sender is not authorized to perform request.</TITLE>\n</HEAD>\n<BODY BGCOLOR="#FFFFFF" TEXT="#000000">\n<H1>Invalid (legacy) Server-key delivered or Sender is not authorized to perform request.</H1>\n<H2>Error 401</H2>\n</BODY>\n</HTML>\n', 0, 0),
(2, '2019-03-18 12:41:51', 'Developer', 'Helllo', 'http://localhost/savsoftquiz_v5/', '/topics/SavsoftQuiz', '<HTML>\n<HEAD>\n<TITLE>Invalid (legacy) Server-key delivered or Sender is not authorized to perform request.</TITLE>\n</HEAD>\n<BODY BGCOLOR="#FFFFFF" TEXT="#000000">\n<H1>Invalid (legacy) Server-key delivered or Sender is not authorized to perform request.</H1>\n<H2>Error 401</H2>\n</BODY>\n</HTML>\n', 0, 0);

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

--
-- Table structure for table `savsoft_options`
--

CREATE TABLE `savsoft_options` (
  `oid` int(11) NOT NULL AUTO_INCREMENT,
  `qid` int(11) NOT NULL,
  `q_option` text NOT NULL,
  `q_option_match` varchar(1000) DEFAULT NULL,
  `q_option1` text NOT NULL,
  `score` float NOT NULL DEFAULT '0',
  `q_option_match1` text NOT NULL,
  PRIMARY KEY (`oid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=484 ;

--
-- Dumping data for table `savsoft_options`
--

INSERT INTO `savsoft_options` VALUES
(46, 6, 'Good Morning', 'Good Night', '', 0.25, ''),
(47, 6, 'Honda', 'BMW', '', 0.25, ''),
(48, 6, 'Keyboard', 'CPU', '', 0.25, ''),
(49, 6, 'Red', 'Green', '', 0.25, ''),
(51, 7, 'Blue, Sky Blue', NULL, '', 1, ''),
(52, 3, '4', NULL, '', 0.5, ''),
(53, 3, '5', NULL, '', 0, ''),
(54, 3, 'Four', NULL, '', 0.5, ''),
(55, 3, 'Six', NULL, '', 0, ''),
(56, 1, 'Patiala', NULL, '', 0, ''),
(57, 1, 'New Delhi', NULL, '', 1, ''),
(58, 1, 'Chandigarh', NULL, '', 0, ''),
(59, 1, 'Mumbai', NULL, '', 0, ''),
(76, 14, 'A', 'B', '', 0.25, ''),
(77, 14, 'C', 'D', '', 0.25, ''),
(78, 14, 'E', 'F', '', 0.25, ''),
(79, 14, 'G', 'H', '', 0.25, ''),
(81, 15, 'Washington, Washington D.C', NULL, '', 1, ''),
(82, 13, 'five', NULL, '', 0, ''),
(83, 13, '40', NULL, '', 0.5, ''),
(84, 13, 'fourty', NULL, '', 0.5, ''),
(85, 13, 'six', NULL, '', 0, ''),
(86, 12, 'five', NULL, '', 0, ''),
(87, 12, '14', NULL, '', 1, ''),
(88, 12, 'three', NULL, '', 0, ''),
(89, 12, 'six', NULL, '', 0, ''),
(90, 17, '5', NULL, '', 1, ''),
(91, 17, '6', NULL, '', 0, ''),
(92, 17, '7', NULL, '', 0, ''),
(93, 17, '9', NULL, '', 0, ''),
(98, 19, 'sasa', NULL, '', 1, ''),
(99, 19, 'asasas', NULL, '', 0, ''),
(100, 19, 'sasas', NULL, '', 0, ''),
(101, 19, 'asasas', NULL, '', 0, ''),
(102, 20, 'dfgfgfg', NULL, '', 1, ''),
(103, 20, 'jhjhj', NULL, '', 0, ''),
(104, 20, 'lklklk', NULL, '', 0, ''),
(105, 20, 'hghgh', NULL, '', 0, ''),
(106, 21, 'fgdfgfdg', NULL, '', 1, ''),
(107, 21, 'gfdgfdg', NULL, '', 0, ''),
(108, 21, 'deasdsad', NULL, '', 0, ''),
(109, 21, 'gfdgfdgfdg', NULL, '', 0, ''),
(114, 34, 'eop1', NULL, 'hop1', 1, ''),
(115, 34, '', NULL, '', 0, ''),
(116, 34, '', NULL, '', 0, ''),
(117, 34, '', NULL, '', 0, ''),
(158, 22, 'Eop1', NULL, 'Hop1', 0, ''),
(159, 22, '', NULL, '', 1, ''),
(160, 22, '', NULL, '', 0, ''),
(161, 22, '', NULL, '', 0, ''),
(162, 22, 'Eop2', NULL, 'Hop2', 0, ''),
(163, 22, '', NULL, '', 0, ''),
(164, 22, 'Hop2', NULL, '', 0, ''),
(165, 22, '', NULL, '', 0, ''),
(166, 22, 'Eop3', NULL, '', 0, ''),
(167, 22, '', NULL, '', 0, ''),
(168, 22, '', NULL, '', 0, ''),
(169, 22, '', NULL, '', 0, ''),
(170, 22, 'Eop4', NULL, '', 0, ''),
(171, 22, '', NULL, '', 0, ''),
(172, 22, '', NULL, '', 0, ''),
(173, 22, '', NULL, '', 0, ''),
(174, 35, ' 4', NULL, '', 1, ''),
(175, 35, ' 5', NULL, '', 0, ''),
(176, 35, ' 6', NULL, '', 0, ''),
(177, 35, ' 3', NULL, '', 0, ''),
(178, 36, ' 4', NULL, '', 0, ''),
(179, 36, ' 8', NULL, '', 0.5, ''),
(180, 36, ' 6', NULL, '', 0, ''),
(181, 36, ' Eight', NULL, '', 0.5, ''),
(182, 37, ' Osama', NULL, '', 0, ''),
(183, 37, ' Obama', NULL, '', 1, ''),
(184, 37, ' Arvind', NULL, '', 0, ''),
(185, 37, ' Anil', NULL, '', 0, ''),
(186, 38, ' 4', NULL, '', 1, ''),
(187, 38, ' 5', NULL, '', 0, ''),
(188, 38, ' 6', NULL, '', 0, ''),
(189, 38, ' 3', NULL, '', 0, ''),
(190, 39, ' 4', NULL, '', 0, ''),
(191, 39, ' 8', NULL, '', 0.5, ''),
(192, 39, ' 6', NULL, '', 0, ''),
(193, 39, ' Eight', NULL, '', 0.5, ''),
(194, 40, ' Osama', NULL, '', 0, ''),
(195, 40, ' Obama', NULL, '', 1, ''),
(196, 40, ' Arvind', NULL, '', 0, ''),
(197, 40, ' Anil', NULL, '', 0, ''),
(198, 41, ' 4', NULL, ' 4', 1, ''),
(199, 41, ' 5', NULL, ' 5', 0, ''),
(200, 41, ' 6', NULL, ' 6', 0, ''),
(201, 41, ' 3', NULL, ' 3', 0, ''),
(202, 42, ' 4', NULL, '', 1, ''),
(203, 42, ' 5', NULL, '', 0, ''),
(204, 42, ' 6', NULL, '', 0, ''),
(205, 42, ' 3', NULL, '', 0, ''),
(206, 43, ' 4', NULL, '', 0, ''),
(207, 43, ' 8', NULL, '', 0.5, ''),
(208, 43, ' 6', NULL, '', 0, ''),
(209, 43, ' Eight', NULL, '', 0.5, ''),
(210, 44, ' Osama', NULL, '', 0, ''),
(211, 44, ' Obama', NULL, '', 1, ''),
(212, 44, ' Arvind', NULL, '', 0, ''),
(213, 44, ' Anil', NULL, '', 0, ''),
(214, 45, 'five', NULL, '', 0, ''),
(215, 45, 'four', NULL, '', 0.5, ''),
(216, 45, 'four', NULL, '', 0.5, ''),
(217, 45, 'six', NULL, '', 0, ''),
(218, 46, 'A', 'B', '', 0.25, ''),
(219, 46, 'C', 'D', '', 0.25, ''),
(220, 46, 'E', 'F', '', 0.25, ''),
(221, 46, 'G', 'H', '', 0.25, ''),
(222, 47, 'Blue, Sky blue', NULL, '', 0.25, ''),
(223, 49, 'five', NULL, '', 0, ''),
(224, 49, 'four', NULL, '', 0.5, ''),
(225, 49, 'four', NULL, '', 0.5, ''),
(226, 49, 'six', NULL, '', 0, ''),
(227, 50, 'A', 'B', '', 0.25, ''),
(228, 50, 'C', 'D', '', 0.25, ''),
(229, 50, 'E', 'F', '', 0.25, ''),
(230, 50, 'G', 'H', '', 0.25, ''),
(231, 51, 'Blue, Sky blue', NULL, '', 0.25, ''),
(232, 53, 'five', NULL, '', 0, ''),
(233, 53, 'four', NULL, '', 0.5, ''),
(234, 53, 'four', NULL, '', 0.5, ''),
(235, 53, 'six', NULL, '', 0, ''),
(236, 54, 'A', 'B', '', 0.25, ''),
(237, 54, 'C', 'D', '', 0.25, ''),
(238, 54, 'E', 'F', '', 0.25, ''),
(239, 54, 'G', 'H', '', 0.25, ''),
(240, 55, 'Blue, Sky blue', NULL, '', 0.25, ''),
(241, 57, 'five', NULL, '', 0, ''),
(242, 57, 'four', NULL, '', 1, ''),
(243, 57, 'three', NULL, '', 0, ''),
(244, 57, 'six', NULL, '', 0, ''),
(245, 58, 'five', NULL, '', 0, ''),
(246, 58, 'four', NULL, '', 0.5, ''),
(247, 58, 'four', NULL, '', 0.5, ''),
(248, 58, 'six', NULL, '', 0, ''),
(249, 59, 'A', 'B', '', 0.25, ''),
(250, 59, 'C', 'D', '', 0.25, ''),
(251, 59, 'E', 'F', '', 0.25, ''),
(252, 59, 'G', 'H', '', 0.25, ''),
(253, 60, 'Blue, Sky blue', NULL, '', 0.25, ''),
(254, 62, 'five', NULL, '', 0, ''),
(255, 62, 'four', NULL, '', 1, ''),
(256, 62, 'three', NULL, '', 0, ''),
(257, 62, 'six', NULL, '', 0, ''),
(258, 63, 'five', NULL, '', 0, ''),
(259, 63, 'four', NULL, '', 1, ''),
(260, 63, 'three', NULL, '', 0, ''),
(261, 63, 'six', NULL, '', 0, ''),
(262, 66, 'five', NULL, '', 0, ''),
(263, 66, 'four', NULL, '', 1, ''),
(264, 66, 'three', NULL, '', 0, ''),
(265, 66, 'six', NULL, '', 0, ''),
(266, 67, 'five', NULL, '', 0, ''),
(267, 67, 'four', NULL, '', 0.5, ''),
(268, 67, 'four', NULL, '', 0.5, ''),
(269, 67, 'six', NULL, '', 0, ''),
(270, 68, 'A', 'B', '', 0.25, ''),
(271, 68, 'C', 'D', '', 0.25, ''),
(272, 68, 'E', 'F', '', 0.25, ''),
(273, 68, 'G', 'H', '', 0.25, ''),
(274, 69, 'Blue, Sky blue', NULL, '', 0.25, ''),
(275, 71, 'five', NULL, '', 0, ''),
(276, 71, 'four', NULL, '', 1, ''),
(277, 71, 'three', NULL, '', 0, ''),
(278, 71, 'six', NULL, '', 0, ''),
(279, 72, 'five', NULL, '', 0, ''),
(280, 72, 'four', NULL, '', 1, ''),
(281, 72, 'three', NULL, '', 0, ''),
(282, 72, 'six', NULL, '', 0, ''),
(283, 73, 'five', NULL, '', 0, ''),
(284, 73, 'four', NULL, '', 1, ''),
(285, 73, 'three', NULL, '', 0, ''),
(286, 73, 'six', NULL, '', 0, ''),
(287, 74, 'five', NULL, 'five', 0, ''),
(288, 74, 'four', NULL, 'four', 1, ''),
(289, 74, 'three', NULL, 'three', 0, ''),
(290, 74, 'six', NULL, 'six', 0, ''),
(291, 75, 'five', NULL, '', 0, ''),
(292, 75, 'four', NULL, '', 0.5, ''),
(293, 75, 'four', NULL, '', 0.5, ''),
(294, 75, 'six', NULL, '', 0, ''),
(295, 76, 'A', 'B', '', 0.25, ''),
(296, 76, 'C', 'D', '', 0.25, ''),
(297, 76, 'E', 'F', '', 0.25, ''),
(298, 76, 'G', 'H', '', 0.25, ''),
(299, 77, 'Blue, Sky blue', NULL, '', 0.25, ''),
(300, 79, ' 4', NULL, ' 4 second language', 1, ''),
(301, 79, ' 5', NULL, ' 5 second language', 0, ''),
(302, 79, ' 6', NULL, ' 6 second language', 0, ''),
(303, 79, ' 3', NULL, ' 3 second language', 0, ''),
(304, 80, ' 4 second language', NULL, '', 1, ''),
(305, 80, ' 5 second language', NULL, '', 0, ''),
(306, 80, ' 6 second language', NULL, '', 0, ''),
(307, 80, ' 3 second language', NULL, '', 0, ''),
(312, 82, ' Osama', NULL, '', 0, ''),
(313, 82, ' Obama', NULL, '', 1, ''),
(314, 82, ' Arvind', NULL, '', 0, ''),
(315, 82, ' Anil', NULL, '', 0, ''),
(316, 81, ' 4', NULL, '', 0, ''),
(317, 81, ' 8', NULL, '', 0.5, ''),
(318, 81, ' 6', NULL, '', 0, ''),
(319, 81, ' Eight', NULL, '', 0.5, ''),
(448, 111, ' 4', NULL, ' 4 second language', 1, ''),
(449, 111, ' 5', NULL, ' 5 second language', 0, ''),
(450, 111, ' 6', NULL, ' 6 second language', 0, ''),
(451, 111, ' 3', NULL, ' 3 second language', 0, ''),
(452, 112, ' 4 second language', NULL, '', 1, ''),
(453, 112, ' 5 second language', NULL, '', 0, ''),
(454, 112, ' 6 second language', NULL, '', 0, ''),
(455, 112, ' 3 second language', NULL, '', 0, ''),
(456, 113, ' 4', NULL, '', 0, ''),
(457, 113, ' 8', NULL, '', 0.5, ''),
(458, 113, ' 6', NULL, '', 0, ''),
(459, 113, ' Eight', NULL, '', 0.5, ''),
(460, 114, ' Osama', NULL, '', 0, ''),
(461, 114, ' Obama', NULL, '', 1, ''),
(462, 114, ' Arvind', NULL, '', 0, ''),
(463, 114, ' Anil', NULL, '', 0, ''),
(464, 115, ' 4', NULL, ' 4 second language', 1, ''),
(465, 115, ' 5', NULL, ' 5 second language', 0, ''),
(466, 115, ' 6', NULL, ' 6 second language', 0, ''),
(467, 115, ' 3', NULL, ' 3 second language', 0, ''),
(468, 116, ' 4 second language', NULL, '', 1, ''),
(469, 116, ' 5 second language', NULL, '', 0, ''),
(470, 116, ' 6 second language', NULL, '', 0, ''),
(471, 116, ' 3 second language', NULL, '', 0, ''),
(472, 117, ' 4', NULL, '', 0, ''),
(473, 117, ' 8', NULL, '', 0.5, ''),
(474, 117, ' 6', NULL, '', 0, ''),
(475, 117, ' Eight', NULL, '', 0.5, ''),
(480, 118, 'Osama', NULL, '', 0, ''),
(481, 118, 'Obama', NULL, '', 1, ''),
(482, 118, 'Arvind K', NULL, '', 0, ''),
(483, 118, 'Anil', NULL, '', 0, '');

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

--
-- Table structure for table `savsoft_payment`
--

CREATE TABLE `savsoft_payment` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `gid` int(11) NOT NULL,
  `quid` int(11) NOT NULL DEFAULT '0',
  `amount` float NOT NULL,
  `paid_date` int(11) NOT NULL,
  `payment_gateway` varchar(100) NOT NULL DEFAULT 'Paypal',
  `payment_status` varchar(100) NOT NULL DEFAULT 'Pending',
  `transaction_id` varchar(1000) NOT NULL,
  `other_data` text,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `savsoft_payment`
--

INSERT INTO `savsoft_payment` VALUES
(1, 10, 3, 0, 100, 0, 'Paypal', 'Paid', '1233423DCFDFD', NULL);

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

--
-- Table structure for table `savsoft_qbank`
--

CREATE TABLE `savsoft_qbank` (
  `qid` int(11) NOT NULL AUTO_INCREMENT,
  `question_type` varchar(100) NOT NULL DEFAULT 'Multiple Choice Single Answer',
  `question` text NOT NULL,
  `description` text NOT NULL,
  `question1` text,
  `description1` text,
  `cid` int(11) NOT NULL,
  `lid` int(11) NOT NULL,
  `no_time_served` int(11) NOT NULL DEFAULT '0',
  `no_time_corrected` int(11) NOT NULL DEFAULT '0',
  `no_time_incorrected` int(11) NOT NULL DEFAULT '0',
  `no_time_unattempted` int(11) NOT NULL DEFAULT '0',
  `inserted_by` int(11) NOT NULL,
  `inserted_by_name` varchar(100) DEFAULT NULL,
  `paragraph` text,
  `paragraph1` text,
  `parent_id` int(11) NOT NULL,
  PRIMARY KEY (`qid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=119 ;

--
-- Dumping data for table `savsoft_qbank`
--

INSERT INTO `savsoft_qbank` VALUES
(79, 'Multiple Choice Single Answer', ' what is 2+2 =?', ' description here', ' what is 2+2 =? &ndash; This is second language question Note &ndash; keep question number same as its primary language question', ' description here', 1, 1, 55, 16, 15, 24, 0, NULL, NULL, NULL, 0),
(80, 'Multiple Choice Single Answer', ' what is 2+2 =? &ndash; This is second language question Note &ndash; keep question number same as its primary language question', ' description here', NULL, NULL, 1, 1, 21, 2, 10, 9, 0, NULL, NULL, NULL, 0),
(81, 'Multiple Choice Multiple Answer', ' what is 2+6 =?', ' ', NULL, NULL, 2, 1, 48, 13, 19, 16, 0, NULL, NULL, NULL, 0),
(82, 'Multiple Choice Single Answer', ' Who is in the picture?<img src=&#34;http://localhost/savsoftquiz_v4.0_enterprise/upload/word_images/15090303561.jpeg&#34;>', ' ', NULL, NULL, 1, 1, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0),
(111, 'Multiple Choice Single Answer', ' what is 2+2 =?', ' description here', ' what is 2+2 =? &ndash; This is second language question Note &ndash; keep question number same as its primary language question', ' description here', 2, 1, 0, 0, 0, 0, 0, NULL, '', NULL, 0),
(112, 'Multiple Choice Single Answer', ' what is 2+2 =? &ndash; This is second language question Note &ndash; keep question number same as its primary language question', ' description here', NULL, NULL, 2, 1, 0, 0, 0, 0, 0, NULL, '', NULL, 0),
(113, 'Multiple Choice Multiple Answer', ' what is 2+6 =?', ' ', NULL, NULL, 2, 1, 0, 0, 0, 0, 0, NULL, '', NULL, 0),
(114, 'Multiple Choice Single Answer', ' Who is in the picture?<img src=&#34;http://localhost/savsoftquiz_v4.0_enterprise/upload/word_images/15091000591.jpeg&#34;>', ' ', NULL, NULL, 2, 1, 0, 0, 0, 0, 0, NULL, '', NULL, 0),
(115, 'Multiple Choice Single Answer', ' what is 2+2 =?', ' description here', ' what is 2+2 =? &ndash; This is second language question Note &ndash; keep question number same as its primary language question', ' description here', 2, 1, 2, 0, 1, 1, 0, NULL, ' Paragraph here', ' Paragraph here', 0),
(116, 'Multiple Choice Single Answer', ' what is 2+2 =? &ndash; This is second language question Note &ndash; keep question number same as its primary language question', ' description here', NULL, NULL, 2, 1, 0, 0, 0, 0, 0, NULL, ' Paragraph here', NULL, 0),
(117, 'Multiple Choice Multiple Answer', ' what is 2+6 =?', ' ', NULL, NULL, 2, 1, 2, 0, 0, 2, 0, NULL, '', NULL, 0),
(118, 'Multiple Choice Single Answer', 'Who is in the picture?<img src="../../../../savsoftquiz_v4.0_enterprise/upload/word_images/15091002001.jpeg" />', '', NULL, NULL, 2, 1, 2, 0, 0, 2, 0, NULL, NULL, NULL, 0);

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

--
-- Table structure for table `savsoft_qcl`
--

CREATE TABLE `savsoft_qcl` (
  `qcl_id` int(11) NOT NULL AUTO_INCREMENT,
  `quid` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `lid` int(11) NOT NULL,
  `noq` int(11) NOT NULL,
  `i_correct` text NOT NULL,
  `i_incorrect` text NOT NULL,
  PRIMARY KEY (`qcl_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=83 ;

--
-- Dumping data for table `savsoft_qcl`
--

INSERT INTO `savsoft_qcl` VALUES
(80, 2, 1, 1, 3, '1', '0'),
(81, 2, 0, 1, 1, '1', '0'),
(82, 2, 2, 1, 1, '1', '0');

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

--
-- Table structure for table `savsoft_quiz`
--

CREATE TABLE `savsoft_quiz` (
  `quid` int(11) NOT NULL AUTO_INCREMENT,
  `quiz_name` varchar(1000) NOT NULL,
  `description` text NOT NULL,
  `start_date` int(11) NOT NULL,
  `end_date` int(11) NOT NULL,
  `gids` text NOT NULL,
  `qids` text NOT NULL,
  `noq` int(11) NOT NULL,
  `correct_score` text NOT NULL,
  `incorrect_score` text NOT NULL,
  `ip_address` text NOT NULL,
  `duration` int(11) NOT NULL DEFAULT '10',
  `maximum_attempts` int(11) NOT NULL DEFAULT '1',
  `pass_percentage` float NOT NULL DEFAULT '50',
  `view_answer` int(11) NOT NULL DEFAULT '1',
  `camera_req` int(11) NOT NULL DEFAULT '1',
  `question_selection` int(11) NOT NULL DEFAULT '1',
  `gen_certificate` int(11) NOT NULL DEFAULT '0',
  `certificate_text` text,
  `with_login` int(11) NOT NULL DEFAULT '1',
  `quiz_template` varchar(100) NOT NULL DEFAULT 'Default',
  `uids` varchar(1000) DEFAULT NULL,
  `inserted_by` int(11) NOT NULL DEFAULT '1',
  `inserted_by_name` varchar(100) DEFAULT 'Admin',
  `show_chart_rank` int(11) NOT NULL DEFAULT '1',
  `quiz_price` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`quid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `savsoft_quiz`
--

INSERT INTO `savsoft_quiz` VALUES
(6, '1BPS', 'Description here', 1509030367, 1572102367, '1', '81,79', 2, '1,1', '0,0', '', 100, 100, 50, 1, 0, 0, 0, NULL, 1, 'IN', NULL, 1, 'Admin Admin', 1, 0),
(7, 'Quiz - Paid', '', 1511412289, 1574484289, '1', '115,117,118', 3, '1,1,1', '0,0,0', '', 10, 10, 50, 1, 0, 0, 0, NULL, 1, 'Default', NULL, 1, 'Admin Admin', 1, 10),
(8, 'Default Quiz', '', 1511412326, 1606106726, '1,3', '79,80,81', 3, '1,1,1', '-1,-1,-0.5', '', 10, 10, 50, 1, 0, 0, 0, NULL, 0, 'Default', NULL, 1, 'Admin Admin', 1, 0),
(9, 'Quiz 23 March 2018', '', 1555490864, 1556009264, '1', '117,116,115,114', 4, '1,1,1,1', '0,0,0,0', '', 10, 10, 50, 1, 0, 0, 0, NULL, 1, 'Default', NULL, 1, 'Admin Admin', 1, 0);

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

--
-- Table structure for table `savsoft_result`
--

CREATE TABLE `savsoft_result` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `quid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `result_status` varchar(100) NOT NULL DEFAULT 'Open',
  `start_time` int(11) NOT NULL,
  `end_time` int(11) NOT NULL,
  `categories` text NOT NULL,
  `category_range` text NOT NULL,
  `r_qids` text NOT NULL,
  `individual_time` text NOT NULL,
  `total_time` int(11) NOT NULL DEFAULT '0',
  `score_obtained` float NOT NULL DEFAULT '0',
  `percentage_obtained` float NOT NULL DEFAULT '0',
  `attempted_ip` varchar(100) NOT NULL,
  `score_individual` text NOT NULL,
  `photo` varchar(100) NOT NULL,
  `manual_valuation` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `savsoft_result`
--

INSERT INTO `savsoft_result` VALUES
(1, 8, 1, 'Pass', 1511412687, 1511412701, 'General knowledge,Math', '2,1', '79,80,81', '0,6,0', 6, 3, 100, '::1', '1,1,1', '', 0),
(2, 6, 1, 'Fail', 1511413331, 1511413340, 'Math,General knowledge', '1,1', '81,79', '5,0', 5, 0, 0, '::1', '0,0', '', 0),
(3, 6, 1, 'Fail', 1511413356, 1511413383, 'Math,General knowledge', '1,1', '81,79', '0,5', 5, 0, 0, '::1', '2,2', '', 0),
(4, 8, 1, 'Pass', 1513919539, 1513919552, 'General knowledge,Math', '2,1', '79,80,81', '0,4,0', 4, 3, 100, '::1', '1,1,1', '', 0),
(5, 8, 1, 'Fail', 1514276635, 1514276648, 'General knowledge,Math', '2,1', '79,80,81', '0,5,4', 9, 0.5, 5.55556, '::1', '1,2,2', '', 0),
(6, 8, 1, 'Fail', 1514276724, 1514276735, 'General knowledge,Math', '2,1', '79,80,81', '0,5,3', 8, -0.5, -5.55556, '::1', '1,2,2', '', 0),
(7, 8, 1, 'Fail', 1552662063, 1552662225, 'General knowledge,Math', '2,1', '79,80,81', '89,7,0', 96, -2.5, -83.3333, '::1', '2,2,2', '', 0),
(8, 8, 1, 'Fail', 1552669931, 1552669944, 'General knowledge,Math', '2,1', '79,80,81', '0,7,2', 9, -0.5, -16.6667, '::1', '1,2,2', '', 0),
(9, 8, 1, 'Fail', 1552889514, 1552889691, 'General knowledge,Math', '2,1', '79,80,81', '35,43,53', 131, -0.5, -16.6667, '::1', '1,2,2', '', 0),
(10, 8, 5, 'Fail', 1552913410, 1552913423, 'General knowledge,Math', '2,1', '79,80,81', '0,5,0', 5, -2.5, -83.3333, '::1', '2,2,2', '', 0),
(11, 8, 1, 'Fail', 1553771627, 1553771665, 'General knowledge,Math', '2,1', '79,80,81', '0,0,0', 0, -1, -33.3333, '::1', '2,0,0', '', 0),
(12, 8, 1, 'Fail', 1553771675, 1553771682, 'General knowledge,Math', '2,1', '79,80,81', '3,0,0', 3, -1, -33.3333, '::1', '2,0,0', '', 0),
(13, 7, 1, 'Fail', 1556044127, 1556044162, 'Math', '3', '115,117,118', '0,30,0', 30, 0, 0, '::1', '2,0,0', '', 0),
(14, 6, 1, 'Fail', 1556044200, 1556044253, 'Math,General knowledge', '1,1', '81,79', '7,41', 48, 0, 0, '::1', '2,2', '', 0),
(15, 6, 1, 'Pass', 1557312571, 1557313635, 'Math,General knowledge', '1,1', '81,79', '268,760', 1028, 1, 50, '::1', '2,1', '', 0),
(16, 6, 1, 'Pass', 1557313955, 1557314164, 'Math,General knowledge', '1,1', '81,79', '0,205', 205, 1, 50, '::1', '1,0', '', 0),
(17, 8, 13, 'Fail', 1558001409, 1558001423, 'General knowledge,Math', '2,1', '79,80,81', '0,6,0', 6, -2, -66.6667, '::1', '2,2,0', '', 0),
(18, 8, 1, 'Fail', 1558082971, 1558082983, 'General knowledge,Math', '2,1', '79,80,81', '0,3,0', 3, -2, -66.6667, '::1', '2,2,0', '', 0);

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

--
-- Table structure for table `savsoft_users`
--

CREATE TABLE `savsoft_users` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(1000) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `contact_no` varchar(1000) DEFAULT NULL,
  `connection_key` varchar(1000) DEFAULT NULL,
  `gid` varchar(100) NOT NULL DEFAULT '1',
  `su` int(11) NOT NULL DEFAULT '0',
  `inserted_by` int(11) NOT NULL DEFAULT '0',
  `subscription_expired` int(11) NOT NULL DEFAULT '0',
  `verify_code` int(11) NOT NULL DEFAULT '0',
  `wp_user` varchar(100) DEFAULT NULL,
  `registered_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `photo` varchar(1000) DEFAULT NULL,
  `user_status` varchar(100) NOT NULL DEFAULT 'Active',
  `web_token` varchar(1000) DEFAULT NULL,
  `android_token` varchar(1000) DEFAULT NULL,
  `skype_id` varchar(100) DEFAULT NULL,
  `time_zone` varchar(100) DEFAULT 'Asia/Kolkata',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `savsoft_users`
--

INSERT INTO `savsoft_users` VALUES
(1, '[[admin_pass]]', '[[admin_email]]', '[[admin_fname]]', '[[admin_lname]]', '1234567890', NULL, '1', 1, 0, 1776277800, 0, '', '2017-04-20 11:22:38', NULL, 'Active', 'dnwIpQWkxyA:APA91bFZLhdxZnPcNareTyHnJRikJGqaT7qh9DF4jSmyKSOq1rv6k7uwgmaQ4_K7jT3WNNUeKRdRQYsNf_OZaQZ7i5nKI_CjA6QGPwPsL5_D7ShPTtsuIwTkr0CuGx0RS7oAVNg_bImc', NULL, 'sandhu4222', 'Asia/Kolkata'),
(5, 'e10adc3949ba59abbe56e057f20f883e', 'user@example.com', 'Userss', 'User', '1234567890', '123', '1', 2, 0, 2147483647, 0, '', '2017-04-20 11:22:38', NULL, 'Active', NULL, NULL, NULL, 'Asia/Kolkata'),
(6, '21232f297a57a5a743894a0e4a801fc3', 'subadmin@example.com', 'Subadmin', 'Admin', '1234567890', NULL, '1', 1, 0, 1818873000, 0, NULL, '2017-08-24 05:50:57', NULL, 'Active', NULL, NULL, NULL, 'Asia/Kolkata'),
(9, 'e10adc3949ba59abbe56e057f20f883e', 'user2@example.com', 'user2', 'user2', '1234567890', NULL, '1', 2, 0, 0, 0, NULL, '2017-08-25 10:20:10', NULL, 'Active', NULL, NULL, 'sandhu4222', 'Asia/Kolkata'),
(10, '202cb962ac59075b964b07152d234b70', 'user23@gmail.com', 'user', 'user', '1234567890', NULL, '1,3', 2, 0, 0, 0, NULL, '2019-04-24 11:59:24', NULL, 'Active', NULL, NULL, NULL, 'Asia/Kolkata'),
(11, 'e10adc3949ba59abbe56e057f20f883e', 'user@example222.com', 'sandhu', 'laddi', '1234569870', NULL, '1', 2, 0, 0, 9545, NULL, '2019-05-14 07:09:48', NULL, 'Active', NULL, NULL, NULL, 'Asia/Kolkata'),
(12, 'e10adc3949ba59abbe56e057f20f883e', 'contact234@savsoft.info', 'sandhu', 'laddi', '1234567890', NULL, '1', 2, 0, 0, 6023, NULL, '2019-05-14 07:35:12', NULL, 'Active', NULL, NULL, NULL, 'Asia/Kolkata'),
(13, '3d1dfde9304bff15332bf4b308a47b50', '1558001408', 'Guest User', '1558001408', '', NULL, '1', 0, 0, 0, 0, NULL, '2019-05-16 10:10:08', NULL, 'Active', NULL, NULL, NULL, 'Asia/Kolkata');

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

--
-- Table structure for table `savsoft_users_custom`
--

CREATE TABLE `savsoft_users_custom` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `field_id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `field_values` varchar(100) NOT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `savsoft_users_custom`
--

INSERT INTO `savsoft_users_custom` VALUES
(10, 3, 5, '1234567890'),
(17, 1, 9, 'DAV'),
(18, 2, 9, '8529637410'),
(19, 3, 9, '1234567890');

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

--
-- Table structure for table `social_group`
--

CREATE TABLE `social_group` (
  `sg_id` int(11) NOT NULL AUTO_INCREMENT,
  `sg_name` varchar(30) NOT NULL,
  `about` varchar(1000) NOT NULL,
  `sg_status` varchar(100) NOT NULL DEFAULT 'Public',
  `no_member` int(11) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`sg_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `social_group`
--

INSERT INTO `social_group` VALUES
(1, 'Quiz Star', 'Join masters and compare your ranking', 'Public', 3, '2017-08-27 06:45:45', 1),
(3, 'Genius Group', 'Group of genius.. JOIN NOW', 'Public', 2, '2017-08-27 08:11:45', 1);

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

--
-- Table structure for table `social_group_joined`
--

CREATE TABLE `social_group_joined` (
  `join_id` int(11) NOT NULL AUTO_INCREMENT,
  `sg_id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `joined_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`join_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `social_group_joined`
--

INSERT INTO `social_group_joined` VALUES
(3, 1, 1, '2017-08-27 08:06:39'),
(4, 2, 1, '2017-08-27 08:10:20'),
(5, 3, 1, '2017-08-27 08:11:45'),
(9, 3, 9, '2017-08-27 18:29:19'),
(11, 1, 9, '2017-08-27 18:57:03'),
(14, 1, 5, '2017-08-27 20:14:05');

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

--
-- Table structure for table `study_material`
--

CREATE TABLE `study_material` (
  `stid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `study_description` text NOT NULL,
  `gids` varchar(100) NOT NULL,
  `cid` int(11) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL,
  `attachment` varchar(1000) NOT NULL,
  PRIMARY KEY (`stid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `study_material`
--

INSERT INTO `study_material` VALUES
(8, 'GitHub', 'GitHub is a web-based <a title="Git" href="https://en.wikipedia.org/wiki/Git">Git</a> or <a title="Repository (version control)" href="https://en.wikipedia.org/wiki/Repository_(version_control)">version control repository</a> and <a title="Internet hosting service" href="https://en.wikipedia.org/wiki/Internet_hosting_service">Internet hosting service</a>. It is mostly used for code. It offers all of the <a title="Distributed version control" href="https://en.wikipedia.org/wiki/Distributed_version_control">distributed version control</a> and <a class="mw-redirect" title="Source code management" href="https://en.wikipedia.org/wiki/Source_code_management">source code management</a> (SCM) functionality of Git as well as adding its own features. It provides <a title="Access control" href="https://en.wikipedia.org/wiki/Access_control">access control</a> and several collaboration features such as <a title="Bug tracking system" href="https://en.wikipedia.org/wiki/Bug_tracking_system">bug tracking</a>, <a title="Software feature" href="https://en.wikipedia.org/wiki/Software_feature">feature requests</a>, <a title="Task management" href="https://en.wikipedia.org/wiki/Task_management">task management</a>, and<a title="Wiki" href="https://en.wikipedia.org/wiki/Wiki">wikis</a> for every project.<a href="https://en.wikipedia.org/wiki/GitHub#cite_note-hugeinvestment-3">[3]</a>\r\nGitHub offers both plans for private and free <a title="Repository (version control)" href="https://en.wikipedia.org/wiki/Repository_(version_control)">repositories</a> on the same account<a href="https://en.wikipedia.org/wiki/GitHub#cite_note-4">[4]</a> which are commonly used to host <a class="mw-redirect" title="Open-source" href="https://en.wikipedia.org/wiki/Open-source">open-source</a> software projects.<a href="https://en.wikipedia.org/wiki/GitHub#cite_note-5">[5]</a> As of April 2017, GitHub reports having almost 20 million users and 57 million repositories,<a href="https://en.wikipedia.org/wiki/GitHub#cite_note-6">[6]</a>making it the largest host of <a title="Source code" href="https://en.wikipedia.org/wiki/Source_code">source code</a> in the world.<a href="https://en.wikipedia.org/wiki/GitHub#cite_note-7">[7]</a>\r\nGitHub has a <a title="Mascot" href="https://en.wikipedia.org/wiki/Mascot">mascot</a> called Octocat, a cat with five tentacles and a human-like face.<a href="https://en.wikipedia.org/wiki/GitHub#cite_note-Octodex_FAQ-8">[8]</a><a href="https://en.wikipedia.org/wiki/GitHub#cite_note-Jaramillo-9">[9]</a>', '1,3,4', 1, '2017-08-28 19:49:57', 1, '1503949797.pdf');

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

--
-- Table structure for table `warning_message`
--

CREATE TABLE `warning_message` (
  `wid` int(11) NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `warning_time` int(11) NOT NULL,
  `warning_message` varchar(1000) NOT NULL,
  PRIMARY KEY (`wid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=316 ;

--
-- Dumping data for table `warning_message`
--

INSERT INTO `warning_message` VALUES
(1, 5, 1, 1512452823, 'User idle for more than 2 Minutes'),
(2, 5, 1, 1512452833, 'User idle for more than 2 Minutes'),
(3, 6, 1, 1512453042, 'User idle for more than 2 Minutes'),
(4, 6, 1, 1512453193, 'User idle for more than 2 Minutes'),
(5, 6, 1, 1512453463, 'User idle for more than 2 Minutes'),
(6, 6, 1, 1512453922, 'Skipping too many question'),
(7, 6, 1, 1512454045, 'User idle for more than 2 Minutes'),
(8, 9, 1, 1512463053, 'Movement Dedected'),
(9, 9, 1, 1512463067, 'Movement Dedected'),
(10, 9, 1, 1512463068, 'Movement Dedected'),
(11, 9, 1, 1512463072, 'Movement Dedected'),
(12, 9, 1, 1512463073, 'Movement Dedected'),
(13, 9, 1, 1512463079, 'Movement Dedected'),
(14, 9, 1, 1512463112, 'Movement Dedected'),
(15, 9, 1, 1512463138, 'Movement Dedected'),
(16, 9, 1, 1512463147, 'Movement Dedected'),
(17, 9, 1, 1512463148, 'Movement Dedected'),
(18, 9, 1, 1512463153, 'Movement Dedected'),
(19, 9, 1, 1512463177, 'Movement Dedected'),
(20, 9, 1, 1512463200, 'Movement Dedected'),
(21, 9, 1, 1512463201, 'Movement Dedected'),
(22, 9, 1, 1512463202, 'Movement Dedected'),
(23, 9, 1, 1512463206, 'Movement Dedected'),
(24, 9, 1, 1512463256, 'Movement Dedected'),
(25, 9, 1, 1512463257, 'Movement Dedected'),
(26, 9, 1, 1512463264, 'Movement Dedected'),
(27, 9, 1, 1512463269, 'Movement Dedected'),
(28, 9, 1, 1512463270, 'Movement Dedected'),
(29, 9, 1, 1512463316, 'Movement Dedected'),
(30, 9, 1, 1512463317, 'Movement Dedected'),
(31, 9, 1, 1512463325, 'Movement Dedected'),
(32, 9, 1, 1512463326, 'Movement Dedected'),
(33, 9, 1, 1512463335, 'Movement Dedected'),
(34, 9, 1, 1512463336, 'Movement Dedected'),
(35, 9, 1, 1512463341, 'Movement Dedected'),
(36, 9, 1, 1512463355, 'Movement Dedected'),
(37, 9, 1, 1512463403, 'Movement Dedected'),
(38, 9, 1, 1512463409, 'Movement Dedected'),
(39, 9, 1, 1512463410, 'Movement Dedected'),
(40, 9, 1, 1512463431, 'Movement Dedected'),
(41, 9, 1, 1512463432, 'Movement Dedected'),
(42, 9, 1, 1512463434, 'Movement Dedected'),
(43, 9, 1, 1512463435, 'Movement Dedected'),
(44, 9, 1, 1512463436, 'Movement Dedected'),
(45, 9, 1, 1512463437, 'Movement Dedected'),
(46, 9, 1, 1512463450, 'Movement Dedected'),
(47, 9, 1, 1512463451, 'Movement Dedected'),
(48, 9, 1, 1512463462, 'Movement Dedected'),
(49, 9, 1, 1512463467, 'Movement Dedected'),
(50, 9, 1, 1512463499, 'Movement Dedected'),
(51, 9, 1, 1512463500, 'Movement Dedected'),
(52, 9, 1, 1512463501, 'Movement Dedected'),
(53, 9, 1, 1512463503, 'Movement Dedected'),
(54, 9, 1, 1512463505, 'Movement Dedected'),
(55, 9, 1, 1512463506, 'Movement Dedected'),
(56, 9, 1, 1512463513, 'Movement Dedected'),
(57, 9, 1, 1512463515, 'Movement Dedected'),
(58, 9, 1, 1512463523, 'Movement Dedected'),
(59, 9, 1, 1512463525, 'Movement Dedected'),
(60, 9, 1, 1512463526, 'Movement Dedected'),
(61, 9, 1, 1512463530, 'Movement Dedected'),
(62, 9, 1, 1512463531, 'Movement Dedected'),
(63, 9, 1, 1512463543, 'Movement Dedected'),
(64, 9, 1, 1512463544, 'Movement Dedected'),
(65, 9, 1, 1512463551, 'Movement Dedected'),
(66, 9, 1, 1512463555, 'Movement Dedected'),
(67, 9, 1, 1512463556, 'Movement Dedected'),
(68, 9, 1, 1512463559, 'Movement Dedected'),
(69, 9, 1, 1512463560, 'Movement Dedected'),
(70, 9, 1, 1512463562, 'Movement Dedected'),
(71, 9, 1, 1512463563, 'Movement Dedected'),
(72, 9, 1, 1512463564, 'Movement Dedected'),
(73, 9, 1, 1512463565, 'Movement Dedected'),
(74, 9, 1, 1512463594, 'Movement Dedected'),
(75, 9, 1, 1512463597, 'Movement Dedected'),
(76, 9, 1, 1512463605, 'Movement Dedected'),
(77, 9, 1, 1512463606, 'Movement Dedected'),
(78, 9, 1, 1512463643, 'Movement Dedected'),
(79, 9, 1, 1512463691, 'Movement Dedected'),
(80, 9, 1, 1512463699, 'Movement Dedected'),
(81, 9, 1, 1512463700, 'Movement Dedected'),
(82, 9, 1, 1512463740, 'Movement Dedected'),
(83, 9, 1, 1512463747, 'Movement Dedected'),
(84, 9, 1, 1512463751, 'Movement Dedected'),
(85, 9, 1, 1512463759, 'Movement Dedected'),
(86, 9, 1, 1512463797, 'Movement Dedected'),
(87, 9, 1, 1512463803, 'Movement Dedected'),
(88, 9, 1, 1512463816, 'Movement Dedected'),
(89, 9, 1, 1512463819, 'Movement Dedected'),
(90, 9, 1, 1512463835, 'Movement Dedected'),
(91, 9, 1, 1512463846, 'Movement Dedected'),
(92, 9, 1, 1512463847, 'Movement Dedected'),
(93, 9, 1, 1512463848, 'Movement Dedected'),
(94, 9, 1, 1512463851, 'Movement Dedected'),
(95, 9, 1, 1512463852, 'Movement Dedected'),
(96, 9, 1, 1512463904, 'Movement Dedected'),
(97, 9, 1, 1512463907, 'Movement Dedected'),
(98, 9, 1, 1512463908, 'Movement Dedected'),
(99, 9, 1, 1512463912, 'Movement Dedected'),
(100, 9, 1, 1512463914, 'Movement Dedected'),
(101, 9, 1, 1512463973, 'Movement Dedected'),
(102, 9, 1, 1512463984, 'Movement Dedected'),
(103, 9, 1, 1512463991, 'User idle for more than 2 Minutes'),
(104, 9, 1, 1512463998, 'Movement Dedected'),
(105, 9, 1, 1512464037, 'Movement Dedected'),
(106, 9, 1, 1512464045, 'Movement Dedected'),
(107, 9, 1, 1512464053, 'Movement Dedected'),
(108, 9, 1, 1512464061, 'Movement Dedected'),
(109, 9, 1, 1512464082, 'Movement Dedected'),
(110, 9, 1, 1512464095, 'Movement Dedected'),
(111, 9, 1, 1512464103, 'Movement Dedected'),
(112, 9, 1, 1512464107, 'Movement Dedected'),
(113, 9, 1, 1512464111, 'Movement Dedected'),
(114, 9, 1, 1512464150, 'Movement Dedected'),
(115, 9, 1, 1512464159, 'Movement Dedected'),
(116, 9, 1, 1512464187, 'Movement Dedected'),
(117, 9, 1, 1512464195, 'Movement Dedected'),
(118, 9, 1, 1512464207, 'Movement Dedected'),
(119, 9, 1, 1512464238, 'Movement Dedected'),
(120, 9, 1, 1512464354, 'Movement Dedected'),
(121, 9, 1, 1512464371, 'Movement Dedected'),
(122, 9, 1, 1512464391, 'User idle for more than 2 Minutes'),
(123, 9, 1, 1512464424, 'Movement Dedected'),
(124, 9, 1, 1512464425, 'Movement Dedected'),
(125, 9, 1, 1512464426, 'Movement Dedected'),
(126, 9, 1, 1512464427, 'Movement Dedected'),
(127, 9, 1, 1512464428, 'Movement Dedected'),
(128, 9, 1, 1512464429, 'Movement Dedected'),
(129, 9, 1, 1512464430, 'Movement Dedected'),
(130, 9, 1, 1512464433, 'Movement Dedected'),
(131, 9, 1, 1512464434, 'Movement Dedected'),
(132, 9, 1, 1512464435, 'Movement Dedected'),
(133, 9, 1, 1512464438, 'Movement Dedected'),
(134, 9, 1, 1512464440, 'Movement Dedected'),
(135, 9, 1, 1512464441, 'Movement Dedected'),
(136, 9, 1, 1512464442, 'Movement Dedected'),
(137, 9, 1, 1512464445, 'Movement Dedected'),
(138, 9, 1, 1512464446, 'Movement Dedected'),
(139, 9, 1, 1512464448, 'Movement Dedected'),
(140, 9, 1, 1512464449, 'Movement Dedected'),
(141, 9, 1, 1512464450, 'Movement Dedected'),
(142, 9, 1, 1512464451, 'Movement Dedected'),
(143, 9, 1, 1512464456, 'Movement Dedected'),
(144, 9, 1, 1512464457, 'Movement Dedected'),
(145, 9, 1, 1512464458, 'Movement Dedected'),
(146, 9, 1, 1512464460, 'Movement Dedected'),
(147, 9, 1, 1512464462, 'Movement Dedected'),
(148, 9, 1, 1512464463, 'Movement Dedected'),
(149, 9, 1, 1512464464, 'Movement Dedected'),
(150, 9, 1, 1512464465, 'Movement Dedected'),
(151, 9, 1, 1512464569, 'User idle for more than 2 Minutes'),
(152, 9, 1, 1512464758, 'Movement Dedected'),
(153, 9, 1, 1512464759, 'Movement Dedected'),
(154, 9, 1, 1512464791, 'Movement Dedected'),
(155, 9, 1, 1512464914, 'Movement Dedected'),
(156, 9, 1, 1512464915, 'Movement Dedected'),
(157, 9, 1, 1512464916, 'Movement Dedected'),
(158, 9, 1, 1512464930, 'Movement Dedected'),
(159, 9, 1, 1512464931, 'Movement Dedected'),
(160, 9, 1, 1512464932, 'Movement Dedected'),
(161, 9, 1, 1512464938, 'Movement Dedected'),
(162, 9, 1, 1512464939, 'Movement Dedected'),
(163, 9, 1, 1512465228, 'Movement Dedected'),
(164, 9, 1, 1512465237, 'Movement Dedected'),
(165, 9, 1, 1512465238, 'Movement Dedected'),
(166, 9, 1, 1512465246, 'Movement Dedected'),
(167, 9, 1, 1512465252, 'Movement Dedected'),
(168, 9, 1, 1512465254, 'Movement Dedected'),
(169, 9, 1, 1512465294, 'Movement Dedected'),
(170, 9, 1, 1512465295, 'Movement Dedected'),
(171, 9, 1, 1512465298, 'Movement Dedected'),
(172, 9, 1, 1512465324, 'Movement Dedected'),
(173, 9, 1, 1512465325, 'Movement Dedected'),
(174, 9, 1, 1512465326, 'Movement Dedected'),
(175, 9, 1, 1512465683, 'Movement Dedected'),
(176, 9, 1, 1512465684, 'Movement Dedected'),
(177, 9, 1, 1512466260, 'Movement Dedected'),
(178, 9, 1, 1512466265, 'Movement Dedected'),
(179, 9, 1, 1512466266, 'Movement Dedected'),
(180, 9, 1, 1512466267, 'Movement Dedected'),
(181, 9, 1, 1512466268, 'Movement Dedected'),
(182, 9, 1, 1512466269, 'Movement Dedected'),
(183, 9, 1, 1512466270, 'Movement Dedected'),
(184, 9, 1, 1512466271, 'Movement Dedected'),
(185, 9, 1, 1512466279, 'Movement Dedected'),
(186, 9, 1, 1512466280, 'Movement Dedected'),
(187, 9, 1, 1512466281, 'Movement Dedected'),
(188, 9, 1, 1512466282, 'Movement Dedected'),
(189, 9, 1, 1512466286, 'Movement Dedected'),
(190, 9, 1, 1512466287, 'Movement Dedected'),
(191, 9, 1, 1512466288, 'Movement Dedected'),
(192, 9, 1, 1512466289, 'Movement Dedected'),
(193, 9, 1, 1512466290, 'Movement Dedected'),
(194, 9, 1, 1512466292, 'Movement Dedected'),
(195, 9, 1, 1512466293, 'Movement Dedected'),
(196, 9, 1, 1512466295, 'Movement Dedected'),
(197, 9, 1, 1512466296, 'Movement Dedected'),
(198, 9, 1, 1512466297, 'Movement Dedected'),
(199, 9, 1, 1512466305, 'Movement Dedected'),
(200, 9, 1, 1512466312, 'Movement Dedected'),
(201, 9, 1, 1512466314, 'Movement Dedected'),
(202, 9, 1, 1512466338, 'Movement Dedected'),
(203, 9, 1, 1512466344, 'Movement Dedected'),
(204, 9, 1, 1512466359, 'Movement Dedected'),
(205, 9, 1, 1512466364, 'Movement Dedected'),
(206, 9, 1, 1512466364, 'Movement Dedected'),
(207, 9, 1, 1512466365, 'Movement Dedected'),
(208, 9, 1, 1512466369, 'Movement Dedected'),
(209, 9, 1, 1512466371, 'Movement Dedected'),
(210, 9, 1, 1512466372, 'Movement Dedected'),
(211, 9, 1, 1512466373, 'Movement Dedected'),
(212, 9, 1, 1512466380, 'Movement Dedected'),
(213, 9, 1, 1512466381, 'Movement Dedected'),
(214, 9, 1, 1512466382, 'Movement Dedected'),
(215, 9, 1, 1512466386, 'Movement Dedected'),
(216, 9, 1, 1512466390, 'Movement Dedected'),
(217, 9, 1, 1512466395, 'Movement Dedected'),
(218, 9, 1, 1512466396, 'Movement Dedected'),
(219, 9, 1, 1512466399, 'Movement Dedected'),
(220, 9, 1, 1512466406, 'Movement Dedected'),
(221, 9, 1, 1512466407, 'Movement Dedected'),
(222, 9, 1, 1512466414, 'Movement Dedected'),
(223, 9, 1, 1512466417, 'Movement Dedected'),
(224, 9, 1, 1512466426, 'Movement Dedected'),
(225, 9, 1, 1512466441, 'Movement Dedected'),
(226, 9, 1, 1512466442, 'Movement Dedected'),
(227, 9, 1, 1512466446, 'Movement Dedected'),
(228, 9, 1, 1512466484, 'Movement Dedected'),
(229, 9, 1, 1512466484, 'Movement Dedected'),
(230, 9, 1, 1512466485, 'Movement Dedected'),
(231, 9, 1, 1512466486, 'Movement Dedected'),
(232, 9, 1, 1512466529, 'Movement Dedected'),
(233, 9, 1, 1512466540, 'Movement Dedected'),
(234, 9, 1, 1512466570, 'Movement Dedected'),
(235, 9, 1, 1512466576, 'Movement Dedected'),
(236, 9, 1, 1512466577, 'Movement Dedected'),
(237, 9, 1, 1512466584, 'Movement Dedected'),
(238, 9, 1, 1512466585, 'Movement Dedected'),
(239, 9, 1, 1512466591, 'Movement Dedected'),
(240, 9, 1, 1512466598, 'Movement Dedected'),
(241, 9, 1, 1512466599, 'Movement Dedected'),
(242, 9, 1, 1512466600, 'Movement Dedected'),
(243, 9, 1, 1512466605, 'Movement Dedected'),
(244, 9, 1, 1512466606, 'Movement Dedected'),
(245, 9, 1, 1512466608, 'Movement Dedected'),
(246, 9, 1, 1512466621, 'Movement Dedected'),
(247, 9, 1, 1512466628, 'Movement Dedected'),
(248, 9, 1, 1512466629, 'Movement Dedected'),
(249, 9, 1, 1512466641, 'Movement Dedected'),
(250, 9, 1, 1512466642, 'Movement Dedected'),
(251, 9, 1, 1512466648, 'Movement Dedected'),
(252, 9, 1, 1512466654, 'Movement Dedected'),
(253, 9, 1, 1512466655, 'Movement Dedected'),
(254, 9, 1, 1512466656, 'Movement Dedected'),
(255, 9, 1, 1512466657, 'Movement Dedected'),
(256, 9, 1, 1512466658, 'Movement Dedected'),
(257, 9, 1, 1512466665, 'Movement Dedected'),
(258, 9, 1, 1512466666, 'Movement Dedected'),
(259, 9, 1, 1512466667, 'Movement Dedected'),
(260, 9, 1, 1512466668, 'Movement Dedected'),
(261, 9, 1, 1512466669, 'Movement Dedected'),
(262, 9, 1, 1512466670, 'Movement Dedected'),
(263, 9, 1, 1512466725, 'Movement Dedected'),
(264, 9, 1, 1512466727, 'Movement Dedected'),
(265, 9, 1, 1512466728, 'Movement Dedected'),
(266, 9, 1, 1512466730, 'Movement Dedected'),
(267, 9, 1, 1512467110, 'User idle for more than 2 Minutes'),
(268, 9, 1, 1512467183, 'Movement Dedected'),
(269, 9, 1, 1512467194, 'Movement Dedected'),
(270, 9, 1, 1512467195, 'Movement Dedected'),
(271, 9, 1, 1512467197, 'Movement Dedected'),
(272, 9, 1, 1512467198, 'Movement Dedected'),
(273, 9, 1, 1512467206, 'Movement Dedected'),
(274, 9, 1, 1512467207, 'Movement Dedected'),
(275, 9, 1, 1512467235, 'Movement Dedected'),
(276, 9, 1, 1512467236, 'Movement Dedected'),
(277, 9, 1, 1512467253, 'Movement Dedected'),
(278, 14, 1, 1512484327, 'User idle for more than 2 Minutes'),
(279, 16, 1, 1512485794, 'Movement Dedected'),
(280, 16, 1, 1512485795, 'Movement Dedected'),
(281, 16, 1, 1512485796, 'Movement Dedected'),
(282, 16, 1, 1512485797, 'Movement Dedected'),
(283, 16, 1, 1512485952, 'User idle for more than 2 Minutes'),
(284, 17, 1, 1512486854, 'Movement Dedected'),
(285, 17, 1, 1512486854, 'Movement Dedected'),
(286, 17, 1, 1512487447, 'User idle for more than 2 Minutes'),
(287, 17, 1, 1512487717, 'User idle for more than 2 Minutes'),
(288, 17, 1, 1512488508, 'Movement Dedected'),
(289, 17, 1, 1512488517, 'Movement Dedected'),
(290, 18, 1, 1512497185, 'Movement Detected'),
(291, 24, 1, 1512534886, 'Movement Detected'),
(292, 24, 1, 1512534892, 'Movement Detected'),
(293, 24, 1, 1512534905, 'Movement Detected'),
(294, 26, 1, 1512535298, 'Movement Detected'),
(295, 26, 1, 1512535304, 'Movement Detected'),
(296, 26, 1, 1512535319, 'Movement Detected'),
(297, 26, 1, 1512535325, 'Movement Detected'),
(298, 26, 1, 1512535331, 'Movement Detected'),
(299, 27, 1, 1512550651, 'Movement Detected'),
(300, 27, 1, 1512550657, 'Movement Detected'),
(301, 27, 1, 1512550663, 'Movement Detected'),
(302, 27, 1, 1512550678, 'Movement Detected'),
(303, 27, 1, 1512550684, 'Movement Detected'),
(304, 27, 1, 1512550699, 'Movement Detected'),
(305, 27, 1, 1512550705, 'Movement Detected'),
(306, 27, 1, 1512550713, 'Movement Detected'),
(307, 27, 1, 1512550719, 'Movement Detected'),
(308, 27, 1, 1512550729, 'Movement Detected'),
(309, 27, 1, 1512550750, 'Movement Detected'),
(310, 27, 1, 1512550764, 'Movement Detected'),
(311, 27, 1, 1512550770, 'Movement Detected'),
(312, 27, 1, 1512550776, 'Movement Detected'),
(313, 27, 1, 1512550804, 'Movement Detected'),
(314, 27, 1, 1512550858, 'User idle for more than 2 Minutes'),
(315, 27, 1, 1512550904, 'Movement Detected');

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

Cancel