13 lines
746 B
SQL
13 lines
746 B
SQL
-- Ported from backend/src/main/resources/db/migration/V4__visit_request_contact_fields.sql
|
|
|
|
ALTER TABLE visit_requests ADD COLUMN work_name VARCHAR(255);
|
|
ALTER TABLE visit_requests ADD COLUMN control_name VARCHAR(80);
|
|
ALTER TABLE visit_requests ADD COLUMN control_team VARCHAR(80);
|
|
ALTER TABLE visit_requests ADD COLUMN control_contact VARCHAR(60);
|
|
ALTER TABLE visit_requests ADD COLUMN watcher1_name VARCHAR(80);
|
|
ALTER TABLE visit_requests ADD COLUMN watcher1_team VARCHAR(80);
|
|
ALTER TABLE visit_requests ADD COLUMN watcher1_contact VARCHAR(60);
|
|
ALTER TABLE visit_requests ADD COLUMN watcher2_name VARCHAR(80);
|
|
ALTER TABLE visit_requests ADD COLUMN watcher2_team VARCHAR(80);
|
|
ALTER TABLE visit_requests ADD COLUMN watcher2_contact VARCHAR(60);
|