• Home
• pl.touk.nussknacker
• nussknacker-designer_2.13
• 1.16.0
• source code
• V1_026__ProcessCreatedAtByFields.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.hsql.V1_026__ProcessCreatedAtByFields.sql Maven / Gradle / Ivy

-- create fields
ALTER TABLE "processes" ADD COLUMN "created_at" TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE "processes" ADD COLUMN "created_by" VARCHAR(255);

-- set base value fields
UPDATE "processes" p SET
    "created_at" = (SELECT pv."create_date" FROM "process_versions" pv WHERE pv."process_id" = p."id" ORDER BY pv."create_date" ASC LIMIT 1),
    "created_by" = (SELECT pv."user" FROM "process_versions" pv WHERE pv."process_id" = p."id" ORDER BY pv."create_date" ASC LIMIT 1);

-- set set not null fields
ALTER TABLE "processes" ALTER COLUMN "created_at" set not null;
ALTER TABLE "processes" ALTER COLUMN "created_by" set not null;