Add Column
Current Schema
CREATE TABLE generated_codes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
batch_id INTEGER NOT NULL,
code TEXT NOT NULL UNIQUE,
institution_id TEXT NOT NULL,
valid_until TEXT,
used INTEGER DEFAULT 0,
used_by TEXT,
used_at DATETIME,
created_at DATETIME DEFAULT (datetime('now'))
)