github-mirror/n8n
1
0
Fork 0
mirror of https://github.com/n8n-io/n8n.git synced 2026-10-19 16:55:02 +02:00
Code Issues Actions 13 Packages Projects Releases Wiki Activity Graph
hackmation/worker-pools-rebase
n8n/docs/generated/sqlite-schema/project_pool_settings.md
Mike Repeć 686562c1c4 feat(core): Worker Pools (no-changelog) 
Squash of the hackmation/worker-pools branch (PR #32975), replayed verbatim
onto master. Contains pool-based execution routing, project/workflow pool
settings, worker pool UI, and the rollout feature flag.

Squashed commits:
- Hackmation/worker pools labels (#30378)
- feat(core): Route executions to dedicated worker pool queues (#30380)
- feat(core): Add worker pool defaults UI and instance settings (#30386)
- feat(editor): Show worker pool and queue name in Workers view (#30391)
- feat(editor): Periodically refresh worker pools on settings page (#30397)
- feat(core): Add per-workflow worker pool override settings (#30393)
- feat(db): add project_pool_settings table (#30398)
- feat(core): Route executions to project-level worker pool defaults (#30404)
- feat(core): Add workflow execution priority setting (#30409)
- feat(core): Add project pool settings endpoint and UI filtering (#30411)
- feat(core): Add PATCH for project worker pool settings (#30412)
- refactor(ProjectSettings): simplify project update call
- refactor(core): prepare Worker Pools for rollout behind a flag (#32974)

This commit carries NO adaptation to master beyond the one change required for
the patch to apply at all: the frontend test `defaultSettings` edit targets
@n8n/frontend-test-utils, since #37304 moved that file out of editor-ui.
Everything else needed to land on current master is isolated in the next commit,
so this one can be diffed directly against the reviewed state of #32975.

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
2026-09-01 10:52:32 +00:00

2.0 KiB
Generated
Raw Permalink Blame History

project_pool_settings

Description

Table Definition 
CREATE TABLE "project_pool_settings" ("projectId" varchar(36) PRIMARY KEY NOT NULL, "defaultPool" varchar(63), "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), CONSTRAINT "FK_6f5617b5fb0db43f92e39f5b626" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE)

Columns

Name Type Default Nullable Children Parents Comment
createdAt datetime(3) STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') false
defaultPool varchar(63) true
projectId varchar(36) false project
updatedAt datetime(3) STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') false

Constraints

Name Type Definition
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
projectId PRIMARY KEY PRIMARY KEY (projectId)
sqlite_autoindex_project_pool_settings_1 PRIMARY KEY PRIMARY KEY (projectId)

Indexes

Name Definition
sqlite_autoindex_project_pool_settings_1 PRIMARY KEY (projectId)

Relations

erDiagram

"project_pool_settings" |o--|| "project" : "FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"project_pool_settings" {
  datetime_3_ createdAt
  varchar_63_ defaultPool
  varchar_36_ projectId PK
  datetime_3_ updatedAt
}
"project" {
  datetime_3_ createdAt
  varchar creatorId FK
  TEXT customTelemetryTags
  varchar_512_ description
  TEXT icon
  varchar_36_ id PK
  varchar_255_ name
  varchar_36_ type
  datetime_3_ updatedAt
}

Generated by tbls