CAP v2.3 sql migration script

cap-2.3-SqlMigrationScript.md

MySQL

ALTER TABLE `cap.published` MODIFY Id BIGINT NOT NULL;
ALTER TABLE `cap.received` MODIFY Id BIGINT NOT NULL;

PostgreSql

ALTER TABLE cap.published ALTER COLUMN "Id" TYPE BIGINT;
ALTER TABLE cap.published ALTER COLUMN "Id" DROP DEFAULT;

ALTER TABLE cap.received ALTER COLUMN "Id" TYPE BIGINT;
ALTER TABLE cap.received ALTER COLUMN "Id" DROP DEFAULT;

SQLServer

ALTER TABLE Cap.[Published] DROP CONSTRAINT [PK_Cap.Published];
ALTER TABLE Cap.[Published] ALTER COLUMN Id BIGINT NOT NULL;
ALTER TABLE Cap.[Published] ADD CONSTRAINT [PK_Cap.Published] PRIMARY KEY(Id);

ALTER TABLE Cap.[Received] DROP CONSTRAINT [PK_Cap.[Received];
ALTER TABLE Cap.[Received] ALTER COLUMN Id BIGINT NOT NULL;
ALTER TABLE Cap.[Received] ADD CONSTRAINT [PK_Cap.Received] PRIMARY KEY(Id);