--
-- Table structure and data converted from SQLite → MySQL
--

/*!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 */;

--
-- Table: `attendances`
--
CREATE TABLE IF NOT EXISTS `attendances` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `group_id` INT NOT NULL,
  `date` DATE NOT NULL,
  `user_id` INT NOT NULL,
  `user_uuid` VARCHAR(36) NOT NULL,
  `attendance_status` VARCHAR(20) NOT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  `course_id` INT NOT NULL,
  `period` INT NOT NULL,
  `teacher_id` INT,
  PRIMARY KEY (`id`),
  KEY `attendances_course_id_foreign` (`course_id`),
  KEY `attendances_group_id_foreign` (`group_id`),
  KEY `attendances_teacher_id_foreign` (`teacher_id`),
  KEY `attendances_user_id_foreign` (`user_id`),
  CONSTRAINT `attendances_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `attendances_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `attendances_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `users`(`id`) ON DELETE CASCADE,
  CONSTRAINT `attendances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `attendances`
  ADD UNIQUE KEY `attendance_unique` (`user_id`,`course_id`,`group_id`,`period`,`date`);

--
-- Table: `cache`
--
CREATE TABLE IF NOT EXISTS `cache` (
  `key` VARCHAR(255) NOT NULL,
  `value` TEXT NOT NULL,
  `expiration` INT NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `cache_locks`
--
CREATE TABLE IF NOT EXISTS `cache_locks` (
  `key` VARCHAR(255) NOT NULL,
  `owner` VARCHAR(255) NOT NULL,
  `expiration` INT NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `course_group`
--
CREATE TABLE IF NOT EXISTS `course_group` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `course_id` INT NOT NULL,
  `group_id` INT NOT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`),
  KEY `course_group_course_id_foreign` (`course_id`),
  KEY `course_group_group_id_foreign` (`group_id`),
  CONSTRAINT `course_group_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses`(`id`) ON DELETE CASCADE,
  CONSTRAINT `course_group_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `course_group`
  ADD UNIQUE KEY `course_group_course_id_group_id_unique` (`course_id`,`group_id`);

--
-- Table: `course_teacher_period`
--
CREATE TABLE IF NOT EXISTS `course_teacher_period` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `course_id` INT NOT NULL,
  `group_id` INT NOT NULL,
  `user_id` INT NOT NULL,
  `period` INT NOT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`),
  KEY `ctp_course_id_foreign` (`course_id`),
  KEY `ctp_group_id_foreign` (`group_id`),
  KEY `ctp_user_id_foreign` (`user_id`),
  CONSTRAINT `ctp_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses`(`id`) ON DELETE CASCADE,
  CONSTRAINT `ctp_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ON DELETE CASCADE,
  CONSTRAINT `ctp_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `course_teacher_period`
  ADD UNIQUE KEY `ctp_unique` (`course_id`,`group_id`,`user_id`,`period`);

--
-- Table: `course_user`
--
CREATE TABLE IF NOT EXISTS `course_user` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `course_id` INT NOT NULL,
  `user_id` INT NOT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`),
  KEY `course_user_course_id_foreign` (`course_id`),
  KEY `course_user_user_id_foreign` (`user_id`),
  CONSTRAINT `course_user_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses`(`id`) ON DELETE CASCADE,
  CONSTRAINT `course_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `course_user`
  ADD UNIQUE KEY `course_user_course_id_user_id_unique` (`course_id`,`user_id`);

--
-- Table: `courses`
--
CREATE TABLE IF NOT EXISTS `courses` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `course_name` VARCHAR(255) NOT NULL,
  `course_level` INT NULL,
  `course_value` DECIMAL(10,2) NULL,
  `uuid` VARCHAR(36) NOT NULL,
  `is_delete` TINYINT(1) NOT NULL DEFAULT 0,
  `group_id` INT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`),
  KEY `courses_group_id_foreign` (`group_id`),
  CONSTRAINT `courses_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `courses`
  ADD UNIQUE KEY `courses_uuid_unique` (`uuid`);

--
-- Table: `failed_jobs`
--
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `uuid` VARCHAR(36) NOT NULL,
  `connection` TEXT NOT NULL,
  `queue` TEXT NOT NULL,
  `payload` TEXT NOT NULL,
  `exception` TEXT NOT NULL,
  `failed_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `grades`
