Query

database.sqlite — credential_dependency

SQL

CREATE TABLE "credential_dependency"  (
  "id" integer PRIMARY KEY NOT NULL,
  "credentialId" varchar(36) NOT NULL,
  "dependencyType" varchar(64) NOT NULL,
  "dependencyId" varchar(255) NOT NULL,
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "FK_5ec8e8c8d3539f3696cf73b43bf" FOREIGN KEY ("credentialId") REFERENCES "credentials_entity" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
credentialId varchar(36) Rename | Drop
dependencyType varchar(64) Rename | Drop
dependencyId varchar(255) Rename | Drop
createdAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
credentialId credentials_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_5ec8e8c8d3539f3696cf73b43b credentialId SQL 
CREATE INDEX "IDX_5ec8e8c8d3539f3696cf73b43b"
ON "credential_dependency" ("credentialId")
Drop
IDX_91ee85fa9619dd6776725e117b
  • dependencyType
  • dependencyId
 SQL 
CREATE INDEX "IDX_91ee85fa9619dd6776725e117b"
ON "credential_dependency" ("dependencyType", "dependencyId")
Drop
IDX_credential_dependency_credentialId_dependencyType_dependencyId
  • credentialId
  • dependencyType
  • dependencyId
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_credential_dependency_credentialId_dependencyType_dependencyId"
ON "credential_dependency" ("credentialId", "dependencyType", "dependencyId")
Drop