miniproj.sql

-- MySQL dump 10.13  Distrib 8.0.39, for Linux (x86_64)
--
-- Host: localhost    Database: DBMS_PROJECT
-- ------------------------------------------------------
-- Server version	8.0.39-0ubuntu0.22.04.1

/*!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 `Doctor`
--

DROP TABLE IF EXISTS `Doctor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Doctor` (
  `Doctor_ID` int NOT NULL,
  `Doctor_Name` varchar(20) NOT NULL,
  `Department_Name` varchar(20) NOT NULL,
  `organization_ID` int NOT NULL,
  PRIMARY KEY (`Doctor_ID`),
  KEY `organization_ID` (`organization_ID`),
  CONSTRAINT `Doctor_ibfk_1` FOREIGN KEY (`organization_ID`) REFERENCES `Organization` (`Organization_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Doctor`
--

LOCK TABLES `Doctor` WRITE;
/*!40000 ALTER TABLE `Doctor` DISABLE KEYS */;
INSERT INTO `Doctor` VALUES (1,'Dr Ajith','Cardiology',5),(2,'Dr Abhinav Arora','General Medicine',10),(3,'Dr Ram Prakash','Nephrology',61),(4,'Dr Rahul Gandhi','OBG',26),(5,'Dr Narander Modi','Oncology',11),(6,'Dr Georgia Meloni','Orthopedic',99),(7,'Dr Arvind Kejriwal','Neurology',54),(8,'Dr Justin Parvinder','Cardiology',44),(9,'Dr Akshay Kumar','Hepato-Gaestrology',57),(10,'Dr Singh','Pulmunology',31),(11,'Dr JP Singh','Dermatology',5),(12,'Dr Abhinav Arora','General Medicine',11),(13,'Dr Ram Prakash','Nephrology',36),(14,'Dr Rahul Gandhi','OBG',22),(15,'Dr Narander Modi','Oncology',42),(16,'Dr Georgia Meloni','Orthopedic',73),(17,'Dr Arvind Kejriwal','Neurology',80),(18,'Dr Justin Parvinder','Cardiology',77),(19,'Dr Akshay Kumar','Hepato-Gaestrology',6),(20,'Dr Singh','Pulmunology',87),(21,'Dr JP Singh','Dermatology',13),(22,'Dr Abhinav Arora','General Medicine',13),(23,'Dr Ram Prakash','Nephrology',63),(24,'Dr Rahul Gandhi','OBG',87),(25,'Dr Narander Modi','Oncology',20),(26,'Dr Georgia Meloni','Orthopedic',67),(27,'Dr Arvind Kejriwal','Neurology',91),(28,'Dr Justin Parvinder','Cardiology',97),(29,'Dr Akshay Kumar','Hepato-Gaestrology',43),(30,'Dr Singh','Pulmunology',59),(31,'Dr JP Singh','Dermatology',68),(32,'Dr Abhinav Arora','General Medicine',42),(33,'Dr Ram Prakash','Nephrology',80),(34,'Dr Rahul Gandhi','OBG',91),(35,'Dr Narander Modi','Oncology',19),(36,'Dr Georgia Meloni','Orthopedic',57),(37,'Dr Arvind Kejriwal','Neurology',71),(38,'Dr Justin Parvinder','Cardiology',58),(39,'Dr Akshay Kumar','Hepato-Gaestrology',44),(40,'Dr Singh','Pulmunology',24),(41,'Dr JP Singh','Dermatology',89),(42,'Dr Abhinav Arora','General Medicine',73),(43,'Dr Ram Prakash','Nephrology',48),(44,'Dr Rahul Gandhi','OBG',89),(45,'Dr Narander Modi','Oncology',77),(46,'Dr Georgia Meloni','Orthopedic',37),(47,'Dr Arvind Kejriwal','Neurology',1),(48,'Dr Justin Parvinder','Cardiology',50),(49,'Dr Akshay Kumar','Hepato-Gaestrology',17),(50,'Dr Singh','Pulmunology',60),(51,'Dr JP Singh','Dermatology',8),(52,'Dr Abhinav Arora','General Medicine',92),(53,'Dr Ram Prakash','Nephrology',99),(54,'Dr Rahul Gandhi','OBG',17),(55,'Dr Narander Modi','Oncology',60),(56,'Dr Georgia Meloni','Orthopedic',38),(57,'Dr Arvind Kejriwal','Neurology',47),(58,'Dr Justin Parvinder','Cardiology',11),(59,'Dr Akshay Kumar','Hepato-Gaestrology',43),(60,'Dr Singh','Pulmunology',42),(61,'Dr JP Singh','Dermatology',68),(62,'Dr Abhinav Arora','General Medicine',73),(63,'Dr Ram Prakash','Nephrology',47),(64,'Dr Rahul Gandhi','OBG',48),(65,'Dr Narander Modi','Oncology',52),(66,'Dr Georgia Meloni','Orthopedic',50),(67,'Dr Arvind Kejriwal','Neurology',16),(68,'Dr Justin Parvinder','Cardiology',43),(69,'Dr Akshay Kumar','Hepato-Gaestrology',20),(70,'Dr Singh','Pulmunology',15),(71,'Dr JP Singh','Dermatology',56),(72,'Dr Abhinav Arora','General Medicine',79),(73,'Dr Ram Prakash','Nephrology',14),(74,'Dr Rahul Gandhi','OBG',27),(75,'Dr Narander Modi','Oncology',9),(76,'Dr Georgia Meloni','Orthopedic',49),(77,'Dr Arvind Kejriwal','Neurology',14),(78,'Dr Justin Parvinder','Cardiology',45),(79,'Dr Akshay Kumar','Hepato-Gaestrology',38),(80,'Dr Singh','Pulmunology',53),(81,'Dr JP Singh','Dermatology',36),(82,'Dr Abhinav Arora','General Medicine',40),(83,'Dr Ram Prakash','Nephrology',15),(84,'Dr Rahul Gandhi','OBG',71),(85,'Dr Narander Modi','Oncology',72),(86,'Dr Georgia Meloni','Orthopedic',84),(87,'Dr Arvind Kejriwal','Neurology',91),(88,'Dr Justin Parvinder','Cardiology',22),(89,'Dr Akshay Kumar','Hepato-Gaestrology',85),(90,'Dr Singh','Pulmunology',2),(91,'Dr JP Singh','Dermatology',22),(92,'Dr Abhinav Arora','General Medicine',41),(93,'Dr Ram Prakash','Nephrology',41),(94,'Dr Rahul Gandhi','OBG',33),(95,'Dr Narander Modi','Oncology',60),(96,'Dr Georgia Meloni','Orthopedic',11),(97,'Dr Arvind Kejriwal','Neurology',70),(98,'Dr Justin Parvinder','Cardiology',9),(99,'Dr Akshay Kumar','Hepato-Gaestrology',96),(100,'Dr Singh','Pulmunology',16),(101,'Dr JP Singh','Dermatology',7),(102,'Dr Abhinav Arora','General Medicine',51),(103,'Dr Ram Prakash','Nephrology',10),(104,'Dr Rahul Gandhi','OBG',75),(105,'Dr Narander Modi','Oncology',49),(106,'Dr Georgia Meloni','Orthopedic',71),(107,'Dr Arvind Kejriwal','Neurology',59),(108,'Dr Justin Parvinder','Cardiology',9),(109,'Dr Akshay Kumar','Hepato-Gaestrology',23),(110,'Dr Singh','Pulmunology',31),(111,'Dr JP Singh','Dermatology',49),(112,'Dr Abhinav Arora','General Medicine',23),(113,'Dr Ram Prakash','Nephrology',82),(114,'Dr Rahul Gandhi','OBG',4),(115,'Dr Narander Modi','Oncology',36),(116,'Dr Georgia Meloni','Orthopedic',99),(117,'Dr Arvind Kejriwal','Neurology',81),(118,'Dr Justin Parvinder','Cardiology',85),(119,'Dr Akshay Kumar','Hepato-Gaestrology',80),(120,'Dr Singh','Pulmunology',3),(121,'Dr JP Singh','Dermatology',40),(122,'Dr Abhinav Arora','General Medicine',91),(123,'Dr Ram Prakash','Nephrology',56),(124,'Dr Rahul Gandhi','OBG',53),(125,'Dr Narander Modi','Oncology',92),(126,'Dr Georgia Meloni','Orthopedic',80),(127,'Dr Arvind Kejriwal','Neurology',63),(128,'Dr Justin Parvinder','Cardiology',76),(129,'Dr Akshay Kumar','Hepato-Gaestrology',32),(130,'Dr Singh','Pulmunology',31),(131,'Dr JP Singh','Dermatology',77),(132,'Dr Abhinav Arora','General Medicine',13),(133,'Dr Ram Prakash','Nephrology',36),(134,'Dr Rahul Gandhi','OBG',2),(135,'Dr Narander Modi','Oncology',7),(136,'Dr Georgia Meloni','Orthopedic',61),(137,'Dr Arvind Kejriwal','Neurology',22),(138,'Dr Justin Parvinder','Cardiology',53),(139,'Dr Akshay Kumar','Hepato-Gaestrology',97),(140,'Dr Singh','Pulmunology',84),(141,'Dr JP Singh','Dermatology',91),(142,'Dr Abhinav Arora','General Medicine',71),(143,'Dr Ram Prakash','Nephrology',97),(144,'Dr Rahul Gandhi','OBG',98),(145,'Dr Narander Modi','Oncology',89),(146,'Dr Georgia Meloni','Orthopedic',25),(147,'Dr Arvind Kejriwal','Neurology',77),(148,'Dr Justin Parvinder','Cardiology',55),(149,'Dr Akshay Kumar','Hepato-Gaestrology',13),(150,'Dr Singh','Pulmunology',49),(151,'Dr JP Singh','Dermatology',91),(152,'Dr Abhinav Arora','General Medicine',56),(153,'Dr Ram Prakash','Nephrology',1),(154,'Dr Rahul Gandhi','OBG',45),(155,'Dr Narander Modi','Oncology',6),(156,'Dr Georgia Meloni','Orthopedic',63),(157,'Dr Arvind Kejriwal','Neurology',28),(158,'Dr Justin Parvinder','Cardiology',8),(159,'Dr Akshay Kumar','Hepato-Gaestrology',66),(160,'Dr Singh','Pulmunology',36),(161,'Dr JP Singh','Dermatology',74),(162,'Dr Abhinav Arora','General Medicine',26),(163,'Dr Ram Prakash','Nephrology',83),(164,'Dr Rahul Gandhi','OBG',60),(165,'Dr Narander Modi','Oncology',9),(166,'Dr Georgia Meloni','Orthopedic',55),(167,'Dr Arvind Kejriwal','Neurology',17),(168,'Dr Justin Parvinder','Cardiology',16),(169,'Dr Akshay Kumar','Hepato-Gaestrology',89),(170,'Dr Singh','Pulmunology',61),(171,'Dr JP Singh','Dermatology',71),(172,'Dr Abhinav Arora','General Medicine',61),(173,'Dr Ram Prakash','Nephrology',4),(174,'Dr Rahul Gandhi','OBG',10),(175,'Dr Narander Modi','Oncology',3),(176,'Dr Georgia Meloni','Orthopedic',57),(177,'Dr Arvind Kejriwal','Neurology',35),(178,'Dr Justin Parvinder','Cardiology',66),(179,'Dr Akshay Kumar','Hepato-Gaestrology',84),(180,'Dr Singh','Pulmunology',49),(181,'Dr JP Singh','Dermatology',41),(182,'Dr Abhinav Arora','General Medicine',89),(183,'Dr Ram Prakash','Nephrology',36),(184,'Dr Rahul Gandhi','OBG',9),(185,'Dr Narander Modi','Oncology',19),(186,'Dr Georgia Meloni','Orthopedic',50),(187,'Dr Arvind Kejriwal','Neurology',13),(188,'Dr Justin Parvinder','Cardiology',43),(189,'Dr Akshay Kumar','Hepato-Gaestrology',11),(190,'Dr Singh','Pulmunology',6),(191,'Dr JP Singh','Dermatology',27),(192,'Dr Abhinav Arora','General Medicine',42),(193,'Dr Ram Prakash','Nephrology',8),(194,'Dr Rahul Gandhi','OBG',17),(195,'Dr Narander Modi','Oncology',2),(196,'Dr Georgia Meloni','Orthopedic',50),(197,'Dr Arvind Kejriwal','Neurology',29),(198,'Dr Justin Parvinder','Cardiology',47),(199,'Dr Akshay Kumar','Hepato-Gaestrology',78);
/*!40000 ALTER TABLE `Doctor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Doctor_phone_no`
--

DROP TABLE IF EXISTS `Doctor_phone_no`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Doctor_phone_no` (
  `Doctor_ID` int NOT NULL,
  `Phone_no` varchar(15) DEFAULT NULL,
  KEY `Doctor_ID` (`Doctor_ID`),
  CONSTRAINT `Doctor_phone_no_ibfk_1` FOREIGN KEY (`Doctor_ID`) REFERENCES `Doctor` (`Doctor_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Doctor_phone_no`
--

LOCK TABLES `Doctor_phone_no` WRITE;
/*!40000 ALTER TABLE `Doctor_phone_no` DISABLE KEYS */;
/*!40000 ALTER TABLE `Doctor_phone_no` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Donor`
--

DROP TABLE IF EXISTS `Donor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Donor` (
  `Donor_ID` int NOT NULL,
  `organ_donated` varchar(20) NOT NULL,
  `reason_of_donation` varchar(20) DEFAULT NULL,
  `Organization_ID` int NOT NULL,
  `User_ID` int NOT NULL,
  PRIMARY KEY (`Donor_ID`,`organ_donated`),
  KEY `User_ID` (`User_ID`),
  KEY `Organization_ID` (`Organization_ID`),
  CONSTRAINT `Donor_ibfk_1` FOREIGN KEY (`User_ID`) REFERENCES `User` (`User_ID`) ON DELETE CASCADE,
  CONSTRAINT `Donor_ibfk_2` FOREIGN KEY (`Organization_ID`) REFERENCES `Organization` (`Organization_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Donor`
--

LOCK TABLES `Donor` WRITE;
/*!40000 ALTER TABLE `Donor` DISABLE KEYS */;
INSERT INTO `Donor` VALUES (1,'Heart','On Dialysis',97,90),(2,'Pancreas','Brain dead',79,41),(3,'Pancreas','Old age',1,95),(4,'Intestine','Brain damage',60,96),(5,'Kidney','Brain dead',69,72),(6,'Pancreas','Old age',1,89),(7,'Kidney','Old age',51,43),(8,'Kidney','Wind pipe damage',53,61),(9,'Heart','On Dialysis',57,16),(10,'Heart','Respiration failure',24,50),(11,'Kidney','Heart hole',8,92),(12,'Pancreas','Respiration failure',64,58),(13,'Pancreas','Heart hole',28,45),(14,'Pancreas','Brain damage',10,75),(15,'Heart','Brain damage',50,53),(16,'Intestine','On Dialysis',27,31),(17,'Intestine','Heart Failure',72,94),(18,'Intestine','On Dialysis',97,7),(19,'Pancreas','Brain dead',69,67),(20,'Intestine','Brain damage',40,28),(21,'Pancreas','On Dialysis',97,40),(22,'Lung','Cancer final stage',56,50),(23,'Heart','Old age',81,99),(24,'Lung','Brain dead',89,50),(25,'Intestine','Wind pipe damage',43,30),(26,'Intestine','Brain damage',60,50),(27,'Lung','Wind pipe damage',33,92),(28,'Pancreas','On Dialysis',67,93),(29,'Intestine','Heart Failure',62,58),(30,'Kidney','On Dialysis',27,32),(31,'Heart','Respiration failure',4,27),(32,'Lung','Old age',11,72),(33,'Kidney','On Dialysis',57,8),(34,'Heart','Heart Failure',22,29),(35,'Heart','Cancer final stage',66,58),(36,'Heart','Old age',21,99),(37,'Heart','Heart Failure',72,61),(38,'Pancreas','Heart Failure',12,28),(39,'Intestine','On Dialysis',27,92),(40,'Intestine','Old age',71,79),(41,'Intestine','Heart Failure',2,31),(42,'Kidney','Falling Vitals',85,36),(43,'Kidney','Falling Vitals',35,7),(44,'Lung','Heart hole',28,34),(45,'Heart','Falling Vitals',5,33),(46,'Lung','Respiration failure',14,80),(47,'Intestine','Brain dead',9,6),(48,'Lung','Respiration failure',54,42),(49,'Kidney','Respiration failure',94,73),(50,'Kidney','Brain dead',29,25),(51,'Intestine','Falling Vitals',55,44),(52,'Pancreas','Respiration failure',24,70),(53,'Kidney','Brain dead',9,17),(54,'Intestine','Wind pipe damage',73,46),(55,'Lung','Falling Vitals',25,35),(56,'Kidney','Falling Vitals',25,25),(57,'Intestine','Wind pipe damage',23,48),(58,'Heart','Cancer final stage',56,21),(59,'Lung','Cancer final stage',6,57),(60,'Kidney','Respiration failure',24,67),(61,'Lung','Respiration failure',4,30),(62,'Intestine','Brain dead',9,94),(63,'Kidney','On Dialysis',67,35),(64,'Kidney','Brain dead',89,28),(65,'Pancreas','Brain dead',79,32),(66,'Lung','Heart hole',98,59),(67,'Lung','Old age',31,58),(68,'Intestine','Respiration failure',84,52),(69,'Heart','Respiration failure',64,39),(70,'Lung','Heart hole',78,17),(71,'Pancreas','Cancer final stage',46,89),(72,'Lung','Falling Vitals',55,36),(73,'Lung','Falling Vitals',25,54),(74,'Lung','Heart hole',38,27),(75,'Intestine','Falling Vitals',5,27),(76,'Kidney','Cancer final stage',16,18),(77,'Pancreas','Cancer final stage',46,28),(78,'Pancreas','Heart hole',68,13),(79,'Pancreas','Falling Vitals',65,71),(80,'Kidney','Respiration failure',64,98),(81,'Lung','Wind pipe damage',43,75),(82,'Heart','Old age',21,56),(83,'Intestine','On Dialysis',67,6),(84,'Pancreas','Respiration failure',34,18),(85,'Heart','On Dialysis',37,5),(86,'Heart','Wind pipe damage',93,69),(87,'Kidney','Heart hole',38,96),(88,'Intestine','Heart Failure',42,44),(89,'Heart','Falling Vitals',75,88),(90,'Intestine','Wind pipe damage',83,1),(91,'Kidney','Old age',11,40),(92,'Intestine','Brain damage',70,16),(93,'Kidney','On Dialysis',77,79),(94,'Kidney','Falling Vitals',45,32),(95,'Heart','Brain damage',40,47),(96,'Pancreas','On Dialysis',77,73),(97,'Intestine','Heart Failure',92,32),(98,'Heart','Respiration failure',84,29),(99,'Pancreas','Old age',61,33),(100,'Kidney','Heart Failure',92,5),(101,'Pancreas','Heart hole',98,35),(102,'Heart','Brain damage',90,25),(103,'Heart','Heart hole',18,3),(104,'Heart','Falling Vitals',45,79),(105,'Kidney','On Dialysis',17,9),(106,'Pancreas','Wind pipe damage',93,3),(107,'Intestine','Heart hole',78,76),(108,'Pancreas','Cancer final stage',46,91),(109,'Pancreas','Brain damage',80,28),(110,'Lung','Brain damage',60,80),(111,'Kidney','Heart Failure',52,85),(112,'Pancreas','Heart hole',38,14),(113,'Pancreas','Heart hole',18,91),(114,'Pancreas','Old age',11,91),(115,'Heart','Brain dead',49,95),(116,'Lung','Brain damage',20,11),(117,'Heart','Wind pipe damage',93,66),(118,'Kidney','Respiration failure',24,23),(119,'Pancreas','On Dialysis',97,55),(120,'Lung','Falling Vitals',95,81),(121,'Heart','Brain dead',9,53),(122,'Kidney','Brain dead',69,9),(123,'Pancreas','Heart hole',28,58),(124,'Heart','Heart Failure',2,59),(125,'Heart','Old age',61,39),(126,'Heart','Old age',1,14),(127,'Lung','Wind pipe damage',43,97),(128,'Kidney','Heart hole',28,46),(129,'Intestine','Respiration failure',4,71),(130,'Lung','Heart Failure',22,26),(131,'Pancreas','Heart hole',8,91),(132,'Heart','Cancer final stage',36,58),(133,'Lung','Heart hole',68,47),(134,'Lung','Cancer final stage',86,88),(135,'Heart','Heart Failure',22,8),(136,'Pancreas','Heart hole',28,31),(137,'Intestine','Falling Vitals',35,64),(138,'Heart','Heart hole',78,80),(139,'Pancreas','Old age',11,67),(140,'Kidney','Wind pipe damage',63,82),(141,'Kidney','Old age',91,76),(142,'Lung','Old age',41,38),(143,'Pancreas','Wind pipe damage',53,71),(144,'Heart','Wind pipe damage',73,37),(145,'Heart','Respiration failure',4,36),(146,'Intestine','On Dialysis',27,25),(147,'Intestine','Cancer final stage',96,64),(148,'Lung','Heart hole',38,78),(149,'Lung','Falling Vitals',55,63),(150,'Kidney','Cancer final stage',76,54),(151,'Kidney','Heart Failure',52,8),(152,'Heart','Heart Failure',32,53),(153,'Kidney','Brain damage',40,2),(154,'Intestine','Heart Failure',12,4),(155,'Kidney','Brain dead',9,68),(156,'Pancreas','On Dialysis',7,44),(157,'Kidney','Cancer final stage',66,67),(158,'Kidney','Old age',51,25),(159,'Lung','Respiration failure',94,77),(160,'Kidney','Respiration failure',64,12),(161,'Kidney','Falling Vitals',75,52),(162,'Lung','Wind pipe damage',13,60),(163,'Pancreas','Heart hole',48,34),(164,'Heart','Brain damage',90,82),(165,'Lung','Wind pipe damage',13,73),(166,'Lung','Heart Failure',12,69),(167,'Pancreas','Heart hole',58,1),(168,'Pancreas','Heart Failure',12,26),(169,'Intestine','Brain dead',29,89),(170,'Lung','Respiration failure',94,77),(171,'Kidney','Brain damage',80,33),(172,'Kidney','Brain dead',19,3),(173,'Intestine','Heart hole',98,92),(174,'Kidney','Falling Vitals',65,70),(175,'Kidney','Brain dead',89,37),(176,'Lung','Brain damage',90,58),(177,'Intestine','On Dialysis',47,60),(178,'Lung','Old age',91,33),(179,'Intestine','Heart hole',38,55),(180,'Heart','Heart hole',98,1),(181,'Pancreas','On Dialysis',7,83),(182,'Kidney','Respiration failure',54,75),(183,'Heart','Brain damage',30,50),(184,'Lung','Heart hole',68,84),(185,'Heart','Brain dead',69,88),(186,'Pancreas','Cancer final stage',36,82),(187,'Intestine','Cancer final stage',56,51),(188,'Pancreas','On Dialysis',27,53),(189,'Pancreas','Brain damage',60,39),(190,'Heart','Old age',11,26),(191,'Intestine','Wind pipe damage',33,42),(192,'Intestine','Cancer final stage',36,31),(193,'Intestine','Brain damage',90,98),(194,'Kidney','Brain dead',39,50),(195,'Kidney','Heart hole',18,22),(196,'Pancreas','Old age',81,94),(197,'Heart','On Dialysis',17,8),(198,'Lung','Wind pipe damage',63,43),(199,'Kidney','Wind pipe damage',93,47);
/*!40000 ALTER TABLE `Donor` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_0900_ai_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `ADD_DONOR_LOG` AFTER INSERT ON `Donor` FOR EACH ROW begin
insert into log values
(now(), concat("Inserted new Donor", cast(new.Donor_Id as char)));
end */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_0900_ai_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `UPD_DONOR_LOG` AFTER UPDATE ON `Donor` FOR EACH ROW begin
insert into log values
(now(), concat("Updated Donor Details", cast(new.Donor_Id as char)));
end */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_0900_ai_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `DEL_DONOR_LOG` AFTER DELETE ON `Donor` FOR EACH ROW begin
insert into log values
(now(), concat("Deleted Donor ", cast(old.Donor_Id as char)));
end */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_0900_ai_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `DEL_PATIENT_LOG` AFTER DELETE ON `Donor` FOR EACH ROW begin
insert into log values
(now(), concat("Deleted Patient ", cast(old.Donor_Id as char)));
end */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `Organ_available`
--