--
CREATE TABLE IF NOT EXISTS `grades` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `student_id` INT NOT NULL,
  `course_id` INT NOT NULL,
  `teacher_id` INT NOT NULL,
  `assessment_type` ENUM('test','classwork','homework') NOT NULL,
  `percentage` INT NOT NULL,
  `grade` INT NOT NULL,
  `date` DATE NOT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`),
  KEY `grades_course_id_foreign` (`course_id`),
  KEY `grades_student_id_foreign` (`student_id`),
  KEY `grades_teacher_id_foreign` (`teacher_id`),
  CONSTRAINT `grades_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses`(`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `users`(`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `group_user`
--
CREATE TABLE IF NOT EXISTS `group_user` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `group_id` INT NOT NULL,
  `user_id` INT NOT NULL,
  `assigned_by` INT NULL,
  `assigned_at` DATETIME,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`),
  KEY `group_user_group_id_foreign` (`group_id`),
  KEY `group_user_user_id_foreign` (`user_id`),
  KEY `group_user_assigned_by_foreign` (`assigned_by`),
  CONSTRAINT `group_user_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ON DELETE CASCADE,
  CONSTRAINT `group_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE,
  CONSTRAINT `group_user_assigned_by_foreign` FOREIGN KEY (`assigned_by`) REFERENCES `users`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `group_user`
  ADD UNIQUE KEY `group_user_group_id_user_id_unique` (`group_id`,`user_id`);

--
-- Table: `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `ability` INT NOT NULL,
  `start_date` DATE NOT NULL,
  `end_date` DATE NOT NULL,
  `status` TINYINT(1) NOT NULL DEFAULT 1,
  `created_by` INT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  `professor_id` INT NULL,
  `uuid` VARCHAR(36) NOT NULL,
  `is_delete` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `groups_professor_id_foreign` (`professor_id`),
  CONSTRAINT `groups_professor_id_foreign` FOREIGN KEY (`professor_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `groups`
  ADD UNIQUE KEY `groups_uuid_unique` (`uuid`);

--
-- Table: `histories`
--
CREATE TABLE IF NOT EXISTS `histories` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `uuid` VARCHAR(36) NOT NULL,
  `is_delete` TINYINT(1) NOT NULL DEFAULT 0,
  `month` DATE NOT NULL,
  `share` INT NOT NULL,
  `paid` INT NOT NULL,
  `balance` INT NOT NULL,
  `total` INT NOT NULL,
  `total_paid` INT NOT NULL,
  `total_balance` INT NOT NULL,
  `user_id` INT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`),
  KEY `histories_user_id_foreign` (`user_id`),
  CONSTRAINT `histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `histories`
  ADD UNIQUE KEY `histories_uuid_unique` (`uuid`);

--
-- Table: `job_batches`
--
CREATE TABLE IF NOT EXISTS `job_batches` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `total_jobs` INT NOT NULL,
  `pending_jobs` INT NOT NULL,
  `failed_jobs` INT NOT NULL,
  `failed_job_ids` TEXT NOT NULL,
  `options` TEXT NULL,
  `cancelled_at` INT NULL,
  `created_at` INT NOT NULL,
  `finished_at` INT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `jobs`
--
CREATE TABLE IF NOT EXISTS `jobs` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `queue` VARCHAR(255) NOT NULL,
  `payload` TEXT NOT NULL,
  `attempts` INT NOT NULL,
  `reserved_at` INT NULL,
  `available_at` INT NOT NULL,
  `created_at` INT NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `jobs`
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Table: `migrations`
--
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `migration` VARCHAR(255) NOT NULL,
  `batch` INT NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `password_reset_tokens`
