-- The root cause behind several real reported bugs: adding a staff member
-- in Staff Management only ever created an HR roster row — it never
-- created an actual login account. That's why newly-added teachers never
-- got a temp PIN, and never showed up in Duty Roster, Class Management,
-- Payroll, Teacher Welfare, or Teacher Queries — those all read from real
-- login accounts (users), which were never being created.
ALTER TABLE users ADD COLUMN IF NOT EXISTS temp_pin_hash TEXT;
ALTER TABLE users ADD COLUMN IF NOT EXISTS temp_pin_used BOOLEAN NOT NULL DEFAULT FALSE;
ALTER TABLE staff_management ADD COLUMN IF NOT EXISTS linked_user_id INTEGER;