Query

db.sqlite3 — django_content_type

SQL

CREATE TABLE "django_content_type"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "app_label" varchar(100) NOT NULL,
  "model" varchar(100) NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
app_label varchar(100) Rename | Drop
model varchar(100) Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
django_content_type_app_label_model_76bd3d3b_uniq
  • app_label
  • model
 ✓ SQL 
CREATE UNIQUE INDEX "django_content_type_app_label_model_76bd3d3b_uniq"
ON "django_content_type" ("app_label", "model")
Drop