-- Run BEFORE deploying teacher password hashing. Existing passwords are retained.
-- Legacy Base64 teacher passwords are upgraded after a successful frontend login.
ALTER TABLE member_tb MODIFY password VARCHAR(255) NULL DEFAULT NULL;
-- Canonical mapping matches existing forms and salary code. Do NOT swap data.
ALTER TABLE member_tb MODIFY time_work TINYINT(1) NULL DEFAULT NULL COMMENT '1. Full Time 2. Part Time';