API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 12th, 2015
153
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 70.94 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.13 Distrib 5.6.24, for osx10.8 (x86_64)
  2. --
  3. -- Host: localhost Database: ecg
  4. -- ------------------------------------------------------
  5. -- Server version 5.6.24
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `centers`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `centers`;
  23. /*!40101 SET @saved_cs_client = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `centers` (
  26. `ID` int(11) NOT NULL AUTO_INCREMENT,
  27. `CenterID` varchar(255) NOT NULL,
  28. `CenterName` varchar(255) DEFAULT NULL,
  29. `DrName` varchar(255) DEFAULT NULL,
  30. `ContactNo` varchar(64) DEFAULT NULL,
  31. `SMSNumber` varchar(64) DEFAULT NULL,
  32. `BillingSMSNumber` varchar(50) NOT NULL,
  33. `Email` varchar(255) DEFAULT NULL,
  34. `Latitude` double DEFAULT NULL,
  35. `Longitude` double DEFAULT NULL,
  36. `Address1` varchar(50) DEFAULT NULL,
  37. `Address2` varchar(50) DEFAULT NULL,
  38. `Address3` varchar(50) DEFAULT NULL,
  39. `City` varchar(50) DEFAULT NULL,
  40. `State` varchar(50) DEFAULT NULL,
  41. `Country` varchar(50) DEFAULT NULL,
  42. `Pin` varchar(10) DEFAULT NULL,
  43. `RefDr1Name` varchar(255) DEFAULT NULL,
  44. `RefDr1Voice` varchar(15) DEFAULT NULL,
  45. `RefDr1SMS` varchar(15) DEFAULT NULL,
  46. `RefDr1Email` varchar(255) DEFAULT NULL,
  47. `RefDr2Name` varchar(255) DEFAULT NULL,
  48. `RefDr2Voice` varchar(15) DEFAULT NULL,
  49. `RefDr2SMS` varchar(15) DEFAULT NULL,
  50. `RefDr2Email` varchar(255) DEFAULT NULL,
  51. `RefDr3Name` varchar(255) DEFAULT NULL,
  52. `RefDr3Voice` varchar(15) DEFAULT NULL,
  53. `RefDr3SMS` varchar(15) DEFAULT NULL,
  54. `RefDr3Email` varchar(255) DEFAULT NULL,
  55. `RefDr4Name` varchar(255) DEFAULT NULL,
  56. `RefDr4Voice` varchar(15) DEFAULT NULL,
  57. `RefDr4SMS` varchar(15) DEFAULT NULL,
  58. `RefDr4Email` varchar(255) DEFAULT NULL,
  59. `RefDr5Name` varchar(255) DEFAULT NULL,
  60. `RefDr5Voice` varchar(15) DEFAULT NULL,
  61. `RefDr5SMS` varchar(15) DEFAULT NULL,
  62. `RefDr5Email` varchar(255) DEFAULT NULL,
  63. `Camp` int(11) NOT NULL DEFAULT '0',
  64. `CampDate` date NOT NULL,
  65. `Status` varchar(50) DEFAULT NULL,
  66. `Note` varchar(255) NOT NULL,
  67. `qbid` varchar(100) DEFAULT NULL,
  68. PRIMARY KEY (`ID`)
  69. ) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=latin1;
  70. /*!40101 SET character_set_client = @saved_cs_client */;
  71.  
  72. --
  73. -- Dumping data for table `centers`
  74. --
  75.  
  76. LOCK TABLES `centers` WRITE;
  77. /*!40000 ALTER TABLE `centers` DISABLE KEYS */;
  78. INSERT INTO `centers` VALUES (1,'1','Cardiac Center','Dr Charit','7259299699','7259299699','','abhinav@tricog.com',13.0129882,77.575959,'94/H, 9th Cross','Raj Mahal Vilas Extension',NULL,'Bangalore','Karnataka','India','560080','Dr Charit Bhograj','9663375833','9663375833','drcharit@gmail.com','Dr Abhijit Bhograj',NULL,'9663375833','drcharit@gmail.com','Dr B Ramana Rao',NULL,'9663375833','drcharit@gmail.com','Dr Ranga Nayak',NULL,'9663375833','drcharit@gmail.com','Dr Padmakumar',NULL,'9663375833','drcharit@gmail.com',0,'2015-01-01','ACTIVE','','61'),(11,'11','Joseph Medical Center','Dr Charit','7259299699','7259299699','','abhinav@tricog.com',NULL,NULL,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'0000-00-00','NEVER','','62'),(12,'12','Camp 25 Jan 2015',NULL,'7259299699','7259299699','','abhinav@tricog.com',NULL,NULL,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'0000-00-00',NULL,'',NULL),(13,'13','Demo','Dr Demo3','7259299699','7259299699','','abhinav@tricog.com',12.973056715419968,77.56155015869138,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'0000-00-00',NULL,'','63'),(14,'14','Saraswathi Polyclinic','Dr MuneGowda','7259299699','7259299699','9880609364,9980855371','abhinav@tricog.com',13.1000287,77.5959492,'1233, Hospital Road',NULL,'Yelahanka','Bangalore',NULL,NULL,'560064',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','ACTIVE','',NULL),(15,'15','Pooja 3D Hospital and Diabetes Centre','Dr Krishna Murthy','7259299699','7259299699','','abhinav@tricog.com',13.0060365,77.638689,NULL,'Banaswadi Main Road',NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','ACTIVE','',NULL),(16,'16','Sridevi Clinic and Diabetes Center','Dr Chandrashekar','7259299699','7259299699','9342811256','abhinav@tricog.com',13.0323335,77.5772352,'#23, 1st Main Road','Muneshwara Layout','Manorayanapalya','Bangalore',NULL,NULL,'560032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','ACTIVE','',NULL),(17,'17','Ideal Diabetes Center','Dr Santosh Kumar','7259299699','7259299699','','abhinav@tricog.com',13.0238784,77.6193824,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'0000-00-00','DEACT','',NULL),(18,'18','Uma Clinic','Dr Chikkanna','7259299699','7259299699','','abhinav@tricog.com',13.2491987,77.7116363,'Main Road, Devannahalli town','Opp Municipal Office','Devannahalli','Bangalore',NULL,NULL,'562110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','ACTIVE','',NULL),(19,'19','Athmeya Polyclinic and Diagnostic Center','Dr Somashekar','7259299699','7259299699','','abhinav@tricog.com',13.0067435,77.5568452,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','DEACT','',NULL),(20,'20','RK Hospital','Dr Keerthan Hegde','7259299699','7259299699','9945273599','abhinav@tricog.com',13.0116949,77.6316594,'31, Kammanahalli Main Rd',NULL,'Kacharakanahalli','Bangalore',NULL,NULL,'560084',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','ACTIVE','',NULL),(21,'21','Amruth Clinic','Dr Venkatesh','7259299699','7259299699','9845611856','abhinav@tricog.com',13.1023213500279,77.5955118612178,NULL,'Bazar Road','Yelahanka','Bangalore',NULL,NULL,'560064',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','ACTIVE','','67'),(22,'22','Hub','Dr Charit','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01',NULL,'',NULL),(23,'23','Patil Nursing Home','Dr B S Patil','7259299699','7259299699','9844064358,8050027172','abhinav@tricog.com',13.008956,77.696695,'No 42/B-1, Sri Thimmappa Complex','Old Madras Road','KR Puram','Bangalore','KA','In','560036',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-01-01','ACTIVE','',NULL),(24,'24','Joshi Hospital-Camp','Dr.K.V.Joshi','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'#57,58 & 59, Sirsi Road,Near Sirsi Circle,','(Mysore road circle), ','Chamarajpet,','Bangalore','KA','IN','560018',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-03-18',NULL,'',NULL),(25,'25','Shri Jain Lab Camp','Dr.T.S.Somasheker','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'#222. 3rd Main ','next to food world','Chamarajpet,','Bangalore','KA','IN','5600018','Dr. T.S.Somashekar',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-03-25',NULL,'',NULL),(26,'26','Devannahalli camp','Dr Chikkanna','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Devannahalli',NULL,NULL,'Bangalore','KA','IN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-03-28',NULL,'',NULL),(27,'27','Dr Indresh Preethi NH Camp-','Dr Indresh','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'padarayanapura, ','mysore road,',NULL,'Bangalore','KA','IN','5600026','Dr Indresh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-02',NULL,'',NULL),(28,'28','New Gardencity Clinic Camp','Dr Md.Afroz','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,NULL,'Bangalore','KA','IN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-08',NULL,'',NULL),(29,'29','Shree Vinayaka Polyclinic & Prashanth Diagnostics. Camp','Dr SN Mohan','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No: 8/45,80 feet road,','SBM Colony','BSK 1st stage','Bangalore','KA','IN','560050',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-09',NULL,'',NULL),(30,'30','Sri Lakshmi Venkateshwara Clinic Camp','Dr CS Nagaraju','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'87, First floor,','BEML Main Road, GM Palya,',' C V Raman Nagar,','Bangalore','KA','IN','560075',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-13',NULL,'',NULL),(31,'31','City Health Clinic Camp','Dr Jnayaneshwar','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,'Ganagondanahalli','Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-12',NULL,'',NULL),(33,'33','Venkateshwara Clinic Camp','Dr Venkatesh S','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,'Kuruburahalli','Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-15',NULL,'',NULL),(34,'34','Anugraha Multi Speciality Center Camp','Dr Praveen Kumar','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No:313, 2nd Main Road, Kenchapura,',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-14',NULL,'',NULL),(35,'35','Guru Clinic Camp','Dr Gurudev S','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Yelahanka Old Town',NULL,NULL,'bangalore','KA','IN','560064',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-16',NULL,'',NULL),(36,'36','Al-Shifa Clinic Camp','Dr Akbar Ali','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Sultanpalya',NULL,NULL,'Bangalore','KA','IN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-17',NULL,'',NULL),(37,'37','Mediscope Hospital Camp','Dr Mohseen Pasha','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Pillanna Garden',NULL,NULL,'Bangalore','KA','IN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-18',NULL,'',NULL),(38,'38','Sri Ganesh Diagnostics and Poly Clinic','Dr Srinath B K','7259299699','7259299699','','abhinav@tricog.com',13.0002735,77.5334654,NULL,NULL,'Kurubarahalli','Bangalore',NULL,NULL,'560086',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-19',NULL,'',NULL),(39,'39','Padma Poly Clinic Camp','Dr Ashwini Ashok','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'R S Palya',NULL,NULL,'Bangalore','KA','IN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-20',NULL,'',NULL),(40,'40','Demo Camp','Dr. Vishal Bhardwaj','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-22',NULL,'',NULL),(41,'41','Bharath Nursing Home Camp','Dr BV Venugopal','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No: 1402, JP Nagar 1st Phase, Sarakki, Kanakapura ',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-22',NULL,'',NULL),(42,'42','FAKE CAMP','Dr Rahul','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Tricog',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-04-21',NULL,'',NULL),(43,'43','Venkateshwara Clinic','Venkateshwara Clinic','7259299699','7259299699','','abhinav@tricog.com',12.9998836,77.5316238,'#114,RAVI COMPLEX, PIPELINE ROAD, KURUBURAHALLI MA',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(44,'44','Shankar Poly Clinic','Dr Anil Kumar','7259299699','7259299699','9448213584','abhinav@tricog.com',13.0133485,77.5098958,'#118/1, NARAYANAPPA COMPLEX, 6TH CROSS, RAJGOPALNA',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(45,'45','Vikas Polyclinic','Dr Shilpa Devanand','7259299699','7259299699','','abhinav@tricog.com',13.0144756,77.5106289,'# 5, RAJAGOPAL NAGAR, MAIN ROAD, PEENYA 2ND STAGE',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(46,'46','Sri Rama Clinic','Dr Praveen','7259299699','7259299699','','abhinav@tricog.com',13.0110552,77.5226094,'#2, 50 FEET ROAD, LAGGERE CIRCLE',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ISSUE','',NULL),(47,'47','Suraksha Clinic','Dr Uday Hebbar P','7259299699','7259299699','8123097156','abhinav@tricog.com',13.0084461,77.5267126,'\"# 381 1ST MAIN ROAD, 2ND CROSS, FREEDOM FIGHTERS ',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(48,'48','Bharathy Hospital','Dr Bharathi Rangaswamy','7259299699','7259299699','','abhinav@tricog.com',12.9760143,77.532605,'#4,NAGARABHAVI MAIN ROAD, PRASHANTH NAGAR',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(49,'49','Ganesh Polyclinic','Dr Srinatth Bk','7259299699','7259299699','','abhinav@tricog.com',13.000517,77.5333491,'# 184/2, 18TH MAIN, KURUBARAHALLI MAIN ROAD',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(50,'50','Vinayaka Polyclinic','Dr Mahendra Kumar','7259299699','7259299699','9663941755','abhinav@tricog.com',13.0357552,77.5989029,'GUDADAHALLI CIRCLE, CHOLA NAGAR MAIN ROAD, RT NAGA',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(51,'51','Kirthan Poly Clinic','Dr Sridhara Murthy','7259299699','7259299699','','abhinav@tricog.com',13.0108054,77.6352744,'#12,KAMMANAHALLI MAIN ROAD, R S PALYA',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','NEVER','',NULL),(52,'52','City Health Care','Dr Jnyaneshwar M S','7259299699','7259299699','','abhinav@tricog.com',12.9496305,77.5269341,'#1,GANGONDANAHALLI MAIN ROAD, NAYANDAHALLI',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(53,'53','Ambica Clinic','Dr Ajith Kumar Hegde','7259299699','7259299699','','abhinav@tricog.com',13.0332318,77.5761121,'# 161 AECS LAYOUT, RMV 2ND STAGE, SANJAYNAGAR',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','','69'),(54,'54','Padma Polyclinic','Dr Ashwini Ashok Kumar','7259299699','7259299699','','abhinav@tricog.com',13.0093812,77.6347732,'SATHYA MURTHY CROSS, KAMMANAHANALLI MAIN ROAD',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(55,'55','MM Clinic','Dr Mujaid Pasha','7259299699','7259299699','','abhinav@tricog.com',12.9744286,77.6386586,'# 253, MOTANNA PALYA, INDIRANAGAR 2ND STAGE',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(56,'56','Sushrutha Lab','Dr B V Manjunath Bhat','7259299699','7259299699','','abhinav@tricog.com',13.0063074,77.6989675,'DEVASANDRA MAIN ROAD, K R PURAM',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(58,'58','All Cure Clinic','Dr Deen Venkatesan','7259299699','7259299699','','abhinav@tricog.com',12.9948166,77.6160032,'#7, WHEELER ROAD, FRAZER TOWN',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','','66'),(59,'59','Joshi  Hospital','Dr K V Joshi','7259299699','7259299699','','abhinav@tricog.com',12.9611887,77.5606107,'#57,58&59, SIRSI ROAD, CHAMARAJPET',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(60,'60','Shri Jain Lab','Dr Somashekar','7259299699','7259299699','','abhinav@tricog.com',12.9587969,77.5660574,'#169, 5TH MAIN, CHAMARAJPET',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(61,'61','Preethi Nursing Home','Dr Indresh','7259299699','7259299699','','abhinav@tricog.com',12.965035,77.5518834,'# 661,7 TH MAIN ROAD, 14TH CROSS, PADAYARAYANAPURA',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(62,'62','Shri Lakshmi Venkateshwara Clinic And Lab','Dr C S Nagaraj','7259299699','7259299699','','abhinav@tricog.com',12.9751779,77.6659741,'# 87, GM PALYA MAIN ROAD, BEHIND BEML FACTORY',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(63,'63','Garden City Clinic And Lab','Dr Mohammed Afroz','7259299699','7259299699','','abhinav@tricog.com',13.0049746,77.6032257,'# 15/2, 2ND MAIN ROAD, CHINNAPPA GARDEN',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(64,'64','Indira Clinic','Dr T P Nagendra','7259299699','7259299699','','abhinav@tricog.com',12.9333605,77.5626545,'#416,VIDYAPEETHA LAYOUT, T R NAGAR',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(65,'65','Ashwini Nursing Home','Dr Raju Seth','7259299699','7259299699','9448308911,9986407949','abhinav@tricog.com',13.0113379,77.6766956,'# 382, NARAYANAPPA BUILDING ,RAMAMURTHY NAGAR',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(66,'66','Anugraha Nursing Home','Dr Praveen Kumar','7259299699','7259299699','9611108008','abhinav@tricog.com',12.9419667,77.4936924,'OUTER RING ROAD, OPP. KENCHANPURA BUS STOP, JNANA ',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','','72'),(67,'67','H K Hospital','Dr A H Lokesh','7259299699','7259299699','','abhinav@tricog.com',12.908727,77.4782857,'#106/2, B M ROAD, NEAR RAINBOW BRIDGE, KENGERI',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(68,'68','Bharat Nursing Home','Dr B V Venu Gopal','7259299699','7259299699','9845036334,9343737136','abhinav@tricog.com',12.910894,77.5730768,'#1402, J P NAGAR 1ST PHASE, SARAKKI, KANAKAPURA MA',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(69,'69','Padmashree Nursing Home','C Ramu, Dr Vasantha','7259299699','7259299699','','abhinav@tricog.com',12.958314,77.5350371,'# 1108/30, 10TH MAIN, RPC LAYOUT, VIJAYANAGAR',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(70,'70','Kusuma Hospital','Dr Sridhar Mk','7259299699','7259299699','','abhinav@tricog.com',12.942019,77.5508469,'# 237/37, 10TH MAIN, NAGENDRA BLOCK, SRINAGAR',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','DEACT','',NULL),(73,'73','Sai Ambica Hospital','Dr K Srinivasa Murthy','7259299699','7259299699','9342557669','abhinav@tricog.com',12.9284947,77.5938348,'# 380, 30TH CROSS, THILAKNAGAR',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-28','ACTIVE','',NULL),(74,'74','Mediscope Hospital','Dr Mousin Pasha','7259299699','7259299699','8123123366,8123123355','abhinav@tricog.com',13.0110927,77.6162699,'1ST CROSS ROAD, PILLANNA GARDEN,','STAGE 3, KADUGONDANAHALLI',NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-29','ACTIVE','',NULL),(75,'75','Lake Side Hospital','Dr Raviraj','7259299699','7259299699','','abhinav@tricog.com',12.9880242,77.6177204,'# 35-3, TANK ROAD,','NEAR ULSOOR LAKE',NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-29','ACTIVE','',NULL),(76,'76','Shilpa Polyclinic','Dr. B.A.Keshava Murthy','7259299699','7259299699','','abhinav@tricog.com',13.014715,77.4761993,'1/1-1, 10th Cross,','Padarayanapura',NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-04-30','DEACT','',NULL),(78,'78','Karnataka Clinic','Dr. V S Krishnamurthy','7259299699','7259299699','9341228273','abhinav@tricog.com',12.9715581,77.5772824,'No 66 Rangaswamy Temple St',NULL,'Chickpet','Bangalore',NULL,NULL,'560053',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-01','ACTIVE','',NULL),(79,'79','Pulse Multispeciality Hospital','Dr. Goutham R Choudhari','7259299699','7259299699','','abhinav@tricog.com',12.9425611,77.54732956,'No. 5/8/1, 50 Feet Road, 20th Main Road, Muneshwar',NULL,NULL,'Bangalore',NULL,NULL,'560085',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-11','DEACT','',NULL),(80,'80','Narayana Clinic','Dr Jaganath C','7259299699','7259299699','','abhinav@tricog.com',13.0635619,77.5877841,'No: 2253, NLC Complex, Opp. Sterling Apartments, K',NULL,NULL,'Bangalore',NULL,NULL,'560092',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-12','DEACT','',NULL),(81,'81','Sri Ram Nursing Home','Dr Chandrashekar','7259299699','7259299699','','abhinav@tricog.com',12.9420247,77.5515432,'# 343, 7th Main Road, Muneshwara Block, Hanumantha',NULL,NULL,'Bangalore',NULL,NULL,'560085',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-14','NEVER','',NULL),(82,'82','Sreenagar Hospital','Dr L Leela','7259299699','7259299699','9448056669,9844059830','abhinav@tricog.com',12.9442786,77.5550817,'#855, Ramanjaneya Main Road, SriNagar',NULL,NULL,'Bangalore',NULL,NULL,'560050',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-15','ACTIVE','',NULL),(83,'83','Lakshmi Hospital','Dr Sriram R','7259299699','7259299699','9739965812','abhinav@tricog.com',13.0249134,77.5916901,'402, 2nd Cross, Judges Colony, Ganganagar',NULL,NULL,'Bangalore',NULL,NULL,'560032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-19','ACTIVE','',NULL),(84,'84','Chaitanya Hospital','Dr P M Patil','7259299699','7259299699','9900316357,7022161297','abhinav@tricog.com',13.0241362,77.5944081,'# 80 & 117, P & T Colony, R T Nagar',NULL,NULL,'Bangalore',NULL,NULL,'560032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-19','ACTIVE','',NULL),(85,'85','Poornima Hospital','Dr Pooraneson Raju','7259299699','7259299699','','abhinav@tricog.com',13.0263216,77.5950595,'# 200/A, HMT Layout, R T Nagar',NULL,NULL,'Bangalore',NULL,NULL,'560032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-19','ACTIVE','',NULL),(86,'86','Sri Krishna Clinic and Diagnostic Centre','Dr Damodar Krishna','7259299699','7259299699','9845626540','abhinav@tricog.com',12.9800671,77.5546589,'# 687/9, Dr Rajkumar Road, 6th Block, Rajajinagar',NULL,NULL,'Bangalore',NULL,NULL,'560010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-21','ACTIVE','',NULL),(87,'87','S.G Hospital','Dr. Gopalswamy H.C','7259299699','7259299699','','abhinav@tricog.com',13.0935677,77.3930092,'#30,Ittamadugu main road','Anjaneyanagar, near janatha bazaar,','b.s.k 3rd stage','Bangalore',NULL,NULL,'560085',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-05-29','ACTIVE','',NULL),(88,'88','Balakrishna Clinic','Dr Madhusudan K','7259299699','7259299699','','abhinav@tricog.com',12.8853382,77.5704264,'#13 Chunchagatta Road, Old Bank Colony',NULL,'Konanakunte','Bangalore',NULL,NULL,'560062',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-06-11','ACTIVE','',NULL),(89,'89','Kamadhenu Hospital','Dr Trivikram Dr Raju','7259299699','7259299699','9945086897,9945946764,08023205577','abhinav@tricog.com',12.975607,77.534725,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-06-19','ACTIVE','',NULL),(90,'90','Amruth Hospital','Dr Prasad','7259299699','7259299699','','abhinav@tricog.com',13.1024914,77.6278341,'No.1, Agrahara layout cross,','bellahalli Main road,kogilu layout,',NULL,'Bangalore',NULL,NULL,'560064',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-06-22','ACTIVE','','71'),(93,'93','Dr.Ali','Dr.Ali','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-06-22',NULL,'',NULL),(94,'94','Manasa Hospital','Dr Nagesh','7259299699','7259299699','','abhinav@tricog.com',12.9689433,77.5245186,'#189,shiva complex,1st main, shivananda nagar,','near vijaya bank, moodalapalya, nagarabhavi main r',NULL,'Bangalore',NULL,NULL,'560072',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-06-25','ACTIVE','',NULL),(98,'98','Yashas clinic & Diagnostics','Dr. Manjunath','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No.474,next to corporation bank,thimmaiahnroad,','Manjunath nagar road, near ambedkar stadium,',NULL,'Bangalore',NULL,NULL,'560010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-06-28',NULL,'',NULL),(99,'99','Mathrushree Hospital','Dr Mahesh S Gandhi','7259299699','7259299699','','abhinav@tricog.com',13.0935677,77.3930092,'No: 6930, Sy. No: 198, NH-4, Gandhinagar, Bye-Pass',NULL,NULL,'Bangalore',NULL,NULL,'562123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-07','ACTIVE','',NULL),(100,'100','J P Hospital','Dr Jaya Prasad','7259299699','7259299699','','abhinav@tricog.com',13.0973824,77.3966144,'B H Road, Nelamangala',NULL,NULL,'Bangalore',NULL,NULL,'562123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-07','ACTIVE','',NULL),(102,'102','Prasad Hospital','Dr S Rajendra Prasad','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'B H Road, Nelamangala',NULL,NULL,'Bangalore',NULL,NULL,'562123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-09','NEVER','',NULL),(103,'103','Sridevi Nursing Home','Dr Rekha Prashanth','7259299699','7259299699','','abhinav@tricog.com',12.9238918,77.5735289,'No: 726, 23rd Cross, K R Road, B S K 2nd Stage',NULL,NULL,'Bangalore',NULL,NULL,'560070',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-09','ACTIVE','',NULL),(104,'104','Sanjeevini Hospital','Dr Sanjay Kumar Tripathi','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No: 760, 7th Main, Last Bus Stop, Near Swimming Po',NULL,NULL,'Bangalore',NULL,NULL,'560086',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-09','FIRST','',NULL),(105,'105','V Care Hospital','Dr Ahmed Shariff','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No: 29, 1st Main Road, A 1st Block, Devegowda Road',NULL,NULL,'Bangalore',NULL,NULL,'560032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-09','FIRST','',NULL),(107,'107','Tanmay Hospital Pvt. Ltd','Dr B Prasanna Kumar','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No: 66, B/7, Pipe Line Road, Manuvana, Vijaynagar',NULL,NULL,'Bangalore',NULL,NULL,'560040',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-09','SURVEY','',NULL),(108,'108','Sri Shirdi Sai Hospital','Dr Muniraju','7259299699','7259299699','','abhinav@tricog.com',13.2436105,77.7112362,'Surabhi Complex, Opp. to Canara Bank, B B Road, De',NULL,NULL,'Bangalore',NULL,NULL,'562110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-09','ACTIVE','',NULL),(109,'109','Mamatha Hospital','Dr Hegde, Dr Nanditha S Hegde','7259299699','7259299699','','abhinav@tricog.com',12.9205554,77.592538,'No: 1539, 39th Cross, 4th T Block, Jayanagar',NULL,NULL,'Bangalore',NULL,NULL,'560041',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-10','ACTIVE','',NULL),(110,'110','Srinidhi Diabetic Centre','Dr Ravindra H S','7259299699','7259299699','','abhinav@tricog.com',12.9270296,77.5881327,'16th Main, Opp. to BES College, Jayanagar 4th Bloc',NULL,NULL,'Bangalore',NULL,NULL,'560011',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-10','ACTIVE','',NULL),(111,'111','Medstar Speciality Hospital','Dr Narendra Kumar','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No: 2270, Maruthi Plaza, Kodegehalli Main Road, Sa',NULL,NULL,'Bangalore',NULL,NULL,'560092',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-10','FIRST','',NULL),(112,'112','Mamta Hospital','Dr Sunil Chhabria','7259299699','7259299699','','abhinav@tricog.com',13.0377617,77.5744335,'No:12, D. Rajgopal Road, Next to Food World, Nagas',NULL,NULL,'Bangalore',NULL,NULL,'560094',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-10','ACTIVE','',NULL),(114,'114','Padma Devaiah Hospital And Research Centre','Dr Abhilash','7259299699','7259299699','','abhinav@tricog.com',12.9705069,77.5562542,'No: 19/1, 19th Cross, 3rd Main Road, Bhuvaneshwari',NULL,NULL,'Bangalore',NULL,NULL,'560023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-13','ACTIVE','',NULL),(115,'115','Eshwar Hospital','Dr Rangaswamy','7259299699','7259299699','','abhinav@tricog.com',13.0092854,77.5404758,'No: 32, 2nd \"A\" Cross, 1st Main Road, Saraswathipu',NULL,NULL,'Bangalore',NULL,NULL,'560096',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-13','ACTIVE','',NULL),(116,'116','Cure Hospital','Dr Homeira Nishat','7259299699','7259299699','','abhinav@tricog.com',13.0322968,77.6085972,'No: 41, Kalleem Building, KHB Main Road, Kanakanag',NULL,NULL,'Bangalore',NULL,NULL,'560032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-13','ACTIVE','',NULL),(117,'117','Durga Clinic','Dr H M Swamy Raj','7259299699','7259299699','','abhinav@tricog.com',13.0401375,77.5925228,'#4','Balaji Complex Shankar Block','Guddadahalli Main Rd Hebbal','Bangalore',NULL,NULL,'560024',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-14','ACTIVE','',NULL),(118,'118','Hegde Multi Speciality Clinic','Dr. Suresh','7259299699','7259299699','','abhinav@tricog.com',12.9208581,77.5933896,'#1032,26thmain, 4thblock','jayanagar',NULL,'Bangalore',NULL,NULL,'560041',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-15','ACTIVE','',NULL),(119,'119','Soham Clinic','Dr Anuradha','7259299699','7259299699','','abhinav@tricog.com',12.9295979,77.5974335,'No: 22, 1st Main, 2nd Cross,','S. R. K Garden, Tilak Nagar Main Road,','Jayanagar,','Bangalore',NULL,NULL,'560041',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-17','ACTIVE','',NULL),(120,'120','East Side Medical Centre','Dr M R Krishna Murthy','7259299699','7259299699','','abhinav@tricog.com',12.9171229,77.5969037,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-17','ACTIVE','',NULL),(121,'121','Sri Sai Ram Hospital, BG Road','Dr Vivekananda Shetty','7259299699','7259299699','9845195939,8548849026','abhinav@tricog.com',12.9146411,77.5998248,'No: 33, Bannerghatta Main Road,','B. T. M Layout II Stage,',NULL,'Bangalore',NULL,NULL,'560076',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-17','ACTIVE','',NULL),(122,'122','Heart Diseases Detection Centre','Dr H Siddappa','7259299699','7259299699','','abhinav@tricog.com',12.9730954,77.6366678,'No 65','Indiranagar 2nd Stage','Appareddy Palya','Bangalore',NULL,NULL,'560038',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-20','ACTIVE','',NULL),(123,'123','Uma Clinic Camp','Dr Chikkanna','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Main Rd Devanahalli Town','opp to Municpal office',NULL,'Bangalore',NULL,NULL,'5621110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-07-21',NULL,'',NULL),(124,'124','Reddy Hospital','Dr Ashok Reddy','7259299699','7259299699','','abhinav@tricog.com',12.9196943,77.5966396,'No: 1590, East End Main Road,','39th Cross, 9th Block,','Jayanagar,','Bangalore',NULL,NULL,'560069',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-21','ACTIVE','',NULL),(126,'126','Hayath Health Centre','Dr Afshad Baig','7259299699','7259299699','','abhinav@tricog.com',12.9661567,77.55138,'No 49/4-1','9th main road','Padarayanapura','Bangalore',NULL,NULL,'560026',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-22','ACTIVE','',NULL),(127,'127','Future Care Clinic & Diagnostics','Mr Deepak Kumar J','7259299699','7259299699','','abhinav@tricog.com',12.9194833,77.5951436,'# 922 28th main','9th Block','Jayanagar Next To S V C Bank','Bangalore',NULL,NULL,'560069',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-23','ACTIVE','',NULL),(128,'128','Magnus Diagnostics Centre','Mr Prasad M','7259299699','7259299699','','abhinav@tricog.com',12.9348172,77.593541,'# 81 S T Bed Entrance ,Off 80 ft Road','Koramangala','IV Block','Bangalore',NULL,NULL,'560034',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-24','ACTIVE','',NULL),(129,'129','N G O Camp','Dr Ali','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Behind Sakara Hospital','Bangalore',NULL,'Bangalore',NULL,NULL,'560036',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-07-26',NULL,'',NULL),(130,'130','N G O Camp','Dr Ali','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'Behind Sakara Hospital','Bangalore',NULL,'Bangalore',NULL,NULL,'560036',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-07-26',NULL,'',NULL),(131,'131','Sree Venkateshwara Speciality Hospital','Dr Venkatesh','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'#1 Gupta Layout Lakkasandra Bannerughatta Road Ban',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-28','ACTIVE','',NULL),(132,'132','Carbon Clinic and Diagnostics','Dr. Periambar','7259299699','7259299699','','abhinav@tricog.com',12.974980426224304,77.7017116729736,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-28',NULL,'',NULL),(133,'133','Sri Anugraha Clinic','Dr Ashok P K','7259299699','7259299699','','abhinav@tricog.com',12.9944397,77.5454107,'No 37/1','60 Feet Road','Manjunathanagar','Bangalore',NULL,NULL,'560010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-29','ACTIVE','',NULL),(134,'134','Yashas Clinic & Diagnostics','Dr Manjunath H V','7259299699','7259299699','','abhinav@tricog.com',12.9839759,77.5426202,'No 474 Next To Corporation Bank','Thimmaiah Road Near Ambedkar Stadium','Basaveshwaranagar','Bangalore',NULL,NULL,'560010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-29','ACTIVE','',NULL),(135,'135','Varalakshmi Hospital','Dr Rekha Prashanth','7259299699','7259299699','','abhinav@tricog.com',12.92470228,77.61710034,'38/2,2nd main raod, madiwala new extn',NULL,NULL,'Bangalore',NULL,NULL,'560068',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-30','ACTIVE','',NULL),(137,'137','Uniq Health Services','Dr. Mohammed Ilyas S P','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'NO 4/1, Shop No 2','4th Cross Giddappa Block','Ganganagar Extn','Bangalore',NULL,NULL,'560032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-30','ACTIVE','',NULL),(138,'138','Vivekananda hospital','Dr Prakash','7259299699','7259299699','','abhinav@tricog.com',12.90040704,77.60177239,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-31','ACTIVE','',NULL),(141,'141','Swetha Clinic','Dr N S Suresha','7259299699','7259299699','9448065725','abhinav@tricog.com',12.9667,77.5667,'Abayashram shop complex','H Siddaiah Rd','Wilson Garden','Bangalore',NULL,NULL,'560027',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-31','ACTIVE','',NULL),(142,'142','Sri Sai Ram Hospital, Kanakapura Road','Dr Vivekanada bhatt','7259299699','7259299699','','abhinav@tricog.com',12.89431239,77.56858673,'#6. JC Industrial Area','yelechenahalli,near metro, kanakapura road',NULL,'Bangalore',NULL,NULL,'560062',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-31','ACTIVE','',NULL),(144,'144','Jeevika Hospital','Dr Ashok Reddy','7259299699','7259299699','9739711484,9964052535,8904184617,08030766768','abhinav@tricog.com',12.9667,77.5667,'95/3','Marathahalli outer ring rd','Doddanekkundi','Bangalore',NULL,NULL,'560037',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-31','ACTIVE','',NULL),(146,'146','Dr Shah\'s Diagnostic Centre','Dr Anil Shah','7259299699','7259299699','','abhinav@tricog.com',13.03220226,77.55906733,'#70,9th main,(opp. SBM)','HTM main road, mathikere',NULL,'Bangalore',NULL,NULL,'560054',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-31','ACTIVE','',NULL),(147,'147','Apple Medi Clinic','Dr Manjula Ravikumar','7259299699','7259299699','9341577055,9916988733','abhinav@tricog.com',12.9667,77.5667,'No 1637/679','Kogilu Main rd','Maruthinagar bus stop Yelahanka','Bangalore',NULL,NULL,'560064',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-07-31','ACTIVE','',NULL),(148,'148','CAMP Kunigal','Raghavendra','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-08-01',NULL,'',NULL),(149,'149','AM 2 PM','Dr Girish','7259299699','7259299699','','abhinav@tricog.com',13.09397754,77.5704106,'Purva Venizia Apartment','Yelahanaka New Town','Near Club House Opp park','Bangalore',NULL,NULL,'560064',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-04','ACTIVE','','70'),(150,'150','Navarang Diagnostics Centre','Mr James','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'No 9/1','Vikram complex Dr Rajkumar Rd','Opp to Navarang Park Rajajinagar','Bangalore',NULL,NULL,'560010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-04','ACTIVE','',NULL),(151,'151','Garden City Collage Campus','Mr Raghavendra','7259299699','7259299699','','abhinav@tricog.com',12.9667,77.5667,'K R Puram',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-08-06',NULL,'',NULL),(152,'152','Sri Balaji Nursing Home','Dr Laxman H Hiremani','7259299699','7259299699','9880795495','abhinav@tricog.com',12.9667,77.5667,'Shanthi Layout Main Rd','Near Shanthi Layout Bus stop','Ram murthy nagar','Bangalore',NULL,NULL,'560016',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-12','ACTIVE','',NULL),(153,'153','Deepa hospital','Dr Vishalakshi','7259299699','7259299699','9535234124,8971534108','abhinav@tricog.com',12.9667,77.5667,'Kr puram',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-18','ACTIVE','',NULL),(155,'155','Bilva Hospital','Dr Keshava Murthy R V','7259299699','7259299699','8792425444,8050659683','abhinav@tricog.com',12.9667,77.5667,'No 22,2nd main Rd','Placae Gutta Halli',NULL,'Bangalore',NULL,NULL,'560003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-18','ACTIVE','',NULL),(156,'156','Jayshree Nursing Home','Dr K Ramadev','7259299699','7259299699','9886626383','abhinav@tricog.com',12.9667,77.5667,'No 4','4th cross,4 th Block','Kumara park West','Bangalore',NULL,NULL,'560020',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-19','ACTIVE','',NULL),(157,'157','Abb limited-WTC','Dr Shanthi','7259299699','7259299699','9980764969','abhinav@tricog.com',12.9667,77.5667,'9980764969',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-19','ACTIVE','','64'),(158,'158','Vittals Medi Care Private Ltd','Mr Rajesh Kumar Singh','7259299699','7259299699','7353755704','abhinav@tricog.com',12.9667,77.5667,'No 270','3rd cross , Domlur','2nd stage Indiranagar','Bangalore',NULL,NULL,'560071',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-19','ACTIVE','',NULL),(159,'159','Joseph Medical Centre','Dr Amalaselvam A','7259299699','7259299699','9986052670','abhinav@tricog.com',12.9667,77.5667,'10','12th cross Lakshmipuram','Off C M H Rd Halasuru','Bangalore',NULL,NULL,'560008',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-19','ACTIVE','',NULL),(160,'160','Apoorva Diagnostics Centre','Mr Kabir Das','7259299699','7259299699','9986009880','abhinav@tricog.com',12.9667,77.5667,'325','1st floor C M H Rd','Indiranagar','Bangalore',NULL,NULL,'560038',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-19','ACTIVE','','73'),(161,'161','Koshys Hospital','Dr Santhosh Khoshy','7259299699','7259299699','9686760116,9731590156,9742286328','abhinav@tricog.com',12.9667,77.5667,'T C Palya Main','Rammurthynagar Extn',NULL,'Bangalore',NULL,NULL,'560016',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-19','ACTIVE','',NULL),(162,'162','City Hospital','Dr Prabhakar','7259299699','7259299699','9901965778','abhinav@tricog.com',12.9667,77.5667,'205/1 prakesh complex,dsa road,','frazer town',NULL,'Bangalore',NULL,NULL,'560005',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-19','ACTIVE','',NULL),(163,'163','ABB- Peenya','Dr.Pradeep S V','7259299699','7259299699','9902122551','abhinav@tricog.com',12.9667,77.5667,'ABB India limited, Plot No. 4A, 5 & 6, 2nd Phase','Peenya industrial Area',NULL,'Bangalore',NULL,NULL,'560058',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-20','ACTIVE','','65'),(164,'164','Zion Hospital','Dr Santhosh Khoshy','7259299699','7259299699','9845242548,9483742691,08043518000','abhinav@tricog.com',12.9667,77.5667,'83/1','Kammanahalli main rd','Behind doctors diagnostics centre','Bangalore',NULL,NULL,'560084',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-20','ACTIVE','',NULL),(165,'165','Srinivasa Nursing Home','Dr Shankar','7259299699','7259299699','9980457455','abhinav@tricog.com',12.9667,77.5667,'No 50','Lakshmi complex','Peenya 3rd phase','Bangalore',NULL,NULL,'560058',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-21','ACTIVE','',NULL),(166,'166','V S Achar Multi Speciality Hospital','Dr Vijay Mahantesh Tarnal','7259299699','7259299699','9480007687','abhinav@tricog.com',12.9667,77.5667,'No 196','10th Cross','Wilson Garden','Bangalore',NULL,NULL,'560027',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-22','ACTIVE','',NULL),(167,'167','Brookefield hospital','Dr. T J Pradeep Kumar MD','7259299699','7259299699','9341217545,9008585588','abhinav@tricog.com',12.9667,77.5667,'521/522, vijayalakshmi square,','ITPL main road, kundalahalli',NULL,'Bangalore',NULL,NULL,'560037',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-22','ACTIVE','',NULL),(168,'168','Amrik Hospital','Dr Amarjit Singh','7259299699','7259299699','9845040520','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-22','ACTIVE','','68'),(169,'169','Nightingale','Dr Jameel','7259299699','7259299699','8884462742','abhinav@tricog.com',12.9667,77.5667,'Ulsoor',NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-08-23',NULL,'',NULL),(170,'170','Gangothri Hospital','Dr Gange Gowda','7259299699','7259299699','9845590549','abhinav@tricog.com',12.9667,77.5667,NULL,NULL,NULL,'Bangalore',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-24','ACTIVE','',NULL),(171,'171','M G A Hospital','Dr M G Peadyumna','7259299699','7259299699','9449829460,9108675168','abhinav@tricog.com',12.9667,77.5667,'No 96','Varthur Main rd','Marathahalli','Bangalore',NULL,NULL,'560037',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-25','ACTIVE','',NULL),(172,'172','Shraddha Health Care & Nursing','Dr Rajiv Gupta','7259299699','7259299699','9886343860','abhinav@tricog.com',12.9667,77.5667,'3&4','7th main','1st Block Koramangala','Bangalore',NULL,NULL,'560034',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-25','ACTIVE','',NULL),(173,'173','Shradha Nursing Home','Dr R Sureshbabu','7259299699','7259299699','9341169544','abhinav@tricog.com',12.9667,77.5667,'727','1st main rd 8th block','Opp to shiva theater near passport office Koramang','Bangalore',NULL,NULL,'560095',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-25','ACTIVE','',NULL),(174,'174','Ramkrishna Nursing Home','Dr Pavan Hegde','7259299699','7259299699','9845148541','abhinav@tricog.com',12.9667,77.5667,'No 79/18','1st cross 6th main rd','Near TTD Temple Gayathridevi park Extn Vyalikaval','Bangalore',NULL,NULL,'560003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2015-08-25','ACTIVE','',NULL);
  79. /*!40000 ALTER TABLE `centers` ENABLE KEYS */;
  80. UNLOCK TABLES;
  81.  
  82. --
  83. -- Table structure for table `devices`
  84. --
  85.  
  86. DROP TABLE IF EXISTS `devices`;
  87. /*!40101 SET @saved_cs_client = @@character_set_client */;
  88. /*!40101 SET character_set_client = utf8 */;
  89. CREATE TABLE `devices` (
  90. `ID` int(11) NOT NULL AUTO_INCREMENT,
  91. `DeviceID` varchar(255) NOT NULL,
  92. `CenterID` varchar(15) DEFAULT NULL,
  93. `AutoSSH-Port` int(5) NOT NULL,
  94. `KeepAlive` int(1) NOT NULL,
  95. `LastHeartBeat` datetime NOT NULL,
  96. `CodeUpdateNeeded` int(1) NOT NULL,
  97. `ModemIMEI` varchar(64) NOT NULL,
  98. `SIMID` varchar(64) NOT NULL,
  99. `LastDataSync` datetime NOT NULL,
  100. `MobileNo` varchar(16) NOT NULL,
  101. `HardwareVersion` varchar(50) DEFAULT NULL,
  102. `WifiSSID` varchar(200) DEFAULT NULL,
  103. `WifiKey` varchar(200) DEFAULT NULL,
  104. `SendLog` int(11) DEFAULT '0',
  105. `RemoteReboot` int(11) NOT NULL DEFAULT '0',
  106. `type` varchar(10) DEFAULT NULL,
  107. UNIQUE KEY `ID` (`ID`)
  108. ) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=latin1;
  109. /*!40101 SET character_set_client = @saved_cs_client */;
  110.  
  111. --
  112. -- Dumping data for table `devices`
  113. --
  114.  
  115. LOCK TABLES `devices` WRITE;
  116. /*!40000 ALTER TABLE `devices` DISABLE KEYS */;
  117. INSERT INTO `devices` VALUES (13,'Tricog-Dongle-0000','171',60000,0,'2015-04-14 13:14:51',0,'','','2015-08-13 15:41:55','',NULL,NULL,NULL,0,0,NULL),(16,'1','1',60010,1,'0000-00-00 00:00:00',1,'0','0','2015-04-30 12:51:26','',NULL,NULL,NULL,0,0,NULL),(18,'Tricog-Dongle-AFA6','22',60001,0,'2015-05-26 12:29:44',0,'863617022335779','89914509009102804120','2015-05-26 12:26:26','7259014160',NULL,NULL,NULL,0,0,NULL),(19,'Tricog-Dongle-4FB2','22',60002,0,'2015-07-07 15:26:11',0,'863617022350208','89914509009102804104','2015-07-07 15:26:43','7259008895',NULL,NULL,NULL,0,0,'3G Dongle'),(20,'Tricog-Dongle-B777','22',60003,0,'2015-06-19 12:20:31',0,'868860008997817','89914509009302471456','2015-06-18 14:45:52','8861100369',NULL,NULL,NULL,0,0,NULL),(21,'Tricog-Dongle-9D4B','22',60004,0,'2015-06-18 16:01:57',0,'868860009017516\r\n','89914509009102804112','2015-06-18 13:17:16','7259013805',NULL,NULL,NULL,0,0,NULL),(22,'Tricog-Dongle-69EA','22',60005,0,'2015-05-30 12:55:43',0,'863617021908055\r\n','89914509009302471472','2015-07-30 16:36:40','8861100415',NULL,NULL,NULL,1,0,NULL),(24,'Tricog-Dongle-358D','22',60006,1,'2015-08-26 10:51:43',0,'868860000461309','89914509009302471357\r\n','2015-04-04 18:15:48','8861100408',NULL,NULL,NULL,0,0,'3G Dongle'),(25,'Tricog-Dongle-D42C','22',60007,0,'2015-08-04 13:13:52',0,'863617022347774','89914509009102804138','2015-07-20 22:40:28','7259014351',NULL,NULL,NULL,0,0,NULL),(26,'Tricog-Dongle-25F8','22',60008,0,'2015-04-20 14:38:42',0,'863617021839102','89914509009302471449','2015-04-20 14:20:45','8861100244',NULL,NULL,NULL,0,0,NULL),(27,'Viewer','22',0,0,'0000-00-00 00:00:00',0,'','','0000-00-00 00:00:00','',NULL,NULL,NULL,0,0,NULL),(28,'Tricog-Dongle-4C3A','22',60009,0,'2015-05-24 17:17:17',1,'868860000461309','89914509009302471357','2015-05-23 12:25:31','',NULL,NULL,NULL,0,0,NULL),(29,'Tricog-Dongle-000B','22',60011,0,'2015-05-27 09:45:58',0,'868860005520042','89914509009102804096','2015-05-27 09:46:36','7259008894',NULL,NULL,NULL,0,0,NULL),(30,'Tricog-Dongle-1AF9','22',60012,1,'2015-08-26 10:55:02',0,'','','2015-08-11 15:23:32','','HydrogenB','Tricog Internal','@Tri85y#9',0,0,'3G Dongle'),(31,'Tricog-Dongle-90FA','94',60013,0,'2015-08-22 19:29:34',0,'356793031314396','','2015-08-22 19:25:41','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(32,'Tricog-Dongle-E88D','90',60014,0,'2015-08-25 22:36:26',0,'356793031314271','404450930243180','2015-08-25 22:24:05','9731226549','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(33,'Tricog-Dongle-3A5C','44',60015,0,'2015-08-22 19:03:16',0,'356793031316854','404450930243176','2015-08-21 21:03:55','9731227550','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(34,'Tricog-Dongle-B4F1','165',60016,0,'2015-08-25 09:54:04',0,'356793031314552','404450930243199','2015-08-25 09:50:42','9731732426','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(35,'Tricog-Dongle-60BF','86',60017,0,'2015-07-30 21:36:58',0,'356793031314248','404450930243177','2015-07-30 21:36:25','9731229846','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(36,'Tricog-Dongle-B36F','47',60018,0,'2015-08-24 10:34:53',0,'356793031268188','404450930243198','2015-08-24 10:33:08','9731729635','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(37,'Tricog-Dongle-3DB4','16',60019,0,'2015-08-18 13:07:45',0,'356793031313422','','2015-08-18 13:03:09','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(38,'Tricog-Dongle-6C6D','53',60020,0,'2015-08-11 21:04:35',0,'356793031316250','404450930243181','2015-08-11 19:11:31','9731225879','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(39,'Tricog-Dongle-FA52','75',60021,0,'2015-08-24 12:33:14',0,'356793031313596','404450930243178','2015-08-24 12:33:39','9731227501','HydrogenB',NULL,NULL,0,0,'Tricog AP'),(40,'Tricog-Dongle-0E62','68',60022,0,'2015-08-26 10:55:40',0,'','404450930243196','2015-08-26 08:35:09','9731723987','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(41,'Tricog-Dongle-8ED2','1',62222,1,'2015-08-25 12:58:45',0,'','','2015-08-25 12:54:34','','',NULL,NULL,0,0,NULL),(42,'Tricog-Dongle-0D31','158',62223,1,'2015-08-26 10:54:58',0,'356793031314412','404450920544462','2015-08-26 01:56:46','7899767931','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(43,'Tricog-Dongle-9D63','159',62224,0,'2015-08-19 23:29:55',0,'356793031315849','404450930243175','2015-08-19 15:10:28','9731228913','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(46,'Tricog-Dongle-1802','167',62227,0,'2015-08-23 10:19:25',0,'356793031316821','404450920544494','2015-08-22 13:14:39','7899767945','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(47,'Tricog-Dongle-6B21','22',62228,0,'2015-08-25 19:32:13',0,'356793031314313','404450930243190','2015-06-11 11:09:06','9731775589','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(48,'Tricog-Dongle-A7A4','65',62229,0,'2015-08-25 21:50:34',0,'356793031313877','404450930243188','2015-08-25 21:47:17','9731221643','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(49,'Tricog-Dongle-45BC','172',62230,0,'2015-08-25 21:26:28',0,'356793031314420','404450930243193','2015-08-25 13:57:30','9731718412','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(50,'Tricog-Dongle-33EA','58',62231,0,'2015-08-25 14:02:18',0,'356793031314024','404450930243189','2015-08-24 23:55:53','9731220581','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(51,'Tricog-Dongle-857D','22',62232,1,'2015-08-26 10:55:51',0,'356793031314537','404450930243195','2015-08-10 19:41:45','9731723893','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(52,'Tricog-Dongle-C201','22',62233,0,'2015-08-07 21:33:11',0,'356793031313976','404450930243193','2015-07-30 10:50:51','9731718412','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(53,'Tricog-Dongle-73DF','22',62234,0,'2015-07-31 12:29:13',1,'356793031314057','404450930243192','2015-07-31 12:29:07','9731713569','HydrogenB',NULL,NULL,0,0,NULL),(54,'Tricog-Dongle-FB9E','171',62235,0,'2015-08-25 16:27:46',0,'356793031317027','404450920544491','2015-08-25 12:46:04','7899767946','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(55,'Tricog-Dongle-1358','88',62236,0,'2015-08-26 07:49:34',0,'356793031270028','404450930243194','2015-08-25 19:03:53','9731718452','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(56,'Tricog-Dongle-9137','160',62237,0,'2015-08-20 12:07:32',0,'356793031314032','404450920544491','2015-08-20 10:59:26','7899767946','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(57,'Tricog-Dongle-F18A','22',62238,0,'2015-07-17 13:56:18',1,'356793031270671','404450930243191','2015-07-14 11:04:04','9535182657','HydrogenB',NULL,NULL,0,0,NULL),(58,'Tricog-Dongle-8C82','21',62239,0,'2015-08-25 17:19:18',0,'356793031313943','404450920544472','2015-08-25 17:17:14','7899767932','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(59,'Tricog-Dongle-3BD9','56',62240,0,'2015-08-24 15:01:15',0,'356793031313687','404450920544470','2015-08-24 11:01:54','7899767938','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(60,'Tricog-Dongle-D633','85',62241,0,'2015-08-25 20:18:20',0,'356793031314008','404450920544471','2015-08-25 20:18:34','7899767933','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(61,'Tricog-Dongle-EFEB','22',62242,0,'2015-08-11 19:00:19',1,'356793031313364','404450920544499','2015-08-11 18:57:07','7899767940','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(62,'Tricog-Dongle-1785','22',62243,0,'2015-08-22 10:06:36',0,'356793031313968','404450920544469','2015-06-24 15:39:46','7899767939','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(63,'Tricog-Dongle-D192','157',62244,0,'2015-08-24 11:09:21',0,'356793031314693','404450920544496','2015-08-24 11:07:05','7899767941','HydrogenB',NULL,NULL,0,0,NULL),(64,'Tricog-Dongle-E133','84',62245,0,'2015-08-26 06:06:04',0,'356793031315799','404450930243182','2015-08-26 06:01:08','9731224783','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(65,'Tricog-Dongle-3FB6','87',62246,0,'2015-08-25 16:13:58',0,'356793031313653','404450930243182','2015-08-25 16:10:34','9731224783','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(66,'Tricog-Dongle-8133','164',62247,0,'2015-08-26 07:22:49',0,'356793031269343','404450920544473','2015-08-26 07:22:17','7899767936','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(67,'Tricog-Dongle-5761','23',62248,0,'2015-08-26 10:55:23',0,'356793031313836','404450920544473','2015-08-25 14:18:03','7899767936','HydrogenB',NULL,NULL,0,0,'Tricog AP'),(68,'Tricog-Dongle-CA70','173',62249,0,'2015-08-25 15:44:07',0,'356793031315799','404450930243182','2015-08-25 15:34:26','9731224783','HydrogenB',NULL,NULL,0,0,'Tricog AP'),(69,'Tricog-Dongle-B838','20',62250,0,'2015-08-23 21:51:48',0,'356793031313653','404450920544473','2015-08-23 21:51:50','7899767936','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(70,'Tricog-Dongle-82DC','83',62251,0,'2015-08-14 16:04:09',0,'356793031315799','404450930243182','2015-08-14 14:37:03','9731224783','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(71,'Tricog-Dongle-C24D','18',62252,0,'2015-08-24 13:29:23',0,'356793031315799','404450930243182','2015-08-24 11:49:37','9731224783','HydrogenB',NULL,NULL,0,0,NULL),(72,'Tricog-Dongle-C779','73',62253,0,'2015-08-25 13:34:27',0,'356793031313653','404450920544473','2015-08-25 13:35:12','7899767936','HydrogenB',NULL,NULL,0,0,'Tricog AP'),(73,'Tricog-Dongle-2BAD','22',62254,0,'2015-08-25 16:36:20',0,'356793031313653','404450920544473','2015-08-10 19:19:49','7899767936','HydrogenB',NULL,NULL,0,0,NULL),(74,'Tricog-Dongle-F976','78',62255,0,'2015-08-24 21:08:52',0,'356793031313653','404450920544289','2015-08-24 20:41:26','7899730471','HydrogenB',NULL,NULL,0,0,'Tricog AP'),(75,'Tricog-Dongle-C4F7','63',62256,0,'2015-08-25 11:31:59',0,'356793031313653','404450920544289','2015-08-24 15:01:23','7899730471','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(76,'Tricog-Dongle-DF49','66',62257,0,'2015-08-17 17:24:39',0,'356793031313653','404450920544289','2015-08-17 17:17:55','7899730471','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(77,'Tricog-Dongle-5DD2','22',62258,0,'2015-08-25 20:23:58',0,'356793031313653','404450920544289','2015-08-10 20:01:20','7899730471','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(78,'Tricog-Dongle-01C7','14',62259,0,'2015-08-26 10:55:33',0,'356793031313653','404450920544289','2015-08-24 13:19:14','7899730471','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(79,'Tricog-Dongle-60C3','155',62260,0,'2015-08-25 14:44:49',0,'-1','-1','2015-08-25 13:17:15','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(80,'Tricog-Dongle-2CA1','103',62261,0,'2015-08-12 10:49:05',0,'356793032034241','404450940665337','2015-08-12 10:49:29','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(81,'Tricog-Dongle-1B07','110',62262,0,'2015-08-26 10:22:07',0,'356793031313851','404450930247131','2015-08-26 10:22:19','','HydrogenB',NULL,NULL,0,0,NULL),(82,'Tricog-Dongle-0E80','126',62263,0,'2015-08-25 16:10:40',0,'356793032034456','404450940665323','2015-08-21 20:10:00','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(83,'Tricog-Dongle-8A8D','112',62264,0,'2015-08-26 09:26:27',0,'356793031313851','404450930247131','2015-08-26 09:16:35','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(84,'Tricog-Dongle-AC54','109',62265,0,'2015-08-11 11:31:48',0,'356793031313851','404450930247131','2015-07-29 14:50:33','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(85,'Tricog-Dongle-17A3','82',62266,0,'2015-08-25 23:44:58',0,'356793031313851','404450930247131','2015-08-25 23:44:11','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(86,'Tricog-Dongle-9002','54',62267,0,'2015-08-22 12:11:24',0,'356793031313851','404450930247131','2015-08-22 12:12:10','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(87,'Tricog-Dongle-8885','108',62268,0,'2015-08-24 14:39:32',0,'356793031313851','404450930247131','2015-08-24 14:39:38','','HydrogenB',NULL,NULL,0,0,'Tricog AP'),(88,'Tricog-Dongle-8117','114',62269,0,'2015-08-24 12:31:22',0,'356793032033789','404450940665305','2015-08-24 12:23:31','','HydrogenB',NULL,NULL,0,0,NULL),(89,'Tricog-Dongle-E441','89',62270,0,'2015-08-24 21:58:52',0,'356793031313851','404450930247131','2015-08-24 21:49:43','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(90,'Tricog-Dongle-2039','117',62271,0,'2015-08-11 18:42:05',0,'356793031313851','404450930247131','2015-08-11 18:37:40','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(91,'Tricog-Dongle-EAB9','133',62272,0,'2015-08-21 09:14:25',0,'356793031313851','404450930247131','2015-08-03 14:21:53','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(92,'Tricog-Dongle-97B5','22',62273,0,'2015-08-22 10:10:52',0,'356793031313851','404450930247131','0000-00-00 00:00:00','','HydrogenC',NULL,NULL,0,0,NULL),(93,'Tricog-Dongle-8DAB','115',62274,0,'2015-08-25 22:21:45',0,'356793031313851','404450930247131','2015-08-25 22:22:11','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(94,'Tricog-Dongle-6FBC','146',62275,0,'2015-08-26 10:38:41',0,'356793031313851','404450930247131','2015-08-26 10:38:26','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(95,'Tricog-Dongle-5B0E','128',62276,0,'2015-08-04 12:19:41',0,'356793031313851','404450930247131','2015-08-04 12:10:50','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(96,'Tricog-Dongle-D258','116',62277,0,'2015-08-25 21:34:25',0,'356793031313851','404450930247131','2015-08-25 21:34:39','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(97,'Tricog-Dongle-7353','127',62278,0,'2015-08-21 19:47:03',0,'356793031313851','404450930247131','2015-08-21 19:41:49','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(102,'Tricog-Dongle-4566','137',62279,0,'2015-08-14 12:29:12',0,'356793031313851','404450930247131','2015-07-30 20:04:52','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(103,'Tricog-Dongle-DA4A','141',62280,0,'2015-08-23 10:54:54',0,'356793031313851','404450930247131','2015-08-23 10:55:23','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(104,'Tricog-Dongle-AE8A','149',62281,0,'2015-08-23 09:00:13',0,'356793031313851','404450930247131','2015-08-23 09:00:16','','HydrogenC','venkatesh','9964878491',0,0,'Private'),(105,'Tricog-Dongle-E69C','134',62282,0,'2015-07-31 16:04:02',0,'356793031313851','404450930247131','2015-07-29 17:23:31','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(106,'Tricog-Dongle-0A7F','135',62283,0,'2015-08-14 14:41:21',0,'356793031313851','404450930247131','2015-08-14 14:41:26','','HydrogenC','Prashanth','tavaru123',0,0,'Private'),(107,'Tricog-Dongle-BA21','168',62284,0,'2015-08-24 23:29:30',0,'356793031313851','404450930247131','2015-08-22 15:01:03','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(108,'Tricog-Dongle-345D','150',62285,0,'2015-08-25 12:32:39',0,'356793031313851','404450930247131','2015-08-24 11:44:59','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(109,'Tricog-Dongle-488B','153',62286,0,'2015-08-24 20:16:49',0,'356793031313851','404450930247131','2015-08-24 20:17:03','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(110,'Tricog-Dongle-25C4','170',62287,0,'2015-08-25 12:06:18',0,'356793031313851','404450930247131','2015-08-24 20:48:13','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(111,'Tricog-Dongle-BC24','144',62288,0,'2015-08-26 10:55:27',0,'356793031313851','404450930247131','2015-08-26 10:52:08','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(112,'Tricog-Dongle-73FB','120',62289,0,'2015-08-21 04:43:11',0,'356793031313851','404450930247131','2015-07-31 12:45:11','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(113,'Tricog-Dongle-830B','152',62290,0,'2015-08-24 19:44:56',0,'356793031313851','404450930247131','2015-08-24 10:58:25','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(114,'Tricog-Dongle-0804','121',62291,0,'2015-08-25 00:14:39',0,'356793031313851','404450930247131','2015-08-24 22:12:14','','HydrogenC',NULL,NULL,0,0,'Tricog AP'),(115,'Tricog-Dongle-7EC2','147',62292,0,'2015-08-21 11:54:50',0,'356793031313851','404450930247131','2015-08-21 11:47:51','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(116,'Tricog-Dongle-3361','161',62293,0,'2015-08-26 09:30:49',0,'356793031313851','404450930247131','2015-08-25 17:07:34','','HydrogenC',NULL,NULL,0,0,'Tricog AP'),(117,'Tricog-Dongle-5CA7','62',62294,0,'2015-08-18 21:53:03',0,'356793031313851','404450930247131','2015-08-18 21:52:12','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(118,'Tricog-Dongle-F485','99',62295,0,'2015-08-20 18:24:57',0,'356793031313851','404450930247131','2015-08-20 17:06:30','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(119,'Tricog-Dongle-FF26','118',62296,0,'2015-08-23 12:25:51',0,'356793031313851','404450930247131','2015-08-23 12:25:23','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(120,'Tricog-Dongle-C837','142',62297,0,'2015-08-25 06:35:48',0,'356793031313851','404450930247131','2015-08-25 06:35:23','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(121,'Tricog-Dongle-1E3D','122',62298,0,'2015-07-20 13:15:11',0,'356793031313851','404450930247131','2015-07-20 13:08:57','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(122,'Tricog-Dongle-E683','166',62299,0,'2015-08-25 12:13:34',0,'356793031313851','404450930247131','2015-08-25 12:13:14','','HydrogenC',NULL,NULL,0,0,NULL),(123,'Tricog-Dongle-0CC2','138',62300,0,'2015-08-25 18:45:42',0,'356793031313851','404450930247131','2015-08-25 18:44:51','','HydrogenB','vivekananda hospital','919845467787',0,0,'Private'),(124,'Tricog-Dongle-160E','100',62301,0,'2015-08-26 07:10:50',0,'356793031313851','404450930247131','2015-08-26 07:09:34','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(125,'Tricog-Dongle-1E22','119',62302,0,'2015-08-24 12:48:44',0,'356793031313851','404450930247131','2015-08-24 12:49:17','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(126,'Tricog-Dongle-7FF5','131',62303,0,'2015-08-24 23:49:29',0,'356793031313851','404450930247131','2015-08-17 21:05:40','','HydrogenC',NULL,NULL,0,0,NULL),(127,'Tricog-Dongle-90D8','124',62304,0,'2015-08-21 20:30:23',0,'356793031313851','404450930247131','2015-08-21 20:29:27','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(128,'TRICOG-DONGLE-FXFX','132',0,0,'0000-00-00 00:00:00',0,'','','0000-00-00 00:00:00','',NULL,NULL,NULL,0,0,NULL),(129,'Tricog-Dongle-A1B4','163',62305,0,'2015-08-25 11:47:35',0,'356793032027682','404450920831676','2015-08-25 11:23:21','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(130,'Tricog-Dongle-C413','50',62306,0,'2015-08-21 21:33:44',0,'356793032027591','404450920831692','2015-08-05 11:40:52','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(131,'',NULL,62307,0,'0000-00-00 00:00:00',0,'','','0000-00-00 00:00:00','','HydrogenC',NULL,NULL,0,0,NULL),(132,'Tricog-Dongle-E5C4','74',62308,0,'2015-08-26 06:34:05',0,'356793031313851','404450930247131','2015-08-26 06:34:35','','HydrogenC',NULL,NULL,0,0,'3G Dongle'),(133,'Tricog-Dongle-86DD','162',62309,0,'2015-08-25 12:26:07',0,'356793031314057','404450940665336','2015-08-25 12:26:37','','HydrogenB',NULL,NULL,0,0,'3G Dongle'),(134,'Tricog-Dongle-F183','156',62310,0,'2015-08-24 20:12:39',0,'356793031313851','404450930247131','2015-08-24 20:12:52','','Hydrogen C','ramu','9886626383',0,0,'Private'),(135,'Tricog-Dongle-5274','174',62311,1,'2015-08-26 10:55:09',0,'356793031313851','404450930247131','2015-08-26 08:20:51','','Hydrogen C','ramu','4f35366ce487808211b256f1863384ac329c78037d6143110070bb7ef8ba5cde',0,0,'Private'),(136,'Tricog-Dongle-347E','22',62312,1,'2015-08-26 10:51:32',0,'356793031313851','404450930247131','0000-00-00 00:00:00','','Hydrogen C',NULL,NULL,0,0,'3G Dongle'),(137,'Tricog-Dongle-7DDB',NULL,62313,0,'2015-08-21 13:48:06',0,'356793031313851','404450930247131','0000-00-00 00:00:00','','HydrogenC',NULL,NULL,0,0,NULL);
  118. /*!40000 ALTER TABLE `devices` ENABLE KEYS */;
  119. UNLOCK TABLES;
  120. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  121.  
  122. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  123. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  124. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  125. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  126. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  127. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  128. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  129.  
  130. -- Dump completed on 2015-09-12 11:26:35
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!