-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `visitorpass`
--

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

--
-- Table structure for table `activation_code`
--

CREATE TABLE `activation_code` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mac_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code_mac` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `checked_before` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activation_code`
--

INSERT INTO `activation_code` (`id`, `code`, `mac_address`, `code_mac`, `created_at`, `updated_at`, `checked_before`) VALUES
(87, '$2y$10$3yx8GYSFEFcywIR3XIOlQOc7EGnw5ENsihHCa2jAmpco94eP71.oe', '$2y$10$RFyR6Qc4OSWNKcc55M1OVu7xiYLiSDMiciDPoH3iY14riURe5Iq4C', '$2y$10$Nd7HMAyk4AkpKFxXHQs5/OMvTB8r.QQN.7fY1pOTnS8Jnsmsgjpdq', '2023-01-11 14:54:11', '2023-01-11 14:55:15', 1);

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

--
-- Table structure for table `attendances`
--

CREATE TABLE `attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `checkin_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkout_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `backend_menus`
--

CREATE TABLE `backend_menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `priority` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `backend_menus`
--

INSERT INTO `backend_menus` (`id`, `name`, `link`, `icon`, `status`, `parent_id`, `priority`, `created_at`, `updated_at`) VALUES
(1, 'Dashboard', 'dashboard', 'fas fa-laptop', 1, 0, 9000, NULL, NULL),
(2, 'Profile', 'profile', 'far fa-user', 1, 0, 8900, NULL, NULL),
(3, 'Departments', 'departments', 'fas fa-building', 1, 0, 8800, NULL, NULL),
(4, 'Positions', 'designations', 'fas fa-layer-group', 1, 0, 8700, NULL, NULL),
(5, 'Employees', 'employees', 'fas fa-user-secret', 1, 0, 8600, NULL, NULL),
(6, 'Visitors', 'visitors', 'fas fa-walking', 1, 0, 8600, NULL, NULL),
(7, 'Pre-registers', 'pre-registers', 'fas fa-user-friends', 1, 0, 8600, NULL, NULL),
(8, 'Administrators', 'adminusers', 'fas fa-users', 1, 0, 8500, NULL, NULL),
(9, 'Role', 'role', 'fa fa-star', 1, 0, 2400, NULL, NULL),
(10, 'Settings', 'setting', 'fas fa-cogs', 1, 0, 2400, NULL, NULL),
(11, 'Types', 'types', 'fas fa-layer-group', 1, 0, 8999, NULL, NULL);

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reg_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `purpose` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `is_pre_register` tinyint(1) NOT NULL,
  `is_group_enabled` tinyint(3) UNSIGNED NOT NULL,
  `invitation_people_count` int(11) NOT NULL DEFAULT 0,
  `accept_invitation_count` int(11) NOT NULL DEFAULT 0,
  `attendee_count` int(11) NOT NULL DEFAULT 0,
  `start_at` datetime NOT NULL,
  `end_at` datetime NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Operation', 5, NULL, NULL),
(2, 'IT', 5, NULL, NULL),
(3, 'Marketing', 5, NULL, NULL),
(4, 'Service', 10, NULL, NULL),
(10, 'RK', 5, NULL, NULL),
(14, 'QC', 5, NULL, NULL);

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

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `designations`
--

INSERT INTO `designations` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'HR Director', 5, NULL, NULL),
(2, 'Chief Human Resource Officer', 5, NULL, NULL),
(3, 'General HR Manager', 5, NULL, NULL),
(4, 'Production Manager', 5, NULL, NULL),
(5, 'Delivery', 10, NULL, NULL),
(7, 'QC', 5, NULL, NULL),
(8, 'IT', 5, NULL, NULL);

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nickname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` tinyint(3) UNSIGNED NOT NULL,
  `official_identification_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_joining` date NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED NOT NULL,
  `designation_id` bigint(20) UNSIGNED NOT NULL,
  `about` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `creator_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `creator_id` bigint(20) UNSIGNED NOT NULL,
  `editor_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `editor_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `first_name`, `last_name`, `phone`, `nickname`, `display_name`, `gender`, `official_identification_number`, `date_of_joining`, `status`, `user_id`, `department_id`, `designation_id`, `about`, `creator_type`, `creator_id`, `editor_type`, `editor_id`, `created_at`, `updated_at`) VALUES
(6, 'Rehab', 'kassim', '23215996', NULL, NULL, 10, NULL, '2022-08-17', 5, 8, 2, 4, NULL, 'App\\User', 1, 'App\\User', 1, '2022-08-25 22:01:37', '2022-08-25 22:01:37'),
(7, 'demo', 'account', '123456789', NULL, NULL, 5, NULL, '2022-09-01', 5, 9, 1, 8, NULL, 'App\\User', 1, 'App\\User', 1, '2022-09-01 22:02:54', '2022-09-01 22:03:07'),
(3, 'Mohamed', 'Sabry', '23215996', NULL, NULL, 10, NULL, '2022-08-17', 5, 1, 2, 4, NULL, 'App\\User', 1, 'App\\User', 1, '2022-08-25 22:01:37', '2022-08-25 22:01:37');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `invitations`
--

CREATE TABLE `invitations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `booking_id` bigint(20) UNSIGNED NOT NULL,
  `visitor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `checkin_at` datetime DEFAULT NULL,
  `checkout_at` datetime DEFAULT NULL,
  `iuid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activation_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `collection_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `responsive_images` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_column` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=MyISAM 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, '2018_10_25_043002_create_pre_registers_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2020_04_06_130203_create_designations_table', 1),
