
-- SQL for creating the school_checkin database and the checkins table

CREATE DATABASE IF NOT EXISTS school_checkin;

USE school_checkin;

CREATE TABLE IF NOT EXISTS checkins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    lrn VARCHAR(20),
    name VARCHAR(255),
    grade VARCHAR(50),
    checkin_time DATETIME,
    checkout_time DATETIME
);
