Files

8 lines
239 B
SQL

ALTER TABLE runtime_instance
ADD COLUMN binding_version bigint CHECK (binding_version > 0);
UPDATE runtime_instance runtime
SET binding_version = binding.version
FROM environment_binding binding
WHERE runtime.binding_id = binding.id;