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




create database if not exists `application`;

USE `application`;


/*Table structure for table `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');

