CREATE DATABASE IF NOT EXISTS school_db;
USE school_db;

CREATE TABLE IF NOT EXISTS students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sr_number VARCHAR(50) UNIQUE,
    student_name VARCHAR(100),
    class VARCHAR(50),
    section VARCHAR(50),
    father_name VARCHAR(100),
    mother_name VARCHAR(100),
    guardian_name VARCHAR(100),
    student_photo VARCHAR(255),
    father_photo VARCHAR(255),
    mother_photo VARCHAR(255),
    guardian_photo VARCHAR(255),
    father_whatsapp VARCHAR(20),
    mother_whatsapp VARCHAR(20),
    guardian_whatsapp VARCHAR(20),
    email VARCHAR(150),
    is_locked TINYINT(1) DEFAULT 0
);