--
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` VARCHAR(255) NOT NULL,
  `token` VARCHAR(255) NOT NULL,
  `created_at` DATETIME NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `payments`
--
CREATE TABLE IF NOT EXISTS `payments` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `uuid` VARCHAR(36) NOT NULL,
  `is_delete` TINYINT(1) NOT NULL DEFAULT 0,
  `amount_to_pay` INT NOT NULL,
  `amount_paid` INT NOT NULL,
  `balance` INT NOT NULL,
  `month` DATE NOT NULL,
  `payment_date` DATE NOT NULL,
  `registration_id` INT NULL,
  `history_id` INT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  `user_id` INT NULL,
  PRIMARY KEY (`id`),
  KEY `payments_history_id_foreign` (`history_id`),
  KEY `payments_registration_id_foreign` (`registration_id`),
  KEY `payments_user_id_foreign` (`user_id`),
  CONSTRAINT `payments_history_id_foreign` FOREIGN KEY (`history_id`) REFERENCES `histories`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `payments_registration_id_foreign` FOREIGN KEY (`registration_id`) REFERENCES `registrations`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `payments`
  ADD UNIQUE KEY `payments_uuid_unique` (`uuid`);

--
-- Table: `registrations`
--
CREATE TABLE IF NOT EXISTS `registrations` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `uuid` VARCHAR(36) NOT NULL,
  `reg_date` DATE NOT NULL,
  `is_delete` TINYINT(1) NOT NULL DEFAULT 0,
  `user_id` INT NULL,
  `course_id` INT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  `group_id` INT NULL,
  `reg_value` DECIMAL(10,2) NULL,
  PRIMARY KEY (`id`),
  KEY `registrations_course_id_foreign` (`course_id`),
  KEY `registrations_group_id_foreign` (`group_id`),
  KEY `registrations_user_id_foreign` (`user_id`),
  CONSTRAINT `registrations_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `registrations_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  CONSTRAINT `registrations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `registrations`
  ADD UNIQUE KEY `registrations_uuid_unique` (`uuid`);

