Query

database.sqlite — deployment_key

SQL

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'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
type varchar(64) Rename | Drop
value TEXT Rename | Drop
algorithm varchar(20) ✓ Rename | Drop
status varchar(20) Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_deployment_key_data_encryption_active type ✓ SQL 
CREATE UNIQUE INDEX "IDX_deployment_key_data_encryption_active"
ON "deployment_key" ("type") WHERE status = 'active' AND type = 'data_encryption'
Drop
IDX_deployment_key_instance_id_active type ✓ SQL 
CREATE UNIQUE INDEX "IDX_deployment_key_instance_id_active"
ON "deployment_key" ("type") WHERE status = 'active' AND type = 'instance.id'
Drop
IDX_deployment_key_jwe_private_key_active
  • type
  • algorithm
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_deployment_key_jwe_private_key_active"
ON "deployment_key" ("type", "algorithm") WHERE status = 'active' AND type = 'jwe.private-key'
Drop
IDX_deployment_key_signing_binary_data_active type ✓ SQL 
CREATE UNIQUE INDEX "IDX_deployment_key_signing_binary_data_active"
ON "deployment_key" ("type") WHERE status = 'active' AND type = 'signing.binary_data'
Drop
IDX_deployment_key_signing_hmac_active type ✓ SQL 
CREATE UNIQUE INDEX "IDX_deployment_key_signing_hmac_active"
ON "deployment_key" ("type") WHERE status = 'active' AND type = 'signing.hmac'
Drop
IDX_deployment_key_signing_jwt_active type ✓ SQL 
CREATE UNIQUE INDEX "IDX_deployment_key_signing_jwt_active"
ON "deployment_key" ("type") WHERE status = 'active' AND type = 'signing.jwt'
Drop
sqlite_autoindex_deployment_key_1 id ✓ SQL
-- no sql found --
 Drop