CREATE DATABASE  IF NOT EXISTS `medical_center_db`;
USE `medical_center_db`;
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);



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');

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');

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);

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');