DROP TABLE IF EXISTS `Organ_available`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Organ_available` (
  `Organ_ID` int NOT NULL AUTO_INCREMENT,
  `Organ_name` varchar(20) NOT NULL,
  `Donor_ID` int NOT NULL,
  PRIMARY KEY (`Organ_ID`),
  KEY `Donor_ID` (`Donor_ID`),
  CONSTRAINT `Organ_available_ibfk_1` FOREIGN KEY (`Donor_ID`) REFERENCES `Donor` (`Donor_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Organ_available`
--

LOCK TABLES `Organ_available` WRITE;
/*!40000 ALTER TABLE `Organ_available` DISABLE KEYS */;
/*!40000 ALTER TABLE `Organ_available` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Organization`
--

DROP TABLE IF EXISTS `Organization`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Organization` (
  `Organization_ID` int NOT NULL,
  `Organization_name` varchar(20) NOT NULL,
  `Location` varchar(20) DEFAULT NULL,
  `Government_approved` int DEFAULT NULL,
  PRIMARY KEY (`Organization_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Organization`
--

LOCK TABLES `Organization` WRITE;
/*!40000 ALTER TABLE `Organization` DISABLE KEYS */;
INSERT INTO `Organization` VALUES (1,'Aster Hospital','New Delhi',1),(2,'Columbia Asia Group','Mumbai',0),(3,'TATA Memorial','Kolkata',0),(4,'PESIMSR','Kolkata',1),(5,'Apollo Health','Ahmedabad',1),(6,'Care Asia','Kolkata',0),(7,'Medanta','Kolkata',0),(8,'Kidwai Memorial','Ahmedabad',0),(9,'Kaveri Hospital','Kolkata',1),(10,'Manipal Hospital','Bangalore',1),(11,'Aster Hospital','Ahmedabad',1),(12,'Columbia Asia Group','Mumbai',0),(13,'TATA Memorial','Kolkata',0),(14,'PESIMSR','Ahmedabad',1),(15,'Apollo Health','Ahmedabad',0),(16,'Care Asia','Kolkata',0),(17,'Medanta','Kolkata',1),(18,'Kidwai Memorial','Mumbai',1),(19,'Kaveri Hospital','Ahmedabad',1),(20,'Manipal Hospital','Bangalore',1),(21,'Aster Hospital','Ahmedabad',0),(22,'Columbia Asia Group','New Delhi',0),(23,'TATA Memorial','Mumbai',1),(24,'PESIMSR','Ahmedabad',0),(25,'Apollo Health','Mumbai',0),(26,'Care Asia','Ahmedabad',0),(27,'Medanta','Kolkata',0),(28,'Kidwai Memorial','Mumbai',0),(29,'Kaveri Hospital','Mumbai',1),(30,'Manipal Hospital','Bangalore',1),(31,'Aster Hospital','New Delhi',0),(32,'Columbia Asia Group','New Delhi',0),(33,'TATA Memorial','New Delhi',0),(34,'PESIMSR','Kolkata',0),(35,'Apollo Health','New Delhi',0),(36,'Care Asia','Mumbai',0),(37,'Medanta','Kolkata',0),(38,'Kidwai Memorial','New Delhi',1),(39,'Kaveri Hospital','Kolkata',1),(40,'Manipal Hospital','Bangalore',0),(41,'Aster Hospital','Mumbai',0),(42,'Columbia Asia Group','Kolkata',0),(43,'TATA Memorial','New Delhi',1),(44,'PESIMSR','Kolkata',0),(45,'Apollo Health','New Delhi',1),(46,'Care Asia','Ahmedabad',0),(47,'Medanta','Mumbai',1),(48,'Kidwai Memorial','New Delhi',1),(49,'Kaveri Hospital','Ahmedabad',0),(50,'Manipal Hospital','Bangalore',1),(51,'Aster Hospital','Kolkata',0),(52,'Columbia Asia Group','New Delhi',0),(53,'TATA Memorial','New Delhi',0),(54,'PESIMSR','Kolkata',0),(55,'Apollo Health','Mumbai',0),(56,'Care Asia','Ahmedabad',0),(57,'Medanta','Kolkata',0),(58,'Kidwai Memorial','Kolkata',0),(59,'Kaveri Hospital','Kolkata',1),(60,'Manipal Hospital','Bangalore',0),(61,'Aster Hospital','Mumbai',1),(62,'Columbia Asia Group','Kolkata',1),(63,'TATA Memorial','Mumbai',1),(64,'PESIMSR','Kolkata',0),(65,'Apollo Health','Kolkata',0),(66,'Care Asia','Mumbai',0),(67,'Medanta','Mumbai',0),(68,'Kidwai Memorial','Ahmedabad',0),(69,'Kaveri Hospital','New Delhi',0),(70,'Manipal Hospital','Bangalore',1),(71,'Aster Hospital','Ahmedabad',1),(72,'Columbia Asia Group','Ahmedabad',1),(73,'TATA Memorial','New Delhi',0),(74,'PESIMSR','Ahmedabad',0),(75,'Apollo Health','New Delhi',0),(76,'Care Asia','Kolkata',0),(77,'Medanta','Ahmedabad',1),(78,'Kidwai Memorial','New Delhi',1),(79,'Kaveri Hospital','New Delhi',0),(80,'Manipal Hospital','Bangalore',0),(81,'Aster Hospital','Ahmedabad',0),(82,'Columbia Asia Group','Ahmedabad',1),(83,'TATA Memorial','Ahmedabad',0),(84,'PESIMSR','Mumbai',1),(85,'Apollo Health','Kolkata',0),(86,'Care Asia','Mumbai',0),(87,'Medanta','Kolkata',1),(88,'Kidwai Memorial','Ahmedabad',0),(89,'Kaveri Hospital','Mumbai',1),(90,'Manipal Hospital','Bangalore',0),(91,'Aster Hospital','Ahmedabad',0),(92,'Columbia Asia Group','Ahmedabad',0),(93,'TATA Memorial','Kolkata',0),(94,'PESIMSR','Ahmedabad',0),(95,'Apollo Health','Mumbai',1),(96,'Care Asia','Kolkata',1),(97,'Medanta','New Delhi',0),(98,'Kidwai Memorial','Mumbai',1),(99,'Kaveri Hospital','New Delhi',0);
/*!40000 ALTER TABLE `Organization` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Organization_head`
--

