From 2a2ae1a7b053e44aa7963b5103d7647a7a83fcec Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 22 Jul 2007 21:29:11 +0200 Subject: [PATCH] Make the foreign key from image to exif_info cascade on delete. --- sql/pr0n.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/pr0n.sql b/sql/pr0n.sql index c3b6689..cd528e6 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -72,7 +72,7 @@ CREATE TABLE users ( ); CREATE TABLE exif_info ( - image integer NOT NULL REFERENCES images (id), + image integer NOT NULL REFERENCES images (id) ON DELETE CASCADE, tag varchar NOT NULL, value varchar NOT NULL, -- 2.39.2