-- Mirror Database Schema
CREATE TABLE IF NOT EXISTS `results` (
  `htno` varchar(20) NOT NULL,
  `student_name` varchar(255) DEFAULT NULL,
  `college_name` varchar(255) DEFAULT NULL,
  `course_name` varchar(255) DEFAULT NULL,
  `result_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `raw_html` longblob DEFAULT NULL,
  `fetched_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`htno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