DROP TABLE IF EXISTS `Organization_head`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Organization_head` (
  `Organization_ID` int NOT NULL,
  `Employee_ID` int NOT NULL,
  `Name` varchar(20) NOT NULL,
  `Date_of_joining` date NOT NULL,
  `Term_length` int NOT NULL,
  PRIMARY KEY (`Organization_ID`,`Employee_ID`),
  CONSTRAINT `Organization_head_ibfk_1` FOREIGN KEY (`Organization_ID`) REFERENCES `Organization` (`Organization_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Organization_head`
--

LOCK TABLES `Organization_head` WRITE;
/*!40000 ALTER TABLE `Organization_head` DISABLE KEYS */;
/*!40000 ALTER TABLE `Organization_head` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Organization_phone_no`
--

DROP TABLE IF EXISTS `Organization_phone_no`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Organization_phone_no` (
  `Organization_ID` int NOT NULL,
  `Phone_no` varchar(15) DEFAULT NULL,
  KEY `Organization_ID` (`Organization_ID`),
  CONSTRAINT `Organization_phone_no_ibfk_1` FOREIGN KEY (`Organization_ID`) REFERENCES `Organization` (`Organization_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Organization_phone_no`
--

LOCK TABLES `Organization_phone_no` WRITE;
/*!40000 ALTER TABLE `Organization_phone_no` DISABLE KEYS */;
/*!40000 ALTER TABLE `Organization_phone_no` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Patient`
--

DROP TABLE IF EXISTS `Patient`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Patient` (
  `Patient_ID` int NOT NULL,
  `organ_req` varchar(20) NOT NULL,
  `reason_of_procurement` varchar(20) DEFAULT NULL,
  `Doctor_ID` int NOT NULL,
  `User_ID` int NOT NULL,
  PRIMARY KEY (`Patient_ID`,`organ_req`),
  KEY `User_ID` (`User_ID`),
  KEY `Doctor_ID` (`Doctor_ID`),
  CONSTRAINT `Patient_ibfk_1` FOREIGN KEY (`User_ID`) REFERENCES `User` (`User_ID`) ON DELETE CASCADE,
  CONSTRAINT `Patient_ibfk_2` FOREIGN KEY (`Doctor_ID`) REFERENCES `Doctor` (`Doctor_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Patient`
--

LOCK TABLES `Patient` WRITE;
/*!40000 ALTER TABLE `Patient` DISABLE KEYS */;
INSERT INTO `Patient` VALUES (1,'Heart','Genetic Mutation',63,48),(2,'Kidney','Organ Failure',62,11),(3,'Pancreas','Cellular Infection',72,84),(4,'Kidney','Internal Injuries',87,36),(5,'Heart','Organ Transmutation',44,13),(6,'Lung','Organ Cancer',71,52),(7,'Intestine','Chronic Disease',63,85),(8,'Intestine','Body Fluid Imbalance',42,83),(9,'Lung','Tissue rupture',41,52),(10,'Kidney','Injury in accident',16,8),(11,'Kidney','Genetic Mutation',91,95),(12,'Pancreas','Organ Failure',70,58),(13,'Intestine','Cellular Infection',81,44),(14,'Heart','Internal Injuries',3,94),(15,'Kidney','Organ Transmutation',94,30),(16,'Lung','Organ Cancer',95,97),(17,'Heart','Chronic Disease',7,2),(18,'Kidney','Body Fluid Imbalance',89,82),(19,'Kidney','Tissue rupture',25,24),(20,'Pancreas','Injury in accident',11,23),(21,'Intestine','Genetic Mutation',64,66),(22,'Pancreas','Organ Failure',52,66),(23,'Lung','Cellular Infection',64,28),(24,'Intestine','Internal Injuries',30,13),(25,'Heart','Organ Transmutation',2,81),(26,'Lung','Organ Cancer',94,8),(27,'Intestine','Chronic Disease',75,78),(28,'Pancreas','Body Fluid Imbalance',94,94),(29,'Kidney','Tissue rupture',9,80),(30,'Intestine','Injury in accident',82,74),(31,'Pancreas','Genetic Mutation',33,87),(32,'Pancreas','Organ Failure',98,55),(33,'Heart','Cellular Infection',58,37),(34,'Heart','Internal Injuries',10,31),(35,'Kidney','Organ Transmutation',51,2),(36,'Pancreas','Organ Cancer',98,67),(37,'Heart','Chronic Disease',53,47),(38,'Kidney','Body Fluid Imbalance',59,20),(39,'Pancreas','Tissue rupture',81,59),(40,'Lung','Injury in accident',89,46),(41,'Pancreas','Genetic Mutation',50,29),(42,'Lung','Organ Failure',28,95),(43,'Heart','Cellular Infection',10,14),(44,'Pancreas','Internal Injuries',20,44),(45,'Kidney','Organ Transmutation',10,17),(46,'Pancreas','Organ Cancer',38,14),(47,'Pancreas','Chronic Disease',68,88),(48,'Lung','Body Fluid Imbalance',28,32),(49,'Kidney','Tissue rupture',76,14),(50,'Lung','Injury in accident',95,4),(51,'Heart','Genetic Mutation',90,11),(52,'Lung','Organ Failure',65,94),(53,'Heart','Cellular Infection',9,7),(54,'Kidney','Internal Injuries',24,75),(55,'Heart','Organ Transmutation',98,36),(56,'Kidney','Organ Cancer',97,17),(57,'Pancreas','Chronic Disease',34,57),(58,'Lung','Body Fluid Imbalance',74,14),(59,'Heart','Tissue rupture',80,17),(60,'Kidney','Injury in accident',84,14),(61,'Kidney','Genetic Mutation',60,42),(62,'Pancreas','Organ Failure',97,29),(63,'Heart','Cellular Infection',96,84),(64,'Heart','Internal Injuries',2,81),(65,'Kidney','Organ Transmutation',89,8),(66,'Heart','Organ Cancer',25,52),(67,'Pancreas','Chronic Disease',92,74),(68,'Kidney','Body Fluid Imbalance',31,44),(69,'Heart','Tissue rupture',13,76),(70,'Pancreas','Injury in accident',67,78),(71,'Lung','Genetic Mutation',48,82),(72,'Heart','Organ Failure',11,41),(73,'Heart','Cellular Infection',55,90),(74,'Pancreas','Internal Injuries',91,40),(75,'Intestine','Organ Transmutation',64,25),(76,'Lung','Organ Cancer',88,70),(77,'Pancreas','Chronic Disease',18,74),(78,'Intestine','Body Fluid Imbalance',68,7),(79,'Heart','Tissue rupture',33,50),(80,'Lung','Injury in accident',56,29),(81,'Intestine','Genetic Mutation',56,24),(82,'Pancreas','Organ Failure',75,81),(83,'Pancreas','Cellular Infection',93,64),(84,'Lung','Internal Injuries',38,5),(85,'Pancreas','Organ Transmutation',58,12),(86,'Pancreas','Organ Cancer',49,45),(87,'Heart','Chronic Disease',70,98),(88,'Intestine','Body Fluid Imbalance',3,23),(89,'Pancreas','Tissue rupture',63,71),(90,'Pancreas','Injury in accident',95,21),(91,'Lung','Genetic Mutation',17,56),(92,'Lung','Organ Failure',61,48),(93,'Pancreas','Cellular Infection',98,77),(94,'Heart','Internal Injuries',54,67),(95,'Lung','Organ Transmutation',51,87),(96,'Lung','Organ Cancer',30,45),(97,'Kidney','Chronic Disease',76,2),(98,'Intestine','Body Fluid Imbalance',8,67),(99,'Heart','Tissue rupture',25,65),(100,'Lung','Injury in accident',45,66),(101,'Pancreas','Genetic Mutation',86,79),(102,'Pancreas','Organ Failure',71,95),(103,'Heart','Cellular Infection',34,28),(104,'Pancreas','Internal Injuries',97,79),(105,'Lung','Organ Transmutation',44,8),(106,'Kidney','Organ Cancer',42,89),(107,'Intestine','Chronic Disease',55,37),(108,'Kidney','Body Fluid Imbalance',67,84),(109,'Kidney','Tissue rupture',99,61),(110,'Intestine','Injury in accident',18,47),(111,'Lung','Genetic Mutation',80,42),(112,'Lung','Organ Failure',63,55),(113,'Intestine','Cellular Infection',67,23),(114,'Pancreas','Internal Injuries',82,30),(115,'Pancreas','Organ Transmutation',64,16),(116,'Intestine','Organ Cancer',41,39),(117,'Kidney','Chronic Disease',15,32),(118,'Heart','Body Fluid Imbalance',88,24),(119,'Lung','Tissue rupture',59,82),(120,'Pancreas','Injury in accident',45,82),(121,'Intestine','Genetic Mutation',6,39),(122,'Kidney','Organ Failure',40,13),(123,'Intestine','Cellular Infection',13,90),(124,'Kidney','Internal Injuries',83,62),(125,'Pancreas','Organ Transmutation',85,13),(126,'Heart','Organ Cancer',2,41),(127,'Heart','Chronic Disease',2,45),(128,'Pancreas','Body Fluid Imbalance',45,45),(129,'Intestine','Tissue rupture',76,69),(130,'Pancreas','Injury in accident',62,74),(131,'Pancreas','Genetic Mutation',60,30),(132,'Kidney','Organ Failure',49,9),(133,'Lung','Cellular Infection',48,58),(134,'Lung','Internal Injuries',14,15),(135,'Pancreas','Organ Transmutation',73,94),(136,'Lung','Organ Cancer',27,19),(137,'Kidney','Chronic Disease',83,28),(138,'Pancreas','Body Fluid Imbalance',29,37),(139,'Intestine','Tissue rupture',5,85),(140,'Lung','Injury in accident',14,83),(141,'Pancreas','Genetic Mutation',98,47),(142,'Pancreas','Organ Failure',88,53),(143,'Lung','Cellular Infection',40,61),(144,'Heart','Internal Injuries',56,30),(145,'Pancreas','Organ Transmutation',76,63),(146,'Heart','Organ Cancer',33,10),(147,'Pancreas','Chronic Disease',89,15),(148,'Kidney','Body Fluid Imbalance',66,48),(149,'Lung','Tissue rupture',81,57),(150,'Intestine','Injury in accident',70,64),(151,'Pancreas','Genetic Mutation',50,15),(152,'Lung','Organ Failure',81,89),(153,'Intestine','Cellular Infection',68,5),(154,'Pancreas','Internal Injuries',40,97),(155,'Pancreas','Organ Transmutation',50,58),(156,'Lung','Organ Cancer',62,84),(157,'Heart','Chronic Disease',10,98),(158,'Heart','Body Fluid Imbalance',64,58),(159,'Heart','Tissue rupture',44,29),(160,'Intestine','Injury in accident',16,42),(161,'Kidney','Genetic Mutation',64,2),(162,'Lung','Organ Failure',62,58),(163,'Heart','Cellular Infection',88,94),(164,'Pancreas','Internal Injuries',38,94),(165,'Kidney','Organ Transmutation',78,8),(166,'Lung','Organ Cancer',62,62),(167,'Pancreas','Chronic Disease',31,80),(168,'Lung','Body Fluid Imbalance',71,21),(169,'Intestine','Tissue rupture',90,5),(170,'Lung','Injury in accident',20,26),(171,'Pancreas','Genetic Mutation',25,17),(172,'Heart','Organ Failure',82,51),(173,'Lung','Cellular Infection',97,23),(174,'Kidney','Internal Injuries',29,56),(175,'Heart','Organ Transmutation',37,67),(176,'Pancreas','Organ Cancer',86,39),(177,'Pancreas','Chronic Disease',53,68),(178,'Heart','Body Fluid Imbalance',21,31),(179,'Intestine','Tissue rupture',54,33),(180,'Lung','Injury in accident',15,80),(181,'Intestine','Genetic Mutation',43,38),(182,'Heart','Organ Failure',58,89),(183,'Heart','Cellular Infection',52,7),(184,'Kidney','Internal Injuries',93,4),(185,'Kidney','Organ Transmutation',3,61),(186,'Heart','Organ Cancer',32,44),(187,'Intestine','Chronic Disease',52,13),(188,'Pancreas','Body Fluid Imbalance',1,96),(189,'Kidney','Tissue rupture',13,85),(190,'Kidney','Injury in accident',53,99),(191,'Pancreas','Genetic Mutation',94,18),(192,'Lung','Organ Failure',49,26),(193,'Pancreas','Cellular Infection',89,68),(194,'Intestine','Internal Injuries',59,19),(195,'Heart','Organ Transmutation',57,31),(196,'Heart','Organ Cancer',19,57),(197,'Intestine','Chronic Disease',7,59),(198,'Lung','Body Fluid Imbalance',82,71),(199,'Lung','Tissue rupture',86,31),(181181,'pancreas','Genetic Mutation',5,6);
/*!40000 ALTER TABLE `Patient` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_0900_ai_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `ADD_PATIENT_LOG` AFTER INSERT ON `Patient` FOR EACH ROW begin
insert into log values
(now(), concat("Inserted new Patient ", cast(new.Patient_Id as char)));
end */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_0900_ai_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `UPD_PATIENT_LOG` AFTER UPDATE ON `Patient` FOR EACH ROW begin
insert into log values
(now(), concat("Updated Patient Details ", cast(new.Patient_Id as char)));
end */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `Transaction`
--

DROP TABLE IF EXISTS `Transaction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Transaction` (
  `Patient_ID` int NOT NULL,
  `Organ_ID` int NOT NULL,
  `Donor_ID` int NOT NULL,
  `Date_of_transaction` date NOT NULL,
  `Status` int NOT NULL,
  PRIMARY KEY (`Patient_ID`,`Organ_ID`),
  KEY `Donor_ID` (`Donor_ID`),
  CONSTRAINT `Transaction_ibfk_1` FOREIGN KEY (`Patient_ID`) REFERENCES `Patient` (`Patient_ID`) ON DELETE CASCADE,
  CONSTRAINT `Transaction_ibfk_2` FOREIGN KEY (`Donor_ID`) REFERENCES `Donor` (`Donor_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Transaction`
--

LOCK TABLES `Transaction` WRITE;
/*!40000 ALTER TABLE `Transaction` DISABLE KEYS */;
INSERT INTO `Transaction` VALUES (1,93,93,'2012-04-12',0),(4,155,155,'2015-05-29',0),(6,58,58,'2016-10-26',0),(7,172,172,'2012-10-10',0),(8,71,71,'2016-05-02',0),(10,147,147,'2016-03-08',0),(12,145,145,'2016-11-26',0),(19,4,4,'2014-11-10',0),(20,129,129,'2014-10-10',0),(21,144,144,'2012-12-11',0),(22,7,7,'2014-09-19',0),(26,23,23,'2013-08-24',1),(28,143,143,'2017-12-13',0),(30,82,82,'2014-07-25',1),(31,152,152,'2014-09-04',1),(32,119,119,'2017-05-22',0),(33,162,162,'2016-12-16',0),(34,106,106,'2014-03-12',1),(36,123,123,'2016-12-03',0),(37,91,91,'2016-07-13',1),(38,102,102,'2012-08-18',1),(39,170,170,'2017-06-22',0),(43,130,130,'2013-07-24',0),(50,66,66,'2013-11-25',1),(51,149,149,'2017-01-29',0),(52,101,101,'2017-07-25',0),(55,134,134,'2013-06-19',1),(58,87,87,'2012-05-07',1),(60,186,186,'2014-09-02',1),(63,131,131,'2017-09-02',1),(65,94,94,'2015-10-20',0),(68,17,17,'2012-05-15',1),(69,97,97,'2015-12-21',1),(70,60,60,'2013-02-16',1),(72,191,191,'2012-09-21',1),(73,36,36,'2017-03-27',0),(74,64,64,'2013-12-04',0),(75,2,2,'2016-12-09',0),(76,196,196,'2012-06-03',0),(77,69,69,'2017-03-10',0),(78,40,40,'2014-06-22',0),(79,76,76,'2015-12-23',0),(82,96,96,'2014-12-21',1),(83,20,20,'2012-11-05',0),(84,193,193,'2016-04-04',0),(85,9,9,'2012-01-23',0),(86,184,184,'2013-11-11',0),(88,160,160,'2017-01-28',0),(90,195,195,'2014-03-15',0),(91,126,126,'2014-10-20',1),(97,19,19,'2013-04-30',1),(103,117,117,'2016-12-28',0),(104,1,1,'2012-04-24',0),(105,109,109,'2016-12-24',0),(107,173,173,'2017-09-18',1),(108,28,28,'2015-08-01',0),(109,181,181,'2014-05-22',0),(110,53,53,'2017-01-12',1),(111,164,164,'2012-04-02',1),(112,18,18,'2017-05-18',0),(113,110,110,'2013-09-28',1),(115,166,166,'2012-02-29',0),(116,168,168,'2014-07-15',0),(119,27,27,'2017-11-04',0),(120,121,121,'2015-04-04',1),(124,29,29,'2015-04-13',1),(125,188,188,'2014-07-06',0),(127,32,32,'2014-03-15',0),(136,198,198,'2013-05-21',0),(142,44,44,'2016-06-08',1),(143,156,156,'2016-10-22',0),(145,72,72,'2017-11-19',1),(147,177,177,'2013-01-12',0),(149,30,30,'2017-07-29',0),(153,95,95,'2015-12-28',0),(156,154,154,'2017-04-10',1),(161,78,78,'2012-05-26',1),(162,52,52,'2016-03-29',1),(163,80,80,'2016-09-28',0),(167,111,111,'2015-10-14',1),(169,165,165,'2014-05-30',1),(172,21,21,'2014-03-01',1),(174,77,77,'2013-08-04',0),(175,50,50,'2012-07-19',0),(176,107,107,'2013-02-10',1),(179,138,138,'2016-12-07',0),(182,48,48,'2013-04-27',0),(183,16,16,'2014-03-05',0),(184,57,57,'2012-06-09',1),(185,8,8,'2014-09-24',0),(186,83,83,'2016-12-22',1),(188,153,153,'2015-11-15',1),(189,15,15,'2013-04-30',0),(190,22,22,'2013-05-23',1),(191,120,120,'2015-10-06',0),(195,67,67,'2017-02-26',0),(196,135,135,'2017-09-23',1),(197,157,157,'2015-05-03',0),(199,10,10,'2016-09-28',1);
/*!40000 ALTER TABLE `Transaction` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_0900_ai_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `ADD_TRASACTION_LOG` AFTER INSERT ON `Transaction` FOR EACH ROW begin
insert into log values
(now(), concat("Added Transaction :: Patient ID : ", cast(new.Patient_ID as char), "; Donor ID : " ,cast(new.Donor_ID as char)));
end */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;

--
-- Table structure for table `User`
--

DROP TABLE IF EXISTS `User`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `User` (
  `User_ID` int NOT NULL,
  `Name` varchar(20) NOT NULL,
  `Date_of_Birth` date NOT NULL,
  `Medical_insurance` int DEFAULT NULL,
  `Medical_history` varchar(20) DEFAULT NULL,
  `Street` varchar(20) DEFAULT NULL,
  `City` varchar(20) DEFAULT NULL,
  `State` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`User_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `User`
