-- MySQL dump 10.13  Distrib 8.0.33, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: emedsol_test
-- ------------------------------------------------------
-- Server version	8.0.35

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- 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` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'admin_menu','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(2,'announcement_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(3,'config_parameter_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(4,'user_management_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(5,'permissions_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(6,'roles_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(7,'sample_config_screen_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(8,'treatment_plan_template_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(9,'billing_category_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(10,'hospit_room_bed_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(11,'email_template_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(12,'tv_screen_mapping_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(13,'secretary_menu','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(14,'calendar_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(15,'call_center_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(16,'daily_report_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(17,'sample_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(18,'lab_menu','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(19,'lab_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(20,'lab_tube_configuration_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(21,'lab_ml_configuration_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(22,'lab_config_ref_value_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(23,'imagery_menu','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(24,'imagery_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(25,'pharmacy_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(26,'doctor_menu','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(27,'doctor_agenda_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(28,'nurse_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(29,'hospit_menu','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(30,'hospit_ui','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(31,'receive_expected_time_email_notification','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(32,'approve_lab_result','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(33,'edit_cost','sanctum','2024-04-19 12:48:32','2024-04-19 12:48:32'),(34,'medical_service_ui','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(35,'can_edit_lab_completed_results','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(36,'can_edit_hospit_form','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(37,'can_add_hospit_form','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(38,'can_read_hospit_form','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(39,'can_edit_appointment_cost','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(40,'working_day_template_ui','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(41,'can_delete_visit_scan_image','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(42,'can_upload_visit_scan_image','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(43,'can_edit_cost_on_bill','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(44,'can_edit_quantity_on_bill','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(45,'can_delete_request_on_bill','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(46,'can_assign_vip_to_patient','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(47,'doctor_report_ui','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(48,'medical_service_sold_ui','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(49,'company_report_ui','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(50,'company_extra_report_ui','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(51,'cmd_extra_report_ui','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(52,'report_tabs','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(53,'can_view_patient_file_summary_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(54,'can_view_patient_file_note_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(55,'can_view_patient_file_lab_result_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(56,'can_view_patient_file_imagery_result_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(57,'can_view_patient_file_hospitalization_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(58,'can_view_patient_file_treatment_plan_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(59,'can_view_patient_file_achive_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(60,'can_view_patient_file_appointment_tab','sanctum','2024-04-19 12:48:33','2024-04-19 12:48:33'),(61,'gga_report_ui','sanctum','2024-04-19 12:48:34','2024-04-19 12:48:34'),(62,'report_medical_request_stat_detailed','sanctum','2024-04-19 12:48:34','2024-04-19 12:48:34'),(63,'report_medical_request_stat_per_sub_category','sanctum','2024-04-19 12:48:34','2024-04-19 12:48:34'),(64,'cogs_report_ui','sanctum','2024-04-19 12:48:34','2024-04-19 12:48:34'),(65,'dashboard_menu','sanctum','2024-04-19 12:48:34','2024-04-19 12:48:34'),(66,'company_management_ui','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(67,'company_price_list_ui','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(68,'doctor_percentage_pay_ui','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(69,'patient_extra_report_ui','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(70,'company_group_by_patient_report_ui','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(71,'can_see_pregnant_icon','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(72,'daily_cash_report_ui','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(73,'can_assign_company_to_patient','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(74,'can_unassign_company_to_patient','sanctum','2024-04-19 12:48:35','2024-04-19 12:48:35'),(75,'can_update_covered_amount_on_bill','sanctum','2024-04-19 12:48:37','2024-04-19 12:48:37'),(76,'can_view_inventory_item_ui','sanctum','2024-05-08 07:47:02','2024-05-08 07:47:02'),(77,'can_view_inventory_ui','sanctum','2024-05-08 08:19:12','2024-05-08 08:19:12'),(78,'can_view_inventory_batch_ui','sanctum','2024-05-08 08:19:12','2024-05-08 08:19:12'),(79,'can_configure_daily_cash_close','sanctum','2024-05-08 09:11:23','2024-05-08 09:11:23'),(80,'can_create_inventory_batch','sanctum','2024-05-13 10:26:28','2024-05-13 10:26:28'),(81,'can_edit_inventory_batch','sanctum','2024-05-13 10:26:28','2024-05-13 10:26:28'),(82,'can_delete_inventory_batch','sanctum','2024-05-13 10:26:28','2024-05-13 10:26:28'),(83,'can_add_or_edit_blood_group','sanctum','2024-05-24 07:20:57','2024-05-24 07:20:57'),(84,'can_launch_medical_request','sanctum','2024-05-24 07:20:57','2024-05-24 07:20:57'),(85,'can_show_secretary_note','sanctum','2024-05-24 07:20:58','2024-05-24 07:20:58'),(86,'can_show_deleted_data','sanctum','2024-05-24 07:22:54','2024-05-24 07:22:54'),(87,'can_upload_notes','sanctum','2024-05-30 08:38:48','2024-05-30 08:38:48'),(88,'can_print_patient_file','sanctum','2024-05-30 08:38:48','2024-05-30 08:38:48'),(89,'diagnostic_management_ui','sanctum','2024-06-07 12:17:29','2024-06-07 12:17:29'),(90,'can_create_diagnostic','sanctum','2024-06-07 12:17:29','2024-06-07 12:17:29'),(91,'can_edit_diagnostic','sanctum','2024-06-07 12:17:29','2024-06-07 12:17:29'),(92,'can_delete_diagnostic','sanctum','2024-06-07 12:17:29','2024-06-07 12:17:29'),(93,'location_management_ui','sanctum','2024-06-10 04:36:01','2024-06-10 04:36:01'),(94,'can_create_location','sanctum','2024-06-10 04:36:01','2024-06-10 04:36:01'),(95,'can_edit_location','sanctum','2024-06-10 04:36:01','2024-06-10 04:36:01'),(96,'can_delete_location','sanctum','2024-06-10 04:36:01','2024-06-10 04:36:01'),(97,'can_manage_payment_method','sanctum','2024-06-12 06:33:05','2024-06-12 06:33:05'),(98,'can_create_payment_method','sanctum','2024-06-12 06:34:04','2024-06-12 06:34:04'),(99,'can_edit_payment_method','sanctum','2024-06-12 06:34:04','2024-06-12 06:34:04'),(100,'can_delete_payment_method','sanctum','2024-06-12 06:34:05','2024-06-12 06:34:05'),(101,'can_change_bill_amount_covered','sanctum','2024-06-13 15:14:25','2024-06-13 15:14:25'),(102,'can_show_bill_discount','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(103,'can_add_bill_discount','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(104,'can_change_doctor_on_bill','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(105,'can_change_payment_amount_on_bill','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(106,'can_view_bill_rating','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(107,'can_view_deleted_requests','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(108,'can_add_internal_comment','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(109,'can_add_external_comment','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(110,'can_add_bill_diagnostic','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(111,'can_view_bill_consumables','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(112,'can_view_labs_without_results','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(113,'can_lock_or_unlock_bill','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(114,'can_print_bill_prescription','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26'),(115,'can_view_company_description','sanctum','2024-06-13 15:14:26','2024-06-13 15:14:26');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
/*!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 2024-07-16 11:22:31
