text: -- phpMyAdmin SQL Dump
  -- version 4.6.5.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: May 09, 2018 at 02:48 PM
  -- Server version: 10.1.21-MariaDB
  -- PHP Version: 5.6.30
  
  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 utf8mb4 */;
  
  --
  -- Database: `employees_db`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `codes`
  --
  
  CREATE TABLE `codes` (
    `id` int(11) NOT NULL,
    `project_code` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
    `project_name` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
    `department_id` int(10) NOT NULL,
    `task` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;
  
  --
  -- Dumping data for table `codes`
  --
  
  INSERT INTO `codes` (`id`, `project_code`, `project_name`, `department_id`, `task`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (1, 'CCS21203', 'CIMB', 2, 'Web Developing', 'Enhance the Website', '2018-04-27 01:53:40', '2018-04-30 11:24:57', NULL),
  (2, 'ENT1103', 'MSU', 1, 'Develop Hospital System', 'A new hospital system', '2018-04-27 03:03:18', '2018-04-27 03:03:18', NULL),
  (3, '1234', 'ABCD', 2, 'QWERTYUIOP', 'ASDFGHJKL', '2018-04-27 05:03:41', '2018-04-27 05:03:41', NULL);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `codes`
  --
  ALTER TABLE `codes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `department_id` (`department_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `codes`
  --
  ALTER TABLE `codes`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  /*!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 */;
  