\r\n
\r\n
\r\n\r\n
{{$data[\'main_heading\']}}
\r\n
{{$data[\'content\']}}
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
![\"Banknote/Currency\"](\"{{)
\r\n
\r\n
\r\n
Life at PSPC
\r\n
A peek into our everyday office vibe — collaborative spaces, friendly faces, and a\r\n culture that balances productivity with positivity.
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
What We Believe In
\r\n
\r\n
Our values aren\'t just words on a wall — they guide how we work, interact, and grow\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
Moments That Matter / Celebrations/ Inclusive always
\r\n
From birthdays to big wins, we celebrate everything together.
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
Moments That Matter / Celebrations/ Inclusive always
\r\n
From birthdays to big wins, we celebrate everything together.
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
Growth & Learning
\r\n
Work is just one part of our journey — growth is another.
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
Doing Meaningful Work
\r\n
We’re not just building products — we’re building impact.
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n',1,'2025-05-22 00:47:06','2025-05-23 02:02:37',NULL,NULL,NULL),(10,'ESG Tabs',1,'{\"fields\": [{\"name\": \"main_heading\", \"type\": \"text\", \"label\": \"Main Heading\", \"required\": true}], \"children\": [{\"name\": \"main_title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"url\", \"type\": \"text\", \"label\": \"URL\", \"required\": true}, {\"name\": \"image\", \"type\": \"file\", \"label\": \"Upload Image\", \"required\": true}]}','
\r\n \r\n
\r\n
\r\n
\r\n
{{$data[\'main_heading\']}}
\r\n \r\n
\r\n
\r\n
\r\n @if($pageComponent->children)\r\n @foreach($pageComponent->children as $i => $children)\r\n
\r\n
\r\n
\r\n
fields_data[\'image\']) }}\" alt=\"\">\r\n
\r\n
\r\n
\r\n
\r\n @endforeach\r\n @endif\r\n
\r\n
',1,'2025-05-22 01:56:08','2025-05-25 19:54:56',NULL,NULL,NULL),(11,'Awards & Certificates',1,'{\"fields\": [{\"name\": \"sub_heading\", \"type\": \"text\", \"label\": \"Sub Heading\", \"required\": true}, {\"name\": \"main_heading\", \"type\": \"text\", \"label\": \"Main Heading\", \"required\": true}, {\"name\": \"content\", \"type\": \"text\", \"label\": \"Content\", \"required\": true}, {\"name\": \"url\", \"type\": \"text\", \"label\": \"URL\", \"required\": true}]}','
\r\n \r\n
\r\n
\r\n
\r\n
{{$data[\'sub_heading\']}}
\r\n
{{$data[\'main_heading\']}}
\r\n
{{$data[\'content\']}}
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
',1,'2025-06-09 23:14:04','2025-06-09 23:16:17',NULL,NULL,NULL),(12,'Parallex Section',1,'{\"fields\": [{\"name\": \"main_heading\", \"type\": \"text\", \"label\": \"Main Heading\", \"required\": true}, {\"name\": \"content\", \"type\": \"textarea\", \"label\": \"Content\", \"advance\": true, \"required\": true}, {\"name\": \"Image\", \"type\": \"file\", \"label\": \"File\", \"required\": true}]}','
\r\n \r\n
\r\n
\r\n
\r\n
\r\n
Expansion & Industrial Growth
\r\n
\r\n - 1965 – The Security Papers Limited (SPL) was established to manufacture banknote\r\n paper within Pakistan. This\r\n significantly reduced PSPC’s reliance on imported security paper.
\r\n - 1982 – A new banknote factory building was constructed, equipped with modern\r\n printing machinery. The existing banknote\r\n production was shifted to the new facility, enhancing PSPC’s capacity and efficiency.
\r\n - 1995 – PSPC reduced its dependence on imported security inks by forming a joint\r\n venture with SICPA (Switzerland). This\r\n led to the establishment of a local ink manufacturing facility, ensuring high-quality and locally\r\n produced security inks\r\n for banknote printing.
\r\n
\r\n
\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n
',1,'2025-06-10 21:58:51','2025-06-10 21:58:51',NULL,NULL,NULL);
/*!40000 ALTER TABLE `components` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `failed_jobs`
--
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `failed_jobs`
--
LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job_batches`
--
DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_batches` (
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`total_jobs` int NOT NULL,
`pending_jobs` int NOT NULL,
`failed_jobs` int NOT NULL,
`failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`cancelled_at` int DEFAULT NULL,
`created_at` int NOT NULL,
`finished_at` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job_batches`
--
LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jobs`
--
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint unsigned NOT NULL,
`reserved_at` int unsigned DEFAULT NULL,
`available_at` int unsigned NOT NULL,
`created_at` int unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jobs`
--
LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menus`
--
DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `menus` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`parent_id` bigint unsigned DEFAULT NULL,
`title` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`title_ur` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`redirection_type` tinyint NOT NULL COMMENT '1 = Redirect to Page, 2 = Redirect to Route, 3 = Redirect to External Link',
`page_id` bigint unsigned DEFAULT NULL,
`route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint(1) NOT NULL DEFAULT '0',
`sorting` int NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `menus_parent_id_foreign` (`parent_id`),
KEY `menus_page_id_foreign` (`page_id`),
CONSTRAINT `menus_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE SET NULL,
CONSTRAINT `menus_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `menus` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `menus`
--
LOCK TABLES `menus` WRITE;
/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
INSERT INTO `menus` (`id`, `parent_id`, `title`, `title_ur`, `redirection_type`, `page_id`, `route`, `url`, `status`, `sorting`, `created_at`, `updated_at`, `deleted_at`) VALUES (43,NULL,'Home','ہوم پیج',2,NULL,'website.index',NULL,1,0,'2025-05-14 19:53:54','2025-06-09 20:46:00',NULL),(44,NULL,'About','تعرف',3,NULL,NULL,'http://pspc-deployment.test',1,0,'2025-05-14 20:44:37','2025-05-14 20:44:37',NULL),(45,44,'Who we are','ہم کون ہیں',1,1464,NULL,NULL,1,1,'2025-05-14 20:45:16','2025-06-09 20:43:04',NULL),(47,44,'History of PSPC','پی ایس پی سی کی تاریخ',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-14 21:05:40','2025-05-14 23:16:04',NULL),(48,44,'Our Commitment','ہمارا عزم',3,NULL,NULL,'http://pspc-deployment.test/en',1,3,'2025-05-14 23:14:14','2025-05-14 23:14:14',NULL),(49,44,'Board of Directors','بورڈ آف ڈائریکٹرز',3,NULL,NULL,'http://pspc-deployment.test/en',1,4,'2025-05-14 23:17:42','2025-05-14 23:17:42',NULL),(50,44,'Management Team','انتظامی ٹیم',3,NULL,NULL,'http://pspc-deployment.test/en',1,5,'2025-05-14 23:18:02','2025-05-15 00:23:53',NULL),(51,44,'MD Message','ایم ڈی کا پیغام',3,NULL,NULL,'http://pspc-deployment.test/en',1,6,'2025-05-14 23:18:32','2025-05-14 23:18:32',NULL),(52,44,'Our Stakeholders','ہمارے اسٹیک ہولڈرز',3,NULL,NULL,'http://pspc-deployment.test/en',1,7,'2025-05-14 23:18:57','2025-05-15 00:23:42',NULL),(53,NULL,'Products','مصنوعات',3,NULL,NULL,'http://pspc-deployment.test/en',1,3,'2025-05-14 23:20:04','2025-05-15 01:35:06',NULL),(54,53,'Banknote/Currency','نوٹ / کرنسی',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 00:24:59','2025-05-15 00:25:17',NULL),(55,53,'Prize Bonds','انعامی بانڈز',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-15 00:25:56','2025-05-15 00:25:56',NULL),(56,53,'Other Security Products','دیگر سیکیورٹی مصنوعات',3,NULL,NULL,'http://pspc-deployment.test/en',1,3,'2025-05-15 00:26:25','2025-05-15 00:26:25',NULL),(57,56,'Passports','پاسپورٹ',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 00:26:55','2025-05-15 00:26:55',NULL),(58,56,'Degrees & Transcripts','اسناد اور نقلِ درجات',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-15 00:27:57','2025-05-15 00:27:57',NULL),(59,53,'Banknotes History','کرنسی نوٹوں کی تاریخ',3,NULL,NULL,'http://pspc-deployment.test/en',1,4,'2025-05-15 00:28:40','2025-05-15 00:44:21',NULL),(60,56,'Bank Cheques','بینک چیکس',3,NULL,NULL,'http://pspc-deployment.test/en',1,3,'2025-05-15 00:31:04','2025-05-15 00:31:04',NULL),(61,56,'Stamps','تمبر',3,NULL,NULL,'http://pspc-deployment.test/en',1,4,'2025-05-15 00:35:36','2025-05-15 00:35:36',NULL),(62,56,'Real State Documents','جائیداد کے دستاویزات',3,NULL,NULL,'http://pspc-deployment.test/en',1,5,'2025-05-15 00:37:42','2025-05-15 00:37:42',NULL),(63,56,'Parchments / Awards','سرٹیفکیٹس / ایوارڈز',3,NULL,NULL,'http://pspc-deployment.test/en',1,6,'2025-05-15 00:38:16','2025-05-15 00:38:16',NULL),(64,56,'Ballot Papers','بیلٹ پیپرز',3,NULL,NULL,'http://pspc-deployment.test/en',1,7,'2025-05-15 00:39:28','2025-05-15 00:39:28',NULL),(65,56,'Cards','کارڈز',3,NULL,NULL,'http://pspc-deployment.test/en',1,8,'2025-05-15 00:39:45','2025-05-15 00:39:45',NULL),(66,56,'Educational Credentials','تعلیمی اسناد',3,NULL,NULL,'http://pspc-deployment.test/en',1,9,'2025-05-15 00:41:00','2025-05-15 00:41:00',NULL),(67,NULL,'Expertise','مہارت',3,NULL,NULL,'http://pspc-deployment.test/en',1,4,'2025-05-15 00:42:21','2025-05-15 00:42:21',NULL),(68,67,'Technology','ٹیکنالوجی',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 00:46:29','2025-05-15 00:46:29',NULL),(69,67,'Printed Security Features','پرنٹی حفاظتی عناصر',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-15 00:47:11','2025-05-15 00:47:11',NULL),(70,67,'Subsidiaries Features','سبسڈری خصوصیات',3,NULL,NULL,'http://pspc-deployment.test/en',1,3,'2025-05-15 00:47:59','2025-05-15 00:47:59',NULL),(71,70,'Embedded Security Features','ایمبیڈڈ سیکیورٹی خصوصیات',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 00:49:01','2025-05-15 00:49:01',NULL),(72,70,'Specialized Security Inks','مخصوص سیکیورٹی انکس',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-15 00:49:18','2025-05-15 00:49:18',NULL),(73,NULL,'Media','میڈیا',3,NULL,NULL,'http://pspc-deployment.test/en',1,5,'2025-05-15 00:49:47','2025-05-15 00:49:47',NULL),(74,73,'Project & Videos','پروجیکٹس اور ویڈیوز',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 00:50:19','2025-05-15 00:50:19',NULL),(75,73,'Events','تقریبات',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-15 00:50:41','2025-05-15 00:50:41',NULL),(76,NULL,'Sustainability','پائیداری',3,NULL,NULL,'http://pspc-deployment.test/en',1,6,'2025-05-15 00:51:17','2025-05-15 00:51:17',NULL),(77,76,'ESG','ای ایس جی',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 00:52:12','2025-05-15 00:52:12',NULL),(78,76,'QHSE','کیو ایچ ایس ای',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-15 00:52:34','2025-05-15 00:52:34',NULL),(79,NULL,'Tender','ٹینڈر',3,NULL,NULL,'http://pspc-deployment.test/en',1,7,'2025-05-15 01:06:51','2025-05-15 01:06:51',NULL),(80,79,'Download Tender','ٹینڈر ڈاؤن لوڈ کریں',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 01:08:08','2025-05-15 01:08:08',NULL),(81,79,'Tender History','ٹینڈر کی تاریخ',3,NULL,NULL,'http://pspc-deployment.test/en',1,2,'2025-05-15 01:08:22','2025-05-15 01:08:22',NULL),(82,79,'Evaluation Report','تشخیصی رپورٹ',3,NULL,NULL,'http://pspc-deployment.test/en',1,3,'2025-05-15 01:08:38','2025-05-15 01:08:38',NULL),(83,79,'Sign In / Sign Up','سائن ان / سائن اپ',3,NULL,NULL,'http://pspc-deployment.test/en',1,4,'2025-05-15 01:09:03','2025-05-15 01:09:15',NULL),(84,NULL,'E-Hiring','ای-ہائرنگ',3,NULL,NULL,'http://pspc-deployment.test/en',1,8,'2025-05-15 01:15:12','2025-05-15 01:15:12',NULL),(85,84,'Join Our Team','ہماری ٹیم میں شامل ہوں',3,NULL,NULL,'http://pspc-deployment.test/en',1,1,'2025-05-15 01:15:29','2025-05-15 01:15:29',NULL),(86,NULL,'Contact','رابطہ کریں',3,NULL,NULL,'http://pspc-deployment.test/en',1,9,'2025-05-15 01:16:12','2025-05-15 01:16:12',NULL);
/*!40000 ALTER TABLE `menus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migrations`
--
LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (7,'0001_01_01_000000_create_users_table',1),(8,'0001_01_01_000001_create_cache_table',1),(9,'0001_01_01_000002_create_jobs_table',1),(10,'2025_05_05_053054_create_permission_tables',1),(11,'2025_05_05_053403_create_admins_table',1),(12,'2025_05_05_120607_create_menus_table',1),(13,'2025_05_06_064030_create_pages_table',2),(14,'2025_05_06_064717_update_menus_table_add_status_and_foreign_keys',3),(15,'2025_05_06_102447_change_image_column_in_pages_table',4),(18,'2025_05_07_122647_update_menus_add_url',5),(19,'2025_05_08_093949_add_slug_to_pages_table',5),(20,'2025_05_09_055932_create_components_table',6),(21,'2025_05_12_070235_create_page_components_table',7),(22,'2025_05_12_111321_add_javascript_css_to_components_table',7),(23,'2025_05_12_111507_remove_related_id_from_page_components_table',8),(24,'2025_05_14_064617_add_type_to_components_table',9),(27,'2025_05_14_072101_update_page_components_table_add_parent_id_and_fields_data',10),(28,'2025_05_14_105807_update_page_components_table_add_title',10),(29,'2025_05_15_061845_update_menus_table_add_sorting',11),(30,'2025_05_19_120726_add_is_homepage_to_pages_table',12),(31,'2025_05_21_111839_update_components_unique_index_for_soft_deletes',13),(32,'2025_06_12_113453_create_tender_persons_table',14),(33,'2025_06_12_113519_create_tender_categories_table',14),(34,'2025_06_12_113747_create_tenders_table',14),(38,'2025_06_12_114212_add_tender_person_id_to_tenders_table',15);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `model_has_permissions`
--
DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
`permission_id` bigint unsigned NOT NULL,
`model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `model_has_permissions`
--
LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `model_has_roles`
--
DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
`role_id` bigint unsigned NOT NULL,
`model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint unsigned NOT NULL,
PRIMARY KEY (`role_id`,`model_id`,`model_type`),
KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `model_has_roles`
--
LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES (1,'App\\Models\\Admin',1),(2,'App\\Models\\Admin',3),(3,'App\\Models\\Admin',4);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `page_components`
--
DROP TABLE IF EXISTS `page_components`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_components` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`parent_id` bigint unsigned DEFAULT NULL,
`page_id` bigint unsigned NOT NULL,
`type` tinyint NOT NULL,
`component_id` bigint unsigned DEFAULT NULL,
`related_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fields_data` json DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`sorting` int NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `page_components_page_id_foreign` (`page_id`),
KEY `page_components_component_id_foreign` (`component_id`),
KEY `page_components_parent_id_foreign` (`parent_id`),
CONSTRAINT `page_components_component_id_foreign` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE SET NULL,
CONSTRAINT `page_components_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE,
CONSTRAINT `page_components_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `page_components` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `page_components`
--
LOCK TABLES `page_components` WRITE;
/*!40000 ALTER TABLE `page_components` DISABLE KEYS */;
INSERT INTO `page_components` (`id`, `title`, `parent_id`, `page_id`, `type`, `component_id`, `related_type`, `fields_data`, `status`, `sorting`, `created_at`, `updated_at`, `deleted_at`) VALUES (8,'Home Page Hero Section',NULL,1464,1,5,NULL,'{\"media\": \"uploads/page-components/media/hrevJynuYrtAaZGyycrtIf6q3zXsSTLI6lvSdkVh.mp4\", \"heading\": \"Pakistan Security Printing Corporation (Pvt.) Ltd\", \"tagline\": \"Upholding trust and security with decades of expertise, delivering innovative and reliable printing solutions.\", \"heading_ur\": \"پاکستان سیکورٹی پرنٹنگ کارپوریشن (پرائیویٹ) لمیٹڈ\", \"tagline_ur\": \"کئی دہائیوں کی مہارت کے ساتھ اعتماد اور تحفظ کو برقرار رکھنا، جدید اور قابل اعتماد پرنٹنگ حل فراہم کرنا۔\"}',1,1,'2025-05-21 02:03:14','2025-06-17 01:14:14',NULL),(10,'Home Page About Section',NULL,1464,1,6,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"content\": \"With over 75 years of excellence, Pakistan Security Printing Corporation stands as the leading and sole organization of its kind in the country. Leveraging cutting-edge technology and unmatched expertise, we specialize in producing a wide range of security products for Pakistan and have also provided currency printing Products for international clients in the past. Our commitment to security and quality ensures trusted solutions for our valued partners.\", \"picture_one\": \"uploads/page-components/media/qrl5c1O9JDp5QFYWGAR2ZxinwYwPtZCLPLubeoi9.png\", \"picture_two\": \"uploads/page-components/media/455c1TwQ5bzkfVHA02E9mJwmwYBAoX0k9IarJcKp.png\", \"sub_heading\": null, \"main_heading\": \"Trusted, Secure, Innovative\"}',1,2,'2025-05-22 00:31:40','2025-06-15 21:03:15',NULL),(11,'Home page what we offer section',NULL,1464,1,7,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"content\": \"We offer a wide range of Products designed to meet the evolving demands of our clients. From concept to execution, we ensure quality, efficiency, and satisfaction at every step.\", \"sub_heading\": \"What We Offer\", \"main_heading\": \"Delivering Innovative Solutions Tailored to Your Needs\"}',1,3,'2025-05-22 00:37:28','2025-05-22 01:00:16',NULL),(12,'Home page stake holders section',NULL,1464,1,8,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"content\": \"We believe in fostering long-term partnerships with our stakeholders based on trust, transparency, and mutual respect. Their continued support plays a vital role in achieving our mission and delivering excellence.\", \"sub_heading\": \"Our Stakeholders\", \"main_heading\": \"Building Strong Relationships with Our Valued Stakeholders\"}',1,4,'2025-05-22 00:42:34','2025-05-22 00:42:34',NULL),(13,'Home page culture section',NULL,1464,1,9,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"content\": \"At PSPC, we foster a culture of continuous learning and development, where employees are empowered to grow and excel.\", \"main_heading\": \"Our Culture at a Glance\"}',1,5,'2025-05-22 00:47:45','2025-05-22 00:47:45',NULL),(17,'ESG Section',NULL,1464,1,10,NULL,'{\"main_heading\": \"ESG\"}',1,6,'2025-05-23 02:26:30','2025-05-23 02:26:30',NULL),(19,'ESG Section 1',17,1464,1,10,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"image\": \"uploads/page-components/media/0R6LyJgJxfrMHb6VfxpjGy3T4oFoeTWrdn6loBHC.jpg\", \"main_title\": \"Environmental Stewardship\"}',1,1,'2025-05-23 02:32:01','2025-05-25 19:47:41',NULL),(20,'ESG Section 2',17,1464,1,10,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"image\": \"uploads/page-components/media/0K6Arkr6yQiIEexpsjZgq5gtfaqKrIX0fJHQcVCp.jpg\", \"main_title\": \"Social Responsibility\"}',1,2,'2025-05-25 19:54:27','2025-05-25 19:54:27',NULL),(21,'ESG Section 3',17,1464,1,10,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"image\": \"uploads/page-components/media/OItpbQ63nYpc8YLTc6mzQZ0bouSEUqlAC0FJ92Br.png\", \"main_title\": \"Governance & Administration\"}',1,3,'2025-05-25 19:55:32','2025-05-25 19:55:32',NULL),(22,'Awards & Certificates (Home Page)',NULL,1464,1,11,NULL,'{\"url\": \"http://pspc-deployment.test/en\", \"content\": \"We have earned a distinguished portfolio of QHSE Awards and Certifications that reflect our unwavering commitment to quality, health, safety, and environmental excellence.\", \"sub_heading\": \"Our Certificates\", \"main_heading\": \"QHSE Awards and Certificates\"}',1,7,'2025-06-09 23:15:29','2025-06-09 23:16:36',NULL),(23,'hero',NULL,1464,1,5,NULL,'{\"media\": \"uploads/page-components/media/nJ0XI0qDqfaDsXFjxgRmt5oGhRn7tNNvHMKQedn4.mp4\", \"heading\": \"Pakistan Security Printing Corporation (Pvt.) Ltd\", \"tagline\": \"Upholding trust and security with decades of expertise, delivering innovative and reliable printing solutions.\", \"heading_ur\": \"پاکستان سیکورٹی پرنٹنگ کارپوریشن (پرائیویٹ) لمیٹڈ\", \"tagline_ur\": \"کئی دہائیوں کی مہارت کے ساتھ اعتماد اور تحفظ کو برقرار رکھنا، جدید اور قابل اعتماد پرنٹنگ حل فراہم کرنا۔\"}',1,10,'2025-06-16 05:25:25','2025-06-16 05:25:25',NULL);
/*!40000 ALTER TABLE `page_components` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pages` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title_ur` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`description_ur` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint(1) NOT NULL DEFAULT '0',
`is_homepage` tinyint(1) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=1466 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pages`
--
LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` (`id`, `title`, `title_ur`, `slug`, `description`, `description_ur`, `image`, `meta_title`, `meta_description`, `meta_keywords`, `status`, `is_homepage`, `created_at`, `updated_at`, `deleted_at`) VALUES (1464,'Home Page','ہوم پیج','home-page','
Pakistan Security Printing Corporation (Pvt.) Limited is a government-owned organization responsible for printing secure and high-quality documents, including currency notes, passports, stamps, and other confidential materials. Our mission is to ensure trust, security, and technological excellence in the field of secure printing, serving both national and international clients with integrity and professionalism.
','
پاکستان سیکیورٹی پرنٹنگ کارپوریشن (پرائیویٹ) لمیٹڈ ایک سرکاری ادارہ ہے جو کرنسی نوٹ، پاسپورٹ، اسٹامپ اور دیگر حساس دستاویزات کی محفوظ اور معیاری طباعت کا ذمہ دار ہے۔ ہمارا مشن اعتماد، سلامتی اور ٹیکنالوجی کے اعلیٰ معیار کو یقینی بناتے ہوئے قومی و بین الاقوامی سطح پر طباعت کی خدمات فراہم کرنا ہے۔
','uploads/pages/images/SAx2NT3E3MWsWQ2q9SlNhixkfJ2rN6YiVIZ65Jdq.jpg','Pakistan Security Printing Corporation | Official Government Secure Printing','Pakistan Security Printing Corporation (Pvt.) Limited is the official provider of secure printing solutions including currency, passports, stamps, and confidential documents for the Government of Pakistan and international clients.','Pakistan Security Printing Corporation, PSPC, secure printing Pakistan, currency printing, passport printing, government printing, confidential documents, official printing, national security printing, PSPC Pakistan',1,1,'2025-05-18 19:41:06','2025-05-18 19:53:10',NULL),(1465,'Who we are','ہم کون ہیں','who-we-are','
Who we are
','
Who we are
','uploads/pages/images/lrDwW9dlhZyTwJl7m1mVXfDGyifcbnVGQVYnjoqZ.png','who-we-are','who-we-are','who-we-are',1,NULL,'2025-06-15 20:44:50','2025-06-15 20:44:50',NULL);
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_reset_tokens`
--
DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_reset_tokens`
--
LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `permissions`
--
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `permissions`
--
LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1,'admin-create','admin','2025-05-05 02:54:21','2025-05-05 23:11:09'),(2,'admin-edit','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(3,'admin-delete','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(4,'admin-list','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(5,'role-create','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(6,'role-edit','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(7,'role-delete','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(8,'role-list','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(10,'permission-edit','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(11,'permission-delete','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(12,'permission-list','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(13,'permission-create','admin','2025-05-05 21:22:58','2025-05-05 21:22:58'),(14,'page-create','admin','2025-05-05 23:26:10','2025-05-05 23:26:10'),(15,'page-edit','admin','2025-05-05 23:26:18','2025-05-05 23:26:18'),(16,'page-list','admin','2025-05-05 23:26:25','2025-05-05 23:26:25'),(17,'page-delete','admin','2025-05-05 23:26:31','2025-05-08 20:09:40'),(18,'menu-create','admin','2025-05-07 01:44:17','2025-05-07 01:44:17'),(19,'menu-edit','admin','2025-05-07 01:44:28','2025-05-07 01:44:28'),(20,'menu-delete','admin','2025-05-07 01:44:37','2025-05-07 01:44:37'),(21,'menu-list','admin','2025-05-07 01:44:45','2025-05-07 01:44:45'),(22,'component-create','admin','2025-05-08 20:08:49','2025-05-09 02:01:26'),(23,'component-edit','admin','2025-05-08 20:08:55','2025-05-09 02:01:30'),(24,'component-list','admin','2025-05-08 20:09:08','2025-05-09 02:01:37'),(25,'component-delete','admin','2025-05-08 20:09:20','2025-05-09 02:01:41'),(26,'website-user','admin','2025-06-11 19:26:08','2025-06-11 19:26:08'),(27,'tender-user','admin','2025-06-11 19:26:15','2025-06-11 19:26:15'),(28,'tender-create','admin','2025-06-11 20:33:23','2025-06-11 20:33:23'),(29,'tender-edit','admin','2025-06-12 01:57:37','2025-06-12 01:57:37'),(30,'tender-list','admin','2025-06-12 01:57:45','2025-06-12 01:57:45'),(31,'tender-delete','admin','2025-06-12 01:57:50','2025-06-12 01:57:50'),(32,'tender-person-create','admin','2025-06-12 01:59:09','2025-06-12 01:59:09'),(33,'tender-person-edit','admin','2025-06-12 01:59:13','2025-06-12 01:59:13'),(34,'tender-person-list','admin','2025-06-12 01:59:19','2025-06-12 01:59:19'),(35,'tender-person-delete','admin','2025-06-12 01:59:32','2025-06-12 01:59:32'),(36,'tender-category-create','admin','2025-06-12 01:59:45','2025-06-12 01:59:45'),(37,'tender-category-edit','admin','2025-06-12 01:59:49','2025-06-12 01:59:49'),(38,'tender-category-list','admin','2025-06-12 01:59:53','2025-06-12 01:59:53'),(39,'tender-category-delete','admin','2025-06-12 01:59:58','2025-06-12 01:59:58');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role_has_permissions`
--
DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
`permission_id` bigint unsigned NOT NULL,
`role_id` bigint unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`role_id`),
KEY `role_has_permissions_role_id_foreign` (`role_id`),
CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role_has_permissions`
--
LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(26,2),(1,3),(2,3),(3,3),(4,3),(27,3),(28,3),(29,3),(30,3),(31,3),(32,3),(33,3),(34,3),(35,3),(36,3),(37,3),(38,3),(39,3);
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1,'Super Admin','admin','2025-05-05 02:54:21','2025-05-05 02:54:21'),(2,'Website User','admin','2025-05-05 02:59:03','2025-06-11 19:31:09'),(3,'Tender User','admin','2025-06-11 19:32:32','2025-06-11 19:32:32');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint unsigned DEFAULT NULL,
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`last_activity` int NOT NULL,
PRIMARY KEY (`id`),
KEY `sessions_user_id_index` (`user_id`),
KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sessions`
--
LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('1DKKYWmeOttB1JVURJUiMu4UfvgIVUtJOOWqu1Vv',NULL,'27.115.124.33','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_0) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNWVPRG5jNDdWQjMwMzBFWTRVV1pkb2dtV09qcEhnU1NXNWtMYmsweSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTg6Imh0dHA6Ly9sYXJhdmVsMTEud3BzdGFnaW5nLmEyemNyZWF0b3J6LmNvbS9wc3BjLWRlcGxveW1lbnQiO319',1769902522),('1GgGyKQAyuiLUUlLVHWcrPKsmBvUQenZmUjF4QfT',NULL,'167.94.146.59','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoibjVpNmxRUU1Sb05VcVg2TDdETlhCM2xMcDVDMHRGbXpESFNMNHhMOSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vNjQuMjcuNTIuMjEwL3BzcGMtZGVwbG95bWVudCI7fX0=',1769976183),('75pK5i4ZrYH1VvECoAQCZApfDi5eqZMk5E1oxSod',NULL,'94.102.49.193','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiREk1aXVZNkxMTXl2SnNKNWczbzI2R2c3U2RONmJrY2pMaEFuZXZsYiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319fQ==',1770124589),('KFwwqBQuFb0AV5a3bvVFe4npg3RL6sXDxG6Yleno',NULL,'167.94.146.58','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidmJxZXlybldkMW9sYXppNTNlT1BhNlVHdWF1cmNub2lVM2lYT1VyRiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vNjQuMjcuNTIuMjEwL3BzcGMtZGVwbG95bWVudCI7fX0=',1770209633),('mb1VmoOIknkhR1phpK3G3yODLq7E4ErL1uZCHvCz',NULL,'27.115.124.114','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_0) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11','YTozOntzOjY6Il90b2tlbiI7czo0MDoibm51OUhJMWNHb0hBOXdaVTJjMDk3b1FsMzhXRUZ3R013QkpUQThEcCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vbWFpbC5ldmFtdXNpcXVlLmNvbS9wc3BjLWRlcGxveW1lbnQiO319',1769914258),('NdlsFaGl2kqVNzYhNkmbxHMih3D0tvsbC2PuFoRc',NULL,'35.195.151.21','Mozilla/5.0 (Windows NT 10.0; rv:78.0) Gecko/20100101 Firefox/78.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoieER4VHVmTUQxVUh3eG1uQ0RXSVhFc3VjQ01KZTJPU1JGZGdzMEdtZyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTQ6Imh0dHBzOi8vc2VydmVyMTUtcHRyLTEwLmEyemNyZWF0b3J6LmNhL3BzcGMtZGVwbG95bWVudCI7fX0=',1770071448),('nWbCBnYLpZP5r4cxiU14epNO6pwKJflE0xNjPvgj',1,'110.93.237.252','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoicnNlY0d2Sno1eml3dkxjd25SaVQ4UTgybUR4Z0VCTHk0enlNR2ZoZyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjI6Imh0dHBzOi8vbGFyYXZlbDExLndwc3RhZ2luZy5hMnpjcmVhdG9yei5jb20vcHNwYy1kZXBsb3ltZW50L2VuIjt9czo2OiJsb2NhbGUiO3M6MjoiZW4iO3M6NTI6ImxvZ2luX2FkbWluXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1750143635),('PFiToZO3mi3Nk0k87WoXHmCenIDlDQeKd7XCN4jM',NULL,'34.76.210.200','Mozilla/5.0 (Windows NT 10.0; rv:78.0) Gecko/20100101 Firefox/78.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoidXN4WjNKSU1pYkJZS1gydlc3Z0REM3UybGdQQTBsUDRSc3dMcnFHUiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vNjQuMjcuNTIuMjEwL3BzcGMtZGVwbG95bWVudCI7fX0=',1769832399),('so44hQtGZ3oYt3JDt75YfS4Mr6CP0xtasA42ZAqh',NULL,'167.94.146.57','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNmxIczRwcGgxckl0dDJRN0FYZFVHWE9zajFxRkpDUUVMcGNyM1JteiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vNjQuMjcuNTIuMjEwL3BzcGMtZGVwbG95bWVudCI7fX0=',1770828438);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tender_categories`
--
DROP TABLE IF EXISTS `tender_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tender_categories` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `tender_categories_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tender_categories`
--
LOCK TABLES `tender_categories` WRITE;
/*!40000 ALTER TABLE `tender_categories` DISABLE KEYS */;
INSERT INTO `tender_categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'asd','2025-06-13 01:50:37','2025-06-13 02:05:05','2025-06-13 02:05:05'),(2,'GOODS','2025-06-13 01:51:39','2025-06-13 01:51:39',NULL);
/*!40000 ALTER TABLE `tender_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tender_persons`
--
DROP TABLE IF EXISTS `tender_persons`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tender_persons` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `tender_persons_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tender_persons`
--
LOCK TABLES `tender_persons` WRITE;
/*!40000 ALTER TABLE `tender_persons` DISABLE KEYS */;
INSERT INTO `tender_persons` (`id`, `name`, `email`, `phone`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'Yasir Jawed','engr.yasirjawed@gmail.com','03353657876','2025-06-12 20:13:52','2025-06-13 02:03:20',NULL),(2,'HASEEB','haseeb@techempire.com','335477987','2025-06-12 20:28:02','2025-06-12 21:53:17','2025-06-12 21:53:17');
/*!40000 ALTER TABLE `tender_persons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tenders`
--
DROP TABLE IF EXISTS `tenders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tenders` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`ref_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`participation_closing_date` date NOT NULL,
`participation_closing_time` time NOT NULL,
`bids_opening_date` date NOT NULL,
`bids_opening_time` time NOT NULL,
`tender_person_id` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tenders_tender_person_id_foreign` (`tender_person_id`),
CONSTRAINT `tenders_tender_person_id_foreign` FOREIGN KEY (`tender_person_id`) REFERENCES `tender_persons` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tenders`
--
LOCK TABLES `tenders` WRITE;
/*!40000 ALTER TABLE `tenders` DISABLE KEYS */;
/*!40000 ALTER TABLE `tenders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`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_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping events for database 'laravel11_pspc-deployment'
--
--
-- Dumping routines for database 'laravel11_pspc-deployment'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2026-02-12 12:16:19