-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 26, 2016 at 11:23 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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: `javae`
--

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

--
-- Table structure for table `registration`
--

CREATE TABLE IF NOT EXISTS `registration` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `surname` varchar(500) NOT NULL,
  `firstname` varchar(500) NOT NULL,
  `othernames` varchar(500) NOT NULL,
  `gender` varchar(500) NOT NULL,
  `dob` varchar(500) NOT NULL,
  `nationality` varchar(500) NOT NULL,
  `state` varchar(255) NOT NULL,
  `lga` varchar(500) NOT NULL,
  `religion` varchar(500) NOT NULL,
  `occupation` varchar(500) NOT NULL,
  `pri_phone` varchar(500) NOT NULL,
  `sec_phone` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `address` varchar(500) NOT NULL,
  `previous_knowledge` varchar(500) NOT NULL,
  `spon_surname` varchar(500) NOT NULL,
  `spon_firstname` varchar(500) NOT NULL,
  `spon_othernames` varchar(500) NOT NULL,
  `spon_relationship` varchar(500) NOT NULL,
  `spon_phone` varchar(500) NOT NULL,
  `spon_occupation` varchar(500) NOT NULL,
  `spon_email` varchar(500) NOT NULL,
  `spon_address` varchar(500) NOT NULL,
  `entry_level` varchar(500) NOT NULL,
  `class_type` varchar(500) NOT NULL,
  `instrument` varchar(500) NOT NULL,
  `time` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL DEFAULT 'new',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`id`, `title`, `surname`, `firstname`, `othernames`, `gender`, `dob`, `nationality`, `state`, `lga`, `religion`, `occupation`, `pri_phone`, `sec_phone`, `email`, `address`, `previous_knowledge`, `spon_surname`, `spon_firstname`, `spon_othernames`, `spon_relationship`, `spon_phone`, `spon_occupation`, `spon_email`, `spon_address`, `entry_level`, `class_type`, `instrument`, `time`, `status`) VALUES
(1, 'None', 'Ogunshola', 'Victor', 'Oluseyi', 'male', '5/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Dave', 'Ope', 'Brother', '323252523525', 'Missionary', 'd2ogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', 'Talking Drum', '20, 02, 2016', 'new'),
(2, 'None', 'Ogunshola', 'Victor', 'Oluseyi', 'male', '5/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Dave', 'Ope', 'Brother', '323252523525', 'Missionary', 'd2ogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', 'Xylophone', '20, 02, 2016', 'new'),
(3, 'None', 'Ogunshola', 'Victor', 'Oluseyi', 'male', '5/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Dave', 'Ope', 'Brother', '323252523525', 'Missionary', 'd2ogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', 'Xylophone', '20, 02, 2016', 'new'),
(4, 'Mr.', 'Ogunshola', 'Victor', 'Oluseyi', 'male', '5/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Dave', 'Ope', 'Brother', '323252523525', 'Missionary', 'd2ogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', 'Xylophone', '20, 02, 2016', 'new'),
(5, 'Mr.', 'Ogunshola', 'Victor', 'Oluseyi', 'male', '5/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Dave', 'Ope', 'Brother', '323252523525', 'Missionary', 'd2ogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', 'Xylophone', '20, 02, 2016', 'new'),
(6, 'Mr.', 'Ogunshola', 'Victor', 'Oluseyi', 'male', '5/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Dave', 'Ope', 'Brother', '323252523525', 'Missionary', 'd2ogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', 'Xylophone', '20, 02, 2016', 'new'),
(7, 'Mrs.', 'Ogunshola', 'Victor', 'ewfwe', 'male', '05/11', 'nkjb', 'Akwa Ibom', 'jnlkjl', 'kjbnlk', 'kjblkjbb', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Victor', 'nmkjbn ,lkg', 'jbhkljb', '+2348136698217', 'kjbnlknmb', 'jmnek@wnjiw.com', '130, Atiku Abubakar Avenue,', 'Advanced Level', 'Private Class', '', '21, 02, 2016', 'new'),
(8, 'Mrs.', 'Ogunshola', 'Victor', 'ewfwe', 'male', '05/11', 'nkjb', 'Akwa Ibom', 'jnlkjl', 'kjbnlk', 'kjblkjbb', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Victor', 'nmkjbn ,lkg', 'jbhkljb', '+2348136698217', 'kjbnlknmb', 'jmnek@wnjiw.com', '130, Atiku Abubakar Avenue,', 'Advanced Level', 'Private Class', 'Keyboard (Piano)', '21, 02, 2016', 'new'),
(9, 'Mrs.', 'Ogunshola', 'Victor', 'ewfwe', 'male', '05/11', 'nkjb', 'Akwa Ibom', 'jnlkjl', 'kjbnlk', 'kjblkjbb', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Victor', 'nmkjbn ,lkg', 'jbhkljb', '+2348136698217', 'kjbnlknmb', 'jmnek@wnjiw.com', '130, Atiku Abubakar Avenue,', 'Advanced Level', 'Private Class', '', '21, 02, 2016', 'new'),
(10, 'None', 'Ogunshola', 'Victor', 'knikj', 'male', '05/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Victor', 'kojpinjhku', 'jkjljk', '+2348136698217', 'Missionary', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', '    ,Saxophone ,Clarinet   ,Xylophone  ', '21, 02, 2016', 'new'),
(11, 'Mr.', 'Ogunshola', 'Victor', 'Oluseyi', 'male', '5/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', 'Ogunshola', 'Dave', 'Ope', 'Brother', '323252523525', 'Missionary', 'd2ogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'Intermediate Level', 'Private Class', ',Keyboard (Piano) ,Violin    ,Clarinet   ,Xylophone  ', '21, 02, 2016', 'new'),
(12, 'Mr.', 'Ogunshola', 'Victor', 'jbinkbhj', 'male', '05/11', 'Nigeria', 'Akwa Ibom', 'Lagelu', 'Christian', 'SOftware Developer', '+2348136698217', '+2348136698217', 'vogunshola@gmail.com', '130, Atiku Abubakar Avenue,', 'No', '1014', 'project', 'rklejpgijieoij', 'Brother', '8136698217', 'Missionary', 'vogunshola@gmail.com', 'Adamawa State University', 'Intermediate Level', 'Family Class (70k for 3 months)', ' ,Violin  ,Bass Guitar  ,Trumpet     ', '22, 02, 2016', 'new');

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