CREATE TABLE "Tablechild" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "propstr" TEXT NOT NULL ); CREATE TABLE "Tablemaster" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "propstr" TEXT, "propint" INTEGER, "propdate" DATETIME, "propstrnotnull" TEXT NOT NULL, "tablechild" INTEGER NOT NULL REFERENCES "Tablechild" ("id") ON DELETE CASCADE ); CREATE INDEX "idx_tablemaster__tablechild" ON "Tablemaster" ("tablechild")