CREATE TABLE IF NOT EXISTS login_attendance_settings (
 id TINYINT UNSIGNED NOT NULL PRIMARY KEY,
 started_on DATE NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT IGNORE INTO login_attendance_settings(id,started_on) VALUES(1,DATE(UTC_TIMESTAMP()+INTERVAL 2 HOUR));
CREATE TABLE IF NOT EXISTS student_login_days (
 user_id BIGINT UNSIGNED NOT NULL,
 attendance_date DATE NOT NULL,
 first_seen_at DATETIME NOT NULL,
 PRIMARY KEY(user_id,attendance_date),
 FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS student_login_receipts (
 user_id BIGINT UNSIGNED NOT NULL,
 receipt_month CHAR(7) NOT NULL,
 closed_at DATETIME NOT NULL,
 receipt_json LONGTEXT NOT NULL,
 PRIMARY KEY(user_id,receipt_month),
 FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
