text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Apr 29, 2021 at 01:43 PM
  -- Server version: 10.4.11-MariaDB
  -- PHP Version: 7.4.5
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  START TRANSACTION;
  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: `ci4`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_activation_attempts`
  --
  
  CREATE TABLE `auth_activation_attempts` (
    `id` int(11) UNSIGNED NOT NULL,
    `ip_address` varchar(255) NOT NULL,
    `user_agent` varchar(255) NOT NULL,
    `token` varchar(255) DEFAULT NULL,
    `created_at` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_groups`
  --
  
  CREATE TABLE `auth_groups` (
    `id` int(11) UNSIGNED NOT NULL,
    `name` varchar(255) NOT NULL,
    `description` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_groups_permissions`
  --
  
  CREATE TABLE `auth_groups_permissions` (
    `group_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
    `permission_id` int(11) UNSIGNED NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_groups_users`
  --
  
  CREATE TABLE `auth_groups_users` (
    `group_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
    `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_logins`
  --
  
  CREATE TABLE `auth_logins` (
    `id` int(11) UNSIGNED NOT NULL,
    `ip_address` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `user_id` int(11) UNSIGNED DEFAULT NULL,
    `date` datetime NOT NULL,
    `success` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `auth_logins`
  --
  
  INSERT INTO `auth_logins` (`id`, `ip_address`, `email`, `user_id`, `date`, `success`) VALUES
  (1, '::1', 'dianatakarya@gmail.com', 1, '2021-04-26 18:32:21', 1),
  (2, '::1', 'dianatakarya@gmail.com', 1, '2021-04-26 18:41:24', 1),
  (3, '::1', 'hafied', NULL, '2021-04-26 19:00:11', 0),
  (4, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-26 19:02:01', 1),
  (5, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-26 19:03:27', 1),
  (6, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-26 19:07:16', 1),
  (7, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-26 19:31:29', 1),
  (8, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-27 11:44:16', 1),
  (9, '::1', 'hafied', NULL, '2021-04-27 12:18:28', 0),
  (10, '::1', 'hafied', NULL, '2021-04-27 12:18:41', 0),
  (11, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-27 12:18:50', 1),
  (12, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-27 23:40:21', 1),
  (13, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-28 00:39:35', 1),
  (14, '::1', 'hafied', NULL, '2021-04-28 03:22:34', 0),
  (15, '::1', 'hafied', NULL, '2021-04-28 03:22:39', 0),
  (16, '::1', 'hafied', NULL, '2021-04-28 03:22:59', 0),
  (17, '::1', 'hafied', NULL, '2021-04-28 03:23:10', 0),
  (18, '::1', 'hafied', NULL, '2021-04-28 03:23:18', 0),
  (19, '::1', 'hafied', NULL, '2021-04-28 03:30:51', 0),
  (20, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-28 03:31:34', 1),
  (21, '::1', 'hafied', NULL, '2021-04-28 04:19:09', 0),
  (22, '::1', 'hafied', NULL, '2021-04-28 04:19:17', 0),
  (23, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-28 04:19:25', 1),
  (24, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-28 08:02:51', 1),
  (25, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-28 09:01:18', 1),
  (26, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-28 09:10:07', 1),
  (27, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-28 16:43:29', 1),
  (28, '::1', 'khalifatulhafied@gmail.com', 3, '2021-04-29 06:02:37', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_permissions`
  --
  
  CREATE TABLE `auth_permissions` (
    `id` int(11) UNSIGNED NOT NULL,
    `name` varchar(255) NOT NULL,
    `description` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_reset_attempts`
  --
  
  CREATE TABLE `auth_reset_attempts` (
    `id` int(11) UNSIGNED NOT NULL,
    `email` varchar(255) NOT NULL,
    `ip_address` varchar(255) NOT NULL,
    `user_agent` varchar(255) NOT NULL,
    `token` varchar(255) DEFAULT NULL,
    `created_at` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_tokens`
  --
  
  CREATE TABLE `auth_tokens` (
    `id` int(11) UNSIGNED NOT NULL,
    `selector` varchar(255) NOT NULL,
    `hashedValidator` varchar(255) NOT NULL,
    `user_id` int(11) UNSIGNED NOT NULL,
    `expires` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `auth_users_permissions`
  --
  
  CREATE TABLE `auth_users_permissions` (
    `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
    `permission_id` int(11) UNSIGNED NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `komik`
  --
  
  CREATE TABLE `komik` (
    `id` int(11) NOT NULL,
    `judul` varchar(255) NOT NULL,
    `slug` varchar(255) NOT NULL,
    `penulis` varchar(255) NOT NULL,
    `penerbit` varchar(255) NOT NULL,
    `ttl` date NOT NULL,
    `ssb` varchar(20) NOT NULL,
    `ayah` varchar(20) NOT NULL,
    `ibu` varchar(20) NOT NULL,
    `administrasi` varchar(20) NOT NULL,
    `goldar` char(2) NOT NULL,
    `kelamin` varchar(20) NOT NULL,
    `bBadan` int(10) NOT NULL,
    `tBadan` int(10) NOT NULL,
    `kota` varchar(20) NOT NULL,
    `sampul` varchar(255) NOT NULL,
    `sd` varchar(20) DEFAULT NULL,
    `smp` varchar(20) DEFAULT NULL,
    `akademi` text DEFAULT NULL,
    `prestasi` text DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `komik`
  --
  
  INSERT INTO `komik` (`id`, `judul`, `slug`, `penulis`, `penerbit`, `ttl`, `ssb`, `ayah`, `ibu`, `administrasi`, `goldar`, `kelamin`, `bBadan`, `tBadan`, `kota`, `sampul`, `sd`, `smp`, `akademi`, `prestasi`, `created_at`, `updated_at`) VALUES
  (46, 'Rian Kusuma', 'rian-kusuma', 'Batu Ampar', '081299777536', '2021-04-04', 'Bina Taruna', 'Koko', 'Cece', 'AKTE', 'A', 'Laki-Laki', 160, 35, 'Batam', '1619618685_aaf84e4ca691c9aa98bd.jpg', 'SD Negeri 02 Batam', 'SMP Negeri 4 BAtam', 'Rian Kusuma, SSB Bina Taruna 2020 Posisi MF', 'Rian Kusuma, Liga Nusantara, Juara 1, SSB Bina Taruna Posisi MF', '2021-04-28 08:09:48', '2021-04-28 09:04:45');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `version` varchar(255) NOT NULL,
    `class` varchar(255) NOT NULL,
    `group` varchar(255) NOT NULL,
    `namespace` varchar(255) NOT NULL,
    `time` int(11) NOT NULL,
    `batch` int(11) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
  (1, '2017-11-20-223112', 'Myth\\Auth\\Database\\Migrations\\CreateAuthTables', 'default', 'Myth\\Auth', 1619478715, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(11) UNSIGNED NOT NULL,
    `email` varchar(255) NOT NULL,
    `username` varchar(30) DEFAULT NULL,
    `password_hash` varchar(255) NOT NULL,
    `reset_hash` varchar(255) DEFAULT NULL,
    `reset_at` datetime DEFAULT NULL,
    `reset_expires` datetime DEFAULT NULL,
    `activate_hash` varchar(255) DEFAULT NULL,
    `status` varchar(255) DEFAULT NULL,
    `status_message` varchar(255) DEFAULT NULL,
    `active` tinyint(1) NOT NULL DEFAULT 0,
    `force_pass_reset` tinyint(1) NOT NULL DEFAULT 0,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    `deleted_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `email`, `username`, `password_hash`, `reset_hash`, `reset_at`, `reset_expires`, `activate_hash`, `status`, `status_message`, `active`, `force_pass_reset`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (1, 'dianatakarya@gmail.com', 'hafied17', '$2y$10$UbjkmctZ/TgCYwjkUjBClewi32UrIE7uPcR15kVCHGuU30PEH40i.', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '2021-04-26 18:32:11', '2021-04-26 18:32:11', NULL),
  (3, 'khalifatulhafied@gmail.com', 'hafied', '$2y$10$Fov5lK8stvLjBWN/G7.eTenmRK//z6sMrYgYtknIwc6PceEkc/ZYm', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '2021-04-26 19:01:46', '2021-04-26 19:01:46', NULL);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `auth_activation_attempts`
  --
  ALTER TABLE `auth_activation_attempts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `auth_groups`
  --
  ALTER TABLE `auth_groups`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `auth_groups_permissions`
  --
  ALTER TABLE `auth_groups_permissions`
    ADD KEY `auth_groups_permissions_permission_id_foreign` (`permission_id`),
    ADD KEY `group_id_permission_id` (`group_id`,`permission_id`);
  
  --
  -- Indexes for table `auth_groups_users`
  --
  ALTER TABLE `auth_groups_users`
    ADD KEY `auth_groups_users_user_id_foreign` (`user_id`),
    ADD KEY `group_id_user_id` (`group_id`,`user_id`);
  
  --
  -- Indexes for table `auth_logins`
  --
  ALTER TABLE `auth_logins`
    ADD PRIMARY KEY (`id`),
    ADD KEY `email` (`email`),
    ADD KEY `user_id` (`user_id`);
  
  --
  -- Indexes for table `auth_permissions`
  --
  ALTER TABLE `auth_permissions`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `auth_reset_attempts`
  --
  ALTER TABLE `auth_reset_attempts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `auth_tokens`
  --
  ALTER TABLE `auth_tokens`
    ADD PRIMARY KEY (`id`),
    ADD KEY `auth_tokens_user_id_foreign` (`user_id`),
    ADD KEY `selector` (`selector`);
  
  --
  -- Indexes for table `auth_users_permissions`
  --
  ALTER TABLE `auth_users_permissions`
    ADD KEY `auth_users_permissions_permission_id_foreign` (`permission_id`),
    ADD KEY `user_id_permission_id` (`user_id`,`permission_id`);
  
  --
  -- Indexes for table `komik`
  --
  ALTER TABLE `komik`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `email` (`email`),
    ADD UNIQUE KEY `username` (`username`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `auth_activation_attempts`
  --
  ALTER TABLE `auth_activation_attempts`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `auth_groups`
  --
  ALTER TABLE `auth_groups`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `auth_logins`
  --
  ALTER TABLE `auth_logins`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
  
  --
  -- AUTO_INCREMENT for table `auth_permissions`
  --
  ALTER TABLE `auth_permissions`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `auth_reset_attempts`
  --
  ALTER TABLE `auth_reset_attempts`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `auth_tokens`
  --
  ALTER TABLE `auth_tokens`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `komik`
  --
  ALTER TABLE `komik`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `auth_groups_permissions`
  --
  ALTER TABLE `auth_groups_permissions`
    ADD CONSTRAINT `auth_groups_permissions_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `auth_groups` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `auth_groups_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `auth_permissions` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `auth_groups_users`
  --
  ALTER TABLE `auth_groups_users`
    ADD CONSTRAINT `auth_groups_users_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `auth_groups` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `auth_groups_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `auth_tokens`
  --
  ALTER TABLE `auth_tokens`
    ADD CONSTRAINT `auth_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `auth_users_permissions`
  --
  ALTER TABLE `auth_users_permissions`
    ADD CONSTRAINT `auth_users_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `auth_permissions` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `auth_users_permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  COMMIT;
  
  /*!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 */;
  