Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `savsoft5`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `account_type`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `account_type` (

[20] Fix | Delete

`account_id` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`users` varchar(1000) DEFAULT NULL,

[22] Fix | Delete

`quiz` varchar(1000) DEFAULT NULL,

[23] Fix | Delete

`results` varchar(1000) DEFAULT NULL,

[24] Fix | Delete

`questions` varchar(1000) DEFAULT NULL,

[25] Fix | Delete

`account_name` varchar(1000) DEFAULT NULL,

[26] Fix | Delete

`setting` varchar(100) DEFAULT NULL,

[27] Fix | Delete

`study_material` varchar(1000) NOT NULL,

[28] Fix | Delete

`appointment` varchar(1000) NOT NULL,

[29] Fix | Delete

PRIMARY KEY (`account_id`)

[30] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

[31] Fix | Delete

[32] Fix | Delete

[33] Fix | Delete

-- Dumping data for table `account_type`

[34] Fix | Delete

[35] Fix | Delete

[36] Fix | Delete

INSERT INTO `account_type` VALUES

[37] Fix | Delete

(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'),

[38] Fix | Delete

(2, 'Myaccount', 'Attempt,View,List', 'View,List,Remove', '', 'User', NULL, 'View,List', 'List');

[39] Fix | Delete

[40] Fix | Delete

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

[41] Fix | Delete

[42] Fix | Delete

[43] Fix | Delete

-- Table structure for table `appointment_request`

[44] Fix | Delete

[45] Fix | Delete

[46] Fix | Delete

CREATE TABLE `appointment_request` (

[47] Fix | Delete

`appointment_id` int(11) NOT NULL AUTO_INCREMENT,

[48] Fix | Delete

`request_by` int(11) NOT NULL,

[49] Fix | Delete

`to_id` int(11) NOT NULL,

[50] Fix | Delete

`appointment_timing` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

[51] Fix | Delete

`appointment_time_zone` varchar(100) NOT NULL DEFAULT 'Asia/Kolkata',

[52] Fix | Delete

`appointment_status` varchar(100) NOT NULL DEFAULT 'Pending',

[53] Fix | Delete

PRIMARY KEY (`appointment_id`)

[54] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

[55] Fix | Delete

[56] Fix | Delete

[57] Fix | Delete

-- Dumping data for table `appointment_request`

[58] Fix | Delete

[59] Fix | Delete

[60] Fix | Delete

INSERT INTO `appointment_request` VALUES

[61] Fix | Delete

(2, 9, 1, '2017-08-30 07:53:57', 'Asia/Kolkata', 'Accepted'),

[62] Fix | Delete

(3, 1, 1, '2017-12-27 08:43:25', 'Asia/Kolkata', 'Accepted'),

[63] Fix | Delete

(4, 1, 1, '2019-03-18 06:18:40', 'Asia/Kolkata', 'Accepted'),

[64] Fix | Delete

(5, 5, 1, '2019-03-18 12:50:32', 'Asia/Kolkata', 'Accepted');

[65] Fix | Delete

[66] Fix | Delete

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

[67] Fix | Delete

[68] Fix | Delete

[69] Fix | Delete

-- Table structure for table `ci_sessions`

[70] Fix | Delete

[71] Fix | Delete

[72] Fix | Delete

CREATE TABLE `ci_sessions` (

[73] Fix | Delete

`id` varchar(40) NOT NULL DEFAULT '0',

[74] Fix | Delete

`ip_address` varchar(45) NOT NULL DEFAULT '0',

[75] Fix | Delete

`data` text NOT NULL,

[76] Fix | Delete

`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

[77] Fix | Delete

PRIMARY KEY (`id`)

[78] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[79] Fix | Delete

[80] Fix | Delete

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

[81] Fix | Delete

[82] Fix | Delete

[83] Fix | Delete

-- Table structure for table `savsoftquiz_custom_form`

[84] Fix | Delete

[85] Fix | Delete

[86] Fix | Delete

CREATE TABLE `savsoftquiz_custom_form` (

[87] Fix | Delete

`field_id` int(11) NOT NULL AUTO_INCREMENT,

[88] Fix | Delete

`field_title` varchar(100) NOT NULL,

[89] Fix | Delete

`field_type` varchar(100) NOT NULL DEFAULT 'text',

[90] Fix | Delete

`field_validate` varchar(1000) NOT NULL DEFAULT 'pattern="[A-Za-z0-9]{1,100}"',

[91] Fix | Delete

`field_value` varchar(100) DEFAULT NULL,

[92] Fix | Delete

`display_at` varchar(100) NOT NULL DEFAULT 'Registration',

[93] Fix | Delete

PRIMARY KEY (`field_id`)

[94] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[95] Fix | Delete

[96] Fix | Delete

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

[97] Fix | Delete

[98] Fix | Delete

[99] Fix | Delete

-- Table structure for table `savsoftquiz_setting`

[100] Fix | Delete

[101] Fix | Delete

[102] Fix | Delete

CREATE TABLE `savsoftquiz_setting` (

[103] Fix | Delete

`setting_id` int(11) NOT NULL AUTO_INCREMENT,

[104] Fix | Delete

`setting_name` varchar(1000) NOT NULL,

[105] Fix | Delete

`setting_value` varchar(1000) DEFAULT 'true',

[106] Fix | Delete

`setting_group_name` varchar(100) NOT NULL DEFAULT 'General',

[107] Fix | Delete

`order_by` int(11) NOT NULL,

[108] Fix | Delete

`setting_description` varchar(1000) DEFAULT NULL,

[109] Fix | Delete

PRIMARY KEY (`setting_id`)

[110] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;

[111] Fix | Delete

[112] Fix | Delete

[113] Fix | Delete

-- Dumping data for table `savsoftquiz_setting`

[114] Fix | Delete

[115] Fix | Delete

[116] Fix | Delete

INSERT INTO `savsoftquiz_setting` VALUES

[117] Fix | Delete

(1, 'App_Name', '', 'General', 1, NULL),

[118] Fix | Delete

(2, 'App_title', '', 'General', 1, NULL),

[119] Fix | Delete

(3, 'SMTP_hostname', 'ssl://smtp.gmail.com', 'Email', 2, NULL),

[120] Fix | Delete

(4, 'SMTP_username', '', 'Email', 2, NULL),

[121] Fix | Delete

(5, 'SMTP_password', '', 'Email', 2, NULL),

[122] Fix | Delete

(6, 'SMTP_port', '465', 'Email', 2, NULL),

[123] Fix | Delete

(7, 'Language_direction', 'ltr', 'General', 1, NULL),

[124] Fix | Delete

(8, 'Enable_web_cam', 'true', 'General', 1, NULL),

[125] Fix | Delete

(9, 'Enable_google_chart', 'true', 'General', 1, NULL),

[126] Fix | Delete

(10, 'Enable_dompdf', 'true', 'General', 1, NULL),

[127] Fix | Delete

(11, 'Enable_user_registration', 'true', 'General', 1, NULL),

[128] Fix | Delete

(12, 'Verify_user_email', 'true', 'Email', 2, NULL),

[129] Fix | Delete

(13, 'Tinymce_editor', 'true', 'Editor', 3, NULL),

[130] Fix | Delete

(14, 'Tinymce_eqneditor_plugin', 'true', 'Editor', 3, NULL),

[131] Fix | Delete

(15, 'Tinymce_wiris_plugin', 'true', 'Editor', 3, NULL),

[132] Fix | Delete

(16, 'Mathjax', 'true', 'Editor', 3, NULL),

[133] Fix | Delete

(17, 'Default_group_id', '1', 'General', 1, NULL),

[134] Fix | Delete

(18, 'Enable_open_quiz', 'true', 'General', 1, NULL),

[135] Fix | Delete

(19, 'Enable_sharethis', 'true', 'General', 1, NULL),

[136] Fix | Delete

(20, 'Sharethis_property_id', '', 'General', 1, NULL),

[137] Fix | Delete

(21, 'Advertisement_display_after_seconds', '60', 'General', 1, NULL),

[138] Fix | Delete

(22, 'Advertisement_display_for_seconds', '10', 'General', 1, NULL),

[139] Fix | Delete

(23, 'Android_API_key', '', 'General', 1, NULL),

[140] Fix | Delete

(25, 'Email_protocol', 'mail', 'Email', 2, NULL),

[141] Fix | Delete

(26, 'SMTP_mailtype', 'text', 'Email', 2, NULL),

[142] Fix | Delete

(28, 'Activation_email_subject', 'Action required to verify your account', 'Email', 2, NULL),

[143] Fix | Delete

(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),

[144] Fix | Delete

(30, 'Password_change_subject', 'Password Changed', 'Email', 2, NULL),

[145] Fix | Delete

(31, 'Password_change_message', 'Hi, \\r\\n Your New Password is: [new_password] \\r\\n Thanks', 'Email', 2, NULL),

[146] Fix | Delete

(32, 'Send_result_email', 'true', 'Email', 2, NULL),

[147] Fix | Delete

(33, 'Result_email_subject', 'Result generated for quiz [quiz_name]', 'Email', 2, NULL),

[148] Fix | Delete

(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),

[149] Fix | Delete

(35, 'Master_password', 'savsoftquiz', 'General', 1, NULL),

[150] Fix | Delete

(36, 'Base_currency_prefix', '$', 'Payment_Gateway', 4, NULL),

[151] Fix | Delete

(37, 'Base_currency_sufix', 'USD', 'Payment_Gateway', 4, NULL),

[152] Fix | Delete

(38, 'Payment_gateways', 'paypal,checkout,payumoney,paytm', 'Payment_Gateway', 4, 'Comma separated'),

[153] Fix | Delete

(39, 'Default_gateway', 'paypal', 'Payment_Gateway', 4, NULL),

[154] Fix | Delete

(40, 'Enable_paypal', 'true', 'Payment_Gateway', 4, NULL),

[155] Fix | Delete

(41, 'Paypal_environment', '', 'Payment_Gateway', 4, 'Empty for real or sandbox '),

[156] Fix | Delete

(42, 'Paypal_receiver', '', 'Payment_Gateway', 4, 'Paypal email id'),

[157] Fix | Delete

(43, 'Paypal_currency_prefix', '$', 'Payment_Gateway', 4, NULL),

[158] Fix | Delete

(44, 'Paypal_currency_sufix', 'USD', 'Payment_Gateway', 4, NULL),

[159] Fix | Delete

(45, 'Paypal_conversion', '1', 'Payment_Gateway', 4, '1 if base currency is same'),

[160] Fix | Delete

(46, 'Enable_checkout', 'true', 'Payment_Gateway', 4, NULL),

[161] Fix | Delete

(47, 'Checkout_environment', '', 'Payment_Gateway', 4, NULL),

[162] Fix | Delete

(48, 'Checkout_sid', '', 'Payment_Gateway', 4, NULL),

[163] Fix | Delete

(49, 'Checkout_SecretWord', '', 'Payment_Gateway', 4, ''),

[164] Fix | Delete

(50, 'Checkout_receiver', '', 'Payment_Gateway', 4, NULL),

[165] Fix | Delete

(51, 'Checkout_currency_prefix', '$', 'Payment_Gateway', 4, NULL),

[166] Fix | Delete

(52, 'Checkout_currency_sufix', 'USD', 'Payment_Gateway', 4, NULL),

[167] Fix | Delete

(53, 'Checkout_conversion', '1', 'Payment_Gateway', 4, NULL),

[168] Fix | Delete

(54, 'Enable_payumoney', 'false', 'Payment_Gateway', 4, NULL),

[169] Fix | Delete

(55, 'Payu_merchant_key', '', 'Payment_Gateway', 4, NULL),

[170] Fix | Delete

(56, 'Payu_salt', '', 'Payment_Gateway', 4, NULL),

[171] Fix | Delete

(57, 'Payumoney_currency_prefix', 'Rs', 'Payment_Gateway', 4, NULL),

[172] Fix | Delete

(58, 'Payumoney_currency_sufix', 'INR', 'Payment_Gateway', 4, NULL),

[173] Fix | Delete

(59, 'Payumoney_conversion', '66', 'Payment_Gateway', 4, NULL),

[174] Fix | Delete

(60, 'Enable_paytm', 'false', 'Payment_Gateway', 4, NULL),

[175] Fix | Delete

(61, 'Paytm_environment', 'Test', 'Payment_Gateway', 4, NULL),

[176] Fix | Delete

(62, 'Paytm_merchant_key', '', 'Payment_Gateway', 4, NULL),

[177] Fix | Delete

(63, 'Paytm_merchant_id', '', 'Payment_Gateway', 4, NULL),

[178] Fix | Delete

(64, 'Paytm_merchant_website', 'WEB_STAGING', 'Payment_Gateway', 4, NULL),

[179] Fix | Delete

(65, 'Paytm_currency_prefix', 'Rs', 'Payment_Gateway', 4, NULL),

[180] Fix | Delete

(66, 'Paytm_currency_sufix', 'INR', 'Payment_Gateway', 4, NULL),

[181] Fix | Delete

(67, 'Paytm_conversion', '', 'Payment_Gateway', 4, NULL);

[182] Fix | Delete

[183] Fix | Delete

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

[184] Fix | Delete

[185] Fix | Delete

[186] Fix | Delete

-- Table structure for table `savsoft_add`

[187] Fix | Delete

[188] Fix | Delete

[189] Fix | Delete

CREATE TABLE `savsoft_add` (

[190] Fix | Delete

`add_id` int(11) NOT NULL AUTO_INCREMENT,

[191] Fix | Delete

`advertisement_code` text NOT NULL,

[192] Fix | Delete

`banner` varchar(1000) NOT NULL,

[193] Fix | Delete

`banner_link` varchar(1000) DEFAULT NULL,

[194] Fix | Delete

`position` varchar(100) NOT NULL,

[195] Fix | Delete

`add_status` varchar(100) NOT NULL DEFAULT 'Active',

[196] Fix | Delete

PRIMARY KEY (`add_id`)

[197] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

[198] Fix | Delete

[199] Fix | Delete

[200] Fix | Delete

-- Dumping data for table `savsoft_add`

[201] Fix | Delete

[202] Fix | Delete

[203] Fix | Delete

INSERT INTO `savsoft_add` VALUES

[204] Fix | Delete

(1, '', '1501084226.jpg', 'https://savsoftquiz.com', 'Top', 'Inactive'),

[205] Fix | Delete

(2, ' ', '1501084206.jpg', 'https://savsoftquiz.com', 'Bottom', 'Active'),

[206] Fix | Delete

(3, '', '1501084197.jpg', 'https://savsoftquiz.com', 'Center_Result', 'Active'),

[207] Fix | Delete

(4, '', '1501084258.jpg', 'https://savsoftquiz.com', 'During_Quiz', 'Active');

[208] Fix | Delete

[209] Fix | Delete

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

[210] Fix | Delete

[211] Fix | Delete

[212] Fix | Delete

-- Table structure for table `savsoft_answers`

[213] Fix | Delete

[214] Fix | Delete

[215] Fix | Delete

CREATE TABLE `savsoft_answers` (

[216] Fix | Delete

`aid` int(11) NOT NULL AUTO_INCREMENT,

[217] Fix | Delete

`qid` int(11) NOT NULL,

[218] Fix | Delete

`q_option` text NOT NULL,

[219] Fix | Delete

`uid` int(11) NOT NULL,

[220] Fix | Delete

`score_u` float NOT NULL DEFAULT '0',

[221] Fix | Delete

`rid` int(11) NOT NULL,

[222] Fix | Delete

`qn` int(11) NOT NULL,

[223] Fix | Delete

PRIMARY KEY (`aid`)

[224] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=151 ;

[225] Fix | Delete

[226] Fix | Delete

[227] Fix | Delete

-- Dumping data for table `savsoft_answers`

[228] Fix | Delete

[229] Fix | Delete

[230] Fix | Delete

INSERT INTO `savsoft_answers` VALUES

[231] Fix | Delete

(8, 79, '300', 1, 1, 1, 0),

[232] Fix | Delete

(9, 80, '304', 1, 1, 1, 0),

[233] Fix | Delete

(10, 81, '317', 1, 0.5, 1, 0),

[234] Fix | Delete

(11, 81, '319', 1, 0.5, 1, 0),

[235] Fix | Delete

(15, 81, '317', 1, 0.5, 3, 0),

[236] Fix | Delete

(16, 79, '302', 1, 0, 3, 0),

[237] Fix | Delete

(24, 79, '300', 1, 1, 4, 0),

[238] Fix | Delete

(25, 80, '304', 1, 1, 4, 0),

[239] Fix | Delete

(26, 81, '317', 1, 0.5, 4, 0),

[240] Fix | Delete

(27, 81, '319', 1, 0.5, 4, 0),

[241] Fix | Delete

(34, 79, '300', 1, 1, 5, 0),

[242] Fix | Delete

(35, 80, '305', 1, 0, 5, 0),

[243] Fix | Delete

(36, 81, '317', 1, 0.5, 5, 0),

[244] Fix | Delete

(43, 79, '300', 1, 1, 6, 0),

[245] Fix | Delete

(44, 80, '305', 1, 0, 6, 0),

[246] Fix | Delete

(45, 81, '317', 1, 0.5, 6, 0),

[247] Fix | Delete

(52, 79, '301', 1, 0, 7, 0),

[248] Fix | Delete

(53, 80, '305', 1, 0, 7, 0),

[249] Fix | Delete

(54, 81, '318', 1, 0, 7, 0),

[250] Fix | Delete

(64, 79, '300', 1, 1, 8, 0),

[251] Fix | Delete

(65, 80, '305', 1, 0, 8, 0),

[252] Fix | Delete

(66, 81, '318', 1, 0, 8, 0),

[253] Fix | Delete

(106, 79, '300', 1, 1, 9, 0),

[254] Fix | Delete

(107, 81, '317', 1, 0.5, 9, 0),

[255] Fix | Delete

(114, 79, '301', 5, 0, 10, 0),

[256] Fix | Delete

(115, 80, '306', 5, 0, 10, 0),

[257] Fix | Delete

(116, 81, '318', 5, 0, 10, 0),

[258] Fix | Delete

(118, 79, '303', 1, 0, 11, 0),

[259] Fix | Delete

(120, 79, '303', 1, 0, 12, 0),

[260] Fix | Delete

(123, 115, '465', 1, 0, 13, 0),

[261] Fix | Delete

(137, 81, '318', 1, 0, 14, 0),

[262] Fix | Delete

(138, 79, '302', 1, 0, 14, 0),

[263] Fix | Delete

(139, 81, '316', 1, 0, 15, 0),

[264] Fix | Delete

(143, 79, '300', 1, 1, 15, 1),

[265] Fix | Delete

(144, 81, '317', 1, 0.5, 16, 0),

[266] Fix | Delete

(145, 81, '319', 1, 0.5, 16, 0),

[267] Fix | Delete

(146, 79, '301', 13, 0, 17, 0),

[268] Fix | Delete

(147, 80, '305', 13, 0, 17, 1),

[269] Fix | Delete

(148, 79, '301', 1, 0, 18, 0),

[270] Fix | Delete

(150, 80, '306', 1, 0, 18, 1);

[271] Fix | Delete

[272] Fix | Delete

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

[273] Fix | Delete

[274] Fix | Delete

[275] Fix | Delete

-- Table structure for table `savsoft_category`

[276] Fix | Delete

[277] Fix | Delete

[278] Fix | Delete

CREATE TABLE `savsoft_category` (

[279] Fix | Delete

`cid` int(11) NOT NULL AUTO_INCREMENT,

[280] Fix | Delete

`category_name` varchar(1000) NOT NULL,

[281] Fix | Delete

PRIMARY KEY (`cid`)

[282] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[283] Fix | Delete

[284] Fix | Delete

[285] Fix | Delete

-- Dumping data for table `savsoft_category`

[286] Fix | Delete

[287] Fix | Delete

[288] Fix | Delete

INSERT INTO `savsoft_category` VALUES

[289] Fix | Delete

(1, 'General knowledge'),

[290] Fix | Delete

(2, 'Math');

[291] Fix | Delete

[292] Fix | Delete

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

[293] Fix | Delete

[294] Fix | Delete

[295] Fix | Delete

-- Table structure for table `savsoft_group`

[296] Fix | Delete

[297] Fix | Delete

[298] Fix | Delete

CREATE TABLE `savsoft_group` (

[299] Fix | Delete

`gid` int(11) NOT NULL AUTO_INCREMENT,

[300] Fix | Delete

`group_name` varchar(1000) NOT NULL,

[301] Fix | Delete

`price` float NOT NULL,

[302] Fix | Delete

`valid_for_days` int(11) NOT NULL DEFAULT '0',

[303] Fix | Delete

`description` text NOT NULL,

[304] Fix | Delete

PRIMARY KEY (`gid`)

[305] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

[306] Fix | Delete

[307] Fix | Delete

[308] Fix | Delete

-- Dumping data for table `savsoft_group`

[309] Fix | Delete

[310] Fix | Delete

[311] Fix | Delete

INSERT INTO `savsoft_group` VALUES

[312] Fix | Delete

(1, 'Free', 0, 0, '10 Free quiz'),

[313] Fix | Delete

(3, 'Premium-1', 100, 90, '100 Quizzes'),

[314] Fix | Delete

(4, 'Group 3', 2500, 90, 'Unlimites quizzes.\r\nPhone support');

[315] Fix | Delete

[316] Fix | Delete

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

[317] Fix | Delete

[318] Fix | Delete

[319] Fix | Delete

-- Table structure for table `savsoft_level`

[320] Fix | Delete

[321] Fix | Delete

[322] Fix | Delete

CREATE TABLE `savsoft_level` (

[323] Fix | Delete

`lid` int(11) NOT NULL AUTO_INCREMENT,

[324] Fix | Delete

`level_name` varchar(1000) NOT NULL,

[325] Fix | Delete

PRIMARY KEY (`lid`)

[326] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[327] Fix | Delete

[328] Fix | Delete

[329] Fix | Delete

-- Dumping data for table `savsoft_level`

[330] Fix | Delete

[331] Fix | Delete

[332] Fix | Delete

INSERT INTO `savsoft_level` VALUES

[333] Fix | Delete

(1, 'Easy'),

[334] Fix | Delete

(2, 'Difficult');

[335] Fix | Delete

[336] Fix | Delete

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

[337] Fix | Delete

[338] Fix | Delete

[339] Fix | Delete

-- Table structure for table `savsoft_notification`

[340] Fix | Delete

[341] Fix | Delete

[342] Fix | Delete

CREATE TABLE `savsoft_notification` (

[343] Fix | Delete

`nid` int(11) NOT NULL AUTO_INCREMENT,

[344] Fix | Delete

`notification_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

[345] Fix | Delete

`title` varchar(100) DEFAULT NULL,

[346] Fix | Delete

`message` varchar(1000) DEFAULT NULL,

[347] Fix | Delete

`click_action` varchar(100) DEFAULT NULL,

[348] Fix | Delete

`notification_to` varchar(1000) DEFAULT NULL,

[349] Fix | Delete

`response` text,

[350] Fix | Delete

`uid` int(11) NOT NULL,

[351] Fix | Delete

`viewed` int(11) NOT NULL,

[352] Fix | Delete

PRIMARY KEY (`nid`)

[353] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[354] Fix | Delete

[355] Fix | Delete

[356] Fix | Delete

-- Dumping data for table `savsoft_notification`

[357] Fix | Delete

[358] Fix | Delete

[359] Fix | Delete

INSERT INTO `savsoft_notification` VALUES

[360] Fix | Delete

(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),

[361] Fix | Delete

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

[362] Fix | Delete

[363] Fix | Delete

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

[364] Fix | Delete

[365] Fix | Delete

[366] Fix | Delete

-- Table structure for table `savsoft_options`

[367] Fix | Delete

[368] Fix | Delete

[369] Fix | Delete

CREATE TABLE `savsoft_options` (

[370] Fix | Delete

`oid` int(11) NOT NULL AUTO_INCREMENT,

[371] Fix | Delete

`qid` int(11) NOT NULL,

[372] Fix | Delete

`q_option` text NOT NULL,

[373] Fix | Delete

`q_option_match` varchar(1000) DEFAULT NULL,

[374] Fix | Delete

`q_option1` text NOT NULL,

[375] Fix | Delete

`score` float NOT NULL DEFAULT '0',

[376] Fix | Delete

`q_option_match1` text NOT NULL,

[377] Fix | Delete

PRIMARY KEY (`oid`)

[378] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=484 ;

[379] Fix | Delete

[380] Fix | Delete

[381] Fix | Delete

-- Dumping data for table `savsoft_options`

[382] Fix | Delete

[383] Fix | Delete

[384] Fix | Delete

INSERT INTO `savsoft_options` VALUES

[385] Fix | Delete

(46, 6, 'Good Morning', 'Good Night', '', 0.25, ''),

[386] Fix | Delete

(47, 6, 'Honda', 'BMW', '', 0.25, ''),

[387] Fix | Delete

(48, 6, 'Keyboard', 'CPU', '', 0.25, ''),

[388] Fix | Delete

(49, 6, 'Red', 'Green', '', 0.25, ''),

[389] Fix | Delete

(51, 7, 'Blue, Sky Blue', NULL, '', 1, ''),

[390] Fix | Delete

(52, 3, '4', NULL, '', 0.5, ''),

[391] Fix | Delete

(53, 3, '5', NULL, '', 0, ''),

[392] Fix | Delete

(54, 3, 'Four', NULL, '', 0.5, ''),

[393] Fix | Delete

(55, 3, 'Six', NULL, '', 0, ''),

[394] Fix | Delete

(56, 1, 'Patiala', NULL, '', 0, ''),

[395] Fix | Delete

(57, 1, 'New Delhi', NULL, '', 1, ''),

[396] Fix | Delete

(58, 1, 'Chandigarh', NULL, '', 0, ''),

[397] Fix | Delete

(59, 1, 'Mumbai', NULL, '', 0, ''),

[398] Fix | Delete

(76, 14, 'A', 'B', '', 0.25, ''),

[399] Fix | Delete

(77, 14, 'C', 'D', '', 0.25, ''),

[400] Fix | Delete

(78, 14, 'E', 'F', '', 0.25, ''),

[401] Fix | Delete

(79, 14, 'G', 'H', '', 0.25, ''),

[402] Fix | Delete

(81, 15, 'Washington, Washington D.C', NULL, '', 1, ''),

[403] Fix | Delete

(82, 13, 'five', NULL, '', 0, ''),

[404] Fix | Delete

(83, 13, '40', NULL, '', 0.5, ''),

[405] Fix | Delete

(84, 13, 'fourty', NULL, '', 0.5, ''),

[406] Fix | Delete

(85, 13, 'six', NULL, '', 0, ''),

[407] Fix | Delete

(86, 12, 'five', NULL, '', 0, ''),

[408] Fix | Delete

(87, 12, '14', NULL, '', 1, ''),

[409] Fix | Delete

(88, 12, 'three', NULL, '', 0, ''),

[410] Fix | Delete

(89, 12, 'six', NULL, '', 0, ''),

[411] Fix | Delete

(90, 17, '5', NULL, '', 1, ''),

[412] Fix | Delete

(91, 17, '6', NULL, '', 0, ''),

[413] Fix | Delete

(92, 17, '7', NULL, '', 0, ''),

[414] Fix | Delete

(93, 17, '9', NULL, '', 0, ''),

[415] Fix | Delete

(98, 19, 'sasa', NULL, '', 1, ''),

[416] Fix | Delete

(99, 19, 'asasas', NULL, '', 0, ''),

[417] Fix | Delete

(100, 19, 'sasas', NULL, '', 0, ''),

[418] Fix | Delete

(101, 19, 'asasas', NULL, '', 0, ''),

[419] Fix | Delete

(102, 20, 'dfgfgfg', NULL, '', 1, ''),

[420] Fix | Delete

(103, 20, 'jhjhj', NULL, '', 0, ''),

[421] Fix | Delete

(104, 20, 'lklklk', NULL, '', 0, ''),

[422] Fix | Delete

(105, 20, 'hghgh', NULL, '', 0, ''),

[423] Fix | Delete

(106, 21, 'fgdfgfdg', NULL, '', 1, ''),

[424] Fix | Delete

(107, 21, 'gfdgfdg', NULL, '', 0, ''),

[425] Fix | Delete

(108, 21, 'deasdsad', NULL, '', 0, ''),

[426] Fix | Delete

(109, 21, 'gfdgfdgfdg', NULL, '', 0, ''),

[427] Fix | Delete

(114, 34, 'eop1', NULL, 'hop1', 1, ''),

[428] Fix | Delete

(115, 34, '', NULL, '', 0, ''),

[429] Fix | Delete

(116, 34, '', NULL, '', 0, ''),

[430] Fix | Delete

(117, 34, '', NULL, '', 0, ''),

[431] Fix | Delete

(158, 22, 'Eop1', NULL, 'Hop1', 0, ''),

[432] Fix | Delete

(159, 22, '', NULL, '', 1, ''),

[433] Fix | Delete

(160, 22, '', NULL, '', 0, ''),

[434] Fix | Delete

(161, 22, '', NULL, '', 0, ''),

[435] Fix | Delete

(162, 22, 'Eop2', NULL, 'Hop2', 0, ''),

[436] Fix | Delete

(163, 22, '', NULL, '', 0, ''),

[437] Fix | Delete

(164, 22, 'Hop2', NULL, '', 0, ''),

[438] Fix | Delete

(165, 22, '', NULL, '', 0, ''),

[439] Fix | Delete

(166, 22, 'Eop3', NULL, '', 0, ''),

[440] Fix | Delete

(167, 22, '', NULL, '', 0, ''),

[441] Fix | Delete

(168, 22, '', NULL, '', 0, ''),

[442] Fix | Delete

(169, 22, '', NULL, '', 0, ''),

[443] Fix | Delete

(170, 22, 'Eop4', NULL, '', 0, ''),

[444] Fix | Delete

(171, 22, '', NULL, '', 0, ''),

[445] Fix | Delete

(172, 22, '', NULL, '', 0, ''),

[446] Fix | Delete

(173, 22, '', NULL, '', 0, ''),

[447] Fix | Delete

(174, 35, ' 4', NULL, '', 1, ''),

[448] Fix | Delete

(175, 35, ' 5', NULL, '', 0, ''),

[449] Fix | Delete

(176, 35, ' 6', NULL, '', 0, ''),

[450] Fix | Delete

(177, 35, ' 3', NULL, '', 0, ''),

[451] Fix | Delete

(178, 36, ' 4', NULL, '', 0, ''),

[452] Fix | Delete

(179, 36, ' 8', NULL, '', 0.5, ''),

[453] Fix | Delete

(180, 36, ' 6', NULL, '', 0, ''),

[454] Fix | Delete

(181, 36, ' Eight', NULL, '', 0.5, ''),

[455] Fix | Delete

(182, 37, ' Osama', NULL, '', 0, ''),

[456] Fix | Delete

(183, 37, ' Obama', NULL, '', 1, ''),

[457] Fix | Delete

(184, 37, ' Arvind', NULL, '', 0, ''),

[458] Fix | Delete

(185, 37, ' Anil', NULL, '', 0, ''),

[459] Fix | Delete

(186, 38, ' 4', NULL, '', 1, ''),

[460] Fix | Delete

(187, 38, ' 5', NULL, '', 0, ''),

[461] Fix | Delete

(188, 38, ' 6', NULL, '', 0, ''),

[462] Fix | Delete

(189, 38, ' 3', NULL, '', 0, ''),

[463] Fix | Delete

(190, 39, ' 4', NULL, '', 0, ''),

[464] Fix | Delete

(191, 39, ' 8', NULL, '', 0.5, ''),

[465] Fix | Delete

(192, 39, ' 6', NULL, '', 0, ''),

[466] Fix | Delete

(193, 39, ' Eight', NULL, '', 0.5, ''),

[467] Fix | Delete

(194, 40, ' Osama', NULL, '', 0, ''),

[468] Fix | Delete

(195, 40, ' Obama', NULL, '', 1, ''),

[469] Fix | Delete

(196, 40, ' Arvind', NULL, '', 0, ''),

[470] Fix | Delete

(197, 40, ' Anil', NULL, '', 0, ''),

[471] Fix | Delete

(198, 41, ' 4', NULL, ' 4', 1, ''),

[472] Fix | Delete

(199, 41, ' 5', NULL, ' 5', 0, ''),

[473] Fix | Delete

(200, 41, ' 6', NULL, ' 6', 0, ''),

[474] Fix | Delete

(201, 41, ' 3', NULL, ' 3', 0, ''),

[475] Fix | Delete

(202, 42, ' 4', NULL, '', 1, ''),

[476] Fix | Delete

(203, 42, ' 5', NULL, '', 0, ''),

[477] Fix | Delete

(204, 42, ' 6', NULL, '', 0, ''),

[478] Fix | Delete

(205, 42, ' 3', NULL, '', 0, ''),

[479] Fix | Delete

(206, 43, ' 4', NULL, '', 0, ''),

[480] Fix | Delete

(207, 43, ' 8', NULL, '', 0.5, ''),

[481] Fix | Delete

(208, 43, ' 6', NULL, '', 0, ''),

[482] Fix | Delete

(209, 43, ' Eight', NULL, '', 0.5, ''),

[483] Fix | Delete

(210, 44, ' Osama', NULL, '', 0, ''),

[484] Fix | Delete

(211, 44, ' Obama', NULL, '', 1, ''),

[485] Fix | Delete

(212, 44, ' Arvind', NULL, '', 0, ''),

[486] Fix | Delete

(213, 44, ' Anil', NULL, '', 0, ''),

[487] Fix | Delete

(214, 45, 'five', NULL, '', 0, ''),

[488] Fix | Delete

(215, 45, 'four', NULL, '', 0.5, ''),

[489] Fix | Delete

(216, 45, 'four', NULL, '', 0.5, ''),

[490] Fix | Delete

(217, 45, 'six', NULL, '', 0, ''),

[491] Fix | Delete

(218, 46, 'A', 'B', '', 0.25, ''),

[492] Fix | Delete

(219, 46, 'C', 'D', '', 0.25, ''),

[493] Fix | Delete

(220, 46, 'E', 'F', '', 0.25, ''),

[494] Fix | Delete

(221, 46, 'G', 'H', '', 0.25, ''),

[495] Fix | Delete

(222, 47, 'Blue, Sky blue', NULL, '', 0.25, ''),

[496] Fix | Delete

(223, 49, 'five', NULL, '', 0, ''),

[497] Fix | Delete

(224, 49, 'four', NULL, '', 0.5, ''),

[498] Fix | Delete

(225, 49, 'four', NULL, '', 0.5, ''),

[499] Fix | Delete

12 3