-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 19, 2009 at 07:38 AM
-- Server version: 5.0.75
-- PHP Version: 5.2.5-dev

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `icsb2`
--

-- --------------------------------------------------------

--
-- Table structure for table `reg`
--

CREATE TABLE IF NOT EXISTS `reg` (
  `sno` int(11) NOT NULL auto_increment,
  `Title` varchar(40) NOT NULL,
  `Name` varchar(40) NOT NULL,
  `Surname` varchar(40) NOT NULL,
  `Country` varchar(20) NOT NULL,
  `Author's Email` varchar(40) NOT NULL,
  `Alternative Email` varchar(40) default NULL,
  `Abstact Category` varchar(40) NOT NULL,
  `Conference Title` varchar(40) NOT NULL,
  `Website` varchar(40) NOT NULL,
  `Full Postal Address` text NOT NULL,
  `Request for Hotel reservation` varchar(40) NOT NULL,
  `Payment for Hotel reservation` varchar(40) NOT NULL,
  PRIMARY KEY  (`sno`),
  UNIQUE KEY `Name` (`Name`),
  UNIQUE KEY `Name_2` (`Name`,`Author's Email`,`Alternative Email`,`Website`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `reg`
--

INSERT INTO `reg` (`sno`, `Title`, `Name`, `Surname`, `Country`, `Author's Email`, `Alternative Email`, `Abstact Category`, `Conference Title`, `Website`, `Full Postal Address`, `Request for Hotel reservation`, `Payment for Hotel reservation`) VALUES
(10, 'Mr', 'ssadas', 'adasdas', 'dasdasd', 'asda@gmail.com', NULL, 'asdadas', 'sdasda', 'www.aaaa.gmail.com', 'fsdfsdfsd', 'Y', 'N');
