File: /home/durgeshpandey215/www/subsidycrm/DB/subsidycrm.sql
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 06, 2024 at 07:46 AM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.2.0
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: `subsidycrm`
--
-- --------------------------------------------------------
--
-- Table structure for table `api_routes`
--
CREATE TABLE `api_routes` (
`id` bigint(20) NOT NULL,
`model` varchar(255) DEFAULT NULL,
`action_group` varchar(255) DEFAULT NULL,
`action_name` varchar(255) DEFAULT NULL,
`is_active` tinyint(1) DEFAULT 1,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `api_routes`
--
INSERT INTO `api_routes` (`id`, `model`, `action_group`, `action_name`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Auth', 'register', 'register', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:57:34'),
(2, 'Auth', 'login', 'login', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:56:32'),
(3, 'Auth', 'logout', 'logout', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:56:44'),
(4, 'Auth', 'token', 'refresh', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:57:23'),
(5, 'Auth', 'profile', 'me', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:57:11'),
(6, 'Role', 'read', 'role-index', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:57:45'),
(7, 'UAC', 'read', 'standard-uac', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:57:58'),
(8, 'UAC', 'read', 'standard-uac-model-action-group', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:58:11'),
(9, 'User', 'read', 'user-index', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:58:37'),
(10, 'User', 'read', 'user-show', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:56:01'),
(11, 'User', 'create', 'user-store', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:59:01'),
(12, 'User', 'update', 'user-update', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:59:11'),
(13, 'User', 'delete', 'user-destroy', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:58:23'),
(14, 'Customer', 'read', 'customer-index', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:54:41'),
(15, 'Customer', 'read', 'customer-show', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:54:55'),
(16, 'Customer', 'create', 'customer-store', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:55:04'),
(17, 'Customer', 'update', 'customer-update', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:55:16'),
(18, 'Customer', 'delete', 'customer-destroy', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:44:47'),
(19, 'Enum', 'read', 'enum-store-type', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:55:30'),
(20, 'Enum', 'read', 'enum-store-by-value', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:55:50'),
(21, 'Booking', 'read', 'booking-index', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:43:56'),
(22, 'Booking', 'read', 'booking-show', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:44:12'),
(23, 'Booking', 'create', 'booking-store', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:44:21'),
(24, 'Booking', 'update', 'booking-update', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 21:44:30'),
(25, 'booking', 'delete', 'booking-destroy', 1, 1, 1, '2024-06-24 18:57:38', '2024-06-24 19:00:33'),
(27, 'AssignCustomer', 'create', 'assign-customer', 1, 1, 1, '2024-06-28 04:06:56', '2024-06-28 04:08:01'),
(28, 'Customer', 'read', 'customer-booking', 1, 1, 1, '2024-06-28 22:32:57', '2024-06-28 22:33:21'),
(29, 'Booking', 'update', 'booking-update-status', 1, 1, 1, '2024-06-28 22:46:09', '2024-06-28 22:46:22'),
(30, 'Notification', 'read', 'notification-get-count', 1, 1, 1, '2024-06-30 23:43:14', '2024-06-30 23:43:38'),
(32, 'Notification', 'update', 'notification-update-view-status', 1, 1, 1, '2024-07-01 00:05:01', '2024-07-01 00:06:13'),
(33, 'Notification', 'update', 'notification-update-all-view-status', 1, 1, 1, '2024-07-01 00:05:50', '2024-07-01 00:06:04'),
(35, 'Enum', 'read', 'enum-store-by-name', 1, 1, 1, '2024-07-05 23:31:57', '2024-07-05 23:32:51');
-- --------------------------------------------------------
--
-- Table structure for table `bookings`
--
CREATE TABLE `bookings` (
`id` bigint(20) NOT NULL,
`ref_no` varchar(255) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`booking_date` date DEFAULT NULL,
`booking_amount` decimal(11,2) DEFAULT NULL,
`booking_amount_date` date DEFAULT NULL,
`project_report_amount` decimal(11,2) DEFAULT NULL,
`project_report_amount_date` date DEFAULT NULL,
`documents` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`payment_mode` bigint(20) DEFAULT NULL,
`payment_info` text DEFAULT NULL,
`operation_status` bigint(20) DEFAULT NULL,
`finance_status` bigint(20) DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `bookings`
--
INSERT INTO `bookings` (`id`, `ref_no`, `customer_id`, `booking_date`, `booking_amount`, `booking_amount_date`, `project_report_amount`, `project_report_amount_date`, `documents`, `payment_mode`, `payment_info`, `operation_status`, `finance_status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(8, NULL, 1, NULL, '100300.00', NULL, '140000.00', NULL, '\"[{\\\"doc_type_id\\\":\\\"1\\\",\\\"doc_name\\\":\\\"6676b414387601719055380.png\\\"},{\\\"doc_type_id\\\":\\\"2\\\",\\\"doc_name\\\":\\\"6676b414395f91719055380.png\\\"},{\\\"doc_type_id\\\":\\\"3\\\",\\\"doc_name\\\":\\\"6676b41439d041719055380.png\\\"},{\\\"doc_type_id\\\":\\\"4\\\",\\\"doc_name\\\":\\\"6676b4143a2d51719055380.jpg\\\"}]\"', NULL, NULL, 2, 1, 2, 2, '2024-06-22 05:53:00', '2024-06-28 23:07:33'),
(9, 'BSC5480F4B7047E80', 4, NULL, '100000.00', NULL, '140000.00', NULL, '\"[{\\\"doc_type_id\\\":\\\"1\\\",\\\"doc_name\\\":\\\"667e44aa2c3021719551146.png\\\"},{\\\"doc_type_id\\\":\\\"2\\\",\\\"doc_name\\\":\\\"667e44aa2cdc21719551146.jpg\\\"}]\"', NULL, NULL, 2, 12, 2, 2, '2024-06-27 23:35:46', '2024-06-28 23:11:39'),
(10, 'BSCFB2DBFE7D6A560', 4, NULL, '10000.00', NULL, '10000.00', NULL, '\"[{\\\"doc_type_id\\\":\\\"1\\\",\\\"doc_name\\\":\\\"667fa9278a4b61719642407.png\\\"},{\\\"doc_type_id\\\":\\\"2\\\",\\\"doc_name\\\":\\\"667fa9278aeff1719642407.jpg\\\"}]\"', NULL, NULL, 2, NULL, 2, 2, '2024-06-29 00:56:47', '2024-06-30 03:28:43'),
(12, 'BSCB9DF125C336866', 8, '2024-06-01', '120000.00', '2024-06-01', '150000.00', '2024-06-04', '\"[{\\\"doc_type_id\\\":\\\"1\\\",\\\"doc_name\\\":\\\"6688d954b456e1720244564.png\\\"},{\\\"doc_type_id\\\":\\\"2\\\",\\\"doc_name\\\":\\\"6688d954b52081720244564.jpg\\\"},{\\\"doc_type_id\\\":\\\"7\\\",\\\"doc_name\\\":\\\"6688d954b577b1720244564.png\\\"}]\"', 4, 'TX12345678', NULL, NULL, 2, 2, '2024-07-06 00:10:42', '2024-07-06 00:12:44');
-- --------------------------------------------------------
--
-- Table structure for table `cache`
--
CREATE TABLE `cache` (
`key` varchar(255) NOT NULL,
`value` mediumtext NOT NULL,
`expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `cache_locks`
--
CREATE TABLE `cache_locks` (
`key` varchar(255) NOT NULL,
`owner` varchar(255) NOT NULL,
`expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE `customers` (
`id` bigint(20) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`mobile` varchar(15) DEFAULT NULL,
`address` text DEFAULT NULL,
`product` bigint(20) DEFAULT NULL,
`model` bigint(20) DEFAULT NULL,
`variant` bigint(20) DEFAULT NULL,
`modification` bigint(20) DEFAULT NULL,
`fuel` bigint(20) DEFAULT NULL,
`attended_by_id` bigint(20) DEFAULT NULL,
`visit_date` date DEFAULT NULL,
`user_remark` text DEFAULT NULL,
`reference_by` varchar(255) DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `customers`
--
INSERT INTO `customers` (`id`, `name`, `email`, `mobile`, `address`, `product`, `model`, `variant`, `modification`, `fuel`, `attended_by_id`, `visit_date`, `user_remark`, `reference_by`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Soman Baweja', 'soman@gmail.com', '8949999990', 'Sion Mumba1 400022', 1, 1, 1, 1, 2, NULL, NULL, NULL, 'Ram Kumar', 2, 2, '2024-06-21 23:53:34', '2024-06-22 00:03:17'),
(3, 'roop Rathod', 'roop@gmail.com', '4449999990', 'Dadar Mumba1 400070', 1, 2, 3, 1, 1, NULL, NULL, NULL, 'Pawan Mehendi', 2, 2, '2024-06-22 00:25:50', '2024-07-02 01:35:37'),
(4, 'roop Rathod', 'roop@gmail.com', '4449999990', 'Dadar Mumba1 400070', 1, 2, 3, 1, 1, NULL, NULL, NULL, 'Pawan Mehendi', 2, 2, '2024-06-27 23:33:12', '2024-07-04 05:49:32'),
(6, 'Mithun Pawar', 'mithun@gmail.com', '7749909990', 'Mahim Mumba1 400070', 1, 2, 2, 1, NULL, NULL, NULL, NULL, 'Mithun Pawar', 2, NULL, '2024-06-28 05:17:36', '2024-06-28 05:17:36'),
(7, 'Manav Desai', 'manav@gmail.com', '2349909990', 'Mahim Mumba1 400070', 1, 2, 2, 1, NULL, NULL, NULL, NULL, 'Makrand Pawar', 2, NULL, '2024-06-29 01:06:13', '2024-06-29 01:06:13'),
(8, 'Purab Ganguly', 'purab@gmail.com', '4449909990', 'Pawai Mumba1 400090', 1, 2, 2, 2, 1, 5, '2024-06-05', 'Interested Confirm', 'Sonu Pasi', 2, 2, '2024-07-05 22:29:03', '2024-07-05 22:35:42');
-- --------------------------------------------------------
--
-- Table structure for table `customer_assignment`
--
CREATE TABLE `customer_assignment` (
`id` bigint(20) NOT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`action_type` bigint(20) DEFAULT NULL,
`is_active` tinyint(1) DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `customer_assignment`
--
INSERT INTO `customer_assignment` (`id`, `customer_id`, `user_id`, `action_type`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(12, 6, 6, NULL, 0, 2, 2, '2024-07-02 10:53:10', '2024-07-02 10:53:18'),
(13, 6, 9, NULL, 1, 2, NULL, '2024-07-02 10:53:18', '2024-07-02 10:53:18'),
(14, 6, 5, NULL, 0, 2, 2, '2024-07-02 10:53:36', '2024-07-02 10:58:29'),
(15, 6, 10, NULL, 0, 2, 2, '2024-07-02 10:53:44', '2024-07-02 10:58:29'),
(16, 6, 10, NULL, 1, 2, NULL, '2024-07-02 10:58:29', '2024-07-02 10:58:29');
-- --------------------------------------------------------
--
-- Table structure for table `enum_store`
--
CREATE TABLE `enum_store` (
`id` bigint(20) NOT NULL,
`type` varchar(255) DEFAULT NULL,
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `enum_store`
--
INSERT INTO `enum_store` (`id`, `type`, `data`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'product', '[\r\n{\"id\": 1,\"name\":\"Prod A\",\"color\":\"info\"},\r\n{\"id\": 2,\"name\":\"Prod B\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(2, 'model', '[\r\n{\"id\": 1,\"name\":\"Model A\",\"for\":\"Prod A\",\"color\":\"info\"},\r\n{\"id\": 2,\"name\":\"Model B\",\"for\":\"Prod A\",\"color\":\"info\"},\r\n{\"id\": 3,\"name\":\"Model C\",\"for\":\"Prod B\",\"color\":\"info\"},\r\n{\"id\": 4,\"name\":\"Model D\",\"for\":\"Prod B\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(3, 'variant', '[\r\n{\"id\": 1,\"name\":\"Vary A\",\"for\":\"Model A\",\"color\":\"info\"},\r\n{\"id\": 2,\"name\":\"Vary B\",\"for\":\"Model A\",\"color\":\"info\"},\r\n{\"id\": 3,\"name\":\"Vary C\",\"for\":\"Model B\",\"color\":\"info\"},\r\n{\"id\": 4,\"name\":\"Vary D\",\"for\":\"Model B\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(4, 'modification', '[\r\n{\"id\": 1,\"name\":\"Modify A\",\"for\":\"Prod A\",\"color\":\"info\"},\r\n{\"id\": 2,\"name\":\"Modify B\",\"for\":\"Prod A\",\"color\":\"info\"},\r\n{\"id\": 3,\"name\":\"Modify C\",\"for\":\"Prod A\",\"color\":\"info\"},\r\n{\"id\": 4,\"name\":\"Modify D\",\"for\":\"Prod A\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(5, 'fuel', '[\r\n{\"id\": 1,\"name\":\"Petrol\",\"color\":\"info\"},\r\n{\"id\": 2,\"name\":\"Diesel\",\"color\":\"info\"},\r\n{\"id\": 3,\"name\":\"Electric\",\"color\":\"info\"},\r\n{\"id\": 4,\"name\":\"Hybrid\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(6, 'doc_type', '[\r\n{\"id\": 1,\"name\":\"PAN\",\"color\":\"info\"},\r\n{\"id\": 2,\"name\":\"AADHAR Front\",\"color\":\"info\"},\r\n{\"id\": 3,\"name\":\"AADHAR back\",\"color\":\"info\"},\r\n{\"id\": 4,\"name\":\"Voter ID\",\"color\":\"info\"},\r\n{\"id\": 5,\"name\":\"Driving License\",\"color\":\"info\"},\r\n{\"id\": 6,\"name\":\"Bank Passbook\",\"color\":\"info\"},\r\n{\"id\": 7,\"name\":\"Payment Info\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(7, 'branch', '[\r\n{\"id\": 1,\"name\":\"Mumbai(Dadar)\",\"type\":\"Head\",\"color\":\"info\"},\r\n{\"id\": 2,\"name\":\"Mumbai(Vashi)\",\"color\":\"Operation\",\"color\":\"info\"},\r\n{\"id\": 3,\"name\":\"Mumbai(Andheri)\",\"color\":\"Finance\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(8, 'operation_status', '[\r\n{\"id\":1,\"name\":\"Booking Done\",\"color\":\"info\"},\r\n{\"id\":2,\"name\":\"File uploaded\",\"color\":\"info\"},\r\n{\"id\":3,\"name\":\"Subsidy Approved\",\"color\":\"info\"},\r\n{\"id\":4,\"name\":\"Ready for Finance\",\"color\":\"info\"},\r\n{\"id\":5,\"name\":\"Forwarded to Finance Team with Financer name\",\"color\":\"info\"},\r\n{\"id\":6,\"name\":\"Forward to EDP training\",\"color\":\"info\"},\r\n{\"id\":7,\"name\":\"EDP Training\",\"color\":\"info\"},\r\n{\"id\":8,\"name\":\"Subsidy Claimed\",\"color\":\"info\"},\r\n{\"id\":9,\"name\":\"Cancelled\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(9, 'finance_status', '[\r\n{\"id\":1,\"name\":\"File Received\",\"color\":\"info\"},\r\n{\"id\":2,\"name\":\"CIBIL check\",\"color\":\"info\"},\r\n{\"id\":3,\"name\":\"Home verification\",\"color\":\"info\"},\r\n{\"id\":4,\"name\":\"Loan Sanctioned\",\"color\":\"info\"},\r\n{\"id\":5,\"name\":\"Loan Disbursed\",\"color\":\"info\"},\r\n{\"id\":6,\"name\":\"Vehicle Modification\",\"color\":\"info\"},\r\n{\"id\":7,\"name\":\"Vehicle delivered\",\"color\":\"info\"},\r\n{\"id\":8,\"name\":\"Vehicle Documentation\",\"color\":\"info\"},\r\n{\"id\":9,\"name\":\"File Closed\",\"color\":\"info\"},\r\n{\"id\":10,\"name\":\"Cancelled\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(10, 'message', '[\r\n{\"id\":1,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your booking ref no. {ref_no} is created\",\"operation_status_id\":1,\"color\":\"info\"},\r\n{\"id\":2,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your document is uploaded for booking ref no. {ref_no}\",\"operation_status_id\":2,\"color\":\"info\"},\r\n{\"id\":3,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your subsidy is approved booking ref no. {ref_no}\",\"operation_status_id\":3,\"color\":\"info\"},\r\n{\"id\":4,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} you are ready for the finance process for booking ref no. {ref_no}\",\"operation_status_id\":4,\"color\":\"info\"},\r\n{\"id\":5,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your file id forwarded to financer for finance approval for booking ref no. {ref_no}\",\"operation_status_id\":5,\"color\":\"info\"},\r\n{\"id\":6,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your file is forward for EDP training for booking ref no. {ref_no}\",\"operation_status_id\":6,\"color\":\"info\"},\r\n{\"id\":7,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your file is under EDP training for booking ref no. {ref_no}\",\"operation_status_id\":7,\"color\":\"info\"},\r\n{\"id\":8,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your subsidy is claimed for booking ref no. {ref_no}\",\"operation_status_id\":8,\"color\":\"info\"},\r\n{\"id\":9,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your subsidy is cancelled for booking ref no. {ref_no}\",\"operation_status_id\":9,\"color\":\"info\"},\r\n{\"id\":10,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your file is revieved by finance team for booking ref no. {ref_no}\",\"finance_status_id\":1,\"color\":\"info\"},\r\n{\"id\":11,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your file under CIBIL check for booking ref no. {ref_no}\",\"finance_status_id\":2,\"color\":\"info\"},\r\n{\"id\":12,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your address is under verification for booking ref no. {ref_no}\",\"finance_status_id\":3,\"color\":\"info\"},\r\n{\"id\":13,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your loan in sanctioned for booking ref no. {ref_no}\",\"finance_status_id\":4,\"color\":\"info\"},\r\n{\"id\":14,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} you loan is disbursed for booking ref no. {ref_no}\",\"finance_status_id\":5,\"color\":\"info\"},\r\n{\"id\":15,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your you have opted for vehicle modifications for booking ref no. {ref_no}\",\"finance_status_id\":6,\"color\":\"info\"},\r\n{\"id\":16,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your vehicle is delivered for booking ref no. {ref_no}\",\"finance_status_id\":7,\"color\":\"info\"},\r\n{\"id\":17,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your vehicle documents are ready for booking ref no. {ref_no}\",\"finance_status_id\":8,\"color\":\"info\"},\r\n{\"id\":18,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your susidy process is final for booking ref no. {ref_no}\",\"finance_status_id\":9,\"color\":\"info\"},\r\n{\"id\":19,\"subject\":\"booking\",\"msg\":\"Dear {customer_name} your subsidy process is cancelled for booking ref no. {ref_no}\",\"finance_status_id\":10,\"color\":\"info\"},\r\n{\"id\":20,\"subject\":\"assign_customer\",\"msg\":\"{admin_name} has assigned {customer_name} to {user_name}\",\"color\":\"info\"},\r\n{\"id\":20,\"subject\":\"new_customer\",\"msg\":\"Dear {customer_name}, thank you for reaching out to us. We are eager to assist you and provide you with our best service.\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(11, 'notification_type', '[\r\n{\"id\":1,\"name\":\"System\",\"color\":\"info\"},\r\n{\"id\":2,\"name\":\"WhatsApp\",\"color\":\"info\"},\r\n{\"id\":3,\"name\":\"SMS\",\"color\":\"info\"},\r\n{\"id\":4,\"name\":\"Email\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(12, 'notification_for', '[\r\n{\"id\":1,\"name\":\"Internal\",\"color\":\"info\"},\r\n{\"id\":2,\"name\":\"External\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL),
(13, 'payment_mode', '[\r\n{\"id\":1,\"name\":\"Cash\",\"color\":\"info\"},\r\n{\"id\":2,\"name\":\"Cheque\",\"color\":\"info\"},\r\n{\"id\":3,\"name\":\"NEFT\",\"color\":\"info\"},\r\n{\"id\":4,\"name\":\"UPI\",\"color\":\"info\"},\r\n{\"id\":5,\"name\":\"Other\",\"color\":\"info\"}\r\n]', NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`uuid` varchar(255) NOT NULL,
`connection` text NOT NULL,
`queue` text NOT NULL,
`payload` longtext NOT NULL,
`exception` longtext NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE `jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`queue` varchar(255) NOT NULL,
`payload` longtext NOT NULL,
`attempts` tinyint(3) UNSIGNED NOT NULL,
`reserved_at` int(10) UNSIGNED DEFAULT NULL,
`available_at` int(10) UNSIGNED NOT NULL,
`created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `job_batches`
--
CREATE TABLE `job_batches` (
`id` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`total_jobs` int(11) NOT NULL,
`pending_jobs` int(11) NOT NULL,
`failed_jobs` int(11) NOT NULL,
`failed_job_ids` longtext NOT NULL,
`options` mediumtext DEFAULT NULL,
`cancelled_at` int(11) DEFAULT NULL,
`created_at` int(11) NOT NULL,
`finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL,
`migration` varchar(255) 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, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_06_20_061110_create_personal_access_tokens_table', 2);
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE `notifications` (
`id` bigint(20) NOT NULL,
`message` text DEFAULT NULL,
`notification_for` bigint(20) DEFAULT NULL,
`reference_id` bigint(20) DEFAULT NULL,
`viewed_by_admin` tinyint(1) DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `notifications`
--
INSERT INTO `notifications` (`id`, `message`, `notification_for`, `reference_id`, `viewed_by_admin`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(3, 'Super Admin has assigned Jayesh Pawar to Nikhil S Kumar', 1, 0, 1, 2, NULL, '2024-06-28 04:51:24', '2024-07-01 00:12:19'),
(4, 'Super Admin has assigned Jayesh Pawar to Nikhil S Kumar', 1, 0, 1, 2, NULL, '2024-06-28 05:12:20', '2024-07-01 00:12:19'),
(5, 'HTTP/1.0 200 OK\r\nCache-Control: no-cache, private\r\nContent-Type: application/json\r\nDate: Fri, 28 Jun 2024 10:43:40 GMT\r\n\r\n{\"message\":\"Message not found\",\"status\":\"success\"}', 2, 0, 1, 2, NULL, '2024-06-28 05:13:40', '2024-07-01 00:12:19'),
(6, 'Super Admin has assigned Jayesh Pawar to Nikhil S Kumar', 1, 0, 1, 2, NULL, '2024-06-28 05:15:06', '2024-07-01 00:12:19'),
(7, 'Dear Mithun Pawar, thank you for reaching out to us. We are eager to assist you and provide you with our best service.', 2, 0, 1, 2, NULL, '2024-06-28 05:17:36', '2024-07-01 00:12:19'),
(8, 'Super Admin has assigned Jayesh Pawar to Nikhil S Kumar', 1, 0, 1, 2, NULL, '2024-06-28 05:22:49', '2024-07-01 00:12:19'),
(9, 'Dear Soman Baweja your document is uploaded for booking ref no. ', 2, 0, 1, 2, NULL, '2024-06-28 23:07:33', '2024-07-01 00:12:19'),
(10, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSC5480F4B7047E80', 2, 0, 1, 2, NULL, '2024-06-28 23:08:41', '2024-07-01 00:12:19'),
(11, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSC5480F4B7047E80', 2, 0, 1, 2, NULL, '2024-06-28 23:09:49', '2024-07-01 00:12:19'),
(12, 'Dear Jayesh Pawar your file under CIBIL check for booking ref no. BSC5480F4B7047E80', 2, 0, 1, 2, NULL, '2024-06-28 23:10:06', '2024-07-01 00:12:19'),
(13, 'Dear Jayesh Pawar your subsidy process is cancelled for booking ref no. BSC5480F4B7047E80', 2, 0, 1, 2, NULL, '2024-06-28 23:11:17', '2024-07-01 00:12:19'),
(14, 'Dear Jayesh Pawar your susidy process is final for booking ref no. BSC5480F4B7047E80', 2, 0, 1, 2, NULL, '2024-06-28 23:11:31', '2024-07-01 00:12:19'),
(15, 'Dear Jayesh Pawar your booking ref no. BSCFB2DBFE7D6A560 is created', 2, 0, 1, 2, NULL, '2024-06-29 00:57:38', '2024-07-01 00:12:19'),
(16, 'Dear Jayesh Pawar your booking ref no. BSCFB2DBFE7D6A560 is created', 2, 0, 1, 2, NULL, '2024-06-29 00:58:37', '2024-07-01 00:12:19'),
(17, 'Super Admin has assigned Jayesh Pawar to Durgesh Kumar', 1, 0, 1, 2, NULL, '2024-06-29 01:01:54', '2024-07-01 00:12:19'),
(18, 'Super Admin has assigned Jayesh Pawar to Durgesh Kumar', 1, 0, 1, 2, NULL, '2024-06-29 01:04:02', '2024-07-01 00:12:19'),
(19, 'Super Admin has assigned Mithun Pawar to Durgesh Kumar', 1, 0, 1, 2, NULL, '2024-06-29 01:04:32', '2024-07-01 00:12:19'),
(20, 'Dear Manav Desai, thank you for reaching out to us. We are eager to assist you and provide you with our best service.', 2, 0, 1, 2, NULL, '2024-06-29 01:06:13', '2024-07-01 00:12:19'),
(21, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 03:28:43', '2024-07-01 00:12:19'),
(22, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 03:29:23', '2024-07-01 00:12:19'),
(23, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 08:09:02', '2024-07-01 00:12:19'),
(24, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 08:09:24', '2024-07-01 00:12:19'),
(25, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 08:15:15', '2024-07-01 00:12:19'),
(26, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 08:17:06', '2024-07-01 00:12:19'),
(27, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 08:27:34', '2024-07-01 00:12:19'),
(28, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 08:29:31', '2024-07-01 00:12:19'),
(29, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 08:36:51', '2024-07-01 00:12:19'),
(30, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 21:46:19', '2024-07-01 00:12:19'),
(31, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 22:46:59', '2024-07-01 00:12:19'),
(32, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 22:47:53', '2024-07-01 00:12:19'),
(33, 'Dear Jayesh Pawar your document is uploaded for booking ref no. BSCFB2DBFE7D6A560', 2, 0, 1, 2, NULL, '2024-06-30 22:48:50', '2024-07-01 00:12:19'),
(34, 'Super Admin has assigned Mithun Pawar to Durgesh Kumar', 1, 1, 0, 2, NULL, '2024-07-02 10:49:19', '2024-07-02 10:49:19'),
(35, 'Super Admin has assigned Mithun Pawar to Durgesh Kumar', 1, 1, 0, 2, NULL, '2024-07-02 10:53:10', '2024-07-02 10:53:10'),
(36, 'Super Admin has assigned Mithun Pawar to Suresh', 1, 1, 0, 2, NULL, '2024-07-02 10:53:19', '2024-07-02 10:53:19'),
(37, 'Super Admin has assigned Mithun Pawar to Sunil Kumar', 1, 1, 0, 2, NULL, '2024-07-02 10:53:36', '2024-07-02 10:53:36'),
(38, 'Super Admin has assigned Mithun Pawar to Manojam K', 1, 1, 0, 2, NULL, '2024-07-02 10:53:44', '2024-07-02 10:53:44'),
(39, 'Super Admin has assigned Mithun Pawar to Manojam K', 1, 1, 0, 2, NULL, '2024-07-02 10:58:30', '2024-07-02 10:58:30'),
(40, 'Dear Purab Ganguly, thank you for reaching out to us. We are eager to assist you and provide you with our best service.', 2, 8, 0, 2, NULL, '2024-07-05 22:29:03', '2024-07-05 22:29:03');
-- --------------------------------------------------------
--
-- Table structure for table `password_reset_tokens`
--
CREATE TABLE `password_reset_tokens` (
`email` varchar(255) NOT NULL,
`token` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) UNSIGNED NOT NULL,
`tokenable_type` varchar(255) NOT NULL,
`tokenable_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`token` varchar(64) NOT NULL,
`abilities` text DEFAULT NULL,
`last_used_at` timestamp NULL DEFAULT NULL,
`expires_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`id` bigint(20) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`id`, `name`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'superadmin', 1, 1, NULL, NULL),
(2, 'admin', 1, 1, NULL, NULL),
(3, 'operation', 1, 1, NULL, NULL),
(4, 'finance', 1, 1, NULL, NULL),
(5, 'systemadmin', 5, 5, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `sessions`
--
CREATE TABLE `sessions` (
`id` varchar(255) NOT NULL,
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
`ip_address` varchar(45) DEFAULT NULL,
`user_agent` text DEFAULT NULL,
`payload` longtext NOT NULL,
`last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `sessions`
--
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('TeWkPNoB4gROE5kRuhyS1F1oOnZqEhtjEjBcbkoF', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVkM5ZjdmMXpmeUZaTkFPNW5udTZ6Q1RMbWxUYU1BRktWa0JjaURidyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9zeXN0ZW0vYXBpLXJvdXRlcyI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1720242204);
-- --------------------------------------------------------
--
-- Table structure for table `standard_uac`
--
CREATE TABLE `standard_uac` (
`id` bigint(20) NOT NULL,
`role_id` bigint(20) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
`action_name` varchar(255) DEFAULT NULL,
`action_group` varchar(255) DEFAULT NULL,
`permission` tinyint(1) DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `standard_uac`
--
INSERT INTO `standard_uac` (`id`, `role_id`, `model`, `action_name`, `action_group`, `permission`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'Auth', 'login', 'login', 1, 1, 1, '2024-06-24 22:01:02', '2024-06-24 22:01:02'),
(2, 1, 'Auth', 'logout', 'logout', 1, 1, 1, '2024-06-24 22:01:04', '2024-06-24 22:01:04'),
(3, 1, 'Auth', 'me', 'profile', 1, 1, 1, '2024-06-24 22:01:06', '2024-06-24 22:01:06'),
(4, 1, 'Auth', 'register', 'register', 1, 1, 1, '2024-06-24 22:01:07', '2024-06-24 22:01:07'),
(5, 1, 'Auth', 'refresh', 'token', 1, 1, 1, '2024-06-24 22:01:08', '2024-06-24 22:01:08'),
(6, 1, 'Booking', 'booking-store', 'create', 1, 1, 1, '2024-06-24 22:01:09', '2024-06-24 22:01:09'),
(7, 1, 'booking', 'booking-destroy', 'delete', 1, 1, 1, '2024-06-24 22:01:10', '2024-06-24 22:01:10'),
(8, 1, 'Booking', 'booking-index', 'read', 1, 1, 1, '2024-06-24 22:01:11', '2024-06-24 22:01:11'),
(9, 1, 'Booking', 'booking-show', 'read', 1, 1, 1, '2024-06-24 22:01:11', '2024-06-24 22:01:11'),
(10, 1, 'Booking', 'booking-update', 'update', 1, 1, 1, '2024-06-24 22:01:12', '2024-06-24 22:01:12'),
(11, 1, 'Customer', 'customer-store', 'create', 1, 1, 1, '2024-06-24 22:01:29', '2024-06-24 22:01:29'),
(12, 1, 'Customer', 'customer-destroy', 'delete', 1, 1, 1, '2024-06-24 22:01:29', '2024-06-24 22:01:29'),
(13, 1, 'Customer', 'customer-index', 'read', 1, 1, 1, '2024-06-24 22:01:31', '2024-06-24 22:01:31'),
(14, 1, 'Customer', 'customer-show', 'read', 1, 1, 1, '2024-06-24 22:01:32', '2024-06-24 22:01:32'),
(15, 1, 'Customer', 'customer-update', 'update', 1, 1, 1, '2024-06-24 22:01:32', '2024-06-24 22:01:32'),
(16, 1, 'Enum', 'enum-store-type', 'read', 1, 1, 1, '2024-06-24 22:01:33', '2024-06-24 22:01:33'),
(17, 1, 'Enum', 'enum-store-by-value', 'read', 1, 1, 1, '2024-06-24 22:01:34', '2024-06-24 22:01:34'),
(18, 1, 'Role', 'role-index', 'read', 1, 1, 1, '2024-06-24 22:01:35', '2024-06-24 22:01:35'),
(19, 1, 'UAC', 'standard-uac', 'read', 1, 1, 1, '2024-06-24 22:01:36', '2024-06-24 22:01:36'),
(20, 1, 'UAC', 'standard-uac-model-action-group', 'read', 1, 1, 1, '2024-06-24 22:01:37', '2024-06-24 22:01:37'),
(21, 1, 'User', 'user-store', 'create', 1, 1, 1, '2024-06-24 22:01:48', '2024-06-24 22:01:48'),
(22, 1, 'User', 'user-destroy', 'delete', 1, 1, 1, '2024-06-24 22:01:48', '2024-06-24 22:01:48'),
(23, 1, 'User', 'user-index', 'read', 1, 1, 1, '2024-06-24 22:01:49', '2024-06-24 22:01:49'),
(25, 1, 'User', 'user-update', 'update', 1, 1, 1, '2024-06-24 22:01:51', '2024-06-24 22:01:51'),
(28, 1, 'User', 'user-show', 'read', 1, 1, 1, '2024-06-24 21:56:08', '2024-06-24 21:56:08'),
(30, 1, 'AssignCustomer', 'assign-customer', 'create', 1, 1, 1, '2024-06-28 04:08:04', '2024-06-28 04:08:04'),
(31, 1, 'Customer', 'customer-booking', 'read', 1, 1, 1, '2024-06-28 22:33:31', '2024-06-28 22:33:31'),
(32, 1, 'Booking', 'booking-update-status', 'update', 1, 1, 1, '2024-06-28 22:46:28', '2024-06-28 22:46:28'),
(35, 1, 'Notification', 'notification-get-count', 'read', 1, 1, 1, '2024-06-30 23:43:55', '2024-06-30 23:43:55'),
(37, 1, NULL, 'notification-update-all-view-status', NULL, 1, 1, 1, '2024-07-01 00:05:53', '2024-07-01 00:05:53'),
(38, 1, NULL, 'notification-update-view-status', NULL, 1, 1, 1, '2024-07-01 00:05:54', '2024-07-01 00:05:54'),
(39, 1, 'Enum', 'enum-store-by-name', 'read', 1, 1, 1, '2024-07-05 23:33:00', '2024-07-05 23:33:00');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint(20) NOT NULL,
`role_id` bigint(20) DEFAULT NULL,
`branch_id` bigint(20) DEFAULT 1,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`mobile` varchar(15) DEFAULT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) NOT NULL,
`uac` text DEFAULT NULL,
`is_active` tinyint(1) DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `role_id`, `branch_id`, `name`, `email`, `mobile`, `email_verified_at`, `password`, `uac`, `is_active`, `remember_token`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 5, 1, 'Sytem Admin', 'system@gmail.com', '9967806575', NULL, '$2y$12$u4RjXQj3IJjxnCA9kIXJXO4ddlDMAPQ0wASj9Ni5PYB8tiXWY3Lay', '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]', 1, NULL, NULL, NULL, '2024-06-20 23:51:59', '2024-06-20 23:51:59'),
(2, 1, 1, 'Super Admin', 'superadmin@gmail.com', '9999999997', NULL, '$2y$12$qBRHEqgQcQFwJBuVWIEHN.sRVUZz8.ECCwoaiTBtR.sNNPy4/5INW', '[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]', 1, NULL, NULL, 2, '2024-06-21 02:17:44', '2024-06-21 03:19:06'),
(5, 4, 1, 'Sunil Kumar', 'sunilkumar@gmail.com', '9949999990', NULL, '$2y$12$8Nm4M5Swi9VCwxmIS0NWE.9JGwUv8ZJ2KI5YjDzfhc5aze5TBVify', '[1,2,6,7,8,9]', 1, NULL, 2, NULL, '2024-06-21 03:00:51', '2024-06-21 03:00:51'),
(6, 3, 1, 'Durgesh Kumar', 'durgeshkumar@gmail.com', '9949669990', NULL, '$2y$12$2V6UEfPQajyBCoyDUwvBV.bKoViy1B73OU8rvq8YWWxdv3PopWUhC', NULL, 1, NULL, 2, NULL, '2024-06-22 01:55:32', '2024-06-22 01:55:32'),
(7, 2, 3, 'Nikhil S Kumar', 'nikhilkumar@gmail.com', '8765453423', NULL, '$2y$12$qC6sgB6Kh5HCZfsORhuYg.9rCiZRY/HTGTdfglIK5bt0mLBwB9XJa', '[1,2,6,7,8,9]', 1, NULL, 2, 2, '2024-06-22 22:13:27', '2024-06-22 22:21:57'),
(8, 5, 1, 'System Admin', 'system@gmail.com', '9967806575', NULL, '$2y$12$u4RjXQj3IJjxnCA9kIXJXO4ddlDMAPQ0wASj9Ni5PYB8tiXWY3Lay', NULL, 1, NULL, 5, 5, NULL, NULL),
(9, 3, 1, 'Suresh', 'suresh@gmail.com', '9999944999', NULL, '$2y$12$awWUh.IhFKSenc.Omi7ib.OCRD8QfzK/DYER6k8aNDVhzQ0W6ePxi', NULL, 1, NULL, NULL, 2, '2024-06-24 22:25:32', '2024-06-28 02:11:37'),
(10, 4, 3, 'Manojam K', 'manojam@gmail.com', '8765453423', NULL, '$2y$12$Y16JNwC6zqD7SkAtQ/EQ..v2UUL4PmQQDHUX/m/p7r/V2fYUx8GXy', NULL, 1, NULL, 2, 2, '2024-06-24 22:27:12', '2024-06-24 22:29:15');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `api_routes`
--
ALTER TABLE `api_routes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
ADD PRIMARY KEY (`id`),
ADD KEY `customer_id` (`customer_id`);
--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
ADD PRIMARY KEY (`key`);
--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
ADD PRIMARY KEY (`key`);
--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
ADD PRIMARY KEY (`id`),
ADD KEY `attented_by_id` (`attended_by_id`);
--
-- Indexes for table `customer_assignment`
--
ALTER TABLE `customer_assignment`
ADD PRIMARY KEY (`id`),
ADD KEY `customer_id` (`customer_id`),
ADD KEY `user_id` (`user_id`);
--
-- Indexes for table `enum_store`
--
ALTER TABLE `enum_store`
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 `jobs`
--
ALTER TABLE `jobs`
ADD PRIMARY KEY (`id`),
ADD KEY `jobs_queue_index` (`queue`);
--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
ADD PRIMARY KEY (`email`);
--
-- 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`);
--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
ADD PRIMARY KEY (`id`),
ADD KEY `sessions_user_id_index` (`user_id`),
ADD KEY `sessions_last_activity_index` (`last_activity`);
--
-- Indexes for table `standard_uac`
--
ALTER TABLE `standard_uac`
ADD PRIMARY KEY (`id`),
ADD KEY `role_id` (`role_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD KEY `role_id` (`role_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `api_routes`
--
ALTER TABLE `api_routes`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `customer_assignment`
--
ALTER TABLE `customer_assignment`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `enum_store`
--
ALTER TABLE `enum_store`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `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=5;
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `standard_uac`
--
ALTER TABLE `standard_uac`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`);
--
-- Constraints for table `customers`
--
ALTER TABLE `customers`
ADD CONSTRAINT `customers_ibfk_1` FOREIGN KEY (`attended_by_id`) REFERENCES `users` (`id`);
--
-- Constraints for table `customer_assignment`
--
ALTER TABLE `customer_assignment`
ADD CONSTRAINT `customer_assignment_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
ADD CONSTRAINT `customer_assignment_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints for table `standard_uac`
--
ALTER TABLE `standard_uac`
ADD CONSTRAINT `standard_uac_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);
--
-- Constraints for table `users`
--
ALTER TABLE `users`
ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);
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 */;