Files
acs/migrations/009_visitor_application_staff.sql
2026-08-03 17:11:04 +09:00

8 lines
372 B
SQL

ALTER TABLE visitor_applications
ADD COLUMN IF NOT EXISTS control_name VARCHAR(80),
ADD COLUMN IF NOT EXISTS control_team VARCHAR(80),
ADD COLUMN IF NOT EXISTS control_contact VARCHAR(60),
ADD COLUMN IF NOT EXISTS watcher1_name VARCHAR(80),
ADD COLUMN IF NOT EXISTS watcher1_team VARCHAR(80),
ADD COLUMN IF NOT EXISTS watcher1_contact VARCHAR(60);