/*
SQLyog Ultimate v10.00 Beta1
MySQL - 8.0.21 : Database - db_icportal
*********************************************************************
*/




CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_icportal` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

/*Data for the table `ic_bed` */

insert  into `ic_bed`(`bed_id`,`ward_no`,`bed_no`,`bed_status`,`bed_creation`,`bed_updation`) values (1,'1','1',NULL,'2021-06-05 00:00:00',NULL);

/*Data for the table `ic_culture_report` */

insert  into `ic_culture_report`(`culture_id`,`culture_insertion_date`,`culture_source`,`culture_result`,`culture_organism`,`culture_antibio`,`MDR`,`culture_creation`,`culture_updation`,`culture_status`,`device_id`) values (1,'2021-07-08 00:00:00','tissue','Positive','Staphylococcus aureus','Vancomycin, fluoroquinolone','Methicilin resistant Staphylococcus aureus (MRSA)','2021-06-02 00:00:00',NULL,NULL,1),(2,'2021-07-06 00:00:00','central line blood','Positive','Enterococcus','Vancomycin,piperacillin','Vancomycin resistant Enterococcus (VRE)','2021-06-02 00:00:00',NULL,NULL,2),(3,'2020-07-17 00:00:00','central line blood','Positive','Enterococcus','Vancomycin,piperacillin','Vancomycin resistant Enterococcus (VRE)','2021-06-02 00:00:00',NULL,NULL,3),(4,'2020-07-17 00:00:00','central line blood','Negative','Staphylococcus aureus','Vancomycin, fluoroquinolone','Methicilin resistant Staphylococcus aureus (MRSA)','2021-06-02 00:00:00',NULL,NULL,5),(5,'2020-07-17 00:00:00','urethral swab','Positive','Staphylococcus aureus','Vancomycin','Methicilin resistant Staphylococcus aureus (MRSA)','2021-06-05 00:00:00',NULL,NULL,6),(6,'2020-07-17 00:00:00','stool','Positive','Staphylococcus aureus',' fluoroquinolone','Vancomycin resistant Enterococcus (VRE)','2021-06-05 00:00:00',NULL,NULL,7);

/*Data for the table `ic_infection_devices` */

insert  into `ic_infection_devices`(`device_id`,`device_name`,`device_status`,`deivce_insertion_date`,`phlebitis`,`site`,`check`,`mr_no`,`device_creation`,`device_updation`,`deivce_surgery_date`,`device_extubation_date`,`type`) values (1,'Phlebitis','0','2021-06-02 00:00:00','yes','dfdf','Suspected','45879','2021-06-02 00:00:00',NULL,NULL,NULL,NULL),(2,'Phlebitis','0','2021-06-02 00:00:00','yes','test','Confirm','45869','2021-06-02 00:00:00',NULL,NULL,NULL,NULL),(3,'Phlebitis','0','2021-06-02 00:00:00','yes','test','Confirm','458691','2021-06-02 00:00:00',NULL,NULL,NULL,NULL),(4,'Surgical Site Infection','0','2021-06-02 00:00:00',NULL,NULL,'HAP NO','458691','2021-06-02 00:00:00',NULL,'2021-06-02 00:00:00',NULL,NULL),(5,'Phlebitis','0','2021-06-02 00:00:00','yes','testing','Confirm','23456','2021-06-02 00:00:00',NULL,NULL,NULL,NULL),(6,'Phlebitis','0','2021-06-06 00:00:00','yes','tagr','Suspected','1234','2021-06-05 00:00:00',NULL,NULL,NULL,NULL),(7,'Phlebitis','0','2021-06-06 00:00:00','yes','3df','Suspected','2456','2021-06-05 00:00:00',NULL,NULL,NULL,NULL);

/*Data for the table `ic_lovs` */

insert  into `ic_lovs`(`lov_id`,`lov_name`,`lov_type`,`lov_status`,`lov_creation`,`lov_updation`) values (1,'Staphylococcus aureus','organism','1','2021-06-05 00:00:00',NULL),(5,'Vancomycin','antibiotic1','1','2021-06-05 00:00:00',NULL),(4,'Enterococcus','organism','1','2021-06-05 00:00:00',NULL),(6,'Ciprofloxacin/levofloxacin/other fluoroquinolone','antibiotic2','1','2021-06-05 00:00:00',NULL),(7,'MDR Pseudomonas aeruginosa','mdr','1','2021-06-05 00:00:00',NULL),(8,'XDR Salmonella','mdr','1','2021-06-05 00:00:00',NULL);

/*Data for the table `ic_roles` */

insert  into `ic_roles`(`role_id`,`role_name`,`role_status`,`role_creation`,`role_updation`) values (1,'CONTROLER','1','2021-06-05 00:00:00',NULL),(2,'ADMINISTRATE','1','2021-06-05 00:00:00',NULL);

/*Data for the table `ic_ward` */

insert  into `ic_ward`(`ward_id`,`ward_no`,`ward_depart`,`ward_status`,`ward_creation`,`ward_updation`) values (1,'1','control','1','2021-06-05 21:37:51',NULL);

