text: -- phpMyAdmin SQL Dump
  -- version 4.9.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: Aug 03, 2021 at 12:32 PM
  -- Server version: 8.0.17
  -- PHP Version: 7.3.10
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  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: `salesmap`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `attendances`
  --
  
  CREATE TABLE `attendances` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `users_id` int(10) UNSIGNED NOT NULL,
    `lat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `long` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `device` text COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `attendances`
  --
  
  INSERT INTO `attendances` (`id`, `users_id`, `lat`, `long`, `created_at`, `updated_at`, `address`, `device`) VALUES
  (3, 2, '24.7488437', '46.6608875', '2021-07-28 05:08:03', '2021-07-28 05:08:03', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', ''),
  (4, 2, '24.7488437', '46.6608875', '2021-07-28 05:10:01', '2021-07-28 05:10:01', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', ''),
  (5, 2, '24.7488437', '46.6608875', '2021-07-28 06:35:13', '2021-07-28 06:35:13', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', ''),
  (6, 2, '24.7488437', '46.6608875', '2021-07-28 06:38:48', '2021-07-28 06:38:48', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', ''),
  (7, 2, '24.7488437', '46.6608875', '2021-08-01 06:17:27', '2021-08-01 06:17:27', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36'),
  (8, 2, '24.7488437', '46.6608875', '2021-08-01 06:24:36', '2021-08-01 06:24:36', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36'),
  (9, 2, '24.7488437', '46.6608875', '2021-08-01 06:24:43', '2021-08-01 06:24:43', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36'),
  (10, 2, '24.7488437', '46.6608875', '2021-08-01 06:26:25', '2021-08-01 06:26:25', '3073 Alshahir St, Al Muruj, Riyadh 12281 6262, Saudi Arabia', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `clients`
  --
  
  CREATE TABLE `clients` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `maplink` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_apicustom`
  --
  
  CREATE TABLE `cms_apicustom` (
    `id` int(10) UNSIGNED NOT NULL,
    `permalink` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `tabel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `aksi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `kolom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `orderby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `sub_query_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `sql_where` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `keterangan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parameter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `method_type` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parameters` longtext COLLATE utf8mb4_unicode_ci,
    `responses` longtext COLLATE utf8mb4_unicode_ci
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_apikey`
  --
  
  CREATE TABLE `cms_apikey` (
    `id` int(10) UNSIGNED NOT NULL,
    `screetkey` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `hit` int(11) DEFAULT NULL,
    `status` varchar(25) 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;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_dashboard`
  --
  
  CREATE TABLE `cms_dashboard` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_cms_privileges` int(11) DEFAULT NULL,
    `content` longtext COLLATE utf8mb4_unicode_ci,
    `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 `cms_email_queues`
  --
  
  CREATE TABLE `cms_email_queues` (
    `id` int(10) UNSIGNED NOT NULL,
    `send_at` datetime DEFAULT NULL,
    `email_recipient` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_from_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_from_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_cc_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_content` text COLLATE utf8mb4_unicode_ci,
    `email_attachments` text COLLATE utf8mb4_unicode_ci,
    `is_sent` tinyint(1) 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 `cms_email_templates`
  --
  
  CREATE TABLE `cms_email_templates` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` longtext COLLATE utf8mb4_unicode_ci,
    `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `from_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `from_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `cc_email` varchar(255) 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 `cms_email_templates`
  --
  
  INSERT INTO `cms_email_templates` (`id`, `name`, `slug`, `subject`, `content`, `description`, `from_name`, `from_email`, `cc_email`, `created_at`, `updated_at`) VALUES
  (1, 'Email Template Forgot Password Backend', 'forgot_password_backend', NULL, '<p>Hi,</p><p>Someone requested forgot password, here is your new password : </p><p>[password]</p><p><br></p><p>--</p><p>Regards,</p><p>Admin</p>', '[password]', 'System', 'system@crudbooster.com', NULL, '2021-07-27 11:36:03', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_logs`
  --
  
  CREATE TABLE `cms_logs` (
    `id` int(10) UNSIGNED NOT NULL,
    `ipaddress` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `useragent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `details` text COLLATE utf8mb4_unicode_ci,
    `id_cms_users` int(11) 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 `cms_logs`
  --
  
  INSERT INTO `cms_logs` (`id`, `ipaddress`, `useragent`, `url`, `description`, `details`, `id_cms_users`, `created_at`, `updated_at`) VALUES
  (1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2021-07-27 11:36:47', NULL),
  (2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2021-07-27 11:49:20', NULL),
  (3, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/menu_management/edit-save/1', 'Update data Clients Management at Menu Management', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>name</td><td>ادارة العملاء</td><td>Clients Management</td></tr><tr><td>type</td><td>Route</td><td>Module</td></tr><tr><td>path</td><td>AdminClientsControllerGetIndex</td><td>clients</td></tr><tr><td>color</td><td></td><td>normal</td></tr></tbody></table>', 1, '2021-07-27 12:02:53', NULL),
  (4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/clients/add-save', 'Add New Data ابراهيم at Clients', '', 1, '2021-07-27 12:14:53', NULL),
  (5, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/clients/delete/1', 'Delete data ابراهيم at Clients', '', 1, '2021-07-27 12:44:21', NULL),
  (6, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2021-07-28 03:45:00', NULL),
  (7, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2021-07-28 03:59:46', NULL),
  (8, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/users13/edit-save/2', 'Update data Ibrahim at Employees', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>email_verified_at</td><td></td><td></td></tr><tr><td>password</td><td>$2y$10$daXDbg4Nswpka/Av/jpL.uWJ5BVpH7cU7OAWKUcZ0JhuJ76XMbPo6</td><td></td></tr><tr><td>remember_token</td><td>eXSVWHM9EnPPst9WrjDgG9vwozn5qcyHEWXhimsptZjiqpRS1P2YfvCZh1pP</td><td></td></tr><tr><td>empid</td><td></td><td>10057</td></tr></tbody></table>', 1, '2021-07-28 05:15:58', NULL),
  (9, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/users13/edit-save/1', 'Update data Ibrahim Elsanhouri at Employees', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>email_verified_at</td><td></td><td></td></tr><tr><td>password</td><td>$2y$10$Z12QFMJtfd7mjE698obD/eCHxoaxxG/ihPLhMkRJoNWOWtyKFBOde</td><td></td></tr><tr><td>remember_token</td><td></td><td></td></tr><tr><td>empid</td><td></td><td>10057</td></tr></tbody></table>', 1, '2021-07-28 05:16:13', NULL),
  (10, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/users13/edit-save/1', 'Update data Ibrahim Elsanhouri at Employees', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>email_verified_at</td><td></td><td></td></tr><tr><td>password</td><td>$2y$10$Z12QFMJtfd7mjE698obD/eCHxoaxxG/ihPLhMkRJoNWOWtyKFBOde</td><td></td></tr><tr><td>remember_token</td><td></td><td></td></tr><tr><td>empid</td><td>10057</td><td>10054</td></tr></tbody></table>', 1, '2021-07-28 05:16:26', NULL),
  (11, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2021-07-28 05:21:09', NULL),
  (12, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/menu_management/edit-save/3', 'Update data Attendance at Menu Management', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>color</td><td></td><td>normal</td></tr><tr><td>sorting</td><td>3</td><td></td></tr></tbody></table>', 1, '2021-07-28 05:23:56', NULL),
  (13, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/attendances/delete/2', 'Delete data 2 at Attendance', '', 1, '2021-07-28 05:24:14', NULL),
  (14, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/attendances/delete/1', 'Delete data 1 at Attendance', '', 1, '2021-07-28 05:24:17', NULL),
  (15, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/menu_management/edit-save/1', 'Update data Clients Management at Menu Management', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody></tbody></table>', 1, '2021-07-28 05:48:04', NULL),
  (16, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/menu_management/edit-save/2', 'Update data Employees at Menu Management', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>color</td><td></td><td>normal</td></tr><tr><td>sorting</td><td>2</td><td></td></tr></tbody></table>', 1, '2021-07-28 05:48:14', NULL),
  (17, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/logout', 'admin@crudbooster.com logout', '', 1, '2021-07-28 05:59:23', NULL),
  (18, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2021-07-28 05:59:31', NULL),
  (19, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/statistic_builder/add-save', 'Add New Data Main Statistic at Statistic Builder', '', 1, '2021-07-28 05:59:57', NULL),
  (20, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/statistic_builder/delete/1', 'Delete data Main Statistic at Statistic Builder', '', 1, '2021-07-28 06:05:51', NULL),
  (21, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/statistic_builder/add-save', 'Add New Data Main Statistic at Statistic Builder', '', 1, '2021-07-28 06:06:03', NULL),
  (22, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/menu_management/add-save', 'Add New Data Main Dashboard at Menu Management', '', 1, '2021-07-28 06:21:51', NULL),
  (23, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/users/add-save', 'Add New Data Saleh Alsanosi at Users Management', '', 1, '2021-07-28 06:29:50', NULL),
  (24, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/users/edit-save/1', 'Update data Super Admin at Users Management', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>photo</td><td></td><td>uploads/1/2021-07/logo_tuv_1.png</td></tr><tr><td>password</td><td>$2y$10$uKXucyH.tiIvmKFo0HImOe8GqIEAVStZBEXdEliOHLBPBgM3wtNBi</td><td></td></tr><tr><td>status</td><td>Active</td><td></td></tr></tbody></table>', 1, '2021-07-28 06:30:04', NULL),
  (25, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/users/edit-save/1', 'Update data Super Admin at Users Management', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>email</td><td>admin@crudbooster.com</td><td>ialsanhouri@tuvaustria.sa</td></tr><tr><td>password</td><td>$2y$10$uKXucyH.tiIvmKFo0HImOe8GqIEAVStZBEXdEliOHLBPBgM3wtNBi</td><td></td></tr><tr><td>status</td><td>Active</td><td></td></tr></tbody></table>', 1, '2021-07-28 06:30:22', NULL),
  (26, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/logout', 'ialsanhouri@tuvaustria.sa logout', '', 1, '2021-07-28 06:34:54', NULL),
  (27, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'ialsanhouri@tuvaustria.sa login with IP Address 127.0.0.1', '', 1, '2021-07-28 06:39:06', NULL),
  (28, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'ialsanhouri@tuvaustria.sa login with IP Address 127.0.0.1', '', 1, '2021-07-30 07:52:09', NULL),
  (29, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'ialsanhouri@tuvaustria.sa login with IP Address 127.0.0.1', '', 1, '2021-08-01 03:30:22', NULL),
  (30, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/offices/add-save', 'Add New Data Riyadh Office (Head Office) at Office Management', '', 1, '2021-08-01 03:35:44', NULL),
  (31, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/offices/add-save', 'Add New Data Egypt Office at Office Management', '', 1, '2021-08-01 03:35:52', NULL),
  (32, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/offices/add-save', 'Add New Data UAE Office at Office Management', '', 1, '2021-08-01 03:36:00', NULL),
  (33, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/departments/add-save', 'Add New Data Cargo at Departments', '', 1, '2021-08-01 03:46:03', NULL),
  (34, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/departments/add-save', 'Add New Data COC at Departments', '', 1, '2021-08-01 03:46:19', NULL),
  (35, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/departments/add-save', 'Add New Data Admin at Departments', '', 1, '2021-08-01 03:46:28', NULL),
  (36, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/departments/add-save', 'Add New Data Certification at Departments', '', 1, '2021-08-01 03:46:39', NULL),
  (37, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/departments/add-save', 'Add New Data Oil & Gas at Departments', '', 1, '2021-08-01 03:46:46', NULL),
  (38, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/users13/add-save', 'Add New Data test at Employees', '', 1, '2021-08-01 04:29:50', NULL),
  (39, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/menu_management/edit-save/5', 'Update data Office Management at Menu Management', '<table class=\"table table-striped\"><thead><tr><th>Key</th><th>Old Value</th><th>New Value</th></thead><tbody><tr><td>color</td><td></td><td>normal</td></tr><tr><td>icon</td><td>fa fa-glass</td><td>fa fa-home</td></tr><tr><td>sorting</td><td>4</td><td></td></tr></tbody></table>', 1, '2021-08-01 05:48:22', NULL),
  (40, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://localhost:8000/admin/login', 'ialsanhouri@tuvaustria.sa login with IP Address 127.0.0.1', '', 1, '2021-08-01 06:18:03', NULL),
  (41, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', 'http://127.0.0.1:8000/admin/login', 'ialsanhouri@tuvaustria.sa login with IP Address 127.0.0.1', '', 1, '2021-08-01 06:26:40', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_menus`
  --
  
  CREATE TABLE `cms_menus` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'url',
    `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_dashboard` tinyint(1) NOT NULL DEFAULT '0',
    `id_cms_privileges` int(11) DEFAULT NULL,
    `sorting` int(11) 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 `cms_menus`
  --
  
  INSERT INTO `cms_menus` (`id`, `name`, `type`, `path`, `color`, `icon`, `parent_id`, `is_active`, `is_dashboard`, `id_cms_privileges`, `sorting`, `created_at`, `updated_at`) VALUES
  (1, 'Clients Management', 'Module', 'clients', 'normal', 'fa fa-users', 0, 1, 0, 1, 2, '2021-07-27 11:58:05', '2021-07-28 05:48:04'),
  (2, 'Employees', 'Route', 'AdminUsers13ControllerGetIndex', 'normal', 'fa fa-users', 0, 1, 0, 1, 4, '2021-07-28 05:14:33', '2021-07-28 05:48:14'),
  (3, 'Attendance', 'Route', 'AdminAttendancesControllerGetIndex', 'normal', 'fa fa-map-marker', 0, 0, 0, 1, 3, '2021-07-28 05:16:59', '2021-07-28 05:23:56'),
  (4, 'Main Dashboard', 'Statistic', 'statistic_builder/show/main-statistic', 'normal', 'fa fa-dashboard', 0, 1, 1, 1, 1, '2021-07-28 06:21:51', NULL),
  (5, 'Office Management', 'Route', 'AdminOfficesControllerGetIndex', 'normal', 'fa fa-home', 0, 1, 0, 1, 3, '2021-08-01 03:34:48', '2021-08-01 05:48:22');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_menus_privileges`
  --
  
  CREATE TABLE `cms_menus_privileges` (
    `id` int(10) UNSIGNED NOT NULL,
    `id_cms_menus` int(11) DEFAULT NULL,
    `id_cms_privileges` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `cms_menus_privileges`
  --
  
  INSERT INTO `cms_menus_privileges` (`id`, `id_cms_menus`, `id_cms_privileges`) VALUES
  (5, 3, 1),
  (6, 1, 2),
  (7, 1, 1),
  (8, 2, 2),
  (9, 2, 1),
  (10, 4, 2),
  (11, 4, 1),
  (13, 5, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_moduls`
  --
  
  CREATE TABLE `cms_moduls` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `controller` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_protected` tinyint(1) NOT NULL DEFAULT '0',
    `is_active` tinyint(1) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `cms_moduls`
  --
  
  INSERT INTO `cms_moduls` (`id`, `name`, `icon`, `path`, `table_name`, `controller`, `is_protected`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (1, 'Notifications', 'fa fa-cog', 'notifications', 'cms_notifications', 'NotificationsController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (2, 'Privileges', 'fa fa-cog', 'privileges', 'cms_privileges', 'PrivilegesController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (3, 'Privileges Roles', 'fa fa-cog', 'privileges_roles', 'cms_privileges_roles', 'PrivilegesRolesController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (4, 'Users Management', 'fa fa-users', 'users', 'cms_users', 'AdminCmsUsersController', 0, 1, '2021-07-27 11:36:03', NULL, NULL),
  (5, 'Settings', 'fa fa-cog', 'settings', 'cms_settings', 'SettingsController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (6, 'Module Generator', 'fa fa-database', 'module_generator', 'cms_moduls', 'ModulsController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (7, 'Menu Management', 'fa fa-bars', 'menu_management', 'cms_menus', 'MenusController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (8, 'Email Templates', 'fa fa-envelope-o', 'email_templates', 'cms_email_templates', 'EmailTemplatesController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (9, 'Statistic Builder', 'fa fa-dashboard', 'statistic_builder', 'cms_statistics', 'StatisticBuilderController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (10, 'API Generator', 'fa fa-cloud-download', 'api_generator', '', 'ApiCustomController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (11, 'Log User Access', 'fa fa-flag-o', 'logs', 'cms_logs', 'LogsController', 1, 1, '2021-07-27 11:36:03', NULL, NULL),
  (12, 'Clients', 'fa fa-users', 'clients', 'clients', 'AdminClientsController', 0, 0, '2021-07-27 11:58:05', NULL, NULL),
  (13, 'Employees', 'fa fa-users', 'users13', 'users', 'AdminUsers13Controller', 0, 0, '2021-07-28 05:14:33', NULL, NULL),
  (14, 'Attendance', 'fa fa-map-marker', 'attendances', 'attendances', 'AdminAttendancesController', 0, 0, '2021-07-28 05:16:59', NULL, NULL),
  (15, 'Office Management', 'fa fa-tv', 'offices', 'offices', 'AdminOfficesController', 0, 0, '2021-08-01 03:34:48', NULL, NULL),
  (16, 'Departments', 'fa fa-key', 'departments', 'departments', 'AdminDepartmentsController', 0, 0, '2021-08-01 03:44:55', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_notifications`
  --
  
  CREATE TABLE `cms_notifications` (
    `id` int(10) UNSIGNED NOT NULL,
    `id_cms_users` int(11) DEFAULT NULL,
    `content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_read` tinyint(1) 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 `cms_privileges`
  --
  
  CREATE TABLE `cms_privileges` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_superadmin` tinyint(1) DEFAULT NULL,
    `theme_color` varchar(255) 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 `cms_privileges`
  --
  
  INSERT INTO `cms_privileges` (`id`, `name`, `is_superadmin`, `theme_color`, `created_at`, `updated_at`) VALUES
  (1, 'Super Administrator', 1, 'skin-blue', '2021-07-27 11:36:03', NULL),
  (2, 'HR Manager', 0, 'skin-blue', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_privileges_roles`
  --
  
  CREATE TABLE `cms_privileges_roles` (
    `id` int(10) UNSIGNED NOT NULL,
    `is_visible` tinyint(1) DEFAULT NULL,
    `is_create` tinyint(1) DEFAULT NULL,
    `is_read` tinyint(1) DEFAULT NULL,
    `is_edit` tinyint(1) DEFAULT NULL,
    `is_delete` tinyint(1) DEFAULT NULL,
    `id_cms_privileges` int(11) DEFAULT NULL,
    `id_cms_moduls` int(11) 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 `cms_privileges_roles`
  --
  
  INSERT INTO `cms_privileges_roles` (`id`, `is_visible`, `is_create`, `is_read`, `is_edit`, `is_delete`, `id_cms_privileges`, `id_cms_moduls`, `created_at`, `updated_at`) VALUES
  (13, 1, 1, 1, 1, 1, 1, 12, NULL, NULL),
  (14, 1, 1, 1, 1, 1, 1, 4, NULL, NULL),
  (15, 1, 1, 1, 1, 1, 1, 13, NULL, NULL),
  (16, 1, 1, 1, 1, 1, 1, 14, NULL, NULL),
  (17, 1, 1, 1, 1, 1, 2, 14, NULL, NULL),
  (18, 1, 1, 1, 1, 1, 2, 12, NULL, NULL),
  (19, 1, 1, 1, 1, 1, 2, 13, NULL, NULL),
  (20, 1, 1, 1, 1, 1, 1, 15, NULL, NULL),
  (21, 1, 1, 1, 1, 1, 1, 16, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_settings`
  --
  
  CREATE TABLE `cms_settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` text COLLATE utf8mb4_unicode_ci,
    `content_input_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `dataenum` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `helper` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `group_setting` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `cms_settings`
  --
  
  INSERT INTO `cms_settings` (`id`, `name`, `content`, `content_input_type`, `dataenum`, `helper`, `created_at`, `updated_at`, `group_setting`, `label`) VALUES
  (1, 'login_background_color', NULL, 'text', NULL, 'Input hexacode', '2021-07-27 11:36:03', NULL, 'Login Register Style', 'Login Background Color'),
  (2, 'login_font_color', NULL, 'text', NULL, 'Input hexacode', '2021-07-27 11:36:03', NULL, 'Login Register Style', 'Login Font Color'),
  (3, 'login_background_image', NULL, 'upload_image', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Login Register Style', 'Login Background Image'),
  (4, 'email_sender', 'support@crudbooster.com', 'text', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Email Setting', 'Email Sender'),
  (5, 'smtp_driver', 'mail', 'select', 'smtp,mail,sendmail', NULL, '2021-07-27 11:36:03', NULL, 'Email Setting', 'Mail Driver'),
  (6, 'smtp_host', '', 'text', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Email Setting', 'SMTP Host'),
  (7, 'smtp_port', '25', 'text', NULL, 'default 25', '2021-07-27 11:36:03', NULL, 'Email Setting', 'SMTP Port'),
  (8, 'smtp_username', '', 'text', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Email Setting', 'SMTP Username'),
  (9, 'smtp_password', '', 'text', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Email Setting', 'SMTP Password'),
  (10, 'appname', 'TUV Austria GIS Microservice', 'text', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Application Setting', 'Application Name'),
  (11, 'default_paper_size', 'Legal', 'text', NULL, 'Paper size, ex : A4, Legal, etc', '2021-07-27 11:36:03', NULL, 'Application Setting', 'Default Paper Print Size'),
  (12, 'logo', 'uploads/2021-07/8f86b89194147dbcb25b5878042dffc4.png', 'upload_image', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Application Setting', 'Logo'),
  (13, 'favicon', 'uploads/2021-07/c7cf2ebe3567a702de7c716815f44822.png', 'upload_image', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Application Setting', 'Favicon'),
  (14, 'api_debug_mode', 'true', 'select', 'true,false', NULL, '2021-07-27 11:36:03', NULL, 'Application Setting', 'API Debug Mode'),
  (15, 'google_api_key', 'AIzaSyC-HNN9PRpqznkMLp5MWqGpKVEZxyvh2A4', 'text', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Application Setting', 'Google API Key'),
  (16, 'google_fcm_key', NULL, 'text', NULL, NULL, '2021-07-27 11:36:03', NULL, 'Application Setting', 'Google FCM Key');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_statistics`
  --
  
  CREATE TABLE `cms_statistics` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slug` varchar(255) 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 `cms_statistics`
  --
  
  INSERT INTO `cms_statistics` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
  (2, 'Main Statistic', 'main-statistic', '2021-07-28 06:06:03', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_statistic_components`
  --
  
  CREATE TABLE `cms_statistic_components` (
    `id` int(10) UNSIGNED NOT NULL,
    `id_cms_statistics` int(11) DEFAULT NULL,
    `componentID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `component_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `area_name` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `sorting` int(11) DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `config` longtext COLLATE utf8mb4_unicode_ci,
    `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 `cms_statistic_components`
  --
  
  INSERT INTO `cms_statistic_components` (`id`, `id_cms_statistics`, `componentID`, `component_name`, `area_name`, `sorting`, `name`, `config`, `created_at`, `updated_at`) VALUES
  (1, 1, 'ce084fccd153a0abcf2ac2785b61a8ce', 'smallbox', NULL, 0, 'Untitled', NULL, '2021-07-28 06:00:17', NULL),
  (2, 1, '7f2ea25293024de9eea5edd9ae7a66f3', 'smallbox', 'area1', 0, NULL, '{\"name\":\"Clients Locations\",\"icon\":\"ion-person-stalker\",\"color\":\"bg-green\",\"link\":\"#\",\"sql\":\"SELECT SUM(id)\\r\\nFROM clients;\"}', '2021-07-28 06:00:21', NULL),
  (3, 2, '40bcb4f809b6b57a7afc6fae38526d55', 'smallbox', 'area1', 0, NULL, '{\"name\":\"Clients Locations\",\"icon\":\"ion-person-stalker\",\"color\":\"bg-green\",\"link\":\"#\",\"sql\":\"SELECT COUNT(id)\\r\\nFROM clients;\"}', '2021-07-28 06:06:19', NULL),
  (4, 2, 'aa16db5ba34c607953b73e0d830e2fad', 'smallbox', 'area2', 0, NULL, '{\"name\":\"Inspectors and Sales Members\",\"icon\":\"ion-briefcase\",\"color\":\"bg-red\",\"link\":\"#\",\"sql\":\"SELECT COUNT(id)\\r\\nFROM users;\"}', '2021-07-28 06:07:32', NULL),
  (5, 2, 'a48ad01a7387a884368a056f903ade73', 'smallbox', 'area3', 0, NULL, '{\"name\":\"API Map Requests\",\"icon\":\"ion-location\",\"color\":\"bg-aqua\",\"link\":\"#\",\"sql\":\"SELECT COUNT(id)\\r\\nFROM attendances;\"}', '2021-07-28 06:09:40', NULL),
  (6, 2, '211ed0a90f80ba2238c638d1b0d7f6fe', 'smallbox', 'area4', 0, NULL, '{\"name\":\"Admins\",\"icon\":\"ion-thumbsup\",\"color\":\"bg-yellow\",\"link\":\"#\",\"sql\":\"SELECT count(created_at)\\r\\nFROM cms_users;\"}', '2021-07-28 06:12:51', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cms_users`
  --
  
  CREATE TABLE `cms_users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `id_cms_privileges` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `cms_users`
  --
  
  INSERT INTO `cms_users` (`id`, `name`, `photo`, `email`, `password`, `id_cms_privileges`, `created_at`, `updated_at`, `status`) VALUES
  (1, 'Super Admin', 'uploads/1/2021-07/logo_tuv_1.png', 'ialsanhouri@tuvaustria.sa', '$2y$10$uKXucyH.tiIvmKFo0HImOe8GqIEAVStZBEXdEliOHLBPBgM3wtNBi', 1, '2021-07-27 11:36:03', '2021-07-28 06:30:22', 'Active'),
  (2, 'Saleh Alsanosi', 'uploads/1/2021-07/logo_tuv.png', 'salsanosi@tuvaustria.sa', '$2y$10$/6vfxYQMkKcafTylQm7Edu9wNmVdxwfNR6T.R6/uoywrXN1SBMQDm', 2, '2021-07-28 06:29:50', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `departments`
  --
  
  CREATE TABLE `departments` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `offices_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `departments`
  --
  
  INSERT INTO `departments` (`id`, `name`, `offices_id`, `created_at`, `updated_at`) VALUES
  (1, 'Cargo', 2, '2021-08-01 03:46:03', NULL),
  (2, 'COC', 2, '2021-08-01 03:46:19', NULL),
  (3, 'Admin', 2, '2021-08-01 03:46:28', NULL),
  (4, 'Certification', 2, '2021-08-01 03:46:39', NULL),
  (5, 'Oil & Gas', 2, '2021-08-01 03:46:46', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `devices`
  --
  
  CREATE TABLE `devices` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `device_uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `device_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
    `device_hijacked_at` timestamp NULL DEFAULT NULL,
    `data` json DEFAULT NULL,
    `deleted_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 `devices`
  --
  
  INSERT INTO `devices` (`id`, `device_uuid`, `device_type`, `ip`, `device_hijacked_at`, `data`, `deleted_at`, `created_at`, `updated_at`) VALUES
  (1, 'b2ca194a-651c-407e-8a71-2357b0f3f1fc:s03Txa4Yb9U8JQXh', 'Windows|Chrome', '127.0.0.1', NULL, '{\"engine\": \"Blink\", \"is_bot\": false, \"version\": \"92.0.4515\", \"user_agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36\", \"device_model\": \"\", \"ip_addresses\": [\"127.0.0.1\"], \"platform_name\": \"Windows 10\", \"platform_family\": \"Windows\", \"platform_version\": \"10\"}', NULL, '2021-07-29 17:17:33', '2021-07-29 17:17:33'),
  (2, 'b60d028c-ebbc-466d-9a5f-97fb15068859:VvDmp5pV9M3nQdZq', 'Windows|Chrome', '127.0.0.1', NULL, '{\"engine\": \"Blink\", \"is_bot\": false, \"version\": \"92.0.4515\", \"user_agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36\", \"device_model\": \"\", \"ip_addresses\": [\"127.0.0.1\"], \"platform_name\": \"Windows 10\", \"platform_family\": \"Windows\", \"platform_version\": \"10\"}', NULL, '2021-08-01 06:12:41', '2021-08-01 06:24:27'),
  (3, 'ea4c79a9-2f90-45e9-bbbd-6e1cb449d3cf:1tOSauS74lzibOqK', 'Windows|Chrome', '127.0.0.1', NULL, '{\"engine\": \"Blink\", \"is_bot\": false, \"version\": \"92.0.4515\", \"user_agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36\", \"device_model\": \"\", \"ip_addresses\": [\"127.0.0.1\"], \"platform_name\": \"Windows 10\", \"platform_family\": \"Windows\", \"platform_version\": \"10\"}', NULL, '2021-08-01 06:16:59', '2021-08-01 06:16:59');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `device_user`
  --
  
  CREATE TABLE `device_user` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `user_id` bigint(20) UNSIGNED NOT NULL,
    `device_id` bigint(20) UNSIGNED NOT NULL,
    `verified_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 `device_user`
  --
  
  INSERT INTO `device_user` (`id`, `user_id`, `device_id`, `verified_at`, `created_at`, `updated_at`) VALUES
  (1, 2, 1, NULL, '2021-07-29 17:17:33', '2021-07-29 17:17:33'),
  (2, 2, 2, NULL, '2021-08-01 06:12:41', '2021-08-01 06:12:41'),
  (3, 2, 3, NULL, '2021-08-01 06:16:59', '2021-08-01 06:16:59');
  
  -- --------------------------------------------------------
  
  --
  -- 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, '2016_08_07_145904_add_table_cms_apicustom', 1),
  (4, '2016_08_07_150834_add_table_cms_dashboard', 1),
  (5, '2016_08_07_151210_add_table_cms_logs', 1),
  (6, '2016_08_07_151211_add_details_cms_logs', 1),
  (7, '2016_08_07_152014_add_table_cms_privileges', 1),
  (8, '2016_08_07_152214_add_table_cms_privileges_roles', 1),
  (9, '2016_08_07_152320_add_table_cms_settings', 1),
  (10, '2016_08_07_152421_add_table_cms_users', 1),
  (11, '2016_08_07_154624_add_table_cms_menus_privileges', 1),
  (12, '2016_08_07_154624_add_table_cms_moduls', 1),
  (13, '2016_08_17_225409_add_status_cms_users', 1),
  (14, '2016_08_20_125418_add_table_cms_notifications', 1),
  (15, '2016_09_04_033706_add_table_cms_email_queues', 1),
  (16, '2016_09_16_035347_add_group_setting', 1),
  (17, '2016_09_16_045425_add_label_setting', 1),
  (18, '2016_09_17_104728_create_nullable_cms_apicustom', 1),
  (19, '2016_10_01_141740_add_method_type_apicustom', 1),
  (20, '2016_10_01_141846_add_parameters_apicustom', 1),
  (21, '2016_10_01_141934_add_responses_apicustom', 1),
  (22, '2016_10_01_144826_add_table_apikey', 1),
  (23, '2016_11_14_141657_create_cms_menus', 1),
  (24, '2016_11_15_132350_create_cms_email_templates', 1),
  (25, '2016_11_15_190410_create_cms_statistics', 1),
  (26, '2016_11_17_102740_create_cms_statistic_components', 1),
  (27, '2017_06_06_164501_add_deleted_at_cms_moduls', 1),
  (28, '2019_08_19_000000_create_failed_jobs_table', 1),
  (29, '2021_07_27_145459_create_clients_table', 2),
  (30, '2021_07_27_151238_add_map_link_to_clients', 3),
  (31, '2021_07_28_064856_add_id_to_users', 4),
  (32, '2021_07_28_071152_create_attendances_table', 5),
  (33, '2021_07_28_080615_add_address_to_attendance', 6),
  (34, '2020_10_13_140209_create_devices_table', 7),
  (35, '2020_10_13_150113_create_device_user_table', 7),
  (36, '2021_07_28_081101_add_address_to_empid', 7),
  (37, '2021_08_01_063315_create_offices_table', 8),
  (38, '2021_08_01_063832_create_departments_table', 9),
  (39, '2021_08_01_071304_add_office_department_to_users', 10),
  (40, '2021_08_01_085219_add_device_to_attendance', 11);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `offices`
  --
  
  CREATE TABLE `offices` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `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 `offices`
  --
  
  INSERT INTO `offices` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, 'Riyadh Office (Head Office)', '2021-08-01 03:35:44', NULL),
  (2, 'Egypt Office', '2021-08-01 03:35:52', NULL),
  (3, 'UAE Office', '2021-08-01 03:36:00', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- 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 `users`
  --
  
  CREATE TABLE `users` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `empid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `offices_id` int(10) UNSIGNED NOT NULL,
    `departments_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `empid`, `offices_id`, `departments_id`) VALUES
  (1, 'Ibrahim Elsanhouri', 'ibrahimelsanhouri@gmail.com', NULL, '$2y$10$Z12QFMJtfd7mjE698obD/eCHxoaxxG/ihPLhMkRJoNWOWtyKFBOde', NULL, '2021-07-27 11:43:14', '2021-07-28 05:16:26', '10054', 0, 0),
  (2, 'Ibrahim', 'ialsanhouri@tuvaustria.sa', NULL, '$2y$10$daXDbg4Nswpka/Av/jpL.uWJ5BVpH7cU7OAWKUcZ0JhuJ76XMbPo6', '8qmq54GzioeINXvHIKegOk4V6r4p3O08cViESg0kP7BmfleZdWouXP1sVTDZ', '2021-07-28 04:57:51', '2021-07-28 05:15:58', '10057', 0, 0),
  (3, 'test', 'test@test.com', NULL, '$2y$10$IuYcphGLKD43KZBnpI5rWuJGN98CIeyJd1EHjjjyDw9STGNXekQ.O', NULL, '2021-08-01 04:29:50', NULL, '10000', 2, 3);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `attendances`
  --
  ALTER TABLE `attendances`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `clients`
  --
  ALTER TABLE `clients`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_apicustom`
  --
  ALTER TABLE `cms_apicustom`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_apikey`
  --
  ALTER TABLE `cms_apikey`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_dashboard`
  --
  ALTER TABLE `cms_dashboard`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_email_queues`
  --
  ALTER TABLE `cms_email_queues`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_email_templates`
  --
  ALTER TABLE `cms_email_templates`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_logs`
  --
  ALTER TABLE `cms_logs`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_menus`
  --
  ALTER TABLE `cms_menus`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_menus_privileges`
  --
  ALTER TABLE `cms_menus_privileges`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_moduls`
  --
  ALTER TABLE `cms_moduls`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_notifications`
  --
  ALTER TABLE `cms_notifications`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_privileges`
  --
  ALTER TABLE `cms_privileges`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_privileges_roles`
  --
  ALTER TABLE `cms_privileges_roles`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_settings`
  --
  ALTER TABLE `cms_settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_statistics`
  --
  ALTER TABLE `cms_statistics`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_statistic_components`
  --
  ALTER TABLE `cms_statistic_components`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cms_users`
  --
  ALTER TABLE `cms_users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `departments`
  --
  ALTER TABLE `departments`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `devices`
  --
  ALTER TABLE `devices`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `devices_device_uuid_unique` (`device_uuid`),
    ADD KEY `devices_device_type_index` (`device_type`),
    ADD KEY `devices_ip_index` (`ip`);
  
  --
  -- Indexes for table `device_user`
  --
  ALTER TABLE `device_user`
    ADD PRIMARY KEY (`id`),
    ADD KEY `device_user_user_id_device_id_index` (`user_id`,`device_id`),
    ADD KEY `device_user_user_id_index` (`user_id`),
    ADD KEY `device_user_device_id_index` (`device_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 `offices`
  --
  ALTER TABLE `offices`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`),
    ADD UNIQUE KEY `users_empid_unique` (`empid`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `attendances`
  --
  ALTER TABLE `attendances`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT for table `clients`
  --
  ALTER TABLE `clients`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `cms_apicustom`
  --
  ALTER TABLE `cms_apicustom`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `cms_apikey`
  --
  ALTER TABLE `cms_apikey`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `cms_dashboard`
  --
  ALTER TABLE `cms_dashboard`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `cms_email_queues`
  --
  ALTER TABLE `cms_email_queues`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `cms_email_templates`
  --
  ALTER TABLE `cms_email_templates`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `cms_logs`
  --
  ALTER TABLE `cms_logs`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
  
  --
  -- AUTO_INCREMENT for table `cms_menus`
  --
  ALTER TABLE `cms_menus`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `cms_menus_privileges`
  --
  ALTER TABLE `cms_menus_privileges`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT for table `cms_moduls`
  --
  ALTER TABLE `cms_moduls`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  
  --
  -- AUTO_INCREMENT for table `cms_notifications`
  --
  ALTER TABLE `cms_notifications`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `cms_privileges`
  --
  ALTER TABLE `cms_privileges`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `cms_privileges_roles`
  --
  ALTER TABLE `cms_privileges_roles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  
  --
  -- AUTO_INCREMENT for table `cms_settings`
  --
  ALTER TABLE `cms_settings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  
  --
  -- AUTO_INCREMENT for table `cms_statistics`
  --
  ALTER TABLE `cms_statistics`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `cms_statistic_components`
  --
  ALTER TABLE `cms_statistic_components`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `cms_users`
  --
  ALTER TABLE `cms_users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `departments`
  --
  ALTER TABLE `departments`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `devices`
  --
  ALTER TABLE `devices`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `device_user`
  --
  ALTER TABLE `device_user`
    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=41;
  
  --
  -- AUTO_INCREMENT for table `offices`
  --
  ALTER TABLE `offices`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  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 */;
  