CREATE DATABASE  IF NOT EXISTS `medical_center_db`;
USE `medical_center_db`;
SET FOREIGN_KEY_CHECKS=0;
LOCK TABLES `permission_role` WRITE;
INSERT INTO `permission_role` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,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),(24,1),(25,1),(26,1),(1,2),(2,2),(3,2),(4,2),(8,2),(9,2),(12,2),(13,2),(16,2),(21,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(7,3),(8,3),(9,3),(10,3),(11,3),(12,3),(13,3),(14,3),(15,3),(16,3),(17,3),(18,3),(19,3),(20,3),(21,3),(22,3),(23,3),(24,3),(25,3),(26,3),(1,4),(2,4),(3,4),(4,4),(5,4),(6,4),(7,4),(8,4),(9,4),(10,4),(11,4),(12,4),(13,4),(14,4),(15,4),(16,4),(17,4),(18,4),(19,4),(20,4),(21,4),(22,4),(23,4),(24,4),(25,4),(26,4),(27,4),(28,4),(29,4);
UNLOCK TABLES;

LOCK TABLES `permissions` WRITE;
INSERT INTO `permissions` VALUES (1,'create-appointment','Create Appointment','Create Appointment','2023-03-12 15:19:25','2023-03-12 15:19:25'),(2,'update-appointment','Update Appointment','Update Appointment','2023-03-12 15:19:25','2023-03-12 15:19:25'),(3,'delete-appointment','Delete Appointment','Delete Appointment','2023-03-12 15:19:25','2023-03-12 15:19:25'),(4,'view-appointment','View Appointment','View Appointment','2023-03-12 15:19:25','2023-03-12 15:19:25'),(5,'create-history','Create History','Create History','2023-03-12 15:19:25','2023-03-12 15:19:25'),(6,'update-history','Update History','Update History','2023-03-12 15:19:26','2023-03-12 15:19:26'),(7,'delete-history','Delete History','Delete History','2023-03-12 15:19:26','2023-03-12 15:19:26'),(8,'view-history','View History','View History','2023-03-12 15:19:26','2023-03-12 15:19:26'),(9,'create-patient','Create Patient','Create Patient','2023-03-12 15:19:26','2023-03-12 15:19:26'),(10,'update-patient','Update Patient','Update Patient','2023-03-12 15:19:26','2023-03-12 15:19:26'),(11,'delete-patient','Delete Patient','Delete Patient','2023-03-12 15:19:26','2023-03-12 15:19:26'),(12,'view-patient','View Patient','View Patient','2023-03-12 15:19:27','2023-03-12 15:19:27'),(13,'create-representative','Create Representative','Create Representative','2023-03-12 15:19:27','2023-03-12 15:19:27'),(14,'update-representative','Update Representative','Update Representative','2023-03-12 15:19:27','2023-03-12 15:19:27'),(15,'delete-representative','Delete Representative','Delete Representative','2023-03-12 15:19:27','2023-03-12 15:19:27'),(16,'view-representative','View Representative','View Representative','2023-03-12 15:19:27','2023-03-12 15:19:27'),(17,'create-user','Create User','Create User','2023-03-12 15:19:27','2023-03-12 15:19:27'),(18,'update-user','Update User','Update User','2023-03-12 15:19:28','2023-03-12 15:19:28'),(19,'delete-user','Delete User','Delete User','2023-03-12 15:19:28','2023-03-12 15:19:28'),(20,'view-user','View User','View User','2023-03-12 15:19:28','2023-03-12 15:19:28'),(21,'view-area','View Area','View Area','2023-03-12 15:19:28','2023-03-12 15:19:28'),(22,'create-area','Create Area','Create Area','2023-03-12 15:19:28','2023-03-12 15:19:28'),(23,'update-area','Update Area','Update Area','2023-03-12 15:19:28','2023-03-12 15:19:28'),(24,'create-control-history','Create Control History','Create Control History','2023-03-12 15:19:28','2023-03-12 15:19:28'),(25,'update-control-history','Update Control History','Update Control History','2023-03-12 15:19:28','2023-03-12 15:19:28'),(26,'download-history','Download History','Download History','2023-03-12 15:19:28','2023-03-12 15:19:28'),(27,'view-config','View Config','View Config','2023-03-12 15:19:28','2023-03-12 15:19:28'),(28,'create-config','Create Config','Create Config','2023-03-12 15:19:28','2023-03-12 15:19:28'),(29,'update-config','Update Config','Update Config','2023-03-12 15:19:28','2023-03-12 15:19:28');
UNLOCK TABLES;

LOCK TABLES `roles` WRITE;
INSERT INTO `roles` VALUES (1,'doctor','Doctor','Doctor','2023-03-12 15:19:24','2023-03-12 15:19:24'),(2,'receptionist','Receptionist','Receptionist','2023-03-12 15:19:24','2023-03-12 15:19:24'),(3,'admin','User Administrator','User is allowed to manage and edit other users','2023-03-12 15:19:24','2023-03-12 15:19:24'),(4,'root','root','User root','2023-03-12 15:19:24','2023-03-12 15:19:24');
UNLOCK TABLES;

LOCK TABLES `role_user` WRITE;
INSERT INTO `role_user` VALUES (4,14,'App\\Models\\User','2023-04-01 11:59:56','2023-04-01 11:59:56'),(1,15,'App\\Models\\User','2023-04-02 02:27:06','2023-04-02 02:27:06'),(3,16,'App\\Models\\User','2023-04-02 08:33:46','2023-04-02 08:33:46'),(2,17,'App\\Models\\User','2023-04-20 01:09:16','2023-04-20 01:09:16');
UNLOCK TABLES;

LOCK TABLES `section_type` WRITE;
INSERT INTO `section_type` VALUES ('011ecee7d295c066ae68d4396215c3d0','28c8edde3d61a0411511d3b1866f0636','BDEV','Developer_Background','2022-09-05 23:20:26','4',NULL),('28c8edde3d61a0411511d3b1866f0636',NULL,'BACK','Background','2022-09-05 23:16:07','0',NULL),('38026ed22fc1a91d92b5d2ef93540f20','28c8edde3d61a0411511d3b1866f0636','BPTA','Perinatal_Background','2022-09-05 23:18:28','2',NULL),('3d2f8900f2e49c02b481c2f717aa9020','28c8edde3d61a0411511d3b1866f0636','BINM','Immunizations_Background','2022-09-05 23:25:51','6',NULL),('4c0d13d3ad6cc317017872e51d01b238','28c8edde3d61a0411511d3b1866f0636','SALM','Alimentation','2022-09-05 23:30:32','3',NULL),('4e44f1ac85cd60e3caa56bfd4afb675e','28c8edde3d61a0411511d3b1866f0636','BPSI','Psychobiology_Background','2022-09-05 23:23:03','5',NULL),('665f644e43731ff9db3d341da5c827e1','28c8edde3d61a0411511d3b1866f0636','BPER','Personal_Background','2022-09-05 23:17:13','7',NULL),('7bfc85c0d74ff05806e0b5a0fa0c1df1','28c8edde3d61a0411511d3b1866f0636','BOTA','Obstetric_Background','2022-09-11 01:42:05','1',NULL),('815e6212def15fe76ed27cec7a393d59','28c8edde3d61a0411511d3b1866f0636','BFAM','Family_Background','2022-09-05 23:29:31','8',NULL),('8d8e353b98d5191d5ceea1aa3eb05d43',NULL,'ANTR','Nutritional_Score','2022-09-05 23:31:28','9',NULL);
UNLOCK TABLES;

LOCK TABLES `users` WRITE;
INSERT INTO `users` VALUES (14,'root','root@root.com',NULL,'$2y$10$SlZ8FkedupD7jFmmqKj7COcM3NHkj.arcOYDCGxQEzwz5LtgJfoYa',NULL,'2023-04-01 07:59:56','2023-04-01 07:59:56');
UNLOCK TABLES;
SET FOREIGN_KEY_CHECKS=1;