--

LOCK TABLES `User` WRITE;
/*!40000 ALTER TABLE `User` DISABLE KEYS */;
INSERT INTO `User` VALUES (1,'Amit Shah','1978-08-21',1,'NIL','Street-1','New Delhi','Delhi'),(2,'Virat Kohli','1975-12-10',0,'NIL','Street-2','Mumbai','Maharashtra'),(3,'Rohit Sharma','1976-06-04',0,'NIL','Street-3','Mumbai','Maharashtra'),(4,'MS Dhoni','1985-10-13',1,'NIL','Street-4','Ahmedabad','Gujarat'),(5,'Jay Shah','1983-10-12',1,'NIL','Street-5','Kolkata','West Bengal'),(6,'Eren Yeager','1977-01-18',1,'NIL','Street-6','Kolkata','West Bengal'),(7,'Roronoa Zoro','1976-02-26',0,'NIL','Street-7','New Delhi','Delhi'),(8,'Allu Arjun','1973-04-12',1,'NIL','Street-8','Mumbai','Maharashtra'),(9,'MK Gandhi','1976-11-01',0,'NIL','Street-9','Mumbai','Maharashtra'),(10,'Abhinav Arora','1978-11-18',1,'NIL','Street-10','New Delhi','Delhi'),(11,'Amit Shah','1975-01-06',1,'NIL','Street-11','Mumbai','Maharashtra'),(12,'Virat Kohli','1983-11-01',1,'NIL','Street-12','Mumbai','Maharashtra'),(13,'Rohit Sharma','1983-01-09',1,'NIL','Street-13','New Delhi','Delhi'),(14,'MS Dhoni','1975-10-12',1,'NIL','Street-14','Mumbai','Maharashtra'),(15,'Jay Shah','1977-09-23',0,'NIL','Street-15','Ahmedabad','Gujarat'),(16,'Eren Yeager','1982-11-29',1,'NIL','Street-16','New Delhi','Delhi'),(17,'Roronoa Zoro','1974-03-19',0,'NIL','Street-17','Mumbai','Maharashtra'),(18,'Allu Arjun','1973-10-27',0,'NIL','Street-18','New Delhi','Delhi'),(19,'MK Gandhi','1980-03-18',0,'NIL','Street-19','Kolkata','West Bengal'),(20,'Abhinav Arora','1978-08-15',1,'NIL','Street-20','Kolkata','West Bengal'),(21,'Amit Shah','1975-10-12',1,'NIL','Street-21','Mumbai','Maharashtra'),(22,'Virat Kohli','1983-02-19',1,'NIL','Street-22','Ahmedabad','Gujarat'),(23,'Rohit Sharma','1987-03-30',1,'NIL','Street-23','Mumbai','Maharashtra'),(24,'MS Dhoni','1979-10-28',1,'NIL','Street-24','Ahmedabad','Gujarat'),(25,'Jay Shah','1987-07-26',1,'NIL','Street-25','Kolkata','West Bengal'),(26,'Eren Yeager','1987-12-23',0,'NIL','Street-26','New Delhi','Delhi'),(27,'Roronoa Zoro','1982-04-29',1,'NIL','Street-27','Kolkata','West Bengal'),(28,'Allu Arjun','1984-03-09',0,'NIL','Street-28','Kolkata','West Bengal'),(29,'MK Gandhi','1985-01-04',0,'NIL','Street-29','Mumbai','Maharashtra'),(30,'Abhinav Arora','1981-05-19',0,'NIL','Street-30','Kolkata','West Bengal'),(31,'Amit Shah','1981-11-05',1,'NIL','Street-31','New Delhi','Delhi'),(32,'Virat Kohli','1975-07-06',1,'NIL','Street-32','New Delhi','Delhi'),(33,'Rohit Sharma','1984-09-04',1,'NIL','Street-33','New Delhi','Delhi'),(34,'MS Dhoni','1985-06-09',1,'NIL','Street-34','New Delhi','Delhi'),(35,'Jay Shah','1984-11-16',0,'NIL','Street-35','Ahmedabad','Gujarat'),(36,'Eren Yeager','1973-04-19',1,'NIL','Street-36','New Delhi','Delhi'),(37,'Roronoa Zoro','1977-05-19',0,'NIL','Street-37','Kolkata','West Bengal'),(38,'Allu Arjun','1985-05-10',0,'NIL','Street-38','New Delhi','Delhi'),(39,'MK Gandhi','1975-04-02',0,'NIL','Street-39','Kolkata','West Bengal'),(40,'Abhinav Arora','1978-02-20',1,'NIL','Street-40','Mumbai','Maharashtra'),(41,'Amit Shah','1987-02-19',0,'NIL','Street-41','Mumbai','Maharashtra'),(42,'Virat Kohli','1975-11-30',0,'NIL','Street-42','Mumbai','Maharashtra'),(43,'Rohit Sharma','1986-12-18',1,'NIL','Street-43','Mumbai','Maharashtra'),(44,'MS Dhoni','1979-02-21',1,'NIL','Street-44','New Delhi','Delhi'),(45,'Jay Shah','1986-09-02',0,'NIL','Street-45','Ahmedabad','Gujarat'),(46,'Eren Yeager','1983-12-13',0,'NIL','Street-46','Mumbai','Maharashtra'),(47,'Roronoa Zoro','1977-09-28',0,'NIL','Street-47','Mumbai','Maharashtra'),(48,'Allu Arjun','1979-01-09',1,'NIL','Street-48','Kolkata','West Bengal'),(49,'MK Gandhi','1985-03-08',1,'NIL','Street-49','Mumbai','Maharashtra'),(50,'Abhinav Arora','1974-01-03',1,'NIL','Street-50','Mumbai','Maharashtra'),(51,'Amit Shah','1976-07-05',1,'NIL','Street-51','New Delhi','Delhi'),(52,'Virat Kohli','1973-04-16',0,'NIL','Street-52','New Delhi','Delhi'),(53,'Rohit Sharma','1985-06-29',0,'NIL','Street-53','Ahmedabad','Gujarat'),(54,'MS Dhoni','1976-04-02',0,'NIL','Street-54','Ahmedabad','Gujarat'),(55,'Jay Shah','1974-12-23',0,'NIL','Street-55','Ahmedabad','Gujarat'),(56,'Eren Yeager','1982-02-08',0,'NIL','Street-56','Kolkata','West Bengal'),(57,'Roronoa Zoro','1976-01-09',0,'NIL','Street-57','Kolkata','West Bengal'),(58,'Allu Arjun','1982-02-12',1,'NIL','Street-58','New Delhi','Delhi'),(59,'MK Gandhi','1974-03-17',0,'NIL','Street-59','Ahmedabad','Gujarat'),(60,'Abhinav Arora','1986-03-01',1,'NIL','Street-60','Mumbai','Maharashtra'),(61,'Amit Shah','1984-02-09',1,'NIL','Street-61','Mumbai','Maharashtra'),(62,'Virat Kohli','1986-01-24',1,'NIL','Street-62','New Delhi','Delhi'),(63,'Rohit Sharma','1985-12-27',0,'NIL','Street-63','Kolkata','West Bengal'),(64,'MS Dhoni','1973-06-29',0,'NIL','Street-64','Mumbai','Maharashtra'),(65,'Jay Shah','1984-04-06',1,'NIL','Street-65','Kolkata','West Bengal'),(66,'Eren Yeager','1982-05-16',1,'NIL','Street-66','Ahmedabad','Gujarat'),(67,'Roronoa Zoro','1979-05-10',0,'NIL','Street-67','Mumbai','Maharashtra'),(68,'Allu Arjun','1984-08-07',1,'NIL','Street-68','New Delhi','Delhi'),(69,'MK Gandhi','1987-02-24',0,'NIL','Street-69','Ahmedabad','Gujarat'),(70,'Abhinav Arora','1979-06-21',0,'NIL','Street-70','Mumbai','Maharashtra'),(71,'Amit Shah','1987-10-24',0,'NIL','Street-71','Kolkata','West Bengal'),(72,'Virat Kohli','1983-06-07',1,'NIL','Street-72','Ahmedabad','Gujarat'),(73,'Rohit Sharma','1977-12-15',0,'NIL','Street-73','Mumbai','Maharashtra'),(74,'MS Dhoni','1984-07-02',0,'NIL','Street-74','Ahmedabad','Gujarat'),(75,'Jay Shah','1986-03-24',1,'NIL','Street-75','Ahmedabad','Gujarat'),(76,'Eren Yeager','1986-02-06',0,'NIL','Street-76','Kolkata','West Bengal'),(77,'Roronoa Zoro','1977-11-06',1,'NIL','Street-77','Ahmedabad','Gujarat'),(78,'Allu Arjun','1978-07-20',0,'NIL','Street-78','Ahmedabad','Gujarat'),(79,'MK Gandhi','1983-04-29',1,'NIL','Street-79','Kolkata','West Bengal'),(80,'Abhinav Arora','1980-03-05',0,'NIL','Street-80','Ahmedabad','Gujarat'),(81,'Amit Shah','1986-12-17',1,'NIL','Street-81','New Delhi','Delhi'),(82,'Virat Kohli','1983-01-01',1,'NIL','Street-82','Mumbai','Maharashtra'),(83,'Rohit Sharma','1979-02-03',1,'NIL','Street-83','Mumbai','Maharashtra'),(84,'MS Dhoni','1984-04-16',0,'NIL','Street-84','Mumbai','Maharashtra'),(85,'Jay Shah','1985-10-18',1,'NIL','Street-85','Kolkata','West Bengal'),(86,'Eren Yeager','1977-07-15',1,'NIL','Street-86','Mumbai','Maharashtra'),(87,'Roronoa Zoro','1981-08-08',0,'NIL','Street-87','New Delhi','Delhi'),(88,'Allu Arjun','1982-04-04',1,'NIL','Street-88','Mumbai','Maharashtra'),(89,'MK Gandhi','1982-12-20',1,'NIL','Street-89','Ahmedabad','Gujarat'),(90,'Abhinav Arora','1983-04-08',1,'NIL','Street-90','Kolkata','West Bengal'),(91,'Amit Shah','1981-11-17',1,'NIL','Street-91','Ahmedabad','Gujarat'),(92,'Virat Kohli','1986-08-10',1,'NIL','Street-92','Ahmedabad','Gujarat'),(93,'Rohit Sharma','1985-05-05',0,'NIL','Street-93','Ahmedabad','Gujarat'),(94,'MS Dhoni','1977-01-10',0,'NIL','Street-94','Kolkata','West Bengal'),(95,'Jay Shah','1985-01-30',0,'NIL','Street-95','Ahmedabad','Gujarat'),(96,'Eren Yeager','1987-02-04',1,'NIL','Street-96','Kolkata','West Bengal'),(97,'Roronoa Zoro','1985-12-22',1,'NIL','Street-97','Kolkata','West Bengal'),(98,'Allu Arjun','1981-08-06',1,'NIL','Street-98','Mumbai','Maharashtra'),(99,'MK Gandhi','1978-01-15',1,'NIL','Street-99','Kolkata','West Bengal');
/*!40000 ALTER TABLE `User` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `User_phone_no`
--

DROP TABLE IF EXISTS `User_phone_no`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `User_phone_no` (
  `User_ID` int NOT NULL,
  `phone_no` varchar(15) DEFAULT NULL,
  KEY `User_ID` (`User_ID`),
  CONSTRAINT `User_phone_no_ibfk_1` FOREIGN KEY (`User_ID`) REFERENCES `User` (`User_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `User_phone_no`
--

LOCK TABLES `User_phone_no` WRITE;
/*!40000 ALTER TABLE `User_phone_no` DISABLE KEYS */;
INSERT INTO `User_phone_no` VALUES (2,'9999999999');
/*!40000 ALTER TABLE `User_phone_no` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log` (
  `querytime` datetime DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log`
--

LOCK TABLES `log` WRITE;
/*!40000 ALTER TABLE `log` DISABLE KEYS */;
INSERT INTO `log` VALUES ('2024-11-13 21:14:01','Inserted new Patient 1'),('2024-11-13 21:14:01','Inserted new Patient 2'),('2024-11-13 21:14:01','Inserted new Patient 3'),('2024-11-13 21:14:01','Inserted new Patient 4'),('2024-11-13 21:14:01','Inserted new Patient 5'),('2024-11-13 21:14:01','Inserted new Patient 6'),('2024-11-13 21:14:01','Inserted new Patient 7'),('2024-11-13 21:14:01','Inserted new Patient 8'),('2024-11-13 21:14:01','Inserted new Patient 9'),('2024-11-13 21:14:01','Inserted new Patient 10'),('2024-11-13 21:14:01','Inserted new Patient 11'),('2024-11-13 21:14:01','Inserted new Patient 12'),('2024-11-13 21:14:01','Inserted new Patient 13'),('2024-11-13 21:14:01','Inserted new Patient 14'),('2024-11-13 21:14:01','Inserted new Patient 15'),('2024-11-13 21:14:01','Inserted new Patient 16'),('2024-11-13 21:14:01','Inserted new Patient 17'),('2024-11-13 21:14:01','Inserted new Patient 18'),('2024-11-13 21:14:01','Inserted new Patient 19'),('2024-11-13 21:14:01','Inserted new Patient 20'),('2024-11-13 21:14:01','Inserted new Patient 21'),('2024-11-13 21:14:01','Inserted new Patient 22'),('2024-11-13 21:14:01','Inserted new Patient 23'),('2024-11-13 21:14:01','Inserted new Patient 24'),('2024-11-13 21:14:01','Inserted new Patient 25'),('2024-11-13 21:14:01','Inserted new Patient 26'),('2024-11-13 21:14:01','Inserted new Patient 27'),('2024-11-13 21:14:01','Inserted new Patient 28'),('2024-11-13 21:14:01','Inserted new Patient 29'),('2024-11-13 21:14:01','Inserted new Patient 30'),('2024-11-13 21:14:01','Inserted new Patient 31'),('2024-11-13 21:14:01','Inserted new Patient 32'),('2024-11-13 21:14:01','Inserted new Patient 33'),('2024-11-13 21:14:01','Inserted new Patient 34'),('2024-11-13 21:14:01','Inserted new Patient 35'),('2024-11-13 21:14:01','Inserted new Patient 36'),('2024-11-13 21:14:01','Inserted new Patient 37'),('2024-11-13 21:14:01','Inserted new Patient 38'),('2024-11-13 21:14:01','Inserted new Patient 39'),('2024-11-13 21:14:01','Inserted new Patient 40'),('2024-11-13 21:14:01','Inserted new Patient 41'),('2024-11-13 21:14:01','Inserted new Patient 42'),('2024-11-13 21:14:01','Inserted new Patient 43'),('2024-11-13 21:14:01','Inserted new Patient 44'),('2024-11-13 21:14:01','Inserted new Patient 45'),('2024-11-13 21:14:01','Inserted new Patient 46'),('2024-11-13 21:14:01','Inserted new Patient 47'),('2024-11-13 21:14:01','Inserted new Patient 48'),('2024-11-13 21:14:01','Inserted new Patient 49'),('2024-11-13 21:14:01','Inserted new Patient 50'),('2024-11-13 21:14:01','Inserted new Patient 51'),('2024-11-13 21:14:01','Inserted new Patient 52'),('2024-11-13 21:14:01','Inserted new Patient 53'),('2024-11-13 21:14:01','Inserted new Patient 54'),('2024-11-13 21:14:01','Inserted new Patient 55'),('2024-11-13 21:14:01','Inserted new Patient 56'),('2024-11-13 21:14:01','Inserted new Patient 57'),('2024-11-13 21:14:01','Inserted new Patient 58'),('2024-11-13 21:14:01','Inserted new Patient 59'),('2024-11-13 21:14:01','Inserted new Patient 60'),('2024-11-13 21:14:01','Inserted new Patient 61'),('2024-11-13 21:14:01','Inserted new Patient 62'),('2024-11-13 21:14:01','Inserted new Patient 63'),('2024-11-13 21:14:01','Inserted new Patient 64'),('2024-11-13 21:14:01','Inserted new Patient 65'),('2024-11-13 21:14:01','Inserted new Patient 66'),('2024-11-13 21:14:01','Inserted new Patient 67'),('2024-11-13 21:14:01','Inserted new Patient 68'),('2024-11-13 21:14:01','Inserted new Patient 69'),('2024-11-13 21:14:01','Inserted new Patient 70'),('2024-11-13 21:14:01','Inserted new Patient 71'),('2024-11-13 21:14:01','Inserted new Patient 72'),('2024-11-13 21:14:01','Inserted new Patient 73'),('2024-11-13 21:14:01','Inserted new Patient 74'),('2024-11-13 21:14:01','Inserted new Patient 75'),('2024-11-13 21:14:01','Inserted new Patient 76'),('2024-11-13 21:14:01','Inserted new Patient 77'),('2024-11-13 21:14:01','Inserted new Patient 78'),('2024-11-13 21:14:01','Inserted new Patient 79'),('2024-11-13 21:14:01','Inserted new Patient 80'),('2024-11-13 21:14:01','Inserted new Patient 81'),('2024-11-13 21:14:01','Inserted new Patient 82'),('2024-11-13 21:14:01','Inserted new Patient 83'),('2024-11-13 21:14:01','Inserted new Patient 84'),('2024-11-13 21:14:01','Inserted new Patient 85'),('2024-11-13 21:14:01','Inserted new Patient 86'),('2024-11-13 21:14:01','Inserted new Patient 87'),('2024-11-13 21:14:01','Inserted new Patient 88'),('2024-11-13 21:14:01','Inserted new Patient 89'),('2024-11-13 21:14:01','Inserted new Patient 90'),('2024-11-13 21:14:01','Inserted new Patient 91'),('2024-11-13 21:14:01','Inserted new Patient 92'),('2024-11-13 21:14:01','Inserted new Patient 93'),('2024-11-13 21:14:01','Inserted new Patient 94'),('2024-11-13 21:14:01','Inserted new Patient 95'),('2024-11-13 21:14:01','Inserted new Patient 96'),('2024-11-13 21:14:01','Inserted new Patient 97'),('2024-11-13 21:14:01','Inserted new Patient 98'),('2024-11-13 21:14:01','Inserted new Patient 99'),('2024-11-13 21:14:01','Inserted new Patient 100'),('2024-11-13 21:14:01','Inserted new Patient 101'),('2024-11-13 21:14:01','Inserted new Patient 102'),('2024-11-13 21:14:01','Inserted new Patient 103'),('2024-11-13 21:14:01','Inserted new Patient 104'),('2024-11-13 21:14:01','Inserted new Patient 105'),('2024-11-13 21:14:01','Inserted new Patient 106'),('2024-11-13 21:14:01','Inserted new Patient 107'),('2024-11-13 21:14:01','Inserted new Patient 108'),('2024-11-13 21:14:01','Inserted new Patient 109'),('2024-11-13 21:14:01','Inserted new Patient 110'),('2024-11-13 21:14:01','Inserted new Patient 111'),('2024-11-13 21:14:01','Inserted new Patient 112'),('2024-11-13 21:14:01','Inserted new Patient 113'),('2024-11-13 21:14:01','Inserted new Patient 114'),('2024-11-13 21:14:01','Inserted new Patient 115'),('2024-11-13 21:14:01','Inserted new Patient 116'),('2024-11-13 21:14:01','Inserted new Patient 117'),('2024-11-13 21:14:01','Inserted new Patient 118'),('2024-11-13 21:14:01','Inserted new Patient 119'),('2024-11-13 21:14:01','Inserted new Patient 120'),('2024-11-13 21:14:01','Inserted new Patient 121'),('2024-11-13 21:14:01','Inserted new Patient 122'),('2024-11-13 21:14:01','Inserted new Patient 123'),('2024-11-13 21:14:01','Inserted new Patient 124'),('2024-11-13 21:14:01','Inserted new Patient 125'),('2024-11-13 21:14:01','Inserted new Patient 126'),('2024-11-13 21:14:01','Inserted new Patient 127'),('2024-11-13 21:14:01','Inserted new Patient 128'),('2024-11-13 21:14:01','Inserted new Patient 129'),('2024-11-13 21:14:01','Inserted new Patient 130'),('2024-11-13 21:14:01','Inserted new Patient 131'),('2024-11-13 21:14:01','Inserted new Patient 132'),('2024-11-13 21:14:01','Inserted new Patient 133'),('2024-11-13 21:14:01','Inserted new Patient 134'),('2024-11-13 21:14:01','Inserted new Patient 135'),('2024-11-13 21:14:01','Inserted new Patient 136'),('2024-11-13 21:14:01','Inserted new Patient 137'),('2024-11-13 21:14:01','Inserted new Patient 138'),('2024-11-13 21:14:01','Inserted new Patient 139'),('2024-11-13 21:14:01','Inserted new Patient 140'),('2024-11-13 21:14:01','Inserted new Patient 141'),('2024-11-13 21:14:01','Inserted new Patient 142'),('2024-11-13 21:14:01','Inserted new Patient 143'),('2024-11-13 21:14:01','Inserted new Patient 144'),('2024-11-13 21:14:01','Inserted new Patient 145'),('2024-11-13 21:14:01','Inserted new Patient 146'),('2024-11-13 21:14:01','Inserted new Patient 147'),('2024-11-13 21:14:01','Inserted new Patient 148'),('2024-11-13 21:14:01','Inserted new Patient 149'),('2024-11-13 21:14:01','Inserted new Patient 150'),('2024-11-13 21:14:01','Inserted new Patient 151'),('2024-11-13 21:14:01','Inserted new Patient 152'),('2024-11-13 21:14:01','Inserted new Patient 153'),('2024-11-13 21:14:01','Inserted new Patient 154'),('2024-11-13 21:14:01','Inserted new Patient 155'),('2024-11-13 21:14:01','Inserted new Patient 156'),('2024-11-13 21:14:01','Inserted new Patient 157'),('2024-11-13 21:14:01','Inserted new Patient 158'),('2024-11-13 21:14:01','Inserted new Patient 159'),('2024-11-13 21:14:01','Inserted new Patient 160'),('2024-11-13 21:14:01','Inserted new Patient 161'),('2024-11-13 21:14:01','Inserted new Patient 162'),('2024-11-13 21:14:01','Inserted new Patient 163'),('2024-11-13 21:14:01','Inserted new Patient 164'),('2024-11-13 21:14:01','Inserted new Patient 165'),('2024-11-13 21:14:01','Inserted new Patient 166'),('2024-11-13 21:14:01','Inserted new Patient 167'),('2024-11-13 21:14:01','Inserted new Patient 168'),('2024-11-13 21:14:01','Inserted new Patient 169'),('2024-11-13 21:14:01','Inserted new Patient 170'),('2024-11-13 21:14:01','Inserted new Patient 171'),('2024-11-13 21:14:01','Inserted new Patient 172'),('2024-11-13 21:14:01','Inserted new Patient 173'),('2024-11-13 21:14:01','Inserted new Patient 174'),('2024-11-13 21:14:01','Inserted new Patient 175'),('2024-11-13 21:14:01','Inserted new Patient 176'),('2024-11-13 21:14:01','Inserted new Patient 177'),('2024-11-13 21:14:01','Inserted new Patient 178'),('2024-11-13 21:14:01','Inserted new Patient 179'),('2024-11-13 21:14:01','Inserted new Patient 180'),('2024-11-13 21:14:01','Inserted new Patient 181'),('2024-11-13 21:14:01','Inserted new Patient 182'),('2024-11-13 21:14:01','Inserted new Patient 183'),('2024-11-13 21:14:01','Inserted new Patient 184'),('2024-11-13 21:14:01','Inserted new Patient 185'),('2024-11-13 21:14:01','Inserted new Patient 186'),('2024-11-13 21:14:01','Inserted new Patient 187'),('2024-11-13 21:14:01','Inserted new Patient 188'),('2024-11-13 21:14:01','Inserted new Patient 189'),('2024-11-13 21:14:01','Inserted new Patient 190'),('2024-11-13 21:14:01','Inserted new Patient 191'),('2024-11-13 21:14:01','Inserted new Patient 192'),('2024-11-13 21:14:01','Inserted new Patient 193'),('2024-11-13 21:14:01','Inserted new Patient 194'),('2024-11-13 21:14:01','Inserted new Patient 195'),('2024-11-13 21:14:01','Inserted new Patient 196'),('2024-11-13 21:14:01','Inserted new Patient 197'),('2024-11-13 21:14:01','Inserted new Patient 198'),('2024-11-13 21:14:01','Inserted new Patient 199'),('2024-11-13 21:14:20','Inserted new Donor1'),('2024-11-13 21:14:20','Inserted new Donor2'),('2024-11-13 21:14:20','Inserted new Donor3'),('2024-11-13 21:14:20','Inserted new Donor4'),('2024-11-13 21:14:20','Inserted new Donor5'),('2024-11-13 21:14:20','Inserted new Donor6'),('2024-11-13 21:14:20','Inserted new Donor7'),('2024-11-13 21:14:20','Inserted new Donor8'),('2024-11-13 21:14:20','Inserted new Donor9'),('2024-11-13 21:14:20','Inserted new Donor10'),('2024-11-13 21:14:20','Inserted new Donor11'),('2024-11-13 21:14:20','Inserted new Donor12'),('2024-11-13 21:14:20','Inserted new Donor13'),('2024-11-13 21:14:20','Inserted new Donor14'),('2024-11-13 21:14:20','Inserted new Donor15'),('2024-11-13 21:14:20','Inserted new Donor16'),('2024-11-13 21:14:20','Inserted new Donor17'),('2024-11-13 21:14:20','Inserted new Donor18'),('2024-11-13 21:14:20','Inserted new Donor19'),('2024-11-13 21:14:20','Inserted new Donor20'),('2024-11-13 21:14:20','Inserted new Donor21'),('2024-11-13 21:14:20','Inserted new Donor22'),('2024-11-13 21:14:20','Inserted new Donor23'),('2024-11-13 21:14:20','Inserted new Donor24'),('2024-11-13 21:14:20','Inserted new Donor25'),('2024-11-13 21:14:20','Inserted new Donor26'),('2024-11-13 21:14:20','Inserted new Donor27'),('2024-11-13 21:14:20','Inserted new Donor28'),('2024-11-13 21:14:20','Inserted new Donor29'),('2024-11-13 21:14:20','Inserted new Donor30'),('2024-11-13 21:14:20','Inserted new Donor31'),('2024-11-13 21:14:20','Inserted new Donor32'),('2024-11-13 21:14:20','Inserted new Donor33'),('2024-11-13 21:14:20','Inserted new Donor34'),('2024-11-13 21:14:20','Inserted new Donor35'),('2024-11-13 21:14:20','Inserted new Donor36'),('2024-11-13 21:14:20','Inserted new Donor37'),('2024-11-13 21:14:20','Inserted new Donor38'),('2024-11-13 21:14:20','Inserted new Donor39'),('2024-11-13 21:14:20','Inserted new Donor40'),('2024-11-13 21:14:20','Inserted new Donor41'),('2024-11-13 21:14:20','Inserted new Donor42'),('2024-11-13 21:14:20','Inserted new Donor43'),('2024-11-13 21:14:20','Inserted new Donor44'),('2024-11-13 21:14:20','Inserted new Donor45'),('2024-11-13 21:14:20','Inserted new Donor46'),('2024-11-13 21:14:20','Inserted new Donor47'),('2024-11-13 21:14:20','Inserted new Donor48'),('2024-11-13 21:14:20','Inserted new Donor49'),('2024-11-13 21:14:20','Inserted new Donor50'),('2024-11-13 21:14:20','Inserted new Donor51'),('2024-11-13 21:14:20','Inserted new Donor52'),('2024-11-13 21:14:20','Inserted new Donor53'),('2024-11-13 21:14:20','Inserted new Donor54'),('2024-11-13 21:14:20','Inserted new Donor55'),('2024-11-13 21:14:20','Inserted new Donor56'),('2024-11-13 21:14:20','Inserted new Donor57'),('2024-11-13 21:14:20','Inserted new Donor58'),('2024-11-13 21:14:20','Inserted new Donor59'),('2024-11-13 21:14:20','Inserted new Donor60'),('2024-11-13 21:14:20','Inserted new Donor61'),('2024-11-13 21:14:20','Inserted new Donor62'),('2024-11-13 21:14:20','Inserted new Donor63'),('2024-11-13 21:14:20','Inserted new Donor64'),('2024-11-13 21:14:20','Inserted new Donor65'),('2024-11-13 21:14:20','Inserted new Donor66'),('2024-11-13 21:14:20','Inserted new Donor67'),('2024-11-13 21:14:20','Inserted new Donor68'),('2024-11-13 21:14:20','Inserted new Donor69'),('2024-11-13 21:14:20','Inserted new Donor70'),('2024-11-13 21:14:20','Inserted new Donor71'),('2024-11-13 21:14:20','Inserted new Donor72'),('2024-11-13 21:14:20','Inserted new Donor73'),('2024-11-13 21:14:20','Inserted new Donor74'),('2024-11-13 21:14:20','Inserted new Donor75'),('2024-11-13 21:14:20','Inserted new Donor76'),('2024-11-13 21:14:20','Inserted new Donor77'),('2024-11-13 21:14:20','Inserted new Donor78'),('2024-11-13 21:14:20','Inserted new Donor79'),('2024-11-13 21:14:20','Inserted new Donor80'),('2024-11-13 21:14:20','Inserted new Donor81'),('2024-11-13 21:14:20','Inserted new Donor82'),('2024-11-13 21:14:20','Inserted new Donor83'),('2024-11-13 21:14:20','Inserted new Donor84'),('2024-11-13 21:14:20','Inserted new Donor85'),('2024-11-13 21:14:20','Inserted new Donor86'),('2024-11-13 21:14:20','Inserted new Donor87'),('2024-11-13 21:14:20','Inserted new Donor88'),('2024-11-13 21:14:20','Inserted new Donor89'),('2024-11-13 21:14:20','Inserted new Donor90'),('2024-11-13 21:14:20','Inserted new Donor91'),('2024-11-13 21:14:20','Inserted new Donor92'),('2024-11-13 21:14:20','Inserted new Donor93'),('2024-11-13 21:14:20','Inserted new Donor94'),('2024-11-13 21:14:20','Inserted new Donor95'),('2024-11-13 21:14:20','Inserted new Donor96'),('2024-11-13 21:14:20','Inserted new Donor97'),('2024-11-13 21:14:20','Inserted new Donor98'),('2024-11-13 21:14:20','Inserted new Donor99'),('2024-11-13 21:14:20','Inserted new Donor100'),('2024-11-13 21:14:20','Inserted new Donor101'),('2024-11-13 21:14:20','Inserted new Donor102'),('2024-11-13 21:14:20','Inserted new Donor103'),('2024-11-13 21:14:20','Inserted new Donor104'),('2024-11-13 21:14:20','Inserted new Donor105'),('2024-11-13 21:14:20','Inserted new Donor106'),('2024-11-13 21:14:20','Inserted new Donor107'),('2024-11-13 21:14:20','Inserted new Donor108'),('2024-11-13 21:14:20','Inserted new Donor109'),('2024-11-13 21:14:20','Inserted new Donor110'),('2024-11-13 21:14:20','Inserted new Donor111'),('2024-11-13 21:14:20','Inserted new Donor112'),('2024-11-13 21:14:20','Inserted new Donor113'),('2024-11-13 21:14:20','Inserted new Donor114'),('2024-11-13 21:14:20','Inserted new Donor115'),('2024-11-13 21:14:20','Inserted new Donor116'),('2024-11-13 21:14:20','Inserted new Donor117'),('2024-11-13 21:14:20','Inserted new Donor118'),('2024-11-13 21:14:20','Inserted new Donor119'),('2024-11-13 21:14:20','Inserted new Donor120'),('2024-11-13 21:14:20','Inserted new Donor121'),('2024-11-13 21:14:20','Inserted new Donor122'),('2024-11-13 21:14:20','Inserted new Donor123'),('2024-11-13 21:14:20','Inserted new Donor124'),('2024-11-13 21:14:20','Inserted new Donor125'),('2024-11-13 21:14:20','Inserted new Donor126'),('2024-11-13 21:14:20','Inserted new Donor127'),('2024-11-13 21:14:20','Inserted new Donor128'),('2024-11-13 21:14:20','Inserted new Donor129'),('2024-11-13 21:14:20','Inserted new Donor130'),('2024-11-13 21:14:20','Inserted new Donor131'),('2024-11-13 21:14:20','Inserted new Donor132'),('2024-11-13 21:14:20','Inserted new Donor133'),('2024-11-13 21:14:20','Inserted new Donor134'),('2024-11-13 21:14:20','Inserted new Donor135'),('2024-11-13 21:14:20','Inserted new Donor136'),('2024-11-13 21:14:20','Inserted new Donor137'),('2024-11-13 21:14:20','Inserted new Donor138'),('2024-11-13 21:14:20','Inserted new Donor139'),('2024-11-13 21:14:20','Inserted new Donor140'),('2024-11-13 21:14:20','Inserted new Donor141'),('2024-11-13 21:14:20','Inserted new Donor142'),('2024-11-13 21:14:20','Inserted new Donor143'),('2024-11-13 21:14:20','Inserted new Donor144'),('2024-11-13 21:14:20','Inserted new Donor145'),('2024-11-13 21:14:20','Inserted new Donor146'),('2024-11-13 21:14:20','Inserted new Donor147'),('2024-11-13 21:14:20','Inserted new Donor148'),('2024-11-13 21:14:20','Inserted new Donor149'),('2024-11-13 21:14:20','Inserted new Donor150'),('2024-11-13 21:14:20','Inserted new Donor151'),('2024-11-13 21:14:20','Inserted new Donor152'),('2024-11-13 21:14:20','Inserted new Donor153'),('2024-11-13 21:14:20','Inserted new Donor154'),('2024-11-13 21:14:20','Inserted new Donor155'),('2024-11-13 21:14:20','Inserted new Donor156'),('2024-11-13 21:14:20','Inserted new Donor157'),('2024-11-13 21:14:20','Inserted new Donor158'),('2024-11-13 21:14:20','Inserted new Donor159'),('2024-11-13 21:14:20','Inserted new Donor160'),('2024-11-13 21:14:20','Inserted new Donor161'),('2024-11-13 21:14:20','Inserted new Donor162'),('2024-11-13 21:14:20','Inserted new Donor163'),('2024-11-13 21:14:20','Inserted new Donor164'),('2024-11-13 21:14:20','Inserted new Donor165'),('2024-11-13 21:14:20','Inserted new Donor166'),('2024-11-13 21:14:20','Inserted new Donor167'),('2024-11-13 21:14:20','Inserted new Donor168'),('2024-11-13 21:14:20','Inserted new Donor169'),('2024-11-13 21:14:20','Inserted new Donor170'),('2024-11-13 21:14:20','Inserted new Donor171'),('2024-11-13 21:14:20','Inserted new Donor172'),('2024-11-13 21:14:20','Inserted new Donor173'),('2024-11-13 21:14:20','Inserted new Donor174'),('2024-11-13 21:14:20','Inserted new Donor175'),('2024-11-13 21:14:20','Inserted new Donor176'),('2024-11-13 21:14:20','Inserted new Donor177'),('2024-11-13 21:14:20','Inserted new Donor178'),('2024-11-13 21:14:20','Inserted new Donor179'),('2024-11-13 21:14:20','Inserted new Donor180'),('2024-11-13 21:14:20','Inserted new Donor181'),('2024-11-13 21:14:20','Inserted new Donor182'),('2024-11-13 21:14:20','Inserted new Donor183'),('2024-11-13 21:14:20','Inserted new Donor184'),('2024-11-13 21:14:20','Inserted new Donor185'),('2024-11-13 21:14:20','Inserted new Donor186'),('2024-11-13 21:14:20','Inserted new Donor187'),('2024-11-13 21:14:20','Inserted new Donor188'),('2024-11-13 21:14:20','Inserted new Donor189'),('2024-11-13 21:14:20','Inserted new Donor190'),('2024-11-13 21:14:20','Inserted new Donor191'),('2024-11-13 21:14:20','Inserted new Donor192'),('2024-11-13 21:14:20','Inserted new Donor193'),('2024-11-13 21:14:20','Inserted new Donor194'),('2024-11-13 21:14:20','Inserted new Donor195'),('2024-11-13 21:14:20','Inserted new Donor196'),('2024-11-13 21:14:20','Inserted new Donor197'),('2024-11-13 21:14:20','Inserted new Donor198'),('2024-11-13 21:14:20','Inserted new Donor199'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 22; Donor ID : 7'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 97; Donor ID : 19'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 156; Donor ID : 154'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 113; Donor ID : 110'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 73; Donor ID : 36'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 108; Donor ID : 28'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 111; Donor ID : 164'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 86; Donor ID : 184'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 34; Donor ID : 106'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 51; Donor ID : 149'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 69; Donor ID : 97'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 174; Donor ID : 77'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 68; Donor ID : 17'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 32; Donor ID : 119'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 79; Donor ID : 76'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 183; Donor ID : 16'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 60; Donor ID : 186'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 142; Donor ID : 44'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 199; Donor ID : 10'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 109; Donor ID : 181'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 4; Donor ID : 155'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 78; Donor ID : 40'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 191; Donor ID : 120'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 120; Donor ID : 121'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 74; Donor ID : 64'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 7; Donor ID : 172'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 38; Donor ID : 102'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 75; Donor ID : 2'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 85; Donor ID : 9'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 63; Donor ID : 131'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 169; Donor ID : 165'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 10; Donor ID : 147'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 186; Donor ID : 83'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 147; Donor ID : 177'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 65; Donor ID : 94'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 30; Donor ID : 82'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 52; Donor ID : 101'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 197; Donor ID : 157'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 70; Donor ID : 60'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 104; Donor ID : 1'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 149; Donor ID : 30'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 163; Donor ID : 80'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 162; Donor ID : 52'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 124; Donor ID : 29'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 110; Donor ID : 53'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 112; Donor ID : 18'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 184; Donor ID : 57'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 82; Donor ID : 96'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 84; Donor ID : 193'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 76; Donor ID : 196'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 1; Donor ID : 93'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 43; Donor ID : 130'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 20; Donor ID : 129'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 33; Donor ID : 162'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 136; Donor ID : 198'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 182; Donor ID : 48'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 12; Donor ID : 145'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 145; Donor ID : 72'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 91; Donor ID : 126'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 167; Donor ID : 111'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 172; Donor ID : 21'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 153; Donor ID : 95'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 8; Donor ID : 71'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 90; Donor ID : 195'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 28; Donor ID : 143'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 58; Donor ID : 87'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 105; Donor ID : 109'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 125; Donor ID : 188'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 176; Donor ID : 107'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 19; Donor ID : 4'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 72; Donor ID : 191'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 6; Donor ID : 58'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 107; Donor ID : 173'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 119; Donor ID : 27'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 195; Donor ID : 67'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 55; Donor ID : 134'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 21; Donor ID : 144'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 196; Donor ID : 135'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 26; Donor ID : 23'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 185; Donor ID : 8'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 116; Donor ID : 168'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 36; Donor ID : 123'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 115; Donor ID : 166'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 31; Donor ID : 152'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 189; Donor ID : 15'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 39; Donor ID : 170'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 161; Donor ID : 78'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 143; Donor ID : 156'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 190; Donor ID : 22'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 83; Donor ID : 20'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 175; Donor ID : 50'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 103; Donor ID : 117'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 179; Donor ID : 138'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 188; Donor ID : 153'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 127; Donor ID : 32'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 37; Donor ID : 91'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 50; Donor ID : 66'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 77; Donor ID : 69'),('2024-11-13 21:14:39','Added Transaction :: Patient ID : 88; Donor ID : 160'),('2024-11-13 22:44:10','Inserted new Patient 181181'),('2024-11-13 23:37:37','Updated Donor Details4'),('2024-11-13 23:37:37','Updated Donor Details14'),('2024-11-13 23:37:37','Updated Donor Details15'),('2024-11-13 23:37:37','Updated Donor Details20'),('2024-11-13 23:37:37','Updated Donor Details26'),('2024-11-13 23:37:37','Updated Donor Details92'),('2024-11-13 23:37:37','Updated Donor Details95'),('2024-11-13 23:37:37','Updated Donor Details102'),('2024-11-13 23:37:37','Updated Donor Details109'),('2024-11-13 23:37:37','Updated Donor Details110'),('2024-11-13 23:37:37','Updated Donor Details116'),('2024-11-13 23:37:37','Updated Donor Details153'),('2024-11-13 23:37:37','Updated Donor Details164'),('2024-11-13 23:37:37','Updated Donor Details171'),('2024-11-13 23:37:37','Updated Donor Details176'),('2024-11-13 23:37:37','Updated Donor Details183'),('2024-11-13 23:37:37','Updated Donor Details189'),('2024-11-13 23:37:37','Updated Donor Details193'),('2024-11-13 23:38:07','Updated Donor Details3'),('2024-11-13 23:38:07','Updated Donor Details6'),('2024-11-13 23:38:07','Updated Donor Details7'),('2024-11-13 23:38:07','Updated Donor Details23'),('2024-11-13 23:38:07','Updated Donor Details32'),('2024-11-13 23:38:07','Updated Donor Details36'),('2024-11-13 23:38:07','Updated Donor Details40'),('2024-11-13 23:38:07','Updated Donor Details67'),('2024-11-13 23:38:07','Updated Donor Details82'),('2024-11-13 23:38:07','Updated Donor Details91'),('2024-11-13 23:38:07','Updated Donor Details99'),('2024-11-13 23:38:07','Updated Donor Details114'),('2024-11-13 23:38:07','Updated Donor Details125'),('2024-11-13 23:38:07','Updated Donor Details126'),('2024-11-13 23:38:07','Updated Donor Details139'),('2024-11-13 23:38:07','Updated Donor Details141'),('2024-11-13 23:38:07','Updated Donor Details142'),('2024-11-13 23:38:07','Updated Donor Details158'),('2024-11-13 23:38:07','Updated Donor Details178'),('2024-11-13 23:38:07','Updated Donor Details190'),('2024-11-13 23:38:07','Updated Donor Details196'),('2024-11-13 23:38:35','Updated Donor Details3'),('2024-11-13 23:38:35','Updated Donor Details6'),('2024-11-13 23:38:35','Updated Donor Details7'),('2024-11-13 23:38:35','Updated Donor Details23'),('2024-11-13 23:38:35','Updated Donor Details32'),('2024-11-13 23:38:35','Updated Donor Details36'),('2024-11-13 23:38:35','Updated Donor Details40'),('2024-11-13 23:38:35','Updated Donor Details67'),('2024-11-13 23:38:35','Updated Donor Details82'),('2024-11-13 23:38:35','Updated Donor Details91'),('2024-11-13 23:38:35','Updated Donor Details99'),('2024-11-13 23:38:35','Updated Donor Details114'),('2024-11-13 23:38:35','Updated Donor Details125'),('2024-11-13 23:38:35','Updated Donor Details126'),('2024-11-13 23:38:35','Updated Donor Details139'),('2024-11-13 23:38:35','Updated Donor Details141'),('2024-11-13 23:38:35','Updated Donor Details142'),('2024-11-13 23:38:35','Updated Donor Details158'),('2024-11-13 23:38:35','Updated Donor Details178'),('2024-11-13 23:38:35','Updated Donor Details190'),('2024-11-13 23:38:35','Updated Donor Details196'),('2024-11-13 23:38:42','Updated Donor Details17'),('2024-11-13 23:38:42','Updated Donor Details29'),('2024-11-13 23:38:42','Updated Donor Details34'),('2024-11-13 23:38:42','Updated Donor Details37'),('2024-11-13 23:38:42','Updated Donor Details38'),('2024-11-13 23:38:42','Updated Donor Details41'),('2024-11-13 23:38:42','Updated Donor Details88'),('2024-11-13 23:38:42','Updated Donor Details97'),('2024-11-13 23:38:42','Updated Donor Details100'),('2024-11-13 23:38:42','Updated Donor Details111'),('2024-11-13 23:38:42','Updated Donor Details124'),('2024-11-13 23:38:42','Updated Donor Details130'),('2024-11-13 23:38:42','Updated Donor Details135'),('2024-11-13 23:38:42','Updated Donor Details151'),('2024-11-13 23:38:42','Updated Donor Details152'),('2024-11-13 23:38:42','Updated Donor Details154'),('2024-11-13 23:38:42','Updated Donor Details166'),('2024-11-13 23:38:42','Updated Donor Details168'),('2024-11-13 23:39:01','Updated Donor Details8'),('2024-11-13 23:39:01','Updated Donor Details25'),('2024-11-13 23:39:01','Updated Donor Details27'),('2024-11-13 23:39:01','Updated Donor Details54'),('2024-11-13 23:39:01','Updated Donor Details57'),('2024-11-13 23:39:01','Updated Donor Details81'),('2024-11-13 23:39:01','Updated Donor Details86'),('2024-11-13 23:39:01','Updated Donor Details90'),('2024-11-13 23:39:01','Updated Donor Details106'),('2024-11-13 23:39:01','Updated Donor Details117'),('2024-11-13 23:39:01','Updated Donor Details127'),('2024-11-13 23:39:01','Updated Donor Details140'),('2024-11-13 23:39:01','Updated Donor Details143'),('2024-11-13 23:39:01','Updated Donor Details144'),('2024-11-13 23:39:01','Updated Donor Details162'),('2024-11-13 23:39:01','Updated Donor Details165'),('2024-11-13 23:39:01','Updated Donor Details191'),('2024-11-13 23:39:01','Updated Donor Details198'),('2024-11-13 23:39:01','Updated Donor Details199'),('2024-11-13 23:39:38','Updated Donor Details8'),('2024-11-13 23:39:38','Updated Donor Details25'),('2024-11-13 23:39:38','Updated Donor Details27'),('2024-11-13 23:39:38','Updated Donor Details54'),('2024-11-13 23:39:38','Updated Donor Details57'),('2024-11-13 23:39:38','Updated Donor Details81'),('2024-11-13 23:39:38','Updated Donor Details86'),('2024-11-13 23:39:38','Updated Donor Details90'),('2024-11-13 23:39:38','Updated Donor Details106'),('2024-11-13 23:39:38','Updated Donor Details117'),('2024-11-13 23:39:38','Updated Donor Details127'),('2024-11-13 23:39:38','Updated Donor Details140'),('2024-11-13 23:39:38','Updated Donor Details143'),('2024-11-13 23:39:38','Updated Donor Details144'),('2024-11-13 23:39:38','Updated Donor Details162'),('2024-11-13 23:39:38','Updated Donor Details165'),('2024-11-13 23:39:38','Updated Donor Details191'),('2024-11-13 23:39:38','Updated Donor Details198'),('2024-11-13 23:39:38','Updated Donor Details199'),('2024-11-13 23:39:45','Updated Donor Details10'),('2024-11-13 23:39:45','Updated Donor Details12'),('2024-11-13 23:39:45','Updated Donor Details31'),('2024-11-13 23:39:45','Updated Donor Details46'),('2024-11-13 23:39:45','Updated Donor Details48'),('2024-11-13 23:39:45','Updated Donor Details49'),('2024-11-13 23:39:45','Updated Donor Details52'),('2024-11-13 23:39:45','Updated Donor Details60'),('2024-11-13 23:39:45','Updated Donor Details61'),('2024-11-13 23:39:45','Updated Donor Details68'),('2024-11-13 23:39:45','Updated Donor Details69'),('2024-11-13 23:39:45','Updated Donor Details80'),('2024-11-13 23:39:45','Updated Donor Details84'),('2024-11-13 23:39:45','Updated Donor Details98'),('2024-11-13 23:39:45','Updated Donor Details118'),('2024-11-13 23:39:45','Updated Donor Details129'),('2024-11-13 23:39:45','Updated Donor Details145'),('2024-11-13 23:39:45','Updated Donor Details159'),('2024-11-13 23:39:45','Updated Donor Details160'),('2024-11-13 23:39:45','Updated Donor Details170'),('2024-11-13 23:39:45','Updated Donor Details182'),('2024-11-13 23:39:56','Updated Donor Details42'),('2024-11-13 23:39:56','Updated Donor Details43'),('2024-11-13 23:39:56','Updated Donor Details45'),('2024-11-13 23:39:56','Updated Donor Details51'),('2024-11-13 23:39:56','Updated Donor Details55'),('2024-11-13 23:39:56','Updated Donor Details56'),('2024-11-13 23:39:56','Updated Donor Details72'),('2024-11-13 23:39:56','Updated Donor Details73'),('2024-11-13 23:39:56','Updated Donor Details75'),('2024-11-13 23:39:56','Updated Donor Details79'),('2024-11-13 23:39:56','Updated Donor Details89'),('2024-11-13 23:39:56','Updated Donor Details94'),('2024-11-13 23:39:56','Updated Donor Details104'),('2024-11-13 23:39:56','Updated Donor Details120'),('2024-11-13 23:39:56','Updated Donor Details137'),('2024-11-13 23:39:56','Updated Donor Details149'),('2024-11-13 23:39:56','Updated Donor Details161'),('2024-11-13 23:39:56','Updated Donor Details174'),('2024-11-13 23:40:16','Updated Donor Details22'),('2024-11-13 23:40:16','Updated Donor Details35'),('2024-11-13 23:40:16','Updated Donor Details58'),('2024-11-13 23:40:16','Updated Donor Details59'),('2024-11-13 23:40:16','Updated Donor Details71'),('2024-11-13 23:40:16','Updated Donor Details76'),('2024-11-13 23:40:16','Updated Donor Details77'),('2024-11-13 23:40:16','Updated Donor Details108'),('2024-11-13 23:40:16','Updated Donor Details132'),('2024-11-13 23:40:16','Updated Donor Details134'),('2024-11-13 23:40:16','Updated Donor Details147'),('2024-11-13 23:40:16','Updated Donor Details150'),('2024-11-13 23:40:16','Updated Donor Details157'),('2024-11-13 23:40:16','Updated Donor Details186'),('2024-11-13 23:40:16','Updated Donor Details187'),('2024-11-13 23:40:16','Updated Donor Details192'),('2024-11-13 23:40:45','Updated Donor Details1'),('2024-11-13 23:40:45','Updated Donor Details9'),('2024-11-13 23:40:45','Updated Donor Details16'),('2024-11-13 23:40:45','Updated Donor Details18'),('2024-11-13 23:40:45','Updated Donor Details21'),('2024-11-13 23:40:45','Updated Donor Details28'),('2024-11-13 23:40:45','Updated Donor Details30'),('2024-11-13 23:40:45','Updated Donor Details33'),('2024-11-13 23:40:45','Updated Donor Details39'),('2024-11-13 23:40:45','Updated Donor Details63'),('2024-11-13 23:40:45','Updated Donor Details83'),('2024-11-13 23:40:45','Updated Donor Details85'),('2024-11-13 23:40:45','Updated Donor Details93'),('2024-11-13 23:40:45','Updated Donor Details96'),('2024-11-13 23:40:45','Updated Donor Details105'),('2024-11-13 23:40:45','Updated Donor Details119'),('2024-11-13 23:40:45','Updated Donor Details146'),('2024-11-13 23:40:45','Updated Donor Details156'),('2024-11-13 23:40:45','Updated Donor Details177'),('2024-11-13 23:40:45','Updated Donor Details181'),('2024-11-13 23:40:45','Updated Donor Details188'),('2024-11-13 23:40:45','Updated Donor Details197'),('2024-11-13 23:41:05','Updated Donor Details1'),('2024-11-13 23:41:05','Updated Donor Details9'),('2024-11-13 23:41:05','Updated Donor Details16'),('2024-11-13 23:41:05','Updated Donor Details18'),('2024-11-13 23:41:05','Updated Donor Details21'),('2024-11-13 23:41:05','Updated Donor Details28'),('2024-11-13 23:41:05','Updated Donor Details30'),('2024-11-13 23:41:05','Updated Donor Details33'),('2024-11-13 23:41:05','Updated Donor Details39'),('2024-11-13 23:41:05','Updated Donor Details63'),('2024-11-13 23:41:05','Updated Donor Details83'),('2024-11-13 23:41:05','Updated Donor Details85'),('2024-11-13 23:41:05','Updated Donor Details93'),('2024-11-13 23:41:05','Updated Donor Details96'),('2024-11-13 23:41:05','Updated Donor Details105'),('2024-11-13 23:41:05','Updated Donor Details119'),('2024-11-13 23:41:05','Updated Donor Details146'),('2024-11-13 23:41:05','Updated Donor Details156'),('2024-11-13 23:41:05','Updated Donor Details177'),('2024-11-13 23:41:05','Updated Donor Details181'),('2024-11-13 23:41:05','Updated Donor Details188'),('2024-11-13 23:41:05','Updated Donor Details197'),('2024-11-13 23:41:13','Updated Donor Details11'),('2024-11-13 23:41:13','Updated Donor Details13'),('2024-11-13 23:41:13','Updated Donor Details44'),('2024-11-13 23:41:13','Updated Donor Details66'),('2024-11-13 23:41:13','Updated Donor Details70'),('2024-11-13 23:41:13','Updated Donor Details74'),('2024-11-13 23:41:13','Updated Donor Details78'),('2024-11-13 23:41:13','Updated Donor Details87'),('2024-11-13 23:41:13','Updated Donor Details101'),('2024-11-13 23:41:13','Updated Donor Details103'),('2024-11-13 23:41:13','Updated Donor Details107'),('2024-11-13 23:41:13','Updated Donor Details112'),('2024-11-13 23:41:13','Updated Donor Details113'),('2024-11-13 23:41:13','Updated Donor Details123'),('2024-11-13 23:41:13','Updated Donor Details128'),('2024-11-13 23:41:13','Updated Donor Details131'),('2024-11-13 23:41:13','Updated Donor Details133'),('2024-11-13 23:41:13','Updated Donor Details136'),('2024-11-13 23:41:13','Updated Donor Details138'),('2024-11-13 23:41:13','Updated Donor Details148'),('2024-11-13 23:41:13','Updated Donor Details163'),('2024-11-13 23:41:13','Updated Donor Details167'),('2024-11-13 23:41:13','Updated Donor Details173'),('2024-11-13 23:41:13','Updated Donor Details179'),('2024-11-13 23:41:13','Updated Donor Details180'),('2024-11-13 23:41:13','Updated Donor Details184'),('2024-11-13 23:41:13','Updated Donor Details195'),('2024-11-13 23:41:25','Updated Donor Details2'),('2024-11-13 23:41:25','Updated Donor Details5'),('2024-11-13 23:41:25','Updated Donor Details19'),('2024-11-13 23:41:25','Updated Donor Details24'),('2024-11-13 23:41:25','Updated Donor Details47'),('2024-11-13 23:41:25','Updated Donor Details50'),('2024-11-13 23:41:25','Updated Donor Details53'),('2024-11-13 23:41:25','Updated Donor Details62'),('2024-11-13 23:41:25','Updated Donor Details64'),('2024-11-13 23:41:25','Updated Donor Details65'),('2024-11-13 23:41:25','Updated Donor Details115'),('2024-11-13 23:41:25','Updated Donor Details121'),('2024-11-13 23:41:25','Updated Donor Details122'),('2024-11-13 23:41:25','Updated Donor Details155'),('2024-11-13 23:41:25','Updated Donor Details169'),('2024-11-13 23:41:25','Updated Donor Details172'),('2024-11-13 23:41:25','Updated Donor Details175'),('2024-11-13 23:41:25','Updated Donor Details185'),('2024-11-13 23:41:25','Updated Donor Details194'),('2024-11-14 00:02:41','Updated Patient Details 10'),('2024-11-14 00:02:41','Updated Patient Details 20'),('2024-11-14 00:02:41','Updated Patient Details 30'),('2024-11-14 00:02:41','Updated Patient Details 40'),('2024-11-14 00:02:41','Updated Patient Details 50'),('2024-11-14 00:02:41','Updated Patient Details 60'),('2024-11-14 00:02:41','Updated Patient Details 70'),('2024-11-14 00:02:41','Updated Patient Details 80'),('2024-11-14 00:02:41','Updated Patient Details 90'),('2024-11-14 00:02:41','Updated Patient Details 100'),('2024-11-14 00:02:41','Updated Patient Details 110'),('2024-11-14 00:02:41','Updated Patient Details 120'),('2024-11-14 00:02:41','Updated Patient Details 130'),('2024-11-14 00:02:41','Updated Patient Details 140'),('2024-11-14 00:02:41','Updated Patient Details 150'),('2024-11-14 00:02:41','Updated Patient Details 160'),('2024-11-14 00:02:41','Updated Patient Details 170'),('2024-11-14 00:02:41','Updated Patient Details 180'),('2024-11-14 00:02:41','Updated Patient Details 190'),('2024-11-14 00:03:01','Updated Patient Details 1'),('2024-11-14 00:03:01','Updated Patient Details 11'),('2024-11-14 00:03:01','Updated Patient Details 21'),('2024-11-14 00:03:01','Updated Patient Details 31'),('2024-11-14 00:03:01','Updated Patient Details 41'),('2024-11-14 00:03:01','Updated Patient Details 51'),('2024-11-14 00:03:01','Updated Patient Details 61'),('2024-11-14 00:03:01','Updated Patient Details 71'),('2024-11-14 00:03:01','Updated Patient Details 81'),('2024-11-14 00:03:01','Updated Patient Details 91'),('2024-11-14 00:03:01','Updated Patient Details 101'),('2024-11-14 00:03:01','Updated Patient Details 111'),('2024-11-14 00:03:01','Updated Patient Details 121'),('2024-11-14 00:03:01','Updated Patient Details 131'),('2024-11-14 00:03:01','Updated Patient Details 141'),('2024-11-14 00:03:01','Updated Patient Details 151'),('2024-11-14 00:03:01','Updated Patient Details 161'),('2024-11-14 00:03:01','Updated Patient Details 171'),('2024-11-14 00:03:01','Updated Patient Details 181'),('2024-11-14 00:03:01','Updated Patient Details 191'),('2024-11-14 00:03:01','Updated Patient Details 181181'),('2024-11-14 00:03:15','Updated Patient Details 1'),('2024-11-14 00:03:15','Updated Patient Details 11'),('2024-11-14 00:03:15','Updated Patient Details 21'),('2024-11-14 00:03:15','Updated Patient Details 31'),('2024-11-14 00:03:15','Updated Patient Details 41'),('2024-11-14 00:03:15','Updated Patient Details 51'),('2024-11-14 00:03:15','Updated Patient Details 61'),('2024-11-14 00:03:15','Updated Patient Details 71'),('2024-11-14 00:03:15','Updated Patient Details 81'),('2024-11-14 00:03:15','Updated Patient Details 91'),('2024-11-14 00:03:15','Updated Patient Details 101'),('2024-11-14 00:03:15','Updated Patient Details 111'),('2024-11-14 00:03:15','Updated Patient Details 121'),('2024-11-14 00:03:15','Updated Patient Details 131'),('2024-11-14 00:03:15','Updated Patient Details 141'),('2024-11-14 00:03:15','Updated Patient Details 151'),('2024-11-14 00:03:15','Updated Patient Details 161'),('2024-11-14 00:03:15','Updated Patient Details 171'),('2024-11-14 00:03:15','Updated Patient Details 181'),('2024-11-14 00:03:15','Updated Patient Details 191'),('2024-11-14 00:03:15','Updated Patient Details 181181'),('2024-11-14 00:03:21','Updated Patient Details 2'),('2024-11-14 00:03:21','Updated Patient Details 12'),('2024-11-14 00:03:21','Updated Patient Details 22'),('2024-11-14 00:03:21','Updated Patient Details 32'),('2024-11-14 00:03:21','Updated Patient Details 42'),('2024-11-14 00:03:21','Updated Patient Details 52'),('2024-11-14 00:03:21','Updated Patient Details 62'),('2024-11-14 00:03:21','Updated Patient Details 72'),('2024-11-14 00:03:21','Updated Patient Details 82'),('2024-11-14 00:03:21','Updated Patient Details 92'),('2024-11-14 00:03:21','Updated Patient Details 102'),('2024-11-14 00:03:21','Updated Patient Details 112'),('2024-11-14 00:03:21','Updated Patient Details 122'),('2024-11-14 00:03:21','Updated Patient Details 132'),('2024-11-14 00:03:21','Updated Patient Details 142'),('2024-11-14 00:03:21','Updated Patient Details 152'),('2024-11-14 00:03:21','Updated Patient Details 162'),('2024-11-14 00:03:21','Updated Patient Details 172'),('2024-11-14 00:03:21','Updated Patient Details 182'),('2024-11-14 00:03:21','Updated Patient Details 192'),('2024-11-14 00:03:47','Updated Patient Details 3'),('2024-11-14 00:03:47','Updated Patient Details 13'),('2024-11-14 00:03:47','Updated Patient Details 23'),('2024-11-14 00:03:47','Updated Patient Details 33'),('2024-11-14 00:03:47','Updated Patient Details 43'),('2024-11-14 00:03:47','Updated Patient Details 53'),('2024-11-14 00:03:47','Updated Patient Details 63'),('2024-11-14 00:03:47','Updated Patient Details 73'),('2024-11-14 00:03:47','Updated Patient Details 83'),('2024-11-14 00:03:47','Updated Patient Details 93'),('2024-11-14 00:03:47','Updated Patient Details 103'),('2024-11-14 00:03:47','Updated Patient Details 113'),('2024-11-14 00:03:47','Updated Patient Details 123'),('2024-11-14 00:03:47','Updated Patient Details 133'),('2024-11-14 00:03:47','Updated Patient Details 143'),('2024-11-14 00:03:47','Updated Patient Details 153'),('2024-11-14 00:03:47','Updated Patient Details 163'),('2024-11-14 00:03:47','Updated Patient Details 173'),('2024-11-14 00:03:47','Updated Patient Details 183'),('2024-11-14 00:03:47','Updated Patient Details 193'),('2024-11-14 00:04:52','Updated Patient Details 4'),('2024-11-14 00:04:52','Updated Patient Details 14'),('2024-11-14 00:04:52','Updated Patient Details 24'),('2024-11-14 00:04:52','Updated Patient Details 34'),('2024-11-14 00:04:52','Updated Patient Details 44'),('2024-11-14 00:04:52','Updated Patient Details 54'),('2024-11-14 00:04:52','Updated Patient Details 64'),('2024-11-14 00:04:52','Updated Patient Details 74'),('2024-11-14 00:04:52','Updated Patient Details 84'),('2024-11-14 00:04:52','Updated Patient Details 94'),('2024-11-14 00:04:52','Updated Patient Details 104'),('2024-11-14 00:04:52','Updated Patient Details 114'),('2024-11-14 00:04:52','Updated Patient Details 124'),('2024-11-14 00:04:52','Updated Patient Details 134'),('2024-11-14 00:04:52','Updated Patient Details 144'),('2024-11-14 00:04:52','Updated Patient Details 154'),('2024-11-14 00:04:52','Updated Patient Details 164'),('2024-11-14 00:04:52','Updated Patient Details 174'),('2024-11-14 00:04:52','Updated Patient Details 184'),('2024-11-14 00:04:52','Updated Patient Details 194'),('2024-11-14 00:05:12','Updated Patient Details 5'),('2024-11-14 00:05:12','Updated Patient Details 15'),('2024-11-14 00:05:12','Updated Patient Details 25'),('2024-11-14 00:05:12','Updated Patient Details 35'),('2024-11-14 00:05:12','Updated Patient Details 45'),('2024-11-14 00:05:12','Updated Patient Details 55'),('2024-11-14 00:05:12','Updated Patient Details 65'),('2024-11-14 00:05:12','Updated Patient Details 75'),('2024-11-14 00:05:12','Updated Patient Details 85'),('2024-11-14 00:05:12','Updated Patient Details 95'),('2024-11-14 00:05:12','Updated Patient Details 105'),('2024-11-14 00:05:12','Updated Patient Details 115'),('2024-11-14 00:05:12','Updated Patient Details 125'),('2024-11-14 00:05:12','Updated Patient Details 135'),('2024-11-14 00:05:12','Updated Patient Details 145'),('2024-11-14 00:05:12','Updated Patient Details 155'),('2024-11-14 00:05:12','Updated Patient Details 165'),('2024-11-14 00:05:12','Updated Patient Details 175'),('2024-11-14 00:05:12','Updated Patient Details 185'),('2024-11-14 00:05:12','Updated Patient Details 195'),('2024-11-14 00:05:53','Updated Patient Details 6'),('2024-11-14 00:05:53','Updated Patient Details 16'),('2024-11-14 00:05:53','Updated Patient Details 26'),('2024-11-14 00:05:53','Updated Patient Details 36'),('2024-11-14 00:05:53','Updated Patient Details 46'),('2024-11-14 00:05:53','Updated Patient Details 56'),('2024-11-14 00:05:53','Updated Patient Details 66'),('2024-11-14 00:05:53','Updated Patient Details 76'),('2024-11-14 00:05:53','Updated Patient Details 86'),('2024-11-14 00:05:53','Updated Patient Details 96'),('2024-11-14 00:05:53','Updated Patient Details 106'),('2024-11-14 00:05:53','Updated Patient Details 116'),('2024-11-14 00:05:53','Updated Patient Details 126'),('2024-11-14 00:05:53','Updated Patient Details 136'),('2024-11-14 00:05:53','Updated Patient Details 146'),('2024-11-14 00:05:53','Updated Patient Details 156'),('2024-11-14 00:05:53','Updated Patient Details 166'),('2024-11-14 00:05:53','Updated Patient Details 176'),('2024-11-14 00:05:53','Updated Patient Details 186'),('2024-11-14 00:05:53','Updated Patient Details 196'),('2024-11-14 00:06:28','Updated Patient Details 7'),('2024-11-14 00:06:28','Updated Patient Details 17'),('2024-11-14 00:06:28','Updated Patient Details 27'),('2024-11-14 00:06:28','Updated Patient Details 37'),('2024-11-14 00:06:28','Updated Patient Details 47'),('2024-11-14 00:06:28','Updated Patient Details 57'),('2024-11-14 00:06:28','Updated Patient Details 67'),('2024-11-14 00:06:28','Updated Patient Details 77'),('2024-11-14 00:06:28','Updated Patient Details 87'),('2024-11-14 00:06:28','Updated Patient Details 97'),('2024-11-14 00:06:28','Updated Patient Details 107'),('2024-11-14 00:06:28','Updated Patient Details 117'),('2024-11-14 00:06:28','Updated Patient Details 127'),('2024-11-14 00:06:28','Updated Patient Details 137'),('2024-11-14 00:06:28','Updated Patient Details 147'),('2024-11-14 00:06:28','Updated Patient Details 157'),('2024-11-14 00:06:28','Updated Patient Details 167'),('2024-11-14 00:06:28','Updated Patient Details 177'),('2024-11-14 00:06:28','Updated Patient Details 187'),('2024-11-14 00:06:28','Updated Patient Details 197'),('2024-11-14 00:07:12','Updated Patient Details 8'),('2024-11-14 00:07:12','Updated Patient Details 18'),('2024-11-14 00:07:12','Updated Patient Details 28'),('2024-11-14 00:07:12','Updated Patient Details 38'),('2024-11-14 00:07:12','Updated Patient Details 48'),('2024-11-14 00:07:12','Updated Patient Details 58'),('2024-11-14 00:07:12','Updated Patient Details 68'),('2024-11-14 00:07:12','Updated Patient Details 78'),('2024-11-14 00:07:12','Updated Patient Details 88'),('2024-11-14 00:07:12','Updated Patient Details 98'),('2024-11-14 00:07:12','Updated Patient Details 108'),('2024-11-14 00:07:12','Updated Patient Details 118'),('2024-11-14 00:07:12','Updated Patient Details 128'),('2024-11-14 00:07:12','Updated Patient Details 138'),('2024-11-14 00:07:12','Updated Patient Details 148'),('2024-11-14 00:07:12','Updated Patient Details 158'),('2024-11-14 00:07:12','Updated Patient Details 168'),('2024-11-14 00:07:12','Updated Patient Details 178'),('2024-11-14 00:07:12','Updated Patient Details 188'),('2024-11-14 00:07:12','Updated Patient Details 198'),('2024-11-14 00:07:51','Updated Patient Details 9'),('2024-11-14 00:07:51','Updated Patient Details 19'),('2024-11-14 00:07:51','Updated Patient Details 29'),('2024-11-14 00:07:51','Updated Patient Details 39'),('2024-11-14 00:07:51','Updated Patient Details 49'),('2024-11-14 00:07:51','Updated Patient Details 59'),('2024-11-14 00:07:51','Updated Patient Details 69'),('2024-11-14 00:07:51','Updated Patient Details 79'),('2024-11-14 00:07:51','Updated Patient Details 89'),('2024-11-14 00:07:51','Updated Patient Details 99'),('2024-11-14 00:07:51','Updated Patient Details 109'),('2024-11-14 00:07:51','Updated Patient Details 119'),('2024-11-14 00:07:51','Updated Patient Details 129'),('2024-11-14 00:07:51','Updated Patient Details 139'),('2024-11-14 00:07:51','Updated Patient Details 149'),('2024-11-14 00:07:51','Updated Patient Details 159'),('2024-11-14 00:07:51','Updated Patient Details 169'),('2024-11-14 00:07:51','Updated Patient Details 179'),('2024-11-14 00:07:51','Updated Patient Details 189'),('2024-11-14 00:07:51','Updated Patient Details 199');
/*!40000 ALTER TABLE `log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `login`
--

DROP TABLE IF EXISTS `login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `login` (
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `login`
--

LOCK TABLES `login` WRITE;
/*!40000 ALTER TABLE `login` DISABLE KEYS */;
INSERT INTO `login` VALUES ('admin','admin'),('admin','admin'),('vineet','vineet'),('pes','pes'),('dhruthan','dhruthan'),('user1','user1');
/*!40000 ALTER TABLE `login` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-11-27  5:42:59