-- Adminer 4.8.1 MySQL 8.0.33 dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; SET NAMES utf8mb4; DROP TABLE IF EXISTS `employee_infos`; CREATE TABLE `employee_infos` ( `id` int NOT NULL AUTO_INCREMENT, `employee_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `organisation_id` int NOT NULL, `user_id` int NOT NULL, `office_id` int NOT NULL DEFAULT '0', `department_id` int NOT NULL DEFAULT '0', `position_id` int NOT NULL DEFAULT '0', `from_cat_id` int NOT NULL DEFAULT '0', `datas` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `update_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `shift_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO `employee_infos` (`id`, `employee_code`, `organisation_id`, `user_id`, `office_id`, `department_id`, `position_id`, `from_cat_id`, `datas`, `update_data`, `shift_id`, `created_at`, `updated_at`) VALUES (1, 'LNXX0001', 29, 270, 6, 84, 125, 1, '{\"first_name\":\"Dipanshu\",\"second_name\":\"\",\"last_name\":\"Roy\",\"office_id\":\"JCBL - Abu Dhabi\",\"department\":\"Mancom\",\"designation\":\"Managing Director\",\"line_manager\":\"Select Line Manager\",\"become_line_manager\":\"1\",\"shift_id\":\"17\",\"salary\":\"50000\",\"employee_code\":\"LNXX0001\",\"father_name\":\"Papa\",\"mother_name\":\"Mummy\",\"dob\":\"2023-07-24\",\"gender\":\"Male\",\"email\":\"dipanshu@samtechinnovations.co\",\"uae_mobile_no\":\"785858585858\",\"marital_status\":\"Single\",\"lnxx_login\":\"1\",\"profile\":\"employee\\/profile\\/96056237.png\"}', '{\"first_name\":\"Dipanshu\",\"second_name\":\"\",\"last_name\":\"Roy\",\"office_id\":\"6\",\"department\":\"31\",\"designation\":\"291\",\"line_manager\":\"Select Line Manager\",\"become_line_manager\":\"1\",\"shift_id\":\"17\",\"salary\":\"50000\",\"employee_code\":\"LNXX0001\",\"father_name\":\"Papa\",\"mother_name\":\"Mummy\",\"dob\":\"2023-07-24\",\"gender\":\"Male\",\"email\":\"dipanshu@samtechinnovations.co\",\"uae_mobile_no\":\"785858585858\",\"marital_status\":\"Single\",\"lnxx_login\":\"1\",\"profile\":\"employee\\/profile\\/96056237.png\"}', 17, '2023-07-24 12:38:56', '2023-07-24 12:38:56'), (2, 'LNXX0001', 29, 271, 6, 82, 119, 1, '{\"first_name\":\"Atish\",\"second_name\":\"\",\"last_name\":\"Roy\",\"office_id\":\"JCBL - Abu Dhabi\",\"department\":\"HR\",\"designation\":\"HR Manager\",\"line_manager\":\"270\",\"become_line_manager\":\"1\",\"shift_id\":\"1\",\"salary\":\"50000\",\"employee_code\":\"LNXX0001\",\"father_name\":\"Papa\",\"mother_name\":\"Mummy\",\"dob\":\"2023-07-28\",\"gender\":\"Male\",\"email\":\"sales@trueweb.agency\",\"uae_mobile_no\":\"785858585858\",\"marital_status\":\"Single\",\"lnxx_login\":\"1\",\"profile\":\"employee\\/profile\\/images.png\"}', '{\"first_name\":\"Atish\",\"second_name\":\"\",\"last_name\":\"Roy\",\"office_id\":\"6\",\"department\":\"82\",\"designation\":\"119\",\"line_manager\":\"270\",\"become_line_manager\":\"1\",\"shift_id\":\"1\",\"salary\":\"50000\",\"employee_code\":\"LNXX0001\",\"father_name\":\"Papa\",\"mother_name\":\"Mummy\",\"dob\":\"2023-07-28\",\"gender\":\"Male\",\"email\":\"sales@trueweb.agency\",\"uae_mobile_no\":\"785858585858\",\"marital_status\":\"Single\",\"lnxx_login\":\"1\",\"profile\":\"employee\\/profile\\/images.png\"}', 1, '2023-07-28 11:44:21', '2023-07-28 11:44:21'), (3, NULL, 29, 271, 0, 0, 0, 2, '{\"name\":\"Papa\",\"relation\":\"Father\",\"mobile\":\"957293168\",\"address\":\"1306 Opal Tower, Business Bay \",\"country_name\":\"United Arab Emirates\",\"state_name\":\"Dubai\",\"city_name\":\"Abu Dhabi\",\"pincode\":\"201301\"}', '{\"name\":\"Papa\",\"relation\":\"Father\",\"mobile\":\"957293168\",\"address\":\"1306 Opal Tower, Business Bay \",\"country_name\":\"United Arab Emirates\",\"state_name\":\"Dubai\",\"city_name\":\"Abu Dhabi\",\"pincode\":\"201301\"}', 0, '2023-07-28 11:44:34', '2023-07-28 11:44:34'); DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `mobile` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `type` int DEFAULT NULL COMMENT '0=>SuperAdmin,1=>Orgnization,3=>Users', `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `fcm_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `active_notification` int NOT NULL DEFAULT '0', `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Active', `lnxx_login` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '''0'' For No,''1'' For Yes', `shift_id` int DEFAULT NULL, `organisation_id` int NOT NULL DEFAULT '0', `profile_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `salary` varchar(11) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0', `hire_id` int DEFAULT NULL, `line_manager` int DEFAULT NULL, `become_line_manager` int NOT NULL DEFAULT '0', `on_payroll` int NOT NULL DEFAULT '0', `is_admin` int NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO `users` (`id`, `name`, `email`, `mobile`, `email_verified_at`, `password`, `type`, `remember_token`, `fcm_id`, `active_notification`, `status`, `lnxx_login`, `shift_id`, `organisation_id`, `profile_image`, `salary`, `hire_id`, `line_manager`, `become_line_manager`, `on_payroll`, `is_admin`, `created_at`, `updated_at`) VALUES (1, 'Super Admin', 'superadmin@admin.com', NULL, NULL, '$2y$10$HWiKWSt8IAv95hKaGo89MOVUaM6Pkd.Mh8/VjVONdSed08yjEOMRa', 0, NULL, NULL, 0, 'Active', '0', NULL, 0, NULL, '0', NULL, NULL, 0, 0, 0, '2022-11-17 00:48:09', '2022-11-17 00:48:09'), (2, 'Organization', 'organization@admin.com', NULL, NULL, '$2y$10$NOFV3BwuyE1BS9sf6.BFeuEq1NDf1myhYjoT6nFrzbH.ITXn7tXf.', 1, NULL, NULL, 0, 'Active', '0', NULL, 0, NULL, '0', NULL, NULL, 0, 0, 0, '2022-11-17 00:48:09', '2022-11-17 00:48:09'), (29, 'lnxx', 'lnxx@gmail.com', '9572923168', NULL, '$2y$10$n/tAB33PM78Hf7ar4sPrB.HzZF9/D/gpNd.XV29z1LUW1KJLWHpE2', 1, NULL, NULL, 1, 'Active', '0', NULL, 29, NULL, '0', NULL, 29, 0, 0, 1, '2022-11-21 03:02:41', '2022-11-21 03:02:41'), (270, 'Dipanshu Roy', 'dipanshu@samtechinnovations.co', '785858585858', NULL, '$2y$10$.5d2VwXikuaMopM.VgQBh.ykxwRa7.1fyT4IW4rjmvmpCRQNplwge', 1, NULL, NULL, 0, 'Active', '1', NULL, 29, NULL, '50000', 0, 29, 1, 0, 0, '2023-07-24 12:38:52', '2023-07-24 12:38:52'), (271, 'Atish Roy', 'sales@trueweb.agency', '785858585858', NULL, '$2y$10$8o4jZI2tbuOAtH6TjEuv0OCsL3u3KDfQf6fizK7j2XM1Y1DbBvBHi', 1, '8e0bc8ddfa5512d5cfadade349d8e8b6', 'dsfdefdsfdsf', 0, 'Active', NULL, NULL, 29, NULL, '50000', NULL, 270, 1, 0, 0, '2023-07-28 11:44:17', '2023-07-28 11:48:44');