-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 07, 2014 at 11:06 PM
-- Server version: 5.5.37-cll
-- PHP Version: 5.4.23

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

--
-- Database: `rnjmedia_fm`
--

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_level` int(11) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `userid` varchar(155) DEFAULT NULL,
  `password_md5` varchar(255) DEFAULT NULL,
  `registration_date` datetime DEFAULT NULL,
  `designation` varchar(155) DEFAULT NULL,
  `region` varchar(100) NOT NULL,
  `verified` enum('Y','N') DEFAULT 'N',
  `active` enum('Y','N') DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

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

INSERT INTO `users` (`id`, `user_level`, `first_name`, `last_name`, `userid`, `password_md5`, `registration_date`, `designation`, `region`, `verified`, `active`) VALUES
(1, NULL, 'Admin', 'User', 'admin', '21232F297A57A5A743894A0E4A801FC3', '2014-06-30 10:28:05', 'SA', 'Penang', 'Y', 'Y'),
(6, 2, 'abcd', 'abcd', 'abcd', 'e2fc714c4727ee9395f324cd2e7f331f', '2014-06-30 10:28:05', 'S', 'Penang', 'Y', 'Y'),
(7, 2, 'George', 'Lim', 'Glim', '1da61b39d03fcdebe471e7e9d5759a2c', '2014-07-01 03:06:24', 'S', 'Penang', 'Y', 'Y'),
(8, 3, 'Colin', 'Lim', 'Colin', '202cb962ac59075b964b07152d234b70', '2014-07-01 10:36:45', 'S', 'Penang', 'Y', 'Y'),
(9, 3, 'John', 'Doee', 'abcde', '81dc9bdb52d04dc20036dbd8313ed055', '2014-07-01 20:24:16', 'S', 'Kuala Lumpur', 'Y', 'Y');