--
-- Table: `roles`
--
CREATE TABLE IF NOT EXISTS `roles` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `role_name` VARCHAR(50) NOT NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `sessions`
--
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` VARCHAR(255) NOT NULL,
  `user_id` INT NULL,
  `ip_address` VARCHAR(45) NULL,
  `user_agent` TEXT,
  `payload` TEXT NOT NULL,
  `last_activity` INT NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table: `users`
--
CREATE TABLE IF NOT EXISTS `users` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `id_no` VARCHAR(50) NOT NULL,
  `email_verified_at` DATETIME NULL,
  `password` VARCHAR(255) NOT NULL,
  `remember_token` VARCHAR(100) NULL,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  `role_id` INT NULL,
  `picture` VARCHAR(255) NULL,
  `is_delete` TINYINT(1) NOT NULL DEFAULT 0,
  `last_name` VARCHAR(255) NULL,
  `telephone` VARCHAR(20) NULL,
  `notes` VARCHAR(255) NULL,
  `age` INT NULL,
  `address` VARCHAR(255) NULL,
  `city` VARCHAR(100) NULL,
  `stratum` VARCHAR(50) NULL,
  `guard_id` INT NULL,
  `uuid` VARCHAR(36) NOT NULL,
  `first_name` VARCHAR(255) NULL,
  `gender` VARCHAR(20) NULL,
  PRIMARY KEY (`id`),
  KEY `users_role_id_foreign` (`role_id`),
  CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `users`
  ADD UNIQUE KEY `users_id_no_unique` (`id_no`),
  ADD UNIQUE KEY `users_uuid_unique` (`uuid`);

--
-- Dumping data for table `attendances`
--
INSERT INTO `attendances` (`id`,`group_id`,`date`,`user_id`,`user_uuid`,`attendance_status`,`created_at`,`updated_at`,`course_id`,`period`,`teacher_id`) VALUES
(1,1,'2025-06-01','3','9818acfd-f018-4fe2-ac39-7f7c9817ee67','Absent','2025-06-01 07:35:00','2025-06-01 07:35:00',3,1,8),
(2,1,'2025-06-01','6','3dc0e76f-a8f0-48ee-84fd-5672ad99cd23','Present','2025-06-01 07:35:00','2025-06-01 07:35:00',3,1,8),
(3,1,'2025-06-01','3','9818acfd-f018-4fe2-ac39-7f7c9817ee67','Present','2025-06-01 07:39:51','2025-06-01 07:39:51',3,2,9),
(4,1,'2025-06-01','6','3dc0e76f-a8f0-48ee-84fd-5672ad99cd23','Absent','2025-06-01 07:39:51','2025-06-01 07:39:51',3,2,9),
(5,3,'2025-06-01','6','3dc0e76f-a8f0-48ee-84fd-5672ad99cd23','Excused','2025-06-01 07:42:14','2025-06-01 07:42:14',2,1,10),
(6,1,'2025-06-04','3','9818acfd-f018-4fe2-ac39-7f7c9817ee67','Present','2025-06-04 13:41:58','2025-06-04 13:41:58',3,1,8),
(7,1,'2025-06-04','6','3dc0e76f-a8f0-48ee-84fd-5672ad99cd23','Present','2025-06-04 13:41:58','2025-06-04 13:41:58',3,1,8);

--
-- Dumping data for table `course_group`
--
INSERT INTO `course_group` (`id`,`course_id`,`group_id`,`created_at`,`updated_at`) VALUES
(1,1,2,NULL,NULL),
(2,1,1,NULL,NULL),
(3,2,3,NULL,NULL),
(4,3,2,NULL,NULL),
(6,3,1,NULL,NULL);

--
-- Dumping data for table `course_user`
--
INSERT INTO `course_user` (`id`,`course_id`,`user_id`,`created_at`,`updated_at`) VALUES
(1,3,8,'2025-06-01 06:31:48','2025-06-01 06:31:48'),
(2,1,9,'2025-06-01 06:35:54','2025-06-01 06:35:54'),
(3,3,9,'2025-06-01 06:35:55','2025-06-01 06:35:55'),
(4,2,10,'2025-06-01 06:37:32','2025-06-01 06:37:32');

--
-- Dumping data for table `courses`
--
INSERT INTO `courses` (`id`,`course_name`,`course_level`,`course_value`,`uuid`,`is_delete`,`group_id`,`created_at`,`updated_at`) VALUES
(1,'English',NULL,NULL,'e7b97d89-df6d-479a-b9c7-9213af057c60',0,NULL,'2025-06-01 06:27:32','2025-06-01 06:27:32'),
(2,'Science',NULL,NULL,'75017402-52eb-4a44-ab31-3679392a0821',0,NULL,'2025-06-01 06:27:53','2025-06-01 06:27:53'),
(3,'Mathematics',NULL,NULL,'ef4793cc-486a-4ae7-83b2-e4992c06144d',0,NULL,'2025-06-01 06:29:39','2025-06-01 06:29:39');

--
-- Dumping data for table `grades`
--
INSERT INTO `grades` (`id`,`student_id`,`course_id`,`teacher_id`,`assessment_type`,`percentage`,`grade`,`date`,`created_at`,`updated_at`) VALUES
(1,6,2,10,'classwork',63,4,'2025-06-01','2025-06-01 08:03:59','2025-06-01 08:25:34'),
(2,3,3,8,'classwork',72,4,'2025-06-04','2025-06-01 08:31:41','2025-06-04 13:38:40'),
(3,6,3,8,'classwork',57,3,'2025-06-01','2025-06-01 08:31:41','2025-06-01 08:31:41');

--
-- Dumping data for table `group_user`
--
INSERT INTO `group_user` (`id`,`group_id`,`user_id`,`assigned_by`,`assigned_at`,`created_at`,`updated_at`) VALUES
(1,2,8,NULL,NULL,NULL,NULL),
(2,1,8,NULL,NULL,NULL,NULL),
(3,3,9,NULL,NULL,NULL,NULL),
(5,3,10,NULL,NULL,NULL,NULL),
(6,1,9,NULL,'2025-06-01 07:01:23','2025-06-01 07:01:23');

--
-- Dumping data for table `groups`
--
INSERT INTO `groups` (`id`,`name`,`ability`,`start_date`,`end_date`,`status`,`created_by`,`created_at`,`updated_at`,`professor_id`,`uuid`,`is_delete`) VALUES
(1,'FJ119',5,'2025-06-01','2029-06-01',1,2,'2025-06-01 05:42:05','2025-06-01 05:42:05',NULL,'4cb82103-745f-411f-b80c-fc69a4b49b4a',0),
(2,'FJ118',5,'2025-06-01','2029-06-01',1,2,'2025-06-01 05:46:41','2025-06-01 05:46:41',NULL,'a3e49b56-cc44-47b7-b56d-738c6b06d9fc',0),
(3,'FJ117',4,'2025-06-01','2029-06-01',1,2,'2025-06-01 05:47:22','2025-06-01 05:47:22',NULL,'47ec8612-8a55-4331-99e0-7992d0a95c08',0);

--
-- Dumping data for table `job_batches`
--
-- (No rows inserted)

--
-- Dumping data for table `jobs`
--
-- (No rows inserted)

--
-- Dumping data for table `migrations`
--
INSERT INTO `migrations` (`id`,`migration`,`batch`) VALUES
(1,'0001_01_01_000000_create_users_table',1),
(2,'0001_01_01_000001_create_cache_table',1),
(3,'0001_01_01_000002_create_jobs_table',1),
(4,'2024_12_09_235041_create_roles_table',1),
(5,'2024_12_10_001130_add_role_id_to_users_table',1),
(6,'2025_01_09_120726_add_picture_to_users_table',1),
(7,'2025_01_12_031402_add_is_delete_to_users_table',1),
(8,'2025_01_12_044344_add_uuid_to_users_table',1),
(9,'2025_01_13_131115_add_professor_fields_to_users_table',1),
(10,'2025_01_16_114229_add_notes_to_user_table',1),
(11,'2025_01_16_131939_create_groups_table',1),
(12,'2025_01_19_021001_add_twofields_to_groups_table',1),
(13,'2025_01_19_043753_create_courses_table',1),
(14,'2025_01_24_022357_add_students_fields_to_users_table',1),
(15,'2025_01_25_012534_create_registrations_table',1),
(16,'2025_01_27_014325_create_histories_table',1),
(17,'2025_01_28_154310_create_payments_table',1),
(18,'2025_03_02_122705_create_attendance_table',1),
(19,'2025_05_09_112614_make_picture_nullable_on_users_table',1),
(20,'2025_05_13_133721_add_uuid_to_users_table',1),
(21,'2025_05_13_142300_remove_name_from_users_table',1),
(22,'2025_05_14_085029_add_uuid_to_groups_table',1),
(23,'2025_05_14_100354_add_is_delete_to_groups_table',1),
(24,'2025_05_14_123006_add_is_register_to_users_table',1),
(25,'2025_05_14_124114_drop_is_register_from_users_table',1),
(26,'2025_05_14_192402_add_user_id_to_payments_table',1),
(27,'2025_05_15_190000_create_group_user_table',1),
(28,'2025_05_28_052802_make_course_value_and_level_nullable_in_payments_table',1),
(29,'2025_05_28_055352_make_course_level_and_value_nullable',1),
(30,'2025_05_28_060737_create_course_group_table',1),
(31,'2025_05_30_051607_create_course_teacher_period_table',1),
(32,'2025_05_30_053816_add_course_group_period_to_attendances_table',1),
(33,'2025_05_30_075117_create_course_user_table',1),
(34,'2025_05_30_082937_create_course_group_table',1),
(35,'2025_05_31_104028_add_teacher_id_to_attendances_table',1),
(36,'2025_05_31_120312_create_grades_table',1),
(37,'2025_06_01_045220_add_gender_to_users_table',2),
(38,'2025_06_01_064141_add_group_id_to_registrations_table',3),
(39,'2025_06_01_065055_make_reg_value_nullable_in_registrations_table',4);

--
-- Table: `password_reset_tokens`
--
-- (No rows inserted)

--
-- Table: `payments`
--
INSERT INTO `payments` (`id`,`uuid`,`is_delete`,`amount_to_pay`,`amount_paid`,`balance`,`month`,`payment_date`,`registration_id`,`history_id`,`created_at`,`updated_at`,`user_id`) VALUES
(1,'0dc4c813-4891-4f61-8f37-3a5c35287e83',0,280000,70000,210000,'2025-06','2025-06-01',NULL,NULL,'2025-06-01 08:55:14','2025-06-01 08:55:14',6),
(2,'4289059c-5300-4056-965c-a4f488dd8f34',0,210000,70000,140000,'2025-06','2025-06-04',NULL,NULL,'2025-06-04 13:29:45','2025-06-04 13:29:45',6);

--
-- Table: `registrations`
--
INSERT INTO `registrations` (`id`,`uuid`,`reg_date`,`is_delete`,`user_id`,`course_id`,`created_at`,`updated_at`,`group_id`,`reg_value`) VALUES
(1,'ff679951-a666-44de-ab74-1f8f37768ded','2025-06-01',0,3,3,'2025-06-01 06:42:57','2025-06-01 06:42:57',1,NULL),
(2,'729831da-fcc1-4645-bbfd-66070943f4b9','2025-06-01',0,3,1,'2025-06-01 06:43:44','2025-06-01 06:43:44',1,NULL),
(3,'cf174968-7f07-4cfd-b09f-273626e79bdb','2025-06-01',0,6,2,'2025-06-01 06:53:22','2025-06-01 06:53:22',3,NULL),
(4,'1ed5653a-4abb-4168-8239-ed40b8a88f49','2025-06-01',0,6,3,'2025-06-01 06:57:17','2025-06-01 06:57:17',1,NULL);

--
-- Table: `roles`
--
INSERT INTO `roles` (`id`,`role_name`,`created_at`,`updated_at`) VALUES
(1,'Admin','2025-06-01 09:32:59','2025-06-01 09:32:59'),
(2,'Teacher','2025-06-01 09:32:59','2025-06-01 09:32:59'),
(3,'Student','2025-06-01 09:32:59','2025-06-01 09:32:59'),
(4,'Parent','2025-06-01 09:32:59','2025-06-01 09:32:59');

--
-- Table: `sessions`
--
INSERT INTO `sessions` (`id`,`user_id`,`ip_address`,`user_agent`,`payload`,`last_activity`) VALUES
('FoWPNg5Wg5XyIaUjdEufvSLhBq0Ef3SA1kbb6Web',3,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRDdqU2NsYWZ4SmtRdUJ3Q2pia1JzbWlnNmNEZ0R1eEo4UGtaMFlIYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zdHVkZW50L2Rhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM7fQ==',1749042701),
('B3p7llJ4E66oWamEVgafeU5HIgNwnvF2yiYO9N74',2,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoieVJTZ1NYN1Nld1hRWGlxbWJIdDZYSkc0Q05JdThjcVhTaEpwUXNaeSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNzoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2FkbWluL2Rhc2hib2FyZCI7fX0=',1749037476),
('q8IF6BE4dQ8uRarDjasXsXeYugrNXkDEkZ4t7VqN',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoidUgwZkVJeVd1cndGNnFDSlNQb3UzVVhFcmh0TFQzMzNsYVd6eW5EYSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1749039189),
('eZ3hrqXNysgjwToESzcBS2oLMH2qdK20jQRCKKYL',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRHJBNExGUlRtbERZaG5EdEdrbXVYdGNqbkhUb2xObG02aDZLZm54ZyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1749039984),
('j6EDinMNroIrrbq7RgyQwYN8ZnF9sMVUKkFWCf45',3,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiY2ducUYzMW1pMmlBR28yQjRJZDJycWJvMVYwQnBVOTJGdUJTTnNNeiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zdHVkZW50L2Rhc2hib2FyZCI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM7fQ==',1749041386),
('lfvvLNKN9q870znrryhCc7ObsB6BtmOOvAxF7w9n',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiT2FPWFZOTlZkZURxUDEyRG9CN0I5dXlyTktVcEZQM0txOTduNjZaMiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fX0=',1749042893),
('sbfeuRi1tZbJKo2v4HJnfnYoN6WbfJDXftWZx9Xh',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoic0hFWjdvcVY0MW9KZzJtajRzd0hSMmxtUGhybFRtOWZiVDJzUEZnaSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1749043141),
('ukS1PvTEOa6abPoShLmY9j7VMNprZUTdlbysWyBn',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiTDRPdURDcGJmY000enBLWGhDU0RpTkw5aVNybmJMWld6SDZCdWhCVyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1749043169),
('fx3jUtTKyF85aUfWjGxMB4svDOSj5XJBVOgDuTZ0',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidmpJbjZxdURTMlNIVUVTVmlOR3ZYOW42MDVFdk9JMGgyUzFHdnV5UyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1749043179),
('CzatG2BsfDDeMg6hR02KWpi4U75WVXPj09FQhXkG',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjAzM3NyQ25GQ1ZUejd5ck5vWGVzZk1waUtVUXhuWjFLQ0NkOW5BYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1749043187),
('Ux0ZL2pXcqvfcbK0CkQNKN6upLipK75SybhHlfW2',3,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiR2hUT3lCVldZRFN0YVJqZ1FJY1d1OE8wQTVENVdWbWllb2ZLbFVEVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM7fQ==',1749043193),
('JYj13jHTR5bxQTdMmMts0MICC34tLNi44PXy3OOH',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiYmo1SWhoZUxEN25HQlJFdlVkeEIzZE1Qb0thZXJiSG5IdmZFdVFkSiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1749043195),
('X92hOoFHb2x1SsUe8g7eXzp4FrxC0gfdnVVht8sG',8,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibEdOcE5abWswSm1QU3V0b3N2YUhWYWRQQXBSU0hYcE45Z2k3cGtiWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC90ZWFjaGVyL2F0dGVuZGFuY2U/Y291cnNlX2lkPTMmZGF0ZT0yMDI1LTA2LTA0Jmdyb3VwX2lkPTEmcGVyaW9kPTEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo4O30=',1749044519);

--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`,`id_no`,`email_verified_at`,`password`,`remember_token`,`created_at`,`updated_at`,`role_id`,`picture`,`is_delete`,`last_name`,`telephone`,`notes`,`age`,`address`,`city`,`stratum`,`guard_id`,`uuid`,`first_name`,`gender`) VALUES
(2,'39986511',NULL,'$2y$12$zdCA.kFjhRscisMwKrvPR.RG6h0s/Uc/CTgehqY6WlLQghI5HE0eq',NULL,'2025-06-01 04:49:52','2025-06-01 04:49:52',1,NULL,0,'Neto',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5b775af2-b309-479e-a77e-fbbc21844290','Pedro',NULL),
(3,'1701',NULL,'$2y$12$tCCqSYMCNN3Xec/LQhD5zuCuSIh50h0eeIdccpzyJxDLxELgWDRli',NULL,'2025-06-01 04:53:26','2025-06-04 13:14:52',3,NULL,0,'Petrovic','0704715484','',22,'Juja, Mary\'s apartment','Kiambu','3',4,'9818acfd-f018-4fe2-ac39-7f7c9817ee67','Djordje','male'),
(4,'39986541',NULL,'$2y$12$YSGmEeziLkMaRSwTUUPOA.bOEnwOUsRMahp5fSc19yw310ybfyD.a',NULL,'2025-06-01 04:56:31','2025-06-01 04:56:31',4,NULL,0,'Petrovic','0704715484','',NULL,NULL,NULL,NULL,NULL,'3fd9d3bd-cc21-497f-8734-1e3a1565f46c','Mike','male'),
(5,'39986542',NULL,'$2y$12$JVEFwlmRxdabVBLvHSLZD.M90Of9ZaRS6HDHL5iXvoJDFyymmtE8i',NULL,'2025-06-01 04:57:49','2025-06-01 04:57:49',4,NULL,0,'Karanja','0704715484','parent',NULL,NULL,NULL,NULL,NULL,'d4af4b2f-18ec-42c7-b573-442de92a5971','Ephy','male'),
(6,'1702',NULL,'$2y$12$DxA2PsLQgDYWMwdHpMoFsOIv5nzNjhlu23rKJdhKTQuBrrcZP8QmK',NULL,'2025-06-01 05:00:26','2025-06-04 13:26:02',3,NULL,0,'Sanchez','0704715485','',20,'Juja, Mary\'s apartment','Kiambu','4',4,'3dc0e76f-a8f0-48ee-84fd-5672ad99cd23','Robert','male'),
(7,'39986513',NULL,'$2y$12$kgGrnJQnrWC4A6GiJoS3VOOTgN/iiAWxdJ4OQRC8K9x5e7pSHJ4H6',NULL,'2025-06-01 05:27:24','2025-06-01 05:27:24',1,NULL,0,'Madueke',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'f94799af-1219-49ca-8280-f98dbeeb1c8f','Noni',NULL),
(8,'39986521',NULL,'$2y$12$5eZudgIlkZuOpAuy10iZD.HPABNVLT.lzr.cztJoFbkbC/Q7pIN6a',NULL,'2025-06-01 06:31:47','2025-06-01 06:31:47',2,NULL,0,'Gusto','0704715484',NULL,NULL,NULL,NULL,NULL,NULL,'d639bdd0-ec68-406d-819f-6657b7391f38','Malo','male'),
(9,'39986522',NULL,'$2y$12$yC3VdSyjb3EMQEC.g0QtCOYOuQslbEw6F3rXqbCddycWA/wTaRSdW',NULL,'2025-06-01 06:35:54','2025-06-01 06:35:54',2,NULL,0,'James','0704715484',NULL,NULL,NULL,NULL,NULL,NULL,'a00d1549-6024-45e2-83e4-6286381081b2','Reece','male'),
(10,'39986523',NULL,'$2y$12$LRLQe.rax7lRToToKfpdyO2OZhmKNuP0o4vXu35Re7lV.JekKtWNC',NULL,'2025-06-01 06:37:32','2025-06-01 06:37:32',2,NULL,0,'Cucurella','0704715484',NULL,NULL,NULL,NULL,NULL,NULL,'25f09f57-dce5-41df-811c-d8ad37d73c58','Marc','male');

--
-- Indexes for all tables
--
-- (These were already created in‐line above via ALTER TABLE … ADD UNIQUE KEY)

-- --------------------------------------------------------

/*!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 */;