-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 16, 2026 at 03:19 PM -- Server version: 10.6.23-MariaDB-cll-lve -- PHP Version: 8.4.14 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `bbmssferpgos_pms_db` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `user_name` varchar(255) NOT NULL, `image` longtext DEFAULT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `password` varchar(255) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT 1, `last_login` timestamp NULL DEFAULT NULL, `is_superadmin` tinyint(1) NOT NULL DEFAULT 0, `permission_id` bigint(20) UNSIGNED DEFAULT NULL, `role_id` bigint(20) UNSIGNED NOT NULL, `section_id` bigint(20) UNSIGNED DEFAULT NULL, `designation_id` bigint(20) UNSIGNED NOT NULL, `signature_image` longtext DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_by` bigint(20) UNSIGNED DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `layout_preferences` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`layout_preferences`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `user_name`, `image`, `email`, `email_verified_at`, `phone`, `password`, `status`, `last_login`, `is_superadmin`, `permission_id`, `role_id`, `section_id`, `designation_id`, `signature_image`, `created_by`, `updated_by`, `remember_token`, `layout_preferences`, `created_at`, `updated_at`) VALUES (1, 'Admin User', 'admin', NULL, 'admin@admin.com', '2026-04-15 12:08:14', NULL, '$2y$10$36pqIKe2zrbUn0PDly/PReob000rgXn.W0XbrTVdoI8cEUS.b32hS', 1, NULL, 1, 1, 1, NULL, 2, NULL, NULL, NULL, 'E9x6sZi0tre1WzZbVL8Hw7KajyyhY3av5vXVvfWJrIUMz4iBOn6PQvJPIfpm', NULL, '2026-04-15 12:08:14', '2026-04-15 12:08:15'), (2, 'MEO 1 MEC', 'meo1', NULL, 'meo1@pms.local', NULL, NULL, '$2y$10$/qZ1WtDHTZOOU7wPBow7fOSMoAqNblwEfJ5eTn0zl60nxpP3UAS4a', 1, NULL, 0, 2, 2, NULL, 4, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:14', '2026-04-15 12:08:15'), (3, 'MEO 2 MEC', 'meo2', NULL, 'meo2@pms.local', NULL, NULL, '$2y$10$/qZ1WtDHTZOOU7wPBow7fOSMoAqNblwEfJ5eTn0zl60nxpP3UAS4a', 1, NULL, 0, 2, 2, NULL, 4, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:14', '2026-04-15 12:08:15'), (4, 'RD MEC', 'rd', NULL, 'rd@pms.local', NULL, NULL, '$2y$10$/qZ1WtDHTZOOU7wPBow7fOSMoAqNblwEfJ5eTn0zl60nxpP3UAS4a', 1, NULL, 0, 3, 2, NULL, 5, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:14', '2026-04-15 12:08:15'), (5, 'SDM MEC', 'sdm', NULL, 'sdm@pms.local', NULL, NULL, '$2y$10$/qZ1WtDHTZOOU7wPBow7fOSMoAqNblwEfJ5eTn0zl60nxpP3UAS4a', 1, NULL, 0, 4, 2, NULL, 6, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:14', '2026-04-15 12:08:15'), (6, 'DG MEC', 'dg', NULL, 'dg@pms.local', NULL, NULL, '$2y$10$/qZ1WtDHTZOOU7wPBow7fOSMoAqNblwEfJ5eTn0zl60nxpP3UAS4a', 1, NULL, 0, 5, 2, NULL, 7, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:14', '2026-04-15 12:08:15'), (7, 'Dept Submitter', 'pcsubmitter', NULL, 'pcsubmitter@csr.com', NULL, NULL, '$2y$10$nYx/PIlQIg8z2aTwnNCoge9x75/PzASOHartm6HKaBjOoxZx3JwbO', 1, NULL, 0, 6, 3, NULL, 8, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:15', '2026-04-15 12:08:15'), (8, 'CSR Admin', 'csradmin', NULL, 'csradmin@csr.com', NULL, NULL, '$2y$10$nYx/PIlQIg8z2aTwnNCoge9x75/PzASOHartm6HKaBjOoxZx3JwbO', 1, NULL, 0, 7, 3, NULL, 9, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:15', '2026-04-15 12:08:15'), (9, 'Dept Checker', 'pcchecker', NULL, 'pcchecker@csr.com', NULL, NULL, '$2y$10$nYx/PIlQIg8z2aTwnNCoge9x75/PzASOHartm6HKaBjOoxZx3JwbO', 1, NULL, 0, 8, 3, NULL, 8, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:15', '2026-04-15 12:08:15'), (10, 'Dept Approver', 'departmentapprover', NULL, 'departmentapprover@csr.com', NULL, NULL, '$2y$10$nYx/PIlQIg8z2aTwnNCoge9x75/PzASOHartm6HKaBjOoxZx3JwbO', 1, NULL, 0, 8, 3, NULL, 8, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:15', '2026-04-15 12:08:15'), (11, 'P&D Approver', 'pcapprover', NULL, 'pcapprover@pnd.com', NULL, NULL, '$2y$10$nYx/PIlQIg8z2aTwnNCoge9x75/PzASOHartm6HKaBjOoxZx3JwbO', 1, NULL, 0, 9, 1, 1, 3, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:15', '2026-04-15 12:08:15'), (12, 'Chairman P&D', 'chairman_pd', NULL, 'chairman@pnd.com', NULL, NULL, '$2y$10$nYx/PIlQIg8z2aTwnNCoge9x75/PzASOHartm6HKaBjOoxZx3JwbO', 1, NULL, 0, 10, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '2026-04-15 12:08:15', '2026-04-15 12:08:15'), (13, 'User Creator', 'user creator', '', 'test@pms.local', NULL, '8359025723', '$2y$10$ToWg9E0ufyXr0TFO72VR5eCVg4eZlKZm4z4rvx0Ufnnqd6aZE.mPS', 1, NULL, 0, 11, 2, NULL, 1, '', NULL, NULL, NULL, NULL, '2026-04-15 12:23:57', '2026-04-15 12:23:57'), (14, 'Dr. shazia Mahar', 'smahar', '', 'smahar.poda@gmail.com', NULL, '03342982851', '$2y$10$vTWKsVAJXaRuLAgfAqOHq.Vsm6SUf6QzDX73JnhmPWZkx.icHP0c6', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 12:38:13', '2026-04-15 12:38:13'), (15, 'Bilal Ahmed Jalbani', 'bilalaj', '', 'bajalbani27@gmail.com', NULL, '+92 333 7195179', '$2y$10$jRh9kJrsEzxEafcjUfkvzunmLe8tr8kK5ur1pK8N9SYHJpLbl6VKS', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 12:46:04', '2026-04-15 17:06:56'), (16, 'Engr. Aurangzeb Vistro', 'avistro_rd', '', 'zeb_mec@hotmail.com', NULL, '+92 300 3079893', '$2y$10$72apzi4htUsMaJCRkdjbwuJoCu1cSzh1si0WmOU181p6ptrUdelby', 1, NULL, 0, 3, 2, NULL, 5, '', NULL, NULL, NULL, NULL, '2026-04-15 12:49:31', '2026-04-15 12:49:31'), (17, 'Rasheed Jumani', 'rasheed_rd', '', 'rahmed@mecsindh.gov.pk', NULL, '03002685447', '$2y$10$4AZbagGHx4ESZgVYlO9.X.6sRGgHPPr79NqNC5RWI8W.7gLYH3PU6', 1, NULL, 0, 3, 2, NULL, 5, '', NULL, NULL, NULL, NULL, '2026-04-15 12:55:50', '2026-04-15 15:53:43'), (18, 'Kashif Anwar', 'kanwar', '', 'kashifanwarr@gmail.com', NULL, '03002548315', '$2y$10$BXXPkP4jSlBjTUVYXkOmUeARhEPn7THS1Cafjjff50kkAeK/fDXWe', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 12:59:37', '2026-04-15 12:59:37'), (19, 'Ahmed Hussain Mahar', 'amahar', '', 'amahar42@gmail.com', NULL, '+92 300 8211646', '$2y$10$EOMC.H8UD4nCx9rP.eSEl.ebFIaecpGi8pSyQWaX/l6ETJWEiRiWW', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 13:04:22', '2026-04-15 15:49:35'), (20, 'Muhammad Azeem Jarwar', 'ajarwar_rd', '', 'jarwarazeem@yahoo.com', NULL, '03332531184', '$2y$10$UNM9Po5FX5Zqmqx2SKS9augjv3qRwqeDZ4U5x2tl2gF/3JDRC4SLC', 1, NULL, 0, 3, 2, NULL, 5, '', NULL, NULL, NULL, NULL, '2026-04-15 13:10:12', '2026-04-15 13:10:12'), (21, 'Shahzeb Ahmed Shaikh', 'sshaikh', '', 'shahzebahmed72@hotmail.com', NULL, '03003157377', '$2y$10$81U.9JQ7SAwk9yyH29jbb.GotFMOXAPj9Igp7HJbIc3jCXov2HKUW', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 13:12:59', '2026-04-15 16:07:36'), (22, 'Abdul Qayoom Palijo', 'aqpalijo', '', 'apalijo@gmail.com', NULL, '03163961650', '$2y$10$oThVRAMmWnCQF9wL2BySYOlM.JPCH8.F09NJT3VZD3aD4VhX29PZC', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 13:17:16', '2026-04-15 16:08:32'), (23, 'Imran Khan Memon', 'imemon_rd', '', 'petarian8964@gmail.com', NULL, '03332961407', '$2y$10$ZxqeAXK5viRKS0aFuoyFBe66az79Z5tHPl78UHDxBohLGAgINRIpG', 1, NULL, 0, 3, 2, NULL, 5, '', NULL, NULL, NULL, NULL, '2026-04-15 13:21:53', '2026-04-15 14:00:07'), (24, 'Muhammad Amir Arain', 'mamir', '', 'shan_kiit@hotmail.com', NULL, '03013627557', '$2y$10$6acD7jpYsq3OkvxHy26VBeqQtNG42WoSuNWw3e/B3q5efEjgeRvYW', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 13:26:57', '2026-04-15 16:24:46'), (25, 'Nisar Ahmed khatti', 'nkhatti', '', 'nisarkhatti3@gmail.com', NULL, '03313567035', '$2y$10$XzdDbesRpbr/unLJ7fz9QeQxUD.UWzDcRY1UX0EW2h78S5tRqFFBO', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 13:32:38', '2026-04-15 16:49:38'), (26, 'Mohsan Ali Memon', 'mmemon', '', 'mohsan.mec@gmail.com', NULL, '+92 332 2211678/', '$2y$10$ZLQpltd1qEi2yhr6/0fOau0mYkYJGw.v3de2s8bTgnqHx9E0Nwyuy', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 13:39:38', '2026-04-15 13:39:38'), (27, 'Aziz ul Rehman Channa', 'azrehman_rd', '', 'azizrehman_suk@yahoo.com', NULL, '+92 300 3140157', '$2y$10$iOAMQJSARKytfIwq39v76uePjFqfXCEE8RK15L0w7rfNztfitVtlO', 1, NULL, 0, 3, 2, NULL, 5, '', NULL, NULL, NULL, NULL, '2026-04-15 13:46:09', '2026-04-15 13:46:09'), (28, 'Shamsuddin Mahesar', 'smahesar', '', 'drshamas1974@gmail.com', NULL, '+92 345 5418930', '$2y$10$LZs5md8fME1Xfd8FCRt3X.Jz67UkAdWorRKNzRssqEYqWm1x/bqFa', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 13:48:41', '2026-04-15 13:48:41'), (29, 'Fatehuddin Junejo', 'fjunejo_sdm', '', 'fatehdin@gmail.com', NULL, '+92 333 2627342', '$2y$10$IBtAkwChgtAkl0EQAdxEKeXc0uYFDDI.Ey78VbKlPKZLj.DZc8LFO', 1, NULL, 0, 4, 2, NULL, 6, '', NULL, NULL, NULL, NULL, '2026-04-15 14:05:54', '2026-04-15 15:54:32'), (30, 'Muhammad Hanif Hingoro', 'Haneef', '', 'mhaneefhingoro@gmail.com', NULL, '03337065759', '$2y$10$CDas3asKDL8ibhw7YwzlaOA4fieou4AnIp6zNrhDEnh2Uwqxp2IZ2', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 16:15:26', '2026-04-15 16:36:08'), (31, 'Eng Umair Aslam', 'umair', '', 'engineerumairaslam@gmail.com', NULL, '+92 334 3315245', '$2y$10$JFVbwf8aOAgQ/iFO5YqY..UiDO8Cns/gNHZofsE.f/UOnM/RO0Guy', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 16:18:42', '2026-04-15 16:18:42'), (32, 'Rabia Muhammad Ali', 'Rabia', '', 'rabia.muhammadali@gmail.com', NULL, '+92 331 2340885', '$2y$10$Nu5mEZKLp6blFu6mjKi8.e8bQDTPiQiaPzHz.4z.SWXt0nBuJM6VO', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 16:21:56', '2026-04-15 16:21:56'), (33, 'S. Shafqat Ali Shah', 'SAS', '', 'sas.shah77@gmail.com', NULL, '03337455740', '$2y$10$Qot95N8Afi.3dQ3EBV1PBOTx3tUe7/AJmTPrZ4CVQBaXoUVPhjjgi', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 16:29:54', '2026-04-15 16:35:23'), (34, 'Jahanzeb Mallah', 'Jahanzeb', '', 'jahanzebmallah08@gmail.com', NULL, '+92 333 8263000', '$2y$10$QKLHzgKKA2ywVHMb/7Ttc.BkRMIff9W.QAJ7BywhCLgWi9Or5LujG', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 16:46:20', '2026-04-15 16:46:20'), (35, 'shafique Ahmed Samtio', 'ssamtio', '', 'shafiquesamtio123@gmail.com', NULL, '03322184381', '$2y$10$APx9ohukdCe/n/ELuKvhm.uanIrVtC9s3rjbnrh5GcPwzJ1APH37i', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 16:55:26', '2026-04-15 16:55:26'), (36, 'Rameez Bajkani', 'rameez', '', 'rameez.bajkani53@gmail.com', NULL, '+92 333 7199931', '$2y$10$cnhSus28BQ7MdoPMgwIXbeu5.CIGHOPnFg04CzkFnWZrBzZh1/sCK', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 17:00:18', '2026-04-15 17:00:18'), (37, 'Muhammad Hanif Abro', 'mhabro', '', 'mabro.mec@gmail.com', NULL, '+92 300 8011692', '$2y$10$l.ffJR4hHtpLvYRJ1AQ12e8CsqhrHCspWthUTn/TniGRwSnKz3ony', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 17:04:26', '2026-04-15 17:04:26'), (38, 'Engr.Ghulamullah Mahar', 'gmahar', '', 'mecsindh@gmail.com', NULL, '03013819166', '$2y$10$0gKm2ciTLFIy4kKguQI6net4vXYM5NeuRMx.wTJNYjc6GQff1oO4O', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 17:11:18', '2026-04-15 17:11:18'), (39, 'Muhamamd Naeem Korejo', 'mnkorejo', '', 'naeemkorejo@hotmail.com', NULL, '03012547112', '$2y$10$wLGgHjp6xvCK4cLhoiF/p.jRveHZL4cau8.wsYLZwFGODoKTY2oIy', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 17:15:27', '2026-04-15 17:15:27'), (40, 'Shah Faisal rajput', 'Shahfaisal', '', 'shahfaisalrajput1@gmail.com', NULL, '03463213676', '$2y$10$s8YxhN4moNU.YkN6FyHIce6WLra8YEHTF.HOgS0cKwS2bAPYXnYOW', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 17:19:30', '2026-04-15 17:19:30'), (41, 'Jahangir Khan Chandio', 'jkchandio', '', 'chandio.jahangir@gmail.com', NULL, '+92 335 0258719', '$2y$10$UkO1VsozXaFpFGI1Bn1OkO/w8dikuqprUZ3iY7QsnYJLuod.zMfv.', 1, NULL, 0, 2, 2, NULL, 4, '', NULL, NULL, NULL, NULL, '2026-04-15 17:24:32', '2026-04-15 17:24:32'); -- -- Indexes for dumped tables -- -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_role_id_foreign` (`role_id`), ADD KEY `users_permission_id_foreign` (`permission_id`), ADD KEY `users_designation_id_foreign` (`designation_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- Constraints for dumped tables -- -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`), ADD CONSTRAINT `users_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;