• Home
• pl.touk.nussknacker
• nussknacker-designer_2.13
• 1.16.0
• source code
• V1_025__DeploymentActionInfoNotNullProcessVersionId.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.postgres.V1_025__DeploymentActionInfoNotNullProcessVersionId.sql Maven / Gradle / Ivy

UPDATE "process_deployment_info" AS pdi SET "process_version_id" = (
    SELECT pv."id" from "process_versions" as pv
    WHERE
            pv."process_id" = pdi."process_id" and
            pv."create_date" < pdi."deploy_at"
    ORDER BY pv."create_date" DESC
    LIMIT 1
)
WHERE pdi."process_version_id" IS NULL;

ALTER TABLE "process_deployment_info" ALTER COLUMN "process_version_id" set not null;