/*
 Navicat Premium Data Transfer

 Source Server         : MySQL Windows
 Source Server Type    : MySQL
 Source Server Version : 50739 (5.7.39)
 Source Host           : localhost:3306
 Source Schema         : absensi_sekolah

 Target Server Type    : MySQL
 Target Server Version : 50739 (5.7.39)
 File Encoding         : 65001

 Date: 10/07/2025 14:04:59
*/


-- ----------------------------
-- Records of cache_locks
-- ----------------------------

-- ----------------------------
-- Table structure for divisi_shifts
-- ----------------------------
CREATE TABLE `divisi_shifts`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `divisi_id` bigint(20) UNSIGNED NOT NULL,
  `shift_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `divisi_shifts_divisi_id_foreign`(`divisi_id`) USING BTREE,
  INDEX `divisi_shifts_shift_id_foreign`(`shift_id`) USING BTREE,
  CONSTRAINT `divisi_shifts_divisi_id_foreign` FOREIGN KEY (`divisi_id`) REFERENCES `divisis` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `divisi_shifts_shift_id_foreign` FOREIGN KEY (`shift_id`) REFERENCES `shifts` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of divisi_shifts
-- ----------------------------

-- ----------------------------
-- Table structure for divisis
-- ----------------------------
CREATE TABLE `divisis`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of divisis
-- ----------------------------
INSERT INTO `divisis` VALUES (6, '2df63e96-b296-4d89-b845-fdd2e4270f20', 'Apoteker', 'Apoteker', '2025-05-21 04:28:03', '2025-05-21 04:31:30');
INSERT INTO `divisis` VALUES (7, '2efebd75-a08a-42f7-a591-ed537c5b1b34', 'Dokter_Umum_IGD', 'dokter IGD', '2025-05-21 04:28:43', '2025-05-21 04:32:18');
INSERT INTO `divisis` VALUES (8, '73a140d6-2975-46ca-9c85-35aa8e7ebf29', 'PERAWAT_HD_RAJAL', 'perawat HD', '2025-05-21 04:29:22', '2025-05-21 07:40:42');
INSERT INTO `divisis` VALUES (9, '8ca86588-dc04-4e52-adbd-aee3391e367b', 'PENATA', 'Perawat IBS', '2025-05-21 04:29:45', '2025-05-21 07:01:42');
INSERT INTO `divisis` VALUES (10, '01c0d6a5-a972-4674-a288-40b1082d3e93', 'ASISTEN', 'ASISTEN', '2025-05-21 07:01:50', '2025-05-21 07:40:54');
INSERT INTO `divisis` VALUES (11, '36dcaca8-5d8e-4ada-92df-3e837aa3de2a', 'PERAWAT', 'perawat/bidan', '2025-05-21 07:06:51', '2025-05-21 07:39:01');
INSERT INTO `divisis` VALUES (12, '85c5d34b-3f95-4b6c-9547-bef8cbd6d095', 'PERAWAT_HD_RANAP', 'PERAWAT_HD_RANAP', '2025-05-21 07:25:32', '2025-05-21 07:40:48');
INSERT INTO `divisis` VALUES (14, '013d7af3-41cb-4b51-8d6d-feeea8a118d6', 'JTL', 'JTL', '2025-05-21 08:12:05', '2025-05-21 08:12:05');
INSERT INTO `divisis` VALUES (16, 'ae4676ee-f020-4c01-9bf8-566f9ba27bbc', 'tes', 'Tesing gannn', '2025-07-10 06:55:51', '2025-07-10 06:56:33');

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of failed_jobs
-- ----------------------------

-- ----------------------------
-- Table structure for job_batches
-- ----------------------------
CREATE TABLE `job_batches`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `cancelled_at` int(11) NULL DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of job_batches
-- ----------------------------

-- ----------------------------
-- Table structure for jobs
-- ----------------------------
CREATE TABLE `jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED NULL DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `jobs_queue_index`(`queue`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of jobs
-- ----------------------------

-- ----------------------------
-- Table structure for menus
-- ----------------------------
CREATE TABLE `menus`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nama_menu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `menus_parent_id_foreign`(`parent_id`) USING BTREE,
  CONSTRAINT `menus_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES (1, 'bb5e49c9-5c7b-4840-bb4b-b48a96e8a260', 'user.index', 'ti ti-user', 'User', 5, '2025-02-18 02:01:15', '2025-05-21 03:15:30', 2);
INSERT INTO `menus` VALUES (2, '6ee7d0a1-4aca-4cc5-ba7b-7eb636977c57', 'settings.edit', 'ti ti-settings', 'Pengaturan', NULL, '2025-02-18 02:10:08', '2025-07-10 06:48:57', 3);
INSERT INTO `menus` VALUES (3, '9b1c00d5-5b6b-4161-b976-87a6da9573d1', 'role.index', 'ti ti-shield', 'Role', 5, '2025-02-18 02:10:58', '2025-05-21 03:15:30', 3);
INSERT INTO `menus` VALUES (4, '1f2f5340-6912-42da-9331-ab768c5d44ee', 'menu.index', 'ti ti-list', 'Menu', 5, '2025-02-18 02:15:39', '2025-05-21 03:15:30', 4);
INSERT INTO `menus` VALUES (5, 'f602469c-7303-4df9-9164-76ba63e2a5b0', '#', 'ti ti-key', 'Autentikasi', NULL, '2025-02-18 02:17:37', '2025-05-21 03:15:30', 1);
INSERT INTO `menus` VALUES (7, '0a0d3ce4-11af-4854-b7e8-ddbc7e460a8c', 'divisi.index', 'ti ti-building', 'Divisi', 14, '2025-02-18 03:31:06', '2025-05-21 03:15:30', 7);
INSERT INTO `menus` VALUES (14, '65e1728b-0ea5-4cfd-8a60-50be200e94f8', '#', 'ti ti-list', 'Master Data', NULL, '2025-02-25 13:53:39', '2025-07-10 06:48:57', 2);

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (9, '0001_01_01_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (10, '0001_01_01_000001_create_cache_table', 1);
INSERT INTO `migrations` VALUES (11, '0001_01_01_000002_create_jobs_table', 1);
INSERT INTO `migrations` VALUES (12, '2025_02_18_013140_create_settings_table', 1);
INSERT INTO `migrations` VALUES (13, '2025_02_18_014202_create_permission_tables', 1);
INSERT INTO `migrations` VALUES (14, '2025_02_18_015415_create_menus_table', 2);
INSERT INTO `migrations` VALUES (15, '2025_02_18_015517_create_role_menus_table', 2);
INSERT INTO `migrations` VALUES (16, '2025_02_18_031243_create_divisis_table', 3);
INSERT INTO `migrations` VALUES (17, '2025_02_18_031322_create_jabatans_table', 3);
INSERT INTO `migrations` VALUES (19, '2025_02_18_040607_create_radii_table', 5);
INSERT INTO `migrations` VALUES (21, '2025_02_18_034610_create_shifts_table', 6);
INSERT INTO `migrations` VALUES (22, '2025_02_18_061406_create_jam_kerjas_table', 6);
INSERT INTO `migrations` VALUES (23, '2025_02_19_005354_create_divisi_shifts_table', 6);
INSERT INTO `migrations` VALUES (34, '2025_02_20_034830_create_pegawai_masters_table', 7);
INSERT INTO `migrations` VALUES (35, '2025_02_22_011112_create_pegawai_shifts_table', 8);
INSERT INTO `migrations` VALUES (36, '2025_02_24_014835_create_presensis_table', 8);
INSERT INTO `migrations` VALUES (37, '2025_02_24_032535_create_personal_access_tokens_table', 9);
INSERT INTO `migrations` VALUES (38, '2025_02_24_033112_create_o_t_p_verifications_table', 10);
INSERT INTO `migrations` VALUES (41, '2025_02_25_005648_create_user_photos_table', 11);
INSERT INTO `migrations` VALUES (42, '2025_05_14_041214_create_proporsi_fairness_table', 12);
INSERT INTO `migrations` VALUES (43, '2025_05_14_044119_create_grade_table', 13);
INSERT INTO `migrations` VALUES (44, '2025_05_14_050000_create_sumbers_table', 14);
INSERT INTO `migrations` VALUES (45, '2025_05_14_050000_create_sumber_table', 15);
INSERT INTO `migrations` VALUES (46, '2024_01_15_create_remunerasi_batch_table', 16);
INSERT INTO `migrations` VALUES (47, '2024_01_15_create_remunerasi_source_table', 17);
INSERT INTO `migrations` VALUES (48, '2024_03_19_000001_create_detail_source_table', 18);

-- ----------------------------
-- Table structure for model_has_permissions
-- ----------------------------
CREATE TABLE `model_has_permissions`  (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_permissions_model_id_model_type_index`(`model_id`, `model_type`) USING BTREE,
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of model_has_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for model_has_roles
-- ----------------------------
CREATE TABLE `model_has_roles`  (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_roles_model_id_model_type_index`(`model_id`, `model_type`) USING BTREE,
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of model_has_roles
-- ----------------------------
INSERT INTO `model_has_roles` VALUES (1, 'App\\Models\\User', 1);
INSERT INTO `model_has_roles` VALUES (3, 'App\\Models\\User', 8);
INSERT INTO `model_has_roles` VALUES (2, 'App\\Models\\User', 10);

-- ----------------------------
-- Records of password_reset_tokens
-- ----------------------------

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
CREATE TABLE `permissions`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `permissions_name_guard_name_unique`(`name`, `guard_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for role_has_permissions
-- ----------------------------
CREATE TABLE `role_has_permissions`  (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `role_id`) USING BTREE,
  INDEX `role_has_permissions_role_id_foreign`(`role_id`) USING BTREE,
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_has_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for role_menus
-- ----------------------------
CREATE TABLE `role_menus`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `menu_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_menus_role_id_foreign`(`role_id`) USING BTREE,
  INDEX `role_menus_menu_id_foreign`(`menu_id`) USING BTREE,
  CONSTRAINT `role_menus_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `role_menus_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_menus
-- ----------------------------
INSERT INTO `role_menus` VALUES (1, 1, 1, NULL, NULL);
INSERT INTO `role_menus` VALUES (2, 1, 2, NULL, NULL);
INSERT INTO `role_menus` VALUES (3, 1, 3, NULL, NULL);
INSERT INTO `role_menus` VALUES (4, 1, 4, NULL, NULL);
INSERT INTO `role_menus` VALUES (5, 1, 5, NULL, NULL);
INSERT INTO `role_menus` VALUES (7, 1, 7, NULL, NULL);
INSERT INTO `role_menus` VALUES (26, 1, 14, NULL, NULL);
INSERT INTO `role_menus` VALUES (31, 2, 1, NULL, NULL);
INSERT INTO `role_menus` VALUES (33, 2, 3, NULL, NULL);
INSERT INTO `role_menus` VALUES (34, 2, 4, NULL, NULL);
INSERT INTO `role_menus` VALUES (35, 2, 5, NULL, NULL);
INSERT INTO `role_menus` VALUES (37, 2, 7, NULL, NULL);
INSERT INTO `role_menus` VALUES (43, 2, 14, NULL, NULL);
INSERT INTO `role_menus` VALUES (45, 3, 1, NULL, NULL);
INSERT INTO `role_menus` VALUES (46, 3, 2, NULL, NULL);
INSERT INTO `role_menus` VALUES (47, 3, 3, NULL, NULL);
INSERT INTO `role_menus` VALUES (48, 3, 4, NULL, NULL);
INSERT INTO `role_menus` VALUES (49, 3, 5, NULL, NULL);
INSERT INTO `role_menus` VALUES (50, 3, 7, NULL, NULL);
INSERT INTO `role_menus` VALUES (51, 3, 14, NULL, NULL);

-- ----------------------------
-- Table structure for roles
-- ----------------------------
CREATE TABLE `roles`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `roles_name_guard_name_unique`(`name`, `guard_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'SUPERADMIN', 'web', '2025-02-18 01:56:49', '2025-02-18 01:56:49');
INSERT INTO `roles` VALUES (2, 'Guru', 'web', '2025-02-24 04:27:29', '2025-07-10 06:39:41');
INSERT INTO `roles` VALUES (3, 'admin', 'web', '2025-03-12 12:48:41', '2025-03-12 12:48:41');

-- ----------------------------
-- Table structure for sessions
-- ----------------------------
CREATE TABLE `sessions`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sessions_user_id_index`(`user_id`) USING BTREE,
  INDEX `sessions_last_activity_index`(`last_activity`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sessions
-- ----------------------------
INSERT INTO `sessions` VALUES ('Agt9oFdTS8cKGK28syHhxhUV8lPcJkRCi0wGPANo', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiRnZRMGt5MnlkRDFIbkE3Zkc0dWt1V1Y2VU9jMDFkRDV2VVF5V256NCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM0OiJodHRwOi8vYWJzZW5zaS1zZWtvbGFoLnRlc3QvZGl2aXNpIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1752130839);

-- ----------------------------
-- Table structure for settings
-- ----------------------------
CREATE TABLE `settings`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `website_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `website_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `favicon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of settings
-- ----------------------------
INSERT INTO `settings` VALUES (1, 'Absensi Sekolah', 'Absensi Sekolah adalah aplikasi web untuk mencatat kehadiran siswa secara digital, lengkap dengan scan QR Code, rekap otomatis, dan pengelolaan data kelas, siswa, serta tahun ajaran.', 'logos/1741239243_logo.png', 'favicons/1739844536_favicon.webp', 'falehjamaluddin@gmail.com', '085281411550', 'Parenggan, Kec pati, Kab pati', '2025-02-18 02:08:56', '2025-07-10 06:55:41');

-- ----------------------------
-- Table structure for shifts
-- ----------------------------
CREATE TABLE `shifts`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_shift` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_shift` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `toleransi_terlambat` int(11) NOT NULL DEFAULT 0,
  `status` enum('1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `waktu_mulai_masuk` int(11) NULL DEFAULT NULL,
  `waktu_akhir_masuk` int(11) NULL DEFAULT NULL,
  `waktu_mulai_keluar` int(11) NULL DEFAULT NULL,
  `waktu_akhir_keluar` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of shifts
-- ----------------------------
INSERT INTO `shifts` VALUES (12, 'd5181a94-150f-41b1-ac83-f5df072eefcb', 'SHIFT SORE', 'SS', 'OK', 20, '1', '2025-02-19 02:29:01', '2025-03-06 14:01:23', -10, 20, 0, 10);
INSERT INTO `shifts` VALUES (13, '4f8fc7b3-963a-43c6-b3cf-013e6389691d', 'SHIFT PAGI', 'SP', 'OK', 20, '1', '2025-02-19 02:29:30', '2025-03-10 11:56:09', -60, 60, -60, 20);
INSERT INTO `shifts` VALUES (14, '20a6a8fa-df3e-4ab2-ba2e-2e9be3c5b332', 'SHIFT MALAM', 'SM', NULL, 20, '1', '2025-02-19 02:30:18', '2025-03-10 09:45:41', -60, 60, -60, 60);

