-- MySQL dump 10.13  Distrib 5.5.40, for debian-linux-gnu (x86_64)
--
-- Host: mysql.bvraghav.com    Database: bnv_ayy
-- ------------------------------------------------------
-- Server version	5.1.56-log

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

DROP TABLE IF EXISTS `MSmemmaster`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MSmemmaster` (
  `memid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `memno` varchar(10) NOT NULL,
  `memname` varchar(64) NOT NULL,
  `mememail` varchar(64) NOT NULL DEFAULT 'info@bnvenkat.com',
  `memstart` datetime DEFAULT '1981-07-01 00:00:00',
  `memadd` varchar(1023) DEFAULT NULL,
  `memcat` int(11) DEFAULT NULL,
  `mempass` varchar(32) DEFAULT NULL,
  `memclose` datetime DEFAULT '2100-01-01 00:00:00',
  PRIMARY KEY (`memid`),
  KEY `memno` (`memno`,`memid`),
  KEY `memname` (`memname`,`mememail`),
  KEY `memcat` (`memcat`,`memname`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MSmemmaster`
--

LOCK TABLES `MSmemmaster` WRITE;
/*!40000 ALTER TABLE `MSmemmaster` DISABLE KEYS */;
INSERT INTO `MSmemmaster` VALUES (1,'M1','A Palanivel','apalanivel@gmail.com','1981-07-01 00:00:00','Shri A Palanivel IPS (retd)\n65 Church Road\nVishnu Puri\nAliganj, Lucknow 226022\n(M) 9450641394',NULL,'M1apal','2100-01-01 00:00:00'),(2,'M2','akshay.dwarakanath@iitr.res.in','akshay.dwarakanath@iitr.res.in','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(3,'M3','amritha21','amritha21@yahoo.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(4,'M4','Bala krishnan','balakrris@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(5,'M5','bala krishnan','bala.krishnan@hcl.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(6,'M6','balasubramanian sekar','muthamizhsangamlko@gmail.com','1981-07-01 00:00:00','Dr B Sekar\nB-2133 Indira Nagar\nLucknow226016\n(M) 9986468708',NULL,'M6muth','2100-01-01 00:00:00'),(7,'M7','bhavani iswaran','bavaninbri@yahoo.co.in','1981-07-01 00:00:00','Smt. Bavani Iswaran\nA 925/5 Indira Nagar\nLucknow 226016\n(M) 9208229205',NULL,'M7bava','2100-01-01 00:00:00'),(8,'M8','damadaran horticulture','damhort2002@yahoo.com','1981-07-01 00:00:00','Dr. T Damodaran s/o Shri G Thukkaram\nFlat 107 Kunkum Gruh Apartments\nELDECO Udyan I, Ravi Khand\nSharada NagarLucknow\n09198149968',NULL,'M8damh','2100-01-01 00:00:00'),(9,'M9','Dandapani N','n.dandapani@gmail.com','1981-07-01 00:00:00','Shri N Dandapani\nSC-09, Indo Gulf Township\nLucknow',NULL,'M9n.da','2100-01-01 00:00:00'),(10,'M10','ganapathy kr','krg5393@gmail.com','1981-07-01 00:00:00','Shri K R Ganapathy\nD-1385/4 Indira Nagar\nLucknow226016\n(Ph) 0522-6451930',NULL,'M10krg5','2100-01-01 00:00:00'),(11,'M11','ganpathy kesoram','ganpathy.kesoram@timesgroup.com','1981-07-01 00:00:00','Shri G. Kesoraam\n306 Garden View Apartments\n8, Rana Pratap Marg\nLucknow 226 001\n(M)9415019051',NULL,'M11ganp','2100-01-01 00:00:00'),(12,'M12','Gnanamani Ravikumar','gmani.ravi@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(13,'M13','gopal krishna','gopal.krishna@sbi.co.in','1981-07-01 00:00:00','Shri K R Gopalakrishnan\nN-453/A Aashiana Colony\nLucknow 226012\n(M) 9450904706',NULL,'M13gopa','2100-01-01 00:00:00'),(14,'M14','gopal sbi','jay_vighnesh@yahoo.com','1981-07-01 00:00:00','Smt Jayshree Gopalkrishnan\nN-453/A Aashiana Colony\nLucknow 226012\n(M) 9415541309',NULL,'M14jay_','2100-01-01 00:00:00'),(15,'M15','govindarajan s','govind108@yahoo.co.in','1981-07-01 00:00:00','email gets undelivered at\nthe given id\nNo address available',NULL,'M15govi','2100-01-01 00:00:00'),(16,'M16','Gunasegaran s','guna19542003@yahoo.co.uk','1981-07-01 00:00:00','Dr S Gunasekaran\n(M) 9839014410\nADD INCOMPLETE',NULL,'M16guna','2100-01-01 00:00:00'),(17,'M17','J. Venkatesh Pratap','jvpratap@cdri.res.in','1981-07-01 00:00:00','Dr. J V Pratap\n3/161 Sector D, Priyadarshani colony,\nSitapur Road, Lucknow 226020\n(M) 9918223217',NULL,'M17jvpr','2100-01-01 00:00:00'),(18,'M18','k Subramanian','s.kozimuttam@gmail.com','1981-07-01 00:00:00','Shri K R Subramaniam\n1/145 C, Vishwas Khand\nGomti Nagar\nLucknow 226010\n(M) 9532116750',NULL,'M18s.ko','2100-01-01 00:00:00'),(19,'M19','k vijay','kvijay@gail.co.in','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(20,'M20','kalaiselvanpt@canarabank.com','kalaiselvanpt@canarabank.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(21,'M21','Karthik Ramalingam','karthikramalingam86@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(22,'M22','Kesoraam G','raamganesh1@gmail.com','1981-07-01 00:00:00','Smt. K. Saraswathi\n306 Garden View Apartments\n8, Rana Pratap Marg\nLucknow 226 001\n(M) 9415019051',NULL,'M22raam','2100-01-01 00:00:00'),(23,'M23','Kesoraam G','raamganesh1@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(24,'M24','kr gopalan','krgpalan@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(25,'M25','m siva','sk1557@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(26,'M26','Magesh Waran','mag.bacillus@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(27,'M27','mandurai rao','raomsk@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(28,'M28','mania607@gmail.com','mania607@gmail.com','1981-07-01 00:00:00','Shri A Meni\n4/88 Vibhav Khand\nGomti Nagar, Lucknow 226010\n(M) 9648036995',NULL,'M28mani','2100-01-01 00:00:00'),(29,'M29','Muruganantham Mariappan','murugaa.csir@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(30,'M30','MV.Subramanian@nic.co.in','MV.Subramanian@nic.co.in','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(31,'M31','n dandapani','n.dandapani@adityabirla.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(32,'M32','n vr','nvr@godrej.com','1981-07-01 00:00:00','email gets undelivered at\nthe given id\nNo address available',NULL,'M32nvr@','2100-01-01 00:00:00'),(33,'M33','nagarajan','nagarajan60@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(34,'M34','natesan manickam','nmanickam@rediffmail.com','1981-07-01 00:00:00','Dr. N Manickam\nD 58, Sector G, Aliganj\nLucknow 26020\n(M) 9450110787',NULL,'M34nman','2100-01-01 00:00:00'),(35,'M35','navodayamkalleti@ymail.com','navodayamkalleti@ymail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(36,'M36','p.krishnan','p.krishna@tatamotors.com','1981-07-01 00:00:00','Shri P S Venkata Krishnan\nFlat No. 607 Surya Square\n605/1 Vikalp Khand\nGomti Nagar Lucknow 226010\n(M) 9956299832\nemail gets undelivered at\nthe given id  CORR REQD',NULL,'M36p.kr','2100-01-01 00:00:00'),(37,'M37','Pickup Kannan','gaurikann@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(38,'M38','pr santosh','prsantosh@gmail.com','1981-07-01 00:00:00','Shri P R Santosh\n2/297 Vishal Khand\nGomti Nagar,\nLucknow 226010\n(M) 9793051888',NULL,'M38prsa','2100-01-01 00:00:00'),(39,'M39','R Venkataraman','rv_9671@hotmail.com','1981-07-01 00:00:00','Shri Venkataraman\nSB-01, Indo Gulf Township\nLucknow',NULL,'M39rv_9','2100-01-01 00:00:00'),(40,'M40','raghupathi vb','raguvbank@gmail.com','1981-07-01 00:00:00','Shri Raghupati durai\n(M)9473692466\nAddress incomplete CORR REQD',NULL,'M40ragu','2100-01-01 00:00:00'),(41,'M41','rajesh subramanian','subramanian_vrajesh@rediffmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(42,'M42','Rama chandran','chituchandran@rediffmail.com','1981-07-01 00:00:00','Shri C Ramachandran\nVijaya bank Regional office\nIndira Nagar\nLucknow 226016\n(M) 9695711216',NULL,'M42chit','2100-01-01 00:00:00'),(43,'M43','ramarajan.get09@gmail.com','ramarajanget09@gmail.com','1981-07-01 00:00:00','email gets undelivered at\nthe given id\nNo address available',NULL,'M43rama','2100-01-01 00:00:00'),(44,'M44','ramesh kumar','rameshkumar05@yahoo.co.in','1981-07-01 00:00:00','email gets undelivered at\nthe given id\nNo address available',NULL,'M44rame','2100-01-01 00:00:00'),(45,'M45','Ravi kumar','dr.ravikumar@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(46,'M46','ravi shankar','ravi_anitha@yahoo.com','1981-07-01 00:00:00','Dr Ravi shankar\nFlat 506, Eldeco Park View Apartments\nLucknow\n(M) 9838245409',NULL,'M46ravi','2100-01-01 00:00:00'),(47,'M47','Ravisankar M','ravisankar29@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(48,'M48','s p','sparameswaran.2010@gmail.com','1981-07-01 00:00:00','Shri S Parameswaran\nC-146/F RDSO colony, \nLucknow 226011\n(M) 9794863063',NULL,'M48spar','2100-01-01 00:00:00'),(49,'M49','s venkatramanan','vechaban@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(50,'M50','sampath IIml','sampath@iiml.ac.in','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(51,'M51','saravanan kumar','saravanan.kumar.vsk@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(52,'M52','satheeshiyar@gmail.com','satheeshiyar@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(53,'M53','senduran nit','senduran.nit@gmail.com','1981-07-01 00:00:00','Shri Senduran\n6/380 Vineet khand\nGomti Nagar\nLucknow 226 010\n(M) 9935309976',NULL,'M53send','2100-01-01 00:00:00'),(54,'M54','sethil siva','senthil.siva25@gmail.com','1981-07-01 00:00:00','Shri B Senthilkumar\n2/412 Vivek Khand\nGomti Nagar Lucknow 226010\n(M) 9335254293',NULL,'M54sent','2100-01-01 00:00:00'),(55,'M55','Shri SG Swaminatha sashtri','madrasipanditji@yahoo.co.in','1981-07-01 00:00:00','Acharya Shri S G Swaminathan\nC-1059/7 C Block\nIndira Nagar\nLucknow 226 016\n(M) Bhanu 4565060684',NULL,'M55madr','2100-01-01 00:00:00'),(56,'M56','sindham tamil','sindham@yahoo.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(57,'M57','srinivasan hal','bhama.srini@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(58,'M58','SubramaniyanGanesan Swaminathan','madrasipanditji@gmail.com','1981-07-01 00:00:00','Acharya Shri S G Swaminathan\nC-1059/7 C Block\nIndira Nagar\nLucknow 226 016\n(M) 9839120282',NULL,'M58madr','2100-01-01 00:00:00'),(59,'M59','tdr subramanian','tdr.msubramanian@gmail.com','1981-07-01 00:00:00','M.Subramanian\nMeera Subramanian\nPlot No 16 - Dwaraka puri,\nOff Mahadana Street,\nTHIRUVIDAIMARUDUR,\nTanjoore District,Tamilnadu. Pin 612 104.',NULL,'M59tdr.','2100-01-01 00:00:00'),(60,'M60','thangaraman v','thangaraman@gmail.com','1981-07-01 00:00:00','Shri V Raman\nC-199 Indira Nagar\nLucknow 226016\n(M) 9936867200',NULL,'M60than','2100-01-01 00:00:00'),(61,'M61','V SANKAR','vsankar1957@rediffmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(62,'M62','vachani_rajamani@rediffmail.com','vachani_rajamani@rediffmail.com','1981-07-01 00:00:00','Dr V Rajamani\n1/19 New Bahar,\nSahara states\nJankipuramLucknow 226021\n(M) 9935208575 \n(M)Parimala 9451063043',NULL,'M62vach','2100-01-01 00:00:00'),(63,'M63','venkat b n','bnvenkataraman@gmail.com','1981-07-01 00:00:00','Shri B N Venkataraman\nD1/233 Sector F\nJankipuram\nLucknow 226 021\n(M) 7388270901 (Ph) 0522-4072761',NULL,'M63bnve','2100-01-01 00:00:00'),(64,'M64','vijay kumar','herbalvijay@yahoo.co.in','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(65,'M65','violin badri','violin.badri@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(66,'M66','VV Subramanian','v.v.subramanian1948@gmail.com','1981-07-01 00:00:00','Shri V V Subramaniam\n8/109 Indira Nagar\nLucknow 226 016\n(M) 9935378974',NULL,'M66v.v.','2100-01-01 00:00:00'),(67,'M67','yamuna mohanram','yamunamram@gmail.com','1981-07-01 00:00:00',NULL,NULL,NULL,'2100-01-01 00:00:00'),(68,'M68','R S Ramachandran','muthamizhsangamlko@gmail.com','1981-07-01 00:00:00','Shri R S Ramachandran\nMDS-13 Sector G\nLDA Colony Kanpur Road\nLucknow226012\n(M) 9889253963',NULL,'M68muth','2100-01-01 00:00:00');
/*!40000 ALTER TABLE `MSmemmaster` 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 2015-06-16  9:12:33
