-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 24, 2015 at 02:40 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `recruitment`
--

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

--
-- Table structure for table `courses`
--

CREATE TABLE IF NOT EXISTS `courses` (
  `id` int(11) NOT NULL auto_increment,
  `course` varchar(30) NOT NULL,
  `set_time` datetime default NULL,
  `created_by` varchar(60) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `courses`
--


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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `message_time` datetime NOT NULL,
  `mess_status` tinyint(4) default NULL,
  `title` varchar(80) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `messages`
--


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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `names` varchar(100) NOT NULL,
  `image` varchar(80) NOT NULL,
  `username` varchar(60) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(80) NOT NULL,
  `sex` varchar(8) NOT NULL,
  `access` int(3) NOT NULL default '0',
  `state` varchar(35) NOT NULL,
  `u_status` int(3) NOT NULL default '0' COMMENT '0=inactive, 1=active/pending,2=approved,tested=3,10=recommended,15=confirmed,30=invited for interview',
  `email_code` varchar(60) default NULL,
  `cv` varchar(60) default NULL,
  `approved_by` varchar(80) default NULL,
  `dates` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--


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

--
-- Table structure for table `user_courses`
--

CREATE TABLE IF NOT EXISTS `user_courses` (
  `id` int(11) NOT NULL auto_increment,
  `course` varchar(60) NOT NULL,
  `user_id` int(11) NOT NULL,
  `score` int(3) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `user_courses`
--


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

--
-- Table structure for table `user_information`
--

CREATE TABLE IF NOT EXISTS `user_information` (
  `id` int(11) NOT NULL auto_increment,
  `u_phone` varchar(20) default NULL,
  `user_id` int(11) NOT NULL,
  `DOB` varchar(20) default NULL,
  `address` varchar(80) default NULL,
  `school` varchar(60) default NULL,
  `next_of_kin` varchar(60) default NULL,
  `preferred_job` varchar(60) default NULL,
  `previous_job` varchar(60) default NULL,
  `nk_phone` varchar(20) default NULL,
  `nk_address` varchar(60) default NULL,
  `nk_relationship` varchar(30) default NULL,
  `degree` varchar(10) default NULL,
  `religion` varchar(15) default NULL,
  `POB` varchar(255) default NULL,
  `ethnicity` varchar(50) default NULL,
  `marital_status` varchar(10) default NULL,
  `maiden_name` varchar(60) default NULL,
  `refName` varchar(70) default NULL,
  `refAddress` varchar(70) default NULL,
  `refPhone` varchar(20) default NULL,
  `refRelation` varchar(15) default NULL,
  `LGA` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `user_information`
--

