-- Dumping data for table `invoice_settings`
--

INSERT INTO `invoice_settings` (`id`, `per_th`, `prefix`, `student_name`, `student_section`, `student_class`, `student_roll`, `student_group`, `student_admission_no`, `footer_1`, `footer_2`, `footer_3`, `signature_p`, `signature_c`, `signature_o`, `c_signature_p`, `c_signature_c`, `c_signature_o`, `copy_s`, `copy_o`, `copy_c`, `created_at`, `updated_at`, `copy_write_msg`, `created_by`, `updated_by`, `school_id`, `academic_id`) VALUES
(1, 2, 'SPN', 1, 1, 1, 1, 1, 1, 'Parent/Student', 'Casier', 'Officer', 1, 1, 1, 1, 0, 1, 'Parent/Student', 'Office', 'Casier', '2022-02-17 05:10:14', '2022-02-17 05:10:14', NULL, 1, 1, 1, 1);

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `native` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rtl` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `code`, `name`, `native`, `rtl`, `created_at`, `updated_at`, `school_id`) VALUES
(1, 'af', 'Afrikaans', 'Afrikaans', 0, NULL, NULL, 1),
(2, 'am', 'Amharic', 'አማርኛ', 0, NULL, NULL, 1),
(3, 'ar', 'Arabic', 'العربية', 1, NULL, NULL, 1),
(4, 'ay', 'Aymara', 'Aymar', 0, NULL, NULL, 1),
(5, 'az', 'Azerbaijani', 'Azərbaycanca / آذربايجان', 0, NULL, NULL, 1),
(6, 'be', 'Belarusian', 'Беларуская', 0, NULL, NULL, 1),
(7, 'bg', 'Bulgarian', 'Български', 0, NULL, NULL, 1),
(8, 'bi', 'Bislama', 'Bislama', 0, NULL, NULL, 1),
(9, 'bn', 'Bengali', 'বাংলা', 0, NULL, NULL, 1),
(10, 'bs', 'Bosnian', 'Bosanski', 0, NULL, NULL, 1),
(11, 'ca', 'Catalan', 'Català', 0, NULL, NULL, 1),
(12, 'ch', 'Chamorro', 'Chamoru', 0, NULL, NULL, 1),
(13, 'cs', 'Czech', 'Česky', 0, NULL, NULL, 1),
(14, 'da', 'Danish', 'Dansk', 0, NULL, NULL, 1),
(15, 'de', 'German', 'Deutsch', 0, NULL, NULL, 1),
(16, 'dv', 'Divehi', 'ދިވެހިބަސް', 1, NULL, NULL, 1),
(17, 'dz', 'Dzongkha', 'ཇོང་ཁ', 0, NULL, NULL, 1),
(18, 'el', 'Greek', 'Ελληνικά', 0, NULL, NULL, 1),
(19, 'en', 'English', 'English', 0, NULL, NULL, 1),
(20, 'es', 'Spanish', 'Español', 0, NULL, NULL, 1),
(21, 'et', 'Estonian', 'Eesti', 0, NULL, NULL, 1),
(22, 'eu', 'Basque', 'Euskara', 0, NULL, NULL, 1),
(23, 'fa', 'Persian', 'فارسی', 1, NULL, NULL, 1),
(24, 'ff', 'Peul', 'Fulfulde', 0, NULL, NULL, 1),
(25, 'fi', 'Finnish', 'Suomi', 0, NULL, NULL, 1),
(26, 'fj', 'Fijian', 'Na Vosa Vakaviti', 0, NULL, NULL, 1),
(27, 'fo', 'Faroese', 'Føroyskt', 0, NULL, NULL, 1),
(28, 'fr', 'French', 'Français', 0, NULL, NULL, 1),
(29, 'ga', 'Irish', 'Gaeilge', 0, NULL, NULL, 1),
(30, 'gl', 'Galician', 'Galego', 0, NULL, NULL, 1),
(31, 'gn', 'Guarani', 'Avañe\'ẽ', 0, NULL, NULL, 1),
(32, 'gv', 'Manx', 'Gaelg', 0, NULL, NULL, 1),
(33, 'he', 'Hebrew', 'עברית', 1, NULL, NULL, 1),
(34, 'hi', 'Hindi', 'हिन्दी', 0, NULL, NULL, 1),
(35, 'hr', 'Croatian', 'Hrvatski', 0, NULL, NULL, 1),
(36, 'ht', 'Haitian', 'Krèyol ayisyen', 0, NULL, NULL, 1),
(37, 'hu', 'Hungarian', 'Magyar', 0, NULL, NULL, 1),
(38, 'hy', 'Armenian', 'Հայերեն', 0, NULL, NULL, 1),
(39, 'indo', 'Indonesian', 'Bahasa Indonesia', 0, NULL, NULL, 1),
(40, 'is', 'Icelandic', 'Íslenska', 0, NULL, NULL, 1),
(41, 'it', 'Italian', 'Italiano', 0, NULL, NULL, 1),
(42, 'ja', 'Japanese', '日本語', 0, NULL, NULL, 1),
(43, 'ka', 'Georgian', 'ქართული', 0, NULL, NULL, 1),
(44, 'kg', 'Kongo', 'KiKongo', 0, NULL, NULL, 1),
(45, 'kk', 'Kazakh', 'Қазақша', 0, NULL, NULL, 1),
(46, 'kl', 'Greenlandic', 'Kalaallisut', 0, NULL, NULL, 1),
(47, 'km', 'Cambodian', 'ភាសាខ្មែរ', 0, NULL, NULL, 1),
(48, 'ko', 'Korean', '한국어', 0, NULL, NULL, 1),
(49, 'ku', 'Kurdish', 'Kurdî / كوردی', 1, NULL, NULL, 1),
(50, 'ky', 'Kirghiz', 'Kırgızca / Кыргызча', 0, NULL, NULL, 1),
(51, 'la', 'Latin', 'Latina', 0, NULL, NULL, 1),
(52, 'lb', 'Luxembourgish', 'Lëtzebuergesch', 0, NULL, NULL, 1),
(53, 'ln', 'Lingala', 'Lingála', 0, NULL, NULL, 1),
(54, 'lo', 'Laotian', 'ລາວ / Pha xa lao', 0, NULL, NULL, 1),
(55, 'lt', 'Lithuanian', 'Lietuvių', 0, NULL, NULL, 1),
(56, 'lu', '', '', 0, NULL, NULL, 1),
(57, 'lv', 'Latvian', 'Latviešu', 0, NULL, NULL, 1),
(58, 'mg', 'Malagasy', 'Malagasy', 0, NULL, NULL, 1),
(59, 'mh', 'Marshallese', 'Kajin Majel / Ebon', 0, NULL, NULL, 1),
(60, 'mi', 'Maori', 'Māori', 0, NULL, NULL, 1),
(61, 'mk', 'Macedonian', 'Македонски', 0, NULL, NULL, 1),
(62, 'mn', 'Mongolian', 'Монгол', 0, NULL, NULL, 1),
(63, 'ms', 'Malay', 'Bahasa Melayu', 0, NULL, NULL, 1),
(64, 'mt', 'Maltese', 'bil-Malti', 0, NULL, NULL, 1),
(65, 'my', 'Burmese', 'မြန်မာစာ', 0, NULL, NULL, 1),
(66, 'na', 'Nauruan', 'Dorerin Naoero', 0, NULL, NULL, 1),
(67, 'nb', '', '', 0, NULL, NULL, 1),
(68, 'nd', 'North Ndebele', 'Sindebele', 0, NULL, NULL, 1),
(69, 'ne', 'Nepali', 'नेपाली', 0, NULL, NULL, 1),
(70, 'nl', 'Dutch', 'Nederlands', 0, NULL, NULL, 1),
(71, 'nn', 'Norwegian Nynorsk', 'Norsk (nynorsk)', 0, NULL, NULL, 1),
(72, 'no', 'Norwegian', 'Norsk (bokmål / riksmål)', 0, NULL, NULL, 1),
(73, 'nr', 'South Ndebele', 'isiNdebele', 0, NULL, NULL, 1),
(74, 'ny', 'Chichewa', 'Chi-Chewa', 0, NULL, NULL, 1),
(75, 'oc', 'Occitan', 'Occitan', 0, NULL, NULL, 1),
(76, 'pa', 'Panjabi / Punjabi', 'ਪੰਜਾਬੀ / पंजाबी / پنجابي', 0, NULL, NULL, 1),
(77, 'pl', 'Polish', 'Polski', 0, NULL, NULL, 1),
(78, 'ps', 'Pashto', 'پښتو', 1, NULL, NULL, 1),
(79, 'pt', 'Portuguese', 'Português', 0, NULL, NULL, 1),
(80, 'qu', 'Quechua', 'Runa Simi', 0, NULL, NULL, 1),
(81, 'rn', 'Kirundi', 'Kirundi', 0, NULL, NULL, 1),
(82, 'ro', 'Romanian', 'Română', 0, NULL, NULL, 1),
(83, 'ru', 'Russian', 'Русский', 0, NULL, NULL, 1),
(84, 'rw', 'Rwandi', 'Kinyarwandi', 0, NULL, NULL, 1),
(85, 'sg', 'Sango', 'Sängö', 0, NULL, NULL, 1),
(86, 'si', 'Sinhalese', 'සිංහල', 0, NULL, NULL, 1),
(87, 'sk', 'Slovak', 'Slovenčina', 0, NULL, NULL, 1),
(88, 'sl', 'Slovenian', 'Slovenščina', 0, NULL, NULL, 1),
(89, 'sm', 'Samoan', 'Gagana Samoa', 0, NULL, NULL, 1),
(90, 'sn', 'Shona', 'chiShona', 0, NULL, NULL, 1),
(91, 'so', 'Somalia', 'Soomaaliga', 0, NULL, NULL, 1),
(92, 'sq', 'Albanian', 'Shqip', 0, NULL, NULL, 1),
(93, 'sr', 'Serbian', 'Српски', 0, NULL, NULL, 1),
(94, 'ss', 'Swati', 'SiSwati', 0, NULL, NULL, 1),
(95, 'st', 'Southern Sotho', 'Sesotho', 0, NULL, NULL, 1),
(96, 'sv', 'Swedish', 'Svenska', 0, NULL, NULL, 1),
(97, 'sw', 'Swahili', 'Kiswahili', 0, NULL, NULL, 1),
(98, 'ta', 'Tamil', 'தமிழ்', 0, NULL, NULL, 1),
(99, 'tg', 'Tajik', 'Тоҷикӣ', 0, NULL, NULL, 1),
(100, 'th', 'Thai', 'ไทย / Phasa Thai', 0, NULL, NULL, 1),
(101, 'ti', 'Tigrinya', 'ትግርኛ', 0, NULL, NULL, 1),
(102, 'tk', 'Turkmen', 'Туркмен / تركمن', 0, NULL, NULL, 1),
(103, 'tn', 'Tswana', 'Setswana', 0, NULL, NULL, 1),
(104, 'to', 'Tonga', 'Lea Faka-Tonga', 0, NULL, NULL, 1),
(105, 'tr', 'Turkish', 'Türkçe', 0, NULL, NULL, 1),
(106, 'ts', 'Tsonga', 'Xitsonga', 0, NULL, NULL, 1),
(107, 'uk', 'Ukrainian', 'Українська', 0, NULL, NULL, 1),
(108, 'ur', 'Urdu', 'اردو', 1, NULL, NULL, 1),
(109, 'uz', 'Uzbek', 'Ўзбек', 0, NULL, NULL, 1),
(110, 've', 'Venda', 'Tshivenḓa', 0, NULL, NULL, 1),
(111, 'vi', 'Vietnamese', 'Tiếng Việt', 0, NULL, NULL, 1),
(112, 'xh', 'Xhosa', 'isiXhosa', 0, NULL, NULL, 1),
(113, 'zh', 'Chinese', '中文', 0, NULL, NULL, 1),
(114, 'zu', 'Zulu', 'isiZulu', 0, NULL, NULL, 1);

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

--
-- Table structure for table `lesson_planners`
--

CREATE TABLE `lesson_planners` (
  `id` int(10) UNSIGNED NOT NULL,
  `day` int(11) DEFAULT NULL COMMENT '1=sat,2=sun,7=fri',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lesson_id` int(11) DEFAULT NULL,
  `topic_id` int(11) DEFAULT NULL,
  `lesson_detail_id` int(11) NOT NULL,
  `topic_detail_id` int(11) NOT NULL,
  `sub_topic` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lecture_youube_link` text COLLATE utf8mb4_unicode_ci,
  `lecture_vedio` text COLLATE utf8mb4_unicode_ci,
  `attachment` text COLLATE utf8mb4_unicode_ci,
  `teaching_method` text COLLATE utf8mb4_unicode_ci,
  `general_objectives` text COLLATE utf8mb4_unicode_ci,
  `previous_knowlege` text COLLATE utf8mb4_unicode_ci,
  `comp_question` text COLLATE utf8mb4_unicode_ci,
  `zoom_setup` text COLLATE utf8mb4_unicode_ci,
  `presentation` text COLLATE utf8mb4_unicode_ci,
  `note` text COLLATE utf8mb4_unicode_ci,
  `lesson_date` date NOT NULL,
  `competed_date` date DEFAULT NULL,
  `completed_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_id` int(10) UNSIGNED DEFAULT NULL,
  `teacher_id` int(10) UNSIGNED DEFAULT NULL,
  `class_period_id` int(10) UNSIGNED DEFAULT NULL,
  `subject_id` int(10) UNSIGNED DEFAULT NULL,
  `class_id` int(10) UNSIGNED DEFAULT NULL,
  `section_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `routine_id` int(10) UNSIGNED DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `library_subjects`
--

