Query

db.sqlite3 — core_user_services

SQL

CREATE TABLE "core_user_services"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "is_active" bool NOT NULL,
  "config" text NOT NULL CHECK ((JSON_VALID("config") OR "config" IS NULL)),
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL,
  "service_id" bigint NOT NULL REFERENCES "core_services" ("id") DEFERRABLE INITIALLY DEFERRED,
  "user_id" varchar(8) NOT NULL REFERENCES "core_users" ("uuid") DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
is_active bool Rename | Drop
config TEXT Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop
service_id bigint Rename | Drop
user_id varchar(8) Rename | Drop

Foreign Keys

Column Destination
user_id core_users.uuid
service_id core_services.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
core_user_services_service_id_4d4bb326 service_id SQL 
CREATE INDEX "core_user_services_service_id_4d4bb326"
ON "core_user_services" ("service_id")
Drop
core_user_services_user_id_96fdce58 user_id SQL 
CREATE INDEX "core_user_services_user_id_96fdce58"
ON "core_user_services" ("user_id")
Drop
core_user_services_user_id_service_id_a969e770_uniq
  • user_id
  • service_id
 ✓ SQL 
CREATE UNIQUE INDEX "core_user_services_user_id_service_id_a969e770_uniq"
ON "core_user_services" ("user_id", "service_id")
Drop