
CREATE TABLE `cp_classes` (
  `class_id` int NOT NULL AUTO_INCREMENT,
  `class_name` varchar(255) NOT NULL,
  `num_classes` int NOT NULL DEFAULT '42',
  `duration_hours` decimal(4,2) NOT NULL DEFAULT '2.00',
  `note` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `schedule_start_time` time DEFAULT NULL,
  `schedule_end_time` time DEFAULT NULL,
  `schedule_weekday` varchar(20) DEFAULT NULL,
  `student_name` varchar(255) DEFAULT NULL,
  `card_color` varchar(20) DEFAULT NULL,
  `display_order` int DEFAULT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `cp_classes`(`class_id`,`class_name`,`num_classes`,`duration_hours`,`note`,`created_at`,`schedule_start_time`,`schedule_end_time`,`schedule_weekday`,`student_name`,`card_color`,`display_order`) VALUES('1','Year 7 General','42','2.00','','2025-12-10 06:03:25',NULL,NULL,NULL,NULL,'#FFF9C4','3');
INSERT INTO `cp_classes`(`class_id`,`class_name`,`num_classes`,`duration_hours`,`note`,`created_at`,`schedule_start_time`,`schedule_end_time`,`schedule_weekday`,`student_name`,`card_color`,`display_order`) VALUES('4','Year 6 General','42','2.00','','2025-12-10 20:49:16','15:00:00','17:00:00','Every Thursday','Malcom, Rex','#D4EDDA','2');
INSERT INTO `cp_classes`(`class_id`,`class_name`,`num_classes`,`duration_hours`,`note`,`created_at`,`schedule_start_time`,`schedule_end_time`,`schedule_weekday`,`student_name`,`card_color`,`display_order`) VALUES('6','Year 8 General','42','2.00','','2025-12-11 00:10:44',NULL,NULL,NULL,NULL,'#FFE5B4','4');
INSERT INTO `cp_classes`(`class_id`,`class_name`,`num_classes`,`duration_hours`,`note`,`created_at`,`schedule_start_time`,`schedule_end_time`,`schedule_weekday`,`student_name`,`card_color`,`display_order`) VALUES('7','Maths Method Unit 1-2','42','2.00','','2025-12-14 19:37:10',NULL,NULL,NULL,NULL,'#D1ECF1','5');
INSERT INTO `cp_classes`(`class_id`,`class_name`,`num_classes`,`duration_hours`,`note`,`created_at`,`schedule_start_time`,`schedule_end_time`,`schedule_weekday`,`student_name`,`card_color`,`display_order`) VALUES('8','VCE Maths Method Unit 3-4','42','2.00','','2025-12-14 19:37:26',NULL,NULL,NULL,NULL,'#E9ECEF','6');
INSERT INTO `cp_classes`(`class_id`,`class_name`,`num_classes`,`duration_hours`,`note`,`created_at`,`schedule_start_time`,`schedule_end_time`,`schedule_weekday`,`student_name`,`card_color`,`display_order`) VALUES('9','Year 5 General','42','2.00','','2025-12-17 22:06:24',NULL,NULL,NULL,NULL,'#E6CCB2','1');

CREATE TABLE `system_settings` (
  `setting_id` int NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(50) NOT NULL,
  `setting_value` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`setting_id`),
  UNIQUE KEY `setting_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2299 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `system_settings`(`setting_id`,`setting_key`,`setting_value`,`created_at`,`updated_at`) VALUES('1','version','1.01','2025-12-10 06:01:21','2025-12-10 07:30:30');
INSERT INTO `system_settings`(`setting_id`,`setting_key`,`setting_value`,`created_at`,`updated_at`) VALUES('2','system_code','706950','2025-12-10 06:01:21','2025-12-10 07:30:30');
INSERT INTO `system_settings`(`setting_id`,`setting_key`,`setting_value`,`created_at`,`updated_at`) VALUES('3','safe_ips','','2025-12-10 06:01:21','2025-12-10 06:01:21');

