Migration for request type

-- Adminer 4.2.5 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

USE `dps_portal_db`;

DROP TABLE IF EXISTS `request_type`;
CREATE TABLE `request_type` (
  `req_id` int(11) NOT NULL AUTO_INCREMENT,
  `req_name` varchar(255) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`req_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `request_type` (`req_id`, `req_name`) VALUES
(1, 'Permanent House No.'),
(2, 'Permanent Street'),
(3, 'Permanent Brgy/Subdivision'),
(4, 'Permanent District/Municipality'),
(5, 'Permanent City/Province'),
(6, 'Zip Code'),
(7, 'Current Unit/House No.'),
(8, 'Current Street '),
(9, 'Current Brgy/Subdivision'),
(10,    'Current District/Municipality'),
(11,    'Current City/Province'),
(12,    'Current Zip Code'),
(13,    'Home Phone No.'),
(14,    'Mobile No.'),
(15,    'Email Address'),
(16,    'Language/Dialect/s spoken at home'),
(17,    'Talents/Special Skills'),
(18,    'Hobbies/Interest');

-- 2017-03-02 07:10:26