ALTER TABLE `student_attendances` CHANGE `status` `status` ENUM('hadir','izin','sakit','alpha','telat') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;
ALTER TABLE `student_attendances` ADD `school_id` INT NOT NULL AFTER `attendance_session_id`;
ALTER TABLE `student_attendances` ADD FOREIGN KEY (`school_id`) REFERENCES `schools`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-----------------------
ALTER TABLE `teacher_attendances` CHANGE `status_attendance` `status_attendance` ENUM('in','out','not_present') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL;
ALTER TABLE `teacher_attendances` ADD `created_by` BIGINT NULL DEFAULT NULL AFTER `distance`;
ALTER TABLE `teacher_attendances` ADD FOREIGN KEY (`created_by`) REFERENCES `admins`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
ALTER TABLE `teacher_attendances` CHANGE `status_attendance` `status_attendance` ENUM('in','out','not_present','permission','sick') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL;

--------------------------------------
ALTER TABLE `student_attendances` CHANGE `attendance_session_id` `attendance_session_id` BIGINT UNSIGNED NULL;
ALTER TABLE `student_attendances` ADD `created_by_teacher_piket` INT NULL DEFAULT NULL AFTER `note`;
ALTER TABLE `student_attendances` CHANGE `created_by_teacher_piket` `created_by_teacher_piket` BIGINT NULL DEFAULT NULL;
ALTER TABLE `student_attendances` ADD FOREIGN KEY (`created_by_teacher_piket`) REFERENCES `teachers`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;