|
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/peoplebee.in/___accounts-admin/ |
Upload File : |
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 26, 2024 at 11:21 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 NOT NULL,
`company_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`company_tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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');
-- --------------------------------------------------------
--
-- 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');
-- --------------------------------------------------------
--
-- 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,
`orgnization` varchar(255) COLLATE utf8mb4_unicode_ci 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`, `orgnization`, `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, '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, '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, '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, '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, '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, '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, '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, 'gatekeeper', '1', NULL, '2024-03-20 04:38:17', '2024-03-20 04:38:17'),
(27, 14, 'vikas', 'vikas@gmail.com', '8521475632', NULL, '$2y$10$f2TbzT/pMfP04Ot4YiUdBew2Hg/eVu8QCZe0Adj2gyJ5A53.AmCBe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'gatekeeper', '1', NULL, '2024-03-22 05:28:40', '2024-03-22 05:28:40'),
(28, 0, 'ravi', 'demo@gamil.com', '', NULL, '$2y$10$5YUUuoBwE4yCC4sZNHdEIu.FFmOFy3j5L2BqYqIZ1Beq.0OTJk9bi', NULL, NULL, '632569853214', NULL, 'Designer', NULL, 'new delhi', 'delhi', 'delhi', '110011', 'India', NULL, 'admin', '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', NULL, 'Designer', NULL, 'new delhi', 'delhi', 'delhi', '110011', 'India', NULL, 'admin', '1', NULL, '2024-03-26 09:00:43', '2024-03-26 09:00:43');
-- --------------------------------------------------------
--
-- 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);
-- --------------------------------------------------------
--
-- 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,
`visitor_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;
-- --------------------------------------------------------
--
-- Table structure for table `visitor_entries`
--
CREATE TABLE `visitor_entries` (
`id` bigint(20) UNSIGNED NOT NULL,
`admin_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`, `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, '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, '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, '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, '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, '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, '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'),
(7, 14, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711443643.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-26 02:00:00', '2024-03-26 00:00:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 09:00:43', '2024-03-26 09:00:43'),
(8, 14, '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'),
(9, 14, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711444587.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-27 02:00:00', '2024-03-27 02:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 09:16:27', '2024-03-26 09:16:27'),
(10, 14, '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'),
(11, 14, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711445990.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-26 14:00:00', '2024-03-26 14:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 09:39:50', '2024-03-26 09:39:50'),
(12, 14, 'ravi', '343sdfsdf', 'male', 'aadhar', '632569853214', 'Edukrypt', 'Designer', '8521475631', 'new delhi', 'delhi', 'delhi', '110011', 'India', '/admin/visitor/1711446034.png', '345441', 'two wheeler', 'up3655', '1', 2, 'job interview', 2, 'delhi', NULL, '8526545236', '2024-03-26 16:00:00', '2024-03-26 16:30:00', 'gate_2', 'no', 'no', 'no', 'no', 'yes', 11, 'Accounts', 'kj365247', '30', '2024-03-28', 'sfsdfsf', '2024-03-26 09:40:34', '2024-03-26 09:40:34');
--
-- 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=4;
--
-- 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=6;
--
-- 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=31;
--
-- AUTO_INCREMENT for table `users_roles`
--
ALTER TABLE `users_roles`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- 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 for table `visitor_entries`
--
ALTER TABLE `visitor_entries`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- 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 */;