Developing Database for the Application
We have used MySQL for storing and retrieving the
information for this application. The name of the table is "register"
under the database named "application" where field "id"
is primary key and is set to auto-increment.
Fields of the table can be seen as in the figure below:
You can create the database and table using "register.sql"
sql script.
/*
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 */;
|
Download Script for database
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