CREATE TABLE `library_subjects` (
  `id` int(10) UNSIGNED NOT NULL,
  `subject_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sb_category_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'T',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `menu_manages`
--

CREATE TABLE `menu_manages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `parent_position_no` int(11) DEFAULT '0',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `child_id` int(11) DEFAULT '0',
  `child_position_no` int(11) DEFAULT '0',
  `child_active_status` tinyint(4) NOT NULL DEFAULT '1',
  `role_id` int(10) UNSIGNED DEFAULT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_11_01_000001_create_sm_schools_table', 1),
(2, '2014_11_01_000021_create_sm_academic_years_table', 1),
(3, '2014_11_12_100000_create_password_resets_table', 1),
(4, '2014_11_13_000003_create_statuses_table', 1),
(5, '2014_12_01_000001_create_infix_roles_table', 1),
(6, '2014_12_01_000002_create_roles_table', 1),
(7, '2014_12_01_000003_create_users_table', 1),
(8, '2014_12_01_000004_create_sm_base_groups_table', 1),
(9, '2014_12_01_000005_create_sm_base_setups_table', 1),
(10, '2014_12_01_000006_create_sm_classes_table', 1),
(11, '2014_12_01_000007_create_sm_sections_table', 1),
(12, '2014_12_01_000008_create_sm_class_sections_table', 1),
(13, '2014_12_01_000009_create_sm_subjects_table', 1),
(14, '2014_12_01_000010_create_sm_visitors_table', 1),
(15, '2014_12_01_000011_create_sm_fees_groups_table', 1),
(16, '2014_12_01_000012_create_sm_fees_types_table', 1),
(17, '2014_12_01_000013_create_sm_fees_discounts_table', 1),
(18, '2014_12_01_000014_create_sm_income_heads_table', 1),
(19, '2014_12_01_000015_create_sm_chart_of_accounts_table', 1),
(20, '2014_12_01_000016_create_sm_bank_accounts_table', 1),
(21, '2014_12_01_000017_create_sm_payment_gateway_settings_table', 1),
(22, '2014_12_01_000018_create_sm_payment_methhods_table', 1),
(23, '2014_12_01_000019_create_sm_add_incomes_table', 1),
(24, '2014_12_01_000020_create_sm_student_groups_table', 1),
(25, '2014_12_01_000022_create_sm_sessions_table', 1),
(26, '2014_12_01_000023_create_sm_dormitory_lists_table', 1),
(27, '2014_12_01_000024_create_sm_room_types_table', 1),
(28, '2014_12_01_000025_create_sm_room_lists_table', 1),
(29, '2014_12_01_000026_create_sm_designations_table', 1),
(30, '2014_12_01_000027_create_sm_human_departments_table', 1),
(31, '2014_12_01_000028_create_sm_staffs_table', 1),
(32, '2014_12_01_000029_create_sm_vehicles_table', 1),
(33, '2014_12_01_000030_create_sm_routes_table', 1),
(34, '2014_12_01_000031_create_sm_instructions_table', 1),
(35, '2014_12_01_000032_create_sm_question_levels_table', 1),
(36, '2014_12_01_000033_create_sm_question_groups_table', 1),
(37, '2014_12_01_000034_create_sm_question_banks_table', 1),
(38, '2014_12_01_000035_create_sm_online_exams_table', 1),
(39, '2014_12_01_000036_create_sm_exam_types_table', 1),
(40, '2014_12_01_000037_create_sm_marks_grades_table', 1),
(41, '2014_12_01_000038_create_sm_exams_table', 1),
(42, '2014_12_01_000039_create_sm_hourly_rates_table', 1),
(43, '2014_12_01_000040_create_sm_leave_types_table', 1),
(44, '2014_12_01_000041_create_sm_leave_defines_table', 1),
(45, '2014_12_01_000042_create_sm_leave_requests_table', 1),
(46, '2014_12_01_000043_create_sm_expense_heads_table', 1),
(47, '2014_12_01_000044_create_sm_add_expenses_table', 1),
(48, '2014_12_01_000045_create_sm_fees_masters_table', 1),
(49, '2014_12_01_000046_create_sm_setup_admins_table', 1),
(50, '2014_12_01_000047_create_sm_complaints_table', 1),
(51, '2014_12_01_000048_create_sm_postal_receives_table', 1),
(52, '2014_12_01_000049_create_sm_postal_dispatches_table', 1),
(53, '2014_12_01_000050_create_sm_phone_call_logs_table', 1),
(54, '2014_12_01_000051_create_sm_student_categories_table', 1),
(55, '2014_12_01_000052_create_sm_parents_table', 1),
(56, '2014_12_01_000054_create_sm_students_table', 1),
(57, '2014_12_01_000055_create_sm_student_attendances_table', 1),
(58, '2014_12_01_000056_create_sm_student_promotions_table', 1),
(59, '2014_12_01_000057_create_sm_staff_attendences_table', 1),
(60, '2014_12_01_000058_create_sm_student_homeworks_table', 1),
(61, '2014_12_01_000059_create_sm_teacher_upload_contents_table', 1),
(62, '2014_12_01_000060_create_sm_hr_salary_templates_table', 1),
(63, '2014_12_01_000061_create_sm_hr_payroll_generates_table', 1),
(64, '2014_12_01_000062_create_sm_exam_marks_registers_table', 1),
(65, '2014_12_01_000063_create_sm_marks_send_sms_table', 1),
(66, '2014_12_01_000064_create_sm_class_routines_table', 1),
(67, '2014_12_01_000064_create_sm_class_times_table', 1),
(68, '2014_12_01_000065_create_languages_table', 1),
(69, '2014_12_01_000065_create_sm_assign_subjects_table', 1),
(70, '2014_12_01_000066_create_sm_modules_table', 1),
(71, '2014_12_01_000067_create_sm_languages_table', 1),
(72, '2014_12_01_000068_create_sm_date_formats_table', 1),
(73, '2014_12_01_000069_create_sm_news_categories_table', 1),
(74, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(75, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(76, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(77, '2016_06_01_000004_create_oauth_clients_table', 1),
(78, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(79, '2018_08_08_100000_create_telescope_entries_table', 1),
(80, '2018_12_04_050352_create_sm_notice_boards_table', 1),
(81, '2018_12_04_051648_create_sm_send_messages_table', 1),
(82, '2018_12_04_060828_create_sm_events_table', 1),
(83, '2018_12_04_062330_create_sm_holidays_table', 1),
(84, '2018_12_04_062714_create_sm_book_categories_table', 1),
(85, '2018_12_04_063012_create_sm_books_table', 1),
(86, '2018_12_04_075138_create_sm_library_members_table', 1),
(87, '2018_12_04_075911_create_sm_book_issues_table', 1),
(88, '2018_12_13_093741_create_sm_fees_carry_forwards_table', 1),
(89, '2018_12_17_104146_create_sm_fees_assigns_table', 1),
(90, '2018_12_17_111529_create_sm_hr_payroll_earn_deducs_table', 1),
(91, '2018_12_20_064256_create_sm_fees_assign_discounts_table', 1),
(92, '2018_12_20_090159_create_sm_fees_payments_table', 1),
(93, '2018_12_24_052328_create_sm_homeworks_table', 1),
(94, '2018_12_26_084518_create_sm_homework_students_table', 1),
(95, '2018_12_28_054159_create_sm_upload_contents_table', 1),
(96, '2018_12_28_075918_create_sm_content_types_table', 1),
(97, '2018_12_28_122146_create_sm_assign_class_teachers_table', 1),
(98, '2018_12_28_122205_create_sm_class_teachers_table', 1),
(99, '2018_12_31_112538_create_sm_exam_schedules_table', 1),
(100, '2018_12_31_112600_create_sm_exam_schedule_subjects_table', 1),
(101, '2019_01_02_061148_create_sm_marks_registers_table', 1),
(102, '2019_01_02_061238_create_sm_marks_register_children_table', 1),
(103, '2019_01_03_105718_create_sm_class_rooms_table', 1),
(104, '2019_01_06_060144_create_sm_seat_plans_table', 1),
(105, '2019_01_06_060213_create_sm_seat_plan_children_table', 1),
(106, '2019_01_07_132108_create_sm_exam_attendances_table', 1),
(107, '2019_01_07_132220_create_sm_exam_attendance_children_table', 1),
(108, '2019_01_09_101421_create_sm_online_exam_questions_table', 1),
(109, '2019_01_09_101533_create_sm_online_exam_question_mu_options_table', 1),
(110, '2019_01_10_050231_create_sm_item_categories_table', 1),
(111, '2019_01_10_050645_create_sm_items_table', 1),
(112, '2019_01_10_054622_create_sm_item_stores_table', 1),
(113, '2019_01_10_070859_create_sm_suppliers_table', 1),
(114, '2019_01_10_112518_create_sm_item_receives_table', 1),
(115, '2019_01_12_104449_create_sm_item_receive_children_table', 1),
(116, '2019_01_13_113100_create_sm_online_exam_marks_table', 1),
(117, '2019_01_14_061003_create_sm_assign_vehicles_table', 1),
(118, '2019_01_16_065238_create_sm_module_links_table', 1),
(119, '2019_01_19_094137_create_sm_inventory_payments_table', 1),
(120, '2019_01_21_063031_create_sm_student_excel_formats_table', 1),
(121, '2019_01_21_131008_create_sm_item_sells_table', 1),
(122, '2019_01_22_104243_create_sm_item_sell_children_table', 1),
(123, '2019_01_23_121931_create_sm_item_issues_table', 1),
(124, '2019_01_26_054046_create_sm_sms_gateways_table', 1),
(125, '2019_01_30_122524_create_sm_student_documents_table', 1),
(126, '2019_01_31_052142_create_sm_student_timelines_table', 1),
(127, '2019_01_31_101401_create_sm_question_bank_mu_options_table', 1),
(128, '2019_02_02_043028_create_sm_online_exam_question_assigns_table', 1),
(129, '2019_02_02_112647_create_sm_student_take_online_exams_table', 1),
(130, '2019_02_02_112719_create_sm_student_take_online_exam_questions_table', 1),
(131, '2019_02_02_115540_create_sm_student_take_onln_ex_ques_options_table', 1),
(132, '2019_02_09_050800_create_sm_email_sms_logs_table', 1),
(133, '2019_02_10_125119_create_sm_general_settings_table', 1),
(134, '2019_02_11_093834_create_sm_user_logs_table', 1),
(135, '2019_02_12_064024_create_sm_email_settings_table', 1),
(136, '2019_02_16_082050_create_sm_student_certificates_table', 1),
(137, '2019_02_17_124203_create_sm_student_id_cards_table', 1),
(138, '2019_02_24_124115_create_sm_to_dos_table', 1),
(139, '2019_03_13_075602_create_sm_admission_queries_table', 1),
(140, '2019_03_14_075324_create_sm_admission_query_followups_table', 1),
(141, '2019_04_04_124508_create_sm_backups_table', 1),
(142, '2019_04_10_054237_create_sm_temporary_meritlists', 1),
(143, '2019_04_13_062212_create_sm_exam_setups_table', 1),
(144, '2019_04_15_055616_create_sm_mark_stores_table', 1),
(145, '2019_04_17_101844_create_sm_result_stores_table', 1),
(146, '2019_04_21_071626_create_sm_class_routine_updates_table', 1),
(147, '2019_04_23_051315_create_sm_weekends_table', 1),
(148, '2019_04_25_164649_create_sm_countries_table', 1),
(149, '2019_04_27_121353_create_sm_language_phrases_table', 1),
(150, '2019_04_28_074534_create_sm_notifications_table', 1),
(151, '2019_04_30_181622_create_continents_table', 1),
(152, '2019_04_30_181730_create_countries_table', 1),
(153, '2019_05_07_103627_create_sm_currencies_table', 1),
(154, '2019_05_26_095459_create_sm_news_table', 1),
(155, '2019_05_27_103844_create_sm_testimonials_table', 1),
(156, '2019_06_01_113053_create_sm_contact_pages_table', 1),
(157, '2019_06_01_165107_create_sm_contact_messages_table', 1),
(158, '2019_06_10_155041_create_sm_product_purchases_table', 1),
(159, '2019_06_11_112109_create_sm_about_pages_table', 1),
(160, '2019_06_12_143430_create_sm_courses_table', 1),
(161, '2019_07_17_182142_create_sm_dashboard_settings_table', 1),
(162, '2019_07_18_141858_create_sm_background_settings_table', 1),
(163, '2019_07_20_151115_create_sm_custom_links_table', 1),
(164, '2019_07_20_183407_create_sm_frontend_persmissions_table', 1),
(165, '2019_07_21_110814_create_sm_home_page_settings_table', 1),
(166, '2019_09_01_171428_create_sm_system_versions_table', 1),
(167, '2019_09_06_113029_create_continets_table', 1),
(168, '2019_09_09_142112_create_sm_styles_table', 1),
(169, '2019_09_25_183656_create_sm_module_permissions_table', 1),
(170, '2019_09_26_115256_create_sm_module_permission_assigns_table', 1),
(171, '2019_10_16_160104_create_sm_time_zones_table', 1),
(172, '2019_11_27_120508_create_sm_student_attendance_imports_table', 1),
(173, '2019_11_27_181351_create_sm_staff_attendance_imports_table', 1),
(174, '2020_01_23_125935_create_sm_optional_subject_assigns_table', 1),
(175, '2020_01_26_112215_create_sm_class_optional_subject', 1),
(176, '2020_01_28_103859_create_sm_news_pages_table', 1),
(177, '2020_01_28_121210_create_sm_course_pages_table', 1),
(178, '2020_01_29_110503_create_sm_subject_attendances_table', 1),
(179, '2020_02_05_105739_create_custom_result_settings_table', 1),
(180, '2020_02_05_131307_create_sm_custom_temporary_results_table', 1),
(181, '2020_03_09_153421_create_sm_add_ons_table', 1),
(182, '2020_03_14_123955_create_sms_templates_table', 1),
(183, '2020_03_21_200226_create_sm_social_media_icons_table', 1),
(184, '2020_03_29_102518_create_sm_upload_homework_contents_table', 1),
(185, '2020_04_01_060324_create_jobs_table', 1),
(186, '2020_04_11_141636_create_infix_module_infos_table', 1),
(187, '2020_04_12_125728_create_infix_permission_assigns_table', 1),
(188, '2020_04_16_064434_create_infix_module_student_parent_infos_table', 1),
(189, '2020_06_10_193309_create_infix_module_managers_table', 1),
(190, '2020_06_17_091643_create_student_bulk_temporaries_table', 1),
(191, '2020_06_22_120034_create_student_attendance_bulks_table', 1),
(192, '2020_06_26_144311_create_library_subjects_table', 1),
(193, '2020_07_14_052504_create_sm_bank_payment_slips_table', 1),
(194, '2020_08_21_053415_create_check_classes_table', 1),
(195, '2020_10_27_071255_create_sm_leave_deduction_infos_table', 1),
(196, '2020_11_16_065239_create_sm_role_permissions_table', 1),
(197, '2020_11_18_113808_create_sm_lessons_table', 1),
(198, '2020_11_18_121616_create_sm_lesson_details_table', 1),
(199, '2020_11_20_044018_create_sm_lesson_topics_table', 1),
(200, '2020_11_20_045211_create_sm_lesson_topic_details_table', 1),
(201, '2020_12_07_101416_create_online_exam_student_answer_markings_table', 1),
(202, '2020_12_10_095530_create_lesson_planners_table', 1),
(203, '2021_01_18_121007_create_sm_bank_statements_table', 1),
(204, '2021_01_27_103347_create_sm_exam_settings_table', 1),
(205, '2021_02_01_042422_create_sm_amount_transfers_table', 1),
(206, '2021_02_10_110920_create_absent_notification_time_setups_table', 1),
(207, '2021_02_15_111736_create_invitations_table', 1),
(208, '2021_02_15_130414_create_conversations_table', 1),
(209, '2021_02_17_165101_create_block_users_table', 1),
(210, '2021_03_01_131441_create_notifications_table', 1),
(211, '2021_03_03_112535_create_groups_table', 1),
(212, '2021_03_03_112734_create_group_users_table', 1),
(213, '2021_03_03_112908_create_group_message_recipients_table', 1),
(214, '2021_03_14_131442_create_menu_manages_table', 1),
(215, '2021_03_14_131748_create_sidebars_table', 1),
(216, '2021_03_15_112756_create_sm_pages_table', 1),
(217, '2021_03_18_071730_create_sm_header_menu_managers_table', 1),
(218, '2021_03_18_172321_create_group_message_removes_table', 1),
(219, '2021_03_22_121237_create_sm_course_categories_table', 1),
(220, '2021_03_24_133318_create_user_menus_table', 1),
(221, '2021_03_31_053231_create_invitation_types_table', 1),
(222, '2021_04_29_103755_create_edu_bb12update_version_table', 1),
(223, '2021_04_29_103755_create_edu_update_khalti_table', 1),
(224, '2021_04_29_103755_create_edu_update_version630_table', 1),
(225, '2021_04_29_103755_create_edu_update_version632_table', 1),
(226, '2021_05_12_092535_create_sm_custom_fields_table', 1),
(227, '2021_06_06_070142_create_invoice_settings_table', 1),
(228, '2021_06_13_044854_create_sidebar_news_table', 1),
(229, '2021_07_20_110254_create_fm_fees_groups_table', 1),
(230, '2021_07_20_110718_create_fm_fees_types_table', 1),
(231, '2021_07_26_045723_create_fm_fees_invoice_settings_table', 1),
(232, '2021_07_26_070244_create_student_academic_histories_table', 1),
(233, '2021_07_29_050922_create_failed_jobs_table', 1),
(234, '2021_07_29_120251_create_fm_fees_invoices_table', 1),
(235, '2021_07_31_072347_create_fm_fees_invoice_chields_table', 1),
(236, '2021_08_03_035307_create_fm_fees_weavers_table', 1),
(237, '2021_08_03_091427_add_domain_column_to_sm_schools_table', 1),
(238, '2021_08_03_094121_create_fm_fees_transactions_table', 1),
(239, '2021_08_04_040918_create_wm__wallet_settings_table', 1),
(240, '2021_08_08_103123_add_school_id_to_tables', 1),
(241, '2021_08_14_074012_add_types_to_sm_news_categories_table', 1),
(242, '2021_08_25_092306_create_wallet_transactions_table', 1),
(243, '2021_08_31_070309_create_transcations_table', 1),
(244, '2021_09_21_115204_add_time_to_sm_class_routine_updates_table', 1),
(245, '2021_09_26_041758_add_exam_time_periods_change_to_sm_exam_schedules_table', 1),
(246, '2021_10_23_123651_create_school_modules_table', 1),
(247, '2021_11_02_062835_create_fm_fees_transaction_chields_table', 1),
(248, '2021_11_13_044910_create_version_update_migration_for_smart_web', 1),
(249, '2021_11_16_062629_base_setup_update', 1),
(250, '2021_11_24_054447_add_lead_to_infix_module_manager_table', 1),
(251, '2021_11_28_125608_infix_edu_v640_version_update', 1);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `provider`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, 'Laravel Personal Access Client', '2e1LEl0zBTmD8XN4sa0meCTtKslUBpShKW4AGrej', 'https://schoolone.softwarestore.biz', 1, 0, 0, NULL, NULL),
(2, NULL, 'users', 'Laravel Password Grant Client', 'oDaHAi0ml3To8OC7Da10TGVUm7zjhMyq00cmwoDZ', 'https://schoolone.softwarestore.biz', 0, 1, 0, NULL, NULL);

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2022-02-17 05:09:58', '2022-02-17 05:09:58');

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` int(10) UNSIGNED NOT NULL,
  `access_token_id` bigint(20) DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `online_exam_student_answer_markings`
--

CREATE TABLE `online_exam_student_answer_markings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `online_exam_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `question_id` int(11) DEFAULT NULL,
  `user_answer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obtain_marks` int(11) DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  `marked_by` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'System',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `type`, `active_status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `school_id`) VALUES
(1, 'Super admin', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(2, 'Student', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(3, 'Parents', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(4, 'Teacher', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(5, 'Admin', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(6, 'Accountant', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(7, 'Receptionist', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(8, 'Librarian', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1),
(9, 'Driver', 'System', 1, '1', '1', '2022-02-17 05:09:54', NULL, 1);

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

--
-- Table structure for table `school_modules`
--

CREATE TABLE `school_modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `school_id` int(10) UNSIGNED NOT NULL DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sidebars`
--

CREATE TABLE `sidebars` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `child_id` int(11) DEFAULT '0',
  `lan_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_class` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_saas` tinyint(4) NOT NULL DEFAULT '0',
  `route` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `infix_module_id` int(10) UNSIGNED DEFAULT NULL,
  `role_id` int(10) UNSIGNED DEFAULT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sidebars`
--

INSERT INTO `sidebars` (`id`, `module_id`, `parent_id`, `child_id`, `lan_name`, `name`, `icon_class`, `is_saas`, `route`, `active_status`, `infix_module_id`, `role_id`, `user_id`, `school_id`, `created_at`, `updated_at`) VALUES
(1, 2, 0, 0, 'admin_section', 'Admin Section', 'flaticon-analytics', 0, '', 1, 11, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(2, 2, 11, 0, 'admission_query', 'Admission Query', '', 0, 'admission_query', 1, 12, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(3, 2, 11, 0, 'visitor', 'Visitor Book', '', 0, 'visitor', 1, 16, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(4, 2, 11, 0, 'complaint', 'Complaint', '', 0, 'complaint', 1, 21, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(5, 2, 11, 0, 'postal_receive', 'Postal Receive', '', 0, 'postal-receive', 1, 27, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(6, 2, 11, 0, 'postal_dispatch', 'Postal Dispatch', '', 0, 'postal-dispatch', 1, 32, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(7, 2, 11, 0, 'phone_call', 'Phone Call Log', '', 0, 'phone-call', 1, 36, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(8, 2, 11, 0, 'setup_admin', 'Admin Setup', '', 0, 'setup-admin', 1, 41, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(9, 2, 11, 0, 'student_id_card', 'Student ID Card', '', 0, 'student-id-card', 1, 45, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(10, 2, 11, 0, 'student_certificate', 'Student Certificate', '', 0, 'student-certificate', 1, 49, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(11, 2, 11, 0, 'generate_certificate', 'Generate Certificate', '', 0, 'generate_certificate', 1, 53, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(12, 2, 11, 0, 'generate_id_card', 'Generate ID Card', '', 0, 'generate_id_card', 1, 57, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(13, 3, 0, 0, 'student_information', 'Student Info', 'flaticon-reading', 0, '', 1, 61, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(14, 3, 61, 0, 'add_student', 'Add Student', '', 0, 'student_admission', 1, 62, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(15, 3, 61, 0, 'student_list', 'Student List', '', 0, 'student_list', 1, 64, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(16, 3, 61, 0, 'student_attendance', 'Student Attendance', '', 0, 'student_attendance', 1, 68, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(17, 3, 61, 0, 'student_attendance_report', 'Student Attendance Report', '', 0, 'student_attendance_report', 1, 70, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(18, 3, 61, 0, 'student_category', 'Student Category', '', 0, 'student_category', 1, 71, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(19, 3, 61, 0, 'student_group', 'Student Group', '', 0, 'student_group', 1, 76, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(20, 3, 61, 0, 'student_promote', 'Student Promote', '', 0, 'student_promote', 1, 81, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(21, 3, 61, 0, 'disabled_student', 'Disabled Students', '', 0, 'disabled_student', 1, 83, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(22, 4, 0, 0, 'study_material', 'Study Material', 'flaticon-professor', 0, '', 1, 87, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(23, 4, 87, 0, 'upload_content', 'Upload Content', '', 0, 'upload-content', 1, 88, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(24, 4, 87, 0, 'assignment', 'Assignment', '', 0, 'assignment-list', 1, 92, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(25, 4, 87, 0, 'syllabus', 'Syllabus', '', 0, 'syllabus-list', 1, 100, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(26, 4, 87, 0, 'other_download', 'Other Downloads', '', 0, 'other-download-list', 1, 105, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(27, 5, 0, 0, 'fees_collection', 'Fees Collection', 'flaticon-wallet', 0, '', 1, 108, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(28, 5, 108, 0, 'collect_fees', 'Collect Fees', '', 0, 'collect_fees', 1, 109, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(29, 5, 109, 0, '', ' Collect Fees', '', 0, '', 1, 110, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(30, 5, 108, 0, 'search_fees_payment', 'Search Fees Payment', '', 0, 'search_fees_payment', 1, 113, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(31, 5, 108, 0, 'search_fees_due', 'Search Fees Due', '', 0, 'search_fees_due', 1, 116, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(32, 5, 108, 0, 'fees_master', 'Fees Master', '', 0, 'fees-master', 1, 118, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(33, 5, 118, 0, '', 'Assign', '', 0, '', 1, 122, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(34, 5, 108, 0, 'fees_group', 'Fees Group', '', 0, 'fees_group', 1, 123, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(35, 5, 108, 0, 'fees_type', 'Fees Type', '', 0, 'fees_type', 1, 127, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(36, 5, 108, 0, 'fees_discount', 'Fees Discount', '', 0, 'fees_discount', 1, 131, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(37, 5, 131, 0, '', 'Assign', '', 0, '', 1, 135, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(38, 5, 108, 0, 'fees_forward', 'Fees Carry Forward', '', 0, 'fees_forward', 1, 136, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(39, 6, 0, 0, 'accounts', 'Accounts', 'flaticon-accounting', 0, '', 1, 137, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(40, 6, 137, 0, 'profit_&_loss', 'Profit & Loss', '', 0, 'profit', 1, 138, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(41, 6, 137, 0, 'income', 'Income', '', 0, 'add_income', 1, 139, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(42, 6, 137, 0, 'expense', 'Expense', '', 0, 'add-expense', 1, 143, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(43, 6, 137, 0, 'chart_of_account', 'Chart of Account', '', 0, 'chart-of-account', 1, 148, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(44, 6, 137, 0, 'bank_account', 'Bank Account', '', 0, 'bank-account', 1, 156, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(45, 6, 156, 0, 'bank_transaction', 'Bank Transaction', '', 0, '', 1, 158, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(46, 7, 0, 0, 'human_resource', 'Human Resource', 'flaticon-consultation', 0, '', 1, 160, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(47, 7, 160, 0, 'staff_directory', 'Staff Directory', '', 0, 'staff_directory', 1, 161, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(48, 7, 160, 0, 'staff_attendance', 'Staff Attendance', '', 0, 'staff_attendance', 1, 165, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(49, 7, 160, 0, 'staff_attendance_report', 'Staff Attendance Report', '', 0, 'staff_attendance_report', 1, 169, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(50, 7, 160, 0, 'payroll', 'Payroll', '', 0, 'payroll', 1, 170, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(51, 7, 170, 0, '', 'Search', '', 0, '', 1, 173, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(52, 7, 170, 0, '', 'Generate Payroll', '', 0, '', 1, 174, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(53, 7, 170, 0, '', 'Create', '', 0, '', 1, 175, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(54, 7, 170, 0, '', 'Proceed To Pay', '', 0, '', 1, 176, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(55, 7, 170, 0, '', 'View Payslip', '', 0, '', 1, 177, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(56, 7, 160, 0, 'payroll_report', 'Payroll Report', '', 0, 'payroll-report', 1, 178, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(57, 7, 178, 0, '', 'Report Search', '', 0, '', 1, 179, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(58, 7, 160, 0, 'designation', 'Designation', '', 0, 'designation', 1, 180, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(59, 7, 160, 0, 'department', 'Department', '', 0, 'department', 1, 184, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(60, 8, 0, 0, 'leave', 'Leave', 'flaticon-slumber', 0, '', 1, 188, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(61, 8, 188, 0, 'approve_leave_request', 'Approve Leave Request', '', 0, 'approve-leave', 1, 189, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(62, 8, 188, 0, 'apply_leave', 'Apply Leave', '', 0, 'apply-leave', 1, 193, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(63, 8, 188, 0, 'pending_leave_request', 'Pending Leave', '', 0, 'pending-leave', 1, 196, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(64, 8, 188, 0, 'leave_define', 'Leave Define', '', 0, 'leave-define', 1, 199, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(65, 8, 188, 0, 'leave_type', 'Leave Type', '', 0, 'leave-type', 1, 203, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(66, 9, 0, 0, 'examination', 'Examination', 'flaticon-test', 0, '', 1, 207, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(67, 9, 207, 0, 'exam_type', 'Exam Type', '', 0, 'exam-type', 1, 208, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(68, 9, 207, 0, 'exam_setup', 'Exam Setup', '', 0, 'exam', 1, 214, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(69, 9, 207, 0, 'exam_schedule', 'Exam Schedule', '', 0, 'exam_schedule', 1, 217, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(70, 9, 217, 0, '', 'Create', '', 0, '', 1, 219, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(71, 9, 207, 0, 'exam_attendance', 'Exam Attendance', '', 0, 'exam_attendance', 1, 220, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(72, 9, 207, 0, 'marks_register', 'Marks Register', '', 0, 'marks_register', 1, 222, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(73, 9, 222, 0, '', 'Create', '', 0, '', 1, 224, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(74, 9, 207, 0, 'marks_grade', 'Marks Grade', '', 0, 'marks-grade', 1, 225, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(75, 9, 207, 0, 'send_marks_by_sms', 'Send Marks By SMS', '', 0, 'send_marks_by_sms', 1, 229, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(76, 35, 875, 0, 'question_group', 'Question Group', '', 0, 'question-group', 1, 230, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(77, 35, 875, 0, 'question_bank', 'Question Bank', '', 0, 'question-bank', 1, 234, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(78, 35, 875, 0, 'online_exam', 'Online Exam', '', 0, 'online-exam', 1, 238, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(79, 35, 238, 0, '', 'Manage Question', '', 0, '', 1, 242, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(80, 35, 238, 0, '', 'Marks Register', '', 0, '', 1, 243, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(81, 35, 238, 0, '', 'Result', '', 0, '', 1, 244, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(82, 10, 0, 0, 'academics', 'Academics', 'flaticon-book', 0, '', 1, 245, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(83, 10, 245, 0, 'class_routine', 'Class Routine', '', 0, 'class_routine_new', 1, 246, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(84, 10, 245, 0, 'assign_subject', 'Assign Subject', '', 0, 'assign_subject', 1, 250, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(85, 10, 245, 0, 'assign_class_teacher', 'Assign Class Teacher', '', 0, 'assign-class-teacher', 1, 253, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(86, 10, 245, 0, 'subject', 'Subjects', '', 0, 'subject', 1, 257, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(87, 10, 245, 0, 'class', 'Class', '', 0, 'class', 1, 261, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(88, 10, 245, 0, 'section', 'Section', '', 0, 'section', 1, 265, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(89, 10, 245, 0, 'class_room', 'Class Room', '', 0, 'class-room', 1, 269, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(90, 10, 245, 0, 'class_time_setup', 'Class Time Setup', '', 0, 'class-time', 1, 273, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(91, 11, 0, 0, 'home_work', 'Homework', 'flaticon-book', 0, '', 1, 277, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(92, 11, 277, 0, 'add_homework', 'Add Homework', '', 0, 'add-homeworks', 1, 278, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(93, 11, 277, 0, 'homework_list', 'Homework List', '', 0, 'homework-list', 1, 280, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(94, 11, 280, 0, '', 'Evaluation', '', 0, '', 1, 281, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(95, 11, 277, 0, 'evaluation_report', 'Homework Evaluation Report', '', 0, 'evaluation-report', 1, 284, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(96, 12, 0, 0, 'communicate', 'Communicate', 'flaticon-email', 0, '', 1, 286, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(97, 12, 286, 0, 'notice_board', 'Notice Board', '', 0, 'notice-list', 1, 287, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(98, 12, 286, 0, 'send_email', 'Send Email / SMS ', '', 0, 'send-email-sms-view', 1, 291, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(99, 12, 291, 0, '', 'Send', '', 0, '', 1, 292, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(100, 12, 286, 0, 'email_sms_log', 'Email / SMS Log', '', 0, 'email-sms-log', 1, 293, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(101, 12, 286, 0, 'event', 'Event', '', 0, 'event', 1, 294, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(102, 13, 0, 0, 'library', 'Library', 'flaticon-book-1', 0, '', 1, 298, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(103, 13, 298, 0, 'add_book', 'Add Book', '', 0, 'add-book', 1, 299, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(104, 13, 298, 0, 'book_list', 'Book List ', '', 0, 'book-list', 1, 301, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(105, 13, 298, 0, 'book_category', 'Book Categories', '', 0, 'book-category-list', 1, 304, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(106, 13, 298, 0, 'library_member', 'Add Member', '', 0, 'library-member', 1, 308, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(107, 13, 308, 0, '', 'Cancel', '', 0, '', 1, 310, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(108, 13, 298, 0, 'member_list', 'Issue/Return Book', '', 0, 'member-list', 1, 311, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(109, 13, 311, 0, '', 'Issue', '', 0, '', 1, 312, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(110, 13, 311, 0, '', 'Return', '', 0, '', 1, 313, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(111, 13, 298, 0, 'all_issued_book', 'All Issued Book', '', 0, 'all-issed-book', 1, 314, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(112, 14, 0, 0, 'inventory', 'Inventory', 'flaticon-inventory', 0, '', 1, 315, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(113, 14, 315, 0, 'item_category', 'Item Category', '', 0, 'item-category', 1, 316, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(114, 14, 315, 0, 'item_list', 'Item List', '', 0, 'item-list', 1, 320, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(115, 14, 315, 0, 'item_store', 'Item Store', '', 0, 'item-store', 1, 324, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(116, 14, 315, 0, 'supplier', 'Supplier', '', 0, 'suppliers', 1, 328, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(117, 14, 315, 0, 'item_receive', 'Item Receive', '', 0, 'item-receive', 1, 332, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(118, 14, 315, 0, 'item_receive_list', 'Item Receive List', '', 0, 'item-receive-list', 1, 334, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(119, 14, 334, 0, '', 'Cancel', '', 0, '', 1, 338, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(120, 14, 315, 0, 'item_sell', 'Item Sell', '', 0, 'item-sell-list', 1, 339, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(121, 14, 339, 0, '', 'Add Payment', '', 0, '', 1, 343, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(122, 14, 339, 0, '', 'View Payment', '', 0, '', 1, 344, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(123, 14, 315, 0, 'item_issue', 'Item Issue', '', 0, 'item-issue', 1, 345, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(124, 14, 345, 0, '', 'Return', '', 0, '', 1, 347, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(125, 15, 0, 0, 'transport', 'Transport', 'flaticon-bus', 0, '', 1, 348, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(126, 15, 348, 0, 'routes', 'Routes', '', 0, 'transport-route', 1, 349, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(127, 15, 348, 0, 'vehicle', 'Vehicle', '', 0, 'vehicle', 1, 353, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(128, 15, 348, 0, 'assign_vehicle', 'Assign Vehicle', '', 0, 'assign-vehicle', 1, 357, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(129, 15, 348, 0, 'student_transport_report', 'Student Transport Report', '', 0, 'student_transport_report', 1, 361, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(130, 16, 0, 0, 'dormitory', 'Dormitory', 'flaticon-hotel', 0, '', 1, 362, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(131, 16, 362, 0, 'dormitory_rooms', 'Dormitory Rooms', '', 0, 'room-list', 1, 363, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(132, 16, 362, 0, 'dormitory', 'Dormitory', '', 0, 'dormitory-list', 1, 367, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(133, 16, 362, 0, 'room_type', 'Room Type', '', 0, 'room-type', 1, 371, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(134, 16, 362, 0, 'student_dormitory_report', 'Student Dormitory Report', '', 0, 'student_dormitory_report', 1, 375, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(135, 17, 0, 0, 'reports', 'Reports', 'flaticon-analysis', 0, 'student_report', 1, 376, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(136, 17, 376, 0, 'guardian_report', 'Guardian Reports', '', 0, 'guardian_report', 1, 377, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(137, 17, 376, 0, 'student_history', 'Student History', '', 0, 'student_history', 1, 378, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(138, 17, 376, 0, 'student_login_report', 'Student Login Report', '', 0, 'student_login_report', 1, 379, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(139, 17, 376, 0, 'fees_statement', 'Fees Statement', '', 0, 'fees_statement', 1, 381, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(140, 17, 376, 0, 'balance_fees_report', 'Balance Fees Report', '', 0, 'balance_fees_report', 1, 382, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(141, 5, 840, 0, 'collection_report', 'Collection Report', '', 0, 'transaction_report', 1, 383, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(142, 17, 376, 0, 'class_report', 'Class Report', '', 0, 'class_report', 1, 384, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(143, 17, 376, 0, 'class_routine', 'Class Routine', '', 0, 'class_routine_report', 1, 385, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(144, 17, 376, 0, 'exam_routine', 'Exam Routine', '', 0, 'exam_routine_report', 1, 386, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(145, 17, 376, 0, 'teacher_class_routine', 'Teacher Class Routine', '', 0, 'teacher_class_routine_report', 1, 387, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(146, 17, 376, 0, 'merit_list_report', 'Merit List Report', '', 0, 'merit_list_report', 1, 388, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(147, 17, 376, 0, 'online_exam_report', 'Online Exam Report', '', 0, 'online_exam_report', 1, 389, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(148, 17, 376, 0, 'mark_sheet_report', 'Mark Sheet Report', '', 0, 'mark_sheet_report_student', 1, 390, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(149, 17, 376, 0, 'tabulation_sheet_report', 'Tabulation Sheet Report', '', 0, 'tabulation_sheet_report', 1, 391, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(150, 17, 376, 0, 'progress_card_report', 'Progress Card Report', '', 0, 'progress_card_report', 1, 392, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(151, 17, 376, 0, 'user_log', 'User Log', '', 0, 'user_log', 1, 394, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(152, 9, 394, 0, '', 'Exam Setup Edit', '', 0, '', 1, 397, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(153, 18, 0, 0, 'system_settings', 'System Settings', 'flaticon-settings', 0, '', 1, 398, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(154, 18, 398, 0, 'module_manager', ' Manager', '', 0, 'manage-adons', 1, 399, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(155, 18, 399, 0, '', 'Verify', '', 0, '', 1, 400, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(156, 18, 398, 0, 'manage_currency', 'Manage Currency', '', 0, 'manage-currency', 1, 401, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(157, 18, 398, 0, 'general_settings', 'General Settings', '', 0, 'general-settings', 1, 405, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(158, 18, 405, 0, '', 'Logo Change', '', 0, '', 1, 406, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(159, 18, 405, 0, '', 'Fevicon Change', '', 0, '', 1, 407, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(160, 18, 405, 0, '', 'Update', '', 0, '', 1, 409, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(161, 18, 398, 0, 'email_settings', 'Email Setting', '', 0, 'email-settings', 1, 410, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(162, 18, 410, 0, '', 'Update', '', 0, '', 1, 411, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(163, 18, 398, 0, 'payment_method_settings', 'Payment Method Settings', '', 0, 'payment-method-settings', 1, 412, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(164, 18, 412, 0, '', 'Gateway Update', '', 0, '', 1, 413, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(165, 18, 412, 0, '', 'PayPal Update', '', 0, '', 1, 414, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(166, 18, 412, 0, '', 'Stripe Update', '', 0, '', 1, 415, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(167, 18, 412, 0, '', 'Paystack Update', '', 0, '', 1, 416, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(168, 23, 0, 0, 'role_&_permission', 'Role & Permission', 'flaticon-authentication', 0, '', 1, 417, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(169, 23, 417, 0, 'login_permission', 'Login Permission', '', 0, 'login-access-control', 1, 421, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(170, 23, 421, 0, '', 'On', '', 0, '', 1, 422, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(171, 23, 421, 0, '', 'Off', '', 0, '', 1, 423, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(172, 18, 398, 0, 'optional_subject_setup', 'Optional Subject Setup', '', 0, 'class_optional', 1, 424, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(173, 18, 398, 0, 'base_setup', 'Base Setup', '', 0, '', 1, 428, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(174, 18, 398, 0, 'academic_year', 'Academic Year', '', 0, 'academic-year', 1, 432, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(175, 9, 870, 0, 'setup_exam_role', 'Setup Exam Rule', '', 0, 'custom-result-setting', 1, 436, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(176, 18, 398, 0, 'holiday', 'Holiday', '', 0, 'holiday', 1, 440, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(177, 18, 398, 0, 'sms_settings', 'Sms Settings', '', 0, 'sms-settings', 1, 444, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(178, 18, 444, 0, '', ' Select SMS Service', '', 0, '', 1, 445, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(179, 18, 444, 0, '', ' Twilio Update', '', 0, '', 1, 446, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(180, 18, 444, 0, '', ' MSG91 Update', '', 0, '', 1, 447, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(181, 18, 398, 0, 'weekend', 'Weekend', '', 0, 'weekend', 1, 448, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(182, 18, 448, 0, '', 'Update', '', 0, '', 1, 450, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(183, 18, 398, 0, 'language_settings', 'Language Settings', '', 0, 'language-settings', 1, 451, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(184, 18, 451, 0, '', 'Make Default', '', 0, '', 1, 453, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(185, 18, 451, 0, '', 'Setup', '', 0, '', 1, 454, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(186, 18, 451, 0, '', 'Remove', '', 0, '', 1, 455, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(187, 18, 398, 0, 'backup', 'Backup', '', 0, 'backup-settings', 1, 456, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(188, 18, 456, 0, '', 'Image', '', 0, '', 1, 460, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(189, 18, 456, 0, '', 'Full Project', '', 0, '', 1, 461, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(190, 18, 456, 0, '', 'Database', '', 0, '', 1, 462, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(191, 18, 398, 0, 'header', 'Header Option', '', 0, 'button-disable-enable', 1, 463, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(192, 18, 463, 0, '', 'Custom URL Update', '', 0, '', 1, 464, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(193, 18, 463, 0, '', 'Website On', '', 0, '', 1, 465, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(194, 18, 463, 0, '', 'Website Off', '', 0, '', 1, 466, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(195, 18, 463, 0, '', 'Dashboard On', '', 0, '', 1, 467, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(196, 18, 463, 0, '', 'Dashboard Off', '', 0, '', 1, 468, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(197, 18, 463, 0, '', 'Report On', '', 0, '', 1, 469, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(198, 18, 463, 0, '', 'Report Off', '', 0, '', 1, 470, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(199, 18, 463, 0, '', 'Language On', '', 0, '', 1, 471, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(200, 18, 463, 0, '', 'Language Off', '', 0, '', 1, 472, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(201, 18, 463, 0, '', 'Style On', '', 0, '', 1, 473, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(202, 18, 463, 0, '', 'Style Off', '', 0, '', 1, 474, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(203, 18, 398, 0, 'about_&_update', 'About & Update', '', 0, 'update-system', 1, 478, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(204, 12, 286, 0, 'email_templete', 'Email Template', '', 0, 'templatesettings.email-template', 1, 480, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(205, 12, 480, 0, '', 'Save', '', 0, '', 1, 481, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(206, 18, 398, 0, 'api', 'API Permission', '', 0, '', 1, 482, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(207, 18, 482, 0, '', 'On', '', 0, '', 1, 483, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(208, 18, 482, 0, '', 'Off', '', 0, '', 1, 484, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(209, 19, 0, 0, 'style', 'Style', 'flaticon-consultation', 0, '', 1, 485, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(210, 19, 485, 0, 'background_settings', 'Background Settings', '', 0, 'background-setting', 1, 486, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(211, 19, 486, 0, '', 'Make Default', '', 0, '', 1, 489, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(212, 19, 485, 0, 'color_theme', 'Color Theme', '', 0, 'color-style', 1, 490, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(213, 19, 490, 0, '', 'Make Default', '', 0, '', 1, 491, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(214, 20, 0, 0, 'front_settings', 'Front Settings', 'flaticon-software', 0, '', 1, 492, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(215, 20, 492, 0, 'home_page', 'Home Page', '', 0, 'admin-home-page', 1, 493, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(216, 20, 493, 0, '', 'Update', '', 0, '', 1, 494, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(217, 20, 492, 0, 'news_list', 'News List', '', 0, 'news_index', 1, 495, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(218, 20, 492, 0, 'news_category', 'News Category', '', 0, 'news-category', 1, 500, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(219, 20, 492, 0, 'testimonial', 'Testimonial', '', 0, 'testimonial_index', 1, 504, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(220, 20, 492, 0, 'course_list', 'Course List', '', 0, 'course-list', 1, 509, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(221, 20, 492, 0, 'contact_page', 'Contact Page', '', 0, 'conpactPage', 1, 514, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(222, 20, 492, 0, 'contact_message', 'Contact Messages', '', 0, 'contactMessage', 1, 517, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(223, 20, 492, 0, 'about_us', 'About Us', '', 0, 'about-page', 1, 520, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(224, 20, 492, 0, 'news_heading', 'News Heading', '', 0, 'news-heading-update', 1, 523, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(225, 20, 523, 0, '', 'Update', '', 0, '', 1, 524, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(226, 20, 492, 0, 'course_details_heading', 'Course Details Heading', '', 0, 'course-heading-update', 1, 525, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(227, 20, 525, 0, '', 'Update', '', 0, '', 1, 526, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(228, 20, 492, 0, 'footer_widget', 'Footer Widget', '', 0, 'custom-links', 1, 527, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(229, 20, 527, 0, '', 'Update', '', 0, '', 1, 528, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(230, 20, 492, 0, 'social_media', 'Social Media', '', 0, 'social-media', 1, 529, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(231, 3, 61, 0, 'subject_wise_attendance', 'Subject Wise Attendance', '', 0, 'subject-wise-attendance', 1, 533, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(232, 3, 533, 0, '', 'Save', '', 0, '', 1, 534, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(233, 3, 61, 0, 'subject_wise_attendance_report', 'Subject Wise Attendance Report', '', 0, 'subject-attendance-report', 1, 535, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(234, 10, 245, 0, 'optional_subject', 'Optional Subject', '', 0, 'optional-subject', 1, 537, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(235, 17, 376, 0, 'student_report', 'Student Report', '', 0, 'student_report', 1, 538, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(236, 17, 376, 0, 'previous_class_result', 'Previous Result', '', 0, 'previous-class-results', 1, 539, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(237, 17, 376, 0, '', 'previous record', '', 0, '', 1, 540, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(238, 18, 585, 0, '', 'Assign Permission', '', 0, '', 1, 541, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(239, 18, 398, 0, 'language', 'Language', '', 0, 'language-list', 1, 549, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(240, 9, 207, 0, 'exam_time', 'Exam Time', '', 0, 'exam-time', 1, 571, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(241, 7, 161, 0, '', 'Status On', '', 0, '', 1, 577, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(242, 7, 161, 0, '', 'Status Off', '', 0, '', 1, 578, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(243, 13, 298, 0, 'subject', 'Subject', '', 0, 'library_subject', 1, 579, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(244, 23, 417, 0, 'role', 'Role', '', 0, 'rolepermission/role', 1, 585, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(245, 20, 492, 0, 'header_menu_manager', 'Header  Manager', '', 0, 'header-menu-manager', 1, 650, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(246, 20, 492, 0, 'pages', 'Pages', '', 0, 'page-list', 1, 654, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(247, 3, 61, 0, 'student_export', 'Student Export', '', 0, 'all-student-export', 1, 663, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(248, 3, 663, 0, '', 'Export To CSV', '', 0, '', 1, 664, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(249, 3, 663, 0, '', 'Export To PDF', '', 0, '', 1, 665, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(250, 20, 492, 0, 'course_category', 'Course Category', '', 0, 'course-category', 1, 673, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(251, 6, 137, 0, 'report', 'Report', '', 0, '', 1, 700, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(252, 6, 700, 0, 'fine_report', 'Fine Report', '', 0, 'fine-report', 1, 701, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(253, 6, 700, 0, 'payroll_report', 'Payroll Report', '', 0, 'accounts-payroll-report', 1, 702, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(254, 6, 700, 0, 'transaction', 'Transaction', '', 0, 'transaction', 1, 703, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(255, 6, 137, 0, 'fund_transfer', 'Fund Transfer', '', 0, 'fund-transfer', 1, 704, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(256, 6, 704, 0, 'transfer', 'Transfer', '', 0, '', 1, 705, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(257, 9, 870, 0, 'format_settings', 'Format Settings', '', 0, 'exam-settings', 1, 706, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(258, 12, 286, 0, 'sms_template', 'Sms Templete', '', 0, 'sms-template-new', 1, 710, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(259, 7, 160, 0, 'add_staff', 'Add Staff', '', 0, 'addStaff', 1, 712, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(260, 29, 0, 0, 'lesson', 'Lesson', 'flaticon-professor', 0, '', 1, 800, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(261, 29, 800, 0, 'lesson', 'Lesson', '', 0, 'lesson', 1, 801, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(262, 29, 800, 0, 'topic', 'Topic', '', 0, 'lesson.topic', 1, 805, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(263, 29, 800, 0, 'topic_overview', 'Topic Overview', '', 0, 'topic-overview', 1, 809, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(264, 29, 800, 0, 'lesson_plan', 'Lesson Plan', '', 0, 'lesson.lesson-planner', 1, 810, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(265, 29, 800, 0, 'lesson_plan_overview', 'Lesson Plan Overview', '', 0, 'lesson.lessonPlan-overiew', 1, 815, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(266, 29, 800, 0, 'my_lesson_plan', 'My Lesson Plan ', '', 0, 'view-teacher-lessonPlan', 1, 833, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(267, 29, 800, 0, 'my_lesson_plan_overview', 'My Lesson Plan Overview', '', 0, 'view-teacher-lessonPlan-overview', 1, 834, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(268, 5, 108, 0, 'report', 'Report', '', 0, '', 1, 840, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(269, 9, 207, 0, 'settings', 'Settings', '', 0, '', 1, 870, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(270, 5, 108, 0, 'bank_payment', 'Bank Payment', '', 0, 'bank-payment-slip', 1, 871, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(271, 35, 0, 0, 'online_exam', 'Online Exam', 'flaticon-book-1', 0, '', 1, 875, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(272, 31, 0, 0, 'chat', 'Chat', 'flaticon-test', 0, '', 1, 900, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(273, 31, 900, 0, 'chat_box', 'Chat Box', '', 0, 'chat.index', 1, 901, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(274, 31, 901, 0, '', 'New Chat', '', 0, '', 1, 902, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(275, 31, 900, 0, 'invitation', 'Invitation', '', 0, 'chat.invitation', 1, 903, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(276, 31, 900, 0, 'blocked_user', 'Blocked User', '', 0, 'chat.blocked.users', 1, 904, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(277, 31, 900, 0, 'chat_settings', 'Chat Settings', '', 0, 'chat.settings', 1, 905, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(278, 36, 0, 0, 'bulk_print', 'Bulk Print', 'flaticon-analysis', 0, '', 1, 920, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(279, 36, 920, 0, 'student_id_card', 'Student Id Card', '', 0, 'student-id-card-bulk-print', 1, 921, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(280, 36, 920, 0, 'student_certificate', 'Student Certificate', '', 0, 'certificate-bulk-print', 1, 922, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(281, 36, 920, 0, 'staff_id_card', 'Staff Id Card', '', 0, 'staff-id-card-bulk-print', 1, 923, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(282, 36, 920, 0, 'payroll_bulk_print', 'PayrollBulk Print', '', 0, 'payroll-bulk-print', 1, 924, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(283, 36, 920, 0, 'fees_invoice_settings', 'Fees Invoice Settings', '', 0, 'invoice-settings', 1, 925, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(284, 36, 920, 0, 'fees_invoice_bulk_print', 'Fees invoice Bulk Print', '', 0, 'fees-bulk-print', 1, 926, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(285, 3, 61, 0, 'time_setup', 'Time Setup', '', 0, 'notification_time_setup', 1, 950, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(286, 100, 0, 0, 'custom_field', 'Custom Field', 'flaticon-slumber', 0, '', 1, 1100, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(287, 100, 1100, 0, 'student_registration', 'Student Registration', '', 0, 'student-reg-custom-field', 1, 1101, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(288, 100, 1100, 0, 'staff_registration', 'Staff Registration', '', 0, 'staff-reg-custom-field', 1, 1105, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(289, 150, 0, 0, '', 'Wallet', '', 0, '', 1, 1109, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(290, 150, 1109, 0, '', 'Pending Diposite', '', 0, '', 1, 1110, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(291, 150, 1110, 0, '', 'Approve', '', 0, '', 1, 1111, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(292, 150, 1110, 0, '', 'Reject', '', 0, '', 1, 1112, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(293, 150, 1109, 0, '', 'Approve Diposite', '', 0, '', 1, 1114, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(294, 150, 1109, 0, '', 'Reject Diposite', '', 0, '', 1, 1116, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(295, 150, 1109, 0, '', 'Wallet Transaction', '', 0, '', 1, 1118, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(296, 150, 1109, 0, '', 'Wallet Refund Request', '', 0, '', 1, 1119, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(297, 150, 1119, 0, '', 'Approve', '', 0, '', 1, 1120, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(298, 150, 1119, 0, '', 'Reject', '', 0, '', 1, 1121, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(299, 150, 1109, 0, '', 'Wallet Report', '', 0, '', 1, 1123, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(300, 250, 0, 0, '', 'Fees', '', 0, '', 1, 1130, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(301, 250, 1130, 0, '', 'Fees Group', '', 0, '', 1, 1131, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(302, 250, 1130, 0, '', 'Fees Type', '', 0, '', 1, 1135, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(303, 250, 1130, 0, '', 'Fees Invoice', '', 0, '', 1, 1139, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(304, 250, 1139, 0, '', 'View Payment', '', 0, '', 1, 1141, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(305, 250, 1139, 0, '', 'Add Payment', '', 0, '', 1, 1144, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(306, 250, 1139, 0, '', 'Fees Collect', '', 0, '', 1, 1147, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(307, 250, 1130, 0, '', 'Bank Payment', '', 0, '', 1, 1148, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(308, 250, 1148, 0, '', 'Search', '', 0, '', 1, 1149, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(309, 250, 1148, 0, '', 'Approve Payment', '', 0, '', 1, 1150, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(310, 250, 1148, 0, '', 'Reject Payment', '', 0, '', 1, 1151, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(311, 250, 1130, 0, '', 'Fees Invoice Settings', '', 0, '', 1, 1152, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(312, 250, 1152, 0, '', 'Update', '', 0, '', 1, 1153, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(313, 250, 1130, 0, '', 'Fees Due', '', 0, '', 1, 1154, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(314, 250, 1154, 0, '', 'Search', '', 0, '', 1, 1155, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13'),
(315, 18, 398, 0, 'utilities', 'Utilities', '', 0, 'utility', 1, 4000, NULL, NULL, 1, '2022-02-17 05:10:13', '2022-02-17 05:10:13');

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

--
-- Table structure for table `sidebar_news`
--

CREATE TABLE `sidebar_news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module_id` int(11) DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `parent_position_no` int(11) DEFAULT '0',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `child_id` int(11) DEFAULT '0',
  `child_position_no` int(11) DEFAULT '0',
  `child_active_status` tinyint(4) NOT NULL DEFAULT '1',
  `route` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `infix_module_id` int(11) DEFAULT NULL,
  `role_id` int(10) UNSIGNED DEFAULT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sms_templates`
--

CREATE TABLE `sms_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'email, sms',
  `purpose` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `module` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `variable` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT 'Enable & Disable',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_templates`
--

INSERT INTO `sms_templates` (`id`, `type`, `purpose`, `subject`, `body`, `module`, `variable`, `status`, `school_id`, `created_at`, `updated_at`) VALUES
(1, 'sms', 'student_admission', '', 'Dear [student_name], Your Admission Is Completed You Can Login To Your Account Using username:[user_name] Password:[password]', '', '[student_name], [user_name], [password]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(2, 'sms', 'student_admission_for_parent', '', 'Dear Parent [parent_name], Your Child [student_name] Admission Is Completed You Can Login To Your Account Using username:[user_name] Password:[password]', '', '[parent_name], [student_name], [user_name], [password]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(3, 'sms', 'exam_schedule_for_student', '', 'Dear [student_name], your next exam: [exam_type] on [exam_date], [exam_time],Please Attend In Exam', '', '[student_name], [exam_type], [exam_date], [exam_time]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(4, 'sms', 'exam_schedule_for_parent', '', 'Dear [parent_name], your children [student_name] next exam: [exam_type] on [exam_date], [exam_time]', '', '[parent_name], [student_name], [exam_type], [exam_date], [exam_time]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(5, 'sms', 'user_login_permission', '', 'Dear [name], your login permission is disabled username:[user_name]', '', '[name], [user_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(6, 'sms', 'student_promote', '', 'Hi [student_name] , Welcome to [school_name]. Congratulations ! You have promoted in the next class.', '', '[student_name], [school_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(7, 'sms', 'communicate_sms', '', 'In Communicate SMS description is: [description]. Thank You.', '', '[description],', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(8, 'sms', 'student_attendance', '', 'Dear [student_name], your are came to the school at [attendance_date]', '', '[student_name], [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(9, 'sms', 'student_attendance_for_parent', '', 'Dear Parent [parent_name], your child [student_name] came to the school at [attendance_date]', '', '[parent_name], [student_name], [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(10, 'sms', 'staff_attendance', '', 'Dear [staff_name], your are came to the school at [attendance_date]', '', '[staff_name],[attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(11, 'sms', 'student_absent', '', 'Dear [student_name], your are absent to the school on [attendance_date]', '', '[student_name], [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(12, 'sms', 'student_absent_for_parent', '', 'Dear parent [parent_name], your child [student_name] is absent to the school on [attendance_date]', '', '[parent_name], [student_name], [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(13, 'sms', 'staff_absent', '', 'Dear [staff_name], your are absent to the school on [attendance_date]', '', '[staff_name], [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(14, 'sms', 'student_late', '', 'Dear [student_name], your are late to the school on [attendance_date]', '', '[student_late], [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(15, 'sms', 'student_late_for_parent', '', 'Dear parent [parent_name], your child [student_name] is late to the school on [attendance_date]', '', '[parent_name], [student_name], [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(16, 'sms', 'staff_late', '', 'Dear [staff_name], your are late to the school on [attendance_date]', '', '[staff_name], |StudentName|, [attendance_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(17, 'sms', 'student_early_checkout', '', 'Dear parent [parent_name], your child [student_name] is checkout  at [attendance_date] to the school on [attendance_date]', 'InfixBiometrics', '', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(18, 'sms', 'student_checkout', '', 'Dear Parent [parent_name], your child [student_name] left the school at [left_time]', 'InfixBiometrics', '', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(19, 'sms', 'staff_credentials', '', 'Dear staff [staff_name] your login details: username:[user_name] Password:[password]', '', '[staff_name], [user_name], [password]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(20, 'sms', 'holiday', '', 'This is to update you that [holiday_date] is holiday due to [holiday_name]', '', '[holiday_date], [holiday_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(21, 'sms', 'student_leave_appllication', '', 'Dear staff [student_name], Thank you for your leave application. Please wait for approval. Thanks', '', '[student_name],', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(22, 'sms', 'student_leave_approve', '', 'Dear staff [student_name], Thank you for your leave application. Your Leave approve. Thanks', '', '[student_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(23, 'sms', 'parent_leave_appllication_for_student', '', 'Dear staff [parent_name], Thank you for your leave [student_name] application. Please wait for approval. Thanks', '', '[parent_name], [student_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(24, 'sms', 'parent_leave_approve_for_student', '', 'Dear staff [staff_name], Thank you for your leave [student_name] application. Your Leave approve. Thanks', '', '[staff_name], [student_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(25, 'sms', 'staff_leave_appllication', '', 'Dear staff [staff_name], Thank you for your leave application. Please wait for approval. Thanks', '', '[staff_name],', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(26, 'sms', 'staff_leave_approve', '', 'Dear staff [staff_name], Thank you for your leave application. Your Leave approve. Thanks', '', '[staff_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(27, 'sms', 'student_birthday', '', 'Dear [student_name], Warm wishes to your birthday. Happy Birthday', '', '[student_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(28, 'sms', 'staff_birthday', '', 'Dear staff [staff_name], Warm wishes to your birthday. Happy Birthday. Thanks', '', '[staff_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(29, 'sms', 'student_library_book_issue', '', 'Dear [student_name], Library book  is issued to you studying in class: [class_name] , section: [section_name] with roll no:[roll_no] On [issue_date] .Please find the details , Book Title: [book_title], Book No: [book_no], Due Date: [due_date]', '', '[student_name], [class_name], [section_name],[roll_no],[issue_date], [book_title], [book_no], [due_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(30, 'sms', 'parent_library_book_issue', '', 'Dear parent [parent_name], Library book  is issued to your child [student_name] studying in class: [class_name] , section: [section_name] with roll no:[roll_no] On [issue_date] .Please find the details , Book Title: [book_title], Book No: [book_no], Due Date: [due_date]', '', '[parent_name], [student_name], [class_name], [section_name], [roll_no], [issue_date], [book_title], [book_no], [due_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(31, 'sms', 'student_re_issue_book', '', 'Dear [student_name], Library book  is returned by you studying in class: [class_name] , section: [section_name] with roll no:[roll_no] On [return_date] .Please find the details , Book Title: [book_title], Book No: [book_no], Issue Date: [issue_date], Due Date: [due_date]', '', '[student_name], [class_name], [section_name], [roll_no], [return_date], [issue_date], [book_title], [book_no], [due_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(32, 'sms', 'parent_re_issue_book', '', 'Dear parent [parent_name], Library book  is returned by your child [student_name] studying in class: [class_name] , section: [section_name] with roll no:[roll_no] On [return_date] .Please find the details , Book Title: [book_title], Book No: [book_no], Issue Date: [issue_date], Due Date: [due_date]', '', '[parent_name], [student_name], [class_name], [section_name], [roll_no], [return_date], [issue_date], [book_title], [book_no], [due_date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(33, 'sms', 'student_dues_fees', '', 'Hi [student_name], You fees due amount [dues_amount] for [fees_name] on [date]. Thanks', 'Fees', '', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(34, 'sms', 'student_dues_fees_for_parent', '', 'Hi [parent_name], You fees due amount [dues_amount] for [fees_name] on [date]. Thanks', 'Fees', '', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(35, 'sms', 'student_absent_notification', '', 'Hi [parent_name], Your child [student_name] absent for [number_of_subject] subjects. Those are [subject_list] on [date]. Thanks', '', '[parent_name], [student_name], [number_of_subject], [subject_list], [date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(36, 'next_implement', 'cheque_bounce', 'DEMO', 'Dear parent |ParentName|, the Cheque with no :|ChequeNo| for Rs.|FeePaid| received towards fee payment for your child :|StudentName| with receipt number:|ReceiptNo| has been Bounced', '', '', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(37, 'sms', 'student_admission_in_progress', '', 'Dear parent [parent_name], your child [student_name] admission is in process.', 'ParentRegistration', '[parent_name], [student_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(38, 'email', 'test_mail', 'Test Mail', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Test Mail</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [user_name] ,</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            It is test email . If your email configuration is okay then you will be got this email .\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[user_name]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(39, 'email', 'password_reset', 'Password Reset', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                    <tbody>\n                        <tr style=\"vertical-align:top;\" valign=\"top\">\n                            <td style=\"vertical-align:top;\" valign=\"top\">\n                                <div style=\"background-color:#415094;\">\n                                    <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                        <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                            <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                                <div class=\"col_cont\" style=\"width:100%;\">\n                                                    <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                        <a href=\"#\">\n                                                            <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                        </a>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                                <div style=\"background-color:#415094;\">\n                                    <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                        <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                            <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                                <div class=\"col_cont\" style=\"width:100%;\">\n                                                    <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                        <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                                <div style=\"background-color:#7c32ff;\">\n                                    <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                        <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                            <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                                <div class=\"col_cont\" style=\"width:100%;\">\n                                                    <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                        <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                            <span style=\"font-size:36px;\">Password Reset</span>\n                                                        </font>\n                                                    </h1>\n                                                    <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                        <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                            <h1>Hi [name],</h1>\n                                                            <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                                Tap the button below to reset your account password. If you didnt request a new password, you can safely delete this email.\n                                                            </p>\n                                                            <p style=\"text-align:center;margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\"> \n                                                                <a href=\"[reset_link]\" target=\"_blank\" style=\"font-size:12px;line-height:40px;background:#7c32ff;color:#fff;letter-spacing:1px;font-weight:500;padding:19px 52px;text-align:center;text-transform:uppercase;border:0;text-decoration:none;font-family:Arial, Helvetica Neue, Helvetica;\" rel=\"noreferrer noopener\">\n                                                                    RESET LINK\n                                                                </a>\n                                                            </p>\n                                                            <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                                This password reset link will expire in 60 minutes.\n                                                            </p>\n                                                            <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                                If you did not request a password reset, no further action is required.\n                                                            </p>\n                                                            <p style=\"text-align:left;margin:0px;line-height:1.8;\">\n                                                                <br>\n                                                            </p>\n                                                        </div>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                                <div style=\"background-color:#7c32ff;\">\n                                    <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                        <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                            <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                                <div class=\"col_cont\" style=\"width:100%;\">\n                                                    <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                        <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                            <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                                <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                    © 2020 Infix Education software| \n                                                                </span>\n                                                                <span style=\"background-color:transparent;text-align:left;\">\n                                                                    <font color=\"#ffffff\">\n                                                                        Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                    </font>\n                                                                </span>\n                                                                <br>\n                                                            </p>\n                                                        </div>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </td>\n                        </tr>\n                    </tbody>\n            </table>', '', '[name], [reset_link]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(40, 'email', 'student_login_credentials', 'Student Login Credentials', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Student Login Credentials</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [student_name] ,</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Welcome to [school_name]. Congratulations ! You have registered successfully. Please login using this username [username] and password [password]. Thanks.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[student_name], [school_name], [username], [password]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(41, 'email', 'frontend_contact', 'Contact', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Contact Email From : [contact_name]\n                                                            </br>\n                                                            Email : [contact_email]\n                                                            </br>\n                                                            Subject : [contact_subject]\n                                                            </br>\n                                                            message: [contact_message]\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[contact_name], [contact_email], [contact_subject], [contact_message],', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14');
INSERT INTO `sms_templates` (`id`, `type`, `purpose`, `subject`, `body`, `module`, `variable`, `status`, `school_id`, `created_at`, `updated_at`) VALUES
(42, 'email', 'communication_sent_email', 'Sent Email', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\"></span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1></h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Title : [title]\n                                                            </br>\n                                                            Description : [description]\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[title], [description]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(43, 'email', 'parent_login_credentials', 'Parent Login Credentials', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Parent Login Credentials</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [father_name] ,</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Welcome to [school_name]. Congratulations ! You have registered successfully. Please login using this username [username] and password [password]. Thanks.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[student_name], [father_name], [school_name], [username], [password]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(44, 'email', 'staff_login_credentials', 'Staff Login Credentials', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Staff Login Credentials</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [name] ,</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Welcome to [school_name]. Congratulations ! You have registered successfully. Please login using this username [username] and password [password]. Thanks.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[name], [school_name], [username], [password]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(45, 'email', 'dues_payment', 'Dues Payment', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Dues Payment</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [student_name],</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            You fees due amount [due_amount] for [fees_name] on [date]. Thanks\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', 'Fees', '[student_name], [due_amount], [fees_name], [date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(46, 'email', 'parent_reject_bank_payment', 'Reject Bank Payment', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Reject Bank Payment</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Dear [parent_name],</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            your child [student_name] fees rejected . Reject Note [note] [date].\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[parent_name], [student_name], [note], [date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(47, 'email', 'student_reject_bank_payment', 'Reject Bank Payment', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Reject Bank Payment</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Dear [student_name],</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Fees rejected . Reject Note [note] at [date] .\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', '', '[student_name], [note], [date]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14');
INSERT INTO `sms_templates` (`id`, `type`, `purpose`, `subject`, `body`, `module`, `variable`, `status`, `school_id`, `created_at`, `updated_at`) VALUES
(48, 'email', 'wallet_approve', 'Approve Wallet Payment', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Approve Wallet Payment</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [name],</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Your Wallet Diposit Request [add_balance] via [method] on [create_date] is approved by [school_name] .Your current balance is now [current_balance] <br> Thank You.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', 'Wallet', '[name], [add_balance], [method], [create_date], [school_name], [current_balance]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(49, 'email', 'wallet_reject', 'Reject Wallet Payment', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Reject Wallet Payment</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [name],</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Your Wallet Diposit Request [add_balance] via [method] on [create_date] is <strong>Reject</strong> by [school_name] <strong>Reason: [reject_reason] </strong> .Your current balance is now [current_balance] <br> Thank You.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', 'Wallet', '[name], [add_balance], [method], [create_date], [school_name], [reject_reason], [current_balance]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(50, 'email', 'fees_extra_amount_add', 'Fee Extra Amoun Add', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Fee Extra Amoun Add</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [name],</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Your Xtra Fees Amount Add [school_name] , In Your Wallet Amount:  [add_balance] . Which Is Fees Add Payment Via [method] on [create_date] Your previous Balance Was [previous_balance] <br> .Your Current Balance Is Now [current_balance] <br> Thank You.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', 'Wallet', '[name], [school_name], [add_balance], [method], [create_date], [previous_balance], [current_balance]', 1, 1, '2022-02-17 05:10:14', '2022-02-17 05:10:14'),
(51, 'email', 'wallet_refund', 'Wallet Refund', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Wallet Refund</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [name],</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Your Amount [refund_amount] Is Successfully Refunded by [school_name] on [create_date] <br>.Your Current Balance Is Now [current_balance] .Thank You.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', 'Wallet', '[name], [refund_amount], [school_name], [create_date], [current_balance]', 1, 1, '2022-02-17 05:10:15', '2022-02-17 05:10:15'),
(52, 'email', 'student_registration', 'Student Registration', '<table bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Student Registration</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [name] ,</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Welcome to [school_name]. Congratulations ! You have registered successfully.Thanks.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </table>', 'ParentRegistration', '[name], [school_name]', 1, 1, '2022-02-17 05:10:15', '2022-02-17 05:10:15'),
(53, 'email', 'student_registration_for_parents', 'Student Registration', '<tpSmsable bgcolor=\"#FFFFFF\" cellpadding=\"0\" cellspacing=\"0\" class=\"nl-container\" style=\"table-layout:fixed;vertical-align:top;min-width:320px;border-spacing:0;border-collapse:collapse;background-color:#FFFFFF;width:100%;\" width=\"100%\">\n                <tbody>\n                    <tr style=\"vertical-align:top;\" valign=\"top\">\n                        <td style=\"vertical-align:top;\" valign=\"top\">\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;background-position:center top;background-repeat:no-repeat;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center fixedwidth\" style=\"padding-right:30px;padding-left:30px;\">\n                                                    <a href=\"#\">\n                                                        <img border=\"0\" class=\"center fixedwidth\" src=\"\" style=\"padding-top:30px;padding-bottom:30px;text-decoration:none;height:auto;border:0;max-width:150px;\" width=\"150\" alt=\"logo.png\">\n                                                    </a>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#415094;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;padding-top:25px;border-top-right-radius:30px;border-top-left-radius:30px;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div align=\"center\" class=\"img-container center autowidth\" style=\"padding-right:20px;padding-left:20px;\">\n                                                    <img border=\"0\" class=\"center autowidth\" src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\" style=\"text-decoration:none;height:auto;border:0;max-width:541px;\" width=\"541\" alt=\"images?q=tbn:ANd9GcRGF00Oi-zJNU_EvYGueBVz_sqXmFjk8pxNtg&amp;usqp=CAU\">\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:#ffffff;border-bottom-right-radius:30px;border-bottom-left-radius:30px;overflow:hidden;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:#ffffff;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <h1 style=\"line-height:120%;text-align:center;margin-bottom:0px;\">\n                                                    <font color=\"#555555\" face=\"Arial, Helvetica Neue, Helvetica, sans-serif\">\n                                                        <span style=\"font-size:36px;\">Student Registration</span>\n                                                    </font>\n                                                </h1>\n                                                <div style=\"line-height:1.8;padding:20px 15px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.8;\">\n                                                        <h1>Hi [father_name] ,</h1>\n                                                        <p style=\"margin:10px 0px 30px;line-height:1.929;font-size:16px;color:rgb(113,128,150);\">\n                                                            Welcome to [school_name]. Congratulations ! You have registered successfully. Please login using this username [username] and password [password]. Thanks.\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div style=\"background-color:#7c32ff;\">\n                                <div class=\"block-grid\" style=\"min-width:320px;max-width:600px;margin:0 auto;background-color:transparent;\">\n                                    <div style=\"border-collapse:collapse;width:100%;background-color:transparent;\">\n                                        <div class=\"col num12\" style=\"min-width:320px;max-width:600px;vertical-align:top;width:600px;\">\n                                            <div class=\"col_cont\" style=\"width:100%;\">\n                                                <div style=\"color:#262b30;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;line-height:1.2;padding-top:30px;padding-right:5px;padding-bottom:5px;padding-left:5px;\">\n                                                    <div class=\"txtTinyMce-wrapper\" style=\"line-height:1.2;font-size:12px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;color:#262b30;\">\n                                                        <p style=\"margin:0;font-size:12px;line-height:1.2;text-align:center;margin-top:0;margin-bottom:0;\">\n                                                            <span style=\"font-size:14px;color:rgb(255,255,255);font-family:Arial;\">\n                                                                © 2020 Infix Education software| \n                                                            </span>\n                                                            <span style=\"background-color:transparent;text-align:left;\">\n                                                                <font color=\"#ffffff\">\n                                                                    Copyright &copy; 2020 All rights reserved | This application is made by Codethemes\n                                                                </font>\n                                                            </span>\n                                                            <br>\n                                                        </p>\n                                                    </div>\n                                                </div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </td>\n                    </tr>\n                </tbody>\n            </tpSable>', 'ParentRegistration', '[father_name], [school_name], [username], [password]', 1, 1, '2022-02-17 05:10:15', '2022-02-17 05:10:15');

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

--
-- Table structure for table `sm_about_pages`
--

CREATE TABLE `sm_about_pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `main_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_description` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_about_pages`
--

INSERT INTO `sm_about_pages` (`id`, `created_at`, `updated_at`, `title`, `description`, `main_title`, `main_description`, `image`, `main_image`, `button_text`, `button_url`, `active_status`, `created_by`, `updated_by`, `school_id`) VALUES
(1, NULL, NULL, 'About Infix', 'Lisus consequat sapien metus dis urna, facilisi. Nonummy rutrum eu lacinia platea a, ipsum parturient, orci tristique. Nisi diam natoque.', 'Under Graduate Education', 'INFIX has all in one place. You’ll find everything what you are looking into education management system software. We care! User will never bothered in our real eye catchy user friendly UI & UX  Interface design. You know! Smart Idea always comes to well planners. And Our INFIX is Smart for its Well Documentation. Explore in new support world! It’s now faster & quicker. You’ll find us on Support Ticket, Email, Skype, WhatsApp.', 'public/uploads/about_page/about.jpg', 'public/uploads/about_page/about-img.jpg', 'Learn More About Us', 'about', 1, 1, 1, 1);

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

--
-- Table structure for table `sm_academic_years`
--

CREATE TABLE `sm_academic_years` (
  `id` int(10) UNSIGNED NOT NULL,
  `year` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `starting_date` date NOT NULL,
  `ending_date` date NOT NULL,
  `copy_with_academic_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_academic_years`
--

INSERT INTO `sm_academic_years` (`id`, `year`, `title`, `starting_date`, `ending_date`, `copy_with_academic_year`, `active_status`, `created_at`, `updated_at`, `created_by`, `updated_by`, `school_id`) VALUES
(1, '2022', 'Jan-Dec', '2022-01-01', '2022-12-30', NULL, 1, '2022-01-01 00:00:00', '2022-01-01 00:00:00', 1, 1, 1);

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

--
-- Table structure for table `sm_add_expenses`
--

CREATE TABLE `sm_add_expenses` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `amount` double(10,2) DEFAULT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `item_receive_id` int(11) DEFAULT NULL,
  `inventory_id` int(11) DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expense_head_id` int(10) UNSIGNED DEFAULT NULL,
  `account_id` int(10) UNSIGNED DEFAULT NULL,
  `payment_method_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_add_incomes`
--

CREATE TABLE `sm_add_incomes` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `amount` double(10,2) DEFAULT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `item_sell_id` int(11) DEFAULT NULL,
  `fees_collection_id` int(11) DEFAULT NULL,
  `inventory_id` int(11) DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `income_head_id` int(10) UNSIGNED DEFAULT NULL,
  `account_id` int(10) UNSIGNED DEFAULT NULL,
  `payment_method_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_add_ons`
--

CREATE TABLE `sm_add_ons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_admission_queries`
--

CREATE TABLE `sm_admission_queries` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `date` date DEFAULT NULL,
  `follow_up_date` date DEFAULT NULL,
  `next_follow_up_date` date DEFAULT NULL,
  `assigned` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` int(11) DEFAULT NULL,
  `source` int(11) DEFAULT NULL,
  `no_of_child` int(11) DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `class` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_admission_query_followups`
--

CREATE TABLE `sm_admission_query_followups` (
  `id` int(10) UNSIGNED NOT NULL,
  `response` text COLLATE utf8mb4_unicode_ci,
  `note` text COLLATE utf8mb4_unicode_ci,
  `date` date DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `admission_query_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_amount_transfers`
--

CREATE TABLE `sm_amount_transfers` (
  `id` int(10) UNSIGNED NOT NULL,
  `amount` int(11) DEFAULT NULL,
  `purpose` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_payment_method` int(11) DEFAULT NULL,
  `from_bank_name` int(11) DEFAULT NULL,
  `to_payment_method` int(11) DEFAULT NULL,
  `to_bank_name` int(11) DEFAULT NULL,
  `transfer_date` date DEFAULT NULL,
  `active_status` tinyint(4) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_assign_class_teachers`
--

CREATE TABLE `sm_assign_class_teachers` (
  `id` int(10) UNSIGNED NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `class_id` int(10) UNSIGNED DEFAULT NULL,
  `section_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_assign_subjects`
--

CREATE TABLE `sm_assign_subjects` (
  `id` int(10) UNSIGNED NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `teacher_id` int(10) UNSIGNED DEFAULT NULL,
  `class_id` int(10) UNSIGNED DEFAULT NULL,
  `section_id` int(10) UNSIGNED DEFAULT NULL,
  `subject_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_assign_vehicles`
--

CREATE TABLE `sm_assign_vehicles` (
  `id` int(10) UNSIGNED NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `vehicle_id` int(10) UNSIGNED DEFAULT NULL,
  `route_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_background_settings`
--

CREATE TABLE `sm_background_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` int(11) NOT NULL DEFAULT '0',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_background_settings`
--

INSERT INTO `sm_background_settings` (`id`, `title`, `type`, `image`, `color`, `is_default`, `school_id`, `created_at`, `updated_at`) VALUES
(1, 'Dashboard Background', 'image', 'public/backEnd/img/body-bg.jpg', '', 1, 1, NULL, NULL),
(2, 'Login Background', 'image', 'public/backEnd/img/login-bg.jpg', '', 0, 1, NULL, NULL);

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

--
-- Table structure for table `sm_backups`
--

CREATE TABLE `sm_backups` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_type` tinyint(4) DEFAULT NULL COMMENT '0=Database, 1=File, 2=Image',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_bank_accounts`
--

CREATE TABLE `sm_bank_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opening_balance` double NOT NULL DEFAULT '0',
  `current_balance` double NOT NULL DEFAULT '0',
  `note` text COLLATE utf8mb4_unicode_ci,
  `active_status` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_bank_payment_slips`
--

CREATE TABLE `sm_bank_payment_slips` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `amount` double(10,2) DEFAULT NULL,
  `slip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `bank_id` int(11) DEFAULT NULL,
  `approve_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 pending, 1 approve',
  `payment_mode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Bk= bank, Cq=Cheque',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `fees_discount_id` int(10) UNSIGNED DEFAULT NULL,
  `fees_type_id` int(10) UNSIGNED DEFAULT NULL,
  `student_id` int(10) UNSIGNED DEFAULT NULL,
  `class_id` int(10) UNSIGNED NOT NULL,
  `assign_id` int(10) UNSIGNED DEFAULT NULL,
  `section_id` int(10) UNSIGNED NOT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_bank_statements`
--

CREATE TABLE `sm_bank_statements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bank_id` int(11) DEFAULT NULL,
  `after_balance` int(11) DEFAULT NULL,
  `amount` double(10,2) DEFAULT NULL,
  `type` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1 for Income 0 for Expense',
  `payment_method` int(10) UNSIGNED DEFAULT NULL,
  `details` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_receive_id` int(11) DEFAULT NULL,
  `item_receive_bank_statement_id` int(11) DEFAULT NULL,
  `item_sell_bank_statement_id` int(11) DEFAULT NULL,
  `item_sell_id` int(11) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_base_groups`
--

CREATE TABLE `sm_base_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_base_groups`
--

INSERT INTO `sm_base_groups` (`id`, `name`, `active_status`, `created_at`, `updated_at`, `created_by`, `updated_by`, `school_id`) VALUES
(1, 'Gender', 1, '2022-02-17 05:09:54', NULL, 1, 1, 1),
(2, 'Religion', 1, '2022-02-17 05:09:54', NULL, 1, 1, 1),
(3, 'Blood Group', 1, '2022-02-17 05:09:54', NULL, 1, 1, 1);

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

--
-- Table structure for table `sm_base_setups`
--

CREATE TABLE `sm_base_setups` (
  `id` int(10) UNSIGNED NOT NULL,
  `base_setup_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `base_group_id` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_base_setups`
--

INSERT INTO `sm_base_setups` (`id`, `base_setup_name`, `active_status`, `created_at`, `updated_at`, `created_by`, `updated_by`, `base_group_id`, `school_id`) VALUES
(1, 'Male', 1, '2022-02-17 05:09:54', NULL, 1, 1, 1, 1),
(2, 'Female', 1, '2022-02-17 05:09:54', NULL, 1, 1, 1, 1),
(3, 'Others', 1, '2022-02-17 05:09:54', NULL, 1, 1, 1, 1),
(4, 'Islam', 1, '2022-02-17 05:09:54', NULL, 1, 1, 2, 1),
(5, 'Hinduism', 1, '2022-02-17 05:09:54', NULL, 1, 1, 2, 1),
(6, 'Sikhism', 1, '2022-02-17 05:09:54', NULL, 1, 1, 2, 1),
(7, 'Buddhism', 1, '2022-02-17 05:09:54', NULL, 1, 1, 2, 1),
(8, 'Protestantism', 1, '2022-02-17 05:09:54', NULL, 1, 1, 2, 1),
(9, 'A+', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1),
(10, 'O+', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1),
(11, 'B+', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1),
(12, 'AB+', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1),
(13, 'A-', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1),
(14, 'O-', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1),
(15, 'B-', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1),
(16, 'AB-', 1, '2022-02-17 05:09:54', NULL, 1, 1, 3, 1);

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

--
-- Table structure for table `sm_books`
--

CREATE TABLE `sm_books` (
  `id` int(10) UNSIGNED NOT NULL,
  `book_title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `book_number` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isbn_no` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publisher_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rack_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int(11) DEFAULT '0',
  `book_price` int(11) DEFAULT NULL,
  `post_date` date DEFAULT NULL,
  `details` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `book_subject_id` int(10) UNSIGNED DEFAULT NULL,
  `book_category_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_book_categories`
--

CREATE TABLE `sm_book_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_book_issues`
--

CREATE TABLE `sm_book_issues` (
  `id` int(10) UNSIGNED NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `given_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `issue_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `book_id` int(10) UNSIGNED DEFAULT NULL,
  `member_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_chart_of_accounts`
--

CREATE TABLE `sm_chart_of_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `head` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'E = expense, I = income',
  `active_status` int(11) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_chart_of_accounts`
--

INSERT INTO `sm_chart_of_accounts` (`id`, `head`, `type`, `active_status`, `created_at`, `updated_at`, `created_by`, `updated_by`, `school_id`, `academic_id`) VALUES
(1, 'Fees Collection', 'I', 1, '2022-02-17 05:09:55', '2022-02-17 05:09:55', 1, 1, 1, NULL);

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

--
-- Table structure for table `sm_classes`
--

CREATE TABLE `sm_classes` (
  `id` int(10) UNSIGNED NOT NULL,
  `class_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_class_optional_subject`
--

CREATE TABLE `sm_class_optional_subject` (
  `id` int(10) UNSIGNED NOT NULL,
  `class_id` int(11) NOT NULL,
  `gpa_above` double(8,2) NOT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_class_rooms`
--

CREATE TABLE `sm_class_rooms` (
  `id` int(10) UNSIGNED NOT NULL,
  `room_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capacity` int(11) DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_class_routines`
--

CREATE TABLE `sm_class_routines` (
  `id` int(10) UNSIGNED NOT NULL,
  `monday` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monday_start_from` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monday_end_to` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monday_room_id` int(10) UNSIGNED DEFAULT NULL,
  `tuesday` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tuesday_start_from` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tuesday_end_to` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tuesday_room_id` int(10) UNSIGNED DEFAULT NULL,
  `wednesday` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wednesday_start_from` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wednesday_end_to` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wednesday_room_id` int(10) UNSIGNED DEFAULT NULL,
  `thursday` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thursday_start_from` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thursday_end_to` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thursday_room_id` int(10) UNSIGNED DEFAULT NULL,
  `friday` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `friday_start_from` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `friday_end_to` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `friday_room_id` int(10) UNSIGNED DEFAULT NULL,
  `saturday` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `saturday_start_from` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `saturday_end_to` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `saturday_room_id` int(10) UNSIGNED DEFAULT NULL,
  `sunday` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sunday_start_from` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sunday_end_to` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sunday_room_id` int(10) UNSIGNED DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `class_id` int(10) UNSIGNED DEFAULT NULL,
  `section_id` int(10) UNSIGNED DEFAULT NULL,
  `subject_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_class_routine_updates`
--

CREATE TABLE `sm_class_routine_updates` (
  `id` int(10) UNSIGNED NOT NULL,
  `day` int(11) DEFAULT NULL COMMENT '1=sat,2=sun,7=fri',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `room_id` int(10) UNSIGNED DEFAULT NULL,
  `teacher_id` int(10) UNSIGNED DEFAULT NULL,
  `class_period_id` int(10) UNSIGNED DEFAULT NULL,
  `subject_id` int(10) UNSIGNED DEFAULT NULL,
  `class_id` int(10) UNSIGNED DEFAULT NULL,
  `section_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1',
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `is_break` tinyint(4) DEFAULT NULL COMMENT '1 = tiffin time, 0 = class'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_class_sections`
--

CREATE TABLE `sm_class_sections` (
  `id` int(10) UNSIGNED NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `class_id` int(10) UNSIGNED DEFAULT NULL,
  `section_id` int(10) UNSIGNED DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_class_teachers`
--

CREATE TABLE `sm_class_teachers` (
  `id` int(10) UNSIGNED NOT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `teacher_id` int(10) UNSIGNED DEFAULT NULL,
  `assign_class_teacher_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_class_times`
--

CREATE TABLE `sm_class_times` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` enum('exam','class') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `period` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `is_break` tinyint(4) DEFAULT NULL COMMENT '1 = tiffin time, 0 = class',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_complaints`
--

CREATE TABLE `sm_complaints` (
  `id` int(10) UNSIGNED NOT NULL,
  `complaint_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complaint_type` tinyint(4) DEFAULT NULL,
  `complaint_source` tinyint(4) DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `action_taken` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_contact_messages`
--

CREATE TABLE `sm_contact_messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `view_status` tinyint(4) NOT NULL DEFAULT '0',
  `reply_status` tinyint(4) NOT NULL DEFAULT '0',
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_contact_pages`
--

CREATE TABLE `sm_contact_pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zoom_level` int(11) DEFAULT NULL,
  `google_map_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_contact_pages`
--

INSERT INTO `sm_contact_pages` (`id`, `title`, `description`, `image`, `button_text`, `button_url`, `address`, `address_text`, `phone`, `phone_text`, `email`, `email_text`, `latitude`, `longitude`, `zoom_level`, `google_map_address`, `active_status`, `created_at`, `updated_at`, `created_by`, `updated_by`, `school_id`) VALUES
(1, 'Contact Us', 'Have any questions? We’d love to hear from you! Here’s how to get in touch with us.', 'public/uploads/contactPage/contact.jpg', 'Learn More About Us', 'about', '56/8 Panthapath, Dhanmondi,Dhaka', 'Santa monica bullevard', '0184113625', 'Mon to Fri 9am to 6 pm', 'admin@infixedu.com', 'Send us your query anytime!', '23.707310', '90.415480', 15, 'Panthapath, Dhaka', 1, NULL, NULL, 1, 1, 1);

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

--
-- Table structure for table `sm_content_types`
--

CREATE TABLE `sm_content_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `type_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT '1',
  `updated_by` int(10) UNSIGNED DEFAULT '1',
  `school_id` int(10) UNSIGNED DEFAULT '1',
  `academic_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sm_countries`
--

CREATE TABLE `sm_countries` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `native` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `continent` varchar(255) DEFAULT NULL,
  `capital` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `languages` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sm_courses`
--

CREATE TABLE `sm_courses` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `overview` text COLLATE utf8mb4_unicode_ci,
  `outline` text COLLATE utf8mb4_unicode_ci,
  `prerequisites` text COLLATE utf8mb4_unicode_ci,
  `resources` text COLLATE utf8mb4_unicode_ci,
  `stats` text COLLATE utf8mb4_unicode_ci,
  `active_status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(10) UNSIGNED DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_courses`
--

INSERT INTO `sm_courses` (`id`, `title`, `image`, `category_id`, `overview`, `outline`, `prerequisites`, `resources`, `stats`, `active_status`, `created_at`, `updated_at`, `school_id`) VALUES
(1, 'Architecto aliquid dolor enim aliquid eaque.', 'public/uploads/course/academic1.jpg', 0, 'Dolorem aut inventore enim iusto quasi molestiae. Dolorem ut non et et beatae. Tempore a consectetur provident mollitia possimus commodi. Quas totam sit quas quisquam. At perferendis quisquam optio quas. Harum debitis non voluptatum quae. Enim repellendus blanditiis soluta asperiores porro aut. Fugiat sed dolorem velit sint magnam est dolorem. Libero laboriosam in omnis itaque placeat iusto. Magnam qui aut ut. Sed impedit quis eos. Sed facere dolor ratione distinctio. Eveniet quibusdam impedit voluptate ipsam voluptatem optio quisquam esse. Nemo omnis illo vel vel culpa similique suscipit. Quibusdam sed accusantium culpa labore vel. Modi est tempore rerum eveniet. Eos explicabo nobis consequatur. Rerum error voluptatem nihil earum earum. Sunt cupiditate et dolores sunt velit. Inventore totam voluptatem neque architecto et qui repellat. Natus et qui fugiat consequatur. Et occaecati beatae rerum modi voluptatem in. Ipsum eum qui accusamus nobis quia et deleniti dignissimos. Soluta eaque voluptas quaerat distinctio. Laudantium quaerat deserunt et nihil. Quam sint corrupti asperiores assumenda vitae et. Eveniet nulla similique reprehenderit occaecati. Aut occaecati laborum architecto sed. Omnis molestiae quidem veritatis eius dicta impedit molestias. Et dolor velit sit odio. Et veritatis ut vel. Necessitatibus dignissimos modi velit. Iste sit distinctio sunt iusto nihil. Minus qui est et quaerat qui voluptatibus. Modi nulla natus ut eligendi. Consequatur quisquam ducimus sint adipisci error corporis adipisci aperiam. Tempora ea incidunt necessitatibus. Iure magnam id nihil aut velit. Quia aspernatur dolores laborum autem ratione quam at. Assumenda quia explicabo debitis alias eius. Omnis non nobis vitae neque. Quia sint accusamus voluptate mollitia sint in facilis. Repudiandae voluptatem sed et blanditiis et quas et. Est culpa atque ab sint aut earum voluptatum labore. Expedita distinctio omnis eos nam laudantium.', 'Porro aut quia laborum. Et sed quasi dolor est velit est veritatis. Vel neque tempore deserunt sint voluptas dolorem quod. Exercitationem beatae earum id. Eum doloribus aut doloremque aperiam quod itaque amet. Eos modi aliquam adipisci officia. Dignissimos in veritatis ullam recusandae. Dolor sed ut distinctio quaerat omnis deserunt aut. Quas dolor est iste. Dolorem earum iusto quia id velit animi. Architecto ipsum exercitationem nobis molestiae hic voluptatibus. Ipsum et qui sint similique cupiditate nostrum soluta. Facilis placeat aut modi adipisci. Consectetur at inventore iusto nisi. Doloribus impedit quod placeat. Vero quasi debitis sunt sit dicta sit et. Quis perspiciatis omnis laboriosam placeat repellat quo laboriosam asperiores. Cupiditate omnis eos asperiores. Sapiente autem eaque tempore laborum. Deserunt dolor possimus distinctio minima. Molestias doloremque aperiam accusantium repudiandae. Non iure est maxime aut non aut perspiciatis. Doloribus deleniti minus qui asperiores aliquid perspiciatis corporis. Omnis eius voluptatem quo dolor. Laborum alias non et autem consectetur. Saepe error dolorum quia est consequatur et. Quia labore cum deserunt ipsa consequatur. Quae vel est corporis. Porro voluptatibus sapiente iusto consequatur eligendi. Necessitatibus placeat earum quae sed adipisci. Temporibus itaque eaque magnam quae totam. Numquam fuga neque ut at laudantium eius non. Sunt ut eum qui iste dolor. Voluptate ut dolorem omnis voluptatibus qui. Et vel ratione ducimus consectetur esse eos id. Nostrum non magni inventore est fuga nisi dolorum. Molestias alias sit doloribus modi voluptatem. Quod explicabo error in eligendi nihil eligendi iste. Harum inventore eum assumenda. Maiores excepturi illum ea sit cupiditate placeat. Sapiente beatae maiores excepturi omnis velit. Voluptatum dolores aut veniam repellendus qui. Est enim et ex cupiditate ratione placeat tempore. In quis magni vel et aperiam maxime.', 'Libero accusantium et voluptatem officia alias delectus. Omnis saepe itaque est suscipit esse nobis necessitatibus. Vero doloribus et asperiores natus vel qui corrupti atque. At quis libero voluptas voluptas in soluta. Accusamus vero a dolor fugit ipsa voluptate assumenda eum. Animi minus reprehenderit modi veniam suscipit quaerat. Perferendis similique qui minima. Rerum et eos dolorum quae fugit sit quis. Aliquid maiores commodi modi sed incidunt. Vel dicta ipsa qui. Autem et est sit et sed illo impedit. Nihil exercitationem rerum voluptatem consequatur vel suscipit vel. Aspernatur et sed tempore est est possimus ab. Ipsa dolorem provident culpa enim ut. Et ea voluptatum nemo et quis magni. Excepturi voluptatibus aperiam ut ducimus. Corrupti laborum perspiciatis nihil. Harum voluptatem aliquam natus soluta officia tempore. Et optio accusamus qui vel porro. Id fuga aut dolores dolore voluptas aut. Maxime dolores nobis consectetur quia ea voluptates. Alias voluptatem odit illum at nihil autem expedita. Aut officia sed qui et et. Ut magnam dolorem labore dolor voluptate voluptates. Ex tenetur labore reiciendis nobis accusamus voluptates. Accusantium modi fugiat eaque incidunt recusandae provident. Cumque sunt architecto autem accusantium quis magnam. Sapiente aut ad laboriosam neque id repellendus fuga. Et quia est voluptas placeat aliquid minima cupiditate. Reprehenderit deserunt vitae consectetur rerum temporibus ipsum. Expedita autem quos magni voluptatum voluptas. Rerum esse et consequuntur. Eos debitis repellat voluptatem sint. Dolores illo porro nesciunt dolores omnis. Velit voluptas soluta earum illo doloribus ratione eum. Dicta consequatur omnis nesciunt quibusdam voluptatum ratione sit ratione. In ex hic aut corporis et et voluptates. Non quia voluptatem magni quia provident velit. Eos iste porro facilis magnam. Iure exercitationem voluptas ut eum et et dolorem soluta. Occaecati voluptatem quo quisquam ullam.', 'Commodi animi voluptatem asperiores placeat est illo. Deleniti porro iste nihil voluptatibus inventore repellendus sunt. Qui nihil nobis quia. Laboriosam earum sed sed impedit. Expedita alias aut a eos dolorem. Error temporibus error iure aperiam rerum. Voluptas labore quaerat nobis quia. Ut laborum quae autem velit dolorum cum. Ducimus aut et corrupti. Voluptatem dolores fugit sapiente labore aut dolor praesentium ratione. Voluptate soluta vero omnis. Quo quaerat similique culpa sed minus corporis. Adipisci eaque quis dolorum saepe. Ad commodi necessitatibus sit quis veritatis ut ea. Facilis voluptatum et quia est doloribus. Accusantium laboriosam ipsa eaque omnis. Expedita fugiat natus nulla eligendi molestiae ut. Aut saepe provident animi consequuntur labore velit. Qui necessitatibus voluptatem dolorum aliquid. In itaque esse autem tempore tempora eos officia. Repellendus exercitationem in iusto id itaque et quo. Alias et repudiandae accusamus. Alias quidem qui aut quis. Sed aut qui sint doloremque exercitationem explicabo tempore. Necessitatibus architecto illum assumenda voluptatem. Assumenda eius harum pariatur est commodi est. Molestias qui rerum earum dolor. Molestiae repellat harum qui provident tempore sit sint. Aliquam exercitationem et enim hic dolorem quo. Eveniet nulla consequuntur doloribus sapiente quos eius consequatur. Atque vitae nisi dolor quo ad facere minima eveniet. Libero tenetur a exercitationem qui est alias non. Accusantium maxime ad corporis quam est rerum eos ut. Qui placeat et tenetur ut saepe eligendi aperiam quo. Nihil dolores ullam dolore eum nihil vitae quia. Libero eaque ab quae reprehenderit. Harum quia in accusantium qui accusantium quis nihil est. Et ut modi vel illum non perspiciatis quia. Facilis quia deleniti totam velit non. Minima et dolor similique quisquam et. Vero odit qui impedit eaque. Ea officia voluptate qui quaerat et ex. Quia ex dolor totam.', 'Hic blanditiis alias modi sed corporis illum. Eius veniam dolorem qui optio. Odio ut quae labore harum error. Minima laboriosam dolorum omnis nulla doloremque ab. Ut sint voluptatibus aut assumenda et cumque. Quisquam eum consequatur nulla harum. Nam totam et reiciendis vel quia et. Quibusdam aut qui sed consequatur. Perspiciatis recusandae cumque maxime hic. Provident sit nihil itaque sed. Reprehenderit at numquam voluptas ut velit aspernatur. Dolor molestiae est consectetur sed commodi quibusdam inventore. Dicta itaque possimus reprehenderit molestiae aut. Dolorem nam omnis repudiandae nulla velit. Neque corporis ut ipsam numquam quo quam. Id aut vero odit consequuntur. Quia omnis voluptas dolorem veniam ut itaque. Illum delectus qui sed facilis et est deserunt nisi. Fugit quia omnis earum. Quasi tempora dolorum dolorum minus quae. Dolorem molestiae voluptatem officia sed dolore consectetur consequuntur eos. Perferendis suscipit nihil quo cumque. Et dolore autem voluptate ut. At nostrum eveniet commodi vitae voluptatibus aut rerum. Et sunt dignissimos sit consequatur. Iure aut maiores ut doloremque molestias et quam distinctio. Unde et voluptatem aut occaecati. Adipisci corporis exercitationem possimus qui voluptatem tempora incidunt mollitia. Dolorum tenetur est voluptatem iusto reiciendis sequi voluptates. Eos omnis sit odit perferendis consequatur. Consequatur sequi cumque nobis quas. Molestiae ea possimus rem beatae sit quo. Rem quo cumque laudantium tenetur. Quis omnis sed sed nesciunt mollitia sit. Molestiae blanditiis quasi deleniti non sint. Placeat commodi explicabo et et. Natus voluptatibus libero provident. Sed ut ut facilis qui aperiam. Aliquid perferendis officia sit itaque dolores neque. Aut illo architecto non qui omnis est exercitationem. Harum et facere iure molestiae est voluptate at dolore. Harum laboriosam eveniet quo similique dolores est tempore. Velit cum sunt qui adipisci distinctio nihil. Distinctio numquam et laboriosam sed omnis.', 1, '2022-02-17 05:10:09', NULL, 1),
(2, 'Quia numquam perspiciatis et et qui facere aut.', 'public/uploads/course/academic3.jpg', 0, 'Qui et non aperiam iure pariatur fugit earum. Ducimus tenetur libero magni rerum consequatur. Dolorum laboriosam id sit. Ratione perspiciatis neque eum. Sit error voluptatem quisquam perspiciatis pariatur. Doloremque quidem voluptas facilis doloribus culpa corrupti. Sunt corrupti atque est architecto itaque soluta vitae. Et rerum est quam enim autem ut rerum. Ut quaerat in eum fuga sit. Est quidem harum adipisci dolor non sequi cumque. Sequi et enim est animi qui. Quia sapiente dicta molestiae consequatur est placeat vel corporis. Doloremque explicabo fugit aperiam expedita. Et quisquam at voluptatibus et et quo unde non. Et blanditiis explicabo quibusdam id. Sunt praesentium tempore repellendus soluta eum. Eius officiis sunt voluptatem consequuntur. Fugit accusantium autem ipsum nihil magnam rerum. Et earum quo debitis. Delectus velit aut ex iure illo eligendi. Hic veritatis ad et velit omnis repellendus. Soluta odit neque a placeat suscipit eos. Iste quas fugiat quo amet nihil vel dolore. Excepturi ea voluptatibus aperiam minus excepturi iusto ratione. Ut aliquid doloremque est ut atque. Vitae alias minus error eveniet velit. Quam quia atque odit consequatur quaerat voluptatem. Ipsa corrupti nihil deserunt non illo quidem. Voluptas aut dolor ipsam cumque corrupti. Qui eligendi in consequatur repellendus iure alias. Accusamus consequatur voluptatem sint aut. Explicabo consequatur veniam consectetur sed nesciunt earum rerum corporis. Eum quisquam voluptas sint a ut ad ex. Error molestiae ut tempora autem. Est quia quis dolore quod. Vel voluptas eum saepe qui mollitia eum omnis nulla. Sed velit at reiciendis corporis odit quis nostrum. Consectetur consequuntur dolor cum qui aut. Quam corrupti ut deserunt nemo voluptas error et sit. Dolor cupiditate qui explicabo occaecati deleniti qui voluptas. Est accusantium modi omnis cumque sed molestiae. Repellat et quidem dolor libero at.', 'Adipisci veritatis sunt aliquid et. Nulla et nisi at quibusdam sint. Impedit consectetur voluptatem omnis. Animi vel quas quasi et sit magni. Est consequuntur illum delectus occaecati. Porro voluptates nobis nostrum pariatur sint quibusdam cupiditate nihil. Debitis ab nulla ab debitis sed voluptates est non. At consequatur libero iste nihil nesciunt repellat ex voluptatem. At velit iusto suscipit architecto distinctio. Perspiciatis dolore sunt voluptatum quam eaque. Sed adipisci velit delectus. Quas sed aut tempore accusantium totam provident. Amet perferendis et eum architecto eveniet reiciendis unde. Eos sed suscipit corrupti esse. Similique non architecto architecto ab ducimus minus. Et sapiente odit non atque quisquam qui nam rerum. Corporis dolorem saepe cum nulla mollitia. Optio consectetur perferendis magnam iure et. Placeat sint doloribus suscipit dolore voluptatem. Molestiae non autem soluta ab maxime consequatur officia. Voluptas delectus vel nostrum modi nostrum ipsam. Quae est ipsam ducimus qui unde quam. Repudiandae similique nam dolorem eum odio. Mollitia minima necessitatibus cumque pariatur vitae adipisci. Debitis quis cupiditate est vitae voluptas. Quas illum odit expedita necessitatibus unde harum. Non sunt veritatis laboriosam. Ullam illo rerum iusto temporibus amet blanditiis aliquid cum. Qui dolorem voluptate ut velit. Distinctio ea animi consequuntur necessitatibus sed quae. Quis voluptatem ipsum veniam dolorem est. Dolores non aspernatur officiis aut. Velit quaerat nihil pariatur dolorum repellendus. Suscipit dignissimos similique harum consequatur possimus sed. Adipisci totam cum quia omnis vel impedit est minus. Et rerum sit illo accusamus quasi explicabo. Ut eius aut sit aperiam velit assumenda. Deserunt non dolore odit. Eum quis pariatur necessitatibus reprehenderit quis. Earum pariatur hic similique temporibus saepe.', 'Autem qui culpa nihil nemo eligendi. Eum maiores asperiores fugit et ducimus nihil. Sequi occaecati ducimus ipsa aut. Harum debitis aut consequatur. Non commodi reprehenderit amet enim culpa non. Sed et dolorem officiis illo perferendis. Facere qui voluptas nemo voluptatem qui alias. Voluptatem quibusdam qui consequatur dolorum aut similique. Accusantium incidunt dicta quasi laudantium nemo. Consequatur eaque porro ipsam veritatis quia. Id est eum quod et distinctio. Quis dolore rem rerum sunt impedit accusantium impedit. Quisquam impedit et provident ipsa porro ad voluptatem est. Excepturi omnis aliquid aut accusamus sed repellat. Aliquid voluptatem sunt atque saepe unde est sint. Provident a corporis corrupti reiciendis voluptatem. Voluptatem nam soluta qui. Et non fugiat vitae corrupti. Soluta deserunt et et non atque eius. Voluptatum dolores consectetur recusandae quis consequatur ea. Voluptas error aut aut amet architecto exercitationem. Sapiente quo dolores enim qui. Unde sit est est sit. Unde totam expedita ex aut quia. Et recusandae fugiat commodi ipsa voluptatum sint. Suscipit ratione omnis esse praesentium eaque iure ipsum. Id sint sapiente sequi et magni reiciendis repudiandae. Assumenda et quia maxime. Veritatis et autem dolorem animi. Mollitia non rerum est repellat hic placeat. Qui ut dolorum porro. Beatae omnis dignissimos et officiis eos harum. Eos in et omnis id repellendus. Molestias et qui atque unde vero fuga est. Ipsam reiciendis et dignissimos perspiciatis aut est quo. Minus maiores iste modi ex. Culpa earum numquam et dolores a. Impedit repellendus aspernatur nemo doloremque quia. Dignissimos voluptas porro vero velit maxime qui dolor. Similique impedit at deleniti qui. Fugit ducimus necessitatibus consectetur ea est quam. Qui iste placeat et quidem a maxime. Et qui animi voluptates. Ullam voluptas reprehenderit accusamus quia aut. Minima qui iste aut vero voluptas. Non ea est rem neque maiores et sed.', 'Eum tempore sed omnis eum dolores. Perspiciatis cum et ut facere. Mollitia nisi ut dolore. Est sed voluptate nulla aut illum debitis. Delectus possimus aliquam officia voluptatibus possimus veniam quidem. Quisquam ut perferendis vel accusantium iusto sed. Eos quia esse sit ipsam placeat sed. Vel expedita itaque nemo ut voluptatem aspernatur animi. Ratione voluptatibus blanditiis qui qui ab. Totam qui voluptatem qui qui nostrum. Sunt ad cum voluptas dolore dicta suscipit autem. Possimus nihil ut ducimus itaque sint beatae. Iure et tempore et quidem a qui. Nihil distinctio cupiditate consequatur et amet suscipit iste. Inventore ut delectus dolorum officiis dignissimos non. Rem deserunt aut natus ducimus. Qui maxime minus ipsa sit reiciendis possimus. Repudiandae qui doloribus consectetur. Fugit et incidunt a voluptas. Alias delectus voluptatem temporibus molestiae tempora. Provident molestiae temporibus est veniam. Quos in consequatur qui aut qui totam rerum. Omnis minus recusandae id suscipit aliquam. Accusantium dolor non quod optio est. Modi et consequatur suscipit dolore perspiciatis. Autem porro aliquid error qui quisquam. Labore et saepe necessitatibus. Voluptatem alias dolores voluptatem. Vero beatae tempore et qui ad dolores recusandae. Aliquam consectetur voluptatem quaerat iste iure. Delectus et et ipsum quo officiis. Nemo officiis distinctio ea pariatur molestiae. Esse et quaerat asperiores eos. Est deserunt laboriosam pariatur. Aliquam esse voluptas pariatur molestiae. Eos dolor facilis qui molestias fuga. Molestiae illo iusto quam ut quia doloremque quaerat repudiandae. Itaque eum nemo aut qui velit voluptas eum tenetur. Quasi velit eligendi corrupti repellendus veniam aut numquam. Atque ut eaque et iusto beatae qui. Voluptas corrupti quasi sed ut ut quos. Atque distinctio inventore eaque rerum deleniti. Officia sint debitis repudiandae est aut.', 'Est commodi reiciendis dignissimos molestiae aperiam. Pariatur minima harum reprehenderit et quae. Qui voluptas deleniti commodi et sunt. Doloribus nihil asperiores non voluptatem ut. Facere autem reprehenderit nulla dolor ut eos nulla nulla. Voluptatem aut sed repellat esse. Nobis et at ducimus adipisci eos eius. Praesentium aspernatur laudantium ea expedita voluptas fugiat voluptatem. Velit aut voluptas quod quis. Ducimus molestiae alias sint et harum. Doloremque illo enim expedita ut ullam. Vitae quia non excepturi blanditiis quis excepturi. Doloremque id qui velit in. Architecto est sunt cumque magnam expedita. Ducimus quibusdam inventore accusantium odio libero est. Non ea quis eaque impedit quibusdam quam accusantium cum. Nulla et illo rerum. Laboriosam dolorum et quaerat et provident. Qui odit qui officiis illum suscipit. Debitis atque corrupti dignissimos eaque. Delectus soluta consequatur adipisci autem molestiae sit enim. Sed quo doloremque labore ipsa excepturi officiis. Id ducimus voluptas sapiente et enim et hic. In exercitationem aut ea. Architecto non blanditiis ut in maiores in. Quas modi laboriosam id et. Eum molestiae autem pariatur necessitatibus impedit alias neque. Temporibus consequatur aut sed maxime nam. Ad quasi aut quibusdam vitae aperiam. Dolore aut doloribus quia reprehenderit voluptatem quasi magni. Atque ipsa debitis minus quia. Sit et autem quo sit. Nisi sunt vitae vero rem. Porro sint non consequatur. Quis molestiae sequi repudiandae non ullam sint. Pariatur esse non nobis et animi sit repudiandae. Est numquam doloribus et quidem eligendi. Id qui dolore inventore reiciendis maxime vero. Quia dignissimos quo modi cupiditate suscipit sequi. Ea enim reiciendis voluptatem et. Aut autem quia hic qui. Deleniti perspiciatis et velit cupiditate. Ad est sit facere voluptatibus dolores minus ut. Corrupti esse mollitia corrupti sit.', 1, '2022-02-17 05:10:09', NULL, 1),
(3, 'Ratione rerum sapiente repellat.', 'public/uploads/course/academic5.jpg', 0, 'Voluptatum aut qui qui sed veniam. Quia magni id pariatur repudiandae alias. Et ullam sequi quia cupiditate. Est sed non sit provident enim recusandae nemo. Atque ad eius cupiditate reiciendis. Atque dolor quam molestiae itaque non est. Similique aliquid voluptas et cumque qui odit. Et fuga et ut perferendis provident sit. Ut reprehenderit deserunt quis rem ratione. Voluptates a nobis voluptatum ducimus rerum ipsum culpa. Id maxime quos quos ut deleniti quasi numquam. Qui a aut sit id quia quis. Veritatis non saepe voluptatem incidunt voluptas. Et excepturi est et eveniet. Minima in quis qui esse. Voluptatem incidunt quam dolor sunt qui. Autem totam provident illum. Qui minima et qui velit officiis soluta quia est. Explicabo sunt velit et illo rerum. Assumenda odio quae temporibus et illo cumque. Quaerat quam ab sunt consequatur ipsam omnis. Perferendis et eligendi odit sunt. Sint provident odit explicabo impedit et. Impedit sint dolorem nobis aut. Error quisquam ut quasi consequatur. Ut error qui qui eum aut. Placeat tempora ex ab nihil necessitatibus et delectus. Repellat amet consequatur vitae dignissimos nihil excepturi animi. Ea similique et dolorem vero cumque ipsa. Earum ut adipisci explicabo atque aut ducimus. Alias at doloribus sint porro. Ut velit dolor cum ratione nemo nihil. Voluptas unde quas autem. Nam est rerum porro rem ut maiores error. Enim voluptatem aliquid aut vitae et. Dolor ducimus odio tempora voluptas et architecto minus. Velit non illum inventore aut harum porro perferendis. Numquam non itaque dolorem voluptas. Sed maxime eius autem non culpa. Ad suscipit impedit aut et sed tempora commodi. Asperiores qui fugiat est neque et in. Exercitationem accusamus cum eos occaecati fuga. Sit possimus eligendi dolorem mollitia. Nobis autem enim voluptatem voluptas deleniti. Aut voluptatem natus ex expedita nobis eveniet aut quis. Numquam et cupiditate expedita nemo hic eos. Maxime error corporis quo ea nemo. Sapiente inventore non quis rem quod.', 'Consequatur distinctio assumenda rerum qui distinctio molestiae laboriosam magni. A nulla assumenda amet consequatur cumque enim dolor. Sint non debitis qui. Repellat qui dolores unde adipisci sed. At illo quas et id. Vitae veritatis est quia quam necessitatibus dolores. Consectetur ab ut sunt consequatur. Similique corporis quis necessitatibus voluptatem ut quod. In ratione dignissimos sint. Similique qui itaque porro ratione similique perspiciatis. Praesentium autem adipisci sunt qui at distinctio omnis. Eius voluptatem voluptate eaque quod incidunt ratione. Molestias beatae voluptas consequatur autem aut et. Sit voluptates doloribus esse dicta. Enim nihil vel velit quibusdam. Cupiditate deleniti iste sit maiores. Totam sit rem consequuntur inventore dolorem fugit et. Aut et corporis sint incidunt voluptatibus ea. Voluptatibus rem aut harum molestias ipsum maxime. Hic maiores expedita hic mollitia dolores quam facilis. Dicta ut quis aperiam aspernatur totam voluptatem. Perspiciatis distinctio vitae sed placeat totam harum. Laborum beatae cumque sit quo voluptatem debitis vero. Cumque in et sunt doloremque quia. Rem laboriosam et quisquam aperiam. Vero est nulla reprehenderit qui vel porro. Ullam maxime exercitationem omnis assumenda eveniet ipsam reprehenderit. Optio autem sint quam molestias. Sequi eos consequatur dolor eum. Illo libero ab nihil excepturi et enim aut. Et vel praesentium maiores quia ipsum qui. Dolorem nulla recusandae hic et et eum blanditiis suscipit. Nam eos natus sed ut. Sint adipisci est dicta deserunt facilis sunt quo. In et cumque occaecati. Et quia quo ipsa optio qui. Omnis possimus fuga facilis fuga aliquid dolores. Natus blanditiis dolorem beatae voluptatem qui qui. Autem esse impedit maiores aut eveniet et. Pariatur facilis cupiditate et et repellat. Soluta est temporibus expedita omnis nisi aut dolorum. Ut et ea assumenda itaque. Dignissimos consequatur incidunt explicabo. Debitis aut eos aut perspiciatis eveniet velit totam.', 'Eveniet et voluptatem quis nemo ipsum a. Pariatur ut voluptate culpa quisquam in blanditiis. Natus et adipisci suscipit et voluptas earum aliquam. Officia eum necessitatibus quae sed debitis corporis non autem. Deserunt beatae qui dolores ullam et. Velit nulla voluptas earum dolor odit similique. Ut assumenda id id ut doloremque aut accusamus. Ipsum quia praesentium voluptas nisi. Numquam ut fuga reprehenderit possimus ab architecto nulla. Enim reiciendis velit perferendis. Est ratione in natus commodi eius. Sunt eius est autem aut et ipsa voluptatem. Praesentium maxime doloremque quibusdam aut ab. Occaecati distinctio natus error voluptatem labore. Ex deserunt quo recusandae atque et. Eligendi incidunt non qui et voluptatibus. Repellat aspernatur illo in quaerat. Quasi hic mollitia perferendis officiis sit quis rerum voluptatem. Repudiandae ipsum et eum explicabo deserunt ratione voluptas. Quod voluptates necessitatibus explicabo sed. Distinctio consequatur id delectus nam quas et aut. Sint ad facilis eligendi doloribus. Eius libero quis molestias ut omnis iusto. Amet dolor amet est architecto est eveniet tenetur. Quia est repellat est sed dolorem rerum voluptatem. Facere autem iusto autem illum ut blanditiis id tenetur. Minima et vel at aut eligendi expedita reprehenderit. Eius occaecati amet iure quia nisi. Dolores in sint nihil iusto a. Occaecati deleniti magnam voluptate ullam sit. Odio aut tempora nam molestiae consectetur corrupti molestiae. Quisquam velit quisquam praesentium quia omnis. Provident eum magni accusamus velit dolore est velit. Aliquam vero voluptate delectus minus minima voluptas officia. Itaque ab voluptatibus sed sed qui. Adipisci assumenda maxime sit voluptates veniam non et. Officiis voluptatem quos qui a. Consequatur quaerat voluptatem quisquam ad ipsa. Culpa quis est sit eligendi et sint ratione.', 'Quis aut cumque provident dignissimos. Sed libero ut eius fuga sit. Molestiae quo quae facere sunt laboriosam qui quisquam est. Velit iusto quam vitae sit qui impedit et. Aut incidunt sunt voluptas totam illum aut velit. Autem in numquam porro. Consequatur sed asperiores temporibus repellat. Possimus autem commodi aut. Quis ea voluptate rem velit et porro. Qui iusto pariatur ut reprehenderit eveniet. Id recusandae et modi error. Fuga distinctio dolorum libero quia. Est sunt ut sed accusantium nobis autem qui. Enim ea totam quae delectus quam fugiat. Quia ipsum error assumenda voluptate aut. Veniam aut eos sint aut sit. Exercitationem facere sit modi nobis libero dolores. Magni quo maxime eaque sunt. Exercitationem maiores rerum architecto odio est ratione qui iusto. Velit minus cupiditate reiciendis sunt. Minus quos sed deleniti. Ut totam laborum debitis. Mollitia expedita consectetur eligendi officiis. Incidunt sed reprehenderit ut maiores corrupti asperiores dicta. Voluptas maxime ut magni distinctio. In quidem commodi labore commodi. Unde voluptatem et debitis tempora perspiciatis. Nesciunt ipsum similique ab ipsa dolores at qui. Est et rem fugiat rerum doloribus. Eligendi aliquid qui omnis laudantium. Quo ut voluptatem vero distinctio qui cum. Consequuntur impedit omnis deleniti aperiam eligendi aut. Quos est laboriosam nisi voluptas totam placeat ea. Dolore qui aut reprehenderit ratione dolorum reprehenderit autem nostrum. Est eum animi enim voluptatem molestias enim placeat. Officia provident sequi nam quam fuga. Deleniti aspernatur quae libero et sequi. Eum et exercitationem velit temporibus. Accusamus quis est voluptates et tempore omnis. Aspernatur qui rerum numquam accusantium. Eos ab sit nobis dolorem voluptatum. Quis eaque molestiae cum qui facere dolore. Nostrum debitis voluptatem excepturi quam voluptate aliquam.', 'Voluptatem illo earum ea magnam omnis. Vitae magni est expedita perspiciatis. Doloribus temporibus est consectetur eveniet quaerat. Libero porro voluptatem aut blanditiis. Explicabo in maiores ut eum. Quibusdam praesentium molestiae veritatis non quo accusamus. Facilis iste quo laborum repellat aliquam quaerat qui. Voluptatem nihil officiis dolores asperiores. Vel non error voluptatem nihil laudantium velit. Sit nihil possimus et minima. Dolorem voluptatem hic quis in. Est dolores doloremque dolorum est earum est et. Nobis corporis voluptas ducimus corporis. Fugit animi amet dolor distinctio qui asperiores harum facere. Sint sapiente ratione quia velit. Recusandae molestiae adipisci nesciunt accusantium. Repellat sed laborum iusto expedita ratione delectus. Necessitatibus voluptate sequi eum quas. Maxime corrupti dolores qui rerum. Dolore possimus assumenda similique accusamus minima aperiam aut. Vel natus laboriosam voluptatem voluptas. At dicta qui nisi temporibus dolorem doloremque. Recusandae iusto porro commodi. Ea at ullam nihil commodi eos cum veniam. Temporibus animi libero aliquid porro. Ad facilis dolores architecto. Facilis et sed sed at sed atque repellendus. Rerum laboriosam eum ab. Qui in placeat non et. Error consequatur necessitatibus optio amet eius. Labore consequatur at quae qui nemo. Consequatur ducimus excepturi et illum. Laudantium nobis consectetur ex libero facere praesentium et. Commodi vero nam consequatur provident id. Ab voluptate exercitationem consequatur minus omnis id sed. Dolorum voluptatem ut minima corrupti rerum dolorum debitis. Aut libero impedit sequi laborum voluptates facilis neque. Non non cumque magni est iste. Iusto est minus consequuntur. Quasi error cupiditate ab earum sequi consequuntur assumenda. Blanditiis possimus quo velit quisquam enim iste qui. Blanditiis eum nobis quas. Exercitationem tempora voluptatem nemo enim. Quaerat eum ipsam quod nisi velit eaque maiores cum.', 1, '2022-02-17 05:10:09', NULL, 1);

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

--