(6, '2020_04_06_130245_create_departments_table', 1),
(7, '2020_04_06_130356_create_employees_table', 1),
(8, '2020_04_06_130500_create_attendances_table', 1),
(9, '2020_04_06_130652_create_visitors_table', 1),
(10, '2020_04_06_130653_create_bookings_table', 1),
(11, '2020_04_06_130653_create_visiting_details_table', 1),
(12, '2020_04_06_130654_create_invitations_table', 1),
(13, '2020_04_16_063722_create_settings_table', 1),
(14, '2020_04_16_064701_create_media_table', 1),
(15, '2020_04_16_113855_create_jobs_table', 1),
(16, '2020_05_07_111209_create_notifications_table', 1),
(17, '2020_09_09_043116_create_permission_tables', 1),
(18, '2020_09_10_080029_create_backend_menus_table', 1),
(19, '2020_09_28_181710_alter_settings_table', 1),
(20, '2022_08_11_160848_add_qrcode_to_visitors', 2),
(21, '2022_08_11_164734_add_qrcode_to_visiting_details', 3),
(22, '2022_08_14_135236_remove_qrcode_to_visitors', 4),
(23, '2022_08_14_161426_add_type_to_visitors', 5),
(24, '2022_08_14_164242_add_expirydate_to_visiting_details', 5),
(25, '2022_08_14_164726_remove_expirydate_to_visitors_details', 6),
(26, '2022_08_14_164932_add_expirydate2_to_visiting_details', 7),
(27, '2022_08_14_190633_create_types_table', 8),
(28, '2022_08_15_200143_add_photo_to_visitors', 9),
(29, '2023_01_11_105039_create_activation_code_table', 10),
(30, '2023_01_11_152130_add_column_toactivation_code', 11);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` (`permission_id`, `model_type`, `model_id`) VALUES
(1, 'App\\User', 1),
(2, 'App\\User', 1),
(3, 'App\\User', 1),
(4, 'App\\User', 1),
(5, 'App\\User', 1),
(6, 'App\\User', 1),
(7, 'App\\User', 1),
(8, 'App\\User', 1),
(9, 'App\\User', 1),
(10, 'App\\User', 1),
(11, 'App\\User', 1),
(12, 'App\\User', 1),
(13, 'App\\User', 1),
(14, 'App\\User', 1),
(15, 'App\\User', 1),
(16, 'App\\User', 1),
(17, 'App\\User', 1),
(18, 'App\\User', 1),
(19, 'App\\User', 1),
(20, 'App\\User', 1),
(21, 'App\\User', 1),
(22, 'App\\User', 1),
(23, 'App\\User', 1),
(24, 'App\\User', 1),
(25, 'App\\User', 1),
(26, 'App\\User', 1),
(27, 'App\\User', 1),
(28, 'App\\User', 1),
(29, 'App\\User', 1),
(30, 'App\\User', 1),
(31, 'App\\User', 1),
(32, 'App\\User', 1),
(33, 'App\\User', 1),
(34, 'App\\User', 1),
(35, 'App\\User', 1),
(36, 'App\\User', 1),
(37, 'App\\User', 1),
(38, 'App\\User', 1);

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\User', 1),
(2, 'App\\User', 3),
(2, 'App\\User', 4),
(2, 'App\\User', 5),
(2, 'App\\User', 6),
(2, 'App\\User', 7),
(2, 'App\\User', 8),
(2, 'App\\User', 9),
(2, 'App\\User', 10),
(2, 'App\\User', 11),
(3, 'App\\User', 2);

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

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

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

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

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

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

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'dashboard', 'web', NULL, NULL),
(2, 'profile', 'web', NULL, NULL),
(3, 'designations', 'web', NULL, NULL),
(4, 'designations_create', 'web', NULL, NULL),
(5, 'designations_edit', 'web', NULL, NULL),
(6, 'designations_delete', 'web', NULL, NULL),
(7, 'designations_show', 'web', NULL, NULL),
(8, 'departments', 'web', NULL, NULL),
(9, 'departments_create', 'web', NULL, NULL),
(10, 'departments_edit', 'web', NULL, NULL),
(11, 'departments_delete', 'web', NULL, NULL),
(12, 'departments_show', 'web', NULL, NULL),
(13, 'employees', 'web', NULL, NULL),
(14, 'employees_create', 'web', NULL, NULL),
(15, 'employees_edit', 'web', NULL, NULL),
(16, 'employees_delete', 'web', NULL, NULL),
(17, 'employees_show', 'web', NULL, NULL),
(18, 'visitors', 'web', NULL, NULL),
(19, 'visitors_create', 'web', NULL, NULL),
(20, 'visitors_edit', 'web', NULL, NULL),
(21, 'visitors_delete', 'web', NULL, NULL),
(22, 'visitors_show', 'web', NULL, NULL),
(23, 'pre-registers', 'web', NULL, NULL),
(24, 'pre-registers_create', 'web', NULL, NULL),
(25, 'pre-registers_edit', 'web', NULL, NULL),
(26, 'pre-registers_delete', 'web', NULL, NULL),
(27, 'pre-registers_show', 'web', NULL, NULL),
(28, 'adminusers', 'web', NULL, NULL),
(29, 'adminusers_create', 'web', NULL, NULL),
(30, 'adminusers_edit', 'web', NULL, NULL),
(31, 'adminusers_delete', 'web', NULL, NULL),
(32, 'adminusers_show', 'web', NULL, NULL),
(33, 'role', 'web', NULL, NULL),
(34, 'role_create', 'web', NULL, NULL),
(35, 'role_edit', 'web', NULL, NULL),
(36, 'role_delete', 'web', NULL, NULL),
(37, 'role_show', 'web', NULL, NULL),
(38, 'setting', 'web', NULL, NULL),
(39, 'types', 'web', NULL, NULL),
(40, 'types_create', 'web', NULL, NULL),
(41, 'types_edit', 'web', NULL, NULL),
(42, 'types_delete', 'web', NULL, NULL),
(43, 'types_show', 'web', NULL, NULL);

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

--
-- Table structure for table `pre_registers`
--

CREATE TABLE `pre_registers` (
  `id` int(10) UNSIGNED NOT NULL,
  `expected_date` date NOT NULL,
  `expected_time` time NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `visitor_id` int(10) UNSIGNED NOT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `creator_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `creator_id` bigint(20) UNSIGNED NOT NULL,
  `editor_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `editor_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `exit_date` date DEFAULT NULL,
  `exit_time` time DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'web', '2021-02-04 06:34:58', '2021-02-04 06:34:58'),
