-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 31, 2011 at 06:25 PM
-- Server version: 4.1.10
-- PHP Version: 5.0.4
-- 
-- Database: `scilet`
-- 

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

-- 
-- Table structure for table `scilet_login`
-- 

CREATE TABLE `scilet_login` (
  `slno` int(100) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`slno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `scilet_login`
-- 

INSERT INTO `scilet_login` VALUES (1, 'admin', 'admin');

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

-- 
-- Table structure for table `scilet_online_application`
-- 

CREATE TABLE `scilet_online_application` (
  `slno` int(200) NOT NULL auto_increment,
  `title` varchar(200) NOT NULL default '',
  `cname` varchar(200) NOT NULL default '',
  `degree` varchar(200) NOT NULL default '',
  `price` double(200,2) NOT NULL default '0.00',
  `inr` varchar(20) NOT NULL default '',
  `area_of_research` varchar(200) NOT NULL default '',
  `authors` text NOT NULL,
  `texts` text NOT NULL,
  `topic` text NOT NULL,
  `college_name` varchar(200) NOT NULL default '',
  `university_name` varchar(200) NOT NULL default '',
  `college_address1` varchar(200) NOT NULL default '',
  `college_address2` varchar(200) NOT NULL default '',
  `college_city` varchar(200) NOT NULL default '',
  `college_state` varchar(200) NOT NULL default '',
  `college_country` varchar(200) NOT NULL default '',
  `college_postalcode` varchar(200) NOT NULL default '',
  `position` varchar(200) NOT NULL default '',
  `company_name` varchar(200) NOT NULL default '',
  `company_address1` varchar(200) NOT NULL default '',
  `company_address2` varchar(200) NOT NULL default '',
  `company_city` varchar(200) NOT NULL default '',
  `company_state` varchar(200) NOT NULL default '',
  `company_country` varchar(200) NOT NULL default '',
  `company_postalcode` varchar(200) NOT NULL default '',
  `current_address1` varchar(200) NOT NULL default '',
  `current_address2` varchar(200) NOT NULL default '',
  `current_city` varchar(200) NOT NULL default '',
  `current_state` varchar(200) NOT NULL default '',
  `current_country` varchar(200) NOT NULL default '',
  `current_postalcode` varchar(200) NOT NULL default '',
  `current_phoneno` varchar(200) NOT NULL default '',
  `current_mobileno` varchar(200) NOT NULL default '',
  `current_emailid` varchar(200) NOT NULL default '',
  `permanent_address1` varchar(200) NOT NULL default '',
  `permanent_address2` varchar(200) NOT NULL default '',
  `permanent_city` varchar(200) NOT NULL default '',
  `permanent_state` varchar(200) NOT NULL default '',
  `permanent_country` varchar(200) NOT NULL default '',
  `permanent_postalcode` varchar(200) NOT NULL default '',
  `permanent_phoneno` varchar(200) NOT NULL default '',
  `permanent_mobileno` varchar(200) NOT NULL default '',
  `check_address` varchar(200) NOT NULL default '',
  `guide_name` varchar(200) NOT NULL default '',
  `guide_designation` varchar(200) NOT NULL default '',
  `guide_institution` varchar(200) NOT NULL default '',
  `guide_phoneno` varchar(200) NOT NULL default '',
  `guide_office_phoneno` varchar(200) NOT NULL default '',
  `guide_mobileno` varchar(200) NOT NULL default '',
  `guide_emailid` varchar(200) NOT NULL default '',
  `guide_address1` varchar(200) NOT NULL default '',
  `guide_address2` varchar(200) NOT NULL default '',
  `guide_city` varchar(200) NOT NULL default '',
  `guide_state` varchar(200) NOT NULL default '',
  `guide_country` varchar(200) NOT NULL default '',
  `guide_postalcode` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`slno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `scilet_online_application`
-- 

INSERT INTO `scilet_online_application` VALUES (3, 'Mr', 'Sanjeev', 'Overseas', 25.00, '$', 'test', 'test', 'test', 'test', '1', '2', '3', '4', '5', '6', '7', '8', '1', '2', '3', '4', '5', '6', '7', '8', '1', '2', '3', '4', '5', '6', '7', '8', '9', '1', '2', '3', '4', '5', '6', '7', '8', 'on', '1', '2', '3', '4', '5', '6', '7', '1', '2', '3', '4', '5', '6');