Query

database.sqlite — role_scope

SQL

CREATE TABLE role_scope  (
  "roleSlug" VARCHAR(128) NOT NULL,
  "scopeSlug" VARCHAR(128) NOT NULL,
  CONSTRAINT "PK_role_scope" PRIMARY KEY ("roleSlug", "scopeSlug"),
  CONSTRAINT "FK_role" FOREIGN KEY ("roleSlug") REFERENCES role ("slug") ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT "FK_scope" FOREIGN KEY ("scopeSlug") REFERENCES "scope" ("slug") ON DELETE CASCADE ON UPDATE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
roleSlug VARCHAR(128) ✓ Rename | Drop
scopeSlug VARCHAR(128) ✓ Rename | Drop

Foreign Keys

Column Destination
scopeSlug scope.slug
roleSlug role.slug

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_role_scope_scopeSlug scopeSlug SQL 
CREATE INDEX "IDX_role_scope_scopeSlug"
ON "role_scope" ("scopeSlug")
Drop
sqlite_autoindex_role_scope_1
  • roleSlug
  • scopeSlug
 ✓ SQL
-- no sql found --
 Drop