Query

database.sqlite — role_mapping_rule

SQL

CREATE TABLE "role_mapping_rule"  (
  "id" varchar(16) PRIMARY KEY NOT NULL,
  "expression" text NOT NULL,
  "role" varchar(128) NOT NULL,
  "type" varchar(64) NOT NULL,
  "order" integer 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')),
  CONSTRAINT "UQ_b33ac896ad3099fc8de36fdc1c4" UNIQUE ("type", "order"),
  CONSTRAINT "FK_bb66e404c35996b0d6946177501" FOREIGN KEY ("role") REFERENCES "role" ("slug") ON DELETE CASCADE ON UPDATE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(16) ✓ Rename | Drop
expression TEXT Rename | Drop
role varchar(128) Rename | Drop
type varchar(64) Rename | Drop
order INTEGER Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
role role.slug

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_bb66e404c35996b0d694617750 role SQL 
CREATE INDEX "IDX_bb66e404c35996b0d694617750"
ON "role_mapping_rule" ("role")
Drop
sqlite_autoindex_role_mapping_rule_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_role_mapping_rule_2
  • type
  • order
 ✓ SQL
-- no sql found --
 Drop