--
-- Host: localhost    Database: keuangan_jayakarta
-- ------------------------------------------------------


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

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_username_unique` (`username`),
  KEY `users_role_id_index` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,2,'User','user@example.com','demo-user',NULL,'$2y$10$/7IifsGhGW9xvb4oSZX94OgaIcuYlWgSwa2cBIP7.D.eFswxGUT7K','G9T2IgeEc966rKmbWRxs42wGWYrZtSEGGNo7JYn5jyhP1MQKKfpuOBchcyZQ','demo-user-user','2020-02-01 08:45:19','2020-03-25 10:21:51','2020-03-25 10:21:51'),(2,1,'Administrator','admin@example.com','demo-admin',NULL,'$2y$10$4sTqRtqq6kqJv9v/htGtf.1e63pKoWICIvD69eqRZM2t5jgXrD8Gu','mN4dqtBcMoNrwnnlDhXhsVJzIietJdX9QiVcZtJi13YxCqiWJxODQcJPQbJl','demo-admin-administrator','2020-02-01 08:46:09','2020-02-01 08:46:09',NULL),(3,3,'bag-akademik','akademik@jayakarta.ac.id','demo-akademik',NULL,'$2y$10$/19mTkTCwtCJeQUsJ/.cceh3LoxC8HYeAobF6Q42MABl.e0Hzqlxq','TjaqIEH7bSuZBdOHtOAQdIqPtQmzdSNiVKLxGUggqRhZlKADGoytARSGVghp','demo-akademik-bag-akademik','2020-03-25 02:38:28','2020-03-25 02:38:28',NULL),(4,1,'Mobile Apps','mobile-apps@example.com','mobile-apps',NULL,'$2y$10$WykCMsGRLfjnJAJnV7NmB.8V7GhOVGf2XdYSYgPc6kfGW27oPCHsK',NULL,'mobile-apps-mobile-apps','2020-08-13 15:17:09','2020-08-13 15:17:09',NULL),(5,1,'Jayakarta Admin','jayakarta-admin@example.com','jayakarta-admin',NULL,'$2y$10$YwmJDOqLtie.471SSS9tZuDwcHwmNmeLaa2IsNvRH08701TSAcRMa',NULL,'jayakarta-admin-jayakarta-admin','2020-08-13 15:17:09','2020-08-13 15:17:09',NULL);


