1BEGIN; 2 ALTER TABLE containers 3 DROP COLUMN worker_resource_config_check_session_id; 4 5 DROP TABLE worker_resource_config_check_sessions; 6 7 TRUNCATE TABLE resource_config_check_sessions; 8 9 ALTER TABLE resource_config_check_sessions 10 ADD COLUMN worker_base_resource_type_id integer, 11 ADD CONSTRAINT resource_config_check_sessions_worker_base_resource_type_id_fkey FOREIGN KEY (worker_base_resource_type_id) REFERENCES worker_base_resource_types(id) ON DELETE CASCADE; 12 13 CREATE UNIQUE INDEX resource_config_check_sessions_uniq 14 ON resource_config_check_sessions (resource_config_id, worker_base_resource_type_id); 15 16 ALTER TABLE containers 17 ADD COLUMN resource_config_check_session_id integer, 18 ADD CONSTRAINT containers_resource_config_check_session_id_fkey FOREIGN KEY (resource_config_check_session_id) REFERENCES resource_config_check_sessions(id) ON DELETE SET NULL; 19 20 CREATE INDEX containers_resource_config_check_session_id ON containers USING btree (resource_config_check_session_id); 21COMMIT; 22