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

ALTER TABLE "process_attachments" ADD COLUMN "new_id" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1, INCREMENT BY 1);
ALTER TABLE "process_attachments" DROP PRIMARY KEY;
ALTER TABLE "process_attachments" DROP COLUMN "id";
ALTER TABLE "process_attachments" ALTER COLUMN "new_id" RENAME TO "id";
ALTER TABLE "process_attachments" ADD PRIMARY KEY ("id");