Add Column
Current Schema
CREATE TABLE teachers (
id TEXT PRIMARY KEY,
institution_id TEXT NOT NULL,
name TEXT NOT NULL,
phone TEXT,
email TEXT,
title TEXT DEFAULT '',
status TEXT DEFAULT 'active' CHECK(status IN ('active','inactive','resigned')),
created_at DATETIME DEFAULT (datetime('now')),
updated_at DATETIME DEFAULT (datetime('now')),
password_hash TEXT DEFAULT '',
login_enabled INTEGER DEFAULT 1
)