/*
SQLyog Community Edition- MySQL GUI v5.22a
Host - 5.0.19-nt : Database - application
*********************************************************************
Server version : 5.0.19-nt
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `application`;

USE `application`;

/*!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' */;

/*Table structure for table `register` */

DROP TABLE IF EXISTS `register`;

CREATE TABLE `register` (
  `id` bigint(10) NOT NULL auto_increment,
  `firstName` varchar(20) default NULL,
  `lastName` varchar(20) default NULL,
  `userName` varchar(20) default NULL,
  `password` varchar(20) default NULL,
  `email` varchar(40) default NULL,
  `contactNo` varchar(20) default NULL,
  `address` varchar(40) default NULL,
  `country` varchar(30) default NULL,
  `state` varchar(30) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `register` */

insert  into `register`(`id`,`firstName`,`lastName`,`userName`,`password`,`email`,`contactNo`,`address`,`country`,`state`) values (1,'Ravi','Kant','ravikant','ravikant','raviksachan@gmail.com','9999999999','Delhi','India','Delhi');

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