-
Notifications
You must be signed in to change notification settings - Fork 0
/
Database.sql
50 lines (43 loc) · 16.1 KB
/
Database.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
-- MySQL dump 10.13 Distrib 8.0.22, for macos10.15 (x86_64)
--
-- Host: localhost Database: tweet
-- ------------------------------------------------------
-- Server version 8.0.22
/*!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 `poo`
--
DROP TABLE IF EXISTS `poo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `poo` (
`text` varchar(500) DEFAULT NULL,
`phone` bigint unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `poo`
--
LOCK TABLES `poo` WRITE;
/*!40000 ALTER TABLE `poo` DISABLE KEYS */;
INSERT INTO `poo` VALUES ('#Delhi\nNeed #Blood Type : A-negative\nAt : Lions blood bank, Shalimar Bagh\nBlood Component : Blood\nNumber of Units : 2\nPrimary Number : 9818696864\nVia: \n@viragthakkar\n#BloodMatters\nPowered by Twitter',9818696864),('#Trichy\nNeed #Blood Type : B-positive\nAt : Indira Sheshadri Nursing Home\nBlood Component : Need Plasma B+ve from #Covid19 recovered patient\nNumber of Units : 2\nPrimary Number : 9902041850\nVia: \n@vijayandrewsj\n#BloodMatters\nPowered by Twitter',9902041850),('#Delhi\nNeed #Blood Type : Any group\nAt : BLK\nBlood Component : Need Blood any group\nNumber of Units : 20\nPrimary Number : 8951281148\nSecondary Number : 9899819205\nVia: \n@AggaAlka\n#BloodMatters\nPowered by Twitter',8951281148),('#Delhi\nNeed #Blood Type : A-positive\nAt : Sir Gangaram\nNumber of Units : 8\nPrimary Number : 7903024225\nVia: \n@raktnssdtu\n#BloodMatters\nPowered by Twitter',7903024225),('#Srinagar\nNeed #Blood Type : B-negative\nAt : JVC \nNumber of Units : 2\nPrimary Number : 9797929814\nSecondary Number : 9682562845\nVia: \n@listenUmair\n#BloodMatters\nPowered by Twitter',9797929814),('#Vizag\nNeed #Blood Type : O-positive\nAt : Seven Hills\nBlood Component : Need Bombay Blood O+ve\nNumber of Units : 2\nPrimary Number : 9398627876\nVia: \n@KalyanChakrawa1\n#BloodMatters\nPowered by Twitter',9398627876),('#Delhi\nNeed #Blood Type : A-positive\nAt : Tirath Ram Shah\nBlood Component : Need Blood A+ve\nNumber of Units : 2\nPrimary Number : 9910049903\nVia: \n@BloodDonorsIn\n#BloodMatters\nPowered by Twitter',9910049903),('#Baramulla\nNeed #Blood Type : B-positive\nAt : GMC\nBlood Component : Blood\nNumber of Units : 2\nPrimary Number : 8825009415\nSecondary Number : 9622868185\nVia: \n@IamShamsAalam\n#BloodMatters\nPowered by Twitter',8825009415),('#Hyderabad\nNeed #Blood Type : Any group\nAt : Nice Hospital\nNumber of Units : 2\nPrimary Number : 8197396131 \nVia: \n@VemulaRaazu\n#BloodMatters\nPowered by Twitter',8197396131),('#Varanasi\nNeed #Blood Type : A-positive\nAt : Sir Sunderlal\nBlood Component : Need Blood A+ve\nNumber of Units : 1\nPrimary Number : 9019460346\nVia: \n@ArushGzp\n#BloodMatters\nPowered by Twitter',9019460346),('#Patna\nNeed #Blood Type : O-negative\nAt : AIIMS\nBlood Component : Need Blood O-ve\nNumber of Units : 1\nPrimary Number : 9789521029\nSecondary Number : 8431641185\nVia: \n@farhaan_tweets\n#BloodMatters\nPowered by Twitter',9789521029),('#Hyderabad\nNeed #Blood Type : B-positive\nAt : Citizens speciality hospital \nBlood Component : Platelets\nNumber of Units : 2\nPrimary Number : 9492027501\nSecondary Number : 8333024808\nVia: \n@Ahmed85482534\n#BloodMatters\nPowered by Twitter',9492027501),('#Delhi\nNeed #Blood Type : A-positive\nAt : gangaram hospital\nNumber of Units : 2\nPrimary Number : 7903024225\nPatient : Ranvir Kumar\nVia: \n@howbza\n#BloodMatters\nPowered by Twitter',7903024225),('#Sangareddy\nNeed #Blood Type : A-negative\nAt : Balaji\nBlood Component : Need A-ve blood\nNumber of Units : 2\nPrimary Number : 9014223534\nVia: \n@wildthings666\n#BloodMatters\nPowered by Twitter',9014223534),('#Guntur\nNeed #Blood Type : A-positive\nAt : Ramesh\nBlood Component : Need B+ve group blood - heart surgery\nNumber of Units : 2\nPrimary Number : 8074955319\nVia: \n@iug1111\n#BloodMatters\nPowered by Twitter',8074955319),('#Bangalore\nNeed #Blood Type : Any group\nAt : Narayana Hrudyalaya\nNumber of Units : 10\nPrimary Number : 7892158964\nVia: \n@Anjigunda999\n#BloodMatters\nPowered by Twitter',7892158964),('#Bareilly\nNeed #Blood Type : B-positive\nAt : Shri Siddhivinayak \nBlood Component : Need Blood B+ve\nNumber of Units : 2\nPrimary Number : 8445434846\nVia: \n@Nish_ant_1\n#BloodMatters\nPowered by Twitter',8445434846),('#Delhi\nNeed #Blood Type : B-negative\nAt : Rajiv Gandhi Cancer\nBlood Component : Need Blood B-ve\nNumber of Units : 2\nPrimary Number : 9781800034\nVia: \n@Drx_Dskhalsa96\n#BloodMatters\nPowered by Twitter',9781800034),('#Delhi\nNeed #Blood Type : A-positive\nAt : National Heart Institute\nBlood Component : Need A+ve blood donor\nNumber of Units : 2\nPrimary Number : 9873550250\nVia: \n@rajeshkalra\n#BloodMatters\nPowered by Twitter',9873550250),('#Varanasi\nNeed #Blood Type : O-positive\nAt : Mahatma Cancer Center\nNumber of Units : 2\nPrimary Number : 7394852086\nSecondary Number : 6204729089\nIllness : NA\nVia: \n@bekaartweet\n#BloodMatters\nPowered by Twitter',7394852086),('#Mumbai\nNeed #Blood Type : Any group\nAt : Kokilaben\nPrimary Number : 8451947122\nVia: \n@DeepakLevaousa\n#BloodMatters\nPowered by Twitter',8451947122),('#Rewa\nNeed #Blood Type : O-negative\nAt : SMGH\nNumber of Units : 2\nPrimary Number : 8920375278\nVia: \n@Amitshu92418495\n#BloodMatters\nPowered by Twitter',8920375278),('#Guntur\nNeed #Blood Type : A-positive\nAt : Ramesh\nBlood Component : Need Blood B+ve\nNumber of Units : 2\nPrimary Number : 8074955319\nVia: \n@iug1111\n#BloodMatters\nPowered by Twitter',8074955319),('#Hyderabad\nNeed #Blood Type : AB-positive\nAt : Star, Banjara Hills\nBlood Component : Need Blood AB+ve\nNumber of Units : 2\nPrimary Number : 7799271986\nSecondary Number : 8074882658\nVia: \n@CovidCareByRCF\n#BloodMatters\nPowered by Twitter',7799271986),('#Delhi\nNeed #Blood Type : A-positive\nAt : Dr. Baba Saheb Ambedkar, Rohini\nNumber of Units : 4\nPrimary Number : 9582411972\nSecondary Number : 9818238769\nVia: \n@Sohan4BJP\n#BloodMatters\nPowered by Twitter',9582411972),('#Varanasi\nNeed #Blood Type : O-positive\nAt : Mahamana Cancer Centre\nNumber of Units : 5\nPrimary Number : 7394852086\nSecondary Number : 6204729089\nVia: \n@OmKrishnaPatha1\n#BloodMatters\nPowered by Twitter',7394852086),('#Chennai\nNeed #Blood Type : Any group\nAt : Kamatchi \nBlood Component : Need any group blood\nNumber of Units : 5\nPrimary Number : 9791010646\nIllness : ]\nVia: \n@rvsiva17\n#BloodMatters\nPowered by Twitter',9791010646),('#Delhi\nNeed #Blood Type : B-negative\nAt : Max Superspecialty BLK\nBlood Component : Need blood from O-ve or B-ve donor\nNumber of Units : 1\nPrimary Number : 9717794046\nIllness : Critical surgery\nVia: \n@Hitu9479Hitesh\n#BloodMatters\nPowered by Twitter',9717794046),('#SOS\n#Chandigarh\nNeed #Blood Type : O-positive\nAt : PGI\nBlood Component : Need Blood O+ve\nNumber of Units : 2\nPrimary Number : 7289852154\nVia: \n@LivesMatters_\n#BloodMatters\nPowered by Twitter',7289852154),('#Delhi\nNeed #Blood Type : B-negative\nAt : Max Superspecialty BLK\nBlood Component : Need Blood O-ve or B-ve\nNumber of Units : 1\nPrimary Number : 9717794046\nVia: \n@Hitu9479Hitesh\n#BloodMatters\nPowered by Twitter',9717794046),('#Delhi\nNeed #Blood Type : B-positive\nAt : Indian Red Cross Society\nBlood Component : Blood\nNumber of Units : 2\nPrimary Number : 9891411643\nIllness : Thalassemia\nVia: \n@prernakaul\n#BloodMatters\nPowered by Twitter',9891411643),('#Hyderabad\nNeed #Blood Type : B-positive\nAt : Kamineni Hospitals\nBlood Component : Need B+ve blood donor\nNumber of Units : 1\nPrimary Number : 7680042180\nVia: \n@Need4CovSupport\n#BloodMatters\nPowered by Twitter',7680042180),('#Kolkata\nNeed #Blood Type : O-negative\nAt : JagannathGupta Instt, BudgeBudge\nNumber of Units : 2\nPrimary Number : 9831079754\nSecondary Number : 8478920923\nVia: \n@SHCSpeak\n#BloodMatters\nPowered by Twitter',9831079754),('#Patna\nNeed #Blood Type : Any group\nAt : Ruban\nNumber of Units : 10\nPrimary Number : 6202931664\nVia: \n@humourasf\n#BloodMatters\nPowered by Twitter',6202931664),('#Hyderabad\nNeed #Blood Type : A-negative\nAt : Citizen\nBlood Component : Need A-ve group blood\nNumber of Units : 2\nPrimary Number : 8247802856\nVia: \n@wildthings666\n#BloodMatters\nPowered by Twitter',8247802856),('#Gurugram\nNeed #Blood Type : A-positive\nAt : Fortis \nBlood Component : Need Platelet A+ve\nNumber of Units : 2\nPrimary Number : 9119309554\nVia: \n@LivesMatters_\n#BloodMatters\nPowered by Twitter',9119309554),('#Delhi\nNeed #Blood Type : B-positive\nAt : Lady Hardinge\nBlood Component : Need Blood B+ve\nNumber of Units : 5\nPrimary Number : 8825264985\nVia: \n@ASHUTOSHSHANK17\n#BloodMatters\nPowered by Twitter',8825264985),('#Delhi\nNeed #Blood Type : AB-positive\nAt : National Heart Institute\nBlood Component : Need Platelets AB+ve\nNumber of Units : 2\nPrimary Number : 9811446991\nVia: \n@vansh_0104\n#BloodMatters\nPowered by Twitter',9811446991),('#Delhi\nNeed #Blood Type : A-positive\nAt : Max Saket\nBlood Component : Need Blood A+ve\nNumber of Units : 6\nPrimary Number : 9845058228\nVia: \n@MohdAhtishamAh1\n#BloodMatters\nPowered by Twitter',9845058228),('#Secunderabad\nNeed #Blood Type : O-positive\nAt : KIMS\nBlood Component : Need O+ve blood\nNumber of Units : 2\nPrimary Number : 9581161789\nVia: \n@Srikanth_Sanga\n#BloodMatters\nPowered by Twitter',9581161789),('FARIDABAD!\n\nPatient: Kshitij Jain (Sarvodaya Hospital Faridabad)\nContact: Navin Jain 9818381364/ \nMansi Jain 8447441358\nRequirement: ECMO bed urgently',9818381364),('#Mohali\nNeed #Blood Type : B-negative\nAt : Gracian\nBlood Component : Need Platelets B-ve\nNumber of Units : 2\nPrimary Number : 9501009248\nVia: \n@paramprreet\n#BloodMatters\nPowered by Twitter',9501009248),('#Delhi\nNeed #Blood Type : A-positive\nAt : AIIMS Trauma Centre\nBlood Component : Need Blood A+ve\nNumber of Units : 2\nPrimary Number : 9968954551\nVia: \n@BloodDonorsIn\n#BloodMatters\nPowered by Twitter',9968954551),('Urgently need donor for B + Blood Platelets at Metro Hospital , Noida \n\nPlease Contact Shivam Agarwal 7503463328',7503463328),('#Kolkata #May24\nNeed AB+ve Blood donors\nAt AMRI Hospital\nCall 7381147123\nvia \n@BloodMattersorg\n cc \n@TweetKolkata\n #iCanSaveLife #BloodMatters',7381147123),('#Chandigarh\nNeed #Blood Type : O-positive\nAt : PGI\nBlood Component : Need Blood O+ve\nNumber of Units : 2\nPrimary Number : 7289852154\nVia: \n@LivesMatters_\n#BloodMatters\nPowered by Twitter',7289852154),('#Hyderabad\nNeed #Blood Type : B-positive\nAt : Apollo , Jubilee hills\nBlood Component : Platelets\nNumber of Units : 2\nPrimary Number : 9030536591\nSecondary Number : 9704153151\nVia: \n@NMadanG\n#BloodMatters\nPowered by Twitter',9030536591),('#SOS #Gurgaon #AmphotericinB injection needed for 89 year old man \n\nPatient: Krishan LAL Sethi\nDiagnosed for Black Fungus \nCaretaker : Gautam Sethi\nHospital: Paras Hospital, C-1 Sushant Lok-1, Gurgaon\nContact no:9811086760\n \nPls help \n@srinivasiyc\n @AdityaRajKaul\n @bainjal\n @TellDM',9811086760),('Patient Name- Narayan Agarwal, 30, Male\n\nHospital- KMCH, Coimbatore\n\nBlood group - B+ve\n\nRequirement- *B+ve Blood for STP*\nHealthy Male Donor\nShould not be vaccinated in last 10 day\nShould not have contracted covid in last 3 months\n\nCity- Coimbatore\nContact- 09360606090',9360606090),('#Panchkula\nNeed #Blood Type : B-positive\nAt : Paras\nBlood Component : Need Blood B+ve\nNumber of Units : 2\nPrimary Number : 9646072207\nVia: \n@NgoTammana\n#BloodMatters\nPowered by Twitter',9646072207),('#Kakinada\nNeed #Blood Type : AB-positive\nAt : TRUST\nBlood Component : Need AB+ve plasma from #Covid19 recovered patient\nNumber of Units : 2\nPrimary Number : 7829466876\nVia: \n@wildthings666\n#BloodMatters\nPowered by Twitter',7829466876),('#Jammu\nNeed #Blood Type : B-positive\nAt : GMC\nBlood Component : Need Blood B+ve\nNumber of Units : 2\nPrimary Number : 9419201786\nSecondary Number : 9419221399\nVia: \n@mohjo_007\n#BloodMatters\nPowered by Twitter',9419201786),('#Delhi\nNeed #Blood Type : O-positive\nAt : PSRI\nNumber of Units : 2\nPrimary Number : 7087231290\nVia: \n@Pratibh99386572\n#BloodMatters\nPowered by Twitter',7087231290),('#Karimnagar\nNeed #Blood Type : O-positive\nAt : Sri Deepika\nBlood Component : Need O+ve plasma from covid recovered patient\nNumber of Units : 2\nPrimary Number : 9398477741\nVia: \n@GayathriBandar7\n#BloodMatters\nPowered by Twitter',9398477741),('#Secunderabad #May24\nNeed A+ve Blood donors\nAt Sunshine Hospital\nCall 8142090987\nvia \n@hbdsofficial\n cc \n@JahnaviPabba\n #iCanSaveLife #BloodMatters',8142090987),('#Panchkula\nNeed #Blood Type : B-positive\nAt : Paras\nBlood Component : Need Blood B+ve\nNumber of Units : 2\nPrimary Number : 9419184346\nSecondary Number : 7006056332\nVia: \n@Abhinav14061991\n#BloodMatters\nPowered by Twitter',9419184346),('#Delhi\nNeed #Blood Type : B-positive\nAt : AIIMS \nBlood Component : Need Blood B+ve and RDB platelets\nNumber of Units : 2\nPrimary Number : 8863920919\nVia: \n@KhannaShyamlee\n#BloodMatters\nPowered by Twitter',8863920919),('#Chennai\nNeed #Blood Type : AB-negative\nAt : MMM\nBlood Component : Need Blood AB-ve\nNumber of Units : 6\nPrimary Number : 9790389214\nSecondary Number : 7373150100\nVia: \n@arunrajmohan95\n#BloodMatters\nPowered by Twitter',9790389214),('#Bhopal\nNeed #Blood Type : O-positive\nAt : Multi Care\nBlood Component : Need Blood O+ve\nNumber of Units : 2\nPrimary Number : 6263093523\nVia: \n@Prititarun\n#BloodMatters\nPowered by Twitter',6263093523),('#Darbhanga #May23\nNeed A+ve Blood donors\nAt DMCH Hospital\nCall 8910739760\nvia \n@iamshamsaalam\n cc \n@jemin_p\n #iCanSaveLife #BloodMatters',8910739760),('#Delhi #May24\nNeed A+ve Blood donors\nAt Max Saket Hospital\nCall 9845058228\nvia \n@mohdahtishamah1\n cc \n@WeAreNewDelhi\n #iCanSaveLife #BloodMatters',9845058228),('#Gurugram\nNeed #Blood Type : AB-positive\nAt : Metro Park\nBlood Component : Need Blood AB+ve\nNumber of Units : 2\nPrimary Number : 9990293908\nVia: \n@tarunuppaljk\n#BloodMatters\nPowered by Twitter',9990293908),('#Trichy\nNeed #Blood Type : B-positive\nAt : Indira Seshadri\nBlood Component : Need Plasma B+ve from #Covid19 recovered patient\nNumber of Units : 2\nPrimary Number : 9902041850\nVia: \n@ManiRajinikanth\n#BloodMatters\nPowered by Twitter',9902041850),('#Bengaluru #May23\nNeed Any group Blood donors\nAt Manipal Hospital\nCall 9880888438\nvia \n@nagma_morarji\n cc \n@WeAreBangalore\n #iCanSaveLife #BloodMatters',9880888438),('#Bhopal #May24\nNeed O+ve Blood donors\nAt Multi Care Hospital\nCall 6263093523\nvia \n@prititarun\n cc \n@ICJBhopal\n #iCanSaveLife #BloodMatters',6263093523),('#Hyderabad\nNeed #Blood Type : O-positive\nAt : Orchid, Karimnagar\nBlood Component : Need Plasma O+ve from #Covid19 recovered patient\nNumber of Units : 2\nPrimary Number : 9866010511\nSecondary Number : 8179328104\nVia: \n@Rajesh_V_V\n#BloodMatters\nPowered by Twitter',9866010511),('#Hyderabad #May24\nNeed B+ve Blood donors\nAt Kamineni Hospital\nCall 7680042180\nvia \n@need4covsupport\n cc \n@hashHyderabad\n #iCanSaveLife #BloodMatters',7680042180);
/*!40000 ALTER TABLE `poo` 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 2021-05-24 20:11:17