AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
TypeScript ai-agentai-agent-toolsai-agentsai-agents-frameworkmcpmcp-servermcp-toolsmcpsn8n-alternativeno-code-automationworkflowworkflow-automationworkflows
import { ApEdition } from '@activepieces/shared'
import { MigrationInterface, QueryRunner } from 'typeorm'
import { isNotOneOfTheseEditions } from '../../database-common'
export class MakePlatformNotNullable1705969874745 implements MigrationInterface {
name = 'MakePlatformNotNullable1705969874745'
public async up(queryRunner: QueryRunner): Promise<void> {
if (isNotOneOfTheseEditions([ApEdition.CLOUD, ApEdition.ENTERPRISE])) {
return
}
await queryRunner.query(`
ALTER TABLE "project" DROP COLUMN "type"
`)
await queryRunner.query(`
DROP INDEX "idx_project_platform_id_external_id"
`)
await queryRunner.query(`
ALTER TABLE "project"
ALTER COLUMN "platformId"
SET NOT NULL
`)
await queryRunner.query(`
CREATE UNIQUE INDEX "idx_project_platform_id_external_id" ON "project" ("platformId", "externalId")
`)
await queryRunner.query(`
ALTER TABLE "project"
ADD CONSTRAINT "fk_project_platform_id" FOREIGN KEY ("platformId") REFERENCES "platform"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
`)
}
public async down(queryRunner: QueryRunner): Promise<void> {
if (isNotOneOfTheseEditions([ApEdition.CLOUD, ApEdition.ENTERPRISE])) {
return
}
await queryRunner.query(`
ALTER TABLE "project" DROP CONSTRAINT "fk_project_platform_id"
`)
await queryRunner.query(`
DROP INDEX "idx_project_platform_id_external_id"
`)
await queryRunner.query(`
ALTER TABLE "project"
ALTER COLUMN "platformId" DROP NOT NULL
`)
await queryRunner.query(`
CREATE UNIQUE INDEX "idx_project_platform_id_external_id" ON "project" ("platformId", "externalId")
`)
await queryRunner.query(`
ALTER TABLE "project"
ADD "type" character varying NOT NULL DEFAULT 'STANDALONE'
`)
}
}