-- 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 `AYYmemmaster`
--

DROP TABLE IF EXISTS `AYYmemmaster`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AYYmemmaster` (
  `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=79 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `AYYmemmaster`
--

LOCK TABLES `AYYmemmaster` WRITE;
/*!40000 ALTER TABLE `AYYmemmaster` DISABLE KEYS */;
INSERT INTO `AYYmemmaster` VALUES (1,'A1','Shri Anil Nair','anil.nair@timesgroup.com','1981-07-01 00:00:00','Shri Anil Nair\n2/314 B, Viram Khand\nGomti Nagar\nLucknow 226 010',NULL,NULL,'2100-01-01 00:00:00'),(2,'A2','Dr B Sekar','sekar_b2001@yahoo.co.in','1981-07-01 00:00:00','Dr B Sekar\nB-2133 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(3,'A3','balasubramanian sekar ','muthamizhsangamlko@gmail.com','1981-07-01 00:00:00','Dr B Sekar\nB-2133 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(4,'A4','Dr. T Damodaran s/o Shri G Thukkaram','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',NULL,NULL,'2100-01-01 00:00:00'),(5,'A5','Shri K R Ganapathy','krg5393@gmail.com','1981-07-01 00:00:00','Shri K R Ganapathy\nD-1385/4 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(6,'A6','Shri G. Kesoraam','ganapathy.kesoram@timesgroup.com','1981-07-01 00:00:00','Shri G. Kesoraam\n306 Garden View Apartments\n8, Rana Pratap Marg\nLucknow 226 001',NULL,NULL,'2100-01-01 00:00:00'),(7,'A7','Shri K R Gopalakrishnan','gopal.krishna@sbi.co.in','1981-07-01 00:00:00','Shri K R Gopalakrishnan\nN-453/A Aashiana Colony\nLucknow 226012',NULL,NULL,'2100-01-01 00:00:00'),(8,'A8','Shri K P Ravindran','ravindran96@gmail.com','1981-07-01 00:00:00','Shri K P Ravindran\nMM S 1/83 Sector A,\nSBI Colony\nJankipuramLucknow 226 021',NULL,NULL,'2100-01-01 00:00:00'),(9,'A9','Shri K R Subramaniam','s.kozimuttam@gmail.com','1981-07-01 00:00:00','Shri K R Subramaniam\n1/145 C, Vishwas Khand\nGomti Nagar\nLucknow 226010',NULL,NULL,'2100-01-01 00:00:00'),(10,'A10','Shri K Vaidyanathan','k.vaidyanathan@rediffmail.com','1981-07-01 00:00:00','Shri K Vaidyanathan\nMM B-1/86 SBI Colony\nSitapur Road Yojna\nLucknow 226021',NULL,NULL,'2100-01-01 00:00:00'),(11,'A11','Shri Kesoraam G ','raamganesh1@gmail.com','1981-07-01 00:00:00','Shri G. Kesoraam\n306 Garden View Apartments\n8, Rana Pratap Marg\nLucknow 226 001',NULL,NULL,'2100-01-01 00:00:00'),(12,'A12','Shri N Sukumaran','nsukumaran1948@gmail.com','1981-07-01 00:00:00','Shri N Sukumaran\n2/69 Rajani Khand\nSharada Nagar\nLucknow226002',NULL,NULL,'2100-01-01 00:00:00'),(13,'A13','Shri N K Omankuttan','kuttan.aditya1963@gmail.com','1981-07-01 00:00:00','Shri N K Omankuttan\n1/570 Vishal Khand,\nGomti Nagar\nLucknow 226 010',NULL,NULL,'2100-01-01 00:00:00'),(14,'A14','Shri S Vijay Kumar SBI','s.v.kumar@sbi.co.in','1981-07-01 00:00:00','Shri S Vijay Kumar\n18/573 Indira Nagar\nLucknow 226 016',NULL,NULL,'2100-01-01 00:00:00'),(15,'A15','Shri S Vijay Kumar Gmail','sbisvijay@gmail.com','1981-07-01 00:00:00','Shri S Vijay Kumar\n18/573 Indira Nagar\nLucknow 226 016',NULL,NULL,'2100-01-01 00:00:00'),(16,'A16','Acharya Shri S G 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',NULL,NULL,'2100-01-01 00:00:00'),(17,'A17','Shri B N Venkataraman','bnvenkataraman@gmail.com','1981-07-01 00:00:00','Shri B N Venkataraman\nD1/233 Sector F\nJankipuram\nLucknow 226 021',NULL,NULL,'2100-01-01 00:00:00'),(18,'A18','Shri V V Subramaniam','v.v.subramanian1948@gmail.com','1981-07-01 00:00:00','Shri V V Subramaniam\n8/109 Indira Nagar\nLucknow 226 016',NULL,NULL,'2100-01-01 00:00:00'),(19,'A19','Shri S Jayaraman','info@bnvenkat.com','1981-07-01 00:00:00','Shri S Jayaraman\nC-142/A-4 Mahanagar\nLucknow 226006',NULL,NULL,'2100-01-01 00:00:00'),(20,'A20','Shri V S N Krishnan','info@bnvenkat.com','1981-07-01 00:00:00','Shri V S N Krishnan\nA-106, Rohtas Apartments\nVikas Nagar\nLucknow 226 022',NULL,NULL,'2100-01-01 00:00:00'),(21,'A21','Shri K D N Sharma','info@bnvenkat.com','1981-07-01 00:00:00','Shri K D N Sharma\nH-195, South City\nLucknow 226 012',NULL,NULL,'2100-01-01 00:00:00'),(22,'A22','Shri K Vishwanathan','info@bnvenkat.com','1981-07-01 00:00:00','Shri K Vishwanathan\nL-166 Sector E\nLDA Colony, Kanpur Road\nLucknow 226012',NULL,NULL,'2100-01-01 00:00:00'),(23,'A23','Shri K Ganesh','info@bnvenkat.com','1981-07-01 00:00:00','Shri K Ganesh\nD-497, Deep Kunj\nLDA colony, Manasarover\nLucknow 226005',NULL,NULL,'2100-01-01 00:00:00'),(24,'A24','Shri K S Mani Pillai','info@bnvenkat.com','1981-07-01 00:00:00','Shri K S Mani Pillai\nArora Poultry Products Ltd\n119 Patel Nagar Alambagh\nLucknow 226005',NULL,NULL,'2100-01-01 00:00:00'),(25,'A25','Shri D K Jagannathan','info@bnvenkat.com','1981-07-01 00:00:00','Shri D K Jagannathan\nL-11/2 Sector G\nLDA Colony Kanpur Road\nLucknow 226012',NULL,NULL,'2100-01-01 00:00:00'),(26,'A26','Shri V Vishwanathan','info@bnvenkat.com','1981-07-01 00:00:00','Shri V Vishwanathan\nD-1/222 Sector F\nJankipuram\nLucknow 226021',NULL,NULL,'2100-01-01 00:00:00'),(27,'A27','Shri V Rajendran','info@bnvenkat.com','1981-07-01 00:00:00','Shri V Rajendran\nS/o Late Sri S V Iyer\n551K/0 MS-24, Shakti Nagar\nAlambaghLucknow 226 005',NULL,NULL,'2100-01-01 00:00:00'),(28,'A28','Shri Sai Venkatesh','info@bnvenkat.com','1981-07-01 00:00:00','Shri Sai Venkatesh\nB-17, Sector E\nAliganj\nLucknow 226024',NULL,NULL,'2100-01-01 00:00:00'),(29,'A29','Shri R Shivaraman','info@bnvenkat.com','1981-07-01 00:00:00','Shri R Shivaraman\nD-1/264 Sector F\nJankipuram\nLucknow 226021',NULL,NULL,'2100-01-01 00:00:00'),(30,'A30','Dr V Rajamani','info@bnvenkat.com','1981-07-01 00:00:00','Dr V Rajamani\n1/19 New Bahar,\nSahara states\nJankipuramLucknow 226021',NULL,NULL,'2100-01-01 00:00:00'),(31,'A31','Smt Rama Vasudevan','info@bnvenkat.com','1981-07-01 00:00:00','Smt Rama Vasudevan\nC-214 Nirala Nagar\nLucknow 226020',NULL,NULL,'2100-01-01 00:00:00'),(32,'A32','Shri M V Suresh','info@bnvenkat.com','1981-07-01 00:00:00','Shri M V Suresh\nWarehouse Supervisor\nH&R Johnson (I) Ltd\n555, GA/82 Barabirwa, Alambagh,Lucknow 226005',NULL,NULL,'2100-01-01 00:00:00'),(33,'A33','Shri Narayanan Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri Narayanan Nair\nMM-4/34 Vinay Khand\nGomti Nagar\nLucknow226010',NULL,NULL,'2100-01-01 00:00:00'),(34,'A34','Shri Shri V V Mohan Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri Shri V V Mohan Nair\n2/79 Vishwas Khand\nGomti Nagar\nLucknow226010',NULL,NULL,'2100-01-01 00:00:00'),(35,'A35','Shri R K Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri R K Nair\nD-15/1 Paper Mill Colony\nNishat Ganj\nLucknow226006',NULL,NULL,'2100-01-01 00:00:00'),(36,'A36','Shri V Kumar Swamy','info@bnvenkat.com','1981-07-01 00:00:00','Shri V Kumar Swamy\nC-10/10 Paper Mill Colony\nNishat Ganj\nLucknow226006',NULL,NULL,'2100-01-01 00:00:00'),(37,'A37','Shri S Parameshwaran','info@bnvenkat.com','1981-07-01 00:00:00','Shri S Parameshwaran\n\'Kartik Sadan\'\nG-241, Indralok Colony\nKrishna NagarLucknow226005',NULL,NULL,'2100-01-01 00:00:00'),(38,'A38','Shri R S Ramachandran','info@bnvenkat.com','1981-07-01 00:00:00','Shri R S Ramachandran\nMDS-13 Sector G\nLDA Colony Kanpur Road\nLucknow226012',NULL,NULL,'2100-01-01 00:00:00'),(39,'A39','Shri S P Sesha sayee','info@bnvenkat.com','1981-07-01 00:00:00','Shri S P Sesha sayee\nC-1/388 Sector F\nJankipuram\nLucknow226021',NULL,NULL,'2100-01-01 00:00:00'),(40,'A40','Shri A K Natarajan','info@bnvenkat.com','1981-07-01 00:00:00','Shri A K Natarajan\n15/132 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(41,'A41','Shri H Venkataraman','info@bnvenkat.com','1981-07-01 00:00:00','Shri H Venkataraman asof June 15\n3/195 Vinay Khand\nVidhayak Puram\nGomti Nagar\nLucknow 226010',NULL,'A41info','2100-01-01 00:00:00'),(42,'A42','Shri P R S Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri P R S Nair\nSavi Sadan, Azad Lane\nSubhani Khera\nTelibaghLucknow226010',NULL,NULL,'2100-01-01 00:00:00'),(43,'A43','Shri K K Janardhan Nambiar','info@bnvenkat.com','1981-07-01 00:00:00','Shri K K Janardhan Nambiar\n2/130 Vinay Khand\nGomti Nagar\nLucknow226010',NULL,NULL,'2100-01-01 00:00:00'),(44,'A44','Shri P  Radhakrishnan Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri P  Radhakrishnan Nair\nD-11/388 Sector C\nSitapur Road Yojna\nJankipuramLucknow226021',NULL,NULL,'2100-01-01 00:00:00'),(45,'A45','Shri Ravindran Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri Ravindran Nair\nB-121/1 RDSO Colony\nManak Nagar\nLucknow226011',NULL,NULL,'2100-01-01 00:00:00'),(46,'A46','Shri P N Rajasekaran','info@bnvenkat.com','1981-07-01 00:00:00','Shri P N Rajasekaran\n2/271 Viram Khand\nGomti Nagar\nLucknow226010',NULL,NULL,'2100-01-01 00:00:00'),(47,'A47','Shri Ramesh Kurup','info@bnvenkat.com','1981-07-01 00:00:00','Shri Ramesh Kurup\nF-6 Sarojini Nagar\nLucknow226008',NULL,NULL,'2100-01-01 00:00:00'),(48,'A48','Shri Mohan Iyer','info@bnvenkat.com','1981-07-01 00:00:00','Shri Mohan Iyer\nC-93/5 Rajajipuram\nLucknow226017',NULL,NULL,'2100-01-01 00:00:00'),(49,'A49','Shri Rajeev Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri Rajeev Nair\nE-991 Sector C\nSitapur Road Yojna\nJankipuramLucknow226021',NULL,NULL,'2100-01-01 00:00:00'),(50,'A50','Shri A K Parasannan','info@bnvenkat.com','1981-07-01 00:00:00','Shri A K Parasannan\n11/14 Indralok Hydel Colony\nKrishna Nagar\nLucknow226005',NULL,NULL,'2100-01-01 00:00:00'),(51,'A51','Shri Anil C Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri Anil C Nair\nMM/1/856 Vinay Khand\nGomit Nagar\nLucknow226010',NULL,NULL,'2100-01-01 00:00:00'),(52,'A52','Smt Geeta R Nair','info@bnvenkat.com','1981-07-01 00:00:00','Smt Geeta R Nair\nMM D-479 L D A Colony\nKanpur Road\nLucknow226012',NULL,NULL,'2100-01-01 00:00:00'),(53,'A53','Shri K R A Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri K R A Nair\n3/890, Ashirvad\nELDECO, Udayan II\nLucknow226012',NULL,NULL,'2100-01-01 00:00:00'),(54,'A54','Shri Gopa Kumar','info@bnvenkat.com','1981-07-01 00:00:00','Shri Gopa Kumar\nB-39 Sarojini Nagar\nLucknow226008',NULL,NULL,'2100-01-01 00:00:00'),(55,'A55','Shri C Devendran','info@bnvenkat.com','1981-07-01 00:00:00','Shri C Devendran\nC-84 Sarojini Nagar\nLucknow226008',NULL,NULL,'2100-01-01 00:00:00'),(56,'A56','Shri C P Ravindran','info@bnvenkat.com','1981-07-01 00:00:00','Shri C P Ravindran\n10/213 Vikas Nagar\nLucknow226022',NULL,NULL,'2100-01-01 00:00:00'),(57,'A57','Shri Radhakrishnan','info@bnvenkat.com','1981-07-01 00:00:00','Shri Radhakrishnan\nA-16, Sarojini Nagar\nLucknow226008',NULL,NULL,'2100-01-01 00:00:00'),(58,'A58','Shri V G Sankaran','info@bnvenkat.com','1981-07-01 00:00:00','Shri V G Sankaran\nA-921/7 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(59,'A59','Shri C S Pillai','info@bnvenkat.com','1981-07-01 00:00:00','Shri C S Pillai\n893, Ashirvad\nELDECO, Udayan II\nLucknow226012',NULL,NULL,'2100-01-01 00:00:00'),(60,'A60','Shri Chandra Swamy','info@bnvenkat.com','1981-07-01 00:00:00','Shri Chandra Swamy\nMadras Hospital\nAlambagh\nLucknow226005',NULL,NULL,'2100-01-01 00:00:00'),(61,'A61','Shri Ramesh Menon','info@bnvenkat.com','1981-07-01 00:00:00','Shri Ramesh Menon\nG-193 Sector C\nMaha nagar\nLucknow226006',NULL,NULL,'2100-01-01 00:00:00'),(62,'A62','Shri J R Girijavallabh Menon','info@bnvenkat.com','1981-07-01 00:00:00','Shri J R Girijavallabh Menon\n339 Indian Institute of Management, Sitapur Road\nLucknow226013',NULL,NULL,'2100-01-01 00:00:00'),(63,'A63','Shri P K Suresh','info@bnvenkat.com','1981-07-01 00:00:00','Shri P K Suresh\n1/9 Shivji Puram\nSector 14 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(64,'A64','Shri Madhusudan Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri Madhusudan Nair\nBilawa Raiway Colony\nAlambagh\nLucknow226005',NULL,NULL,'2100-01-01 00:00:00'),(65,'A65','Shri A Vasudevan Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri A Vasudevan Nair\n\'Anu Niwas\'\nUthratia Near Sardar Patel Dental College\nRae Bareli RoadLucknow226014',NULL,NULL,'2100-01-01 00:00:00'),(66,'A66','Shri V Chandra sekaran','info@bnvenkat.com','1981-07-01 00:00:00','Shri V Chandra sekaran\n11,IIM Colony\nArbind Nagar\nSitapur RoadLucknow226013',NULL,NULL,'2100-01-01 00:00:00'),(67,'A67','Shri Devenandan','info@bnvenkat.com','1981-07-01 00:00:00','Shri Devenandan\n339 Indian Institute of Management, Sitapur Road\nLucknow226013',NULL,NULL,'2100-01-01 00:00:00'),(68,'A68','Shri Raj Mohan','info@bnvenkat.com','1981-07-01 00:00:00','Shri Raj Mohan\n311 IIM Campus\nSitapur Road\nLucknow226013',NULL,NULL,'2100-01-01 00:00:00'),(69,'A69','Shri Raju kuttan Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri Raju kuttan Nair\nSreeniketan\n958P Morus Enclave Colony Campus\nFaruki NagarLucknow226002',NULL,NULL,'2100-01-01 00:00:00'),(70,'A70','Shri Achutha Panikar','info@bnvenkat.com','1981-07-01 00:00:00','Shri Achutha Panikar\nC-75 Gahama Kunj\nChinhat\nLucknow226019',NULL,NULL,'2100-01-01 00:00:00'),(71,'A71','Shri Chandrasekaran Pillai','info@bnvenkat.com','1981-07-01 00:00:00','Shri Chandrasekaran Pillai\nELDECO Colony\nNear SGPGI\nLucknow',NULL,NULL,'2100-01-01 00:00:00'),(72,'A72','Shri Gopa kumar Pillai','info@bnvenkat.com','1981-07-01 00:00:00','Shri Gopa kumar Pillai\nSitapur Road Yojana\nJankipuram\nLucknow226021',NULL,NULL,'2100-01-01 00:00:00'),(73,'A73','Shri V Chandran','info@bnvenkat.com','1981-07-01 00:00:00','Shri V Chandran\nA-727 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(74,'A74','Shri Ravi Santhanam','info@bnvenkat.com','1981-07-01 00:00:00','Shri Ravi Santhanam\n4-D North wing\nShalimar Heights\nJopling RoadLucknow226001',NULL,NULL,'2100-01-01 00:00:00'),(75,'A75','Shri Krishnamoorthy','info@bnvenkat.com','1981-07-01 00:00:00','Shri Krishnamoorthy\n53-102, ELDECO Apartments\nKursi Road\nLucknow226022',NULL,NULL,'2100-01-01 00:00:00'),(76,'A76','Shri Venu K','info@bnvenkat.com','1981-07-01 00:00:00','Shri Venu K\nNear Bal Vikas School\nKumahar Mani\nTelibaghLucknow226002',NULL,NULL,'2100-01-01 00:00:00'),(77,'A77','Shri C P Sukumaran','info@bnvenkat.com','1981-07-01 00:00:00','Shri C P Sukumaran\n18/326 Indira Nagar\nLucknow226016',NULL,NULL,'2100-01-01 00:00:00'),(78,'A78','Shri T R G Nair','info@bnvenkat.com','1981-07-01 00:00:00','Shri T R G Nair\nP-158/1 GFA, Cantonment,\nLucknow 226002',NULL,'A78info','2100-01-01 00:00:00');
/*!40000 ALTER TABLE `AYYmemmaster` 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  2:57:45