(2, 'Employee', 'web', '2021-02-04 06:34:58', '2021-02-04 06:34:58'),
(3, 'Reception', 'web', '2021-02-04 06:34:58', '2021-02-04 06:34:58'),
(4, 'Delivery1', 'web', '2022-08-28 17:57:54', '2022-08-28 17:58:38'),
(6, 'HR', 'web', '2022-08-30 19:13:58', '2022-08-30 19:13:58'),
(7, 'TEST', 'web', '2023-01-10 14:28:56', '2023-01-10 14:28:56');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(2, 1),
(2, 2),
(2, 3),
(3, 1),
(3, 2),
(4, 1),
(4, 2),
(5, 1),
(5, 2),
(6, 1),
(6, 2),
(7, 1),
(7, 2),
(8, 1),
(8, 2),
(8, 4),
(9, 1),
(9, 2),
(9, 4),
(10, 1),
(10, 2),
(10, 4),
(11, 1),
(11, 2),
(11, 4),
(12, 1),
(12, 2),
(12, 4),
(13, 1),
(13, 2),
(13, 3),
(14, 1),
(14, 2),
(15, 1),
(15, 2),
(16, 1),
(16, 2),
(17, 1),
(17, 2),
(17, 3),
(18, 1),
(18, 2),
(18, 3),
(19, 1),
(19, 2),
(19, 3),
(20, 1),
(20, 2),
(20, 3),
(21, 1),
(21, 2),
(22, 1),
(22, 2),
(22, 3),
(23, 1),
(23, 2),
(23, 3),
(24, 1),
(24, 2),
(24, 3),
(25, 1),
(25, 2),
(25, 3),
(26, 1),
(26, 2),
(27, 1),
(27, 2),
(27, 3),
(28, 1),
(28, 2),
(28, 4),
(29, 1),
(29, 2),
(29, 4),
(30, 1),
(30, 2),
(30, 4),
(31, 1),
(31, 2),
(31, 4),
(32, 1),
(32, 2),
(32, 4),
(33, 1),
(33, 2),
(34, 1),
(34, 2),
(35, 1),
(35, 2),
(36, 1),
(36, 2),
(37, 1),
(37, 2),
(38, 1),
(38, 2),
(39, 1),
(39, 2),
(39, 3),
(39, 4),
(40, 1),
(40, 2),
(40, 3),
(40, 4),
(41, 1),
(41, 2),
(41, 3),
(41, 4),
(42, 1),
(42, 2),
(42, 3),
(42, 4),
(43, 1),
(43, 2),
(43, 3),
(43, 4);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`) VALUES
(1, 'site_name', 'Q - Visitor'),
(2, 'site_email', 'Info@qudratech-eg.com'),
(3, 'site_phone_number', '(+20) 111 444 9994'),
(4, 'site_logo', 'site_logo.png'),
(5, 'site_footer', '@ All Rights Reserved'),
(6, 'site_address', '21 Zaki Hassan St. Nasr City,Cairo'),
(7, 'site_description', 'Q - Visitor management system.'),
(8, 'notify_templates', '<p>Hello Employee Someone wants meet you, his/her name is</p>'),
(9, 'notifications_email', '1'),
(10, 'invite_templates', 'Hello'),
(11, 'notifications_sms', '1'),
(12, 'sms_gateway', '1'),
(13, 'front_end_enable_disable', '1'),
(14, 'terms_condition', 'Terms condition'),
(15, 'welcome_screen', '<p>Welcome,please tap on button to reserve a visit</p>'),
(35, 'mail_from_address', 'info@qudratech-eg.net'),
(34, 'mail_from_name', 'Q-Visitor'),
(20, 'twilio_disabled', '1'),
(33, 'mail_password', 'dvZ6jD=u[E$V'),
(32, 'mail_username', 'info@qudratech-eg.net'),
(31, 'mail_port', '587'),
(27, 'mail_disabled', '1'),
(30, 'mail_host', 'mail.qudratech-eg.net'),
(36, 'visitor_agreement', '0');

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

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(3) 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 `types`
--

INSERT INTO `types` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Type 1', 5, NULL, NULL),
(3, 'Delivery', 5, NULL, NULL),
(5, 'visit', 10, NULL, NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `username`, `email_verified_at`, `password`, `phone`, `address`, `last_login_at`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Mohamed', 'Sabry', 'admin@example.com', 'admin', NULL, '$2y$10$lElX2HTcd4NW8I6tMcL/c.n2DcJARw3BYUQpSHHdW/cpSXnfoOHKi', '+15005550006', 'Cairo, Egypt', NULL, 'S6uwR6DQUZPv3PIgO0nVOM1OHXINkMTynDm4njhsIHXkTvZ6ZYbaBJnL2hu7', '2021-02-04 06:35:00', '2022-08-14 19:47:48'),
(2, 'Reception', 'Demo', 'reception@example.com', 'reception', NULL, '$2y$10$L8py.Sy4ZvSnt8aULe9Kz.ZwMseCiCXUkliNFl5/c0y/IfWaIQ2cy', '+15005550008', 'Dhaka, Bangladesh', NULL, 'RZ4gTGuSct', '2021-02-04 06:35:00', '2021-02-04 06:35:00'),
(3, 'Mohamed', 'Sabry', 'employee@example.com', 'employee2095307444', NULL, '$2y$10$v9RnY7ZCZo6qv8fZoI.6/Ok1OrFP9s55.xUgZR4zrNFWtF90IfSoG', '+15005550007', 'Dhaka, Bangladesh', NULL, 'aX6vn6LmPr', '2021-02-04 06:35:00', '2022-08-16 19:02:28'),
(4, 'ِAmira', 'Noor', 'amira.noor@qudra-tech.com', 'amira.noor1696364717', NULL, '$2y$10$0edvMb2tMrClPfOIVceU4.c.LMf3AEdBFk8EkfYJOod.T4MytlkN2', '1111152549', NULL, NULL, NULL, '2022-08-24 22:10:19', '2022-08-24 22:10:19'),
(5, 'Mohamed', 'Sabry', 'superadmin@example.com', 'superadmin1838431656', NULL, '$2y$10$ijvVb/l4atAKNhAA1yLRcugJubJFFxskSeo4DOIKUAzSJAvqm18FG', '01023654789', NULL, NULL, NULL, '2022-08-25 21:00:11', '2022-08-25 21:00:11'),
(6, 'Amr', 'ASD', 'admin33@example.com', 'admin33796453845', NULL, '$2y$10$c7sFXknidib0eufkDo1E9ebLuWWiahfYNW/.pV8UyV8MWg/WwIDnW', '232343455566', NULL, NULL, NULL, '2022-08-25 21:36:34', '2022-08-25 21:36:34'),
(7, 'Ahmed', 'ASD', 'adminss@example.com', 'adminss1009421334', NULL, '$2y$10$kkTrtOPUas7xV1Zx4WFRBuFcTVdzJ0dF/CKAUZANPwvv2OUKZdrtO', '232343455566', NULL, NULL, NULL, '2022-08-25 21:39:31', '2022-08-25 21:39:31'),
(8, 'Rehab', 'kassim', 'rehabkassim@yahoo.com', 'rehabkassim1690807924', NULL, '$2y$10$OQhqkIPFd6VcQ5q/KVsVTOqgn4BEQHi81t32eiHOfyc91L7XFNpee', '23215996', NULL, NULL, NULL, '2022-08-25 22:01:37', '2022-08-25 22:01:37'),
(9, 'demo', 'account', 'demo@example.com', 'demo811021849', NULL, '$2y$10$lElX2HTcd4NW8I6tMcL/c.n2DcJARw3BYUQpSHHdW/cpSXnfoOHKi', '123456789', NULL, NULL, NULL, '2022-09-01 22:02:54', '2022-09-01 22:03:07'),
(10, 'TestUser', 'QudraTech.', 'TestUser@QudraTech.com', 'TestUser1226180319', NULL, '$2y$10$ilwbCnqoN1Ecb2Hcdz4sUuGN5byEVe5WiYOeacwV7bP5846pUZg0.', '23215996', NULL, NULL, NULL, '2022-10-26 16:43:51', '2022-10-26 16:43:51'),
(11, 'Abdullah', 'bibany', 'abdullah.bibany@qudra-tech.com', 'abdullah.bibany251682882', NULL, '$2y$10$O.PwRMV6xeeYUHynprO1N.SGshdim8euc5oFPUbsX2EVt9YnQWMAK', '01128951062', NULL, NULL, NULL, '2022-10-26 18:29:33', '2022-10-26 18:29:33');

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

--
-- Table structure for table `visiting_details`
--

CREATE TABLE `visiting_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reg_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `purpose` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_employee_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkin_at` datetime DEFAULT NULL,
  `checkout_at` datetime DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `visitor_id` bigint(20) UNSIGNED NOT NULL,
  `creator_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `creator_id` bigint(20) UNSIGNED NOT NULL,
  `editor_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `editor_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `qrcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'storage/qrcode/1234.png',
  `expiry_date` datetime DEFAULT NULL,
  `from_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `visiting_details`
