Query

database.sqlite — user_favorites

SQL

CREATE TABLE "user_favorites"  (
  "id" integer PRIMARY KEY NOT NULL,
  "userId" varchar NOT NULL,
  "resourceId" varchar(255) NOT NULL,
  "resourceType" varchar(64) NOT NULL,
  CONSTRAINT "UQ_cf6ae658ead9ffc124723413c65" UNIQUE ("userId", "resourceId", "resourceType"),
  CONSTRAINT "FK_1dd5c393ad0517be3c31a7af836" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
userId varchar Rename | Drop
resourceId varchar(255) Rename | Drop
resourceType varchar(64) Rename | Drop

Foreign Keys

Column Destination
userId user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_1d11050a381548c42c32cc25c4
  • resourceType
  • resourceId
 SQL 
CREATE INDEX "IDX_1d11050a381548c42c32cc25c4"
ON "user_favorites" ("resourceType", "resourceId")
Drop
IDX_1dd5c393ad0517be3c31a7af83 userId SQL 
CREATE INDEX "IDX_1dd5c393ad0517be3c31a7af83"
ON "user_favorites" ("userId")
Drop
sqlite_autoindex_user_favorites_1
  • userId
  • resourceId
  • resourceType
 ✓ SQL
-- no sql found --
 Drop