/* SQLyog Enterprise - MySQL GUI v7.02 MySQL - 5.5.0-m2-community : Database - paramount ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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' */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`paramount` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `paramount`; /*Table structure for table `area_master` */ DROP TABLE IF EXISTS `area_master`; CREATE TABLE `area_master` ( `area_name` varchar(200) NOT NULL, `branch_name` varchar(200) DEFAULT NULL, `username` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`area_name`), KEY `area_master_branch_master` (`branch_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `area_master` */ insert into `area_master`(`area_name`,`branch_name`,`username`,`status`,`curedatetime`) values ('Bank More','Dhanbad','admin','Active','2010-04-14 12:21:50'),('JNU Compas','Delhi','admin','Active','2010-04-16 10:59:21'),('Koker bagh','Ranchi','admin','Active','2010-04-17 11:23:30'),('Puranma','Sonebdhra','rakesh','Active','2010-04-17 11:22:38'),('sg highway','Ahemadabad','admin','Active','2010-04-22 18:19:29'),('Soti mahala','Aurangabad','admin','Active','2010-04-14 12:21:38'),('South aurangabd','Aurangabad','admin','Active','2010-04-14 12:21:16'),('South Delhi','Aurangabad','admin','Active','2010-04-14 12:19:57'),('XYZ','Pune','admin','Active','2010-04-17 10:58:26'); /*Table structure for table `basement` */ DROP TABLE IF EXISTS `basement`; CREATE TABLE `basement` ( `basement` varchar(300) NOT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`basement`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `basement` */ insert into `basement`(`basement`,`userid`,`status`,`curedatetime`) values ('3rd','admin','Active','2010-04-14 13:49:32'),('AAAAAAAAA','admin','Active','2010-04-03 11:48:30'),('ABNDV','admin','Active','2010-04-14 13:49:10'),('PKoytr','admin','Active','2010-04-14 13:49:23'); /*Table structure for table `branch_master` */ DROP TABLE IF EXISTS `branch_master`; CREATE TABLE `branch_master` ( `zone_branch_name` varchar(200) NOT NULL, `zone_name` varchar(200) DEFAULT NULL, `username` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`zone_branch_name`), KEY `branch_master_zone_master` (`zone_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `branch_master` */ insert into `branch_master`(`zone_branch_name`,`zone_name`,`username`,`status`,`curedatetime`) values ('CST','Kanpur','admin','Active','2010-03-23 18:14:11'),('Gujrat','West Zone','admin','Active','2010-04-22 18:18:14'),('Patana Kankar bagh','New Area','admin','Active','2010-04-01 12:21:52'); /*Table structure for table `channel_master` */ DROP TABLE IF EXISTS `channel_master`; CREATE TABLE `channel_master` ( `channel_name` varchar(200) NOT NULL, `channel_cost` varchar(200) DEFAULT NULL, `channel_datefrom` date DEFAULT NULL, `channel_dateto` date DEFAULT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`channel_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `channel_master` */ insert into `channel_master`(`channel_name`,`channel_cost`,`channel_datefrom`,`channel_dateto`,`userid`,`status`,`curedatetime`) values ('Go Gurgaon','50000','2010-04-01','2011-03-31','admin','Active','2010-03-27 18:24:45'); /*Table structure for table `customer` */ DROP TABLE IF EXISTS `customer`; CREATE TABLE `customer` ( `id` varchar(300) NOT NULL, `customer_name` varchar(2000) DEFAULT NULL, `group_name` varchar(500) DEFAULT NULL, `contactno` varchar(500) DEFAULT NULL, `address1` varchar(200) DEFAULT NULL, `address2` varchar(200) DEFAULT NULL, `address3` varchar(200) DEFAULT NULL, `address4` varchar(200) DEFAULT NULL, `contactperson` varchar(200) DEFAULT NULL, `telephoneno` varchar(200) DEFAULT NULL, `faxno` varchar(200) DEFAULT NULL, `email` varchar(200) DEFAULT NULL, `area` varchar(2000) DEFAULT NULL, `username` varchar(200) DEFAULT NULL, `customer_status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `customer` */ insert into `customer`(`id`,`customer_name`,`group_name`,`contactno`,`address1`,`address2`,`address3`,`address4`,`contactperson`,`telephoneno`,`faxno`,`email`,`area`,`username`,`customer_status`,`curedatetime`) values ('Cus0000001','Haldiram Bhujia','1','9875643213','ASDGHH','IOYUIYIUYUIY','MBNMBNMBM','8998989','011-2365897','Mr. Haldiram','011-4785698','haldi@haldiram.com','BAD','admin','Active','2010-03-27 16:12:38'); /*Table structure for table `daily_status` */ DROP TABLE IF EXISTS `daily_status`; CREATE TABLE `daily_status` ( `daily_id` varchar(300) NOT NULL, `daily_km` varchar(200) DEFAULT NULL, `daily_visit_time` varchar(200) DEFAULT NULL, `daily_sitename` varchar(2000) DEFAULT NULL, `daily_siteid` varchar(2000) DEFAULT NULL, `daily_rentoffered` varchar(2000) DEFAULT NULL, `daily_suggestions` varchar(2000) DEFAULT NULL, `daily_status` varchar(200) DEFAULT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, `daily_minutes_ofmeeting` varchar(200) DEFAULT NULL, `daily_action` varchar(200) DEFAULT NULL, `daily_when` varchar(200) DEFAULT NULL, `daily_where` varchar(200) DEFAULT NULL, `daily_why` varchar(200) DEFAULT NULL, `daily_with` varchar(200) DEFAULT NULL, `daily_LOISEND` varchar(200) DEFAULT NULL, `daily_LOI_received` varchar(200) DEFAULT NULL, `daily_signed_agreement` varchar(200) DEFAULT NULL, `daily_reason` varchar(200) DEFAULT NULL, `daily_sitearea` varchar(200) DEFAULT NULL, `daily_when_dulicatedate` date DEFAULT NULL, `site_email` varchar(100) DEFAULT NULL, `site_alternate_id` varchar(100) DEFAULT NULL, `site_wedsite` varchar(100) DEFAULT NULL, `daily_sitearea_lakhs` varchar(100) DEFAULT NULL, `daily_renttype` varchar(100) DEFAULT NULL, `daily_owner` varchar(200) DEFAULT NULL, `daily_owner_address` varchar(200) DEFAULT NULL, `daily_needfullinformationfromtosend` varchar(100) DEFAULT NULL, `daily_needfullinformationfrom_received` varchar(100) DEFAULT NULL, `daily_DueDiligenceFormToBeSent` varchar(100) DEFAULT NULL, `daily_DueDiligenceFormReceived` varchar(100) DEFAULT NULL, `daily_AgreementToBeSent` varchar(100) DEFAULT NULL, `daily_SignedAgreementReceived` varchar(100) DEFAULT NULL, `daily_bikeclosing_reading` varchar(100) DEFAULT NULL, `daily_basement` varchar(500) DEFAULT NULL, `daily_ground` varchar(500) DEFAULT NULL, `daily_upperfloor` varchar(500) DEFAULT NULL, `daily_footfall` varchar(200) DEFAULT NULL, `daily_sitestatus` varchar(300) DEFAULT NULL, `daily_IBS` varchar(500) DEFAULT NULL, `daily_outdoor` varchar(500) DEFAULT NULL, `daily_zone` varchar(500) DEFAULT NULL, `daily_district` varchar(500) DEFAULT NULL, `daily_circle` varchar(500) DEFAULT NULL, `daily_area` varchar(500) DEFAULT NULL, `daily_reading_commingfrom` varchar(200) DEFAULT NULL, `daily_closing_goinhto` varchar(100) DEFAULT NULL, `daily_designation` varchar(100) DEFAULT NULL, `daily_directno` varchar(100) DEFAULT NULL, `daily_officeno` varchar(100) DEFAULT NULL, `daily_customer_address1` varchar(500) DEFAULT NULL, `daily_customer_address2` varchar(400) DEFAULT NULL, `daily_customer_address3` varchar(300) DEFAULT NULL, `daily_customer_address4` varchar(300) DEFAULT NULL, `daily_contactperson` varchar(100) DEFAULT NULL, PRIMARY KEY (`daily_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `daily_status` */ insert into `daily_status`(`daily_id`,`daily_km`,`daily_visit_time`,`daily_sitename`,`daily_siteid`,`daily_rentoffered`,`daily_suggestions`,`daily_status`,`userid`,`status`,`curedatetime`,`daily_minutes_ofmeeting`,`daily_action`,`daily_when`,`daily_where`,`daily_why`,`daily_with`,`daily_LOISEND`,`daily_LOI_received`,`daily_signed_agreement`,`daily_reason`,`daily_sitearea`,`daily_when_dulicatedate`,`site_email`,`site_alternate_id`,`site_wedsite`,`daily_sitearea_lakhs`,`daily_renttype`,`daily_owner`,`daily_owner_address`,`daily_needfullinformationfromtosend`,`daily_needfullinformationfrom_received`,`daily_DueDiligenceFormToBeSent`,`daily_DueDiligenceFormReceived`,`daily_AgreementToBeSent`,`daily_SignedAgreementReceived`,`daily_bikeclosing_reading`,`daily_basement`,`daily_ground`,`daily_upperfloor`,`daily_footfall`,`daily_sitestatus`,`daily_IBS`,`daily_outdoor`,`daily_zone`,`daily_district`,`daily_circle`,`daily_area`,`daily_reading_commingfrom`,`daily_closing_goinhto`,`daily_designation`,`daily_directno`,`daily_officeno`,`daily_customer_address1`,`daily_customer_address2`,`daily_customer_address3`,`daily_customer_address4`,`daily_contactperson`) values ('DSI0000001','3000','2am','abc121 ','Loc0000023','5666','xcvxcv','Close','admin','Active','2010-04-15 15:17:28','cvxzvx','cvxcvcxv','00-00-0000','NA','NA','NA','Yes','Yes','No','xzcvzxvczxcv','450','0000-00-00','pradeep@adnig.com','anc@yahoo.com','www.com','20','PerMonth','prashant','Palam vihar gurgaon\r\n','No','No','No','Yes','No','Yes','50000','3rd;','BBB;dxvcxvxcvxcv;','Qxvxcvxcvxcvcxv;TRUEW;','34262666','GGGGGGGGGG;SSSSSS;','AS002;HHH;TQ009;','SART@@@;TPOOOR;','Kanpur','Dhanbad','CST;kaka;','Bank;','delhi','allahanbad','Punka','098836352','564545454456456','dsfsdf','dsfsdgfsdgg',NULL,'sdfsdf',NULL),('DSI0000002','400','2pm','South delhi ','Loc0000003','44','cxvxcvcxvcxv','TurnOff','admin','Active','2010-04-15 15:20:56','xcvxcv','cxvxcv','00-00-0000','NA','NA','NA','Yes','Yes','No','xcvcxvxcv','45','0000-00-00','dfg@yahoo.com','dfg@yahoo.com','yahoo.com','22','PerMonth','Prashant','Dhanbad bank more\r\n','Yes','Yes','No','Yes','No','No','500','3rd;AAA;','BBB;dxvcxvxcvxcv;','Qxvxcvxcvxcvcxv;TRUEW;','2','GGGGGGGGGG;SSSSSS;','HHH;TQ009;','SART@@@;TPOOOR;','Kanpur','Dhanbad','kaka;','Bank;','deo','aurangabad','Punka','098836352','564545454456456','dsfsdf','dsfsdgfsdgg','sdfsdf','sdfsdf','prashant'),('DSI0000003','400','2am','Patana over bridge ','Loc0000012','77','cxvxcvxcv','TurnOff','admin','Active','2010-04-15 15:26:36','xcvxc','vxcvxcvcxv','00-00-0000','NA','NA','NA','No','No','No','zxczxczxcxzc','130','0000-00-00','ashish.pandey@adnig.com','ashish.pandey@adnig.com','gmail.com','34543543','PerMonth','prashnat','Dhanbad bank more\r\n','No','No','No','No','No','No','700','rd;AAA;AAA;ABNDV;','BB;dxvcxvxcvxcv;ASDFGG;BBB;','xvxcvxcvxcvcxv;TRUEW;Qxvxcvxcvxcvcxv;TRUEW;','vcbvcb','GGGGGGGGG;SSSSSS;ABBBBB;GGGGGGGGGG;','HH;TQ009;HHH;TQ009;','ART@@@;TPOOOR;SART@@@;TPOOOR;','Kanpur','Aurangabad','aka;CST;kaka;','ank;Soti;South;','gaya','dhanbad','Punka','098836352','564545454456456','dsfsdf','dsfsdgfsdgg','sdfsdf','sdfsdf','prashant'),('DSI0000004','123','5pm','malvika ','Loc0000025','17777','gagagagagga','Close','rakesh','Active','2010-04-17 16:29:36','abababab','gagagagagag','00-00-0000','NA','NA','NA','No','No','No','na','50','0000-00-00','malvika@adnig.com','malvika1@yahoo.com','adnig.com','2','PerMonth','malik','palam vihar','No','No','No','No','No','No','453','ABNDV;PKoytr;','ASDFGG;BBBBBBBBBB;','CCC;Qxvxcvxcvxcvcxv;','123121','ABBBBB;GGGGGGGGGG;','AS002;HHH;','by ashish;by prashant;','North Bihar','Aurangabad','kaka;','Soti;South;','abdc','mahruli','Punka','098836352','564545454456456','dsfsdf','dsfsdgfsdgg','sdfsdf','sdfsdf','prashant'),('DSI0000005','3000','2am','abc121 ','Loc0000023','5666','xcvxcv','TurnOff','admin','Active','2010-04-19 11:42:39','cvxzvx','cvxcvcxv','00-00-0000','NA','NA','NA','Yes','Yes','No','cxvxcvxcvxcv','450','0000-00-00','pradeep@adnig.com','dfg@yahoo.com','dgf.com','20','PerMonth','prashant','Palam vihar gurgaon','No','Yes','Yes','Yes','Yes','No','345','3rd;','BBB;dxvcxvxcvxcv;','CCC;','34262666','GGGGGGGGGG;SSSSSS;','HHH;TQ009;','SART@@@;TPOOOR;','Kanpur','Aurangabad','CST;','BAS;','dfgdfgdfg','gdfgdf','Punka','098836352','564545454456456','dsfsdf','dsfsdgfsdgg','sdfsdf','sdfsdf','prashant'),('DSI0000006','3000','2am','abc121 ','Loc0000023','5666','xcvxcv','TurnOff','admin','Active','2010-04-19 11:45:21','cvxzvx','cvxcvcxv','00-00-0000','NA','NA','NA','Yes','Yes','No','dfgdfgdfg','450','0000-00-00','pradeep@adnig.com','dfg@yahoo.com','dgf.com','20','PerMonth','prashant','Palam vihar gurgaon','No','Yes','Yes','Yes','Yes','No','43543','3rd;','BBB;dxvcxvxcvxcv;','CCC;','34262666','GGGGGGGGGG;SSSSSS;','HHH;TQ009;','SART@@@;TPOOOR;','Kanpur','Aurangabad','CST;','BAS;','dfgdfgdfg','dfgdfg','Punka','098836352','564545454456456','dsfsdf','dsfsdgfsdgg','dsfsd','sdfsdf','prashant'),('DSI0000007','3000','2am','abc121 ','Loc0000023','5666','xcvxcv','TurnOff','admin','Active','2010-04-19 11:56:43','cvxzvx','cvxcvcxv','00-00-0000','NA','NA','NA','Yes','Yes','No','cxzvxcv','450','0000-00-00','pradeep@adnig.com','dfg@yahoo.com','dgf.com','20','PerMonth','prashant','Palam vihar gurgaon','No','Yes','No','Yes','Yes','Yes','56','3rd;','BBB;dxvcxvxcvxcv;','CCC;','34262666','GGGGGGGGGG;SSSSSS;','HHH;TQ009;','SART@@@;TPOOOR;','Kanpur','Aurangabad','CST;','BAS;','gdfgdfg','dfgdfgdfg','Punka','098836352','564545454456456','dsfsdf','dsfsdgfsdgg','dsfsd','sdfsdf','prashant'),('DSI0000008','123','12','Luck ','Loc0000028','654564 ','fasdfasd','Follow-Up','admin','Active','2010-04-19 18:10:24','asd','fasdfasdf','19-04-2010','sdfasd','asdfasdf','fasdf','Yes','No','No','NA','54','2010-04-19','sdfg@dfg.qwer','sdfg@sdfg.ert','dfsgsdf','4','PerMonth','sdfaasd','asdfasdf','Yes','No','Yes','No','Yes','No','234','AAAAAAAAA;','ASDFGG;','CCCBBBBBBBBBBBBBBBB;','54','GGGGGGGGGG;','AS002;','by ashish;','Kanpur','Aurangabad','CST;','Soti;','asdfasd','asdf','sdfgsdfg','65456','65464564','sdfsdf','sdfasdf','dfgsdfg','wwe','asdfasdf'),('DSI0000009','234','23','Luck ','Loc0000028','654564 ','fasdfasd','Close','admin','Active','2010-04-19 18:10:47','asd','fasdfasdf','00-00-0000','sdfasd','asdfasdf','fasdf','Yes','No','No','asdfasdf','4','0000-00-00','sdfg@dfg.qwer','sdfg@sdfg.ert','dfsgsdf','54','PerPerson','sdfaasd','asdfasdf','Yes','No','Yes','No','Yes','No','2323','AAAAAAAAA;','ASDFGG;','CCCBBBBBBBBBBBBBBBB;','54','GGGGGGGGGG;','AS002;','by ashish;','Kanpur','Aurangabad','CST;','Soti;','sdfg','fgdfg','sdfgsdfg','65456','65464564','sdfsdf','sdfasdf','dfgsdfg','wwe','asdfasdf'),('DSI0000010','2300','','Subhiksha ','Loc0000029','54000','','Select Status','admin','Active','2010-04-22 18:31:13','','','00-00-0000','NA','NA','NA','Yes','No','No','NA','50','0000-00-00','kurwai1@gmail.com','kurwai1@gmail.com','google.com','1','PerPerson','Adani','Adani Cop. Ltd','No','No','No','No','No','No','2400','3rd;','ASDFGG;','CCCBBBBBBBBBBBBBBBB;','5000','ABBBBB;','AS002;','by ashish;','West Zone','Ahemadabad','Gujrat;','sg;','mall','home','Manager','9893158902','0987654321','15/2','chankya puri','ahmdabad','gujrat','Sanjay'); /*Table structure for table `distric` */ DROP TABLE IF EXISTS `distric`; CREATE TABLE `distric` ( `distric` varchar(300) NOT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`distric`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `distric` */ insert into `distric`(`distric`,`userid`,`status`,`curedatetime`) values ('Ahemadabad','admin','Active','2010-04-22 18:18:31'),('Aurangabad','admin','Active','2010-04-03 10:48:46'),('Delhi','admin','Active','2010-04-16 10:59:02'),('Dhanbad','admin','Active','2010-04-03 10:49:28'),('Gaya','admin','Active','2010-04-03 10:49:17'),('Pune','admin','Active','2010-04-17 10:57:51'),('Ranchi','admin','Active','2010-04-17 11:23:15'),('Sonebdhra','rakesh','Active','2010-04-17 11:22:24'); /*Table structure for table `employee` */ DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `employee_id` varchar(300) NOT NULL, `employee_firstname` varchar(200) DEFAULT NULL, `employee_secondname` varchar(200) DEFAULT NULL, `employee_gender` varchar(2000) DEFAULT NULL, `employee_age` varchar(200) DEFAULT NULL, `employee_bloodgroup` varchar(200) DEFAULT NULL, `employee_address1` varchar(2000) DEFAULT NULL, `employee_address2` varchar(200) DEFAULT NULL, `employee_address3` varchar(200) DEFAULT NULL, `employee_address4` varchar(2000) DEFAULT NULL, `employee_mobile` varchar(200) DEFAULT NULL, `employee_alternatenumber` varchar(200) DEFAULT NULL, `employee_telephone` varchar(2000) DEFAULT NULL, `employee_state` varchar(200) DEFAULT NULL, `employee_city` varchar(200) DEFAULT NULL, `employee_location` varchar(2000) DEFAULT NULL, `employee_email` varchar(200) DEFAULT NULL, `employee_salary` varchar(200) DEFAULT NULL, `employee_total_expereriance` varchar(2000) DEFAULT NULL, `employee_education` varchar(200) DEFAULT NULL, `employee_additionalinfo` varchar(200) DEFAULT NULL, `employee_user` varchar(200) DEFAULT NULL, `employee_pass` varchar(200) DEFAULT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `employee_dateofbirth` date DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, `employee_fathername` varchar(200) DEFAULT NULL, `employee_contactno` varchar(200) DEFAULT NULL, `employee_addresscity` varchar(200) DEFAULT NULL, `employee_addressstate` varchar(200) DEFAULT NULL, `employee_officialemail` varchar(200) DEFAULT NULL, `employee_persinalemail` varchar(200) DEFAULT NULL, `employee_present_address1` varchar(200) DEFAULT NULL, `employee_present_address2` varchar(200) DEFAULT NULL, `employee_present_address3` varchar(200) DEFAULT NULL, `employee_present_address4` varchar(200) DEFAULT NULL, `employee_present_contactno` varchar(200) DEFAULT NULL, `employee_present_city` varchar(200) DEFAULT NULL, `employee_present_state` varchar(200) DEFAULT NULL, `employee_present_officialemail` varchar(200) DEFAULT NULL, `employee_present_persinalemail` varchar(200) DEFAULT NULL, `employee_workingcircle` varchar(200) DEFAULT NULL, `employee_timeofbirth` varchar(200) DEFAULT NULL, `employee_placeofbirth` varchar(200) DEFAULT NULL, `employee_zone` varchar(100) DEFAULT NULL, PRIMARY KEY (`employee_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `employee` */ insert into `employee`(`employee_id`,`employee_firstname`,`employee_secondname`,`employee_gender`,`employee_age`,`employee_bloodgroup`,`employee_address1`,`employee_address2`,`employee_address3`,`employee_address4`,`employee_mobile`,`employee_alternatenumber`,`employee_telephone`,`employee_state`,`employee_city`,`employee_location`,`employee_email`,`employee_salary`,`employee_total_expereriance`,`employee_education`,`employee_additionalinfo`,`employee_user`,`employee_pass`,`userid`,`status`,`employee_dateofbirth`,`curedatetime`,`employee_fathername`,`employee_contactno`,`employee_addresscity`,`employee_addressstate`,`employee_officialemail`,`employee_persinalemail`,`employee_present_address1`,`employee_present_address2`,`employee_present_address3`,`employee_present_address4`,`employee_present_contactno`,`employee_present_city`,`employee_present_state`,`employee_present_officialemail`,`employee_present_persinalemail`,`employee_workingcircle`,`employee_timeofbirth`,`employee_placeofbirth`,`employee_zone`) values ('PEI0000003','rakesh','roshan','Male','32','A+','zxc','xzcxz','cxzcxzc','xzcxz','234234234sdfsd','234234234','234234fsdfdsfdsf','NA','sdfsdfdfsfdsdf','sdfsd','NA@yahoo.com','34534543','dsfdsfsdfsdfsd','dfsdfdsf','sdfdsf','rakesh','123','admin','Active','2010-04-13','2010-04-03 17:19:05','late munshi','xzcxzcxzc','cxzc','xzcxz','NA','xzcxzcxzc','xzc','xzcxzc','xzcxz','xzcxzc','cxzcxzc','xzcxzcxzc','xzc','zcxzc','NA','a;kaka;CST;kaka;ka;kaka;CST;kaka;','dsfdsf','sdfsdf','Kanpur'),('PEI0000004','Sohann','mishara','Male','42','A-','dsf','fsdf','sdfsd','fsdfsdf','354345345','345345345','435345','NA','dsfgsdfdsf','sdfdsf','NA@yahoo.com','5345435345','45','fgfdgdfgf','fgdfgdfg','sohan','123456','admin','Active','2010-04-13','2010-04-10 15:01:09','Mr. shohan lal','423523453','gvdfg','dfgfd','NA','gdfg@yahoo.com','sdfsdf','dsfsdf','sdfsd','fsdfsd','234234234','dsfdsf','sdfsdf','sdf@yahoo.com','NA','aka;kaka;','3am','delhi','Kanpur'); /*Table structure for table `employee_reference` */ DROP TABLE IF EXISTS `employee_reference`; CREATE TABLE `employee_reference` ( `employee_referenceid` int(11) NOT NULL AUTO_INCREMENT, `employee_id` varchar(200) DEFAULT NULL, `employee_image` blob, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`employee_referenceid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /*Data for the table `employee_reference` */ insert into `employee_reference`(`employee_referenceid`,`employee_id`,`employee_image`,`curedatetime`) values (1,'PEI0000001','\0JFIF\0,,\0\0\0C\0\n \n \n \r\r  \0C  \r \r\0,\"\0\0\0\0\0\0\0\0\0\0\0\0 \n \0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n \0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0 \0\0?\0g~OR{=;AAj>~Q5bF2 4Sџ\"Y\0ޞ=@ɏ ?\"TX1H$\']7⅓fF s=5k7?N(ȩQǵ|]\n-bv>xV+kgQD>~Yd\'k\Z{3QOCHH c=7J9V…])2 9#52ɲ*)A)\0sڍd?\0\0O& Psϡ0) Rx❷?0b0N S-qלӊ4ۭQ7cn$%Ґr 1N\\$\nHna\'1R~n8┩=1LBub@*\\ ь\ns>ip3]篭&\\D`\08 aI\':p8Bg~#ZQFw1+xY4=~\')峽Y-WhP\0QZ\0~1OUw6ݾq;(ʙˣnUP Unޕ,*F7}}q)XBkzֿj-ԭ$ϒ 9,@7 _b}*6!b\\ex9I\Z>\'s2̈Bblqұ\'ҭ>;H,檤516 B>#h܁j&߆=87Q91} S,` Ӹ4/(b@֖K97%R\"ti;*8=?2A\Zbx+X\n|COO$xU=` dT??E>i2Bۏ96s֜?Jf׃@EB0(3A #TNqA^}i8ǰ\0sP]7ʐ6ӳ)ʠzMЫ(#~#A*% kld8=[ _Hϳ+4,K樒njlIrk3Yfq:[~sy=}Ywv%sSe#\0%0O\\#}YdcCYB0q5:[(Y8tXK\\^6o#DWm,tIO=ޫaY]NqRE%@pv`s+j~\nԼ:U=Чq3< CJ`-J#] Gɏzurn,cYF&M_z䈦5!UjiGs\0Ng;1!I;_\0_>Q!aؑ`O|}Rk\roP{\02j}}̢VП\' OT*rcpRW?bmL\0XeiZ8/a[it=+ԋ妄5KPbg|{ֆ;Zxd:b}Oqޝch9@2}}i9A+ XjN$Ye$sz\nI`\"t ^xUHlG\Z.Cplu7߇QinOqƒs9d|#.Y*j/$Y#t1~D۫`wҾU@ }#rp+f۹ KR#R:d8د[3`Ua}+B\r1@ϖ1UUmDxmQ?d/NP538f~5#6qȜ #^q^\r)\0V3S=Vr)nSQ|+Ӥg%kg2\rpw.AuHI=BF3X=c?\0ytN@0\r|n}iRJ0l(a\'o8T[}R{e::5R,?ZpVhUujw,zLKl8ic, >dlcov.]eo\" @$$ KC縯mȼv~{WbQSE\"qWM;S9^kehr1\'R#䂧5=1S*wE>U\'8 s.ga>إ#⋊Ãcvp:SUp:q\'֤ۧZn~\0!zeڃ\0J`\rRqRU7|I?K߰ҹk] efi~ocRyKʞFI\ZtolL at\nsHBl;\r=JSʁY?Q__Fm+O5`@\\+\"5&rGl[[;O2˲]Vq\n!~n\\ח^;h=N4oZjH5\Z1]=\rv lRZvǭqMųScυ\nhtR{χgZRç@+ma$&\Z|Q:M6@&Xh{䚽 jϹa F?\ZR\0b7HHRD8ܪI\0j83Y2vMȋN$\'\'ڱ/K$sީK\'T)+V 03u ֽ:dk&$.T:;)#ωn^$r 0p2.O_>w1d¼ru-w7c5%zi ABHg_F{?³RKs!\0H\'NG*wzuy\\KGqjsekSd>S)Bqǭ&H)848#8zӭ5T Qgڜ\'=^F\r95q)O&2F;Sp=Nhtd2sK$ԡ\0ɤ(@x1S#/>/Ŀh^@e< ă^~%l;q|r\njC{;^mPF w\'.o{9d*~^p?4oiD޵bZ>)UϢ=ohp\0kB^~>ZıE$R rOvyi$rUFṴej\0iK\'6:]÷5\0b}\0\rwF7#c xМ>T5*\'SjOJYD|ֿQ`U> hl+2;_(\0ԯ6 Ɔ+\n58Eϊ3xqVr=\']Cg=FiBs׵=FCfm9#Sc]6jn#;Nq7pi29hrvQ׿4ḓ6O\'׵=A\r!Ah\"\0PH#Ҥe1b;=Fs4\\HH 4#3C0텥c!eOۊFES> W\'q\Z G^u~֚iT;X[濳@oJGI jd8$ؗnV~M4Oqvw9l62k񶫧VW!0s_Thׇ߳tVy$$*~\0Y]ptR^Q>*SR7Ǎ-gY\0z_l}W:a qb9FKHoB|ƼJo{9!X̎q6yR$ңOV} xAMr6B+4\Z?B*\n Oӓ^W?c՝(:c=z ͿG.ï s1\ns^h\\Tv^GHC\" N3jwsG/nMCPȾTїevKs3Lc_?u\rx~P|m!k[Grq^\'+]: aVwDFaS]@a䟽SsحܢC<̿x*E{\0&x -.ChGBQ~\"db/f)Lkӭv(Y\nP0ktq= .T?xsJ:dW?>_cdy\"ܛ+abW?van|e{R»Աc+gic3Ęw\0kGоHFYk/q(m-̶2=Kvm=!Q>J,f62惶d9Jӂ֜]Mw@ӂ|*Aiu-s(ҕrK-o̾ay5x_QXO8^%-cUz2IGS?wF=k\rJS-zE{ .{uɥߺ gziّӧdž`{+^ zcMPZy. l_TisC,k෨=>A]%E3k7=+)*¾n>\Z% \'D<b[νC~h^H24s^){srg >i>G_OѝKn|6q[߅%rsڟA4Tr1^>~ˌ{k6+=9)JGHh!F7c\'4*\0MP)sg\'ʙ2VFC0^@܅?SO07dOO( N\r(E!ٍ jStLpo@>Vգ- B.Q_> kkowj.asʸ6J־?0Q}SQʊfл0!T{$q4Mi[@-#\'gҼe-6yFIX9aQ3sr)tr1Y_cw8`pz\'a/;w!{zި :YǴpԃ$M\\Sך6-;ۜNcpI8\np9Ivr)A5$~(sSIoC|\0\n`*IN\"\0:\\Zmɣ9◭@O\'JFZa\'Ҁ rMy7_\0j-C76*2q^\ZPe4s.t*GcU)Ae(Tt3 ȕs֕Џ EEifWYXl=k&iZ)w!RhJu_.d[>չ^XL:N2\'x͠:)ȫ1A``UA ecmY %r%%s\ZK/a;k>s[Z s l8=\\}ݴOMԇjWFܟ5xq5|TwW;H!$qKrJB&ҫ\\m@IgI+z)-ȓn쫢7~6\rhBǠ|։mi\Z؀t$XḸ3QWFT}+N!b?HAB\0Ʊ5\r$ƅ\\k_:vaY\'ԏzЊ\\zBqL\"R8hLr~_OJt]b|Ҥ)]R1\0\0f~Ie,:S[c\0X\05 t0jSO=h|`G}\rAwgEԚYܑYwVdcQOW;_6koA\\㢷\nSw _]l9dG=b턓 WE*GajAڨc/hG7qŤd,Q Ooz7MX1Zl\0I(\r`_OU,-i|`c>JZ+¾?sRN͝ S]H҃{WcwC$sF-S8 oQ@h(p\'48wmg\0@H8$wFJ[q|co_نVֆ[9UƾyW) devӆ8\'R[>m;*i3\'PH\0;DU#$\Z&uawV\'Iw9tB\0m,qgc;ޥxɜͿ؅{?L)Ynp;W%h^5v7534ʂ0;$o.~\n֊e?|Vw!oEapʱEq.8\0Zֵ)5VE 0WZ|055mgK5xٞQH]4kWv(׬ϟQii(g@8Z)2=hD:M[JIP\0j\"\05G \r0G=:\Z˸d;+!e`F+2[UR:g㈒Ӳ9-z-H޺*%XFՑ62nu)#O.5^@n>E\0Rw4\0S]\r Kmq▃HVh!X[+xe[pMnt\"Z)(+:8.>jyT/U.%V2F0G֟g,m&K1ڭ艊C\Z=q*gtl1-쳘dW%ur~)\ZK\nWA\ZEnuq|塐sS/N{gs]f==qrvўԵDu9+>$#8\'ֲ/QރIܥwYƹѸt_l7 /R7#a` $aqڳQm<ѧ9;X>hMoEp6\0^\nKu<~\\\'\0B5ZN-@vd а\0\n@I=1^G23i#,VdjZ$3}Ί{v(h_M.7pF~\'=xldT~VnLtLV7@2GJu մ[}Z٣|\Z麖u$WdJqp⾂of:\\kuI\0OrW+s t%il|tk\';v\r\\֯5KAWcNu~ l^7+}z^~<?`B73Ooz]GOmlI\rZxZAki !~^WJ$]֧b1ND3|-e nWj;J+U6P ۟-IfɌ!j\rիw {TB\\rz6#c\\iQT@Fs0\r-O#Pe 1V\ZlRFdzd1L qFmޭK[=j-x\\qvM4tEJ.ZIFIEAF2\ZYbjJJM\\j1?Eo7{W\0@G˜+R?1i-u̻}Ze2pKV[7tKEP (\0(\0(&W){j}Dz\'{FAz))ǡb\0\n 袊`QE\0r?|0uYm:09p:g|-I,Nz.vX\0\rwV><ө+?շҝH˹H97bB٫VEԒEk\0?ʧW Xwj\r*DR$rzb%Q@((8Bj>u8Ӯ5#F\"q٬eʮexdd=m.;vz U\0k}yG&$,IݱR֖wAd(y1QLC\0(\0(\0(\0h\0X~o: Cң^#*Cc\"Z(Q@Q@Q@QIҖTJ3Lt;1QE\n(\n(0Rmx:ϛjQpТ:]T(H 8(h\0(\0(\0(I\'\0ws#ԕZ͕`MYIYl$Zn\0TRBrԮD\nAJt\'(QE\0QE\0QE\0QMVݞ\r:+D\rcSJm![nHDx|К(AEPEPH:Z`,5-١!sW5C׌T moQIi&e&:įy($ 㠪W;*S6-QHAEPEPc0 0FE-!K`\nRIL\Z}%sE?6_OEP (\0(\0lqɥ#9RQE%\\ ԋq +  *J`-Q@((1~%Op++Kj>m@nHm{UM0b91uChUpjKw09K l Řnp\0=+RZQJ;pnx=L}k/#[-Zbh:TSOMTR)3Hri(\0\'4\r\'{hVEs֣3R$j),nˮs.:l-[M[mP$!GJ; NNkLp`9ԅ\0ptt\r8L]QE\n(\n(\n(#z\0-S7>jD_2R\\1\0z\n&Aa*fR=ET+cd&(b\n(\n($6PN=jԐj wz[#hr[ F(a9?1\nv?CgU]jB58n4Ƴ#Տ\rijxJyUe5gPH\'\Z0i煈wooZBƫG5EtdJkCR4ycPzSM((\0) =)=E9&rZj+ Md\\~$%lTg6jz|(R\r\0x:ErpZ]( (\0n>`rq\0(QOޭpwW*JF\Z AW튔\rVx 8BQLAEPEPYTf殸\rg\n~tmd:{yIج\rIbգq27E4Wc3HZROjA<#\r5 ֻd\'ijuiqPlVޢc+\n(\n(u5\r{VdH,\0jz(R\rOj~4QL]EQE\0QE\0QE\0V>Eg\rU>c袯(Q@Q@\rk8hƍhg+\r3z(:1Lv*|o','2010-04-01 17:07:07'),(2,'PEI0000002','\0JFIF\0,,\0\0\0C\0\n \n \n \r\r  \0C  \r \r\0,\"\0\0\0\0\0\0\0\0\0\0\0\0 \n \0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n \0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0 \0\0?\0g~OR{=;AAj>~Q5bF2 4Sџ\"Y\0ޞ=@ɏ ?\"TX1H$\']7⅓fF s=5k7?N(ȩQǵ|]\n-bv>xV+kgQD>~Yd\'k\Z{3QOCHH c=7J9V…])2 9#52ɲ*)A)\0sڍd?\0\0O& Psϡ0) Rx❷?0b0N S-qלӊ4ۭQ7cn$%Ґr 1N\\$\nHna\'1R~n8┩=1LBub@*\\ ь\ns>ip3]篭&\\D`\08 aI\':p8Bg~#ZQFw1+xY4=~\')峽Y-WhP\0QZ\0~1OUw6ݾq;(ʙˣnUP Unޕ,*F7}}q)XBkzֿj-ԭ$ϒ 9,@7 _b}*6!b\\ex9I\Z>\'s2̈Bblqұ\'ҭ>;H,檤516 B>#h܁j&߆=87Q91} S,` Ӹ4/(b@֖K97%R\"ti;*8=?2A\Zbx+X\n|COO$xU=` dT??E>i2Bۏ96s֜?Jf׃@EB0(3A #TNqA^}i8ǰ\0sP]7ʐ6ӳ)ʠzMЫ(#~#A*% kld8=[ _Hϳ+4,K樒njlIrk3Yfq:[~sy=}Ywv%sSe#\0%0O\\#}YdcCYB0q5:[(Y8tXK\\^6o#DWm,tIO=ޫaY]NqRE%@pv`s+j~\nԼ:U=Чq3< CJ`-J#] Gɏzurn,cYF&M_z䈦5!UjiGs\0Ng;1!I;_\0_>Q!aؑ`O|}Rk\roP{\02j}}̢VП\' OT*rcpRW?bmL\0XeiZ8/a[it=+ԋ妄5KPbg|{ֆ;Zxd:b}Oqޝch9@2}}i9A+ XjN$Ye$sz\nI`\"t ^xUHlG\Z.Cplu7߇QinOqƒs9d|#.Y*j/$Y#t1~D۫`wҾU@ }#rp+f۹ KR#R:d8د[3`Ua}+B\r1@ϖ1UUmDxmQ?d/NP538f~5#6qȜ #^q^\r)\0V3S=Vr)nSQ|+Ӥg%kg2\rpw.AuHI=BF3X=c?\0ytN@0\r|n}iRJ0l(a\'o8T[}R{e::5R,?ZpVhUujw,zLKl8ic, >dlcov.]eo\" @$$ KC縯mȼv~{WbQSE\"qWM;S9^kehr1\'R#䂧5=1S*wE>U\'8 s.ga>إ#⋊Ãcvp:SUp:q\'֤ۧZn~\0!zeڃ\0J`\rRqRU7|I?K߰ҹk] efi~ocRyKʞFI\ZtolL at\nsHBl;\r=JSʁY?Q__Fm+O5`@\\+\"5&rGl[[;O2˲]Vq\n!~n\\ח^;h=N4oZjH5\Z1]=\rv lRZvǭqMųScυ\nhtR{χgZRç@+ma$&\Z|Q:M6@&Xh{䚽 jϹa F?\ZR\0b7HHRD8ܪI\0j83Y2vMȋN$\'\'ڱ/K$sީK\'T)+V 03u ֽ:dk&$.T:;)#ωn^$r 0p2.O_>w1d¼ru-w7c5%zi ABHg_F{?³RKs!\0H\'NG*wzuy\\KGqjsekSd>S)Bqǭ&H)848#8zӭ5T Qgڜ\'=^F\r95q)O&2F;Sp=Nhtd2sK$ԡ\0ɤ(@x1S#/>/Ŀh^@e< ă^~%l;q|r\njC{;^mPF w\'.o{9d*~^p?4oiD޵bZ>)UϢ=ohp\0kB^~>ZıE$R rOvyi$rUFṴej\0iK\'6:]÷5\0b}\0\rwF7#c xМ>T5*\'SjOJYD|ֿQ`U> hl+2;_(\0ԯ6 Ɔ+\n58Eϊ3xqVr=\']Cg=FiBs׵=FCfm9#Sc]6jn#;Nq7pi29hrvQ׿4ḓ6O\'׵=A\r!Ah\"\0PH#Ҥe1b;=Fs4\\HH 4#3C0텥c!eOۊFES> W\'q\Z G^u~֚iT;X[濳@oJGI jd8$ؗnV~M4Oqvw9l62k񶫧VW!0s_Thׇ߳tVy$$*~\0Y]ptR^Q>*SR7Ǎ-gY\0z_l}W:a qb9FKHoB|ƼJo{9!X̎q6yR$ңOV} xAMr6B+4\Z?B*\n Oӓ^W?c՝(:c=z ͿG.ï s1\ns^h\\Tv^GHC\" N3jwsG/nMCPȾTїevKs3Lc_?u\rx~P|m!k[Grq^\'+]: aVwDFaS]@a䟽SsحܢC<̿x*E{\0&x -.ChGBQ~\"db/f)Lkӭv(Y\nP0ktq= .T?xsJ:dW?>_cdy\"ܛ+abW?van|e{R»Աc+gic3Ęw\0kGоHFYk/q(m-̶2=Kvm=!Q>J,f62惶d9Jӂ֜]Mw@ӂ|*Aiu-s(ҕrK-o̾ay5x_QXO8^%-cUz2IGS?wF=k\rJS-zE{ .{uɥߺ gziّӧdž`{+^ zcMPZy. l_TisC,k෨=>A]%E3k7=+)*¾n>\Z% \'D<b[νC~h^H24s^){srg >i>G_OѝKn|6q[߅%rsڟA4Tr1^>~ˌ{k6+=9)JGHh!F7c\'4*\0MP)sg\'ʙ2VFC0^@܅?SO07dOO( N\r(E!ٍ jStLpo@>Vգ- B.Q_> kkowj.asʸ6J־?0Q}SQʊfл0!T{$q4Mi[@-#\'gҼe-6yFIX9aQ3sr)tr1Y_cw8`pz\'a/;w!{zި :YǴpԃ$M\\Sך6-;ۜNcpI8\np9Ivr)A5$~(sSIoC|\0\n`*IN\"\0:\\Zmɣ9◭@O\'JFZa\'Ҁ rMy7_\0j-C76*2q^\ZPe4s.t*GcU)Ae(Tt3 ȕs֕Џ EEifWYXl=k&iZ)w!RhJu_.d[>չ^XL:N2\'x͠:)ȫ1A``UA ecmY %r%%s\ZK/a;k>s[Z s l8=\\}ݴOMԇjWFܟ5xq5|TwW;H!$qKrJB&ҫ\\m@IgI+z)-ȓn쫢7~6\rhBǠ|։mi\Z؀t$XḸ3QWFT}+N!b?HAB\0Ʊ5\r$ƅ\\k_:vaY\'ԏzЊ\\zBqL\"R8hLr~_OJt]b|Ҥ)]R1\0\0f~Ie,:S[c\0X\05 t0jSO=h|`G}\rAwgEԚYܑYwVdcQOW;_6koA\\㢷\nSw _]l9dG=b턓 WE*GajAڨc/hG7qŤd,Q Ooz7MX1Zl\0I(\r`_OU,-i|`c>JZ+¾?sRN͝ S]H҃{WcwC$sF-S8 oQ@h(p\'48wmg\0@H8$wFJ[q|co_نVֆ[9UƾyW) devӆ8\'R[>m;*i3\'PH\0;DU#$\Z&uawV\'Iw9tB\0m,qgc;ޥxɜͿ؅{?L)Ynp;W%h^5v7534ʂ0;$o.~\n֊e?|Vw!oEapʱEq.8\0Zֵ)5VE 0WZ|055mgK5xٞQH]4kWv(׬ϟQii(g@8Z)2=hD:M[JIP\0j\"\05G \r0G=:\Z˸d;+!e`F+2[UR:g㈒Ӳ9-z-H޺*%XFՑ62nu)#O.5^@n>E\0Rw4\0S]\r Kmq▃HVh!X[+xe[pMnt\"Z)(+:8.>jyT/U.%V2F0G֟g,m&K1ڭ艊C\Z=q*gtl1-쳘dW%ur~)\ZK\nWA\ZEnuq|塐sS/N{gs]f==qrvўԵDu9+>$#8\'ֲ/QރIܥwYƹѸt_l7 /R7#a` $aqڳQm<ѧ9;X>hMoEp6\0^\nKu<~\\\'\0B5ZN-@vd а\0\n@I=1^G23i#,VdjZ$3}Ί{v(h_M.7pF~\'=xldT~VnLtLV7@2GJu մ[}Z٣|\Z麖u$WdJqp⾂of:\\kuI\0OrW+s t%il|tk\';v\r\\֯5KAWcNu~ l^7+}z^~<?`B73Ooz]GOmlI\rZxZAki !~^WJ$]֧b1ND3|-e nWj;J+U6P ۟-IfɌ!j\rիw {TB\\rz6#c\\iQT@Fs0\r-O#Pe 1V\ZlRFdzd1L qFmޭK[=j-x\\qvM4tEJ.ZIFIEAF2\ZYbjJJM\\j1?Eo7{W\0@G˜+R?1i-u̻}Ze2pKV[7tKEP (\0(\0(&W){j}Dz\'{FAz))ǡb\0\n 袊`QE\0r?|0uYm:09p:g|-I,Nz.vX\0\rwV><ө+?շҝH˹H97bB٫VEԒEk\0?ʧW Xwj\r*DR$rzb%Q@((8Bj>u8Ӯ5#F\"q٬eʮexdd=m.;vz U\0k}yG&$,IݱR֖wAd(y1QLC\0(\0(\0(\0h\0X~o: Cң^#*Cc\"Z(Q@Q@Q@QIҖTJ3Lt;1QE\n(\n(0Rmx:ϛjQpТ:]T(H 8(h\0(\0(\0(I\'\0ws#ԕZ͕`MYIYl$Zn\0TRBrԮD\nAJt\'(QE\0QE\0QE\0QMVݞ\r:+D\rcSJm![nHDx|К(AEPEPH:Z`,5-١!sW5C׌T moQIi&e&:įy($ 㠪W;*S6-QHAEPEPc0 0FE-!K`\nRIL\Z}%sE?6_OEP (\0(\0lqɥ#9RQE%\\ ԋq +  *J`-Q@((1~%Op++Kj>m@nHm{UM0b91uChUpjKw09K l Řnp\0=+RZQJ;pnx=L}k/#[-Zbh:TSOMTR)3Hri(\0\'4\r\'{hVEs֣3R$j),nˮs.:l-[M[mP$!GJ; NNkLp`9ԅ\0ptt\r8L]QE\n(\n(\n(#z\0-S7>jD_2R\\1\0z\n&Aa*fR=ET+cd&(b\n(\n($6PN=jԐj wz[#hr[ F(a9?1\nv?CgU]jB58n4Ƴ#Տ\rijxJyUe5gPH\'\Z0i煈wooZBƫG5EtdJkCR4ycPzSM((\0) =)=E9&rZj+ Md\\~$%lTg6jz|(R\r\0x:ErpZ]( (\0n>`rq\0(QOޭpwW*JF\Z AW튔\rVx 8BQLAEPEPYTf殸\rg\n~tmd:{yIج\rIbգq27E4Wc3HZROjA<#\r5 ֻd\'ijuiqPlVޢc+\n(\n(u5\r{VdH,\0jz(R\rOj~4QL]EQE\0QE\0QE\0V>Eg\rU>c袯(Q@Q@\rk8hƍhg+\r3z(:1Lv*|o','2010-04-02 10:28:51'),(3,'PEI0000003','\0JFIF\0\0\0\0\0Exif\0\0MM\0*\0\0\0\0\0\0\0\0\0\0\0\Z\0\0\0\0\0\0\0b\0\0\0\0\0\0\0j(\0\0\0\0\0\0\01\0\0\0\0\0\0\0r2\0\0\0\0\0\0\0i\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Adobe Photoshop 7.0\02009:12:25 18:36:11\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Ġ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\Z\0\0\0\0\0\0\0\0\0\0\0\0(\0\0\0\0\0\0\0\0\0\0\0\0\0&\0\0\0\0\0\0\0\0\0\0\0\0\0H\0\0\0\0\0\0H\0\0\0\0JFIF\0\0H\0H\0\0\0 Adobe_CM\0\0Adobe\0d\0\0\0\0\0    \n    \r \r\r   \0\0\0\"\0\0\0?\0\0\0\0\0\0\0\0\0\0 \n \0\0\0\0\0\0\0\0\0 \n \0 3\0!1AQa\"q2B#$Rb34rC%Scs5&DTdE£t6UeuF\'Vfv7GWgw\05\0!1AQaq\"2B#R3$brCScs4%&5DTdEU6teuFVfv\'7GWgw\0 \0\0?\0r\0?Dow\r.\0ZyF,wɏ1K|O\0=3?hMv6/V#OIKh2w9O0*\05 ntTz~kG\ZX#sv0M9[\'2Ѿ \0k}USoRyL\0+r\rFsMO r-\r\Z~\0Ko;}ON}?\0?\Z\0\0]vm pJXuO-˦ky7ۏnQ[=1,}oWwI6,Zͩ۲85jxe+v]{[__7Uur]O%ԼrJpG]xKG͇2ce +ޓ}LU~fHќI[6}\"\Ztu|o\0IO\07g8x\0?=k\0@醇䲇}g*uufOe=UrʙS\\׆5l\0Maٓ`YwlosUz*-wv~q#E}%\ZÞK}ϳڌ&j~_IZ\np܅~! 9^ά,o]߾Ex7\'\0$z`>o5?,~,nV\0i|2\0?+7?~?G]:UkkS;fs6o[_^E5;Vc>ݞEvZo:K=&\n:xgu+}jͬ,{\Z }XZ.Vs%Q\0\0Η;d81ztKfOQ4}uD1\Z֭\0.`~2ڵUާoo?O S}ux?xiv|n~K{v6khS;77՟t~R>\0}WwNoO9<1H@ݦ)I w{?M)\'x?:dtA-Vpxo{cӱ,$\Z;}Fn`{Q~vDg ]j/yl͞q1\0~kico0X_N3I,p\0[n܍lؒiɷ냋\0\0uWV:yio4m߳n;K70?w+ŽMζnek\r/{Q\\31Hg-k,hGz~\0u8(c@zfR](۳ 餴},\r)\Z5\ZF}?L+-/G\rLPhotoshop 3.0\08BIM%\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\08BIM\0\0\0\0\0\0\0\0\0\0\0\0\0\0\08BIM&\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\08BIM\r\0\0\0\0\0\0\0\08BIM\0\0\0\0\0\0\0\08BIM\0\0\0\0\0 \0\0\0\0\0\0\0\0\08BIM\n\0\0\0\0\0\0\08BIM\'\0\0\0\0\0\n\0\0\0\0\0\0\0\08BIM\0\0\0\0\0H\0/ff\0\0lff\0\0\0\0\0\0\0/ff\0\0\0\0\0\0\0\0\02\0\0\0\0Z\0\0\0\0\0\0\0\0\05\0\0\0\0-\0\0\0\0\0\0\0\08BIM\0\0\0\0\0p\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\08BIM\0\0\0\0\0\0\0\0\0\0@\0\0@\0\0\0\08BIM\0\0\0\0\0\0\0\0\08BIM\Z\0\0\0\0I\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n\0D\0o\0c\0u\0m\0e\0n\0t\0_\06\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0null\0\0\0\0\0\0boundsObjc\0\0\0\0\0\0\0\0\0Rct1\0\0\0\0\0\0\0Top long\0\0\0\0\0\0\0\0Leftlong\0\0\0\0\0\0\0\0Btomlong\0\0\0\0\0\0Rghtlong\0\0\0\0\0\0slicesVlLs\0\0\0Objc\0\0\0\0\0\0\0\0slice\0\0\0\0\0\0sliceIDlong\0\0\0\0\0\0\0groupIDlong\0\0\0\0\0\0\0originenum\0\0\0 ESliceOrigin\0\0\0\rautoGenerated\0\0\0\0Typeenum\0\0\0\nESliceType\0\0\0\0Img \0\0\0boundsObjc\0\0\0\0\0\0\0\0\0Rct1\0\0\0\0\0\0\0Top long\0\0\0\0\0\0\0\0Leftlong\0\0\0\0\0\0\0\0Btomlong\0\0\0\0\0\0Rghtlong\0\0\0\0\0\0urlTEXT\0\0\0\0\0\0\0\0\0nullTEXT\0\0\0\0\0\0\0\0\0MsgeTEXT\0\0\0\0\0\0\0\0altTagTEXT\0\0\0\0\0\0\0\0cellTextIsHTMLbool\0\0\0cellTextTEXT\0\0\0\0\0\0\0\0 horzAlignenum\0\0\0ESliceHorzAlign\0\0\0default\0\0\0 vertAlignenum\0\0\0ESliceVertAlign\0\0\0default\0\0\0 bgColorTypeenum\0\0\0ESliceBGColorType\0\0\0\0None\0\0\0 topOutsetlong\0\0\0\0\0\0\0\nleftOutsetlong\0\0\0\0\0\0\0 bottomOutsetlong\0\0\0\0\0\0\0 rightOutsetlong\0\0\0\0\08BIM\0\0\0\0\0\08BIM\0\0\0\0\0\0\0\08BIM \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0@\0\0 \0\0\0\0\0\0JFIF\0\0H\0H\0\0\0 Adobe_CM\0\0Adobe\0d\0\0\0\0\0    \n    \r \r\r   \0\0\0\"\0\0\0?\0\0\0\0\0\0\0\0\0\0 \n \0\0\0\0\0\0\0\0\0 \n \0 3\0!1AQa\"q2B#$Rb34rC%Scs5&DTdE£t6UeuF\'Vfv7GWgw\05\0!1AQaq\"2B#R3$brCScs4%&5DTdEU6teuFVfv\'7GWgw\0 \0\0?\0r\0?Dow\r.\0ZyF,wɏ1K|O\0=3?hMv6/V#OIKh2w9O0*\05 ntTz~kG\ZX#sv0M9[\'2Ѿ \0k}USoRyL\0+r\rFsMO r-\r\Z~\0Ko;}ON}?\0?\Z\0\0]vm pJXuO-˦ky7ۏnQ[=1,}oWwI6,Zͩ۲85jxe+v]{[__7Uur]O%ԼrJpG]xKG͇2ce +ޓ}LU~fHќI[6}\"\Ztu|o\0IO\07g8x\0?=k\0@醇䲇}g*uufOe=UrʙS\\׆5l\0Maٓ`YwlosUz*-wv~q#E}%\ZÞK}ϳڌ&j~_IZ\np܅~! 9^ά,o]߾Ex7\'\0$z`>o5?,~,nV\0i|2\0?+7?~?G]:UkkS;fs6o[_^E5;Vc>ݞEvZo:K=&\n:xgu+}jͬ,{\Z }XZ.Vs%Q\0\0Η;d81ztKfOQ4}uD1\Z֭\0.`~2ڵUާoo?O S}ux?xiv|n~K{v6khS;77՟t~R>\0}WwNoO9<1H@ݦ)I w{?M)\'x?:dtA-Vpxo{cӱ,$\Z;}Fn`{Q~vDg ]j/yl͞q1\0~kico0X_N3I,p\0[n܍lؒiɷ냋\0\0uWV:yio4m߳n;K70?w+ŽMζnek\r/{Q\\31Hg-k,hGz~\0u8(c@zfR](۳ 餴},\r)\Z5\ZF}?L+-/G\08BIM!\0\0\0\0\0U\0\0\0\0\0\0\0A\0d\0o\0b\0e\0 \0P\0h\0o\0t\0o\0s\0h\0o\0p\0\0\0\0A\0d\0o\0b\0e\0 \0P\0h\0o\0t\0o\0s\0h\0o\0p\0 \07\0.\00\0\0\0\08BIM\0\0\0\0\0\0\0\0\0\0Hhttp://ns.adobe.com/xap/1.0/\0\n\n\n\n\n \n adobe:docid:photoshop:13a4701e-f156-11de-af61-9b44a8f68945\n \n\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\0Adobe\0d\0\0\0\0\0    \n    \r \r\r   \0\0\"\0\0\0\r?\0\0\0\0\0\0\0\0\0\0 \n \0\0\0\0\0\0\0\0\0 \n \0 3\0!1AQa\"q2B#$Rb34rC%Scs5&DTdE£t6UeuF\'Vfv7GWgw\05\0!1AQaq\"2B#R3$brCScs4%&5DTdEU6teuFVfv\'7GWgw\0 \0\0?\0֓\05.\rt_9\00yKvKYA/&DDĎ(\0wrv)\Zru7k~uPc\rML\'136!z7Mclꎑ*\"9&|)[B7e>Whqj}.bt{O~5`~ZuGoޚQSn.@?)*JI[~W}\\7=muZ}gN7\rA:|[]E\Z~\"ߪ&ŘCv!kߞ^==IRYVdٟ$gܐUo!|% =V:~Kޣ9HQ\"#\'Z0\0 Z`4E/F y\0Zݭ{8kQQbGU?Y-f 0~ ӉṌ8.\0[fXϴ]k\01?Vmf[?Eluk:/J?67p zen524De <.\'Psno\n-sFTLm1%u^8c=Crαs)íi;#S2Q7МS@%񑡖A_>eI[T{dV߰\r>?rT}msYƩsKiR{R&OjuHnpd:I?\0V}R&ٵmss2fgA,q;-`˦\Zd~c9q 8c֌4}3(|Ryǭu3zV%_Z>J\\o\\lY%HY}xa∔F:>d8F\0ZoCO$xׄoO\0\'Ig\'ld[O>n~ d:˰0r9xnn<t#H sؔg w͍DqL߬vHu\Z(t1Xå#?4xi&,g\0ZiG@G sx`8a8cGcAϪ&2\Z&<.Ӎ]ncǺ~>ց[G:)*-۠Or\Z\' (Os`Lv8‹?@rm2IAp}&z;\"?-7hNppas1g.\0J`c\0/D\0#*ݑxȿ.2H3 ߸<4$~GrI~qnP\0O!\0\0@y+T&\"cCKT \Z٨TzSz5 @kF+N~ c\r|^!\0\Z~\rq.#cCguF3#<|Za\\\"w\0dSԃK8|/oKVvNc-6 I%Ltq\0y}eF#w -o٘߻_cj?!o7Ѯ+gO\n`%lpǰx#ݎХ vE$\Z5N*ք8I*E$(OI!`))M)-QL,\'NXtZВ%ZВHҀ \'Jĭ \0HII$($I)hNxIEp\'lM AVRJQ<xR0,DkPSEVZHTvI))$ӏtI,tȩI$R<% $BxI:H+$BP2IRI9I$)H\n)*Rp!2*^SILN?I)Ԋt-]$EJN$,I:JX0A^DJHbJDݐR0NJ\\NG@JJXd\"B]S$gUԓWS։ Ӥé\"tTt8$A 4Qna\"b#Tǿt#1\0qju H)(tI{j4FQ \0\0jR-\0v׺Jb@L!DDXi#xPXui}I\'L^tN$%) A.9El9E\0Pݘw0Ӽ)`>cN\'!\0RQ(\np\Zd%\"i#DF)*) yQऄvJI\0xI$RI҈IJN\'@\'HA wR\n)JVg rH&YMT]`3@$\"#^T]&Iڄ(:Tݠה9D S\'LNA%2M$\0rtxe\0IB\'EKjc8LSR9?@Jd؍Tsp~Ri1*M1u]j*V{J!GRӪ(]8L)x4$-OҒ]L($2HRt$2pR)\\$N)GĢ.I4R܄\\r4ɥz`<)I@9>LNZuI7dSӜ$H-\\$I!dI)Id$.\ZLV)$TIIAN:\"ܚSJdW䦔2J)M)iP*E%S@\nXbJI%\0 H$l\"邐LȩE)I(IJ)\'{1WU%Zoӯ82v(J&#&N.S$)$IZi2i r$RYJTO0fHQt4.Qn;6e[kqs⣜t<Îo\\\0wLk{4*D4G)D cH))Dz\reҾ%\rI\ZtvUIр\Zx\'Ne\\6VLݯc1\n^dGH Dt=GAi*jFx7\0\"}*1@tyjNѩW=:u==(=әmN NɈ/ \\-Ш,Gb[۲ז\'ZY 1uԛ[];~P:RVrTn-sCMJ)\0ݣ6ٶL-7@ϒlֲqU7é71ӅA~G@݄D@쒯Spt{Swǫ:^@$_͒A+pum#^ L-el*\0rgWض:}BÕJVmX~) znۺDJIJi|_oR +zm\ZԉKYEmh3ͥba*\Zk4AZpprRC\r%d~KII_f^=f\\.\ZꝚZ\n-ZHG` )0L¬wo\Z\05\'RQ_yvnU3s|Uc\r#H&.hА E(v䲽ADx qU#8Lf?hu6uTH|1znDV(y:V5b4%q=6c5s\\WK2:mݞp ³Ypia0sl0+f69U] *w0 s.܇cN qH *`p(chI.{m!SG+~˺\0yl+VfA{\"<PG0A\Z#W\04yےk*n&L-PL\rهOԩ{S`e\"IhsH2ZO5ɡw?Iտl;/g\0\"{\r.\rqU7[c*`Aq@hajK%]Ta1\Zut赾R}e؍V0<Rfs7M4LoJw%fB\05CΪfc&U\'9ΒdJ\"5uc I\nV9\\N.b#=Hz C`cHo`\\Cȷ97LD9VGmq8wrrꮒ6݁ dTWaU͏\nzm#å ;0ބk$:4M#-] =tYnUv\\HsxHkbS&#~kʬsl\\ֻg&\0k A$s1>>ߎ^=Υb$c O[2kê8FVy`x^ѩ1\'^z\Zi6c\'aaݽqKùJ<~\'O$,+[AIP9\0~\nw? ^5rc/ \'_޽c@ 4[\0\r\080yck\\ #aLjVӺNJ\\G@=?Uߣ{ϼmS,hDoG?XsCeкʷ z+ˮ׵q\03W ]uj HcGtFijvn+;1eٗPVyOh<,g\0iGSm@ ?36z\rS_hXX^mq:ޤ lN_I*x-ir~5k rlM Râs S .uh B0|Ԥٳ#V撈 n{a poH OaVȤ\0ƨ%jca2憛#X\\cMeqhګxn@\Zb `d?C[g,!Ƿ!eg}_${Fs ӓY !<\\*$Tx2mYW&`\0U2 ǚvv-[s@q\ZAPv9Jxq @*Z#8ݺ;qR]Gm͛}]ݱST?xߣC\0j\0^ƮZ$9@aXc\Z;mKJ,ds:0ϛ×eB`vK FQ#PW3GQ-lK+ oۤM!uyag AzF]cd\Z9?\0n|j^.ϲ&Dl\\`Nv:j/t4rΫ[n}Xh71p&A\' xS^QbK|HV(4\rwoK\\ëLvq\'Fp{M ?H]MnF34gccQ[ !uoW*\"]?yy,;v%bܗ1ց*Lj\Z;v\rCy#N\0uMdO@=\\wXK-奮2\n6A{eKA\rԃeB@ԅa^ڪ,Mkp+[ #1c ;\\;4Ӵ8hz=8+BcG\ZBK)rioe,RM-p#B`qg0 0\0P߆LIi1r\Zn~/sr^ vT#wP}+}qskhdgϊq<`<ݮsD\ZQ\r4%mWW_@<݆fЀh۠wJ^D\'EQcC[=+0#rִ\r]\Zv@s:Pxt=ըq k^H\"k >e6oTcݴ3lk?9 *\r}>\ZHM\06H䐭|3`u\\ \\[Ń>flx&5\0$qFEXlַ$)^]]FLsyQF1z޶a1 O l3korq9p&H&WpT[j{mN[߾GU\0^=@048rFCC< *$\Z!ctYK3?6Rm#epo2r|v_ qb7zc\0Иd^.<]XvL\ZB؈\0\0\0-D%-2K[\'m{.X\nSc/hPA6>pcU󗁡sƑ} MimՇZN}\\׭ß$d#rݡ$ߩl􇫳nrk\0\0}cYNK 9sJ#c0k͌$ӧ.!5h]Լ6Pmh1DEȆOs$xtssh\rOt\Zv\0pAn\ZVL\rsJ\rn\ZYj-c@4SoTm-<4fim 2B[=Z9-VT7oU.MKp#HD_ 2\0wd[ v6{XcEu[\ZeWes\0m GĦ\0Skԃ\\2)>m4B>\nO0@Bң\Zs7APMkx\0ldGK:Kq.ѓJU횞H .BokN;cKq\\ی]:9Wh{ui∜Z=SZ,KȻuѸ(f}km~h_þz^ŕMnи4ִXq{o:|PH9!;3,e)TE>-SWkh,r>w՜jˋ/kܳNTh65\'Eohϟ&5;\0IT]>-**W>p ݮ$p{!eDZiF9\nR.A܎Œ ,\0Uî\r j~ g2jF>8uBlq,ACWk*\\=4\"H)]FN~şim߽)++RT4\rv$w*?kA FtsMNx{ḒCM8 \\?{>я>r2Ѕb~j68jQey8Nq==[VC!?8>Ip\\~j_֎x\ryiy pe\'i<*aF&[]\'+8va pՇ\0%6Xp8,ˍrY.<\r7C5p ѭ$b-at wGgR#sakޞuK\"7zmƇ\Zm,\0% &mƲJ罬.\r;O$d\\2;p8lf\"5lԂxc\0RѨ#|nvh0ܽ9ֆ Ns]W\n\n:Uoiש_ɋ/8] pY[ 6\rZ`Js\0%\\3᥋(~M&R\rc VitiwA.!W>(}O$@C$TW)9zI2[gGxEu7n|\0[Occ\'xF&իNX⋇G:a\\Ht !}i$l?c׏,\rWO^Fu6>^> H$+V>S̷!);{\\%{s+xAKJ~1k+*GM\"\ZI) ɂr:xr>È*)ctoӧu[\n5#cI [.Zr&\'z>\r,\\w[+N\Z;u\0\ZV\r֖}O%u=֝%4\"ec،aŭoMWP.ƶ=b[9%c HH0cMGJ674\0\'n֞k-M~+3sms/}΀~3eCj-ط7X\0O ^n|5z-yiD—絶џ:GpxG{حZhC4+BcIpF& p2{*]A$jNP8z/d;QV30l{a[ꕊrhn]\'P4L!D|j6\\sk:Rem\ZǴTCfc,}zAԁF1`}V\\D !K[[6\n5F˛ʼ\ZPumHhvnyI@Kv\0 v- }b̾KH+gGği(N D#\nHϋu_O~RPWܿԱҚ o b!V6ED\r徰qY\"ZGt_i6|v\0xo9SŇก.ߗ*՜ ΰ{_/sNr>S~\"Luh`\Zᡗ|F;vugo6Z5ZNi(Cd8Ҁ\rroWVWpk ,k\r#s]$h\ZR[8FBOCS]/kseW:vNCZb\0\nˋݣ RcwJhVБ\0ىֿGЮ躳7@u+ܖS,\ZBS.3S}s /-Zkc\"(v`Hn@_Q\ZGuOnl\Zz:prX91;ii%|CSD&Jj}U݌iq;A{Dk)ݒ چ*Kd7n?7jfҟ}Y\"kjI|[mJ}!pК!I])$Y.@acey#>̀b<1>: y(.0`:!}76kmŧ\"b5ƥ3[&y\\G&p \"Nk>#ݾ\n\'\'eCβ<[[$(oZdHi_5k\\OL ȳ.`3^ A #E{ٴ\'G./3%v{ou!ήK|?9fgp&ʉ]ݎR\'!^Z@+_@S:텈Znӡt?VZj>{\0sy:dn2?^)\\7TW;#Uvǟ~Ғ|W+b/֮?EV,vZTڏWN@x}dr4SLMlz}`>Ike.âۋsY,\Zu?.c&7l?t@ zvLIZ8u\Zdk/kI`jih>} uk Ek~\nݒ$=}<d4z3>\n gO$ T {\'Ԛxm od*w#XA`߈: AMK1PdHWEa@Ԉ: b4DDq\\uK[7gfWn3^nT%JNOu[e-H F=2\0츍b*y4 R`=~f#_sADújk\Z\r-#D\0X2$}Zvk}B8s 5/\'%uΨz;ig+7$9=:תɃ\0~[lo.p#P;Lӽq:=AQ6-#W7!`uFCmaTnYpN\Zl\n\0=\rR¶Ϣ~AR >||_VujZ}Apuo_^z4s\nˋ $~}Vc@;&=ZTW3ӯ\"$`\ZInaKkIJq9jA^jvB5HY\"[/e\r4H݊;@m}Tj=~mMigVY 8v%KH}`[1>ǼyM <٣O!UUsAia 1[Sde=N2=+Z顅\'\0\r\\\"r o74S[&`UK2{Zw\r6̏- X\ZCL|[is{ɝF;VMkZ.(7{js{$WAl1~{C{cf֏X4n3rpXLr5gP\\%vlxn}~|]]K8wRcK^39D k\\wݧmVEp@Jt]m)$8d7b@@\0z{Yk0zNnelk)N kY,tKcTc[m8LqIiߩNޗNJo;`WmֵF\0µ/¬9!u&Z{#}MaFX~LWUmk@&}?$%XHk YX 0Y܃f äiWWav陇r_^Aﮉ3bMmm\'P`,1Z\ZKˬ`Cut|~M\\A\nUdcUumw3dk@u)k!W`q,S6 :j]E̺qݾxʪstxq]`Lt<ܠ[Z &QՆ >|c,0Aۧ\"UF\r:\n@nzSo&Uvu#`\\ܛx[]o2fǻsOhr+i.ʛ3=SGZ,2 LW*`}.\0C5j~+^\"$*yqh6uB^2XWdUQ-YL}|~l$#׎+\Z 4_ѽӴC8Ӑ,nev_@:;o-3>m2pjJe:ezy2D d!Tj\nauV3:ctFMGi0~j۪s8B&KwQM6;s 7j|QGix~?W`8dƒ6ͨlt$s.#s{wG-@$lDXo8sء<5@T͵kamhۏ5[]vNKf6a$G<\"ˈ\0\"5UAnTcxDuHF\\-x(ed. l8ac\ZO]-d:7Pc2)scr\\#(gÜ=yXVPinW3sr7930Љi8WQ*떎1,.;LFӺmxՆĻMzmx~T *_?(u9|<15zi\0\n+\0pUHEpmNE[1m.\Z+/t,^+J\0h8jmIeowt??һt\\[\Zd~ْyo3\\nL5kkW<2rd;m/[!A5\n\"+#U}h䱹U}|K6S!\ndD\ZCfވ_&m!@ KVGKdݷ˟znvOLa+ZT6>CG`;z⡡\\ueձ#G{mk\r]oXג?GO!\0jx qfG\0Ȥ# =˵acH$ \"Bǝ!|e2 ѿJ: OqQ\n\rA uOR\\hk#tx.m2- GyYGRAR z]\"Ic=?q ^lf-$ipH[Q,?{[ƧUݏC0:cl=`KHs\0.w]Z;<^\0 #-W5=t^\0LTZ\n*企\ZMlqQe唯!a⌷3xҲK|Q[yDֈ\ZNJ<c1Qs]n\0\'#jo;k[ qXYJ,|\ZS` Y~\'/a\"efן^-uֆXLT[iczwE3ّ$K4 =G^͗䱯aRɤ=Eq;V[ic\Z/:תΤ=ޥ9A@SCFsS>]^+_nCx+\rnd>Kr tg-ꁽL;vH[/Դ\\\0Xa-Ιg,ε\\1zrWc(ju[ c.Y ZyL#GG)v5ʶ;~OU!\0Y?s!\0d8;\rppL+.h;+.w9URUlnK~CΚ-ZGaEZ=6ڧfݩG8Ska A,[Xi G*6Zi:?ܟ%Ӭ9*U4ˇz}K 2}Tc X *([#E4\\(:GG\r̬R\\/:~-+(:!>hֽ\"4A3% E̕&}}$ٳ_fla :%qaԳ/\'= N׈&?9tLZZ {8kc <1@. 8[phlf:xf{\0Gt !JI3ՋwȐ4A\rnh^+ȸ\0A\'q\0QXiivM\'!A\"%3\0:&F&OƧc<ͧInuV} KdpNEnav;B0K ӣFG @.4(ycu\0E+S\0:J&\r{2\"o~q[k55G-b.Dp|cID-9L˃I\reOiܮ}5Ϋ{4*0Tl\Z\ZGay$O6TmFx`cu:5@BR6:OD^جɄh\n^ʛ.:3VU7P?Q%#b &]Kr+:VV絘囉xG_u4|{jD0kO%^Ffn|H\\FYMnV:W#55:4\ZΉ8@\Zk!z\nikulr529ݰ~WXHs|漑Ns+4<*Wӏk=vaiB-%Yls_N=x>2qњDHp[kim&X؀5\0ȯ>H^^F9uhO\\]D 0}$R3mѧ[v vI_yN[\0EfdjYVsHٮ߹WZf[U]{VwAމowN9ŬfʫՌm~Q\'B!-v\\7g<|EtVګ\0oG*r5tXav8ssֱn U-pc.h@czXbZG1eƚ۲1#`\r\'Z \'o{+;Rǒ4ق<&Nٛ69DW@aJ6[;\rvSku;/jk\Zɍ$5L&\"X1ޕacN9RȻP*9ơ%(ϭyЀNH#[tO1ȯei!cw9Z}){H*1s@wpecFFJ󞥇n=\ry^}m7˽VKe-\047SBwZ$a!.)I?Jj_k fkY!J[ꚧQ)e6XUQp\'Rnۜ<4kn\0q@=Tz8V԰}6LţuU[[\\;y]MvSnmot^+t.=.nF:k1\rA1uXvrEgcFJpmw_ײ~͆xVO%Yq[vcqH*Ke,unrWtjKkhn>\09n,Nt[~뾗%7#ݺ#VU@ӳrXƐ+Bs\0ЮLg]KO^U~y˸5&4A\Zpas^7NRPX\Zִ(l:ܘf㶓T\n!Jy\0¨ %\n[$˫s\\k|cuyi_VCY\'Y=zyZ k\r_\'Zo|\0CcUH>;5խ}Ywo\rVGˊ\\pHV%\\\0(Z9Qk Yۘ\\A;[Z6Vyetgѻ w{yTPɖψPi,`t\"\0%)x $`quAQQ@\ZMs $5 3\n͖CuqH#@_,y/W/t\07w\09:g?Wvͻ}^IM:Rxq?vﬕeoh\'̮ٷ{._`[^C<9=[}+tD{7(\\$vԼK t %=iZ>qc`f1aTW^]o\nL\rUrO5uE#UҎ^)`>H\n\0JQ1ЏYcG9qS-na\n9DKhX;lsk.䀪oӽEVZOgbȎ+}$B\r/OmY)݉Wѻi|oOـAUj-i\r\"\\\"\n\'L;KHKޥVM>:w~v\r\",kuR\"Rޮ0$d#ðtG5pYb|\rys]Sdzqd]gcflke7\'-ROQ9#|^kȤ׈| y%cÂz\'QV*xhǞO1[y\r?*Hĝo i5,0P2fKv_z?E.ʃ4>Ę (xĠt=^q_=aH`X\Z*ȼc %~S[ cё`$+OWQ5:6 nƤ\n= \rWĦN,(if|>W2}Qөsԟ3Z]ǴBYzU /TzYj\0&+褎˷Omӫ\'kri=#MD*X\"D5A>\nJɲ;cgC JͶABf_L\ZbM\ZIyZVIieOc G6`O#;M -߂!w]^tYN|Y``r6eخ/ Y$7 \0d\"Z:1QK5W=;+\ZYa*@\'ptV:-+]/ X9[.pZUIYP(F[x@\n\0\nX3\03I%+??<]qڇOIVi,yoT׹+])u[tƢő( \Z{\'GtY%$d)A\"&)!q))m?kl~)\'6/?\0S:?%A3΋WrZ \r+4\"LgJΊaÍkO΋\'LH7Λ?gFF, ֗MNi-C虨SĦCFWn0DhxeBVU\"T J 5h˫2[~jU 7Kw? /H%P>Iy?{i5ăUky,>$-ۀJ;cpd\'LBi#EPxQЅ:L)[H\\N.0I$#|]Koq<%v]GC pƇo8\'C{KɲxTLeZʍ3vq OC w% 7vE?he8I|1>ksI&Aj{O/d+ ;PN(b9%5$\n$AyO*Mݖռ9X= 5ЭTܷq>(_I[ȇ UQjwe1^wRJ3G&pوBrU~cl{ u+G|4v\rxKo1oU]8@$[YَJQ 댎Ӊn5V3Ҭ%bɤTtɫՐFXˇ| 0d\"AK$\0‹ȕ!\n/W\'2G -紵`Ccg49\\ VUh vvLHE &)Y䬞zrtv)lnL7%~Z#b֟Փ Y`u6hY܋!ON7ugs48x9h-\"Lx$MaXVP6_\rDdr9K!$,xI%?\n\Z0TLJe\r}%ruu悹SUf}\\\0T/c{5Xp6\'Fur:9DEdY*\0:)oNqڳz\0Cr8ߤm>Jsv]s >A=|*k)aF?xrY}`ZKtcTIu*.un*U+aRtwe8ɣT;umwO::ar$(RPnCb$&E2Uܛ}9eéA].X}ټ+WdPe׊5:\n;uRQ!v*rTӐVqРˊ+B]oYEi腛Ԃ0ܲΏ6 f|gʏL?4xJ&h\"Zg?-}9P+I RMjRꭜy*\0=.aX|Pn-үN8%t\'*D!,:H^y$pƟI\n2@s\'Do3+ջ­9\'V9_3MָUj*%ϖo%HI=i݋AF\n \'w8l;0D,?oT:\r\'/_:j#YiwRG5`;<ǧ<\'y3H|@~HiV\r݈䬠Ƴ!f؇3x+/ۘc!oADtm|B5A\n,D $-?T[;J>vj?O &CC_#n)* xyl5̘`B+L@%`oBq\rY[t\'NbXF< +w\07CjߢZJt7+8=\\gXzWhV!vQ|mroTE#~*9]ºߠnWM0VB~lbs\ZgdH>aY1,oAxZW7uO n/ghVW+?c7u#GIfT:D9M a#!sw7fKpR;OH`[jZVV%iZh.h:]vxp.y)!4?x1ԧ%&,xZ6-oetmLsa<:e?OJϒsu]r]JEG++\'9_v##|iܺgPW?}q]eK Ǜ!^pyJn\'<7ilH\\$I\":c-DZ+y\\zGv4o>\\9@?8QTb\n{l; \r-\'_#G.~lKoc}OWl?Ͽ\0}Hh]ֻi~׉%`A2\ne[bΑg~WVdz(K*n\'pϒ^5Bq \'/[]*AÄnkǁ ?.mە[G[י;4*ck`~;O;p<q݃RUbCҍf\'$~lw\05)“:+]i\'FtH{HB+xpa\0pծ_KW/CF]o\rHG${{\0Q~\nRd/aq(0j*] \0\0LD1MLJmk:Up<ȁϊc*\'tW .͞BRtڣ)z(`vD =3QL݈OUʌ53Sˍ\\/ݐhtG Oe1+VJb^:i*@SQwDnՎҎJ !%A{ꈯs(J\0;fMUWDzŶsHD@;}{]\n#&{\'qe~Mf\\~䰜FU~fyKW1H>37s\nOs;»X;Q2DӞYW@ XYSՁb[<\0 oEE.AnT\\([H`x%AIsAInOv )*_6?<~Ƿ\0Iqnx׶!].;hyQH1s\nɶ~Ơ\'c #TjbCFGuՆ>jEᡎ\Z\08N2fK1\0OUӧOMem`*nˇ3rc&\'[)su<$-Q&THkDS`J 9m]k\\i bV+i.;&tVaPR$8c=6>߫emܰ!Y&|U>M]=q32/XN7F|X3_7mOpI)&Dž:|VMt_[a]NebuvdRAu~rq\Zcl\Z^;b\\޼W\\ѼZ+sָqme-:D qme\\܄z|x{[ȥ 悹ĢhQ]iBYk[ʃKuql \\GfYIn;¬hU\0\0}l~Z_όRL\0W\0_.7^?R1p> Xuomq̘Bxu5ŵ2GX٤8:bk\0ONkH WJ 6=x) 2\'XUavo4 Jʈ UK0Mo-.>R$\'FPikXH-dw(oťד٪7i,$\0Pn=NnSE\n5pR\ZmKHRǵTGi綁\r:htдYeͨGbVSZ\\\0Ub:KC5BXVhtvЯI\r걘5&-ho46װc A\":)s]SD9].F9!lr6+\07I&Wu;\Zwik!p<[XC#]\0GѸD&{.hPqۑi\rk]\Zʘ1*خ~`j0ixiSXN6=A5VC|7?sU|^wk>\\3\062&SjC+%5D\ZQ9!N#|`Gѣ++6acCiЏ4F@ \"{[I?Tpcz?ѤlW4oDL=Qq&hR{d*K#K-#$cb6G\rYwggZƴC\';\Zݨ-?9lQ;\"Gc&6hy;}h0~壴1`i30 ݾkİ4ݐ¨{#HXn\Z \r{*>\0TB.s2q \0k$\0$Ylu®\rTMZpmZ[Oݪ67 !Su\rqydSl9N:hMűTD«n5=U{uJydv c嵿!4&l61vv\\Simv5uU]ұ7]o\Za4P;Op[.BӶ$Ei4:\n/εim\"*m}`hP7zh:Uoi8~JŠs#:{)UgOvc;* -du\"dMuqq߲yDifaփBi1\0\ZhknH:0v 8aA-୚ypmi栗>7vyfu%Sԯco`r,v8+v`WgvZ@,n\Z[~ҁ׭4VX!hApi\"HKL8y#]-æ8J}Z,<󧺫s+}a2$mfӷJoWm6cy9,5<w\ZX.$6*hmc)9+>b֭p7m[-np.mLsva|VgMΪ葀ο~<<;6׵^+FC\Z鑡A`~SA=iʺ,;K<8Ap8H:G˸d{tb(-4yr\ZhFvsm}`$ܗYXH$~ƮZ\0Nޓ̰Ɓ(QJ+7BgZs$&=ܧ\rB9}>ڋ]\"I\\/P\r\ZhƲc[\'D1և\0x:hsSInLhcj|QQk}`?6/h\rTuk{jVŽ#]kmfe17@9W[ORvWd7huTɗO% :`pLQ#\0v7lnmbK/7z)%|?U\0X~vZr,dn&\\?I_+g\"닭{v׉]f@TqC٥OòX׵L몳.cm5-6t!e&0XG>(ik}\\9vVe$jd1;5ݻ\'UJtM]C\'C\'ֵ_:Orlj:\rhѠ*n*i\'#}?]*Zk[h\ZtT~Xs<ΛuRCy.h1#Dc0 DVKd1 s%VK8É셓}8o\"d>--*Ɨ\nOcε7ޭc}}~ļ\0HƓ\'زa-T+SHu\rXOl܀Kg\ZImxÉ3;Y\0u/+k>;,KA]^ȡSnǣ@ac̴:L\\lkl3/[c_ʥO2%DR@\\S%-FiOFc;cX>Af;eH0]\'pJzS3\"fs9Lc}B8\\)ɶٴywu8XmpZtMWngCLOӄ֍)!.N{A2u:\nMn < ן٨s֒ +\r=Ѕ\"QZ@#1гÂZ\rۙMTFDO ZlƪML\r(9 \Z <\nMne2:춓P{ǮiUlRa_ic=IQk*mx\0P`
)c{@{{}懤=Uhy\06@KGBX*9 \Z9. ׎-\'\\NVtK15=<~*VPn#p\ZlLM]|DDwL,{j:)ӛ+ UOV^yTm{4pS@utVVKI vOI\r;VՈM> [a\0;Vd)/cðO0CWtKP|J9Y#p#1zIA AW.8Rl=abV 3tS\Z%V_X=H0TA %ip!&QKHV0qhvE 4@u,Fnwd![g nsp \'t -~ H0\rR\n$%e6a uꪞ}lHZ~k)ng|qs222};\r\"tϳiTǛtOy2@ڭuǚ`*uWWn Eȕc\\\'EmW6eLX kk?r5c\r|mYN͗X&tUu,G|F6wHč­硹`̞+vyg@̛i~pw:(˳ohLh0 [M\\9pƗ\0Ԣ1\ZP6^ vCT)mhcBPt5LI˹ :T-IR|j’(LsNCPYe-;o\ZI=;n:6:NwI$IG{;\0r_cc!s]*t3f{/^s[$Y\nyJ [[.xqz zn@4;\n0\\A2 væ+]WӱCiv&@\\\nČ\\(c\r>nX\Z|BGc|VUͥ^#NfKw)iG =ơGevv_7lys{%Q>՞2i4~\rYy7[k\\\n9Fsڛ%O\05\0DJ|vcN㪍,fV.U{.}Vfunumn\0G|xj8̽1dv?>X/?Ԩa> 8\0.0ps|pN8VY%%8Sv459̨6=&ǂg3<kA[KN}1X&r(e8BKw#3X=_yfmlcckҧ̈a9F1! N bSk\0Q\Zl[EZlo+bSc1~#FC&X(qVŻYNzw\rYO%dU\Zʓ(p\na Ւi0;-vSaպǧal1.~L%_c:Bu@y*g6֗5sGp [(\rfCKkh.:s|΢:XpCX˝39|IiH%Z}1/\r?An&9{\0K7?\0S1m`X%~)}5͡A;H%}-kdȢ?k\Z쎢 |Ŕ7>-W\\AM1WyLg}VɴWV;|`zrO,ޔ(oݪ!Y1_!Ը݋BI6ν\0itkⱸ<̘Y\0Vх0|f##~{1bΜ\\&!Mo\n!H}`Xlp--$L*USk F\"ܶㄯe\0{!8T.3ݯpS\0p\\Wc0+;v(<2\Z&\0\0Pr{gi}gܧKodvγ˜$[=:2\\ێwv@rv>]QSn 8w3%F0$F8pHj>br\05+x\\ޝhQ F6V(nfaV;~dmݱ>uzM\rFTٹ|\Z<U\0}\0,if,9xq88\0Ӈxc!ϒӅعLWi\Z.\0ZlCV8׃[lykGPcJOʰl3*|\0~\0x}\02|w.khQ[hp8c F0,aкIv?j+{xx8OW\\0\\\nztqodrQ/g\0ZE~h~ׇ7?wz\0hnݾ5$M?\0','2010-04-03 17:19:05'),(4,'PEI0000004','\0JFIF\0,,\0\0\0C\0\n \n \n \r\r  \0C  \r \r\0,\"\0\0\0\0\0\0\0\0\0\0\0\0 \n \0\0\0\0}\0!1AQa\"q2#BR$3br \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0\0\0\0\0\0\0\0 \n \0\0\0w\0!1AQaq\"2B #3Rbr\n$4%\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz\0 \0\0?\0g~OR{=;AAj>~Q5bF2 4Sџ\"Y\0ޞ=@ɏ ?\"TX1H$\']7⅓fF s=5k7?N(ȩQǵ|]\n-bv>xV+kgQD>~Yd\'k\Z{3QOCHH c=7J9V…])2 9#52ɲ*)A)\0sڍd?\0\0O& Psϡ0) Rx❷?0b0N S-qלӊ4ۭQ7cn$%Ґr 1N\\$\nHna\'1R~n8┩=1LBub@*\\ ь\ns>ip3]篭&\\D`\08 aI\':p8Bg~#ZQFw1+xY4=~\')峽Y-WhP\0QZ\0~1OUw6ݾq;(ʙˣnUP Unޕ,*F7}}q)XBkzֿj-ԭ$ϒ 9,@7 _b}*6!b\\ex9I\Z>\'s2̈Bblqұ\'ҭ>;H,檤516 B>#h܁j&߆=87Q91} S,` Ӹ4/(b@֖K97%R\"ti;*8=?2A\Zbx+X\n|COO$xU=` dT??E>i2Bۏ96s֜?Jf׃@EB0(3A #TNqA^}i8ǰ\0sP]7ʐ6ӳ)ʠzMЫ(#~#A*% kld8=[ _Hϳ+4,K樒njlIrk3Yfq:[~sy=}Ywv%sSe#\0%0O\\#}YdcCYB0q5:[(Y8tXK\\^6o#DWm,tIO=ޫaY]NqRE%@pv`s+j~\nԼ:U=Чq3< CJ`-J#] Gɏzurn,cYF&M_z䈦5!UjiGs\0Ng;1!I;_\0_>Q!aؑ`O|}Rk\roP{\02j}}̢VП\' OT*rcpRW?bmL\0XeiZ8/a[it=+ԋ妄5KPbg|{ֆ;Zxd:b}Oqޝch9@2}}i9A+ XjN$Ye$sz\nI`\"t ^xUHlG\Z.Cplu7߇QinOqƒs9d|#.Y*j/$Y#t1~D۫`wҾU@ }#rp+f۹ KR#R:d8د[3`Ua}+B\r1@ϖ1UUmDxmQ?d/NP538f~5#6qȜ #^q^\r)\0V3S=Vr)nSQ|+Ӥg%kg2\rpw.AuHI=BF3X=c?\0ytN@0\r|n}iRJ0l(a\'o8T[}R{e::5R,?ZpVhUujw,zLKl8ic, >dlcov.]eo\" @$$ KC縯mȼv~{WbQSE\"qWM;S9^kehr1\'R#䂧5=1S*wE>U\'8 s.ga>إ#⋊Ãcvp:SUp:q\'֤ۧZn~\0!zeڃ\0J`\rRqRU7|I?K߰ҹk] efi~ocRyKʞFI\ZtolL at\nsHBl;\r=JSʁY?Q__Fm+O5`@\\+\"5&rGl[[;O2˲]Vq\n!~n\\ח^;h=N4oZjH5\Z1]=\rv lRZvǭqMųScυ\nhtR{χgZRç@+ma$&\Z|Q:M6@&Xh{䚽 jϹa F?\ZR\0b7HHRD8ܪI\0j83Y2vMȋN$\'\'ڱ/K$sީK\'T)+V 03u ֽ:dk&$.T:;)#ωn^$r 0p2.O_>w1d¼ru-w7c5%zi ABHg_F{?³RKs!\0H\'NG*wzuy\\KGqjsekSd>S)Bqǭ&H)848#8zӭ5T Qgڜ\'=^F\r95q)O&2F;Sp=Nhtd2sK$ԡ\0ɤ(@x1S#/>/Ŀh^@e< ă^~%l;q|r\njC{;^mPF w\'.o{9d*~^p?4oiD޵bZ>)UϢ=ohp\0kB^~>ZıE$R rOvyi$rUFṴej\0iK\'6:]÷5\0b}\0\rwF7#c xМ>T5*\'SjOJYD|ֿQ`U> hl+2;_(\0ԯ6 Ɔ+\n58Eϊ3xqVr=\']Cg=FiBs׵=FCfm9#Sc]6jn#;Nq7pi29hrvQ׿4ḓ6O\'׵=A\r!Ah\"\0PH#Ҥe1b;=Fs4\\HH 4#3C0텥c!eOۊFES> W\'q\Z G^u~֚iT;X[濳@oJGI jd8$ؗnV~M4Oqvw9l62k񶫧VW!0s_Thׇ߳tVy$$*~\0Y]ptR^Q>*SR7Ǎ-gY\0z_l}W:a qb9FKHoB|ƼJo{9!X̎q6yR$ңOV} xAMr6B+4\Z?B*\n Oӓ^W?c՝(:c=z ͿG.ï s1\ns^h\\Tv^GHC\" N3jwsG/nMCPȾTїevKs3Lc_?u\rx~P|m!k[Grq^\'+]: aVwDFaS]@a䟽SsحܢC<̿x*E{\0&x -.ChGBQ~\"db/f)Lkӭv(Y\nP0ktq= .T?xsJ:dW?>_cdy\"ܛ+abW?van|e{R»Աc+gic3Ęw\0kGоHFYk/q(m-̶2=Kvm=!Q>J,f62惶d9Jӂ֜]Mw@ӂ|*Aiu-s(ҕrK-o̾ay5x_QXO8^%-cUz2IGS?wF=k\rJS-zE{ .{uɥߺ gziّӧdž`{+^ zcMPZy. l_TisC,k෨=>A]%E3k7=+)*¾n>\Z% \'D<b[νC~h^H24s^){srg >i>G_OѝKn|6q[߅%rsڟA4Tr1^>~ˌ{k6+=9)JGHh!F7c\'4*\0MP)sg\'ʙ2VFC0^@܅?SO07dOO( N\r(E!ٍ jStLpo@>Vգ- B.Q_> kkowj.asʸ6J־?0Q}SQʊfл0!T{$q4Mi[@-#\'gҼe-6yFIX9aQ3sr)tr1Y_cw8`pz\'a/;w!{zި :YǴpԃ$M\\Sך6-;ۜNcpI8\np9Ivr)A5$~(sSIoC|\0\n`*IN\"\0:\\Zmɣ9◭@O\'JFZa\'Ҁ rMy7_\0j-C76*2q^\ZPe4s.t*GcU)Ae(Tt3 ȕs֕Џ EEifWYXl=k&iZ)w!RhJu_.d[>չ^XL:N2\'x͠:)ȫ1A``UA ecmY %r%%s\ZK/a;k>s[Z s l8=\\}ݴOMԇjWFܟ5xq5|TwW;H!$qKrJB&ҫ\\m@IgI+z)-ȓn쫢7~6\rhBǠ|։mi\Z؀t$XḸ3QWFT}+N!b?HAB\0Ʊ5\r$ƅ\\k_:vaY\'ԏzЊ\\zBqL\"R8hLr~_OJt]b|Ҥ)]R1\0\0f~Ie,:S[c\0X\05 t0jSO=h|`G}\rAwgEԚYܑYwVdcQOW;_6koA\\㢷\nSw _]l9dG=b턓 WE*GajAڨc/hG7qŤd,Q Ooz7MX1Zl\0I(\r`_OU,-i|`c>JZ+¾?sRN͝ S]H҃{WcwC$sF-S8 oQ@h(p\'48wmg\0@H8$wFJ[q|co_نVֆ[9UƾyW) devӆ8\'R[>m;*i3\'PH\0;DU#$\Z&uawV\'Iw9tB\0m,qgc;ޥxɜͿ؅{?L)Ynp;W%h^5v7534ʂ0;$o.~\n֊e?|Vw!oEapʱEq.8\0Zֵ)5VE 0WZ|055mgK5xٞQH]4kWv(׬ϟQii(g@8Z)2=hD:M[JIP\0j\"\05G \r0G=:\Z˸d;+!e`F+2[UR:g㈒Ӳ9-z-H޺*%XFՑ62nu)#O.5^@n>E\0Rw4\0S]\r Kmq▃HVh!X[+xe[pMnt\"Z)(+:8.>jyT/U.%V2F0G֟g,m&K1ڭ艊C\Z=q*gtl1-쳘dW%ur~)\ZK\nWA\ZEnuq|塐sS/N{gs]f==qrvўԵDu9+>$#8\'ֲ/QރIܥwYƹѸt_l7 /R7#a` $aqڳQm<ѧ9;X>hMoEp6\0^\nKu<~\\\'\0B5ZN-@vd а\0\n@I=1^G23i#,VdjZ$3}Ί{v(h_M.7pF~\'=xldT~VnLtLV7@2GJu մ[}Z٣|\Z麖u$WdJqp⾂of:\\kuI\0OrW+s t%il|tk\';v\r\\֯5KAWcNu~ l^7+}z^~<?`B73Ooz]GOmlI\rZxZAki !~^WJ$]֧b1ND3|-e nWj;J+U6P ۟-IfɌ!j\rիw {TB\\rz6#c\\iQT@Fs0\r-O#Pe 1V\ZlRFdzd1L qFmޭK[=j-x\\qvM4tEJ.ZIFIEAF2\ZYbjJJM\\j1?Eo7{W\0@G˜+R?1i-u̻}Ze2pKV[7tKEP (\0(\0(&W){j}Dz\'{FAz))ǡb\0\n 袊`QE\0r?|0uYm:09p:g|-I,Nz.vX\0\rwV><ө+?շҝH˹H97bB٫VEԒEk\0?ʧW Xwj\r*DR$rzb%Q@((8Bj>u8Ӯ5#F\"q٬eʮexdd=m.;vz U\0k}yG&$,IݱR֖wAd(y1QLC\0(\0(\0(\0h\0X~o: Cң^#*Cc\"Z(Q@Q@Q@QIҖTJ3Lt;1QE\n(\n(0Rmx:ϛjQpТ:]T(H 8(h\0(\0(\0(I\'\0ws#ԕZ͕`MYIYl$Zn\0TRBrԮD\nAJt\'(QE\0QE\0QE\0QMVݞ\r:+D\rcSJm![nHDx|К(AEPEPH:Z`,5-١!sW5C׌T moQIi&e&:įy($ 㠪W;*S6-QHAEPEPc0 0FE-!K`\nRIL\Z}%sE?6_OEP (\0(\0lqɥ#9RQE%\\ ԋq +  *J`-Q@((1~%Op++Kj>m@nHm{UM0b91uChUpjKw09K l Řnp\0=+RZQJ;pnx=L}k/#[-Zbh:TSOMTR)3Hri(\0\'4\r\'{hVEs֣3R$j),nˮs.:l-[M[mP$!GJ; NNkLp`9ԅ\0ptt\r8L]QE\n(\n(\n(#z\0-S7>jD_2R\\1\0z\n&Aa*fR=ET+cd&(b\n(\n($6PN=jԐj wz[#hr[ F(a9?1\nv?CgU]jB58n4Ƴ#Տ\rijxJyUe5gPH\'\Z0i煈wooZBƫG5EtdJkCR4ycPzSM((\0) =)=E9&rZj+ Md\\~$%lTg6jz|(R\r\0x:ErpZ]( (\0n>`rq\0(QOޭpwW*JF\Z AW튔\rVx 8BQLAEPEPYTf殸\rg\n~tmd:{yIج\rIbգq27E4Wc3HZROjA<#\r5 ֻd\'ijuiqPlVޢc+\n(\n(u5\r{VdH,\0jz(R\rOj~4QL]EQE\0QE\0QE\0V>Eg\rU>c袯(Q@Q@\rk8hƍhg+\r3z(:1Lv*|o','2010-04-10 15:01:09'); /*Table structure for table `enquiry` */ DROP TABLE IF EXISTS `enquiry`; CREATE TABLE `enquiry` ( `Id` varchar(500) NOT NULL, `SiteName` varchar(500) DEFAULT NULL, `CustomerName` varchar(500) DEFAULT NULL, `Address1` varchar(500) DEFAULT NULL, `Address2` varchar(500) DEFAULT NULL, `Address3` varchar(500) DEFAULT NULL, `Address4` varchar(500) DEFAULT NULL, `ContactPerson` varchar(500) DEFAULT NULL, `DirectNumber` varchar(500) DEFAULT NULL, `Designation` varchar(500) DEFAULT NULL, `OfficeNumber` varchar(500) DEFAULT NULL, `Email` varchar(500) DEFAULT NULL, `FootFall` varchar(500) DEFAULT NULL, `Lattitude` varchar(50) DEFAULT NULL, `Longitude` varchar(50) DEFAULT NULL, `SiteArea` varchar(500) DEFAULT NULL, `SiteStatus` varchar(500) DEFAULT NULL, `Floors` varchar(500) DEFAULT NULL, `IBS` varchar(500) DEFAULT NULL, `Outdoor` varchar(500) DEFAULT NULL, `EntryDate` datetime DEFAULT NULL, `site_area_thousands` varchar(200) DEFAULT NULL, `rentoffered` varchar(100) DEFAULT NULL, `renttype` varchar(100) DEFAULT NULL, `enquiry_basement` varchar(200) DEFAULT NULL, `enquiry_ground` varchar(100) DEFAULT NULL, `enquiry_upperfloor` varchar(100) DEFAULT NULL, `site_alternate_id` varchar(100) DEFAULT NULL, `site_wedsite` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `enquiry` */ insert into `enquiry`(`Id`,`SiteName`,`CustomerName`,`Address1`,`Address2`,`Address3`,`Address4`,`ContactPerson`,`DirectNumber`,`Designation`,`OfficeNumber`,`Email`,`FootFall`,`Lattitude`,`Longitude`,`SiteArea`,`SiteStatus`,`Floors`,`IBS`,`Outdoor`,`EntryDate`,`site_area_thousands`,`rentoffered`,`renttype`,`enquiry_basement`,`enquiry_ground`,`enquiry_upperfloor`,`site_alternate_id`,`site_wedsite`) values ('Req0000001','Palam Vihar ','Ashish Pandey','B-20/21','Palam Vyapar Kendra','Palam Vihar','Gurgaon,Haryana','Ashish Pandey','9312965068','TA (L2)','0124-4555777','ashish.pandey@adnig.com','4520','12.3','14.5','14520 sq.ft.','GGGGGGGGGG;SSSSSS;','4','HHH;TQ009;','ART@@@;TPOOOR;','2010-03-29 11:43:23','40','0988','PerMonth','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'),('Req0000002','Patana over bridge','Prashant','5345','43534','34534','5345345','pradeep','43534543','s/w','34543','ashish.pandey@adnig.com','vcbvcb','435','435','34543543','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','ART@@@;TPOOOR;','2010-04-06 16:49:34','40','99','PerMonth','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'),('Req0000003','Road costruction','Pinki','sdfsdf','dsfsf','sdfsd','fsdfsd','deepak','435325','S/E','45435435','4323@yahoo.com','435','54','45','435345','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','ART@@@;TPOOOR;','2010-04-06 16:52:29','20','200','PerMonth','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'),('Req0000004','Intertainment','Prachi Chourasiya','dfgdfcxvxcv','gdfgdfxcvxc','gdfgvxcv','dgdfgfdgxcvxcvxcv','prashant','4435435','xcvcx','345345','na@yahoo.com','44452345','5545','445','3454','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','ART@@@;TPOOOR;','2010-04-13 18:26:32','40454','400','PerPerson','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'),('Req0000005','Building Construction','Sone Singh','435','34534','5345','345345','Atul','43543543','m/d','5345435','AT@YAHOO.COM','234234','33','33','200','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','ART@@@;TPOOOR;','2010-04-12 12:49:23','50','400','PerMonth','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'),('Req0000006','Turmoto','Prakash','reter','tert fghgfh','retert','ertert fghfgh','sinha gfhgfhgfh','3563534','xcvcxv','5345345345','sdcsadf@yahoo.com','345345546','345456','43545645654','30','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','POOOR;','2010-04-12 14:24:06','40','30000','PerMonth','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'),('Req0000007','Alcatel Lucent','Roshan','456','gdfg','dfgdf','gdfgdfgdfg','Prashant','5645645645','S/E','645654654','gtret@yahoo.com','200','33','33','30','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','ART@@@;TPOOOR;','2010-04-13 10:05:40','40','300','PerPerson','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'),('Req0000008','Surya mondal','APKI','546','dfgfd','df','gdfgdfgdfg','xvcxcv','5464565',' dfgdgfd','456456','dfg@yahoo.com','200','22666','33gtg','20','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','POOOR;','2010-04-14 18:52:28','300','30000','PerMonth','3rd;AAA;ABNDV;','BBB;OTRE;','Qxvxcvxcvxcvcxv;TRUEW;','dfg@yahoo.com','dsfgsd.com'); /*Table structure for table `ground` */ DROP TABLE IF EXISTS `ground`; CREATE TABLE `ground` ( `ground` varchar(300) NOT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`ground`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `ground` */ insert into `ground`(`ground`,`userid`,`status`,`curedatetime`) values ('ASDFGG','admin','Active','2010-04-14 13:49:44'),('BBB','admin','Active','2010-04-03 11:48:38'),('BBBBBBBBBB','admin','Active','2010-04-16 13:49:46'),('dxvcxvxcvxcv','admin','Active','2010-04-14 13:49:37'),('OTRE','admin','Active','2010-04-14 13:49:51'); /*Table structure for table `group_master` */ DROP TABLE IF EXISTS `group_master`; CREATE TABLE `group_master` ( `numbering` mediumint(10) NOT NULL AUTO_INCREMENT, `group_name` varchar(500) DEFAULT NULL, `sector` varchar(500) DEFAULT NULL, `userid` varchar(500) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `entrydate` datetime DEFAULT NULL, PRIMARY KEY (`numbering`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*Data for the table `group_master` */ insert into `group_master`(`numbering`,`group_name`,`sector`,`userid`,`status`,`entrydate`) values (1,'Haldiram','Business','admin','Active','2010-03-27 12:37:32'),(2,'Business','A-123','admin','Active','2010-04-01 12:27:00'),(3,'','-1','admin','Active','2010-04-01 12:27:09'),(4,'ANB','NA','admin','Active','2010-04-03 12:03:04'),(5,'Haldiram Bhujiyawal delhi','NA','admin','Active','2010-04-16 13:24:22'); /*Table structure for table `ibs` */ DROP TABLE IF EXISTS `ibs`; CREATE TABLE `ibs` ( `IBS` varchar(300) NOT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`IBS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `ibs` */ insert into `ibs`(`IBS`,`userid`,`status`,`curedatetime`) values ('AS002','admin','Active','2010-04-14 13:50:31'),('AS002444444444444','admin','Active','2010-04-16 14:11:13'),('HHH','admin','Active','2010-04-03 11:48:57'),('TQ009','admin','Active','2010-04-14 13:50:39'),('TR001','admin','Active','2010-04-14 13:50:24'); /*Table structure for table `incentive` */ DROP TABLE IF EXISTS `incentive`; CREATE TABLE `incentive` ( `incentive_plan_id` varchar(300) NOT NULL, `incentive_plan_name` varchar(200) DEFAULT NULL, `incentive_no_ofsite` varchar(200) DEFAULT NULL, `incentive_rate` varchar(2000) DEFAULT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`incentive_plan_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `incentive` */ insert into `incentive`(`incentive_plan_id`,`incentive_plan_name`,`incentive_no_ofsite`,`incentive_rate`,`userid`,`status`,`curedatetime`) values ('IPI0000001','Education','AA;SS;HH;','300;5600;299;','admin','Active','2010-04-02 12:58:21'),('IPI0000002','Education','cxvxcv;xzcvxv;sxcdsad;','435;45645;54435;','admin','Active','2010-04-02 13:00:43'),('IPI0000003','xcvcxvcxv','xcvxcv;cvxcv;sdfsdf;fsdfds;','43534;43534;34534;34534;','admin','Active','2010-04-02 13:01:57'),('IPI0000004','Master plan','AA;BB;CCC;','300;600;100;','admin','Active','2010-04-02 13:28:42'); /*Table structure for table `incentive_reference` */ DROP TABLE IF EXISTS `incentive_reference`; CREATE TABLE `incentive_reference` ( `incentive_plan_reference` int(11) NOT NULL AUTO_INCREMENT, `incentive_plan_id` varchar(200) DEFAULT NULL, `incentive_plan_name` varchar(200) DEFAULT NULL, `incentive_no_ofsite` varchar(200) DEFAULT NULL, `incentive_rate` varchar(2000) DEFAULT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`incentive_plan_reference`), KEY `incentive_incentive_reference` (`incentive_plan_id`), CONSTRAINT `incentive_incentive_reference` FOREIGN KEY (`incentive_plan_id`) REFERENCES `incentive` (`incentive_plan_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; /*Data for the table `incentive_reference` */ insert into `incentive_reference`(`incentive_plan_reference`,`incentive_plan_id`,`incentive_plan_name`,`incentive_no_ofsite`,`incentive_rate`,`userid`,`status`,`curedatetime`) values (1,'IPI0000001','Education','AA','300','admin','Active','2010-04-02 12:58:21'),(2,'IPI0000001','Education','SS','5600','admin','Active','2010-04-02 12:58:21'),(3,'IPI0000002','Education','cxvxcv','435','admin','Active','2010-04-02 13:00:47'),(4,'IPI0000002','Education','xzcvxv','45645','admin','Active','2010-04-02 13:00:57'),(5,'IPI0000003','xcvcxvcxv','xcvxcv','43534','admin','Active','2010-04-02 13:01:57'),(6,'IPI0000003','xcvcxvcxv','cvxcv','43534','admin','Active','2010-04-02 13:01:57'),(7,'IPI0000003','xcvcxvcxv','sdfsdf','34534','admin','Active','2010-04-02 13:01:57'),(8,'IPI0000003','xcvcxvcxv','fsdfds','34534','admin','Active','2010-04-02 13:01:57'),(9,'IPI0000004','Master plan','AA','300','admin','Active','2010-04-02 13:28:42'),(10,'IPI0000004','Master plan','BB','600','admin','Active','2010-04-02 13:28:42'),(11,'IPI0000004','Master plan','CCC','100','admin','Active','2010-04-02 13:28:42'); /*Table structure for table `leadassign_info` */ DROP TABLE IF EXISTS `leadassign_info`; CREATE TABLE `leadassign_info` ( `leadassign_id` varchar(300) NOT NULL, `leadassign_enquiry_id` varchar(200) DEFAULT NULL, `leadassign_sitename` varchar(200) DEFAULT NULL, `leadassign_cusname` varchar(2000) DEFAULT NULL, `leadassign_agent_name` varchar(200) DEFAULT NULL, `Branchname` varchar(200) DEFAULT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`leadassign_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `leadassign_info` */ insert into `leadassign_info`(`leadassign_id`,`leadassign_enquiry_id`,`leadassign_sitename`,`leadassign_cusname`,`leadassign_agent_name`,`Branchname`,`userid`,`status`,`curedatetime`) values ('LAI0000001','Req0000002','Patana over bridge','Prashant','rakesh',NULL,'admin','Active','2010-04-06 18:37:00'); /*Table structure for table `login` */ DROP TABLE IF EXISTS `login`; CREATE TABLE `login` ( `username` varchar(500) NOT NULL, `password` varchar(500) DEFAULT NULL, `authorize` varchar(50) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `remarks` varchar(100) DEFAULT NULL, PRIMARY KEY (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `login` */ insert into `login`(`username`,`password`,`authorize`,`status`,`remarks`) values ('admin','admin123','111111111111111111','Active','Admin'),('ashish','12345','111111111111111111','Active','Employee'),('pk001','23412321','000000000000000110','Active','Employee'),('rakesh','123','000000111111111111','Active','Employee'),('sohan','123456','0','Active','NewUser'); /*Table structure for table `loi_info` */ DROP TABLE IF EXISTS `loi_info`; CREATE TABLE `loi_info` ( `LOI_id` varchar(300) NOT NULL, `LOI_daily_id` varchar(200) DEFAULT NULL, `LOI_sitename` varchar(200) DEFAULT NULL, `LOI_siteid` varchar(2000) DEFAULT NULL, `LOI_to` varchar(200) DEFAULT NULL, `LOI_qup1` varchar(200) DEFAULT NULL, `LOI_qup2` varchar(2000) DEFAULT NULL, `LOI_qup3` varchar(200) DEFAULT NULL, `LOI_qup4` varchar(200) DEFAULT NULL, `LOI_qup5` varchar(2000) DEFAULT NULL, `LOI_qup6` varchar(200) DEFAULT NULL, `LOI_qup7` varchar(200) DEFAULT NULL, `LOI_qup8` varchar(2000) DEFAULT NULL, `LOI_qup9` varchar(200) DEFAULT NULL, `LOI_qup10` varchar(200) DEFAULT NULL, `LOI_qup11` varchar(2000) DEFAULT NULL, `LOI_qup12` varchar(200) DEFAULT NULL, `LOI_qup13` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`LOI_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `loi_info` */ insert into `loi_info`(`LOI_id`,`LOI_daily_id`,`LOI_sitename`,`LOI_siteid`,`LOI_to`,`LOI_qup1`,`LOI_qup2`,`LOI_qup3`,`LOI_qup4`,`LOI_qup5`,`LOI_qup6`,`LOI_qup7`,`LOI_qup8`,`LOI_qup9`,`LOI_qup10`,`LOI_qup11`,`LOI_qup12`,`LOI_qup13`,`curedatetime`) values ('LOI0000001','DSI0000001','Palam Vihar ','Loc0000008','raj1_prashant@yahoo.co.in',' B-20/21Palam Vyapar KendraPalam Vihar Gurgaon,Haryana','B-20/21 Palam Vyapar Kendra Palam Vihar Gurgaon,Haryana','14520 sq.ft.','345345','5435','435','3254234','fdgfdg',' B-20/21Palam Vyapar KendraPalam ViharGurgaon,Haryana','dfgdfg','fdgfd','gdfg','dfgdfgdfg','2010-04-05 17:35:18'),('LOI0000002','DSI0000001','Palam Vihar ','Loc0000008','ashish.pandey@adnig.com',' B-20/21Palam Vyapar KendraPalam Vihar Gurgaon,Haryana','B-20/21 Palam Vyapar Kendra Palam Vihar Gurgaon,Haryana','14520 sq.ft.','345345345345','5435345345345','435345345','356345345345','fdgfdg',' B-20/21Palam Vyapar KendraPalam ViharGurgaon,Haryana','dfgdfg','fdgfddfsd43232324234','gdfg32434234','dfgdfgdfg234234','2010-04-05 17:53:03'),('LOI0000003','DSI0000001','abc121 ','Loc0000023','raj1_prashant@yahoo.co.in',' dsfsdfdsfsdgfsdggdsfsd sdfsdf','dsfsdf dsfsdgfsdgg dsfsd sdfsdf','20','xcvxc','vxcv','xcvxcv','5666','cxvxc',' dsfsdfdsfsdgfsdggdsfsdsdfsdf','vcxvxc','vxcv','xcvxc','vxcvxcvxcv','2010-04-17 16:56:30'),('LOI0000004','DSI0000001','abc121 ','Loc0000023','raj1_prashant@yahoo.co.in',' dsfsdfdsfsdgfsdggdsfsd sdfsdf','dsfsdf dsfsdgfsdgg dsfsd sdfsdf','20','','','','5666','',' dsfsdfdsfsdgfsdggdsfsdsdfsdf','','','','','2010-04-17 19:21:20'),('LOI0000005','DSI0000001','abc121 ','Loc0000023','raj1_prashant@yahoo.co.in',' dsfsdfdsfsdgfsdggdsfsd sdfsdf','dsfsdf dsfsdgfsdgg dsfsd sdfsdf','20','','','','5666','',' dsfsdfdsfsdgfsdggdsfsdsdfsdf','','','','','2010-04-17 19:27:08'),('LOI0000006','DSI0000002','South delhi ','Loc0000003','raj1_prashant@yahoo.co.in',' fdgfdgfdgdfgdfgdf fdgdfg','fdgfdg fdgdfg dfgdf fdgdfg','22','','','','44','',' fdgfdgfdgdfgdfgdffdgdfg','','','','','2010-04-17 20:01:57'),('LOI0000007','DSI0000001','abc121 ','Loc0000023','raj1_prashant@yahoo.co.in',' dsfsdfdsfsdgfsdggdsfsd sdfsdf','dsfsdf dsfsdgfsdgg dsfsd sdfsdf','20','','','','5666','',' dsfsdfdsfsdgfsdggdsfsdsdfsdf','','','','','2010-04-17 20:12:25'),('LOI0000008','DSI0000002','South delhi ','Loc0000003','raj1_prashant@yahoo.co.in',' fdgfdgfdgdfgdfgdf fdgdfg','fdgfdg fdgdfg dfgdf fdgdfg','22','vbn','vbnvbnbv','nvbn','44','nbvn',' fdgfdgfdgdfgdfgdffdgdfg','cxv','xcvxcv','xcvxc','vxcvcxv','2010-04-17 21:13:51'),('LOI0000009','DSI0000001','abc121 ','Loc0000023','raj1_prashant@yahoo.co.in',' dsfsdfdsfsdgfsdggdsfsd sdfsdf','dsfsdf dsfsdgfsdgg dsfsd sdfsdf','20','nbmbnm','mbnmbnm','nbmbn','5666','bnmnb',' dsfsdfdsfsdgfsdggdsfsdsdfsdf','mbnm','bnmbn','mbnmbn','mbnmbnm','2010-04-19 10:26:22'),('LOI0000010','DSI0000002','South delhi ','Loc0000003','dfg@yahoo.com;dfg@yahoo.com;',' fdgfdgfdgdfgdfgdf fdgdfg','fdgfdg fdgdfg dfgdf fdgdfg','22','na','na','an','44','as',' fdgfdgfdgdfgdfgdffdgdfg','a','a','d','a','2010-04-21 19:10:31'),('LOI0000011','DSI0000002','South delhi ','Loc0000003','dfg@yahoo.com;dfg@yahoo.com;',' fdgfdgfdgdfgdfgdf fdgdfg','fdgfdg fdgdfg dfgdf fdgdfg','22','na','na','na','44','na',' fdgfdgfdgdfgdfgdffdgdfg','na','na','aa','aa','2010-04-21 19:15:06'),('LOI0000012','DSI0000002','South delhi ','Loc0000003','dfg@yahoo.com;dfg@yahoo.com;',' fdgfdgfdgdfgdfgdf fdgdfg','fdgfdg fdgdfg dfgdf fdgdfg','22','na','na','nma','44','na',' fdgfdgfdgdfgdfgdffdgdfg','','','','','2010-04-21 20:02:24'),('LOI0000013','DSI0000008','Luck ','Loc0000028','sdfg@dfg.qwer;sdfg@sdfg.ert;',' sdfsdfsdfasdfdfgsdfg wwe','sdfsdf sdfasdf dfgsdfg wwe','4','sdfg','sdf','gsdfgs','654564 ','dfgsdfgsdfg',' sdfsdfsdfasdfdfgsdfgwwe','sdfgsdfg','sdfgsdfg','sdf','gsdfg','2010-04-22 13:24:08'),('LOI0000014','DSI0000010','Subhiksha ','Loc0000029','kurwai1@gmail.com;kurwai1@gmail.com;',' 15/2chankya puriahmdabad gujrat','15/2 chankya puri ahmdabad gujrat','1','','','','54000','',' 15/2chankya puriahmdabadgujrat','','','','','2010-04-22 18:32:07'); /*Table structure for table `outdoor` */ DROP TABLE IF EXISTS `outdoor`; CREATE TABLE `outdoor` ( `outdoor` varchar(300) NOT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`outdoor`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `outdoor` */ insert into `outdoor`(`outdoor`,`userid`,`status`,`curedatetime`) values ('by ashish','admin','Active','2010-04-16 14:21:43'),('By pradeep','admin','Active','2010-04-03 11:59:13'),('by prashant','admin','Active','2010-04-16 14:21:22'),('SART@@@','admin','Active','2010-04-14 13:51:07'),('TPOOOR','admin','Active','2010-04-14 13:50:56'); /*Table structure for table `sector` */ DROP TABLE IF EXISTS `sector`; CREATE TABLE `sector` ( `sector` varchar(500) NOT NULL, `userid` varchar(500) DEFAULT NULL, `status` varchar(500) DEFAULT NULL, `entrydate` datetime DEFAULT NULL, PRIMARY KEY (`sector`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `sector` */ insert into `sector`(`sector`,`userid`,`status`,`entrydate`) values ('A-1235678','admin','Active','2010-04-01 12:26:45'),('Business-123','admin','Active','2010-03-27 12:16:56'); /*Table structure for table `site_status` */ DROP TABLE IF EXISTS `site_status`; CREATE TABLE `site_status` ( `sitstatus_name` varchar(300) NOT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`sitstatus_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `site_status` */ insert into `site_status`(`sitstatus_name`,`userid`,`status`,`curedatetime`) values ('ABBBBB','admin','Active','2010-04-14 14:20:18'),('GGGGGGGGGG','admin','Active','2010-04-14 14:20:32'),('SSSSSS','admin','Active','2010-04-14 14:20:26'),('TTTTTTTT','admin','Active','2010-04-14 14:20:38'); /*Table structure for table `sitemaster` */ DROP TABLE IF EXISTS `sitemaster`; CREATE TABLE `sitemaster` ( `Id` varchar(500) NOT NULL, `SiteName` varchar(500) DEFAULT NULL, `CustomerId` varchar(300) DEFAULT NULL, `CustomerName` varchar(500) DEFAULT NULL, `SiteOwner` varchar(500) DEFAULT NULL, `Address1` varchar(500) DEFAULT NULL, `Address2` varchar(500) DEFAULT NULL, `Address3` varchar(500) DEFAULT NULL, `Address4` varchar(500) DEFAULT NULL, `ContactPerson` varchar(500) DEFAULT NULL, `DiretNumber` varchar(500) DEFAULT NULL, `Designation` varchar(500) DEFAULT NULL, `OfficeNumber` varchar(500) DEFAULT NULL, `Email` varchar(500) DEFAULT NULL, `FootFall` varchar(500) DEFAULT NULL, `Lattitude` varchar(50) DEFAULT NULL, `Longitude` varchar(50) DEFAULT NULL, `SiteArea` varchar(500) DEFAULT NULL, `SiteStatus` varchar(500) DEFAULT NULL, `Floors` varchar(500) DEFAULT NULL, `IBS` varchar(500) DEFAULT NULL, `Outdoor` varchar(500) DEFAULT NULL, `userid` varchar(500) DEFAULT NULL, `EntryDate` datetime DEFAULT NULL, `alternate_no` varchar(200) DEFAULT NULL, `site_basement` varchar(200) DEFAULT NULL, `site_ground` varchar(200) DEFAULT NULL, `site_upperfloor` varchar(200) DEFAULT NULL, `site_area` varchar(200) DEFAULT NULL, `site_circle` varchar(200) DEFAULT NULL, `site_zone` varchar(200) DEFAULT NULL, `site_district` varchar(200) DEFAULT NULL, `site_group` varchar(200) DEFAULT NULL, `site_sector` varchar(200) DEFAULT NULL, `site_type` varchar(200) DEFAULT NULL, `site_area_thousands` varchar(200) DEFAULT NULL, `site_rentoffered` varchar(200) DEFAULT NULL, `site_renttype` varchar(200) DEFAULT NULL, `owner_address` varchar(500) DEFAULT NULL, `site_alternate_id` varchar(200) DEFAULT NULL, `site_wedsite` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `siteid_customerid` (`CustomerId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `sitemaster` */ insert into `sitemaster`(`Id`,`SiteName`,`CustomerId`,`CustomerName`,`SiteOwner`,`Address1`,`Address2`,`Address3`,`Address4`,`ContactPerson`,`DiretNumber`,`Designation`,`OfficeNumber`,`Email`,`FootFall`,`Lattitude`,`Longitude`,`SiteArea`,`SiteStatus`,`Floors`,`IBS`,`Outdoor`,`userid`,`EntryDate`,`alternate_no`,`site_basement`,`site_ground`,`site_upperfloor`,`site_area`,`site_circle`,`site_zone`,`site_district`,`site_group`,`site_sector`,`site_type`,`site_area_thousands`,`site_rentoffered`,`site_renttype`,`owner_address`,`site_alternate_id`,`site_wedsite`) values ('Loc0000002','Naraiana','Cus0000001','Haldiram Bhujia ','Mr. Daal','NA','RA','IA','NA','Mr. Moong','9874563214','SE','011-7896541','as@as.com','4','45.6','12.0','1200 sq ft.','GGGGGGGGGG;SSSSSS;','4','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-03-27 17:55:54','na','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','na;','Kanpur','Aurangabad','Haldiram;Business;','A-123;','FromLead','40','300','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000003','South delhi','NA','NA','Prashant','fdgfdg','fdgdfg','dfgdf','fdgdfg','Ashish','3543545','s/E','5435435435','dfg@yahoo.com','2','dsfdsf','dsfdsfdsf','22','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-03 13:22:31','na','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','na;','na','na','Haldiram;Business;','A-123;','FromLead','45','44','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000004','North delhi','NA','NA','Pradeep','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-03 13:25:15','NA','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','sdfasdfasdf;','kaka dev','North Bihar','Dhanbad','Haldiram;Business;','A-123;','FromLead','45','6554','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000005','NA','NA','NA','sdcfxzczxc','B-20/21','Palam Vyapar Kendra','Palam Vihar','Gurgaon,Haryana','Ashish Pandey','9312965068','TA (L2)','0124-4555777','ashish.pandey@adnig.com','4520','NA','zxcxzc','14520 sq.ft.','GGGGGGGGGG;SSSSSS;','4','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-05 09:32:37','NA','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','kaka dev;','North Bihar','Dhanbad','Haldiram;Business;','A-123;','FromLead','23','66','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000006','NA','NA','NA','fghfghg','B-20/21','Palam Vyapar Kendra','Palam Vihar','Gurgaon,Haryana','Ashish Pandey','9312965068','TA (L2)','0124-4555777','ashish.pandey@adnig.com','4520','435345','435345','14520 sq.ft.','GGGGGGGGGG;SSSSSS;','4','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-05 09:34:08','546345','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','Patana;','North Bihar','Dhanbad','Haldiram;Business;','A-123;','FromLead','23','44','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000008','Palam Vihar ','NA','NA','zxczxc','B-20/21','Palam Vyapar Kendra','Palam Vihar','Gurgaon,Haryana','Ashish Pandey','9312965068','TA (L2)','0124-4555777','ashish.pandey@adnig.com','4520','4564565','666','14520 sq.ft.','GGGGGGGG;SSSSSS;GGGGGGGGGG;SSSSSS;GGGGGGGGGG;SSSSSS;','NA','H;TQ009;HHH;TQ009;HHH;TQ009;','RT@@@;TPOOOR;SART@@@;TPOOOR;asdasdsad;SART@@@;TPOOOR;','admin','2010-04-05 09:45:10','NA','d;AAA;3rd;AAA;3rd;AAA;ABNDV;','B;dxvcxvxcvxcv;BBB;dxvcxvxcvxcv;BBB;dxvcxvxcvxcv;','C;CCC;CCC;Qxvxcvxcvxcvcxv;','S;BAS;AS;BAS;','ka dev;Patana;kaka dev;Patana;aka dev;Patana;kaka dev;Patana;','South Delhi','Dhanbad','ldiram;Business;Haldiram;Business;Haldiram;Business;','123;A-123;A-123;','FromLead','15','777','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000009','Palam Vihar ','NA','NA','Prashant','5345','43534','34534','5345345','pradeep','43534543','s/w','34543','ashish.pandey@adnig.com','vcbvcb','435','435','34543543','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','rakesh','2010-04-07 11:39:22','4353453454','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','kaka dev;Patana;','North Bihar','Dhanbad','Haldiram;Business;','A-123;','FromLead','14','66','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000010','Patana over bridge','NA','NA','ashish','5345','43534','34534','5345345','pradeep','43534543','s/w','34543','ashish.pandey@adnig.com','vcbvcb','435','435','34543543','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','rakesh','2010-04-07 11:40:50','456546546','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','kaka dev;Patana;','Karnal','Dhanbad','Haldiram;Business;','A-123;','FromLead','23','89','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000011','Patana over bridge','NA','NA','pradeep','5345','43534','34534','5345345','pradeep','43534543','s/w','34543','ashish.pandey@adnig.com','vcbvcb','435','435','34543543','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','rakesh','2010-04-07 15:33:34','0991929272','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','asdf;','kaka dev;Patana;','Kanpur','Aurangabad','Haldiram;Business;','A-123;','FromLead','23','567','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000012','Patana over bridge','NA','NA','prashnat','5345','43534','34534','5345345','pradeep','43534543','s/w','34543','ashish.pandey@adnig.com','vcbvcb','NA','NA','34543543','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-10 14:54:01','NA','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','kaka dev;Patana;','abc','Dhanbad','Haldiram;Business;','A-123;','FromLead','130','77','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000013','Road construction','NA','NA','prakash','fgdg','fdgdf','gdfgdfgfd','gdfgdfgzx','ashish','34534534534','s/h','435435','fdsgYahoo.com','312','13212','213123','23','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-10 15:46:42','5345','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','kaka dev;Patana;','Delhi','Dhanbad','Haldiram;Business;','A-123;','WithOutLead','10','899','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000014','TINTINTIN','NA','NA','Aditya','dsfsd','fsdf','sdfsdfsdf','sdfsdf','pradeep','345345','fdgdg','45345345','dfgv@yahoo.com','343','34','4343','34','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-10 15:49:13','345435','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','BAS;','CST;Patana;','abc','Dhanbad','Haldiram;Business;','A-123;','WithOutLead','10','500','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000015','RRRRR','NA','NA','fdgdfgdfg','sdfsd','dsfsd','fsdfs','dfsdfsdf','dfgdfg','54345345','dfgfdg','345345435','czxvxcv@yahoo.com','3434','34','343','3434','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-10 17:39:10','345345345','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','BAS;','CST;kaka;','Kanpur','Dhanbad','Haldiram;Business;','A-123;','WithOutLead','10','22','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000016','Road costruction','NA','NA','NA','sdfsdf','dsfsf','sdfsd','fsdfsd','deepak','435325','S/E','45435435','4323@yahoo.com','435','22','22','435345','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 12:46:20','NA','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','BAS;','CST;kaka;','Kanpur','Dhanbad','Haldiram;Business;','A-123;','FromLead','40','22','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000017','Building Construction','NA','NA','prashant','435','34534','5345','345345','Atul','43543543','m/d','5345435','AT@YAHOO.COM','234234','22','33','200','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 12:50:50','45435345345','3rd;AAA;','BBB;dxvcxvxcvxcv;','BBB;','BAS;','CST;kaka;','Kanpur','Dhanbad','Haldiram;Business;','A-123;','FromLead','60','22','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000018','Patana over bridge','NA','NA','NA','5345','43534','34534','5345345','pradeep','43534543','s/w','34543','ashish.pandey@adnig.com','vcbvcb','33','33','34543543','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 14:01:42','435345345','3rd;AAA;','BBB;dxvcxvxcvxcv;','BBB;','BAS;','CST;kaka;','Kanpur','Dhanbad','Haldiram;Business;','A-123;','FromLead','40','40000','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000019','geetika & company','NA','NA','abc','NA','NA','NA','NA','abs','na','manager','000101','pradeep@yahoo.com','678','10','20','1000','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 14:15:26','9585755','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','CST;','Kanpur','Aurangabad','Haldiram;Business;','A-123;','WithOutLead','34','10000','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000020','nokia','NA','NA','na','na','na','na','na','na','0919919282','na','4645454','pradeep','456353','1','2','3','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 14:18:22','956756464','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','BAS;','ST;CST;','Kanpur','Aurangabad','Haldiram;Business;','A-123;','WithOutLead','50','7000','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000021','Turmoto','NA','NA','Mr. Prakash','reter','tert','retert','ertert','sinha','3563534','xcvcxv','5345345345','sdcsadf@yahoo.com','345345','22','22','30','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 18:19:19','345435435','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','BAD;','CST;','Kanpur','Dhanbad','Haldiram;Business;','A-123;','FromLead','40','30000','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000022','Turmoto','NA','NA','Simran','reter','tert','retert','ertert','sinha','3563534','xcvcxv','5345345345','sdcsadf@yahoo.com','345345','22','22','30','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 18:21:03','NA','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','Kankarbagh;','kaka;','Kanpur','Dhanbad','Haldiram;Business;','A-123;','FromLead','40','30000','PerMonth','Dhanbad bank more','dfg@yahoo.com','dgf.com'),('Loc0000023','abc121','NA','NA','prashant','dsfsdf','dsfsdgfsdgg','dsfsd','sdfsdf','na','098836352','Punka','564545454456456','pradeep@adnig.com','34262666','23','45','20','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-12 19:32:06','09877664564565','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;','BAS;','CST;','Kanpur','Aurangabad','Haldiram;Business;','A-123;','WithOutLead','450','5666','PerMonth','Palam vihar gurgaon','dfg@yahoo.com','dgf.com'),('Loc0000024','Lower grand','NA','NA','cxzvvc','xcvxc','vcxv','xcvxc','vxcvxcv','vbxcvxcv','345345','dfgdfg','435435','dfg@yahoo.com','66','66','66','30','GGGGGGGGGG;SSSSSS;','NA','HHH;TQ009;','SART@@@;TPOOOR;','admin','2010-04-14 16:39:15','345345','3rd;AAA;','BBB;dxvcxvxcvxcv;','CCC;Qxvxcvxcvxcvcxv;','Soti;','CST;','Kanpur','Aurangabad','Haldiram;Business;','A-123;','WithOutLead','40','40','PerPerson','xcvcxvcxv','dfg@yahoo.com','dgf.com'),('Loc0000025','malvika','NA','NA','malik','A','B','C','D','ram','9818215475','manager','0112343211','malvika@adnig.com','123121','12','45','2','ABBBBB;GGGGGGGGGG;','NA','AS002;HHH;','by ashish;by prashant;','rakesh','2010-04-17 16:26:57','9873423221','ABNDV;PKoytr;','ASDFGG;BBBBBBBBBB;','CCC;Qxvxcvxcvxcvcxv;','Soti;South;','kaka;','North Bihar','Aurangabad','Haldiram;Business;','A-1235678;','WithOutLead','50','17777','PerMonth','palam vihar','malvika1@yahoo.com','adnig.com'),('Loc0000026','Lucknow','NA','NA','gfsfd','sadfasdf','asdf','asd','fasdf','asdfasdf','34234','sdfgsdfg','345345','asdfasdf@scfdaf.wer','34','240.3','120.2','2','ABBBBB;SSSSSS;','NA','AS002;AS002444444444444;','by ashish;By pradeep;by prashant;TPOOOR;','ashish','2010-04-19 00:32:01','345345','3rd;AAAAAAAAA;ABNDV;','ASDFGG;BBBBBBBBBB;','CCCBBBBBBBBBBBBBBBB;','XYZ;','CST;','Kanpur','Pune','Business;','A-1235678;','WithOutLead','34','12345','PerPerson','gsdfgsdfg','wer@dfsg.wer','www.wert.sdfg'),('Loc0000027','Lucknow','NA','NA','gfsfd','sadfasdf','asdf','asd','fasdf','asdfasdf','34234','sdfgsdfg','345345','asdfasdf@scfdaf.wer','34','240.3','120.2','2','BBBBB;SSSSSS;ABBBBB;SSSSSS;','NA','S002;AS002444444444444;AS002;AS002444444444444;','y ashish;By pradeep;by prashant;TPOOOR;by ashish;By pradeep;by prashant;TPOOOR;','ashish','2010-04-19 00:32:01','345345','rd;AAAAAAAAA;ABNDV;3rd;AAAAAAAAA;ABNDV;','SDFGG;BBBBBBBBBB;ASDFGG;BBBBBBBBBB;','CCBBBBBBBBBBBBBBBB;CCCBBBBBBBBBBBBBBBB;','YZ;XYZ;','ST;CST;','Kanpur','Pune','usiness;Business;','-1235678;A-1235678;','WithOutLead','34','12345','PerPerson','gsdfgsdfg','wer@dfsg.wer','www.wert.sdfg'),('Loc0000028','Luck','NA','NA','sdfaasd','sdfsdf','sdfasdf','dfgsdfg','wwe','asdfasdf','65456','sdfgsdfg','65464564','sdfg@dfg.qwer','54','45.12','454.23','4','GGGGGGGGGG;','NA','AS002;','by ashish;','admin','2010-04-19 18:02:58','654654645','AAAAAAAAA;','ASDFGG;','CCCBBBBBBBBBBBBBBBB;','Soti;','CST;','Kanpur','Aurangabad','Haldiram;','A-1235678;','WithOutLead','54','654564 ','PerMonth','asdfasdf','sdfg@sdfg.ert','dfsgsdf'),('Loc0000029','Subhiksha','NA','NA','Adani','15/2','chankya puri','ahmdabad','gujrat','Sanjay','9893158902','Manager','0987654321','kurwai1@gmail.com','5000','NA','NA','1','ABBBBB;','NA','AS002;','by ashish;','admin','2010-04-22 18:30:23','1234567890','3rd;','ASDFGG;','CCCBBBBBBBBBBBBBBBB;','sg;','Gujrat;','West Zone','Ahemadabad','ANB;','Business-123;','WithOutLead','50','54000','PerPerson','Adani Cop. Ltd','kurwai1@gmail.com','google.com'); /*Table structure for table `sitemaster_reference` */ DROP TABLE IF EXISTS `sitemaster_reference`; CREATE TABLE `sitemaster_reference` ( `Id` varchar(500) NOT NULL, `SiteName` varchar(500) DEFAULT NULL, `CustomerId` varchar(300) DEFAULT NULL, `CustomerName` varchar(500) DEFAULT NULL, `SiteOwner` varchar(500) DEFAULT NULL, `Address1` varchar(500) DEFAULT NULL, `Address2` varchar(500) DEFAULT NULL, `Address3` varchar(500) DEFAULT NULL, `Address4` varchar(500) DEFAULT NULL, `ContactPerson` varchar(500) DEFAULT NULL, `DiretNumber` varchar(500) DEFAULT NULL, `Designation` varchar(500) DEFAULT NULL, `OfficeNumber` varchar(500) DEFAULT NULL, `Email` varchar(500) DEFAULT NULL, `FootFall` varchar(500) DEFAULT NULL, `Lattitude` varchar(50) DEFAULT NULL, `Longitude` varchar(50) DEFAULT NULL, `SiteArea` varchar(500) DEFAULT NULL, `SiteStatus` varchar(500) DEFAULT NULL, `Floors` varchar(500) DEFAULT NULL, `IBS` varchar(500) DEFAULT NULL, `Outdoor` varchar(500) DEFAULT NULL, `userid` varchar(500) DEFAULT NULL, `EntryDate` datetime DEFAULT NULL, `alternate_no` varchar(200) DEFAULT NULL, `site_basement` varchar(200) DEFAULT NULL, `site_ground` varchar(200) DEFAULT NULL, `site_upperfloor` varchar(200) DEFAULT NULL, `site_area` varchar(200) DEFAULT NULL, `site_circle` varchar(200) DEFAULT NULL, `site_zone` varchar(200) DEFAULT NULL, `site_district` varchar(200) DEFAULT NULL, `site_group` varchar(200) DEFAULT NULL, `site_sector` varchar(200) DEFAULT NULL, `site_type` varchar(200) DEFAULT NULL, `site_area_thousands` varchar(200) DEFAULT NULL, `site_rentoffered` varchar(200) DEFAULT NULL, `site_renttype` varchar(200) DEFAULT NULL, `owner_address` varchar(500) DEFAULT NULL, `site_alternate_id` varchar(200) DEFAULT NULL, `site_wedsite` varchar(100) DEFAULT NULL, `reference_id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`reference_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `sitemaster_reference` */ /*Table structure for table `upperfloor` */ DROP TABLE IF EXISTS `upperfloor`; CREATE TABLE `upperfloor` ( `upperfloor` varchar(300) NOT NULL, `userid` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`upperfloor`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `upperfloor` */ insert into `upperfloor`(`upperfloor`,`userid`,`status`,`curedatetime`) values ('CCC','admin','Active','2010-04-03 11:48:51'),('CCCBBBBBBBBBBBBBBBB','admin','Active','2010-04-16 14:01:03'),('Qxvxcvxcvxcvcxv','admin','Active','2010-04-14 13:50:15'),('TRUEW','admin','Active','2010-04-14 13:50:01'); /*Table structure for table `zone_master` */ DROP TABLE IF EXISTS `zone_master`; CREATE TABLE `zone_master` ( `zone_name` varchar(200) NOT NULL, `username` varchar(200) DEFAULT NULL, `status` varchar(200) DEFAULT NULL, `curedatetime` datetime DEFAULT NULL, PRIMARY KEY (`zone_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `zone_master` */ insert into `zone_master`(`zone_name`,`username`,`status`,`curedatetime`) values ('Kanpur','admin','Active','2010-03-23 17:28:44'),('New Area','admin','Active','2010-04-16 10:54:48'),('North Bihar',NULL,'Active','2010-04-01 12:24:40'),('South Delhi','admin','Active','2010-04-01 12:26:05'),('West Zone','admin','Active','2010-04-22 18:17:54'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;