-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `mdisdp`
--

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

--
-- Table structure for table `bdedu_memory_exam_categories`
--

CREATE TABLE `bdedu_memory_exam_categories` (
  `memory_exam_category_row_id` int(11) NOT NULL,
  `module_row_id` int(11) NOT NULL,
  `school_row_id` int(3) DEFAULT NULL,
  `exam_category_name` varchar(255) NOT NULL,
  `exam_category_slug` varchar(255) NOT NULL,
  `icon_name` varchar(255) DEFAULT NULL,
  `is_time_base` tinyint(1) NOT NULL DEFAULT '1',
  `parent_id` int(11) DEFAULT NULL,
  `has_child` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `sort_order` int(3) NOT NULL DEFAULT '1',
  `status` tinyint(1) DEFAULT '1',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bdedu_memory_exam_categories`
--

INSERT INTO `bdedu_memory_exam_categories` (`memory_exam_category_row_id`, `module_row_id`, `school_row_id`, `exam_category_name`, `exam_category_slug`, `icon_name`, `is_time_base`, `parent_id`, `has_child`, `level`, `sort_order`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 'Remembering and Recognition', 'rembering-recognition', NULL, 0, NULL, NULL, NULL, 1, 1, 2, 2, '2019-08-19 14:55:13', '2019-08-19 14:55:13'),
(2, 3, 1, 'Visual Spatial', 'visual-spatial', NULL, 1, NULL, NULL, NULL, 2, 1, 2, 2, '2019-08-19 14:56:24', '2019-08-19 14:56:24'),
(3, 3, 1, 'Operation Span', 'operation-span', NULL, 1, NULL, NULL, NULL, 3, 1, 2, 2, '2019-08-19 14:56:24', '2019-08-19 14:56:24'),
(4, 3, 1, 'Reading Span', 'reading-span', NULL, 1, NULL, NULL, NULL, 4, 1, 2, 2, '2019-08-19 14:56:24', '2019-08-19 14:56:24'),
(5, 3, 1, 'Rotation Span', 'rotation-span', NULL, 1, NULL, NULL, NULL, 5, 1, 2, 2, '2019-08-19 14:56:24', '2019-08-19 14:56:24');

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

--
-- Table structure for table `bdedu_memory_exam_questions`
--

CREATE TABLE `bdedu_memory_exam_questions` (
  `memory_question_row_id` int(11) NOT NULL,
  `education_type_row_id` int(11) NOT NULL,
  `class_row_id` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT 'JSON Format Class',
  `module_row_id` int(11) NOT NULL,
  `school_row_id` int(3) DEFAULT NULL,
  `memory_exam_category_row_id` int(11) NOT NULL,
  `question_type` int(11) NOT NULL COMMENT '1 ~ Multiple Choice, 2 ~ Short Descriptive, 3 ~ Broad Descriptive',
  `question_title` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `question_title_attachment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Image,Audio,Video',
  `question_title_answer` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `question_title_attachment_answer` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `question_level` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '1 ~ Foundation, 2 ~ Intermediate, 3 ~ Advance',
  `question_mimetype` int(3) DEFAULT NULL COMMENT '1 ~ Text Question, 2 ~ Image Question, 3 ~ Audio(MP3) Question, 4 ~ Video(MP4) Question',
  `answer_type` int(3) DEFAULT NULL COMMENT '1 ~ Text Answer, 2 ~ Image Answer',
  `mark_weight` int(3) NOT NULL DEFAULT '1',
  `answer_1` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `answer_2` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `answer_3` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `answer_4` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_correct_answer` int(3) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bdedu_memory_exam_questions`
--

INSERT INTO `bdedu_memory_exam_questions` (`memory_question_row_id`, `education_type_row_id`, `class_row_id`, `module_row_id`, `school_row_id`, `memory_exam_category_row_id`, `question_type`, `question_title`, `question_title_attachment`, `question_title_answer`, `question_title_attachment_answer`, `question_level`, `question_mimetype`, `answer_type`, `mark_weight`, `answer_1`, `answer_2`, `answer_3`, `answer_4`, `is_correct_answer`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566721990_memory_test_2_Q_part_1.png', 'Select the locations of green squares in the diagram', '1566721990_memory_test_Q_part_2.png', 'null', 2, 1, 1, 'a)	[ 6, 2]', '[ 7, 3]', '[ 7, 2]', '[ 1, 3]', 3, 2, NULL, '2019-08-25 08:33:10', '2019-08-25 14:33:10'),
(2, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566722095_memory_test_2_Q_part_1.png', 'Select the locations of Yellow squares in the diagram', '1566722095_memory_test_2_Q_part_2.png', 'null', 2, 1, 1, 'a)	[ 1, 4]', '[8, 3]', '[ 1, 3]', '[ 8, 4]', 4, 2, NULL, '2019-08-25 08:34:55', '2019-08-25 14:34:55'),
(3, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566723248_iq_l1_q11.jpg', 'What is the clock time you see?', NULL, 'null', 2, 1, 1, '5:30 PM', '6:300 PM', '7:30 PM', '11:30 PM', 3, 2, NULL, '2019-08-25 08:54:08', '2019-08-25 14:54:08'),
(4, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566723433_sub_geo_l1_q8.jpg', 'What shape you see?', NULL, 'null', 2, 1, 1, 'Square', 'Rectangle', 'Polygon', 'Right-angled-Triangle', 4, 2, NULL, '2019-08-25 08:57:13', '2019-08-25 14:57:13'),
(5, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566723665_sub_geo_l1_q14.jpg', 'What shape you see in picture?', NULL, 'null', 2, 1, 1, 'Circle', 'Cube', 'Sphare', 'Cylinder', 1, 2, NULL, '2019-08-25 09:01:05', '2019-08-25 15:01:05'),
(6, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566723841_sub_geo_l1_q7.jpg', 'What shape you see in picture?', NULL, 'null', 2, 1, 1, 'Cube', 'Triangle', 'Square', 'Rectangle', 1, 2, NULL, '2019-08-25 09:04:01', '2019-08-25 15:04:01'),
(7, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566724044_diag1_l3_8.jpg', 'What shape see in picture?', NULL, 'null', 2, 1, 1, 'Cylinder', 'Circle', 'Polygon', 'Quadric', 1, 2, NULL, '2019-08-25 09:07:24', '2019-08-25 15:07:24'),
(8, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566725090_memory_apple_question.jpg', 'How Many appel you see in picture?', NULL, 'null', 2, 1, 1, '6', '9', '3', '1', 3, 2, NULL, '2019-08-25 09:24:50', '2019-08-25 15:24:50'),
(9, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566725186_memory_question_3.jpg', 'How many Bannana in picture?', NULL, 'null', 2, 1, 1, '5', '7', '4', '3', 1, 2, NULL, '2019-08-25 09:26:26', '2019-08-25 15:26:26'),
(10, 1, '[\"8\"]', 3, 1, 2, 1, NULL, '1566725280_memory_test_question_6.jpg', 'How many pineappel you see in picture?', NULL, 'null', 2, 1, 1, '3', '5', '1', '2', 3, 2, NULL, '2019-08-25 09:28:00', '2019-08-25 15:28:01');

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

--
-- Table structure for table `bdedu_remembering_questions`
--

CREATE TABLE `bdedu_remembering_questions` (
  `remembering_question_row_id` int(11) NOT NULL,
  `school_row_id` int(11) DEFAULT NULL,
  `education_type_row_id` int(11) NOT NULL,
  `class_row_id` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `module_row_id` int(11) DEFAULT NULL,
  `memory_exam_category_row_id` int(11) DEFAULT NULL,
  `question_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `question_title_attachment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `question_level` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '1 ~ Foundation, 2 ~ Intermediate, 3 ~ Advance',
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `answer_1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `marks_1` int(2) DEFAULT NULL,
  `answer_2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `marks_2` int(2) DEFAULT NULL,
  `answer_3` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `marks_3` int(2) DEFAULT NULL,
  `answer_4` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `marks_4` int(2) DEFAULT NULL,
  `answer_5` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `marks_5` int(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bdedu_remembering_questions`
--

INSERT INTO `bdedu_remembering_questions` (`remembering_question_row_id`, `school_row_id`, `education_type_row_id`, `class_row_id`, `module_row_id`, `memory_exam_category_row_id`, `question_title`, `question_title_attachment`, `question_level`, `updated_by`, `updated_at`, `created_at`, `created_by`, `answer_1`, `marks_1`, `answer_2`, `marks_2`, `answer_3`, `marks_3`, `answer_4`, `marks_4`, `answer_5`, `marks_5`) VALUES
(1, 1, 1, '[\"8\"]', 3, 1, 'Do you have difficulty remembering people&rsquo;s names or phone numbers?', NULL, 'null', NULL, '2019-08-22 12:17:56', '2019-08-22 06:17:56', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(2, 1, 1, '[\"8\"]', 3, 1, 'How often do you find yourself trying to remember the location of everyday items (e. g. your school bags, shoes, books, etc)?', NULL, 'null', NULL, '2019-08-22 12:18:37', '2019-08-22 06:18:37', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(3, 1, 1, '[\"8\"]', 3, 1, 'How often do you have to replace passwords (numerical or verbal) because you&rsquo;ve forgotten the original one?', NULL, 'null', NULL, '2019-08-22 12:19:47', '2019-08-22 06:19:47', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(4, 1, 1, '[\"8\"]', 3, 1, 'How often do you find yourself asking questions like, &ldquo;What was I about to do next&rdquo;?', NULL, 'null', NULL, '2019-08-22 12:20:24', '2019-08-22 06:20:24', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(5, 1, 1, '[\"8\"]', 3, 1, 'How often do you have to ask someone to repeat instructions or a story because you can&rsquo;t remember what was said the first time around?', NULL, 'null', NULL, '2019-08-22 12:22:54', '2019-08-22 06:22:54', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(6, 1, 1, '[\"8\"]', 3, 1, 'How often do maintain dairy/notes to remember the important dates/times (i. e. exam date, birth date, etc)?', NULL, 'null', NULL, '2019-08-22 12:23:25', '2019-08-22 06:23:25', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(7, 1, 1, '[\"8\"]', 3, 1, 'How often do you have trouble finding words when you are talking to?', NULL, 'null', NULL, '2019-08-22 12:23:58', '2019-08-22 06:23:58', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(8, 1, 1, '[\"8\"]', 3, 1, 'How often do you forget the lesson you have just learnt?<br />\r\n&nbsp;', NULL, 'null', NULL, '2019-08-22 12:24:34', '2019-08-22 06:24:34', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(9, 1, 1, '[\"8\"]', 3, 1, 'How often do your family members or friends complaints about your forgetfulness', NULL, 'null', NULL, '2019-08-22 12:24:53', '2019-08-22 06:24:53', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(10, 1, 1, '[\"8\"]', 3, 1, 'How often you get lost in the neighborhood when you visit a new place?', NULL, 'null', NULL, '2019-08-22 12:27:15', '2019-08-22 06:27:15', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(11, 1, 1, '[\"8\"]', 3, 1, 'How often do you understand what the people say?', NULL, 'null', NULL, '2019-08-22 12:27:42', '2019-08-22 06:27:42', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(12, 1, 1, '[\"8\"]', 3, 1, 'How often can you reconcile with your past memories?', NULL, 'null', NULL, '2019-08-22 12:28:24', '2019-08-22 06:28:24', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(13, 1, 1, '[\"8\"]', 3, 1, 'How often do you feel that you are tired / exhausted?', NULL, 'null', NULL, '2019-08-22 12:28:56', '2019-08-22 06:28:56', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(14, 1, 1, '[\"8\"]', 3, 1, 'How often do you remember your friends&rsquo; name when you suddenly meet him after a long time ?', NULL, 'null', NULL, '2019-08-22 12:29:28', '2019-08-22 06:29:28', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5),
(15, 1, 1, '[\"8\"]', 3, 1, 'How often do you remain busy with electronic devices?', NULL, 'null', NULL, '2019-08-22 12:30:11', '2019-08-22 06:30:11', 2, 'Almost always', 1, 'Often', 2, 'Sometimes', 3, 'Rarely', 4, 'Almost never', 5);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bdedu_memory_exam_categories`
--
ALTER TABLE `bdedu_memory_exam_categories`
  ADD PRIMARY KEY (`memory_exam_category_row_id`);

--
-- Indexes for table `bdedu_memory_exam_questions`
--
ALTER TABLE `bdedu_memory_exam_questions`
  ADD PRIMARY KEY (`memory_question_row_id`);

--
-- Indexes for table `bdedu_remembering_questions`
--
ALTER TABLE `bdedu_remembering_questions`
  ADD PRIMARY KEY (`remembering_question_row_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bdedu_memory_exam_categories`
--
ALTER TABLE `bdedu_memory_exam_categories`
  MODIFY `memory_exam_category_row_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `bdedu_memory_exam_questions`
--
ALTER TABLE `bdedu_memory_exam_questions`
  MODIFY `memory_question_row_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `bdedu_remembering_questions`
--
ALTER TABLE `bdedu_remembering_questions`
  MODIFY `remembering_question_row_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
COMMIT;

