Files
fm_be/migrations/20260707_drop_doctor_license_dates.sql
2026-07-16 22:16:45 +07:00

8 lines
334 B
SQL

-- +goose Up
ALTER TABLE doctor_profiles DROP COLUMN license_issued_at;
ALTER TABLE doctor_profiles DROP COLUMN license_expired_at;
-- +goose Down
ALTER TABLE doctor_profiles ADD COLUMN license_issued_at DATETIME NULL AFTER short_name;
ALTER TABLE doctor_profiles ADD COLUMN license_expired_at DATETIME NULL AFTER license_issued_at;