--

INSERT INTO `visiting_details` (`id`, `reg_no`, `purpose`, `company_name`, `company_employee_id`, `checkin_at`, `checkout_at`, `status`, `user_id`, `employee_id`, `visitor_id`, `creator_type`, `creator_id`, `editor_type`, `editor_id`, `created_at`, `updated_at`, `qrcode`, `expiry_date`, `from_date`) VALUES
(147, '26102205', 'زياره', NULL, NULL, '2022-10-26 01:12:33', NULL, 5, 3, 3, 166, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:12:33', '2022-10-26 08:12:33', 'https://www.qudratech-eg.net/qrcode/temp/test8357103d913ce7e1ec8840c9a3a8084d.png', '0000-00-00 00:00:00', NULL),
(146, '26102204', 'زياره', NULL, NULL, '2022-10-26 01:11:34', NULL, 5, 3, 3, 165, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:11:34', '2022-10-26 08:11:34', 'https://www.qudratech-eg.net/qrcode/temp/test2a7d887c8e7016d04b5ae8e702be20ff.png', '2028-02-01 00:00:00', NULL),
(143, '26102202', 'زياره', NULL, NULL, '2022-10-26 10:57:19', NULL, 5, 3, 3, 162, 'AppScan', 1, 'AppScan', 1, '2022-10-26 17:57:19', '2022-10-26 17:57:19', 'https://www.qudratech-eg.net/qrcode/temp/test32a9c120dc6bc36583c9aac45ae7b5cc.png', '2027-06-22 00:00:00', NULL),
(148, '26102206', 'زياره', NULL, NULL, '2022-10-26 01:16:59', NULL, 5, 3, 3, 167, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:16:59', '2022-10-26 08:16:59', 'https://www.qudratech-eg.net/qrcode/temp/testad4c4b8d7a98932d66f7f0e5ae4af415.png', '2024-09-04 00:00:00', NULL),
(149, '26102207', 'زياره', NULL, NULL, '2022-10-26 01:17:44', NULL, 5, 3, 3, 168, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:17:44', '2022-10-26 08:17:44', 'https://www.qudratech-eg.net/qrcode/temp/test74380dffa1eadd4b4c43783f6a97947a.png', '2024-12-24 00:00:00', NULL),
(150, '26102208', 'زياره', NULL, NULL, '2022-10-26 01:31:21', NULL, 5, 3, 3, 169, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:31:21', '2022-10-26 08:31:21', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2028-08-02 00:00:00', NULL),
(151, '26102209', 'زياره', NULL, NULL, '2022-10-27 11:26:40', NULL, 5, 3, 3, 170, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:26:40', '2022-10-27 18:26:40', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2024-10-29 00:00:00', NULL),
(152, '26102210', 'زياره', NULL, NULL, '2022-10-27 11:27:19', NULL, 5, 3, 3, 171, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:27:19', '2022-10-27 18:27:19', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2025-08-08 00:00:00', NULL),
(155, '26102213', 'زياره', NULL, NULL, '2022-10-27 11:32:03', NULL, 5, 3, 3, 174, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:32:03', '2022-10-27 18:32:03', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2028-07-09 00:00:00', NULL),
(156, '26102214', 'زياره', NULL, NULL, '2022-10-27 11:32:55', NULL, 5, 3, 3, 175, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:32:55', '2022-10-27 18:32:55', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2024-10-06 00:00:00', NULL),
(157, '26102215', 'زياره', NULL, NULL, '2022-10-27 11:39:41', NULL, 5, 3, 3, 176, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:39:41', '2022-10-27 18:39:41', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '0000-00-00 00:00:00', NULL),
(158, '26102216', 'زياره', NULL, NULL, '2022-10-27 11:40:28', NULL, 5, 3, 3, 177, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:40:28', '2022-10-27 18:40:28', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2029-06-11 00:00:00', NULL),
(159, '26102217', 'زياره', NULL, NULL, '2022-10-27 12:17:48', NULL, 5, 3, 3, 178, 'AppScan', 1, 'AppScan', 1, '2022-10-27 19:17:48', '2022-10-27 19:17:48', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2025-10-13 00:00:00', NULL),
(160, '26102218', 'زياره', NULL, NULL, '2022-10-27 12:18:19', NULL, 5, 3, 3, 179, 'AppScan', 1, 'AppScan', 1, '2022-10-27 19:18:19', '2022-10-27 19:18:19', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2028-03-24 00:00:00', NULL),
(161, '26102219', 'زياره', NULL, NULL, '2022-10-27 02:03:52', NULL, 5, 3, 3, 180, 'AppScan', 1, 'AppScan', 1, '2022-10-27 09:03:52', '2022-10-27 09:03:52', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2028-03-17 00:00:00', NULL),
(162, '26102220', 'زياره', NULL, NULL, '2022-10-27 02:05:58', NULL, 5, 3, 3, 181, 'AppScan', 1, 'AppScan', 1, '2022-10-27 09:05:58', '2022-10-27 09:05:58', 'https://www.qudratech-eg.net/qrcode/temp/test1d4d0c7e4ef5e92bd8ee7461113eda9b.png', '2023-03-20 00:00:00', NULL),
(173, '26102221', 'زياره', NULL, NULL, '2022-11-03 09:19:51', NULL, 5, 3, 3, 192, 'AppScan', 1, 'AppScan', 1, '2022-11-03 16:19:51', '2022-11-03 16:19:51', 'https://www.qudratech-eg.net/qrcode/temp/test36c3a4fef1647e3dc117c6392f8b7f29.png', '2025-05-09 00:00:00', NULL),
(174, '26102222', 'زياره', NULL, NULL, '2022-11-03 11:12:39', NULL, 5, 3, 3, 193, 'AppScan', 1, 'AppScan', 1, '2022-11-03 18:12:39', '2022-11-03 18:12:39', 'https://www.qudratech-eg.net/qrcode/temp/teste075622c97b5635b67c39bac20e57d70.png', '2029-02-28 00:00:00', NULL),
(175, '26102223', 'زياره', NULL, NULL, '2022-11-10 09:37:15', NULL, 5, 3, 3, 194, 'AppScan', 1, 'AppScan', 1, '2022-11-10 16:37:15', '2022-11-10 16:37:15', 'https://www.qudratech-eg.net/qrcode/temp/test2f40e6f0325ae09fb7ccbaf9156e8e0a.png', '2022-11-03 00:00:00', NULL),
(176, '26102224', 'زياره', NULL, NULL, '2022-11-10 09:38:45', NULL, 5, 3, 3, 195, 'AppScan', 1, 'AppScan', 1, '2022-11-10 16:38:45', '2022-11-10 16:38:45', 'https://www.qudratech-eg.net/qrcode/temp/test24a140473e70b9af7804b5fb4a129dc1.png', '2023-10-08 00:00:00', NULL),
(177, '26102225', 'زياره', NULL, NULL, '2022-11-17 09:17:15', NULL, 5, 3, 3, 196, 'AppScan', 1, 'AppScan', 1, '2022-11-17 16:17:15', '2022-11-17 16:17:15', 'https://www.qudratech-eg.net/qrcode/temp/test1457d80b78740b4df603b56b942327bd.png', '2026-07-09 00:00:00', NULL),
(178, '26102226', 'زياره', NULL, NULL, '2022-11-21 09:08:05', NULL, 5, 3, 3, 197, 'AppScan', 1, 'AppScan', 1, '2022-11-21 16:08:05', '2022-11-21 16:08:05', 'https://www.qudratech-eg.net/qrcode/temp/testb3a57db388190f2be69f0fb15cb1184f.png', '2027-12-09 00:00:00', NULL),
(179, '26102227', 'زياره', NULL, NULL, '2022-11-27 11:51:47', NULL, 5, 3, 3, 198, 'AppScan', 1, 'AppScan', 1, '2022-11-27 18:51:47', '2022-11-27 18:51:47', 'https://www.qudratech-eg.net/qrcode/temp/test0c6ec8ee42749416c5c44325fe843a0c.png', '2027-11-04 00:00:00', NULL),
(180, '10012328', 'test tets', 'Ferrell and Marsh LLC', NULL, '2022-08-01 18:35:00', NULL, 5, 7, 7, 199, 'App\\User', 9, 'App\\User', 9, '2023-01-10 09:49:31', '2023-01-10 09:49:31', 'https://www.qudratech-eg.net/qrcode/temp/testc27126f5c25d2d5f21e07a540310eb81.png', '2020-08-12 03:07:00', '2022-08-01 18:35:00');

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

--
-- Table structure for table `visitors`
--

CREATE TABLE `visitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_identification_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_pre_register` tinyint(1) NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `creator_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `creator_id` bigint(20) UNSIGNED NOT NULL,
  `editor_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `editor_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `visitors`
--

INSERT INTO `visitors` (`id`, `first_name`, `last_name`, `email`, `phone`, `gender`, `address`, `national_identification_no`, `is_pre_register`, `status`, `creator_type`, `creator_id`, `editor_type`, `editor_id`, `created_at`, `updated_at`, `type`, `photo`) VALUES
(174, 'شريف', 'محمد عبدالمنعم الأنصارى', '', '', 'ذكر', ' ٥٢أ هضبة الاهرام الهرم - الجيزه', '28104271801616', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:32:01', '2022-10-27 18:32:01', '', 'data:image/jpeg;base64,[encoded data, 13240 characters]'),
(175, 'محمود', 'فرحات حامد عبدالباقى تركى', '', '', 'ذكر', 'العزيزيه مركز البدرشين - الجيزه', '28411282101039', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:32:53', '2022-10-27 18:32:53', '', 'data:image/jpeg;base64,[encoded data, 17160 characters]'),
(172, '', '', '', '', '', ' ', '', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:28:28', '2022-10-27 18:28:28', '', '');
INSERT INTO `visitors` (`id`, `first_name`, `last_name`, `email`, `phone`, `gender`, `address`, `national_identification_no`, `is_pre_register`, `status`, `creator_type`, `creator_id`, `editor_type`, `editor_id`, `created_at`, `updated_at`, `type`, `photo`) VALUES
(173, '', '', '', '', 'ذكر', ' ', '29401292103496', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:31:12', '2022-10-27 18:31:12', '', 'data:image/jpeg;base64,[encoded data, 42248 characters]'),
(163, 'Visitor', 'test', 'a@qudra-tech.com', '01111111111', '5', '26', NULL, 0, 5, 'App\\User', 9, 'App\\User', 9, '2022-10-26 18:31:41', '2022-10-26 18:31:41', NULL, 'storage/1/j7Q7ay1Tot.png'),
(162, 'احمد', 'محمود عبد الرحمن قوللى', '', '', '5', ' ٤النرجس  التجمع الخامس القاهره', '27806140102497', 0, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-26 17:57:16', '2022-10-26 17:57:16', '2', 'storage/1/143.png'),
(164, '', '', '', '', '', ' ', '', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-26 19:37:03', '2022-10-26 19:37:03', '', 'storage/1/145.png'),
(165, 'مايكل', 'فرحات جرجس سركيس', '', '', 'ذكر', 'شارع جامع ابو سبيحه اول الفيوم - الفيوم', '27706152300117', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:11:31', '2022-10-26 08:11:31', '', 'storage/1/146.png'),
(166, 'حمدى', 'صلاح الدين نصر خضر عيسى', '', '', 'ذكر', 'باسوس مركز القناطر الخيريه - القليوبية', '27807079400409', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:12:31', '2022-10-26 08:12:31', '', 'storage/1/147.png'),
(167, 'آيه', 'المتولى احمد المتولى بدوى', '', '', 'أنثى', 'حى  ٣منطقة ٣دعمارة ٢٦٤أأ التجمع الخامس 5 القاهره', '29306181200325', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:16:57', '2022-10-26 08:16:57', '', 'storage/1/148.png'),
(168, 'منهالله', 'السيد فرج محمد جاد', '', '', 'أنثى', ' ٢٢ح جاد يوسف ٠البراد الساحل - القاهره', '30002120200221', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:17:41', '2022-10-26 08:17:41', '', 'storage/1/149.png'),
(169, 'رضا', 'محمد احمد عثمان', '', '', 'ذكر', 'ح  ٥عقد ١ق ٣٣٢ * اكتوبر ثان - الجيزه', '26107220101794', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-26 08:31:19', '2022-10-26 08:31:19', '', 'storage/1/150.png');
INSERT INTO `visitors` (`id`, `first_name`, `last_name`, `email`, `phone`, `gender`, `address`, `national_identification_no`, `is_pre_register`, `status`, `creator_type`, `creator_id`, `editor_type`, `editor_id`, `created_at`, `updated_at`, `type`, `photo`) VALUES
(170, 'احمد', 'عمادالدين عبدالحى صالح', '', '', 'ذكر', 'ع  ٠١٢طيبه جاردنز 5 اكتوبر اول - الجيزه', '29209301604152', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:26:37', '2022-10-27 18:26:37', '', 'data:image/jpeg;base64,[encoded data, 15924 characters]'),
(171, 'احمد', 'عبدالرحمن يحيى عيسى', '', '', 'ذكر', 'عمارات  ٤١٣قطعه ٢٠٠ التجمع الخامس - القاهره', '28908021100312', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:27:17', '2022-10-27 18:27:17', '', 'data:image/jpeg;base64,[encoded data, 14892 characters]'),
(176, 'أحمد', 'ابراهيم خيرى الشنتناوى', '', '', 'ذكر', ' ٢ش الشهيد يسرى فهمى الحى الرابع مدينه نصراول - القاهره', '٢٩٢٠٤٠٨٠١٠٢٦٩٤', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:39:40', '2022-10-27 18:39:40', '', 'data:image/jpeg;base64,[encoded data, 15836 characters]');
INSERT INTO `visitors` (`id`, `first_name`, `last_name`, `email`, `phone`, `gender`, `address`, `national_identification_no`, `is_pre_register`, `status`, `creator_type`, `creator_id`, `editor_type`, `editor_id`, `created_at`, `updated_at`, `type`, `photo`) VALUES
(177, 'محمد', 'امبابى ابراهيم مصطفى', '', '', 'ذكر', ' ٥٧٧الحى الخامس عقد أولمجاورة  ١ اكتوبر ثان - الجيزه', '29102148800096', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 18:40:26', '2022-10-27 18:40:26', '', 'data:image/jpeg;base64,[encoded data, 16412 characters]'),
(178, 'اسامه', 'احمد عبدالعزيز عبدالهادى امبابى', '', '', 'ذكر', ' ٨٦التقسيم السياحى مركز القناطر الخيريه - القليوبية', '29012031401671', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 19:17:45', '2022-10-27 19:17:45', '', 'data:image/jpeg;base64,[encoded data, 15964 characters]'),
(179, 'محمد', 'عبده هاشم محمد', '', '', 'ذكر', 'كه ٥الطريق الصحراوى اول العامريه - الاسكندرية', '27210011802733', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 19:18:18', '2022-10-27 19:18:18', '', 'data:image/jpeg;base64,[encoded data, 15564 characters]');
INSERT INTO `visitors` (`id`, `first_name`, `last_name`, `email`, `phone`, `gender`, `address`, `national_identification_no`, `is_pre_register`, `status`, `creator_type`, `creator_id`, `editor_type`, `editor_id`, `created_at`, `updated_at`, `type`, `photo`) VALUES
(180, 'سمير', 'محمود رضا عبدالحميد على', '', '', 'ذكر', 'شبراهور مركز السنبلاوين - الدقهلية', '28903091201599', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 09:03:49', '2022-10-27 09:03:49', '', 'data:image/jpeg;base64,[encoded data, 15856 characters]'),
(181, 'مصطفى', 'مبروك محمود محمد', '', '', 'ذكر', 'شارع المنطقه الجديده مركز ببا - بنى سويف', '29007262201051', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-10-27 09:05:57', '2022-10-27 09:05:57', '', 'data:image/jpeg;base64,[encoded data, 18644 characters]'),
(182, 'Test', '1', 'abanoub.rizk@qudra-tech.com', '123456', '5', NULL, NULL, 0, 5, 'App\\User', 9, 'App\\User', 9, '2022-10-30 20:30:36', '2022-10-30 20:30:36', '2', NULL),
(183, 'Test', '2', 'abanoub.rizk@qudra-tech.com', '12345698', '5', NULL, NULL, 0, 5, 'App\\User', 9, 'App\\User', 9, '2022-10-30 20:33:07', '2022-10-30 20:33:07', '2', NULL),
(184, 'Test', '3', 'abanoub.rizk@qudra-tech.com', '1234568', '5', NULL, NULL, 0, 5, 'App\\User', 9, 'App\\User', 9, '2022-10-30 20:33:52', '2022-10-30 20:33:52', '2', NULL),
(185, 'Test', '4', 'abanoub.rizk@qudra-tech.com', '12365498', '5', NULL, NULL, 0, 5, 'App\\User', 1, 'App\\User', 1, '2022-10-30 20:38:08', '2022-10-30 20:38:08', '2', NULL),
(186, 'Test', '5', 'abanoub.rizk@qudra-tech.com', '985643', '5', NULL, NULL, 0, 5, 'App\\User', 1, 'App\\User', 1, '2022-10-30 20:39:59', '2022-10-30 20:39:59', '2', NULL),
(187, 'Test', '6', 'abanoub.rizk@qudra-tech.com', '856321', '5', NULL, NULL, 0, 5, 'App\\User', 1, 'App\\User', 1, '2022-10-30 20:41:03', '2022-10-30 20:41:03', '2', NULL),
(188, 'Test', '7', 'abanoub.rizk@qudra-tech.com', '85632', '5', NULL, NULL, 0, 5, 'App\\User', 1, 'App\\User', 1, '2022-10-30 20:41:43', '2022-10-30 20:41:43', '2', NULL),
(189, 'Test', '8', 'abanoub.rizk@qudra-tech.com', '785631', '5', NULL, NULL, 0, 5, 'App\\User', 1, 'App\\User', 1, '2022-10-30 20:42:35', '2022-10-30 20:42:35', '2', NULL),
(190, 'Test', '9', 'abanoub.rizk@qudra-tech.com', '442453', '5', NULL, NULL, 0, 5, 'App\\User', 1, 'App\\User', 1, '2022-10-30 20:43:21', '2022-10-30 20:43:21', '2', NULL),
(191, 'Test', '10', 'abanoub.rizk@qudra-tech.com', '74125825', '5', NULL, NULL, 0, 5, 'App\\User', 1, 'App\\User', 1, '2022-10-30 20:43:51', '2022-10-30 20:43:51', '2', NULL),
(192, 'بيشوى', 'سامى فرنسيس عبيد', '', '', 'ذكر', ' ٤٩شارع الشيخ ترك اول المنيا - المنيا', '28704012400155', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-11-03 16:19:47', '2022-11-03 16:19:47', '', 'storage/1/173.png'),
(193, 'معاذ', 'محمد محمد الجمال', '', '', 'ذكر', ' ٨امتداد الضباط اول السلام 3 القاهره', '28910061701771', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-11-03 18:12:35', '2022-11-03 18:12:35', '', 'storage/1/174.png'),
(194, 'عماد', 'عبدالحليم عبدالمؤمن طبوشه', '', '', 'ذكر', 'طليا مركز اشمون - المنوفية', '29009111700377', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-11-10 16:37:12', '2022-11-10 16:37:12', '', 'storage/1/175.png'),
(195, 'بيتر', 'سمير ويصا بشاى', '', '', 'ذكر', 'ش مكة المكرمة بولاق الدكرور - الجيزه', '29310162101313', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-11-10 16:38:40', '2022-11-10 16:38:40', '', 'storage/1/176.png'),
(196, 'عماد', 'عبدالحليم عبدالمؤمن طبوشه', '', '', 'ذكر', 'طليا مركز اشمون - المنوفية', '29009111700377', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-11-17 16:17:12', '2022-11-17 16:17:12', '', 'storage/1/177.png'),
(197, 'محمود', 'عبدربه توفيق محمد', '', '', 'ذكر', 'ب٤٤سم ١مساكن الحديدوالصلب الجديدة التبين - القاهره', '28209010111856', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-11-21 16:08:01', '2022-11-21 16:08:01', '', 'storage/1/178.png'),
(198, 'ابانوب', 'رزق ذكرى شحاته', '', '', 'ذكر', ' ٣٢ش شيبان الساحل - القاهره', '٢٩٢٠٥٢٣٠١٠١٧٥٢', 1, 5, 'AppScan', 1, 'AppScan', 1, '2022-11-27 18:51:43', '2022-11-27 18:51:43', '', 'storage/1/179.png'),
(199, 'Dawn', 'Moody', 'vybiluqico@mailinator.com', '+1 (171) 406-1132', '10', 'test tes', 'Delectus sed cupidi', 0, 5, 'App\\User', 9, 'App\\User', 9, '2023-01-10 09:49:29', '2023-01-10 09:49:29', '2', NULL),
(201, 'Skyler', 'Jenkins', 'xidyqibi@mailinator.com', '+1 (236) 226-4349', '5', '<p>address 2&nbsp;&nbsp;&nbsp;&nbsp;</p>', 'Commodi impedit err', 0, 5, 'App\\User', 9, 'App\\User', 9, '2023-01-10 10:35:08', '2023-01-10 10:35:08', '2', NULL),
(202, 'Michelle', 'Davenport', 'peluhiror@mailinator.com', '+1 (487) 861-9028', '10', 'fd,jshfsdhfsd', 'Delectus magna aper', 0, 5, 'App\\User', 9, 'App\\User', 9, '2023-01-10 10:40:06', '2023-01-10 10:40:06', '2', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activation_code`
--
ALTER TABLE `activation_code`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `attendances`
--
ALTER TABLE `attendances`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `backend_menus`
--
ALTER TABLE `backend_menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bookings_reg_no_unique` (`reg_no`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `designations`
--
ALTER TABLE `designations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employees_creator_type_creator_id_index` (`creator_type`,`creator_id`),
  ADD KEY `employees_editor_type_editor_id_index` (`editor_type`,`editor_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `invitations`
--
ALTER TABLE `invitations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pre_registers`
--
ALTER TABLE `pre_registers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pre_registers_creator_type_creator_id_index` (`creator_type`,`creator_id`),
  ADD KEY `pre_registers_editor_type_editor_id_index` (`editor_type`,`editor_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `types`
--
ALTER TABLE `types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `users_username_unique` (`username`);

--
-- Indexes for table `visiting_details`
--
ALTER TABLE `visiting_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `visiting_details_reg_no_unique` (`reg_no`),
  ADD KEY `visiting_details_creator_type_creator_id_index` (`creator_type`,`creator_id`),
  ADD KEY `visiting_details_editor_type_editor_id_index` (`editor_type`,`editor_id`);

--
-- Indexes for table `visitors`
--
ALTER TABLE `visitors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visitors_creator_type_creator_id_index` (`creator_type`,`creator_id`),
  ADD KEY `visitors_editor_type_editor_id_index` (`editor_type`,`editor_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activation_code`
--
ALTER TABLE `activation_code`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `attendances`
--
ALTER TABLE `attendances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `backend_menus`
--
ALTER TABLE `backend_menus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invitations`
--
ALTER TABLE `invitations`
  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 `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `pre_registers`
--
ALTER TABLE `pre_registers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `types`
--
ALTER TABLE `types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `visiting_details`
--
ALTER TABLE `visiting_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- AUTO_INCREMENT for table `visitors`
--
ALTER TABLE `visitors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=203;
COMMIT;

