Query

database.sqlite — credentials_entity

SQL

CREATE TABLE "credentials_entity"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "name" varchar(128) NOT NULL,
  "data" text NOT NULL,
  "type" varchar(32) 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')),
  "isManaged" boolean NOT NULL DEFAULT (0),
  "isGlobal" boolean NOT NULL DEFAULT (0),
  "isResolvable" boolean NOT NULL DEFAULT (false),
  "resolvableAllowFallback" boolean NOT NULL DEFAULT (false),
  "resolverId" varchar(16),
  "usageScope" VARCHAR(16) NOT NULL DEFAULT 'project' CONSTRAINT "CHK_credentials_entity_usageScope" CHECK ("usageScope" IN ('project', 'instance')),
  CONSTRAINT "credentials_entity_resolverId_foreign" FOREIGN KEY ("resolverId") REFERENCES "dynamic_credential_resolver" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
name varchar(128) Rename | Drop
data TEXT Rename | Drop
type varchar(32) Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
isManaged boolean Rename | Drop
isGlobal boolean Rename | Drop
isResolvable boolean Rename | Drop
resolvableAllowFallback boolean Rename | Drop
resolverId varchar(16) ✓ Rename | Drop
usageScope VARCHAR(16) Rename | Drop

Foreign Keys

Column Destination
resolverId dynamic_credential_resolver.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_credentials_entity_is_global id SQL 
CREATE INDEX "IDX_credentials_entity_is_global"
ON "credentials_entity" ("id") WHERE "isGlobal" = true
Drop
idx_credentials_entity_type type SQL 
CREATE INDEX "idx_credentials_entity_type"
ON "credentials_entity" ("type")
Drop
sqlite_autoindex_credentials_entity_1 id ✓ SQL
-- no sql found --
 Drop