-- phpMyAdmin SQL Dump
-- version 4.7.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: 25 Sep 2018 pada 06.05
-- Versi Server: 5.6.35
-- PHP Version: 7.1.6

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

--
-- Database: `db_billing_new`
--

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

--
-- Struktur dari tabel `task_types`
--

CREATE TABLE `task_types` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_deleted` enum('Y','N') NOT NULL DEFAULT 'N',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `task_types`
--

INSERT INTO `task_types` (`id`, `title`, `slug`, `is_deleted`, `created_at`, `updated_at`) VALUES
(1, 'Ganten', 'ganten', 'Y', '2018-08-22 01:01:36', '2018-08-22 01:02:01'),
(2, 'Testingss', 'testingss', 'Y', '2018-08-22 01:11:04', '2018-08-22 01:11:51'),
(3, 'Monitoring Invoice', 'monitoring-invoice', 'N', '2018-08-24 01:26:39', '2018-08-24 01:26:39'),
(4, 'Pembinaan Pegawai', 'pembinaan-pegawai', 'N', '2018-08-24 01:26:45', '2018-08-24 01:26:45'),
(5, 'Pembinaan User', 'pembinaan-user', 'N', '2018-08-24 01:27:14', '2018-08-24 01:27:14'),
(6, 'Marketing Calon User', 'marketing-calon-user', 'N', '2018-08-24 01:27:27', '2018-08-24 01:27:27');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `task_types`
--
ALTER TABLE `task_types`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `task_types`
--
ALTER TABLE `task_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;