Deployment Key · SQLite Schema · n8n-io/n8n · Skills Docs

Deployment Key · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "deployment_key" ("id" varchar(36) PRIMARY KEY NOT NULL, "type" varchar(64) NOT NULL, "value" text NOT NULL, "algorithm" varchar(20), "status" varchar(20) NOT NULL, "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')))

Name	Type	Default	Nullable	Children	Parents	Comment
algorithm	varchar(20)		true
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
id	varchar(36)		false
status	varchar(20)		false
type	varchar(64)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
value	TEXT		false

Name	Definition
IDX_deployment_key_data_encryption_active	CREATE UNIQUE INDEX “IDX_deployment_key_data_encryption_active” ON “deployment_key” (“type”) WHERE status = ‘active’ AND type = ‘data_encryption’
IDX_deployment_key_instance_id_active	CREATE UNIQUE INDEX “IDX_deployment_key_instance_id_active” ON “deployment_key” (“type”) WHERE status = ‘active’ AND type = ‘instance.id’
IDX_deployment_key_jwe_private_key_active	CREATE UNIQUE INDEX “IDX_deployment_key_jwe_private_key_active” ON “deployment_key” (“type”, “algorithm”) WHERE status = ‘active’ AND type = ‘jwe.private-key’
IDX_deployment_key_oauth_signing_key_active	CREATE UNIQUE INDEX “IDX_deployment_key_oauth_signing_key_active” ON “deployment_key” (“type”, “algorithm”) WHERE “status” = ‘active’ AND “type” = ‘oauth-server.signing-key’
IDX_deployment_key_signing_binary_data_active	CREATE UNIQUE INDEX “IDX_deployment_key_signing_binary_data_active” ON “deployment_key” (“type”) WHERE status = ‘active’ AND type = ‘signing.binary_data’
IDX_deployment_key_signing_hmac_active	CREATE UNIQUE INDEX “IDX_deployment_key_signing_hmac_active” ON “deployment_key” (“type”) WHERE status = ‘active’ AND type = ‘signing.hmac’
IDX_deployment_key_signing_jwt_active	CREATE UNIQUE INDEX “IDX_deployment_key_signing_jwt_active” ON “deployment_key” (“type”) WHERE status = ‘active’ AND type = ‘signing.jwt’
sqlite_autoindex_deployment_key_1	PRIMARY KEY (id)

Name	Definition
prevent_deployment_key_delete	CREATE TRIGGER “prevent_deployment_key_delete” BEFORE DELETE ON “deployment_key” BEGIN SELECT RAISE(ABORT, ‘Deployment keys must not be deleted’); END