/*
SQLyog Enterprise - MySQL GUI v7.02 
MySQL - 5.0.18-nt : Database - msi
*********************************************************************
*/


/*!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*/`msi` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `msi`;

/*Table structure for table `branch_master` */

DROP TABLE IF EXISTS `branch_master`;

CREATE TABLE `branch_master` (
  `id` int(10) NOT NULL auto_increment,
  `branch_name` varchar(100) NOT NULL,
  `current_date` datetime default NULL,
  PRIMARY KEY  (`branch_name`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `branch_master` */

insert  into `branch_master`(`id`,`branch_name`,`current_date`) values (5,'alahabad','2010-05-22 04:13:10'),(2,'banaras','2010-05-22 04:12:09'),(8,'bareli','2010-05-22 04:22:59'),(4,'bihar','2010-05-22 04:13:00'),(1,'Delhi','2010-05-22 04:07:38'),(11,'gurgaon','2010-05-22 04:26:47'),(6,'kanpur','2010-05-22 04:20:43'),(16,'Kolkata','2010-05-25 16:38:43'),(7,'lucknow','2010-05-22 04:21:36'),(13,'noida','2010-05-22 04:30:11'),(12,'patana','2010-05-22 04:28:41'),(14,'pukhraya','2010-05-22 05:37:36');

/*Table structure for table `busscategory_master` */

DROP TABLE IF EXISTS `busscategory_master`;

CREATE TABLE `busscategory_master` (
  `id` int(10) NOT NULL auto_increment,
  `busscategory_name` varchar(50) NOT NULL,
  `current_date` datetime default NULL,
  PRIMARY KEY  (`busscategory_name`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `busscategory_master` */

insert  into `busscategory_master`(`id`,`busscategory_name`,`current_date`) values (1,'fdafdsf','2010-05-22 07:38:13'),(3,'gdfgdfg','2010-05-22 07:40:25'),(2,'hdfhdfh','2010-05-22 07:40:18'),(4,'Software','2010-05-25 02:42:45'),(5,'steel','2010-05-25 02:42:52');

/*Table structure for table `category_master` */

DROP TABLE IF EXISTS `category_master`;

CREATE TABLE `category_master` (
  `id` int(10) NOT NULL auto_increment,
  `category_name` varchar(50) NOT NULL,
  `current_date` datetime default NULL,
  PRIMARY KEY  (`category_name`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `category_master` */

insert  into `category_master`(`id`,`category_name`,`current_date`) values (1,'gdfgdg','2010-05-22 07:16:52'),(3,'hhghf','2010-05-22 07:18:31'),(4,'mhgkjgjk','2010-05-22 07:18:36'),(6,'sdfsdf','2010-05-25 17:39:22'),(5,'wertwert','2010-05-25 17:20:08');

/*Table structure for table `designation` */

DROP TABLE IF EXISTS `designation`;

CREATE TABLE `designation` (
  `designation` varchar(100) NOT NULL,
  `username` varchar(100) default NULL,
  `branch` varchar(100) default NULL,
  `curedatetime` datetime default NULL,
  PRIMARY KEY  (`designation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `designation` */

insert  into `designation`(`designation`,`username`,`branch`,`curedatetime`) values ('Accounts','Admin','Delhi','2010-05-27 13:22:24'),('ASM','Admin','Delhi','2010-05-27 13:22:43'),('BDE','Admin','Delhi','2010-05-27 13:22:32'),('CSE','Admin','Delhi','2010-05-27 13:22:14'),('Master Admin','Admin','Delhi','2010-05-27 13:21:37'),('Support','Admin','Delhi','2010-05-27 13:21:58');

/*Table structure for table `leadentry` */

DROP TABLE IF EXISTS `leadentry`;

CREATE TABLE `leadentry` (
  `id` int(10) NOT NULL auto_increment,
  `ref_no` varchar(15) NOT NULL,
  `user_name` varchar(100) default NULL,
  `lead_datetime` datetime default NULL,
  `source_name` varchar(50) default NULL,
  `bussiness_category` varchar(50) default NULL,
  `client_name` varchar(50) default NULL,
  `contact_number` varchar(20) default NULL,
  `company_name` varchar(100) default NULL,
  `address` varchar(100) default NULL,
  `zone` varchar(50) default NULL,
  `status` varchar(50) default NULL,
  `app_date` date default NULL,
  `meeting_place` varchar(100) default NULL,
  `appstart_time` time default NULL,
  `am_pm` varchar(10) default NULL,
  `append_time` time default NULL,
  `endam_pm` varchar(10) default NULL,
  `comment` varchar(200) default NULL,
  `currentdate` datetime default NULL,
  PRIMARY KEY  (`ref_no`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `leadentry` */

insert  into `leadentry`(`id`,`ref_no`,`user_name`,`lead_datetime`,`source_name`,`bussiness_category`,`client_name`,`contact_number`,`company_name`,`address`,`zone`,`status`,`app_date`,`meeting_place`,`appstart_time`,`am_pm`,`append_time`,`endam_pm`,`comment`,`currentdate`) values (11,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Call back again','2010-05-27','NA','02:30:00','A.M.','00:00:00','Na','fdgdfgfg','2010-05-27 17:00:36'),(12,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Meeting','2010-05-27','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-27 17:33:54'),(13,'LID000003','Admin','2010-05-27 05:41:48','asdfasdf','Software','bmbnmnbm','657657567','ytutyu','tyutyutyu','North','Not pick','2010-05-27','NA','07:25:00','P.M','00:00:00','Na','ytutyuytuytu','2010-05-27 17:42:10'),(14,'LID000004','Ashish','2010-05-28 01:18:26','adnig','Software','Rinku','9874902384','HCL','Palam','North','Na','0000-00-00','Na','00:00:00','Na','00:00:00','Na','Only Test','2010-05-28 13:23:41'),(15,'LID000005','Ashish','2010-05-28 01:40:02','adnig','Software','Ashok','4567456456','Infosys','Banglor','South','Na','0000-00-00','Na','00:00:00','Na','00:00:00','Na','By ashsish Kuta','2010-05-28 13:40:39');

/*Table structure for table `leadentry_reference` */

DROP TABLE IF EXISTS `leadentry_reference`;

CREATE TABLE `leadentry_reference` (
  `id` int(10) NOT NULL auto_increment,
  `ref_no` varchar(15) NOT NULL,
  `user_name` varchar(100) default NULL,
  `lead_datetime` datetime default NULL,
  `source_name` varchar(50) default NULL,
  `bussiness_category` varchar(50) default NULL,
  `client_name` varchar(50) default NULL,
  `contact_number` varchar(20) default NULL,
  `company_name` varchar(100) default NULL,
  `address` varchar(100) default NULL,
  `zone` varchar(50) default NULL,
  `status` varchar(50) default NULL,
  `app_date` date default NULL,
  `meeting_place` varchar(100) default NULL,
  `appstart_time` time default NULL,
  `am_pm` varchar(10) default NULL,
  `append_time` time default NULL,
  `endam_pm` varchar(10) default NULL,
  `comment` varchar(200) default NULL,
  `currentdate` datetime default NULL,
  UNIQUE KEY `id` (`id`),
  KEY `pk_as` (`ref_no`),
  CONSTRAINT `pk_as` FOREIGN KEY (`ref_no`) REFERENCES `leadentry` (`ref_no`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `leadentry_reference` */

insert  into `leadentry_reference`(`id`,`ref_no`,`user_name`,`lead_datetime`,`source_name`,`bussiness_category`,`client_name`,`contact_number`,`company_name`,`address`,`zone`,`status`,`app_date`,`meeting_place`,`appstart_time`,`am_pm`,`append_time`,`endam_pm`,`comment`,`currentdate`) values (1,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Meeting','2010-05-30','Aurangabad','08:40:00','A.M.','00:00:00','Na','cvcbvb','2010-05-28 12:03:08'),(2,'LID000003','Admin','2010-05-27 05:41:48','asdfasdf','Software','bmbnmnbm','657657567','ytutyu','tyutyutyu','North','Meeting','2010-05-28','deo','07:25:00','P.M','00:00:00','Na','ytutyuytuytu','2010-05-28 12:05:56'),(3,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Call back again','2010-05-28','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-28 12:09:51'),(4,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Meeting','2010-05-28','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-28 12:11:29'),(5,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Call back again','2010-05-28','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-28 12:13:36'),(6,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Call back again','2010-05-28','NA','02:30:00','A.M.','00:00:00','Na','fdgdfgfg','2010-05-28 12:14:13'),(7,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Call back again','2010-05-28','NA','02:30:00','A.M.','00:00:00','Na','fdgdfgfg','2010-05-28 12:16:21'),(8,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Call back again','2010-05-28','NA','02:30:00','A.M.','00:00:00','Na','fdgdfgfg','2010-05-28 12:17:14'),(9,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Meeting','2010-05-28','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-28 12:18:58'),(10,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Meeting','2010-05-28','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-28 12:21:10'),(11,'LID000003','Admin','2010-05-27 05:41:48','asdfasdf','Software','bmbnmnbm','657657567','ytutyu','tyutyutyu','North','Not pick','2010-05-28','NA','07:25:00','P.M','00:00:00','Na','ytutyuytuytu','2010-05-28 12:22:20'),(12,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Meeting','2010-05-28','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-28 12:23:20'),(13,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Call back again','2010-05-28','NA','02:30:00','A.M.','00:00:00','Na','fdgdfgfg','2010-05-28 12:24:40'),(14,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Call back again','2010-05-28','NA','02:30:00','A.M.','00:00:00','Na','fdgdfgfg','2010-05-28 12:26:37'),(15,'LID000003','Admin','2010-05-27 05:41:48','asdfasdf','Software','bmbnmnbm','657657567','ytutyu','tyutyutyu','North','Not pick','2010-05-28','NA','07:25:00','P.M','00:00:00','Na','ytutyuytuytu','2010-05-28 12:27:09'),(16,'LID000001','Admin','2010-05-27 05:00:17','dgdsgf','select','Prashant','46456456','fdgdfg','dfgdfg','West','Call back again','2010-05-28','NA','02:30:00','A.M.','00:00:00','Na','fdgdfgfg','2010-05-28 12:30:02'),(17,'LID000002','Admin','2010-05-27 05:33:15','asdfasdf','gdfgdfg','rinki','094302934','Adnig','jsdksjdkasjd','North','Meeting','2010-05-28','delhi','02:30:00','P.M','00:00:00','Na','bnvbnvbn','2010-05-28 12:30:50'),(18,'LID000003','Admin','2010-05-27 05:41:48','asdfasdf','Software','bmbnmnbm','657657567','ytutyu','tyutyutyu','North','Meeting','2010-06-28','Narayana','06:35:00','P.M','00:00:00','Na','Meeting as such','2010-05-28 13:08:57'),(19,'LID000004','Ashish','2010-05-28 01:18:26','adnig','Software','Rinku','9874902384','HCL','Palam','North','Meeting','2010-05-28','Na','07:30:00','A.M.','00:00:00','Na','Only Test','2010-05-28 13:38:07'),(20,'LID000005','Admin','2010-05-28 01:40:02','adnig','Software','Ashok','4567456456','Infosys','Banglor','South','Call back again','2010-05-28','Na','04:30:00','P.M','00:00:00','Na','By ashsish','2010-05-28 13:42:43');

/*Table structure for table `sourcename_master` */

DROP TABLE IF EXISTS `sourcename_master`;

CREATE TABLE `sourcename_master` (
  `id` int(10) NOT NULL auto_increment,
  `source_name` varchar(50) NOT NULL,
  `current_date` datetime default NULL,
  PRIMARY KEY  (`source_name`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `sourcename_master` */

insert  into `sourcename_master`(`id`,`source_name`,`current_date`) values (5,'adnig','2010-05-25 02:43:19'),(7,'asdfasdf','2010-05-25 17:40:14'),(4,'dgdsgf','2010-05-22 07:00:54'),(2,'gdfgdf','2010-05-22 06:56:32'),(3,'gdsgsg','2010-05-22 07:00:18'),(1,'hdfgsdg','2010-05-22 06:56:00'),(6,'vayam','2010-05-25 02:43:30');

/*Table structure for table `user_master` */

DROP TABLE IF EXISTS `user_master`;

CREATE TABLE `user_master` (
  `id` int(10) NOT NULL auto_increment,
  `user_name` varchar(40) default NULL,
  `upassword` varchar(30) default NULL,
  `branch` varchar(30) default NULL,
  `current_date` datetime default NULL,
  `designation` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `user_master` */

insert  into `user_master`(`id`,`user_name`,`upassword`,`branch`,`current_date`,`designation`) values (1,'gdsg','1234r','banaras','2010-05-22 06:06:56','ASM'),(2,'gdsg','1234r','banaras','2010-05-22 06:08:14','ASM'),(3,'aradhana','arru','delhi','2010-05-22 06:13:47','Support'),(4,'aradhana','arr123','delhi','2010-05-22 06:25:10','BDE'),(5,'aradhana','arru1234','delhi','2010-05-22 06:26:22','CSE'),(6,'aradhana bhatt','aaaa','gurgaon','2010-05-22 06:26:55','BDE'),(7,'ssss','aaaa','bihar','2010-05-22 06:27:17','ASM'),(8,'dfdffas','fafafs','bareli','2010-05-23 22:06:12','Support'),(9,'Ashish','Pandey','Delhi','2010-05-26 16:36:33','Support'),(10,'Admin','Admin123','Delhi','2010-05-26 16:36:33','Master Admin'),(11,'Prashant','1234','Delhi','2010-05-27 13:44:46','ASM');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;