I added CASCADE, like this:
CREATE TABLE IF NOT EXISTS "student" (
"id" INTEGER CONSTRAINT "pk_student" PRIMARY KEY AUTOINCREMENT,
"idchr" TEXT UNIQUE NOT NULL COLLATE NOCASE,
"studentname" TEXT NOT NULL COLLATE NOCASE,
"teachinglang" TEXT NOT NULL COLLATE NOCASE,
"grade" INTEGER,
"classname" TEXT NOT NULL,
"formmaster" TEXT
);
CREATE TABLE IF NOT EXISTS "workpiecelist" (
"id" INTEGER CONSTRAINT "pk_workpiecelist" PRIMARY KEY AUTOINCREMENT,
"grade" INTEGER,
"quarter" INTEGER,
"workpiecenamehu" TEXT NOT NULL COLLATE NOCASE,
"workpiecenamesr" TEXT NOT NULL COLLATE NOCASE
);
CREATE TABLE IF NOT EXISTS "uniqueworkpiece" (
"id" INTEGER CONSTRAINT "pk_uniqueworkpiece" PRIMARY KEY AUTOINCREMENT,
"student" TEXT NOT NULL REFERENCES "student" ("idchr") ON DELETE CASCADE
ON UPDATE CASCADE ,
"workpiece_list" INTEGER NOT NULL REFERENCES "workpiecelist" ("id") ON
DELETE CASCADE ON UPDATE CASCADE,
"mark" INTEGER,
"cause" TEXT
);
-----
Best, Pál
--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
