-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.7.33 - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for db_kepegawaian
CREATE DATABASE IF NOT EXISTS `db_kepegawaian` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `db_kepegawaian`;

-- Dumping structure for table db_kepegawaian.anak_kandungs
CREATE TABLE IF NOT EXISTS `anak_kandungs` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pegawai_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_anak` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `urut` int(11) DEFAULT NULL,
  `valid` tinyint(1) NOT NULL DEFAULT '1',
  `is_ajuan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.anak_kandungs: ~0 rows (approximately)
/*!40000 ALTER TABLE `anak_kandungs` DISABLE KEYS */;
/*!40000 ALTER TABLE `anak_kandungs` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.cutis
CREATE TABLE IF NOT EXISTS `cutis` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pegawai_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_awal` date DEFAULT NULL,
  `tanggal_akhir` date DEFAULT NULL,
  `alasan_cuti` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valid` int(11) NOT NULL DEFAULT '0',
  `is_ajuan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.cutis: ~0 rows (approximately)
/*!40000 ALTER TABLE `cutis` DISABLE KEYS */;
/*!40000 ALTER TABLE `cutis` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.failed_jobs: ~0 rows (approximately)
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.jenjang_pendidikans
CREATE TABLE IF NOT EXISTS `jenjang_pendidikans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_jenjang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.jenjang_pendidikans: ~10 rows (approximately)
/*!40000 ALTER TABLE `jenjang_pendidikans` DISABLE KEYS */;
INSERT INTO `jenjang_pendidikans` (`id`, `nama_jenjang`, `created_at`, `updated_at`) VALUES
	(1, 'SD', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(2, 'SMP/SLTP', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(3, 'SMA/SMK/SLTA', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(4, 'Diploma I', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(5, 'Diploma II', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(6, 'Diploma III', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(7, 'Diploma IV', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(8, 'Sarjana', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(9, 'Magister', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(10, 'Doktor', '2022-12-31 07:00:06', '2022-12-31 07:00:06');
/*!40000 ALTER TABLE `jenjang_pendidikans` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.kenaikan_berkalas
CREATE TABLE IF NOT EXISTS `kenaikan_berkalas` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pegawai_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `berkala_ke` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_kenaikan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valid` tinyint(1) NOT NULL DEFAULT '1',
  `is_ajuan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.kenaikan_berkalas: ~0 rows (approximately)
/*!40000 ALTER TABLE `kenaikan_berkalas` DISABLE KEYS */;
/*!40000 ALTER TABLE `kenaikan_berkalas` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.kenaikan_pangkats
CREATE TABLE IF NOT EXISTS `kenaikan_pangkats` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pegawai_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pangkat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kenaikan_ke` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date NOT NULL,
  `valid` tinyint(1) NOT NULL DEFAULT '1',
  `is_ajuan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.kenaikan_pangkats: ~0 rows (approximately)
/*!40000 ALTER TABLE `kenaikan_pangkats` DISABLE KEYS */;
/*!40000 ALTER TABLE `kenaikan_pangkats` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.migrations: ~15 rows (approximately)
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_resets_table', 1),
	(3, '2019_08_19_000000_create_failed_jobs_table', 1),
	(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(5, '2022_04_17_062635_create_pegawais_table', 1),
	(6, '2022_04_17_064834_create_unit_kerjas_table', 1),
	(7, '2022_04_17_070154_create_permission_tables', 1),
	(8, '2022_04_24_040237_create_anak_kandungs_table', 1),
	(9, '2022_04_24_040500_create_riwayat_pendidikans_table', 1),
	(10, '2022_04_24_040659_create_riwayat_jas_table', 1),
	(11, '2022_04_24_041303_create_unit_unsaps_table', 1),
	(12, '2022_04_24_071500_create_kenaikan_berkalas_table', 1),
	(13, '2022_04_24_071512_create_kenaikan_pangkats_table', 1),
	(14, '2022_04_26_043621_create_jenjang_pendidikans_table', 1),
	(15, '2022_04_26_212902_create_cutis_table', 1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.model_has_permissions
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.model_has_permissions: ~0 rows (approximately)
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.model_has_roles
CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.model_has_roles: ~0 rows (approximately)
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.password_resets
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.password_resets: ~0 rows (approximately)
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.pegawais
CREATE TABLE IF NOT EXISTS `pegawais` (
  `pegawai_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nidn` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nitk` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nipy` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gelar_depan` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gelar_belakang` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jabatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `jk` enum('L','P') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'L',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_pasangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_ktp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_unsap` tinyint(1) NOT NULL DEFAULT '0',
  `tmt_awal` date DEFAULT NULL,
  `masa_kerja_tahun` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `masa_kerja_bulan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `validasi` int(11) NOT NULL DEFAULT '0',
  `is_ajuan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`pegawai_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.pegawais: ~0 rows (approximately)
/*!40000 ALTER TABLE `pegawais` DISABLE KEYS */;
INSERT INTO `pegawais` (`pegawai_id`, `nidn`, `nitk`, `nipy`, `nama`, `nik`, `gelar_depan`, `gelar_belakang`, `jabatan`, `tempat_lahir`, `tanggal_lahir`, `jk`, `status`, `nama_pasangan`, `alamat_ktp`, `is_unsap`, `tmt_awal`, `masa_kerja_tahun`, `masa_kerja_bulan`, `desc`, `active`, `validasi`, `is_ajuan`, `created_at`, `updated_at`) VALUES
	('0733f48e-7efc-4cf1-a7ba-f3731fc7d72b', NULL, NULL, NULL, 'Irfan Fadil', NULL, NULL, NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 0, 0, '2023-01-04 07:24:05', '2023-01-04 07:24:05');
/*!40000 ALTER TABLE `pegawais` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.permissions: ~0 rows (approximately)
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.personal_access_tokens: ~0 rows (approximately)
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.riwayat_jas
CREATE TABLE IF NOT EXISTS `riwayat_jas` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pegawai_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ja` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_urut` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tmt_ja` date NOT NULL,
  `valid` tinyint(1) NOT NULL DEFAULT '1',
  `is_ajuan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.riwayat_jas: ~0 rows (approximately)
/*!40000 ALTER TABLE `riwayat_jas` DISABLE KEYS */;
/*!40000 ALTER TABLE `riwayat_jas` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.riwayat_pendidikans
CREATE TABLE IF NOT EXISTS `riwayat_pendidikans` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pegawai_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenjang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_sekolah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun_lulus` int(11) NOT NULL,
  `valid` tinyint(1) NOT NULL DEFAULT '1',
  `is_ajuan` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.riwayat_pendidikans: ~0 rows (approximately)
/*!40000 ALTER TABLE `riwayat_pendidikans` DISABLE KEYS */;
/*!40000 ALTER TABLE `riwayat_pendidikans` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.roles: ~5 rows (approximately)
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'admin', 'web', '2022-12-31 07:00:05', '2022-12-31 07:00:05'),
	(2, 'pegawai', 'web', '2022-12-31 07:00:05', '2022-12-31 07:00:05'),
	(3, 'dekanat', 'web', '2022-12-31 07:00:05', '2022-12-31 07:00:05'),
	(4, 'rektorat', 'web', '2022-12-31 07:00:05', '2022-12-31 07:00:05'),
	(5, 'yayasan', 'web', '2022-12-31 07:00:05', '2022-12-31 07:00:05');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.role_has_permissions
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.role_has_permissions: ~0 rows (approximately)
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.unit_kerjas
CREATE TABLE IF NOT EXISTS `unit_kerjas` (
  `id` int(11) NOT NULL,
  `nama_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `singkatan_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.unit_kerjas: ~4 rows (approximately)
/*!40000 ALTER TABLE `unit_kerjas` DISABLE KEYS */;
INSERT INTO `unit_kerjas` (`id`, `nama_unit`, `singkatan_unit`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'Yayasan Sebelas April', 'YPSA', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(2, 'Universitas Sebelas April', 'UNSAP', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(3, 'SMP YPSA', 'SMP YPSA', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(4, 'SMK YPSA', 'SMK YPSA', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06');
/*!40000 ALTER TABLE `unit_kerjas` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.unit_unsaps
CREATE TABLE IF NOT EXISTS `unit_unsaps` (
  `id` int(11) NOT NULL,
  `nama_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `singkatan_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.unit_unsaps: ~8 rows (approximately)
/*!40000 ALTER TABLE `unit_unsaps` DISABLE KEYS */;
INSERT INTO `unit_unsaps` (`id`, `nama_unit`, `singkatan_unit`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'Rektorat', 'UNSAP', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(2, 'Fakultas Keguruan dan Ilmu Pendidikan', 'FKIP', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(3, 'Fakultas Ilmu Budaya', 'FIB', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(4, 'Fakultas Ekonomi Bisnis', 'FEB', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(5, 'Fakultas Ilmu Sosial dan Ilmu Politik', 'FISIP', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(6, 'Fakultas Ilmu Kesehatan', 'FIKES', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(7, 'Fakultas Teknologi Informasi', 'FTI', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	(8, 'Sekolah Tinggi Agama Islam Sebelas April', 'STAI', 'Aktif', '2022-12-31 07:00:06', '2022-12-31 07:00:06');
/*!40000 ALTER TABLE `unit_unsaps` ENABLE KEYS */;

-- Dumping structure for table db_kepegawaian.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_unsap` tinyint(1) NOT NULL DEFAULT '0',
  `is_aktif` tinyint(1) NOT NULL DEFAULT '0',
  `unit_id` int(11) NOT NULL,
  `unit_fakultas` int(11) DEFAULT NULL,
  `nomor_handphone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table db_kepegawaian.users: ~5 rows (approximately)
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `is_unsap`, `is_aktif`, `unit_id`, `unit_fakultas`, `nomor_handphone`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES
	('0733f48e-7efc-4cf1-a7ba-f3731fc7d72b', 'Irfan Fadil', 'fadilirfan@unsap.ac.id', NULL, '$2y$10$nUZbcP55noKT3PcJ28P/fuwVg9q84jv6H9lHYxKUv3TubfTM.qmHu', 0, 0, 2, NULL, '085220717928', 'pegawai', NULL, '2023-01-04 07:24:05', '2023-01-04 07:24:05'),
	('1a5bbca9-08eb-4252-a7b9-997ea6ff39d1', 'Dekan FTI', 'dekan_fti@unsap.ac.id', NULL, '$2y$10$c8qKT3ImWQKN/x8DatCom.PLo7SRqOQUz.2HW74VBwD/qHQ5Pm9dS', 0, 1, 0, NULL, NULL, 'dekanat', NULL, '2022-12-31 07:00:05', '2022-12-31 07:00:05'),
	('1cd8adfc-c1b8-473c-99cc-37cb8eb372fe', 'Pegawai 1', 'pegawai@unsap.ac.id', NULL, '$2y$10$s6BSKLNNIS4U.ZaZhoTYr.gJc2bJtfe1dC6EIbV3znoi0Z4UwMsEa', 0, 1, 0, NULL, NULL, 'pegawai', NULL, '2022-12-31 07:00:05', '2022-12-31 07:00:05'),
	('45d0487f-3be8-4124-9c6e-b53a4de6f5c3', 'YPSA', 'ypsa@unsap.ac.id', NULL, '$2y$10$Cdh.NL92MTMjbEBtS3gyBeogXUpaVWCzFPhwdCPo.uEGwmSR.N8Za', 0, 1, 0, NULL, NULL, 'yayasan', NULL, '2022-12-31 07:00:06', '2022-12-31 07:00:06'),
	('83769a3c-610e-4b5d-8526-2ef86054deea', 'Admin', 'admin@unsap.ac.id', NULL, '$2y$10$YywWxs4kHnT0KanvXNxBZOk43rXyjt.raThkjY1SoZm8qLcBWJLxO', 0, 1, 0, NULL, NULL, 'admin', NULL, '2022-12-31 07:00:05', '2022-12-31 07:00:05'),
	('ec459cde-fcbb-49e7-9405-126c39c26e4f', 'Rektorat', 'rektorat@unsap.ac.id', NULL, '$2y$10$zsScsL9n0zig7PJD2ClzaOb359TPmt0MNHlmasXbHyy2DFC8.5oIC', 0, 1, 0, NULL, NULL, 'rektorat', NULL, '2022-12-31 07:00:06', '2022-12-31 07:00:06');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;