-
Notifications
You must be signed in to change notification settings - Fork 0
/
april_25_backup.sql
416 lines (361 loc) · 71.1 KB
/
april_25_backup.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
CREATE DATABASE IF NOT EXISTS `vaccination_table` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `vaccination_table`;
-- MySQL dump 10.13 Distrib 5.7.29, for Linux (x86_64)
--
-- Host: 127.0.0.1 Database: vaccination_table
-- ------------------------------------------------------
-- Server version 5.7.29-0ubuntu0.18.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 */;
/*!40101 SET NAMES utf8 */;
/*!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 `AuthUsers`
--
DROP TABLE IF EXISTS `AuthUsers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AuthUsers` (
`userID` int(11) NOT NULL AUTO_INCREMENT,
`password` varchar(255) NOT NULL,
`emailID` varchar(255) NOT NULL,
`contact` varchar(255) DEFAULT NULL,
`roleID` int(11) NOT NULL,
`name` varchar(45) DEFAULT NULL,
PRIMARY KEY (`userID`),
UNIQUE KEY `emailID_UNIQUE` (`emailID`),
KEY `roleID` (`roleID`),
CONSTRAINT `AuthUsers_ibfk_1` FOREIGN KEY (`roleID`) REFERENCES `RoleRef` (`roleId`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `AuthUsers`
--
LOCK TABLES `AuthUsers` WRITE;
/*!40000 ALTER TABLE `AuthUsers` DISABLE KEYS */;
INSERT INTO `AuthUsers` VALUES (1,'ppa32Z4UHh','[email protected]','115-204-8539',1,NULL),(2,'fFF7GOwl','[email protected]','270-443-0846',4,NULL),(3,'G1u9Ofk0s','[email protected]','492-971-9343',2,NULL),(4,'9IkIr98MUG2','[email protected]','311-735-1504',3,NULL),(5,'Gy06uF2i','[email protected]','769-352-0451',1,NULL),(6,'eHMvoE','[email protected]','109-384-1756',2,NULL),(7,'LDSRdW9','[email protected]','302-855-1747',1,NULL),(8,'FPlyiMybhWH','[email protected]','405-517-1924',1,NULL),(9,'GhpSm3GCP7','[email protected]','519-571-7064',1,NULL),(10,'H5qe9nvRqk0J','[email protected]','969-393-6076',3,NULL),(11,'OrUY28t','[email protected]','638-690-0033',1,NULL),(12,'dJzbQRd','[email protected]','786-832-0706',1,NULL),(13,'86wDMlu','[email protected]','744-641-9251',1,NULL),(14,'6HnzXiHTqNq6','[email protected]','893-165-7986',3,NULL),(15,'FvwZgmA0','[email protected]','369-677-0120',2,NULL),(16,'oeEVZcPZ2VGl','[email protected]','107-490-1084',2,NULL),(17,'xapkzyfR','[email protected]','782-414-5828',2,NULL),(18,'duDSOEHeFXh','[email protected]','240-589-0642',2,NULL),(19,'lKHPiP0K','[email protected]','145-591-5416',2,NULL),(20,'574Wb1y','[email protected]','281-163-2295',2,NULL),(21,'MtkcSi7jz6','[email protected]','418-759-6775',2,NULL),(22,'Na1zsNQ','[email protected]','962-809-7994',2,NULL),(23,'8UlnnS6PTIDu','[email protected]','968-952-8588',2,NULL),(24,'QdqeXRc1C','[email protected]','638-594-4329',2,NULL),(25,'3qYCabk8Br','[email protected]','976-808-5215',2,NULL),(26,'lV183I1FjBN','[email protected]','232-909-3101',2,NULL),(27,'ydO0XU','[email protected]','204-766-1794',2,NULL),(28,'h41M6fyj','[email protected]','718-779-9705',2,NULL),(29,'jRNTIMlSlFr','[email protected]','691-987-1479',2,NULL),(30,'DKTvi6BU','[email protected]','688-949-7337',2,NULL),(31,'KPiERPhK','[email protected]','638-763-0687',2,NULL),(32,'BntZC6dyEq','[email protected]','174-977-0622',4,NULL),(33,'ArvHTxbTB','[email protected]','897-267-9610',2,NULL),(34,'qCdxPx','[email protected]','593-996-4651',3,NULL),(35,'Uiofisd','[email protected]','319-515-0333',1,NULL),(36,'aGUwU4FFryi','[email protected]','317-624-1600',1,NULL),(37,'14AbyER','[email protected]','413-878-9332',2,NULL),(38,'OcX0ve','[email protected]','314-830-7644',2,NULL),(39,'WMp0eFA06M','[email protected]','205-490-0713',2,NULL),(40,'EUBH9CsTh','[email protected]','139-782-4497',2,NULL),(41,'miJNqc8Tai','[email protected]','555-360-9161',2,NULL),(42,'vCDNxEm','[email protected]','564-585-3063',2,NULL),(43,'OYMc9C33R7','[email protected]','681-594-5600',2,NULL),(44,'R9EHvKUfqpQ','[email protected]','904-553-9485',4,NULL),(45,'zaD1nInuji','[email protected]','564-135-5808',1,NULL),(46,'Muu0o3n','[email protected]','769-189-3396',3,NULL),(47,'f8F4ZhL5R1L','[email protected]','914-911-5593',3,NULL),(48,'H5OaYWUrODY','[email protected]','638-106-2819',3,NULL),(49,'AdQuXZ7','[email protected]','568-495-6476',2,NULL),(50,'4hiFcT','[email protected]','628-215-8777',3,NULL),(51,'OSkgDpyOgp7i','[email protected]','684-125-1409',2,NULL),(52,'t1MJhAr3KbxD','[email protected]','920-186-2786',2,NULL),(53,'XUoo9uklWLt','[email protected]','941-993-3793',2,NULL),(54,'thQ3Th','[email protected]','520-752-5632',2,NULL),(55,'fk4kgZAiCkj','[email protected]','963-435-0689',3,NULL),(56,'2TtiZ7zxDJ7','[email protected]','504-844-2399',2,NULL),(57,'Av43ELyPbo','[email protected]','937-478-5149',5,NULL),(58,'vxqnfd','[email protected]','580-403-0077',5,NULL),(59,'7YLp0jwH','[email protected]','312-846-0663',2,NULL),(60,'ZdIZUu','[email protected]','571-685-5321',1,NULL),(61,'JlCZmCCz','[email protected]','593-612-7031',1,NULL),(62,'VcKaKqhIDoGE','[email protected]','386-967-9038',1,NULL),(63,'N24WQtWb63','[email protected]','961-450-4385',4,NULL),(64,'5ud021bP2dHu','[email protected]','442-724-3154',3,NULL),(65,'LzRaWr','[email protected]','367-295-9428',2,NULL),(66,'DCkGbijSNE','[email protected]','279-422-7845',2,NULL),(67,'wMCvlgFDeUeL','[email protected]','857-818-1119',2,NULL),(68,'olrCPO','[email protected]','590-622-2314',1,NULL),(69,'kZUcqKzGWR8f','[email protected]','734-191-4173',2,NULL),(70,'R0hL4JkDDR','[email protected]','216-585-3927',3,NULL),(71,'TrVvaq0zf6','[email protected]','108-565-1067',2,NULL),(72,'1hIltGjQEl','[email protected]','573-633-7315',2,NULL),(73,'gfADL2','[email protected]','684-777-5537',2,NULL),(74,'CqRkxZEW','[email protected]','583-798-1572',2,NULL),(75,'UiwYb6t6','[email protected]','273-193-1526',3,NULL),(76,'RAARV9AAoI','[email protected]','186-585-3814',2,NULL),(77,'pNB8qt4Z','[email protected]','666-485-5025',5,NULL),(78,'NpyfcRc','[email protected]','332-715-1197',5,NULL),(79,'K8PlP0MhN','[email protected]','677-148-0095',2,NULL),(80,'HgRQc00T1','[email protected]','403-523-5134',1,NULL),(81,'HJMNrUre6E','[email protected]','754-498-4526',1,NULL),(82,'r71LSx0','[email protected]','812-457-8244',1,NULL),(83,'YlL8pTlxGXRH','[email protected]','812-930-1257',4,NULL),(84,'2gsJM4','[email protected]','930-388-1804',3,NULL),(85,'x6L4czx','[email protected]','463-246-8882',2,NULL),(86,'73xWI6','[email protected]','936-155-5175',2,NULL),(87,'vteYKEtP9HBt','[email protected]','961-962-9276',2,NULL),(88,'yrqmCsz0','[email protected]','464-910-0638',1,NULL),(89,'E2Xd5fbs','[email protected]','505-165-1095',3,NULL),(90,'gmUobYWN','[email protected]','853-175-9734',2,NULL),(91,'EHiQSyW','[email protected]','690-705-1553',2,NULL),(92,'B2zHuVcQI7oe','[email protected]','762-689-2803',2,NULL),(93,'kyBPuiP00f1z','[email protected]','541-123-3661',2,NULL),(94,'ybMnzrPrB1H','[email protected]','297-433-9698',3,NULL),(95,'OSMv7ADI1','[email protected]','920-279-1717',2,NULL),(96,'SBg7wlEZXO','[email protected]','955-266-2818',5,NULL),(97,'Vy1KAsi','[email protected]','435-734-5852',5,NULL),(98,'ivRF9YhpbTSu','[email protected]','838-414-9435',2,NULL),(99,'y2Z10aH4iz','[email protected]','456-629-0555',1,NULL),(100,'zGLP21aXWJJ','[email protected]','843-991-0548',1,NULL),(101,'ssssssss','[email protected]',NULL,1,'Vasu Goel'),(102,'password','[email protected]',NULL,1,'Sargam');
/*!40000 ALTER TABLE `AuthUsers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Availability`
--
DROP TABLE IF EXISTS `Availability`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Availability` (
`healthCentreID` int(11) NOT NULL,
`VaccineID` int(11) DEFAULT NULL,
`Count` varchar(45) DEFAULT NULL,
PRIMARY KEY (`healthCentreID`),
KEY `fk_vaccine_idx` (`VaccineID`),
CONSTRAINT `fk_healthCentre` FOREIGN KEY (`healthCentreID`) REFERENCES `PublicHealthCentre` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_vaccine` FOREIGN KEY (`VaccineID`) REFERENCES `Vaccinations` (`VaccineID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Availability`
--
LOCK TABLES `Availability` WRITE;
/*!40000 ALTER TABLE `Availability` DISABLE KEYS */;
INSERT INTO `Availability` VALUES (1,90396,'2'),(2,90287,'32'),(3,90283,'2'),(4,90470,'22'),(7,90620,'15'),(10,90654,'12'),(11,90393,'12'),(12,90378,'6'),(13,90646,'12'),(14,90291,'4'),(15,90651,'12'),(16,90645,'28'),(17,90621,'16'),(18,90647,'33'),(20,90653,'43'),(21,90476,'3'),(22,90296,'12'),(23,90581,'4'),(26,90644,'1'),(33,90375,'3'),(41,90371,'46');
/*!40000 ALTER TABLE `Availability` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `CountryImmunizationRecords`
--
DROP TABLE IF EXISTS `CountryImmunizationRecords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CountryImmunizationRecords` (
`CountryCode` varchar(4) NOT NULL,
`Country Name` varchar(45) NOT NULL,
`VaccinationID` int(11) NOT NULL,
PRIMARY KEY (`CountryCode`),
KEY `CountryImmunizationRecords_ibfk_1` (`VaccinationID`),
CONSTRAINT `CountryImmunizationRecords_ibfk_1` FOREIGN KEY (`VaccinationID`) REFERENCES `Vaccinations` (`VaccineID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `CountryImmunizationRecords`
--
LOCK TABLES `CountryImmunizationRecords` WRITE;
/*!40000 ALTER TABLE `CountryImmunizationRecords` DISABLE KEYS */;
INSERT INTO `CountryImmunizationRecords` VALUES ('AD','Andorra',90296),('AF','Afghanistan',90281),('AG','Antigua and Barbuda',90378),('AI','Anguilla',90375),('AL','Albania',90283),('AM','Armenia',90389),('AO','Angola',90371),('AQ','Antarctica',90376),('AR','Argentina',90379),('AS','American Samoa',90291),('AT','Austria',90470),('AU','Australia',90396),('AW','Aruba',90393),('AZ','Azerbaijan',90476),('BA','Bosnia and Herzegovina',90645),('BB','Barbados',90620),('BD','Bangladesh',90585),('BE','Belgium',90625),('BF','Burkina Faso',90653),('BG','Bulgaria',90651),('BH','Bahrain',90581),('BI','Burundi',90654),('BJ','Benin',90632),('BM','Bermuda',90633),('BN','Brunei Darussalam',90650),('BO','Bolivia (Plurinational State of)',90636),('BQ','Bonaire, Sint Eustatius and Saba',90644),('BR','Brazil',90648),('BS','Bahamas (the)',90477),('BT','Bhutan',90634),('BV','Bouvet Island',90647),('BW','Botswana',90646),('BY','Belarus',90621),('BZ','Belize',90630),('CA','Canada',90658),('CC','Cocos (Keeling) Islands (the)',90665),('CD','Congo (the Democratic Republic of the)',90669),('CG','Congo (the)',90670),('CI','Côte d\'Ivoire',90682),('CK','Cook Islands (the)',90672),('CL','Chile',90662),('CM','Cameroon',90657),('CN','China',90663),('CO','Colombia',90666),('CR','Costa Rica',90673),('CU','Cuba',90675),('CV','Cabo Verde',90655),('CW','Curaçao',90676),('CX','Christmas Island',90664),('CY','Cyprus',90680),('CZ','Czechia',90681),('DE','Germany',90712),('DJ','Djibouti',90686),('DM','Dominica',90687),('DO','Dominican Republic (the)',90688),('DZ','Algeria',90287),('EC','Ecuador',90690),('EE','Estonia',90694),('EG','Egypt',90690),('ER','Eritrea',90693),('ET','Ethiopia',90697),('FI','Finland',90702),('FJ','Fiji',90701),('FK','Falkland Islands (the) [Malvinas]',90698),('FO','Faroe Islands (the)',90700),('FR','France',90703),('GA','Gabon',90707),('GD','Grenada',90717),('GE','Georgia',90710),('GF','French Guiana',90704),('GG','Guernsey',90723),('GH','Ghana',90713),('GI','Gibraltar',90714),('GL','Greenland',90716),('GM','Gambia (the)',90708),('GN','Guinea',90724),('GP','Guadeloupe',90718),('GQ','Equatorial Guinea',90692),('GR','Greece',90715),('GT','Guatemala',90721),('GU','Guam',90720),('GW','Guinea-Bissau',90725),('GY','Guyana',90726),('HR','Croatia',90674),('HT','Haiti',90727),('IN','India',90649),('KH','Cambodia',90656),('KM','Comoros (the)',90668),('KY','Cayman Islands (the)',90659),('PF','French Polynesia',90705),('SV','El Salvador',90691),('SZ','Eswatini',90696),('TD','Chad',90661),('TF','French Southern Territories (the)',90706);
/*!40000 ALTER TABLE `CountryImmunizationRecords` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Disease`
--
DROP TABLE IF EXISTS `Disease`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Disease` (
`ICD10` varchar(10) NOT NULL,
`Name` varchar(45) NOT NULL,
`Symptoms` varchar(255) DEFAULT NULL,
`VaccinationType` varchar(10) NOT NULL,
`SpreadBy` varchar(450) DEFAULT NULL,
`Complications` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ICD10`),
KEY `fk_vaccination_cat_idx` (`VaccinationType`),
CONSTRAINT `fk_vaccination_cat` FOREIGN KEY (`VaccinationType`) REFERENCES `VaccineCategories` (`VaccineCategoryID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Disease`
--
LOCK TABLES `Disease` WRITE;
/*!40000 ALTER TABLE `Disease` DISABLE KEYS */;
INSERT INTO `Disease` VALUES ('A00.0','CHOLERA','Watery Diarrhea, vomiting, rapid heart rate.','INV','Spreads by drinking water or eating food contaminated by bacterium.','Rapid fluid loss, low blood sugar. '),('A08.0','ROTAVIRUS','decreased urination, dry mouth and throat.','LAV','It spreads fecal-oral contact.','Severe diarrhea, dehydration, electrolyte imbalance'),('A22.9','ANTHRAX','Sore throat, mild fever, shortness of breath','TXV','Spreads through wound in skin,','Inflammation of membranes fluid covering brain and spinal cord'),('A33','TETANUS','Stiffness of neck, jaw and other muscles, fever and sweating.','TXV','Spreads when dirt enters a wound or cut.','Fractures, aspiration pneumonia.'),('A36.9','DIPHTHERIA','Sore throat and hoarseness, swollen glands(enlarged lymph nodes)','TXV','Spreads through respiratory droplets like coughing and sneezing.','paralysis, lung infection, nerve damage.'),('A39.9','MENINGOCOCCAL','Sudden high fever, nect stiffness, nausea or vomiting','SRPC','spreads by sharing respiratory and throat secretions.','Vasomotor collapse and shock'),('A80.9','Poliomyelitis (Polio)','Fever, sore throat, headache, vomitting, fatique.','INV','It is spread through infected fecal matter entering mouth.','Paralysis of muscles used for breathing'),('A82.9','RABIES','Irritability or aggressiveness, agitation, confusion','INV','Spread through saliva of infected animals.','Insomnia, anxiety, agitation'),('A95.9','YELLOW FEVER','Fever, Headache, Muscles aches, Nausea','LAV','Spread by bite of an infected female mosquito, ','Vomitting, bleeding, jaundice, liver failure, death.'),('B01.89','CHICKEN-POX','loss of appetite, aching muscles','LAV','spreads by closeness and contact with someone with chickenpox','bacterial infectons of skin'),('B02.9','SHINGLES','One-sided stabbing pain, headache, nausea, body aches','SRPC','Caused by varicella zoster virus. Can be caused after chickenpox.','Postherpetic neuralgia, Vision loss'),('B03','Small-Pox','sudden onset of high fever, malaise, widespread skin rash, severe headache, diarrhoea','LAV','infected person talks, coughs or sneezes small droplets containing infectious agents into the air. The droplets in the air may be breathed in by those nearby or may contaminate objects, Smallpox can also be spread by direct contact with blister fluid or contaminated objects.','Eye problems including corneal ulceration and blindnes, Bronchopneumoni, Arthritis, Osteomyelitis'),('B05.9','MEASLES','runny or blocked nose, sneezing, swollen eyelids','LAV','infection with rubeola virus. ','diarrhoea, vomitting, middle ear infection.'),('B06.9','RUBELLA','swollen and tender lymph nodes, mild fever, muscle pain, inflamed or red eyes.','LAV','It can be spread when an infected person coughs or sneezes.','Bleeding problems, testicular swelling.'),('B15.9','HEPATITIS A','flu-like sumptoms, dark urine, loss of appetite','INV','Spreads when virus from contaminated object is taken.','Liver Failure, Guillain Barre Syndrome.'),('B19.10','HEBATITIS B','Abdominal pain, dark urine, joint pain, loss of appetite','SRPC','Spread when blood,semen or other body fluid infected with Hepatitis B','Scarring of the liver, liver cancer.'),('B26.9','Mumps','pain while chewing, fever, pain in swollen salivary gland, muscle aches.','LAV','It can be transmitted by respiratory secretions.','Meningitis, encephalities.'),('B96.3','Haemophilus influenzae b (Hib)','headache, stiff neck, joint pain, fever.','SRPC','Bacteria can move to other parts of body and cause infection.','lung inflammation, joint infection'),('G00.1','Pneumococcal ','Fever, chills, chest pain, shortness of breath','SRPC','Spreads through contact with ill people or who have bacteria in throat','Empyema, pericarditis and respiratory failure'),('R87.810','human papillomavirus (hpv)','warts, genital warts.','SRPC','Spread by having intercourse with someone who has the virus.','Cancer in cervix');
/*!40000 ALTER TABLE `Disease` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `DiseaseVaccineRelation`
--
DROP TABLE IF EXISTS `DiseaseVaccineRelation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DiseaseVaccineRelation` (
`ICDCode` varchar(20) NOT NULL,
`VaccineID` int(11) NOT NULL,
PRIMARY KEY (`ICDCode`,`VaccineID`),
KEY `fk_DiseaseVaccineRelation_VaccineID_idx` (`VaccineID`),
CONSTRAINT `fk_DiseaseVaccineRelation_ICD` FOREIGN KEY (`ICDCode`) REFERENCES `Disease` (`ICD10`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_DiseaseVaccineRelation_VaccineID` FOREIGN KEY (`VaccineID`) REFERENCES `Vaccinations` (`VaccineID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `DiseaseVaccineRelation`
--
LOCK TABLES `DiseaseVaccineRelation` WRITE;
/*!40000 ALTER TABLE `DiseaseVaccineRelation` DISABLE KEYS */;
INSERT INTO `DiseaseVaccineRelation` VALUES ('B02.9',90646),('A82.9',90647),('B19.10',90648),('A95.9',90649),('A80.9',90650),('G00.1',90651),('A39.9',90653),('A00.0',90654),('A36.9',90655),('A33',90656),('B15.9',90657),('A22.9',90658),('R87.810',90659),('B26.9',90660),('B06.9',90661),('A08.0',90662),('B96.3',90663),('B01.89',90664),('B05.9',90665),('B19.10',90666),('A95.9',90668),('A80.9',90669),('A95.9',90670),('A80.9',90672),('G00.1',90673),('A39.9',90674),('A00.0',90675),('A22.9',90676),('R87.810',90680),('B26.9',90681),('B06.9',90682),('A08.0',90685),('B96.3',90686),('B01.89',90687),('B05.9',90701),('B19.10',90702),('A95.9',90703),('R87.810',90705),('B26.9',90706),('B06.9',90707),('A08.0',90708),('B96.3',90710),('B01.89',90712),('B05.9',90713);
/*!40000 ALTER TABLE `DiseaseVaccineRelation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `PublicHealthCentre`
--
DROP TABLE IF EXISTS `PublicHealthCentre`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PublicHealthCentre` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`pincode` varchar(10) NOT NULL,
`address` varchar(255) DEFAULT NULL,
`NumberOfHealthCamps` int(11) DEFAULT NULL,
`OperationalSince` varchar(30) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`Contact` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `PublicHealthCentre`
--
LOCK TABLES `PublicHealthCentre` WRITE;
/*!40000 ALTER TABLE `PublicHealthCentre` DISABLE KEYS */;
INSERT INTO `PublicHealthCentre` VALUES (1,'Health Centre1','110088','AE-9 Shalimar Bag',20,'2010-10-10','Delhi','New Delhi','9874561234'),(2,'Innotype','443929','57 Sutteridge Place',38,'27/03/2014','Delhi','New delhi','302-274-8402'),(3,'Vinte','668162','6615 Hallows Road',78,'23/06/2004','U.p','Bulandshahr','612-342-3932'),(4,'Tanoodle','668162','8577 Corben Avenue',95,'18/05/2006','Goa','murgaon','215-189-1219'),(5,'Browsezoom','668162','9 Westridge Parkway',42,'30/12/2013','Delhi','New Delhi','318-674-5796'),(6,'Jaxworks','211231','3817 Muir Avenue',18,'4/5/1984','Bihar','Patna','952-649-7215'),(7,'Browsebug','443929','672 Westend Center',56,'19/05/2008','Punjab','Chandigarh','843-850-7849'),(8,'Jazzy','211231','064 Autumn Leaf Junction',76,'1/1/2019','Delhi','New Delhi','907-932-4939'),(9,'Voonix','222312','6161 Luster Alley',2,'25/01/2010','Goa','panaji','260-736-4849'),(10,'Topicshots','443929','719 Arizona Street',42,'30/01/1983','Rajasthan','jaipur','901-781-1684'),(11,'Yacero','183221','28970 Logan Road',35,'16/05/2019','Bihar','patna','240-180-1384'),(12,'Gabcube','211231','99080 Golf Course Circle',92,'13/09/1989','Delhi','New Delhi','862-346-7449'),(13,'Yambee','183221','0 Butterfield Trail',1,'26/05/2001','Goa','murgaon','801-832-5744'),(14,'Blogpad','211231','7 Magdeline Alley',13,'19/08/1991','Rajasthan','Jodhpur','617-776-1099'),(15,'Zoonder','183221','89819 Judy Avenue',58,'21/03/1990','Bihar','munger','952-692-0279'),(16,'Divavu','211231','2885 Hauk Junction',54,'15/05/2008','Punjab','Amritsar','650-513-5924'),(17,'Demizz','668162','92 Lindbergh Pass',39,'25/03/1992','Delhi','New Delhi','347-358-1819'),(18,'Twinte','183221','93078 3rd Junction',52,'20/12/2014','M.P','Bhopal','334-278-8553'),(19,'Agimba','668162','80 Stuart Pass',26,'15/08/1996','Goa','murgaon','313-261-6267'),(20,'Skyndu','183221','08594 Trailsway Lane',70,'30/09/1991','Bihar','chappra','202-265-3165'),(21,'Yabox','668162','5926 Lighthouse Bay Pass',69,'28/10/2017','U.p','Mathura','479-167-9464'),(22,'Zoomcast','211231','9 Schmedeman Junction',10,'5/2/2013','M.P','Indore','501-289-8516'),(23,'Meejo','679130','3270 Helena Hill',71,'17/11/1985','Delhi','New Delhi','206-898-4327'),(24,'Oozz','443929','44327 International Plaza',40,'30/10/2003','Bihar','patna','702-202-0750'),(25,'Fivechat','211231','2480 Johnson Point',82,'2/12/1987','Goa','murgaon','214-233-8018'),(26,'Eamia','359120','523 Merry Parkway',28,'17/05/2018','M.P','Indore','216-684-5401'),(27,'Fiveclub','443929','2 Blackbird Center',79,'13/12/2016','Goa','bicholim','502-775-0092'),(28,'Yodo','359120','20592 Superior Point',63,'6/6/1989','Rajasthan','jaipur','405-871-5449'),(29,'Tagopia','359120','2898 Muir Terrace',3,'6/11/1996','Goa','Mapusa','516-419-1440'),(30,'Rhybox','443929','8 Londonderry Plaza',68,'21/12/1985','U.p','Gorakhpur','704-550-3717'),(31,'Zoombeat','359120','0155 Sachs Hill',19,'25/04/1987','Goa','Pernem','817-245-1078'),(32,'Skyble','211231','47 Brown Park',1,'28/04/1992','M.P','Indore','202-845-7832'),(33,'Jabberstorm','211231','9820 Rusk Circle',81,'22/06/1998','Goa','bicholim','818-717-3584'),(34,'Chatterpoint','434345','9079 Cascade Parkway',32,'19/05/1984','U.p','Agra','515-289-7183'),(35,'Tavu','443929','6921 Grayhawk Crossing',35,'3/1/1984','Rajasthan','Jaiselmer','202-119-8235'),(36,'Roombo','183221','29556 Orin Point',51,'17/06/2015','U.p','Agra','406-129-3204'),(37,'Skalith','359120','4 Walton Way',22,'13/07/2014','Rajasthan','Jaipur','480-896-0604'),(38,'Linkbuzz','183221','461 Mariners Cove Court',4,'1/10/1988','M.P','Bhopal','502-420-0658'),(39,'Aimbu','183221','026 Tennessee Crossing',64,'25/08/1990','Goa','Mapusa','502-582-4373'),(40,'Zooxo','211231','4972 Hagan Center',68,'18/04/1991','U.p','Aligarh','717-792-0230'),(41,'Brainsphere','183221','3398 Memorial Park',80,'17/08/1991','Punjab','Amritsar','314-723-5950'),(42,'Tavu','359120','4559 Nobel Parkway',38,'22/10/1982','Rajasthan','Jodhpur','205-232-0327'),(43,'Avavee','183221','2 Bartillon Avenue',47,'3/4/1995','Bihar','Patna','402-149-0451'),(44,'Kwimbee','183221','251 Hollow Ridge Road',78,'21/12/1989','Goa','Mapusa','515-110-1154'),(45,'DabZ','359120','5 Calypso Road',52,'14/03/1997','Punjab','Chandigarh','860-445-6892'),(46,'Kare','211231','992 Spenser Circle',28,'18/08/1983','Bihar','chappra','757-514-0095'),(47,'Youtags','183221','1384 Mandrake Alley',93,'29/08/1982','Goa','Pernem','989-683-8794'),(48,'Vinte','443929','2 Lillian Drive',78,'11/4/2009','Punjab','Amritsar','512-935-4931'),(49,'Flipopia','211231','9140 Arkansas Road',18,'21/09/1998','M.P','Bhopal','901-820-3248'),(50,'Kwilith','359120','7 Clemons Junction',96,'19/03/2004','Rajasthan','Jaipur','907-628-3919');
/*!40000 ALTER TABLE `PublicHealthCentre` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `RegisteredPractitioners`
--
DROP TABLE IF EXISTS `RegisteredPractitioners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `RegisteredPractitioners` (
`LicenseNumber` varchar(255) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`practicingSince` date DEFAULT NULL,
`healthCentreID` int(11) DEFAULT NULL,
`userID` int(11) NOT NULL,
PRIMARY KEY (`LicenseNumber`,`userID`),
KEY `healthCentreID` (`healthCentreID`),
KEY `userID` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `RegisteredPractitioners`
--
LOCK TABLES `RegisteredPractitioners` WRITE;
/*!40000 ALTER TABLE `RegisteredPractitioners` DISABLE KEYS */;
INSERT INTO `RegisteredPractitioners` VALUES ('132-65-4505','Sybille Crispe','2000-08-12',14,31),('133-74-2721','Devlen Gottschalk','2002-10-02',25,38),('144-30-9830','Ximenez Ibbeson','2001-07-20',42,16),('161-14-4194','Verene Gwalter','2003-10-01',1,3),('163-28-0269','Perceval Helversen','2001-06-11',15,33),('172-96-7136','Rois Stener','2003-10-30',37,28),('178-28-7001','Wynnie Ravenshear','2000-09-27',9,19),('184-28-6779','Reinold Rentoll','2002-12-27',45,4),('187-18-3221','Nathanael La Croce','2002-08-29',5,9),('190-99-3495','Iolanthe Heyworth','2003-01-18',18,39),('205-50-6160','Meggie Rake','2000-03-30',30,49),('214-19-9964','Clevey Trillo','2000-08-04',39,22),('217-03-0076','Mirilla Henfre','2002-03-30',44,1),('222-32-7213','Britteny Abbis','2002-07-30',7,13),('233-74-2310','Pru Weathers','2002-12-04',47,6),('244-97-4387','Karlen Tofanelli','2003-10-25',13,29),('265-69-5180','Roobbie Barneveld','2003-01-04',26,36),('279-61-6727','Trista Fossett','2002-03-28',35,47),('316-98-9546','Adiana Primak','2003-07-29',48,8),('344-63-2140','Killy Wyllcock','2001-09-06',6,11),('369-12-1813','Ignacius Bandy','2003-06-03',28,32),('369-98-9669','Yolande Weed','2000-10-05',41,18),('384-78-2405','Vasili Heinssen','2001-04-01',17,37),('399-28-3462','Merrile Coldicott','2001-02-08',50,50),('456-91-4930','Noll Graddon','2003-06-06',23,42),('480-64-7628','Gallagher Files','2001-01-15',40,20),('490-71-9607','Krissy Sanger','2002-10-02',31,17),('491-66-4775','Nora Waistell','2000-02-09',38,24),('522-46-9351','Kristofer Cray','2000-08-23',20,43),('552-14-8904','Rivy Richemond','2003-11-02',19,41),('580-44-2922','Poul Jaggi','2000-07-17',12,27),('616-98-8641','Petrina Willgress','2002-03-31',32,21),('628-69-5304','Humfried Lowin','2002-04-28',8,15),('629-75-0484','Myrwyn Geill','2003-07-03',21,46),('675-39-3063','Annabel Combes','2000-02-12',27,34),('686-78-9971','Gianina Gurdon','2002-11-29',24,40),('706-92-2789','Nichols Allbrook','2000-04-13',34,45),('730-09-3334','Giselle Collinette','2000-09-30',16,35),('760-56-5920','Duncan McGonnell','2001-07-13',46,12),('770-60-7147','Bryanty Schirak','2000-09-10',22,44),('782-07-9052','Kylila Guinnane','2002-05-04',33,26),('782-71-9260','Dania Cometti','2004-02-02',11,25),('798-70-8645','Kingston Glancy','2000-08-12',49,10),('804-07-1073','Savina McTrustie','2001-02-03',29,30),('811-82-0121','Avigdor Angear','2001-07-05',2,2),('843-11-9362','Garrett Solon','2000-08-26',4,7),('846-88-3030','Madeline Creed','2002-10-27',43,14),('871-68-4228','Robbert Zorzoni','2002-07-11',10,23),('882-93-4886','Lisabeth Gosnall','2002-05-24',3,5),('899-88-1049','Ulysses Eagle','2002-04-24',36,48);
/*!40000 ALTER TABLE `RegisteredPractitioners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `RoleRef`
--
DROP TABLE IF EXISTS `RoleRef`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `RoleRef` (
`roleId` int(11) NOT NULL,
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `RoleRef`
--
LOCK TABLES `RoleRef` WRITE;
/*!40000 ALTER TABLE `RoleRef` DISABLE KEYS */;
INSERT INTO `RoleRef` VALUES (1,'admin'),(2,'patient'),(3,'doctor'),(4,'General'),(5,'Official');
/*!40000 ALTER TABLE `RoleRef` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VaccinationRecords`
--
DROP TABLE IF EXISTS `VaccinationRecords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VaccinationRecords` (
`VaccineID` int(11) DEFAULT NULL,
`UserID` int(11) DEFAULT NULL,
`VaccineDate` date DEFAULT NULL,
`PublicHealthCentreID` int(11) DEFAULT NULL,
`DosageNo` int(11) DEFAULT NULL,
`CampID` int(11) DEFAULT NULL,
`DoctorLicenseNo` varchar(255) DEFAULT NULL,
`VaccineCode` varchar(255) NOT NULL,
PRIMARY KEY (`VaccineCode`),
KEY `VaccineID` (`VaccineID`),
KEY `UserID` (`UserID`),
KEY `PublicHealthCentreID` (`PublicHealthCentreID`),
KEY `CampID` (`CampID`),
KEY `DoctorLicenseNo` (`DoctorLicenseNo`),
CONSTRAINT `VaccinationRecords_ibfk_1` FOREIGN KEY (`VaccineID`) REFERENCES `Vaccinations` (`VaccineID`),
CONSTRAINT `VaccinationRecords_ibfk_2` FOREIGN KEY (`UserID`) REFERENCES `users` (`id`),
CONSTRAINT `VaccinationRecords_ibfk_3` FOREIGN KEY (`PublicHealthCentreID`) REFERENCES `PublicHealthCentre` (`id`),
CONSTRAINT `VaccinationRecords_ibfk_4` FOREIGN KEY (`CampID`) REFERENCES `VaccineCamps` (`CampID`),
CONSTRAINT `VaccinationRecords_ibfk_5` FOREIGN KEY (`DoctorLicenseNo`) REFERENCES `RegisteredPractitioners` (`LicenseNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `VaccinationRecords`
--
LOCK TABLES `VaccinationRecords` WRITE;
/*!40000 ALTER TABLE `VaccinationRecords` DISABLE KEYS */;
INSERT INTO `VaccinationRecords` VALUES (90281,73,'2020-03-03',14,5,22,'217-03-0076','0054-4301'),(90650,34,'2020-02-10',10,4,9,'163-28-0269','0280-1197'),(90656,24,'2020-04-03',42,5,12,'133-74-2721','0456-0045'),(90653,75,'2020-02-02',31,1,37,'730-09-3334','0574-0016'),(90376,37,'2020-03-30',30,3,46,'316-98-9546','0781-5791'),(90476,24,'2020-01-10',22,3,27,'628-69-5304','0942-6479'),(90389,85,'2020-03-15',30,4,43,'344-63-2140','15370-101'),(90625,5,'2020-03-31',13,4,44,'616-98-8641','21695-036'),(90287,11,'2020-03-15',50,3,12,'161-14-4194','21695-461'),(90620,98,'2020-02-23',8,1,50,'178-28-7001','23155-240'),(90375,51,'2020-03-23',19,5,11,'843-11-9362','24236-933'),(90649,65,'2020-01-28',5,3,49,'369-12-1813','33261-975'),(90660,23,'2020-01-27',30,4,25,'456-91-4930','33342-047'),(90477,36,'2020-02-16',35,2,42,'144-30-9830','35781-0230'),(90283,28,'2020-01-27',18,5,46,'811-82-0121','36987-2623'),(90658,1,'2020-03-02',49,1,38,'686-78-9971','36987-3391'),(90630,92,'2020-02-26',22,5,20,'214-19-9964','37000-705'),(90470,39,'2020-03-17',40,3,3,'846-88-3030','37205-694'),(90291,32,'2020-02-14',14,2,26,'184-28-6779','43269-619'),(90661,15,'2020-03-15',9,5,45,'522-46-9351','43479-108'),(90393,23,'2020-03-09',7,2,16,'760-56-5920','47335-676'),(90621,51,'2020-03-23',9,2,39,'480-64-7628','49643-328'),(90659,97,'2020-03-03',42,3,22,'552-14-8904','50242-138'),(90645,46,'2020-03-18',31,3,45,'172-96-7136','50436-0284'),(90665,33,'2020-03-23',35,5,20,'279-61-6727','51769-003'),(90371,91,'2020-03-28',27,2,39,'233-74-2310','52125-398'),(90657,40,'2020-03-30',17,3,42,'190-99-3495','52599-282'),(90378,4,'2020-03-17',24,2,12,'187-18-3221','53645-1090'),(90296,71,'2020-01-05',33,3,11,'882-93-4886','53808-0687'),(90585,41,'2020-03-17',35,5,25,'369-98-9669','54170-120'),(90655,25,'2020-01-23',23,1,8,'384-78-2405','54868-3408'),(90647,58,'2020-03-01',31,3,38,'804-07-1073','54868-5590'),(90632,53,'2020-04-09',33,2,28,'871-68-4228','57896-638'),(90646,97,'2020-02-26',1,2,7,'244-97-4387','59779-182'),(90634,94,'2020-01-12',39,3,20,'782-71-9260','60429-310'),(90648,84,'2020-01-15',25,3,22,'132-65-4505','60429-372'),(90633,2,'2020-03-29',27,2,31,'491-66-4775','60432-834'),(90669,71,'2020-01-27',1,5,16,'399-28-3462','61734-085'),(90664,38,'2020-03-28',27,3,29,'629-75-0484','61957-0008'),(90663,8,'2020-01-05',1,5,30,'706-92-2789','63548-6352'),(90654,56,'2020-02-08',37,2,36,'265-69-5180','63629-3204'),(90668,88,'2020-03-17',2,2,10,'205-50-6160','63667-507'),(90396,36,'2020-03-19',34,1,6,'222-32-7213','64117-969'),(90644,99,'2020-02-23',42,4,5,'580-44-2922','64679-920'),(90581,10,'2020-01-10',24,1,16,'490-71-9607','65862-079'),(90666,58,'2020-03-30',38,5,34,'899-88-1049','67510-0633'),(90379,70,'2020-01-27',22,2,2,'798-70-8645','67877-147'),(90651,15,'2020-03-18',48,5,42,'675-39-3063','68462-192'),(90662,42,'2020-02-14',47,1,15,'770-60-7147','68703-051'),(90636,58,'2020-02-06',26,1,2,'782-07-9052','76385-103');
/*!40000 ALTER TABLE `VaccinationRecords` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Vaccinations`
--
DROP TABLE IF EXISTS `Vaccinations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Vaccinations` (
`VaccineID` int(11) NOT NULL,
`purpose` varchar(255) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`requiredDosages` int(11) unsigned NOT NULL,
PRIMARY KEY (`VaccineID`),
UNIQUE KEY `VaccineID_UNIQUE` (`VaccineID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Vaccinations`
--
LOCK TABLES `Vaccinations` WRITE;
/*!40000 ALTER TABLE `Vaccinations` DISABLE KEYS */;
INSERT INTO `Vaccinations` VALUES (90281,'Immune globulin (Ig), human, for intramuscular use','IG',1),(90283,'Immune globulin (IgIV), human, for intravenous use','IGIV',4),(90287,'Botulinum antitoxin, equine, any route','botulinum antitoxin',2),(90291,'Cytomegalovirus immune globulin (CMV-IgIV), human, for intravenous use','CMVIG',1),(90296,'Diphtheria antitoxin, equine, any route','diphtheria antitoxin',4),(90371,'Hepatitis B immune globulin (HBIg), human, for intramuscular use','HBIG',2),(90375,'Rabies immune globulin (RIg), human, for intramuscular and/or subcutaneous use','RIG',4),(90376,'Rabies immune globulin, heat-treated (RIg-HT), human, for intramuscular and/or subcutaneous use','RIG',3),(90378,'Respiratory syncytial virus, monoclonal antibody, recombinant, for intramuscular use, 50 mg, each','RSV-MAb',2),(90379,'Respiratory syncytial virus immune globulin (RSV-IgIV), human, for intravenous use','RSV-IGIV',4),(90389,'Tetanus immune globulin (TIg), human, for intramuscular use','TIG',1),(90393,'Vaccinia immune globulin, human, for intramuscular use','vaccinia immune globulin',5),(90396,'Varicella-zoster immune globulin, human, for intramuscular use','VZIG',2),(90470,'H1N1 immunization administration (intramuscular, intranasal), including counseling when performed','Novel Influenza-H1N1-09, all formulations',5),(90476,'Adenovirus vaccine, type 4, live, for oral use','adenovirus, type 4',3),(90477,'Adenovirus vaccine, type 7, live, for oral use','adenovirus, type 7',1),(90581,'Anthrax vaccine, for subcutaneous or intramuscular use','anthrax',5),(90585,'Bacillus Calmette-Guerin vaccine (BCG) for tuberculosis, live, for percutaneous use','BCG',1),(90620,'Meningococcal recombinant protein and outer membrane vesicle vaccine, serogroup B (MenB-4C), 2 dose schedule, for intramuscular use','meningococcal B, OMV',1),(90621,'Meningococcal recombinant lipoprotein vaccine, serogroup B (MenB-FHbp), 2 or 3 dose schedule, for intramuscular use','meningococcal B, recombinant',1),(90625,'Cholera vaccine, live, adult dosage, 1 dose schedule, for oral use','cholera, live attenuated',6),(90630,'Influenza virus vaccine, quadrivalent (IIV4), split virus, preservative free, for intradermal use','influenza, intradermal, quadrivalent, preservative free',2),(90632,'Hepatitis A vaccine (HepA), adult dosage, for intramuscular use','Hep A, adult',1),(90633,'Hepatitis A vaccine (HepA), pediatric/adolescent dosage-2 dose schedule, for intramuscular use','Hep A, ped/adol, 2 dose',3),(90634,'Hepatitis A vaccine (HepA), pediatric/adolescent dosage-3 dose schedule, for intramuscular use','Hep A, ped/adol, 3 dose',3),(90636,'Hepatitis A and hepatitis B vaccine (HepA-HepB), adult dosage, for intramuscular use','Hep A-Hep B',2),(90644,'Meningococcal conjugate vaccine, serogroups C & Y and Haemophilus influenzae type b vaccine (Hib-MenCY), 4 dose schedule, when administered to children 6 weeks-18 months of age, for intramuscular use','Meningococcal C/Y-HIB PRP',3),(90645,'Hemophilus influenza b vaccine (Hib), HbOC conjugate (4 dose schedule), for intramuscular use','Hib (HbOC)',1),(90646,'Hemophilus influenza b vaccine (Hib), PRP-D conjugate, for booster use only, intramuscular use','Hib (PRP-D)',1),(90647,'Haemophilus influenzae type b vaccine (Hib), PRP-OMP conjugate, 3 dose schedule, for intramuscular use','Hib (PRP-OMP)',2),(90648,'Haemophilus influenzae type b vaccine (Hib), PRP-T conjugate, 4 dose schedule, for intramuscular use','Hib (PRP-T)',2),(90649,'Human Papillomavirus vaccine, types 6, 11, 16, 18, quadrivalent (4vHPV), 3 dose schedule, for intramuscular use','HPV, quadrivalent',2),(90650,'Human Papillomavirus vaccine, types 16, 18, bivalent (2vHPV), 3 dose schedule, for intramuscular use','HPV, bivalent',2),(90651,'Human Papillomavirus vaccine types 6, 11, 16, 18, 31, 33, 45, 52, 58, nonavalent (9vHPV), 2 or 3 dose schedule, for intramuscular use','HPV9',2),(90653,'Influenza vaccine, inactivated (IIV), subunit, adjuvanted, for intramuscular use','influenza, trivalent, adjuvanted',4),(90654,'Influenza virus vaccine, trivalent (IIV3), split virus, preservative-free, for intradermal use','influenza, seasonal, intradermal, preservative free',3),(90655,'Influenza virus vaccine, trivalent (IIV3), split virus, preservative free, 0.25 mL dosage, for intramuscular use','Influenza, seasonal, injectable, preservative free',3),(90656,'Influenza virus vaccine, trivalent (IIV3), split virus, preservative free, 0.5 mL dosage, for intramuscular use','Influenza, seasonal, injectable, preservative free',3),(90657,'Influenza virus vaccine, trivalent (IIV3), split virus, 0.25 mL dosage, for intramuscular use','Influenza, seasonal, injectable',3),(90658,'Influenza virus vaccine, trivalent (IIV3), split virus, 0.5 mL dosage, for intramuscular use','Influenza, seasonal, injectable',2),(90659,'Influenza virus vaccine, whole virus, for intramuscular or jet injection use','influenza, whole',3),(90660,'Influenza virus vaccine, trivalent, live (LAIV3), for intranasal use','influenza, live, intranasal',2),(90661,'Influenza virus vaccine, trivalent (ccIIV3), derived from cell cultures, subunit, preservative and antibiotic free, 0.5 mL dosage, for intramuscular use','Influenza, injectable, MDCK, preservative free',5),(90662,'Influenza virus vaccine (IIV), split virus, preservative free, enhanced immunogenicity via increased antigen content, for intramuscular use','Influenza, high dose seasonal',4),(90663,'Influenza virus vaccine, pandemic formulation, H1N1','Novel Influenza-H1N1-09, all formulations',1),(90664,'Influenza virus vaccine, live (LAIV), pandemic formulation, for intranasal use','Novel Influenza-H1N1-09, nasal',3),(90665,'Lyme disease vaccine, adult dosage, for intramuscular use','Lyme disease',2),(90666,'Influenza virus vaccine (IIV), pandemic formulation, split virus, preservative free, for intramuscular use','Novel influenza-H1N1-09, preservative-free',1),(90668,'Influenza virus vaccine (IIV), pandemic formulation, split virus, for intramuscular use','Novel influenza-H1N1-09',1),(90669,'Pneumococcal conjugate vaccine, 7 valent, for intramuscular use','pneumococcal conjugate PCV 7',1),(90670,'Pneumococcal conjugate vaccine, 13 valent (PCV13), for intramuscular use','Pneumococcal conjugate PCV 13',4),(90672,'Influenza virus vaccine, quadrivalent, live (LAIV4), for intranasal use','influenza, live, intranasal, quadrivalent',1),(90673,'Influenza virus vaccine, trivalent (RIV3), derived from recombinant DNA, hemagglutinin (HA) protein only, preservative and antibiotic free, for intramuscular use','influenza, recombinant, injectable, preservative free',3),(90674,'Influenza virus vaccine, quadrivalent (ccIIV4), derived from cell cultures, subunit, preservative and antibiotic free, 0.5 mL dosage, for intramuscular use','Influenza, injectable, MDCK, preservative free, quadrivalent',1),(90675,'Rabies vaccine, for intramuscular use','rabies, unspecified formulation',2),(90676,'Rabies vaccine, for intradermal use','rabies, intradermal injection',1),(90680,'Rotavirus vaccine, pentavalent (RV5), 3 dose schedule, live, for oral use','rotavirus, pentavalent',5),(90681,'Rotavirus vaccine, human, attenuated (RV1), 2 dose schedule, live, for oral use','rotavirus, monovalent',1),(90682,'Influenza virus vaccine, quadrivalent (RIV4), derived from recombinant DNA, hemagglutinin (HA) protein only, preservative and antibiotic free, for intramuscular use','influenza, recombinant, quadrivalent,injectable, preservative free',4),(90685,'Influenza virus vaccine, quadrivalent (IIV4), split virus, preservative free, 0.25 mL dosage, for intramuscular use','Influenza, injectable,quadrivalent, preservative free, pediatric',3),(90686,'Influenza virus vaccine, quadrivalent (IIV4), split virus, preservative free, 0.5 mL dosage, for intramuscular use','influenza, injectable, quadrivalent, preservative free',2),(90687,'Influenza virus vaccine, quadrivalent (IIV4), split virus, 0.25 mL dosage, for intramuscular use','influenza, injectable, quadrivalent',1),(90688,'Influenza virus vaccine, quadrivalent (IIV4), split virus, 0.5 mL dosage, for intramuscular use','influenza, injectable, quadrivalent',2),(90690,'Typhoid vaccine, live, oral','typhoid, oral',1),(90691,'Typhoid vaccine, Vi capsular polysaccharide (ViCPs), for intramuscular use','typhoid, ViCPs',1),(90692,'Typhoid vaccine, heat- and phenol-inactivated (H-P), for subcutaneous or intradermal use','typhoid, parenteral',2),(90693,'Typhoid vaccine, acetone-killed, dried (AKD), for subcutaneous use (U.S. military)','typhoid, parenteral, AKD (U.S. military)',2),(90694,'Influenza virus vaccine, quadrivalent (aIIV4), inactivated, adjuvanted, preservative free, 0.5 mL dosage, for intramuscular use','influenza, injectable, quadrivalent, preservative free',1),(90696,'Diphtheria, tetanus toxoids, acellular pertussis vaccine and inactivated poliovirus vaccine (DTaP-IPV), when administered to children 4 through 6 years of age, for intramuscular use','DTaP-IPV',1),(90697,'Diphtheria, tetanus toxoids, acellular pertussis vaccine, inactivated poliovirus vaccine, Haemophilus influenzae type b PRP-OMP conjugate vaccine, and hepatitis B vaccine (DTaP-IPV-Hib-HepB), for intramuscular use','DTaP,IPV,Hib,HepB',3),(90698,'Diphtheria, tetanus toxoids, acellular pertussis vaccine, Haemophilus influenzae type b, and inactivated poliovirus vaccine, (DTaP-IPV/Hib), for intramuscular use','DTaP-Hib-IPV',2),(90700,'Diphtheria, tetanus toxoids, and acellular pertussis vaccine (DTaP), when administered to individuals younger than 7 years, for intramuscular use','DTaP, unspecified formulation',4),(90701,'Diphtheria, tetanus toxoids, and whole cell pertussis vaccine (DTP), for intramuscular use','DTP',4),(90702,'Diphtheria and tetanus toxoids adsorbed (DT) when administered to individuals younger than 7 years, for intramuscular use','DT (pediatric)',4),(90703,'Tetanus toxoid adsorbed, for intramuscular use','tetanus toxoid, adsorbed',1),(90704,'Mumps virus vaccine, live, for subcutaneous use','mumps',2),(90705,'Measles virus vaccine, live, for subcutaneous use','measles',3),(90706,'Rubella virus vaccine, live, for subcutaneous use','rubella',3),(90707,'Measles, mumps and rubella virus vaccine (MMR), live, for subcutaneous use','MMR',3),(90708,'Measles and rubella virus vaccine, live, for subcutaneous use','M/R',2),(90710,'Measles, mumps, rubella, and varicella vaccine (MMRV), live, for subcutaneous use','MMRV',1),(90712,'Poliovirus vaccine, (any type[s]) (OPV), live, for oral use','OPV, Unspecified',3),(90713,'Poliovirus vaccine, inactivated (IPV), for subcutaneous or intramuscular use','IPV',3),(90714,'Tetanus and diphtheria toxoids adsorbed (Td), preservative free, when administered to individuals 7 years or older, for intramuscular use','Td, adsorbed, preservative free, adult use, Lf unspecified',2),(90715,'Tetanus, diphtheria toxoids and acellular pertussis vaccine (Tdap), when administered to individuals 7 years or older, for intramuscular use','Tdap',3),(90716,'Varicella virus vaccine (VAR), live, for subcutaneous use','varicella',2),(90717,'Yellow fever vaccine, live, for subcutaneous use','Yellow fever, unspecified formulation',2),(90718,'Tetanus and diphtheria toxoids (Td) adsorbed when administered to individuals 7 years or older, for intramuscular use','Td (adult), 2 Lf tetanus toxoid, preservative free, adsorbed',1),(90720,'Diphtheria, tetanus toxoids, and whole cell pertussis vaccine and Hemophilus influenza B vaccine (DTP-Hib), for intramuscular use','DTP-Hib',1),(90721,'Diphtheria, tetanus toxoids, and acellular pertussis vaccine and Hemophilus influenza B vaccine (DTaP/Hib), for intramuscular use','DTaP-Hib',1),(90723,'Diphtheria, tetanus toxoids, acellular pertussis vaccine, hepatitis B, and inactivated poliovirus vaccine (DTaP-HepB-IPV), for intramuscular use','DTaP-Hep B-IPV',2),(90724,'Influenza virus vaccine','influenza, unspecified formulation',3),(90725,'Cholera vaccine for injectable use','cholera, unspecified formulation',5),(90726,'Rabies vaccine','rabies, unspecified formulation',3),(90727,'Plague vaccine, for intramuscular use','plague',2),(90728,'BCG vaccine','BCG',2),(90730,'Hepatitis A vaccine','Hep A, unspecified formulation',2),(90731,'Hepatitis B vaccine','Hep B, unspecified formulation',1),(90732,'Pneumococcal polysaccharide vaccine, 23-valent (PPSV23), adult or immunosuppressed patient dosage, when administered to individuals 2 years or older, for subcutaneous or intramuscular use','pneumococcal polysaccharide PPV23',3),(90733,'Meningococcal polysaccharide vaccine, serogroups A, C, Y, W-135, quadrivalent (MPSV4), for subcutaneous use','meningococcal MPSV4',5),(90734,'Meningococcal conjugate vaccine, serogroups A, C, W, Y, quadrivalent, diphtheria toxoid carrier (MenACWY-D) or CRM197 carrier (MenACWY-CRM), for intramuscular use','meningococcal MCV4, unspecified formulation',4),(90735,'Japanese encephalitis virus vaccine, for subcutaneous use','Japanese encephalitis SC',2),(90736,'Zoster (shingles) vaccine (HZV), live, for subcutaneous injection','zoster live',3),(90737,'Hemophilus influenza B','Hib, unspecified formulation',3),(90738,'Japanese encephalitis virus vaccine, inactivated, for intramuscular use','Japanese Encephalitis IM',2),(90739,'Hepatitis B vaccine (HepB), adult dosage, 2 dose schedule, for intramuscular use','HepB-CpG',1),(90740,'Hepatitis B vaccine (HepB), dialysis or immunosuppressed patient dosage, 3 dose schedule, for intramuscular use','Hep B, dialysis',3),(90741,'Immunization, passive; immune serum globulin, human (ISG)','IG, unspecified formulation',4),(90743,'Hepatitis B vaccine (HepB), adolescent, 2 dose schedule, for intramuscular use','Hep B, adult',3),(90744,'Hepatitis B vaccine (HepB), pediatric/adolescent dosage, 3 dose schedule, for intramuscular use','Hep B, adolescent or pediatric',3),(90745,'Hepatitis B vaccine, adolescent/high risk infant dosage, for intramuscular use','Hep B, adolescent/high risk infant',3),(90746,'Hepatitis B vaccine (HepB), adult dosage, 3 dose schedule, for intramuscular use','Hep B, adult',2),(90747,'Hepatitis B vaccine (HepB), dialysis or immunosuppressed patient dosage, 4 dose schedule, for intramuscular use','Hep B, dialysis',3),(90748,'Hepatitis B and Haemophilus influenzae type b vaccine (Hib-HepB), for intramuscular use','Hib-Hep B',2),(90750,'Zoster (shingles) vaccine (HZV), recombinant, subunit, adjuvanted, for intramuscular use','zoster recombinant',2),(90756,'Influenza virus vaccine, quadrivalent (ccIIV4), derived from cell cultures, subunit, antibiotic free, 0.5 mL dosage, for intramuscular use','Influenza, injectable, MDCK, quadrivalent, preservative',1);
/*!40000 ALTER TABLE `Vaccinations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VaccineCamps`
--
DROP TABLE IF EXISTS `VaccineCamps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VaccineCamps` (
`CampID` int(11) NOT NULL,
`StartDate` date NOT NULL,
`EndDate` date NOT NULL,
`NumberOfPeopleTreated` int(11) NOT NULL DEFAULT '0',
`VaccineIDs` int(11) NOT NULL,
`HealthCentreID` int(11) NOT NULL,
PRIMARY KEY (`CampID`),
KEY `VaccineCamps_ibfk_1` (`VaccineIDs`),
KEY `fk_VaccineCamps_healthCentre_idx` (`HealthCentreID`),
CONSTRAINT `VaccineCamps_ibfk_1` FOREIGN KEY (`VaccineIDs`) REFERENCES `Vaccinations` (`VaccineID`),
CONSTRAINT `fk_VaccineCamps_healthCentre` FOREIGN KEY (`HealthCentreID`) REFERENCES `PublicHealthCentre` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `VaccineCamps`
--
LOCK TABLES `VaccineCamps` WRITE;
/*!40000 ALTER TABLE `VaccineCamps` DISABLE KEYS */;
INSERT INTO `VaccineCamps` VALUES (1,'2020-03-03','2020-03-10',42,90281,5),(2,'2020-01-27','2020-02-04',30,90283,4),(3,'2020-03-15','2020-03-25',36,90287,9),(4,'2020-02-14','2020-02-24',36,90291,6),(5,'2020-01-05','2020-01-16',38,90296,12),(6,'2020-03-28','2020-04-06',43,90371,13),(7,'2020-03-23','2020-03-30',34,90375,14),(8,'2020-03-30','2020-04-08',47,90376,34),(9,'2020-03-17','2020-03-24',37,90378,23),(10,'2020-01-27','2020-02-03',40,90379,24),(11,'2020-03-15','2020-03-23',47,90389,26),(12,'2020-03-09','2020-03-16',43,90393,45),(13,'2020-03-19','2020-03-26',31,90396,34),(14,'2020-03-17','2020-03-24',36,90470,45),(15,'2020-01-10','2020-01-17',46,90476,15),(16,'2020-02-16','2020-02-23',50,90477,19),(17,'2020-01-10','2020-01-24',33,90581,21),(18,'2020-03-17','2020-03-24',35,90585,4),(19,'2020-02-23','2020-03-01',49,90620,1),(20,'2020-03-23','2020-03-30',40,90621,23),(21,'2020-03-31','2020-04-07',43,90625,45),(22,'2020-02-26','2020-03-04',42,90630,9),(23,'2020-04-09','2020-04-16',44,90632,23),(24,'2020-03-29','2020-04-05',46,90633,45),(25,'2020-01-12','2020-01-19',45,90634,48),(26,'2020-02-06','2020-02-13',35,90636,42),(27,'2020-02-23','2020-03-01',41,90644,41),(28,'2020-03-18','2020-03-25',39,90645,28),(29,'2020-02-26','2020-03-04',31,90646,36),(30,'2020-03-01','2020-03-08',30,90647,45),(31,'2020-01-15','2020-01-22',46,90648,19),(32,'2020-01-28','2020-02-04',41,90649,29),(33,'2020-02-10','2020-02-17',32,90650,31),(34,'2020-03-18','2020-03-25',49,90651,47),(35,'2020-02-02','2020-02-09',33,90644,32),(36,'2020-02-08','2020-02-15',31,90645,49),(37,'2020-01-23','2020-01-30',45,90646,16),(38,'2020-04-03','2020-04-10',44,90647,24),(39,'2020-03-30','2020-04-07',47,90648,36),(40,'2020-03-02','2020-03-09',41,90649,47),(41,'2020-02-04','2020-02-11',47,90650,12),(42,'2020-03-18','2020-03-25',36,90651,7),(43,'2020-03-17','2020-03-25',39,90644,34),(44,'2020-01-11','2020-01-19',30,90645,45),(45,'2020-02-08','2020-02-17',48,90646,5),(46,'2020-01-20','2020-01-28',44,90647,23),(47,'2020-02-03','2020-02-11',40,90648,42),(48,'2020-03-05','2020-03-13',31,90649,27),(49,'2020-01-11','2020-01-18',33,90650,16),(50,'2020-01-27','2020-02-03',47,90651,8);
/*!40000 ALTER TABLE `VaccineCamps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `VaccineCategories`
--
DROP TABLE IF EXISTS `VaccineCategories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VaccineCategories` (
`SID` int(11) NOT NULL,
`VaccineCategoryID` varchar(255) NOT NULL,
`Category Name` varchar(100) NOT NULL,
`Description` varchar(500) DEFAULT NULL,
PRIMARY KEY (`VaccineCategoryID`),
UNIQUE KEY `SID_UNIQUE` (`SID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `VaccineCategories`
--
LOCK TABLES `VaccineCategories` WRITE;
/*!40000 ALTER TABLE `VaccineCategories` DISABLE KEYS */;
INSERT INTO `VaccineCategories` VALUES (2,'INV','Inactivated vaccines','Inactivated vaccines use the killed version of the germ that causes a disease.'),(1,'LAV','Live-attenuated vaccines','Live vaccines use a weakened (or attenuated) form of the germ that causes a disease.'),(3,'SRPC','Subunit, recombinant, polysaccharide, and conjugate vaccines','Subunit, recombinant, polysaccharide, and conjugate vaccines use specific pieces of the germ — like its protein, sugar, or capsid (a casing around the germ).'),(4,'TXV','Toxoid Vaccines','Toxoid vaccines use a toxin (harmful product) made by the germ that causes a disease. They create immunity to the parts of the germ that cause a disease instead of the germ itself. That means the immune response is targeted to the toxin instead of the whole germ.');
/*!40000 ALTER TABLE `VaccineCategories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`full_name` varchar(255) NOT NULL,
`Gender` varchar(10) DEFAULT NULL,
`DOB` date NOT NULL,
`emailID` varchar(255) DEFAULT NULL,
`pincode` int(11) NOT NULL,
`state` varchar(255) DEFAULT NULL,
`Address` varchar(255) DEFAULT NULL,
`Contact` varchar(255) NOT NULL,
`GuardianName` varchar(255) DEFAULT NULL,
`Aadhar Number` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Stevie Heatly','Male','2009-01-30','[email protected]',668162,'Goa','5254 Warbler Way','562-86-9676','Carlyle Fivey','443-43-1170-3213'),(2,'Hendrik Blevin','Male','2010-06-11','[email protected]',443929,'Delhi','864 Northview Avenue','497-72-2240','Charley Varden','735-97-7875-3214'),(3,'Britt Lyman','Female','2010-05-27','[email protected]',668162,'U.p','99118 Stoughton Crossing','282-16-2744','Franky Lamberts','484-40-0058-1235'),(4,'Tabby Trengove','Male','2009-04-05','[email protected]',668162,'Goa','82 Burrows Pass','747-30-6507','Artair De Haven','550-59-3907-4322'),(5,'Gabbie Garrioch','Female','2010-09-10','[email protected]',668162,'Delhi','47506 Cambridge Hill','827-23-8731','Stephie Coxhell','424-38-6855-4531'),(6,'Filmore Bruun','Male','2008-09-06','[email protected]',211231,'Bihar','379 Transport Road','176-24-6699','Ulric Esgate','165-44-9180-4565'),(7,'Cyndy Kear','Female','2010-01-20','[email protected]',443929,'Punjab','52542 Coleman Hill','307-81-5145','Gunilla Falloon','595-09-8405-4566'),(8,'Sterling Simper','Male','2010-06-30','[email protected]',211231,'Delhi','306 Lotheville Court','572-42-3378','Murvyn Pohlke','803-87-2998-4561'),(9,'Tulley Beedle','Male','2009-02-08','[email protected]',222312,'Goa','86 Cody Crossing','423-21-1107','Sim Lokier','324-46-3170-6751'),(10,'Carin Allanby','Female','2009-05-15','[email protected]',443929,'Rajasthan','21 Ridgeway Terrace','423-77-5120','Lorry Rakes','292-58-4149-5636'),(11,'Iver Berkley','Male','2008-10-25','[email protected]',183221,'Bihar','3708 Hansons Plaza','717-86-2724','Lalo Petcher','586-81-0818-5436'),(12,'Gottfried Roscamps','Male','2010-05-24','[email protected]',211231,'Delhi','54 Mesta Lane','608-53-0825','Othello Swinley','540-34-1770-5677'),(13,'Shaina Kleis','Female','2009-07-10','[email protected]',183221,'Goa','62 Warrior Point','238-19-4492','Mollee Hurran','425-68-2363-8767'),(14,'Chuck Machon','Male','2008-09-14','[email protected]',211231,'Rajasthan','18 Jana Drive','851-83-7053','Fransisco Shevlin','899-40-8345-2343'),(15,'Gizela Hornbuckle','Female','2008-07-31','[email protected]',183221,'Bihar','38544 Kropf Circle','831-06-5552','Bari Lillo','289-15-3696-0984'),(16,'Lorene Peracco','Female','2010-08-22','[email protected]',211231,'Punjab','176 Sugar Point','875-05-3134','Johna Chawkley','595-20-3079-4573'),(17,'Alyda Melarkey','Female','2008-04-17','[email protected]',668162,'Delhi','28 Lindbergh Park','620-05-0734','Dian Vedeneev','285-85-6875-7654'),(18,'Herbie Devereux','Male','2008-06-18','[email protected]',183221,'M.P','97 Ludington Plaza','407-85-2425','Titus Deavall','603-29-4704-6785'),(19,'Chrissie Lovie','Female','2008-07-10','[email protected]',668162,'Goa','77198 Leroy Place','586-01-4092','Marisa Zanioletti','411-64-68879839'),(20,'Barron Yeeles','Male','2009-09-08','[email protected]',183221,'Bihar','27 Victoria Trail','429-58-1364','Khalil Camosso','480-12-8977-6483'),(21,'Steffi Kohrding','Female','2009-03-19','[email protected]',668162,'U.p','028 Namekagon Junction','298-76-2717','Adelaide Biers','599-45-9494-6583'),(22,'Maure Woolfenden','Female','2010-06-28','[email protected]',211231,'M.P','48 Briar Crest Court','754-86-5213','Oralia Mytton','657-57-7737-6758'),(23,'Mattie Boshier','Male','2008-08-15','[email protected]',679130,'Delhi','2 Melrose Road','183-14-4042','Lesley Thouless','377-50-0098-6833'),(24,'Tedd Harsnep','Male','2010-11-02','[email protected]',443929,'Bihar','7 Montana Crossing','895-53-9748','Arney Staves','707-05-9616-4683'),(25,'Wanda Sainte Paul','Female','2010-11-07','[email protected]',211231,'Goa','736 Northport Circle','203-69-2256','Eleanore Sivyour','339-80-5810-5638'),(26,'Concettina Oxenford','Female','2008-04-13','[email protected]',359120,'M.P','0521 Spenser Alley','200-91-1046','Atalanta Stiell','335-58-4089-4678'),(27,'Rozanna Sultan','Female','2009-12-05','[email protected]',443929,'Goa','224 Ridgeway Lane','125-70-7072','Missy Baudains','302-99-2639-4332'),(28,'Melody Wethered','Female','2009-01-14','[email protected]',359120,'Rajasthan','4891 Dapin Alley','785-29-7374','Gustie Houdmont','615-49-0470-3425'),(29,'Gian Nortunen','Male','2008-11-25','[email protected]',359120,'Goa','70207 Dennis Park','741-53-8424','Price Blondelle','171-33-9640-4325'),(30,'Scotty Heavy','Male','2010-07-09','[email protected]',443929,'U.p','13781 Summerview Way','210-38-4985','Horacio Brosnan','244-47-0039-4325'),(31,'Barbra Wix','Female','2008-03-01','[email protected]',359120,'Goa','82 Stephen Pass','459-71-4665','Sandy McOwen','129-87-3788-2748'),(32,'Erick Timberlake','Male','2010-12-19','[email protected]',211231,'M.P','1 Lindbergh Road','309-05-6533','Say Peacock','380-80-6305-4673'),(33,'Winnie Scough','Female','2008-03-29','[email protected]',211231,'Goa','8 Bartillon Drive','154-47-2473','Antonietta Valencia','270-17-3634-4672'),(34,'Britta Sambrok','Female','2010-05-24','[email protected]',434345,'U.p','3 Old Gate Place','460-22-2360','Jilly Rubenczyk','204-04-6623-5271'),(35,'Rogers Emma','Male','2009-12-18','[email protected]',443929,'Rajasthan','59074 Brickson Park Park','475-08-9037','Alphard Peizer','246-19-9960-6483'),(36,'Adena Schiefersten','Female','2009-07-18','[email protected]',183221,'U.p','6119 Riverside Lane','217-04-4796','Elaine Donlon','252-61-0259-4672'),(37,'Shela Mingotti','Female','2009-05-20','[email protected]',359120,'Rajasthan','43 Darwin Crossing','299-99-0184','Stormy Dunhill','385-55-8240-4672'),(38,'Junette Jeanequin','Female','2010-10-31','[email protected]',183221,'M.P','4 Dryden Pass','536-17-7912','Brooke Braams','700-04-2712-1132'),(39,'Hannis Sex','Female','2011-02-03','[email protected]',183221,'Goa','85561 Stephen Way','755-23-6334','Nessie Starcks','747-48-8405-4733'),(40,'Erika Ubee','Female','2010-07-23','[email protected]',211231,'U.p','048 Main Court','648-97-0490','Trescha Farren','659-85-4300-3473'),(41,'Lynn Formigli','Male','2010-02-19','[email protected]',183221,'Punjab','69233 Calypso Plaza','375-04-2480','Hymie Fenny','238-60-7491-4874'),(42,'Waylen Liggett','Male','2009-06-30','[email protected]',359120,'Rajasthan','44 Killdeer Road','267-73-2060','Kellby O\'dell','863-07-1966-4376'),(43,'Ignacio Greenwell','Male','2010-12-23','[email protected]',183221,'Bihar','41608 Sherman Place','142-75-5587','Ernesto Phethean','364-19-4852-3433'),(44,'Noel O\'Donovan','Male','2009-01-05','[email protected]',183221,'Goa','27074 Fair Oaks Hill','147-18-8047','Guilbert Dolle','862-06-9102-3443'),(45,'Brock Yeskin','Male','2008-09-01','[email protected]',359120,'Punjab','1 Crowley Parkway','496-05-4938','Rubin Peddel','150-86-4353-3632'),(46,'Sutherlan Briddle','Male','2010-05-30','[email protected]',211231,'Bihar','679 Ludington Lane','275-88-8210','Vinson Dudek','273-81-2463-2323'),(47,'Arlette Dorward','Female','2010-04-04','[email protected]',183221,'Goa','1392 Fisk Lane','241-58-8124','Esme Buard','639-34-5522-4763'),(48,'Aeriel Gerler','Female','2010-12-08','[email protected]',443929,'Punjab','6 Old Shore Place','152-58-6846','Lindsey Gartin','334-78-2591-3434'),(49,'Bernetta Akett','Female','2009-09-03','[email protected]',211231,'M.P','9659 Graedel Junction','235-70-2786','Kellyann Red','598-60-4710-3643'),(50,'Earle Rugg','Male','2009-02-09','[email protected]',359120,'Rajasthan','716 Cherokee Junction','502-57-7606','Tremaine Tregale','322-56-7812-4743'),(51,'Cody Rangle','Male','2009-10-20','[email protected]',183221,'U.p','3 Eagan Avenue','224-85-2839','Boyd Leinster','444-93-7450-3333'),(52,'Steffen Hawke','Male','2008-04-19','[email protected]',601294,'Goa','1116 Fordem Parkway','162-46-0887','Abdel Dudleston','452-57-9749-0987'),(53,'Florinda Jeffels','Female','2009-06-04','[email protected]',307351,'Punjab','18 Delladonna Point','502-25-2292','Valaria Gostling','449-44-3386-6437'),(54,'Siffre Borham','Male','2010-03-04','[email protected]',601294,'Rajasthan','55113 Manley Road','719-04-5529','Dani Sedge','598-18-9321-4673'),(55,'Dave Budden','Male','2009-05-24','[email protected]',211231,'Bihar','6256 Hudson Terrace','345-40-8665','Ingram Adamolli','164-95-2188-4683'),(56,'Fay Blundell','Female','2010-01-27','[email protected]',359120,'Punjab','62 Heath Place','575-53-7321','Theodora Byart','509-80-9843-4738'),(57,'Weston Dungey','Male','2009-03-17','[email protected]',359120,'Goa','48 Lunder Pass','867-51-7479','Odey Clews','395-51-0915-7847'),(58,'Florry Pimlott','Female','2010-03-20','[email protected]',183221,'Punjab','05 Packers Junction','142-61-9598','Leonore Saundercock','181-42-7392-8873'),(59,'Harlin Rickcord','Male','2008-12-19','[email protected]',601294,'U.p','18 Kings Hill','811-57-0945','Alf Titman','243-47-8026-8784'),(60,'Zed Crowest','Male','2009-03-26','[email protected]',211231,'Rajasthan','566 Meadow Ridge Trail','621-98-5019','Currey Denkel','703-28-9884-6473'),(61,'Byram Edgson','Male','2010-06-20','[email protected]',359120,'Rajasthan','392 Old Gate Alley','649-72-9362','Corrie Schenfisch','162-38-1113-4734'),(62,'Benny Phalp','Male','2009-02-20','[email protected]',183221,'Bihar','80067 Ilene Terrace','242-68-9076','Clare Bocock','272-70-8713-7438'),(63,'Bethina Boarer','Female','2008-04-13','[email protected]',601294,'Punjab','62 Lake View Parkway','211-98-8265','Aggi Lyness','468-80-4770-8438'),(64,'Addia Moiser','Female','2008-12-01','[email protected]',359120,'Goa','0841 Westport Avenue','509-89-4518','Dianemarie Niblett','809-21-3463-7483'),(65,'Alaster Merveille','Male','2009-05-21','[email protected]',601294,'Bihar','63 Anniversary Way','129-07-9205','Peter Truss','118-57-1527-6487'),(66,'Lainey Mayhead','Female','2009-09-03','[email protected]',183221,'Goa','606 Ronald Regan Hill','333-31-4546','Benedetta Wordsley','773-84-1221-6743'),(67,'Bondon Aynsley','Male','2010-11-30','[email protected]',601294,'Punjab','73 Dixon Circle','168-80-2654','Somerset Dinnage','127-47-1793-7438'),(68,'Roshelle Thomel','Female','2008-08-27','[email protected]',183221,'Delhi','0998 Duke Plaza','143-85-6170','Catina Claessens','761-47-4998-4673'),(69,'Nolan Hubbold','Male','2010-01-04','[email protected]',601294,'U.p','32 Summer Ridge Plaza','642-52-3379','Clive Wrassell','311-66-5609-7478'),(70,'Katusha Weatherby','Female','2009-02-03','[email protected]',359120,'U.p','4 Melody Street','791-63-5415','Ianthe Lorimer','186-50-1193-4673'),(71,'Riva Clibbery','Female','2009-01-22','[email protected]',183221,'Punjab','7488 Chive Road','341-31-3073','Gussy Gavahan','648-82-1537-3783'),(72,'Ludovico Yepiskopov','Male','2009-08-28','[email protected]',161560,'U.p','6408 Heffernan Place','861-85-4787','Blake Dunston','830-79-1095-7833'),(73,'Tan Dunabie','Male','2009-01-29','[email protected]',28410,'Bihar','02 Hoepker Park','641-16-2246','Salomo Merrell','862-54-6581-7833'),(74,'Frederico Haensel','Male','2010-10-23','[email protected]',359120,'Rajasthan','779 Michigan Point','884-28-1101','Frederic Badam','590-33-8105-7833'),(75,'Pauly Grief','Male','2010-10-30','[email protected]',473008,'Punjab','64455 Cardinal Lane','202-11-2520','Gibb Heliet','420-82-2982-7833'),(76,'Shana Digginson','Female','2010-04-01','[email protected]',601294,'Bihar','9 Darwin Junction','759-38-3893','Yolanthe Murrish','460-77-5861-7833'),(77,'Abbey Feldbaum','Female','2010-11-08','[email protected]',601294,'Punjab','3656 Clemons Parkway','211-65-5364','Dido Offen','518-62-5144-7833'),(78,'Etheline Lamke','Female','2010-04-05','[email protected]',211231,'Delhi','030 Forest Dale Alley','705-10-1666','Mavis Queen','290-69-9750-7833'),(79,'Gwenni Furst','Female','2008-11-01','[email protected]',211231,'Rajasthan','5 Delladonna Junction','855-04-9501','Winni Charlewood','632-31-9720-7833'),(80,'Judye Lanfere','Female','2009-09-14','[email protected]',601294,'Goa','47 Hooker Center','574-14-1478','Jorrie Wimlet','670-68-8873-4683'),(81,'Silvano Leemans','Male','2009-01-24','[email protected]',443929,'Punjab','389 Sherman Crossing','540-59-6979','Durward Eberts','444-40-6708-4683'),(82,'Alanah Braben','Female','2009-09-30','[email protected]',601294,'Rajasthan','063 Brentwood Place','770-06-1688','Tina Briggs','137-40-9494-4683'),(83,'Julietta Denisevich','Female','2009-12-02','[email protected]',601294,'Delhi','202 Nobel Drive','278-50-3457','Darlleen McTear','103-48-0217-4683'),(84,'Royall Oldam','Male','2008-08-22','[email protected]',601294,'U.p','78245 Sunnyside Pass','844-12-6401','Derry Williscroft','741-32-0661-4683'),(85,'Redd Duffit','Male','2009-08-30','[email protected]',232313,'U.p','07 Doe Crossing Avenue','814-47-9464','Archambault Vassar','615-27-8981-4683'),(86,'Eduardo Kirwood','Male','2010-09-18','[email protected]',987321,'Goa','4297 Rowland Trail','660-31-5108','Garik Northley','292-07-3086-4683'),(87,'Ora Fane','Female','2009-08-05','[email protected]',359120,'Bihar','4391 Duke Terrace','166-40-2594','Gabriella Attwater','303-95-4384-4683'),(88,'Corby Crimes','Male','2011-01-18','[email protected]',359120,'Bihar','30020 Myrtle Alley','827-71-3987','Burty Sykes','832-33-6850-4683'),(89,'Temple Hush','Male','2010-07-18','[email protected]',323213,'Rajasthan','28 Michigan Drive','176-23-6783','Magnum Strike','710-80-1826-4683'),(90,'Kaiser Samms','Male','2008-04-07','[email protected]',182313,'Punjab','6127 Mallard Crossing','256-63-5087','Scottie Massow','746-12-4089-4683'),(91,'Archibaldo Kaindl','Male','2009-06-03','[email protected]',601294,'Delhi','0695 Pepper Wood Park','302-74-4853','Torre Foley','304-29-5062-4683'),(92,'Cathrin Broyd','Female','2008-04-30','[email protected]',231121,'U.p','699 Sundown Street','261-96-7335','Perle Coughan','796-66-5431-4683'),(93,'Carolyn McCaighey','Female','2010-07-16','[email protected]',601294,'Bihar','30787 Green Ridge Place','855-47-9206','Ann-marie Lambricht','319-78-7176-4683'),(94,'Erika Forsbey','Female','2009-02-24','[email protected]',601221,'Delhi','75118 Scoville Terrace','761-30-5389','Marys Pigney','503-06-3596-4683'),(95,'Emili Le Provost','Female','2010-06-23','[email protected]',213213,'U.p','1985 Del Mar Way','777-32-1840','Nonnah Hairsine','255-51-7142-4683'),(96,'Clemmie Minghella','Female','2010-07-04','[email protected]',601294,'Goa','51 Rusk Road','165-15-7960','Giselle Duetsche','830-65-5468-4683'),(97,'Kris Crang','Male','2011-01-24','[email protected]',213421,'Bihar','2 Spenser Plaza','830-21-7847','Fielding Risdale','570-75-4785-4683'),(98,'Leeland Blackbrough','Male','2008-07-19','[email protected]',120392,'Goa','183 Homewood Crossing','778-02-2161','Udell Makin','127-78-4371-4683'),(99,'Ronni Yaneev','Female','2010-08-09','[email protected]',220012,'Delhi','19 Armistice Alley','460-58-9105','Beverie Frizzell','680-74-0975-4683'),(100,'Ruthi Woodruffe','Female','2010-08-11','[email protected]',443929,'Punjab','5 Monterey Road','575-79-7564','Elita Giggs','896-75-2791-4683'),(101,'Horatio Allibone','Male','2008-09-07','[email protected]',211231,'U.p','1 Sherman Hill','620-81-0627','Tynan Lacaze','792-76-0016-4683'),(102,'Shannah Haythorne','Female','2011-01-27','[email protected]',323213,'Bihar','091 Longview Street','305-46-9200','Jorrie Cowley','188-38-8398-4683'),(103,'Zabrina Henrych','Female','2010-07-22','[email protected]',444632,'Goa','37 Debs Plaza','586-77-5255','Corie Erbe','633-87-9471-4683'),(104,'Ninette Balnaves','Female','2008-10-16','[email protected]',188532,'Delhi','8 Susan Street','304-28-8240','Jennee Heinssen','695-95-4206-4683'),(105,'Ilene Impey','Female','2010-12-12','[email protected]',323234,'U.p','9417 Ruskin Point','112-82-8841','Vitia Chable','434-26-1687-4683'),(106,'Welbie Abella','Male','2011-01-22','[email protected]',222114,'Delhi','10 Delladonna Plaza','388-01-2866','Gabie Chasmoor','100-77-4179-4683'),(107,'Caron Pablo','Female','2011-01-26','[email protected]',183221,'Bihar','661 Granby Circle','313-19-2858','Ingeborg Axelbee','626-79-5655-4683'),(110,'Vasu Goel','Male','1999-04-06','[email protected]',110088,NULL,NULL,'9711154348',NULL,NULL),(111,'Vasu Goel','Male','1999-04-06','[email protected]',110088,NULL,NULL,'9711154348',NULL,NULL),(112,'Vasu Goel','Male','1999-04-06','[email protected]',110088,NULL,NULL,'9711154348',NULL,NULL),(113,'Sargam','Female','2020-03-16','[email protected]',123123,NULL,NULL,'1321312313',NULL,NULL);
/*!40000 ALTER TABLE `users` 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 2020-04-25 19:40:06