|
Server : Apache/2.4.41 (Ubuntu) System : Linux vmi1525618.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64 User : www-data ( 33) PHP Version : 8.2.12 Disable Function : NONE Directory : /var/www/leadai/leadai.co.in/ |
Upload File : |
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 28, 2024 at 05:50 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `visitor`
--
-- --------------------------------------------------------
--
-- Table structure for table `companies`
--
CREATE TABLE `companies` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`company_tag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type_of_company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
`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 `companies`
--
INSERT INTO `companies` (`id`, `admin_id`, `slug`, `company_name`, `company_tag`, `type_of_company`, `address`, `email`, `phone`, `website`, `company_pic`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '0(Y70%=p', 'ABC Pvt. Ltd.', 'sdfsdfsd', 'education', 'dsfsdfsdf', 'abc20@gmail.com', '214587748', 'htttps://edukrypt.com', NULL, 'active', '2024-03-22 12:29:14', '2024-03-22 12:29:14'),
(2, 14, '@auYf0um', 'XYZ Pvt. Ltd.', 'sdfsdf', 'education', 'sdfsdfsdf', 'xyz@gmail.com', '8756985255', 'htttps://edukrypt.com', NULL, 'active', '2024-03-22 12:30:23', '2024-03-22 13:27:08'),
(4, 14, '', 'SDS Public School', NULL, NULL, NULL, NULL, NULL, NULL, '/admin/organization/1711455496.png', 'active', '2024-03-26 12:18:16', '2024-03-26 12:18:16'),
(5, 14, '', 'webtech new', NULL, NULL, NULL, NULL, NULL, NULL, '/admin/organization/1711455979.png', 'active', '2024-03-26 12:26:19', '2024-03-26 12:26:19'),
(6, 14, '', 'NVS Public School', NULL, NULL, NULL, NULL, NULL, NULL, '/admin/organization/1711518251.png', 'active', '2024-03-27 05:44:11', '2024-03-27 05:44:11');
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) 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(255) 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_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2024_03_12_141126_create_visitor_categories_table', 3),
(8, '2024_03_20_113005_create_notifications_table', 5),
(9, '2024_03_21_150325_create_sessionotps_table', 6),
(10, '2024_03_22_123548_create_companies_table', 7),
(11, '2024_03_12_125949_create_visitor_entries_table', 8),
(12, '2024_03_26_100608_create_visitor_company_relations_table', 8);
-- --------------------------------------------------------
--
-- Table structure for table `modules`
--
CREATE TABLE `modules` (
`id` bigint(20) UNSIGNED NOT NULL,
`type` enum('common','visitor') NOT NULL,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`sort` int(11) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `modules`
--
INSERT INTO `modules` (`id`, `type`, `name`, `slug`, `sort`, `created_at`, `updated_at`) VALUES
(14, 'common', 'Users & Roles (Common)', 'users-roles-edukrypt', 1, '2023-08-23 19:25:29', '2024-03-13 12:25:30'),
(16, 'visitor', 'Video Management', 'video-management', 2, '2023-08-27 01:59:28', '2024-03-14 04:53:26'),
(17, 'visitor', 'Ebook Managment', 'ebook-managment', 3, '2023-08-27 02:06:49', '2024-03-14 04:53:32'),
(18, 'visitor', 'Practice Managment', 'practice-managment', 4, '2023-08-27 02:23:12', '2024-03-14 04:53:37'),
(19, 'visitor', 'Banner & Youtube', 'banner-youtube', 5, '2023-08-27 02:29:46', '2024-03-14 04:53:41'),
(20, 'visitor', 'Product Managment', 'product-managment', 6, '2023-08-27 02:34:59', '2024-03-14 04:53:46'),
(21, 'visitor', 'Notification', 'notification', 7, '2023-08-27 02:45:10', '2024-03-13 12:25:45'),
(22, 'visitor', 'Promocode', 'promocode', 8, '2023-08-27 02:46:13', '2024-03-14 04:53:51'),
(23, 'visitor', 'Live Stream', 'live-stream', 9, '2023-08-31 01:14:48', '2024-03-14 04:53:55'),
(24, 'visitor', 'Order Management', 'order-management', 10, '2023-08-31 05:19:58', '2024-03-14 04:54:00'),
(25, 'visitor', 'Blogs', 'blogs', 11, '2023-08-31 05:20:10', '2024-03-13 12:25:56'),
(26, 'visitor', 'Settings', 'settings', 12, '2023-08-31 05:20:20', '2024-03-13 12:26:01'),
(28, 'visitor', 'Cloud Storage', 'cloud-storage', 12, '2023-09-06 17:56:04', '2024-03-14 04:54:05'),
(40, 'visitor', 'Reports', 'reports', 12, '2023-09-20 06:57:09', '2024-03-14 04:54:10'),
(42, 'visitor', 'Classroom', 'classroom', 5, '2023-10-13 01:05:33', '2024-03-14 04:54:14'),
(43, 'visitor', 'VOD Server', 'vod-server', 1, '2023-10-16 22:15:30', '2024-03-14 04:54:18'),
(53, 'visitor', 'Enquiry', 'enquiry', 1, '2024-01-09 05:35:58', '2024-03-14 04:54:24'),
(54, 'visitor', 'Notice', 'notice', 2, '2024-01-09 05:38:15', '2024-03-14 04:54:28'),
(55, 'visitor', 'Master Database', 'master-database', 3, '2024-01-09 05:43:09', '2024-03-14 04:54:33'),
(56, 'visitor', 'Admissions', 'admissions', 4, '2024-01-09 06:11:49', '2024-03-14 04:54:37'),
(57, 'visitor', 'Student Management', 'student-management', 5, '2024-01-09 06:15:36', '2024-03-14 04:54:41'),
(58, 'visitor', 'Manage Attendance', 'manage-attendance', 6, '2024-01-09 06:22:15', '2024-03-14 04:54:47'),
(59, 'visitor', 'Fees Management', 'fees-management', 7, '2024-01-09 06:24:13', '2024-03-14 04:54:51'),
(60, 'visitor', 'Test Management', 'test-management', 8, '2024-01-09 06:37:26', '2024-03-14 04:54:55'),
(61, 'visitor', 'Library Management', 'library-management', 9, '2024-01-09 06:38:23', '2024-03-14 04:54:58'),
(62, 'visitor', 'Time table', 'time-table', 9, '2024-01-09 07:06:22', '2024-03-14 04:55:09'),
(63, 'visitor', 'Chat', 'chat', 10, '2024-01-09 07:12:20', '2024-03-14 04:55:13'),
(64, 'visitor', 'Exam Management', 'exam-management', 12, '2024-01-09 07:53:06', '2024-03-14 04:55:17'),
(65, 'visitor', 'Assignment management', 'assignment-management', 13, '2024-01-09 07:56:39', '2024-03-14 04:55:20'),
(66, 'visitor', 'Feedback Management', 'feedback-management', 14, '2024-01-09 07:58:32', '2024-03-14 04:55:24'),
(67, 'visitor', 'Encryption Logs', 'encryption-logs', 35, '2024-02-15 09:45:33', '2024-03-14 04:55:28'),
(68, 'visitor', 'School Notification', 'school-notification', 1, '2024-02-20 11:21:32', '2024-03-14 04:55:32'),
(69, 'visitor', 'Privacy Policy', 'privacy-policy', 2, '2024-02-20 11:22:43', '2024-03-14 04:55:36'),
(70, 'visitor', 'Events', 'events', 3, '2024-02-20 11:24:59', '2024-03-14 04:55:40'),
(71, 'visitor', 'School Trips', 'school-trips', 5, '2024-02-20 11:28:50', '2024-03-14 04:55:46'),
(72, 'visitor', 'Transport', 'transport', 100, '2024-03-04 09:25:47', '2024-03-14 04:55:50');
-- --------------------------------------------------------
--
-- Table structure for table `module_permissions`
--
CREATE TABLE `module_permissions` (
`id` bigint(20) UNSIGNED NOT NULL,
`module_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`sort` int(11) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `module_permissions`
--
INSERT INTO `module_permissions` (`id`, `module_id`, `name`, `slug`, `sort`, `created_at`, `updated_at`) VALUES
(31, 14, 'View User', 'view-user', 1, '2023-08-23 19:28:56', '2024-02-04 11:36:23'),
(32, 14, 'Add User', 'add-user', 2, '2023-08-23 19:29:06', '2024-02-04 11:36:23'),
(33, 14, 'Edit User', 'edit-user', 3, '2023-08-23 19:29:15', '2024-02-04 11:36:23'),
(34, 14, 'Delete User', 'delete-user', 4, '2023-08-23 19:29:24', '2024-02-04 11:36:23'),
(35, 14, 'View User Device', 'view-user-device', 5, '2023-08-23 19:29:50', '2024-02-04 11:36:23'),
(36, 14, 'Delete User Device', 'delete-user-device', 6, '2023-08-23 19:30:02', '2024-02-04 11:36:23'),
(37, 14, 'View Role', 'view-role', 7, '2023-08-23 19:32:04', '2024-02-04 11:36:23'),
(38, 14, 'Add Role', 'add-role', 8, '2023-08-23 19:32:13', '2024-02-04 11:36:23'),
(39, 14, 'Edit Role', 'edit-role', 9, '2023-08-23 19:32:27', '2024-02-04 11:36:23'),
(40, 14, 'Delete Role', 'delete-role', 10, '2023-08-23 19:32:41', '2024-02-04 11:36:23'),
(41, 14, 'View Role Permission', 'view-role-permission', 11, '2023-08-23 19:33:07', '2024-02-04 11:36:23'),
(42, 14, 'Edit Role Permission', 'edit-role-permission', 12, '2023-08-23 19:33:21', '2024-02-04 11:36:23'),
(43, 16, 'View Tag', 'view-tag', 1, '2023-08-27 01:59:56', '2024-02-04 11:36:23'),
(44, 16, 'Add Tag', 'add-tag', 2, '2023-08-27 02:00:04', '2024-02-04 11:36:23'),
(45, 16, 'Edit Tag', 'edit-tag', 3, '2023-08-27 02:00:12', '2024-02-04 11:36:23'),
(46, 16, 'Delete Tag', 'delete-tag', 4, '2023-08-27 02:00:25', '2024-02-04 11:36:23'),
(47, 16, 'View Video', 'view-video', 5, '2023-08-27 02:00:55', '2024-02-04 11:36:23'),
(48, 16, 'CSV Video Upload', 'csv-video-upload', 6, '2023-08-27 02:01:14', '2024-02-04 11:36:23'),
(49, 16, 'Delete Video', 'delete-video', 7, '2023-08-27 02:02:11', '2024-02-04 11:36:23'),
(50, 16, 'View Mapping Video', 'view-mapping-video', 8, '2023-08-27 02:03:17', '2024-02-04 11:36:23'),
(52, 16, 'Add Mapping Video', 'add-mapping-video', 9, '2023-08-27 02:03:56', '2024-02-04 11:36:23'),
(53, 16, 'Edit Mapping Video', 'edit-mapping-video', 10, '2023-08-27 02:04:17', '2024-02-04 11:36:23'),
(54, 16, 'Delete Mapping Video', 'delete-mapping-video', 11, '2023-08-27 02:04:30', '2024-02-04 11:36:23'),
(55, 16, 'View Bookmark', 'view-bookmark', 12, '2023-08-27 02:05:21', '2024-02-04 11:36:23'),
(56, 16, 'Add Bookmark', 'add-bookmark', 13, '2023-08-27 02:05:45', '2024-02-04 11:36:23'),
(57, 16, 'Edit Bookmark', 'edit-bookmark', 14, '2023-08-27 02:06:10', '2024-02-04 11:36:23'),
(58, 16, 'Delete Bookmark', 'delete-bookmark', 15, '2023-08-27 02:06:20', '2024-02-04 11:36:23'),
(59, 17, 'View Ebook', 'view-ebook', 1, '2023-08-27 02:07:02', '2024-02-04 11:36:23'),
(60, 17, 'CSV Ebook Upload', 'csv-ebook-upload', 2, '2023-08-27 02:07:46', '2024-02-04 11:36:23'),
(61, 17, 'Delete Ebook', 'delete-ebook', 3, '2023-08-27 02:08:09', '2024-02-04 11:36:23'),
(62, 17, 'View Mapping Ebook', 'view-mapping-ebook', 4, '2023-08-27 02:08:29', '2024-02-04 11:36:23'),
(65, 18, 'View Practice', 'view-practice', 1, '2023-08-27 02:17:13', '2024-02-04 11:36:23'),
(66, 18, 'Add Practice', 'add-practice', 2, '2023-08-27 02:17:28', '2024-02-04 11:36:23'),
(68, 18, 'Edit Practice', 'edit-practice', 3, '2023-08-27 02:18:07', '2024-02-04 11:36:23'),
(69, 18, 'Delete Practice', 'delete-practice', 4, '2023-08-27 02:18:20', '2024-02-04 11:36:23'),
(73, 18, 'View Option', 'view-option', 7, '2023-08-27 02:20:36', '2024-02-04 11:36:23'),
(74, 18, 'Add Option', 'add-option', 8, '2023-08-27 02:20:47', '2024-02-04 11:36:23'),
(75, 18, 'Edit Option', 'edit-option', 9, '2023-08-27 02:20:56', '2024-02-04 11:36:23'),
(76, 18, 'Delete Option', 'delete-option', 10, '2023-08-27 02:21:25', '2024-02-04 11:36:23'),
(77, 19, 'View Banner', 'view-banner', 1, '2023-08-27 02:29:58', '2024-02-04 11:36:23'),
(78, 19, 'Add Banner', 'add-banner', 2, '2023-08-27 02:30:08', '2024-02-04 11:36:23'),
(80, 19, 'Delete Banner', 'delete-banner', 4, '2023-08-27 02:30:32', '2024-02-04 11:36:23'),
(81, 19, 'View Youtube', 'view-youtube', 5, '2023-08-27 02:31:20', '2024-02-04 11:36:23'),
(82, 19, 'Add Youtube', 'add-youtube', 6, '2023-08-27 02:31:33', '2024-02-04 11:36:23'),
(83, 19, 'Edit Youtube', 'edit-youtube', 7, '2023-08-27 02:31:51', '2024-02-04 11:36:23'),
(84, 19, 'Delete Youtube', 'delete-youtube', 8, '2023-08-27 02:32:13', '2024-02-04 11:36:23'),
(86, 20, 'View Main Category', 'view-main-category', 1, '2023-08-27 02:35:48', '2024-02-04 11:36:23'),
(87, 20, 'Add Main Category', 'add-main-category', 2, '2023-08-27 02:35:59', '2024-02-04 11:36:23'),
(88, 20, 'Edit Main Category', 'edit-main-category', 3, '2023-08-27 02:36:10', '2024-02-04 11:36:23'),
(89, 20, 'Delete Main Category', 'delete-main-category', 4, '2023-08-27 02:36:24', '2024-02-04 11:36:23'),
(90, 20, 'View Product', 'view-product', 5, '2023-08-27 02:37:11', '2024-02-04 11:36:23'),
(91, 20, 'Add Product', 'add-product', 6, '2023-08-27 02:37:26', '2024-02-04 11:36:23'),
(92, 20, 'Edit Product', 'edit-product', 7, '2023-08-27 02:37:41', '2024-02-04 11:36:23'),
(93, 20, 'Delete Product', 'delete-product', 8, '2023-08-27 02:37:56', '2024-02-04 11:36:23'),
(94, 20, 'View Product Category', 'view-product-category', 9, '2023-08-27 02:38:18', '2024-02-04 11:36:23'),
(95, 20, 'Add Product Category', 'add-product-category', 10, '2023-08-27 02:38:50', '2024-02-04 11:36:23'),
(96, 20, 'Edit Product Category', 'edit-product-category', 11, '2023-08-27 02:38:59', '2024-02-04 11:36:23'),
(97, 20, 'Delete Product Category', 'delete-product-category', 12, '2023-08-27 02:39:13', '2024-02-04 11:36:23'),
(101, 20, 'View Product Price', 'view-product-price', 13, '2023-08-27 02:41:37', '2024-02-04 11:36:23'),
(102, 20, 'Add Product Price', 'add-product-price', 14, '2023-08-27 02:42:44', '2024-02-04 11:36:23'),
(103, 20, 'Edit Product Price', 'edit-product-price', 15, '2023-08-27 02:42:57', '2024-02-04 11:36:23'),
(104, 20, 'Delete Product Price', 'delete-product-price', 16, '2023-08-27 02:43:13', '2024-02-04 11:36:23'),
(105, 21, 'View Notification', 'view-notification', 1, '2023-08-27 02:45:33', '2024-02-04 11:36:23'),
(106, 21, 'Add Notification', 'add-notification', 2, '2023-08-27 02:45:41', '2024-02-04 11:36:23'),
(107, 21, 'Edit Notification', 'edit-notification', 3, '2023-08-27 02:45:50', '2024-02-04 11:36:23'),
(108, 21, 'Delete Notification', 'delete-notification', 4, '2023-08-27 02:45:58', '2024-02-04 11:36:23'),
(109, 22, 'View Promocode', 'view-promocode', 1, '2023-08-27 02:46:33', '2024-02-04 11:36:23'),
(110, 22, 'Add Promocode', 'add-promocode', 2, '2023-08-27 02:46:41', '2024-02-04 11:36:23'),
(111, 22, 'Edit Promocode', 'edit-promocode', 3, '2023-08-27 02:46:49', '2024-02-04 11:36:23'),
(112, 22, 'Delete Promocode', 'delete-promocode', 4, '2023-08-27 02:47:00', '2024-02-04 11:36:23'),
(113, 16, 'Assign Tag Mapping Video', 'assign-tag-mapping-video', 16, '2023-08-27 19:12:04', '2024-02-04 11:36:23'),
(114, 17, 'Add Mapping Ebook', 'add-mapping-ebook', 5, '2023-08-27 19:46:09', '2024-02-04 11:36:23'),
(115, 17, 'Delete Mapping Ebook', 'delete-mapping-ebook', 6, '2023-08-27 19:46:15', '2024-02-04 11:36:23'),
(119, 18, 'View Practice Mapping Question', 'view-practice-mapping-question', 5, '2023-08-27 20:09:27', '2024-02-04 11:36:23'),
(120, 18, 'Delete Practice Mapping Question', 'delete-practice-mapping-question', 6, '2023-08-27 20:09:58', '2024-02-04 11:36:23'),
(121, 18, 'View Question', 'view-question', 11, '2023-08-27 23:12:36', '2024-02-04 11:36:23'),
(122, 18, 'Add Question', 'add-question', 12, '2023-08-27 23:12:48', '2024-02-04 11:36:23'),
(123, 18, 'Edit Question', 'edit-question', 14, '2023-08-27 23:12:57', '2024-02-04 11:36:23'),
(124, 18, 'Delete Question', 'delete-question', 15, '2023-08-27 23:13:11', '2024-02-04 11:36:23'),
(125, 20, 'View Product Content', 'view-product-content', 17, '2023-08-31 00:46:47', '2024-02-04 11:36:23'),
(134, 20, 'Delete Product Content', 'delete-product-content', 22, '2023-08-31 00:50:48', '2024-02-04 11:36:23'),
(135, 16, 'Add Video Content', 'add-video-content', 17, '2023-08-31 00:57:44', '2024-02-04 11:36:23'),
(136, 17, 'Add Ebook Content', 'add-ebook-content', 8, '2023-08-31 00:58:09', '2024-02-04 11:36:23'),
(137, 18, 'Add MCQ Content', 'add-mcq-content', 16, '2023-08-31 00:58:40', '2024-02-04 11:36:23'),
(138, 23, 'View Live Studio', 'view-live-studio', 1, '2023-08-31 01:15:13', '2024-02-04 11:36:23'),
(139, 23, 'Add Live Studio', 'add-live-studio', 2, '2023-08-31 01:15:29', '2024-02-04 11:36:23'),
(140, 23, 'Edit Live Studio', 'edit-live-studio', 3, '2023-08-31 01:15:41', '2024-02-04 11:36:23'),
(141, 23, 'Delete Live Studio', 'delete-live-studio', 4, '2023-08-31 01:16:08', '2024-02-04 11:36:23'),
(142, 23, 'View Live Schedule', 'view-live-schedule', 5, '2023-08-31 01:16:58', '2024-02-04 11:36:23'),
(143, 23, 'Add Live Schedule', 'add-live-schedule', 6, '2023-08-31 01:17:07', '2024-02-04 11:36:23'),
(147, 23, 'Delete Live Schedule', 'delete-live-schedule', 7, '2023-08-31 01:41:29', '2024-02-04 11:36:23'),
(148, 23, 'Live Chat', 'live-chat', 8, '2023-08-31 01:41:36', '2024-02-04 11:36:23'),
(149, 24, 'View Order', 'view-order', 1, '2023-08-31 05:20:35', '2024-02-04 11:36:23'),
(150, 24, 'Add Order', 'add-order', 2, '2023-08-31 05:20:44', '2024-02-04 11:36:23'),
(151, 24, 'Edit Order', 'edit-order', 3, '2023-08-31 17:29:18', '2024-02-04 11:36:23'),
(152, 24, 'Delete Order', 'delete-order', 4, '2023-08-31 18:38:47', '2024-02-04 11:36:23'),
(153, 25, 'View Blog', 'view-blog', 1, '2023-08-31 18:40:39', '2024-02-04 11:36:23'),
(154, 25, 'Add Blog', 'add-blog', 2, '2023-08-31 18:40:46', '2024-02-04 11:36:23'),
(155, 25, 'Edit Blog', 'edit-blog', 3, '2023-08-31 18:40:57', '2024-02-04 11:36:23'),
(156, 25, 'Delete Blog', 'delete-blog', 4, '2023-08-31 18:41:09', '2024-02-04 11:36:23'),
(158, 26, 'Change Settings', 'change-settings', 1, '2023-08-31 19:01:55', '2024-02-04 11:36:23'),
(159, 28, 'Google Drive', 'google-drive', 1, '2023-09-06 17:56:26', '2024-02-04 11:36:23'),
(160, 28, 'AWS Bucket', 'aws-bucket', 2, '2023-09-06 17:56:43', '2024-02-04 11:36:23'),
(233, 40, 'View Student Progress', 'view-student-progress', 1, '2023-09-20 06:58:39', '2024-02-04 11:36:23'),
(234, 40, 'Reset Student Progress', 'reset-student-progress', 2, '2023-09-20 06:58:53', '2024-02-04 11:36:23'),
(267, 28, 'Microsoft Blob Storage', 'microsoft-blob-storage', 3, '2023-10-09 17:18:42', '2024-02-04 11:36:23'),
(268, 42, 'View Classroom Users', 'view-classroom-users', 1, '2023-10-13 01:05:52', '2024-02-04 11:36:23'),
(269, 43, 'View VOD Server', 'view-vod-server', 1, '2023-10-16 22:15:47', '2024-02-04 11:36:23'),
(270, 43, 'Map VOD Video', 'map-vod-video', 2, '2023-10-16 22:15:53', '2024-02-04 11:36:23'),
(271, 43, 'Delete VOD Video', 'delete-vod-video', 3, '2023-10-16 22:16:03', '2024-02-04 11:36:23'),
(284, 18, 'Upload Question', 'upload-question', 15, '2023-11-06 17:19:09', '2024-02-04 11:36:23'),
(302, 28, 'Bunny Storage', 'bunny-storage', 4, '2023-11-23 06:34:20', '2024-02-04 11:36:23'),
(307, 16, 'Video Limit', 'video-limit', 18, '2023-11-28 01:23:54', '2024-02-04 11:36:23'),
(336, 53, 'View Enquiry', 'view-enquiry', 1, '2024-01-09 05:36:21', '2024-02-04 11:36:23'),
(337, 53, 'Add Enquiry', 'add-enquiry', 2, '2024-01-09 05:37:16', '2024-02-04 11:36:23'),
(338, 53, 'Edit Enquiry', 'edit-enquiry', 3, '2024-01-09 05:37:31', '2024-02-04 11:36:23'),
(339, 53, 'Delete Enquiry', 'delete-enquiry', 4, '2024-01-09 05:37:51', '2024-02-04 11:36:23'),
(340, 54, 'View Notice', 'view-notice', 1, '2024-01-09 05:41:08', '2024-02-04 11:36:23'),
(341, 54, 'Add Notice', 'add-notice', 2, '2024-01-09 05:41:20', '2024-02-04 11:36:23'),
(342, 54, 'Edit Notice', 'edit-notice', 3, '2024-01-09 05:41:38', '2024-02-04 11:36:23'),
(343, 54, 'Delete Notice', 'delete-notice', 4, '2024-01-09 05:42:10', '2024-02-04 11:36:23'),
(344, 55, 'View School', 'view-school', 1, '2024-01-09 05:43:30', '2024-02-04 11:36:23'),
(345, 55, 'Add School', 'add-school', 2, '2024-01-09 05:43:41', '2024-02-04 11:36:23'),
(346, 55, 'Edit School', 'edit-school', 3, '2024-01-09 05:44:30', '2024-02-04 11:36:23'),
(347, 55, 'Delete School', 'delete-school', 4, '2024-01-09 05:45:03', '2024-02-04 11:36:23'),
(348, 55, 'View Class', 'view-class', 5, '2024-01-09 05:46:03', '2024-02-04 11:36:23'),
(353, 55, 'Add Class', 'add-class', 6, '2024-01-09 05:48:02', '2024-02-04 11:36:23'),
(354, 55, 'Edit Class', 'edit-class', 7, '2024-01-09 05:48:16', '2024-02-04 11:36:23'),
(355, 55, 'Delete Class', 'delete-class', 8, '2024-01-09 05:48:29', '2024-02-04 11:36:23'),
(356, 55, 'View Section', 'view-section', 9, '2024-01-09 05:56:43', '2024-02-04 11:36:23'),
(357, 55, 'Add Section', 'add-section', 10, '2024-01-09 05:56:59', '2024-02-04 11:36:23'),
(358, 55, 'Edit Section', 'edit-section', 11, '2024-01-09 05:57:14', '2024-02-04 11:36:23'),
(359, 55, 'Delete Section', 'delete-section', 12, '2024-01-09 05:57:36', '2024-02-04 11:36:23'),
(360, 55, 'View Gallery', 'view-gallery', 13, '2024-01-09 05:58:03', '2024-02-04 11:36:23'),
(361, 55, 'Add Gallery', 'add-gallery', 13, '2024-01-09 05:58:23', '2024-02-04 11:36:23'),
(362, 55, 'Edit Gallery', 'edit-gallery', 14, '2024-01-09 05:58:34', '2024-02-04 11:36:23'),
(363, 55, 'Delete Gallery', 'delete-gallery', 15, '2024-01-09 05:58:47', '2024-02-04 11:36:23'),
(364, 55, 'Add Subject', 'add-subject', 16, '2024-01-09 05:59:43', '2024-02-04 11:36:23'),
(365, 55, 'Edit Subject', 'edit-subject', 17, '2024-01-09 05:59:50', '2024-02-04 11:36:23'),
(366, 55, 'Delete Subject', 'delete-subject', 18, '2024-01-09 06:00:02', '2024-02-04 11:36:23'),
(367, 55, 'View Subject', 'view-subject', 19, '2024-01-09 06:01:23', '2024-02-04 11:36:23'),
(368, 55, 'View Teacher', 'view-teacher', 21, '2024-01-09 06:02:52', '2024-02-04 11:36:23'),
(369, 55, 'Add Teacher', 'add-teacher', 22, '2024-01-09 06:03:05', '2024-02-04 11:36:23'),
(370, 55, 'Edit Teacher', 'edit-teacher', 23, '2024-01-09 06:03:19', '2024-02-04 11:36:23'),
(371, 55, 'Delete Teacher', 'delete-teacher', 24, '2024-01-09 06:03:37', '2024-02-04 11:36:23'),
(372, 55, 'View Document_type', 'view-document-type', 25, '2024-01-09 06:04:29', '2024-02-04 11:36:23'),
(373, 55, 'Add Document_type', 'add-document-type', 26, '2024-01-09 06:04:44', '2024-02-04 11:36:23'),
(375, 55, 'Edit Document_type', 'edit-document-type', 27, '2024-01-09 06:05:27', '2024-02-04 11:36:23'),
(376, 55, 'Detete Document_type', 'detete-document-type', 28, '2024-01-09 06:05:52', '2024-02-04 11:36:23'),
(377, 55, 'View Session', 'view-session', 29, '2024-01-09 06:07:20', '2024-02-04 11:36:23'),
(378, 55, 'Add Session', 'add-session', 30, '2024-01-09 06:07:38', '2024-02-04 11:36:23'),
(379, 55, 'Edit Session', 'edit-session', 31, '2024-01-09 06:07:50', '2024-02-04 11:36:23'),
(380, 55, 'Delete Session', 'delete-session', 32, '2024-01-09 06:08:08', '2024-02-04 11:36:23'),
(381, 55, 'View Vendors', 'view-vendors', 33, '2024-01-09 06:08:58', '2024-02-04 11:36:23'),
(382, 55, 'Add Vendors', 'add-vendors', 34, '2024-01-09 06:09:18', '2024-02-04 11:36:23'),
(383, 55, 'Edit Vendors', 'edit-vendors', 35, '2024-01-09 06:09:36', '2024-02-04 11:36:23'),
(384, 55, 'Delete Vendors', 'delete-vendors', 36, '2024-01-09 06:09:59', '2024-02-04 11:36:23'),
(385, 56, 'View Admission', 'view-admission', 1, '2024-01-09 06:13:39', '2024-02-04 11:36:23'),
(386, 56, 'Add Admission', 'add-admission', 2, '2024-01-09 06:13:49', '2024-02-04 11:36:23'),
(387, 56, 'Edit Admission', 'edit-admission', 3, '2024-01-09 06:14:04', '2024-02-04 11:36:23'),
(388, 56, 'Delete Admission', 'delete-admission', 4, '2024-01-09 06:14:25', '2024-02-04 11:36:23'),
(389, 56, 'Import Admission', 'import-admission', 5, '2024-01-09 06:14:39', '2024-02-04 11:36:23'),
(390, 57, 'View Student', 'view-student', 1, '2024-01-09 06:16:04', '2024-02-04 11:36:23'),
(391, 57, 'Add Student', 'add-student', 2, '2024-01-09 06:16:16', '2024-02-04 11:36:23'),
(392, 57, 'Edit Student', 'edit-student', 3, '2024-01-09 06:16:26', '2024-02-04 11:36:23'),
(393, 57, 'Delete Student', 'delete-student', 4, '2024-01-09 06:16:37', '2024-02-04 11:36:23'),
(394, 57, 'Promote Student', 'promote-student', 5, '2024-01-09 06:16:58', '2024-02-04 11:36:23'),
(395, 57, 'Change Student Password', 'change-student-password', 6, '2024-01-09 06:17:50', '2024-02-04 11:36:23'),
(396, 57, 'View Parents', 'view-parents', 7, '2024-01-09 06:18:02', '2024-02-04 11:36:23'),
(397, 57, 'Add Parents', 'add-parents', 8, '2024-01-09 06:18:25', '2024-02-04 11:36:23'),
(398, 57, 'Edit Parents', 'edit-parents', 9, '2024-01-09 06:18:47', '2024-02-04 11:36:23'),
(399, 57, 'Delete Parents', 'delete-parents', 10, '2024-01-09 06:19:01', '2024-02-04 11:36:23'),
(400, 57, 'View Diary', 'view-diary', 11, '2024-01-09 06:19:25', '2024-02-04 11:36:23'),
(401, 57, 'Add Diary', 'add-diary', 12, '2024-01-09 06:19:35', '2024-02-04 11:36:23'),
(402, 57, 'Edit Diary', 'edit-diary', 13, '2024-01-09 06:20:48', '2024-02-04 11:36:23'),
(403, 57, 'Delete Diary', 'delete-diary', 14, '2024-01-09 06:20:59', '2024-02-04 11:36:23'),
(404, 58, 'View Student Attendance', 'view-student-attendance', 1, '2024-01-09 06:23:02', '2024-02-04 11:36:23'),
(405, 58, 'Sheet Student Attendance', 'sheet-student-attendance', 2, '2024-01-09 06:23:17', '2024-02-04 11:36:23'),
(406, 58, 'Mark Student Attendance', 'mark-student-attendance', 3, '2024-01-09 06:23:29', '2024-02-04 11:36:23'),
(407, 59, 'View Fees_collect', 'view-fees-collect', 1, '2024-01-09 06:24:31', '2024-02-04 11:36:23'),
(408, 59, 'Add Fees_collect', 'add-fees-collect', 2, '2024-01-09 06:25:04', '2024-02-04 11:36:23'),
(409, 59, 'Delete Fees_collect', 'delete-fees-collect', 3, '2024-01-09 06:25:46', '2024-02-04 11:36:23'),
(410, 59, 'View Fees_masters', 'view-fees-masters', 4, '2024-01-09 06:34:50', '2024-02-04 11:36:23'),
(411, 59, 'Add Fees_masters', 'add-fees-masters', 5, '2024-01-09 06:35:11', '2024-02-04 11:36:23'),
(412, 59, 'Edit Fees_masters', 'edit-fees-masters', 6, '2024-01-09 06:35:29', '2024-02-04 11:36:23'),
(413, 59, 'Delete Fees_masters', 'delete-fees-masters', 7, '2024-01-09 06:35:54', '2024-02-04 11:36:23'),
(414, 59, 'Assign Fees_masters', 'assign-fees-masters', 8, '2024-01-09 06:36:19', '2024-02-04 11:36:23'),
(415, 59, 'Add Fees Type', 'add-fees-type', 1, '2024-01-09 06:36:51', '2024-02-04 11:36:23'),
(416, 60, 'Report Testresult', 'report-testresult', 1, '2024-01-09 06:37:42', '2024-02-04 11:36:23'),
(417, 61, 'View Library', 'view-library', 1, '2024-01-09 06:42:53', '2024-02-04 11:36:23'),
(418, 61, 'Add Library', 'add-library', 2, '2024-01-09 06:43:07', '2024-02-04 11:36:23'),
(419, 61, 'Edit Library', 'edit-library', 3, '2024-01-09 06:43:18', '2024-02-04 11:36:23'),
(420, 61, 'Delete Library', 'delete-library', 4, '2024-01-09 06:43:30', '2024-02-04 11:36:23'),
(421, 61, 'View Librarycard', 'view-librarycard', 5, '2024-01-09 06:46:01', '2024-02-04 11:36:23'),
(422, 61, 'Add Librarycard', 'add-librarycard', 6, '2024-01-09 06:46:13', '2024-02-04 11:36:23'),
(423, 61, 'Edit Librarycard', 'edit-librarycard', 7, '2024-01-09 06:56:27', '2024-02-04 11:36:23'),
(424, 61, 'Delete Librarycard', 'delete-librarycard', 7, '2024-01-09 06:56:40', '2024-02-04 11:36:23'),
(425, 61, 'Add Bookissue', 'add-bookissue', 9, '2024-01-09 06:57:01', '2024-02-04 11:36:23'),
(426, 61, 'View Bookissue', 'view-bookissue', 9, '2024-01-09 06:57:40', '2024-02-04 11:36:23'),
(427, 61, 'Edit Bookissue', 'edit-bookissue', 10, '2024-01-09 06:58:08', '2024-02-04 11:36:23'),
(428, 61, 'Delete Bookissue', 'delete-bookissue', 11, '2024-01-09 06:59:54', '2024-02-04 11:36:23'),
(429, 61, 'View elibrary', 'view-elibrary', 12, '2024-01-09 07:01:32', '2024-02-04 11:36:23'),
(430, 61, 'Add elibrary', 'add-elibrary', 13, '2024-01-09 07:01:46', '2024-02-04 11:36:23'),
(431, 61, 'Edit elibrary', 'edit-elibrary', 14, '2024-01-09 07:02:06', '2024-02-04 11:36:23'),
(432, 61, 'Delete elibrary', 'delete-elibrary', 15, '2024-01-09 07:02:30', '2024-02-04 11:36:23'),
(433, 62, 'Add Class Period', 'add-class-period', 1, '2024-01-09 07:06:52', '2024-02-04 11:36:23'),
(435, 62, 'Add Time Table', 'add-time-table', 3, '2024-01-09 07:07:17', '2024-02-04 11:36:23'),
(436, 62, 'View Time Table', 'view-time-table', 4, '2024-01-09 07:08:01', '2024-02-04 11:36:23'),
(437, 62, 'View Class Teacher', 'view-class-teacher', 4, '2024-01-09 07:09:07', '2024-02-04 11:36:23'),
(438, 62, 'Add Class Teacher', 'add-class-teacher', 5, '2024-01-09 07:09:47', '2024-02-04 11:36:23'),
(439, 62, 'Delete Class Teacher', 'delete-class-teacher', 6, '2024-01-09 07:10:05', '2024-02-04 11:36:23'),
(440, 62, 'Teacher Time Table', 'teacher-time-table', 7, '2024-01-09 07:10:56', '2024-02-04 11:36:23'),
(441, 63, 'View Chat', 'view-chat', 1, '2024-01-09 07:12:35', '2024-02-04 11:36:23'),
(442, 63, 'Add Chat', 'add-chat', 2, '2024-01-09 07:12:44', '2024-02-04 11:36:23'),
(443, 63, 'Edit Chat', 'edit-chat', 3, '2024-01-09 07:12:52', '2024-02-04 11:36:23'),
(444, 63, 'Delete Chat', 'delete-chat', 4, '2024-01-09 07:13:01', '2024-02-04 11:36:23'),
(445, 64, 'View Exam Type', 'view-exam-type', 1, '2024-01-09 07:53:21', '2024-02-04 11:36:23'),
(446, 64, 'Add Exam Type', 'add-exam-type', 2, '2024-01-09 07:53:32', '2024-02-04 11:36:23'),
(447, 64, 'Edit Exam Type', 'edit-exam-type', 3, '2024-01-09 07:53:43', '2024-02-04 11:36:23'),
(448, 64, 'Delete Exam Type', 'delete-exam-type', 4, '2024-01-09 07:53:54', '2024-02-04 11:36:23'),
(449, 64, 'View Exam Mark', 'view-exam-mark', 5, '2024-01-09 07:54:09', '2024-02-04 11:36:23'),
(450, 64, 'Add Exam Mark', 'add-exam-mark', 6, '2024-01-09 07:54:24', '2024-02-04 11:36:23'),
(451, 64, 'Edit Exam Mark', 'edit-exam-mark', 7, '2024-01-09 07:54:44', '2024-02-04 11:36:23'),
(452, 64, 'Delete Exam Mark', 'delete-exam-mark', 8, '2024-01-09 07:55:03', '2024-02-04 11:36:23'),
(453, 64, 'Print Mark Sheet', 'print-mark-sheet', 9, '2024-01-09 07:55:20', '2024-02-04 11:36:23'),
(454, 65, 'View Assignment', 'view-assignment', 1, '2024-01-09 07:57:27', '2024-02-04 11:36:23'),
(455, 65, 'Add Assignment', 'add-assignment', 2, '2024-01-09 07:57:39', '2024-02-04 11:36:23'),
(456, 65, 'Edit Assignment', 'edit-assignment', 3, '2024-01-09 07:57:50', '2024-02-04 11:36:23'),
(457, 65, 'Delete Assignment', 'delete-assignment', 4, '2024-01-09 07:58:03', '2024-02-04 11:36:23'),
(458, 66, 'View Feedback', 'view-feedback', 1, '2024-01-09 07:58:44', '2024-02-04 11:36:23'),
(459, 66, 'Add Feedback', 'add-feedback', 2, '2024-01-09 07:58:56', '2024-02-04 11:36:23'),
(460, 66, 'Edit Feedback', 'edit-feedback', 3, '2024-01-09 07:59:08', '2024-02-04 11:36:23'),
(461, 66, 'Delete Feedback', 'delete-feedback', 4, '2024-01-09 07:59:21', '2024-02-04 11:36:23'),
(462, 62, 'Class Teacher List', 'class-teacher-list', 10, '2024-01-26 13:01:09', '2024-02-04 11:36:23'),
(463, 62, 'Time Table List', 'time-table-list', 11, '2024-01-26 13:01:34', '2024-02-04 11:36:23'),
(464, 67, 'View Logs', 'view-logs', 1, '2024-02-15 09:45:57', '2024-02-15 09:45:57'),
(465, 68, 'View School Notification', 'view-school-notification', 1, '2024-02-20 11:21:57', '2024-02-20 11:21:57'),
(466, 68, 'Add School Notification', 'add-school-notification', 2, '2024-02-20 11:22:06', '2024-02-20 11:22:06'),
(467, 68, 'Edit School Notification', 'edit-school-notification', 3, '2024-02-20 11:22:14', '2024-02-20 11:22:14'),
(468, 68, 'Delete School Notification', 'delete-school-notification', 4, '2024-02-20 11:22:22', '2024-02-20 11:22:22'),
(469, 69, 'View Privacy', 'view-privacy', 1, '2024-02-20 11:23:39', '2024-02-20 11:23:39'),
(470, 69, 'Add Privacy', 'add-privacy', 2, '2024-02-20 11:23:47', '2024-02-20 11:23:47'),
(471, 69, 'Edit Privacy', 'edit-privacy', 3, '2024-02-20 11:23:55', '2024-02-20 11:23:55'),
(472, 69, 'Delete Privacy', 'delete-privacy', 4, '2024-02-20 11:24:05', '2024-02-20 11:24:05'),
(474, 70, 'View Event', 'view-event', 1, '2024-02-20 11:27:24', '2024-02-20 11:27:24'),
(475, 70, 'Add Event', 'add-event', 2, '2024-02-20 11:27:37', '2024-02-20 11:27:37'),
(476, 70, 'Edit Event', 'edit-event', 3, '2024-02-20 11:27:46', '2024-02-20 11:27:46'),
(477, 70, 'Delete Event', 'delete-event', 4, '2024-02-20 11:27:56', '2024-02-20 11:27:56'),
(478, 71, 'Add Trip', 'add-trip', 1, '2024-02-20 11:29:09', '2024-02-20 11:29:09'),
(479, 71, 'Edit Trip', 'edit-trip', 2, '2024-02-20 11:29:21', '2024-02-20 11:29:21'),
(480, 71, 'View Trip', 'view-trip', 3, '2024-02-20 11:29:30', '2024-02-20 11:29:30'),
(481, 71, 'Delete Trip', 'delete-trip', 4, '2024-02-20 11:29:40', '2024-02-20 11:29:40'),
(482, 58, 'View Teacher Attendance', 'view-teacher-attendance', 4, '2024-02-20 11:43:40', '2024-02-20 11:43:40'),
(483, 58, 'Mark Teacher Attendance', 'mark-teacher-attendance', 5, '2024-02-20 11:44:33', '2024-02-20 11:44:33'),
(484, 58, 'Sheet Teacher Attendance', 'sheet-teacher-attendance', 6, '2024-02-20 11:44:48', '2024-02-20 11:44:48'),
(485, 59, 'View Fees Type', 'view-fees-type', 1, '2024-01-09 06:36:51', '2024-02-04 11:36:23'),
(486, 59, 'Edit Fees Type', 'edit-fees-type', 1, '2024-01-09 06:36:51', '2024-02-04 11:36:23'),
(487, 59, 'Delete Fees Type', 'delete-fees-type', 1, '2024-01-09 06:36:51', '2024-02-27 07:11:44'),
(488, 72, 'View Vehicles', 'view-vehicles', 1, '2024-03-02 09:34:25', '2024-03-02 09:34:25'),
(489, 72, 'Add Vehicles', 'add-vehicles', 2, '2024-03-02 09:34:34', '2024-03-02 09:34:34'),
(490, 72, 'Edit Vehicles', 'edit-vehicles', 3, '2024-03-02 09:34:45', '2024-03-02 09:34:45'),
(491, 72, 'Delete Vehicles', 'delete-vehicles', 4, '2024-03-02 09:34:59', '2024-03-02 09:34:59'),
(492, 72, 'View Driver', 'view-driver', 5, '2024-03-02 09:35:29', '2024-03-02 09:35:29'),
(493, 72, 'Add Driver', 'add-driver', 6, '2024-03-02 09:36:03', '2024-03-02 09:36:03'),
(494, 72, 'Edit Driver', 'edit-driver', 7, '2024-03-02 09:36:15', '2024-03-02 09:36:15'),
(495, 72, 'Delete Driver', 'delete-driver', 8, '2024-03-02 09:36:41', '2024-03-02 09:36:41'),
(496, 72, 'View Route', 'view-route', 9, '2024-03-02 09:37:12', '2024-03-02 09:37:12'),
(497, 72, 'Add Route', 'add-route', 10, '2024-03-02 09:37:20', '2024-03-02 09:37:20'),
(498, 72, 'Edit Route', 'edit-route', 11, '2024-03-02 09:37:31', '2024-03-02 09:37:31'),
(499, 72, 'Delete Route', 'delete-route', 12, '2024-03-02 09:37:41', '2024-03-02 09:37:41');
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE `notifications` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`subtitle` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
`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 `notifications`
--
INSERT INTO `notifications` (`id`, `admin_id`, `title`, `subtitle`, `description`, `image`, `status`, `created_at`, `updated_at`) VALUES
(2, 1, 'notification 2', 'zczczx', 'sdfsdfsd', '/admin/images/notification/1710926692.jpg', 'active', '2024-03-20 09:24:52', '2024-03-20 09:24:52'),
(3, 1, 'notification 2', 'new rule', 'sdfsdfsd', '/admin/images/notification/1710930906.jpg', 'active', '2024-03-20 10:28:40', '2024-03-20 10:35:06'),
(4, 1, 'testing', 'sdflelrekrekr', 'sdfsdf', '/admin/images/notification/1710930668.jpg', 'active', '2024-03-20 10:31:08', '2024-03-20 10:31:08'),
(5, 1, 'notification 2', 'new rules', 'sdfsdfsd', '/admin/images/notification/1710930783.jpg', 'active', '2024-03-20 10:33:03', '2024-03-20 10:35:34');
-- --------------------------------------------------------
--
-- Table structure for table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) 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 `permissions`
--
CREATE TABLE `permissions` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` bigint(20) UNSIGNED NOT NULL,
`module_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`sort` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `permissions`
--
INSERT INTO `permissions` (`id`, `admin_id`, `module_id`, `name`, `slug`, `sort`, `created_at`, `updated_at`) VALUES
(366, 1, 14, 'View User', 'view-user', 1, '2023-09-04 22:36:14', '2023-09-04 22:36:14'),
(367, 1, 14, 'Add User', 'add-user', 2, '2023-09-04 22:36:15', '2023-09-04 22:36:15'),
(368, 1, 14, 'Edit User', 'edit-user', 3, '2023-09-04 22:36:16', '2023-09-04 22:36:16'),
(369, 1, 14, 'Delete User', 'delete-user', 4, '2023-09-04 22:36:17', '2023-09-04 22:36:17'),
(370, 1, 14, 'View User Device', 'view-user-device', 5, '2023-09-04 22:36:18', '2023-09-04 22:36:18'),
(371, 1, 14, 'Delete User Device', 'delete-user-device', 6, '2023-09-04 22:36:19', '2023-09-04 22:36:19'),
(372, 1, 14, 'View Role', 'view-role', 7, '2023-09-04 22:36:20', '2023-09-04 22:36:20'),
(373, 1, 14, 'Add Role', 'add-role', 8, '2023-09-04 22:36:21', '2023-09-04 22:36:21'),
(374, 1, 14, 'Edit Role', 'edit-role', 9, '2023-09-04 22:36:22', '2023-09-04 22:36:22'),
(375, 1, 14, 'Delete Role', 'delete-role', 10, '2023-09-04 22:36:23', '2023-09-04 22:36:23'),
(376, 1, 14, 'View Role Permission', 'view-role-permission', 11, '2023-09-04 22:36:24', '2023-09-04 22:36:24'),
(377, 1, 14, 'Edit Role Permission', 'edit-role-permission', 12, '2023-09-04 22:36:25', '2023-09-04 22:36:25'),
(378, 1, 21, 'View Notification', 'view-notification', 1, '2023-09-04 22:36:30', '2023-09-04 22:36:30'),
(379, 1, 21, 'Add Notification', 'add-notification', 2, '2023-09-04 22:36:31', '2023-09-04 22:36:31'),
(380, 1, 21, 'Edit Notification', 'edit-notification', 3, '2023-09-04 22:36:32', '2023-09-04 22:36:32'),
(381, 1, 21, 'Delete Notification', 'delete-notification', 4, '2023-09-04 22:36:32', '2023-09-04 22:36:32'),
(382, 1, 22, 'View Promocode', 'view-promocode', 1, '2023-09-04 22:36:33', '2023-09-04 22:36:33'),
(383, 1, 22, 'Add Promocode', 'add-promocode', 2, '2023-09-04 22:36:34', '2023-09-04 22:36:34'),
(384, 1, 22, 'Edit Promocode', 'edit-promocode', 3, '2023-09-04 22:36:35', '2023-09-04 22:36:35'),
(385, 1, 22, 'Delete Promocode', 'delete-promocode', 4, '2023-09-04 22:36:36', '2023-09-04 22:36:36'),
(386, 1, 19, 'View Banner', 'view-banner', 1, '2023-09-05 19:00:34', '2023-09-05 19:00:34'),
(387, 1, 19, 'Add Banner', 'add-banner', 2, '2023-09-05 19:00:35', '2023-09-05 19:00:35'),
(388, 1, 19, 'Delete Banner', 'delete-banner', 4, '2023-09-05 19:00:36', '2023-09-05 19:00:36'),
(389, 1, 19, 'View Youtube', 'view-youtube', 5, '2023-09-05 19:00:37', '2023-09-05 19:00:37'),
(390, 1, 19, 'Add Youtube', 'add-youtube', 6, '2023-09-05 19:00:40', '2023-09-05 19:00:40'),
(391, 1, 19, 'Edit Youtube', 'edit-youtube', 7, '2023-09-05 19:00:41', '2023-09-05 19:00:41'),
(392, 1, 19, 'Delete Youtube', 'delete-youtube', 8, '2023-09-05 19:00:42', '2023-09-05 19:00:42'),
(415, 1, 20, 'View Main Category', 'view-main-category', 1, '2023-09-05 19:58:20', '2023-09-05 19:58:20'),
(416, 1, 20, 'Add Main Category', 'add-main-category', 2, '2023-09-05 19:58:21', '2023-09-05 19:58:21'),
(417, 1, 20, 'Edit Main Category', 'edit-main-category', 3, '2023-09-05 19:58:22', '2023-09-05 19:58:22'),
(418, 1, 20, 'Delete Main Category', 'delete-main-category', 4, '2023-09-05 19:58:23', '2023-09-05 19:58:23'),
(419, 1, 20, 'View Product', 'view-product', 5, '2023-09-05 19:58:24', '2023-09-05 19:58:24'),
(420, 1, 20, 'Add Product', 'add-product', 6, '2023-09-05 19:58:25', '2023-09-05 19:58:25'),
(421, 1, 20, 'Edit Product', 'edit-product', 7, '2023-09-05 19:58:26', '2023-09-05 19:58:26'),
(422, 1, 20, 'Delete Product', 'delete-product', 8, '2023-09-05 19:58:27', '2023-09-05 19:58:27'),
(423, 1, 20, 'View Product Category', 'view-product-category', 9, '2023-09-05 19:58:28', '2023-09-05 19:58:28'),
(424, 1, 20, 'Add Product Category', 'add-product-category', 10, '2023-09-05 19:58:30', '2023-09-05 19:58:30'),
(425, 1, 20, 'Edit Product Category', 'edit-product-category', 11, '2023-09-05 19:58:32', '2023-09-05 19:58:32'),
(426, 1, 20, 'Delete Product Category', 'delete-product-category', 12, '2023-09-05 19:58:33', '2023-09-05 19:58:33'),
(427, 1, 20, 'View Product Price', 'view-product-price', 13, '2023-09-05 19:58:34', '2023-09-05 19:58:34'),
(428, 1, 20, 'Add Product Price', 'add-product-price', 14, '2023-09-05 19:58:35', '2023-09-05 19:58:35'),
(429, 1, 20, 'Edit Product Price', 'edit-product-price', 15, '2023-09-05 19:58:36', '2023-09-05 19:58:36'),
(430, 1, 20, 'Delete Product Price', 'delete-product-price', 16, '2023-09-05 19:58:37', '2023-09-05 19:58:37'),
(431, 1, 20, 'View Product Content', 'view-product-content', 17, '2023-09-05 19:58:38', '2023-09-05 19:58:38'),
(432, 1, 20, 'Delete Product Content', 'delete-product-content', 22, '2023-09-05 19:58:39', '2023-09-05 19:58:39'),
(433, 1, 25, 'View Blog', 'view-blog', 1, '2023-09-05 20:02:14', '2023-09-05 20:02:14'),
(434, 1, 25, 'Add Blog', 'add-blog', 2, '2023-09-05 20:02:15', '2023-09-05 20:02:15'),
(435, 1, 25, 'Edit Blog', 'edit-blog', 3, '2023-09-05 20:02:15', '2023-09-05 20:02:15'),
(436, 1, 25, 'Delete Blog', 'delete-blog', 4, '2023-09-05 20:02:16', '2023-09-05 20:02:16'),
(438, 1, 24, 'View Order', 'view-order', 1, '2023-09-05 20:02:22', '2023-09-05 20:02:22'),
(439, 1, 24, 'Add Order', 'add-order', 2, '2023-09-05 20:02:22', '2023-09-05 20:02:22'),
(440, 1, 24, 'Edit Order', 'edit-order', 3, '2023-09-05 20:02:23', '2023-09-05 20:02:23'),
(441, 1, 24, 'Delete Order', 'delete-order', 4, '2023-09-05 20:02:24', '2023-09-05 20:02:24'),
(442, 1, 23, 'View Live Studio', 'view-live-studio', 1, '2023-09-05 20:02:26', '2023-09-05 20:02:26'),
(443, 1, 23, 'Add Live Studio', 'add-live-studio', 2, '2023-09-05 20:02:27', '2023-09-05 20:02:27'),
(444, 1, 23, 'Edit Live Studio', 'edit-live-studio', 3, '2023-09-05 20:02:28', '2023-09-05 20:02:28'),
(445, 1, 23, 'Delete Live Studio', 'delete-live-studio', 4, '2023-09-05 20:02:28', '2023-09-05 20:02:28'),
(446, 1, 23, 'View Live Schedule', 'view-live-schedule', 5, '2023-09-05 20:02:30', '2023-09-05 20:02:30'),
(447, 1, 23, 'Add Live Schedule', 'add-live-schedule', 6, '2023-09-05 20:02:31', '2023-09-05 20:02:31'),
(448, 1, 23, 'Delete Live Schedule', 'delete-live-schedule', 7, '2023-09-05 20:02:32', '2023-09-05 20:02:32'),
(449, 1, 23, 'Live Chat', 'live-chat', 8, '2023-09-05 20:02:37', '2023-09-05 20:02:37'),
(450, 1, 18, 'View Practice', 'view-practice', 1, '2023-09-05 20:02:46', '2023-09-05 20:02:46'),
(451, 1, 18, 'Add Practice', 'add-practice', 2, '2023-09-05 20:02:48', '2023-09-05 20:02:48'),
(452, 1, 18, 'Edit Practice', 'edit-practice', 3, '2023-09-05 20:02:50', '2023-09-05 20:02:50'),
(453, 1, 18, 'Delete Practice', 'delete-practice', 4, '2023-09-05 20:02:51', '2023-09-05 20:02:51'),
(454, 1, 18, 'View Option', 'view-option', 7, '2023-09-05 20:02:53', '2023-09-05 20:02:53'),
(455, 1, 18, 'Add Option', 'add-option', 8, '2023-09-05 20:02:54', '2023-09-05 20:02:54'),
(456, 1, 18, 'Delete Option', 'delete-option', 10, '2023-09-05 20:02:56', '2023-09-05 20:02:56'),
(457, 1, 18, 'Edit Option', 'edit-option', 9, '2023-09-05 20:02:58', '2023-09-05 20:02:58'),
(458, 1, 18, 'View Practice Mapping Question', 'view-practice-mapping-question', 5, '2023-09-05 20:03:01', '2023-09-05 20:03:01'),
(459, 1, 18, 'Delete Practice Mapping Question', 'delete-practice-mapping-question', 6, '2023-09-05 20:03:02', '2023-09-05 20:03:02'),
(460, 1, 18, 'View Question', 'view-question', 11, '2023-09-05 20:03:03', '2023-09-05 20:03:03'),
(461, 1, 18, 'Add Question', 'add-question', 12, '2023-09-05 20:03:04', '2023-09-05 20:03:04'),
(462, 1, 18, 'Edit Question', 'edit-question', 14, '2023-09-05 20:03:05', '2023-09-05 20:03:05'),
(463, 1, 18, 'Delete Question', 'delete-question', 15, '2023-09-05 20:03:05', '2023-09-05 20:03:05'),
(464, 1, 18, 'Add MCQ Content', 'add-mcq-content', 16, '2023-09-05 20:03:07', '2023-09-05 20:03:07'),
(465, 1, 17, 'View Ebook', 'view-ebook', 1, '2023-09-05 20:03:13', '2023-09-05 20:03:13'),
(466, 1, 17, 'CSV Ebook Upload', 'csv-ebook-upload', 2, '2023-09-05 20:03:13', '2023-09-05 20:03:13'),
(467, 1, 17, 'Delete Ebook', 'delete-ebook', 3, '2023-09-05 20:03:15', '2023-09-05 20:03:15'),
(468, 1, 17, 'View Mapping Ebook', 'view-mapping-ebook', 4, '2023-09-05 20:03:15', '2023-09-05 20:03:15'),
(469, 1, 17, 'Add Mapping Ebook', 'add-mapping-ebook', 5, '2023-09-05 20:03:17', '2023-09-05 20:03:17'),
(470, 1, 17, 'Delete Mapping Ebook', 'delete-mapping-ebook', 6, '2023-09-05 20:03:18', '2023-09-05 20:03:18'),
(471, 1, 17, 'Cloud Ebook Upload', 'cloud-ebook-upload', 7, '2023-09-05 20:03:20', '2023-09-05 20:03:20'),
(473, 1, 17, 'Add Ebook Content', 'add-ebook-content', 8, '2023-09-05 20:03:34', '2023-09-05 20:03:34'),
(474, 1, 16, 'View Tag', 'view-tag', 1, '2023-09-05 20:03:47', '2023-09-05 20:03:47'),
(475, 1, 16, 'Add Tag', 'add-tag', 2, '2023-09-05 20:03:48', '2023-09-05 20:03:48'),
(476, 1, 16, 'Edit Tag', 'edit-tag', 3, '2023-09-05 20:03:49', '2023-09-05 20:03:49'),
(477, 1, 16, 'View Video', 'view-video', 5, '2023-09-05 20:03:51', '2023-09-05 20:03:51'),
(478, 1, 16, 'Delete Tag', 'delete-tag', 4, '2023-09-05 20:03:53', '2023-09-05 20:03:53'),
(479, 1, 16, 'CSV Video Upload', 'csv-video-upload', 6, '2023-09-05 20:03:55', '2023-09-05 20:03:55'),
(480, 1, 16, 'Delete Video', 'delete-video', 7, '2023-09-05 20:03:56', '2023-09-05 20:03:56'),
(481, 1, 16, 'View Mapping Video', 'view-mapping-video', 8, '2023-09-05 20:03:57', '2023-09-05 20:03:57'),
(482, 1, 16, 'Add Mapping Video', 'add-mapping-video', 9, '2023-09-05 20:03:58', '2023-09-05 20:03:58'),
(483, 1, 16, 'Edit Mapping Video', 'edit-mapping-video', 10, '2023-09-05 20:04:03', '2023-09-05 20:04:03'),
(484, 1, 16, 'Delete Mapping Video', 'delete-mapping-video', 11, '2023-09-05 20:04:04', '2023-09-05 20:04:04'),
(485, 1, 16, 'View Bookmark', 'view-bookmark', 12, '2023-09-05 20:04:05', '2023-09-05 20:04:05'),
(486, 1, 16, 'Add Bookmark', 'add-bookmark', 13, '2023-09-05 20:04:11', '2023-09-05 20:04:11'),
(487, 1, 16, 'Edit Bookmark', 'edit-bookmark', 14, '2023-09-05 20:04:12', '2023-09-05 20:04:12'),
(488, 1, 16, 'Delete Bookmark', 'delete-bookmark', 15, '2023-09-05 20:04:13', '2023-09-05 20:04:13'),
(489, 1, 16, 'Assign Tag Mapping Video', 'assign-tag-mapping-video', 16, '2023-09-05 20:04:14', '2023-09-05 20:04:14'),
(490, 1, 16, 'Add Video Content', 'add-video-content', 17, '2023-09-05 20:04:15', '2023-09-05 20:04:15'),
(993, 1, 18, 'Upload Question', 'upload-question', 15, '2023-11-06 23:42:59', '2023-11-06 23:42:59');
-- --------------------------------------------------------
--
-- Table structure for table `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) UNSIGNED NOT NULL,
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_used_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;
--
-- Dumping data for table `personal_access_tokens`
--
INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\User', 21, 'Edukrypt', '814e201045e587264d25c3b6d99a3e8190b944286301a6812eb61723a45ceb6d', '[\"*\"]', NULL, '2024-03-14 09:54:00', '2024-03-14 09:54:00'),
(2, 'App\\Models\\User', 22, 'Edukrypt', '1d1dda40b32af6dc44b55e03f8f86bd8390d55439fe0661ed430fa8ce6a6569c', '[\"*\"]', '2024-03-15 11:00:42', '2024-03-14 09:54:55', '2024-03-15 11:00:42');
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`admin_id` bigint(20) UNSIGNED NOT NULL,
`school_id` bigint(20) UNSIGNED DEFAULT NULL,
`type` enum('admin','superadmin','gatekeeper','visitor') NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`id`, `name`, `slug`, `admin_id`, `school_id`, `type`, `created_at`, `updated_at`) VALUES
(1, 'gatekeeper', 'gatekeeper', 1, 0, 'visitor', '2024-03-13 12:00:41', '2024-03-13 12:00:41'),
(2, 'admin', 'admin', 1, 0, 'visitor', '2024-03-13 12:00:51', '2024-03-13 12:00:51'),
(3, 'visitor', 'visitor', 1, 0, 'visitor', '2024-03-13 12:00:59', '2024-03-13 12:00:59'),
(4, 'gatekeeper', 'gatekeeper', 14, 0, 'visitor', '2024-03-14 12:36:05', '2024-03-14 12:36:05'),
(6, 'superadmin', 'superadmin', 0, 0, 'superadmin', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `roles_permissions`
--
CREATE TABLE `roles_permissions` (
`id` int(11) NOT NULL,
`role_id` bigint(20) UNSIGNED NOT NULL,
`permission_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `roles_permissions`
--
INSERT INTO `roles_permissions` (`id`, `role_id`, `permission_id`) VALUES
(2, 2, 366),
(3, 2, 367),
(4, 2, 368),
(5, 2, 369),
(6, 2, 370),
(7, 2, 371);
-- --------------------------------------------------------
--
-- Table structure for table `sessionotps`
--
CREATE TABLE `sessionotps` (
`id` bigint(20) UNSIGNED NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`otp` int(11) NOT NULL,
`status` enum('active','inactive') COLLATE utf8mb4_unicode_ci 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 `sessionotps`
--
INSERT INTO `sessionotps` (`id`, `email`, `otp`, `status`, `created_at`, `updated_at`) VALUES
(1, 'mohnishkataria000@gmail.com', 6711, 'inactive', '2024-03-21 10:06:11', '2024-03-21 11:42:41'),
(2, 'mohnishkataria000@gmail.com', 4803, 'active', '2024-03-21 12:58:57', '2024-03-21 12:58:57'),
(3, 'mohnishkataria000@gmail.com', 8197, 'active', '2024-03-21 13:01:59', '2024-03-21 13:01:59'),
(4, 'mohnishkataria000@gmail.com', 4676, 'active', '2024-03-21 13:04:38', '2024-03-21 13:04:38'),
(5, 'mohnishkataria000@gmail.com', 1389, 'active', '2024-03-21 13:06:25', '2024-03-21 13:06:25'),
(6, 'mohnishkataria000@gmail.com', 9763, 'active', '2024-03-21 13:07:52', '2024-03-21 13:07:52');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`id_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`id_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`organization` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`organization_id` int(11) DEFAULT NULL,
`designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pincode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`profile_pics` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type` enum('admin','gatekeeper','visitor','superadmin') COLLATE utf8mb4_unicode_ci NOT NULL,
`status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 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 `users`
--
INSERT INTO `users` (`id`, `admin_id`, `name`, `email`, `mobile`, `email_verified_at`, `password`, `gender`, `id_type`, `id_number`, `organization`, `organization_id`, `designation`, `department`, `address`, `city`, `state`, `pincode`, `country`, `profile_pics`, `type`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 1, 'amit', 'admin@gmail.com', '9090909090', NULL, '$2y$10$gunyzxO9Lccg4Z5Nf0e7y.dUJ7uIaoh9ItVOmIeFoYjfSYuEyzN1W', 'male', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://localhost/visitor_management/public/admin/images/profile/1710401691.jpg', 'superadmin', '1', NULL, NULL, '2024-03-14 07:34:51'),
(14, 1, 'ravi', 'ravi@gmail.com', '9856325874', NULL, '$2y$10$RWCOriVm36hGil3IiA5zy.S2ijt4lZfxAcRFfNWyx23F5PCKsNOiO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'admin', '1', NULL, '2024-03-13 12:01:30', '2024-03-13 12:01:30'),
(15, 1, 'ajay kumar', 'ajay@gmail.com', '7586523541', NULL, '$2y$10$MBJ1FmS3maHWtW4Y5m8Hluh7poZ2bF4Uv6OX4LGWy0QYOGE17ytm.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'gatekeeper', '1', NULL, '2024-03-13 12:02:14', '2024-03-20 05:47:29'),
(21, 1, 'abhay', 'abhay@gmail.com', '2145874', NULL, '$2y$10$Cfrq00ZWrKQ1dAecbc8rTek4kJnYmyh.jes1DrYK9Ko1gwQxAjNRK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'visitor', '1', NULL, '2024-03-14 09:54:00', '2024-03-14 09:54:00'),
(22, 1, 'jayant', 'jai@gmail.com', '99845874', NULL, '$2y$10$/yJgbAJ0HCnFxdk5/txNQ.spgz8XsD.aIRrjg1VNK6z6rRRqBVFtW', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'visitor', '1', NULL, '2024-03-14 09:54:55', '2024-03-14 09:54:55'),
(23, 14, 'rakesh', 'rakesh@gmail.com', '8745874521', NULL, '$2y$10$VhKFqB30wMdoy3qvFQMcFOPS/FhXPhSe3sby60MZXl2ciD2h8aFYu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'gatekeeper', '1', NULL, '2024-03-14 12:33:31', '2024-03-15 11:07:00'),
(24, 1, NULL, 'rajkumar@gmail.com', '998458474', NULL, '$2y$10$40vg.EBISgd110B6lC3fQ.tieiF/jkKSVvEswBwI7NjzxFey/Zm12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'visitor', '1', NULL, '2024-03-16 06:56:04', '2024-03-16 06:56:04'),
(25, 1, 'ram', 'ram@gmail.com', '9632541256', NULL, '$2y$10$RUmCvnS3qR/0PUiMzU90t.BO28PRP1Nd0ZuquSi0n4Kmv/5j1uMxm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'gatekeeper', '1', NULL, '2024-03-20 04:38:17', '2024-03-20 04:38:17'),
(28, 0, 'ravi', 'demo@gamil.com', '', NULL, '$2y$10$5YUUuoBwE4yCC4sZNHdEIu.FFmOFy3j5L2BqYqIZ1Beq.0OTJk9bi', NULL, NULL, '632569853214', NULL, NULL, 'Designer', NULL, 'new delhi', 'delhi', 'delhi', '110011', 'India', NULL, 'visitor', '1', NULL, '2024-03-26 08:39:12', '2024-03-26 08:39:12'),
(30, 14, 'ravi', '8521475631@gamil.com', '8521475631', NULL, '$2y$10$YmfaHL5mz/NyGnQ67i9FT..Y4eej/.Gvo58aw30W84qMYFChWlC26', NULL, NULL, '632569853214', 'webtech new', 5, 'Designer', NULL, 'new delhi', 'delhi', 'delhi', '110011', 'India', NULL, 'visitor', '1', NULL, '2024-03-26 09:00:43', '2024-03-27 13:15:25'),
(33, 14, 'ajay', 'ajay123@gmail.com', '8523652142', NULL, '$2y$10$OIS228rSX/KtgGPR4qBrb.yIM887UKmg30XilOt.xSmeC34LYkE9a', NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'gatekeeper', '1', NULL, '2024-03-27 05:34:55', '2024-03-27 05:34:55'),
(34, 14, 'raja', 'raja12@gmail.com', '8563254123', NULL, '$2y$10$0s.yYZ5di4jPvCba0S5OEej2.DLGn71L5qbFTLLTTFOFixOfZWW4a', NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'gatekeeper', '1', NULL, '2024-03-27 05:44:11', '2024-03-27 05:44:11'),
(36, 14, 'abcd', 'abcd123@gmail.com', '8521475321', NULL, '$2y$10$NPRH.Z.z8tl6EARF55bxTufOl01Lvs/EK3ou9hpWG99OU5qPM1vhO', NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'visitor', '1', NULL, '2024-03-27 11:00:40', '2024-03-27 11:00:40'),
(41, 14, 'aman', 'aman@gmail.com', '432234234', NULL, '$2y$10$ihn721Jq05xMnEhpnXGJ1u8.U2LJVFkmPLxF.KCku29Tr4NkefI3m', NULL, NULL, NULL, 'NVS Public School', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'visitor', '1', NULL, '2024-03-27 12:40:45', '2024-03-27 13:16:18');
-- --------------------------------------------------------
--
-- Table structure for table `users_permissions`
--
CREATE TABLE `users_permissions` (
`user_id` bigint(20) UNSIGNED NOT NULL,
`permission_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `users_roles`
--
CREATE TABLE `users_roles` (
`id` int(11) NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `users_roles`
--
INSERT INTO `users_roles` (`id`, `user_id`, `role_id`) VALUES
(1, 14, 1),
(4, 16, 1),
(5, 23, 1),
(6, 25, 1),
(7, 15, 1),
(8, 27, 4),
(9, 33, 4),
(10, 34, 4),
(11, 1, 6),
(12, 37, 4),
(13, 38, 4),
(14, 39, 4);
-- --------------------------------------------------------
--
-- Table structure for table `visitor_categories`
--
CREATE TABLE `visitor_categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`category_name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `visitor_categories`
--
INSERT INTO `visitor_categories` (`id`, `admin_id`, `category_name`, `created_at`, `updated_at`) VALUES
(5, 1, 'guest', '2024-03-20 12:29:34', '2024-03-20 12:29:34'),
(6, 1, 'contractor', '2024-03-20 12:29:39', '2024-03-20 12:29:39');
-- --------------------------------------------------------
--
-- Table structure for table `visitor_company_relations`
--
CREATE TABLE `visitor_company_relations` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`company_id` int(11) 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 `visitor_company_relations`
--
INSERT INTO `visitor_company_relations` (`id`, `user_id`, `company_id`, `created_at`, `updated_at`) VALUES
(1, 41, 6, '2024-03-27 12:40:45', '2024-03-27 13:16:18'),
(2, 30, 5, '2024-03-27 13:14:13', '2024-03-27 13:15:25');
-- --------------------------------------------------------
--
-- Table structure for table `visitor_entries`
--
CREATE TABLE `visitor_entries` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_id` int(11) NOT NULL,
`gatekeeper_id` int(11) NOT NULL,
`visitor_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`information_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`gender` enum('male','female','other') COLLATE utf8mb4_unicode_ci NOT NULL,
`id_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`id_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`organization` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`visitor_mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`pincode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`profile_pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pre_approved_pass` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`vehicle_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`vehicle_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`visitor_category_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`number_of_visitor` int(11) DEFAULT NULL,
`purpose_of_visit` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`visiting_limit` int(11) DEFAULT NULL,
`location_information` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pass_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`check_in_time` datetime DEFAULT NULL,
`check_out_time` datetime DEFAULT NULL,
`gate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fever` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'no',
`sore_throat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'no',
`dry_cough` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'no',
`running_nose` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'no',
`covid_vaccination` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'no',
`host_id` int(11) DEFAULT NULL,
`host_department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`delivery_order` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`min` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`visit_date` date DEFAULT NULL,
`remarks` longtext COLLATE utf8mb4_unicode_ci DEFAULT 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 `visitor_entries`
--
INSERT INTO `visitor_entries` (`id`, `admin_id`, `gatekeeper_id`, `visitor_name`, `information_number`, `gender`, `id_type`, `id_number`, `organization`, `designation`, `visitor_mobile`, `address`, `city`, `state`, `pincode`, `country`, `profile_pic`, `pre_approved_pass`, `vehicle_type`, `vehicle_number`, `visitor_category_id`, `number_of_visitor`, `purpose_of_visit`, `visiting_limit`, `location_information`, `pass_number`, `contact_no`, `check_in_time`, `check_out_time`, `gate`, `fever`, `sore_throat`, `dry_cough`, `running_nose`, `covid_vaccination`, `host_id`, `host_department`, `delivery_order`, `min`, `visit_date`, `remarks`, `created_at`, `updated_at`) VALUES
(1, 14, 0, 'vinay', '', 'male', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, '1', NULL, 'job interview', NULL, NULL, NULL, '8526545236', '2024-03-20 12:00:00', '2024-03-20 12:30:00', '0', 'no', 'no', 'no', 'no', 'no', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 06:10:03', '2024-03-26 06:10:03'),
(2, 14, 0, 'vinay', '', 'male', '', '', '', '', '', '', '', '', '', '', '0', '345441', 'two wheeler', 'up3655', '1', NULL, 'job interview', NULL, 'delhi', NULL, '8526545236', '2024-03-20 12:00:00', '2024-03-20 12:30:00', '0', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 06:20:55', '2024-03-26 06:20:55'),
(3, 14, 0, 'vinay', '', 'male', '', '', '', '', '', '', '', '', '', '', '/admin/visitor/1711434759.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', NULL, 'delhi', NULL, '8526545236', '2024-03-20 12:00:00', '2024-03-20 12:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 06:32:39', '2024-03-26 06:32:39'),
(4, 14, 0, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', '', 'Designer', '9632547852', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711436665.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-20 12:00:00', '2024-03-20 12:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 07:04:25', '2024-03-26 07:04:25'),
(5, 14, 0, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '9632547852', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711436751.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-20 12:00:00', '2024-03-20 12:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 07:05:51', '2024-03-26 07:05:51'),
(6, 14, 0, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711442352.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-01-27 14:41:44', '2024-01-27 14:42:23', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 08:39:12', '2024-03-26 08:39:12'),
(8, 14, 0, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711443765.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '1900-01-27 00:00:00', '1900-01-27 00:00:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 09:02:45', '2024-03-26 09:02:45'),
(10, 14, 0, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711445969.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-27 14:00:00', '2024-03-27 14:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 09:39:29', '2024-03-26 09:39:29'),
(14, 14, 34, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711601351.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-28 16:00:00', '2024-03-28 16:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-28 04:49:11', '2024-03-28 04:49:11'),
(15, 14, 34, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711601362.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-29 16:00:00', '2024-03-29 16:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-28 04:49:22', '2024-03-28 04:49:22'),
(16, 14, 34, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711601374.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-29 15:00:00', '2024-03-29 15:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-28 04:49:34', '2024-03-28 04:49:34'),
(17, 14, 34, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711601387.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-29 18:00:00', '2024-03-29 18:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-28 04:49:47', '2024-03-28 04:49:47');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `modules`
--
ALTER TABLE `modules`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `module_permissions`
--
ALTER TABLE `module_permissions`
ADD PRIMARY KEY (`id`),
ADD KEY `module_permissions_module_id_foreign` (`module_id`);
--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);
--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
ADD PRIMARY KEY (`id`),
ADD KEY `module_id` (`module_id`),
ADD KEY `admin_id` (`admin_id`);
--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `slug` (`slug`,`admin_id`,`type`,`school_id`) USING BTREE;
--
-- Indexes for table `roles_permissions`
--
ALTER TABLE `roles_permissions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `role_id` (`role_id`,`permission_id`),
ADD KEY `roles_permissions_permission_id_foreign` (`permission_id`);
--
-- Indexes for table `sessionotps`
--
ALTER TABLE `sessionotps`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`),
ADD UNIQUE KEY `users_mobile_unique` (`mobile`);
--
-- Indexes for table `users_permissions`
--
ALTER TABLE `users_permissions`
ADD UNIQUE KEY `user_id` (`user_id`,`permission_id`),
ADD KEY `users_permissions_user_id_foreign` (`user_id`),
ADD KEY `users_permissions_permission_id_foreign` (`permission_id`);
--
-- Indexes for table `users_roles`
--
ALTER TABLE `users_roles`
ADD PRIMARY KEY (`id`),
ADD KEY `users_roles_user_id_foreign` (`user_id`),
ADD KEY `users_roles_role_id_foreign` (`role_id`);
--
-- Indexes for table `visitor_categories`
--
ALTER TABLE `visitor_categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `visitor_company_relations`
--
ALTER TABLE `visitor_company_relations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `visitor_entries`
--
ALTER TABLE `visitor_entries`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `modules`
--
ALTER TABLE `modules`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- AUTO_INCREMENT for table `module_permissions`
--
ALTER TABLE `module_permissions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=500;
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2112;
--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `roles_permissions`
--
ALTER TABLE `roles_permissions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `sessionotps`
--
ALTER TABLE `sessionotps`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
--
-- AUTO_INCREMENT for table `users_roles`
--
ALTER TABLE `users_roles`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `visitor_categories`
--
ALTER TABLE `visitor_categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `visitor_company_relations`
--
ALTER TABLE `visitor_company_relations`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `visitor_entries`
--
ALTER TABLE `visitor_entries`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `module_permissions`
--
ALTER TABLE `module_permissions`
ADD CONSTRAINT `module_permissions_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `permissions`
--
ALTER TABLE `permissions`
ADD CONSTRAINT `fk_key_module_id` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `roles_permissions`
--
ALTER TABLE `roles_permissions`
ADD CONSTRAINT `roles_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `roles_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;