setup-postgres.sql

-- PostgreSQL Setup for Teachers Database
-- Run this script in PostgreSQL

CREATE DATABASE classroom_db;

\c classroom_db;

CREATE TABLE teachers (
    id BIGSERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    phone VARCHAR(20) NOT NULL,
    specialization VARCHAR(100) NOT NULL,
    experience INTEGER NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX idx_teacher_email ON teachers(email);

-- Sample data
INSERT INTO teachers (name, email, phone, specialization, experience) VALUES
('Dr. John Smith', 'john.smith@school.com', '+1234567890', 'Mathematics', 10),
('Ms. Sarah Johnson', 'sarah.johnson@school.com', '+1234567891', 'English', 8),
('Mr. Mike Williams', 'mike.williams@school.com', '+1234567892', 'Physics', 12);