schema: cascade delete pages on domain removal

schema: cascade delete pages on domain removal v1 PROPOSED

Umar Getagazov: 1
 schema: cascade delete pages on domain removal

 1 files changed, 1 insertions(+), 1 deletions(-)

Export patchset (mbox)

How do I use this?

Copy & paste the following snippet into your terminal to import this patchset into git:

curl -s https://lists.sr.ht/~sircmpwn/searchhut-devel/patches/33888/mbox | git am -3

Learn more about email & git

Reply to thread View this thread in the archives

[PATCH] schema: cascade delete pages on domain removal Export this patch

Umar Getagazov <umar@handlerug.me>

2 years ago

Implements: https://todo.sr.ht/~sircmpwn/searchhut/7
---
 schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/schema.sql b/schema.sql
index e27ae03..c5d00dc 100644
--- a/schema.sql
+++ b/schema.sql
@@ -11,7 +11,7 @@ CREATE TABLE domain (
 
 CREATE TABLE page (
 	id integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-	domain_id integer NOT NULL REFERENCES domain(id),
+	domain_id integer NOT NULL REFERENCES domain(id) ON DELETE CASCADE,
 	source varchar NOT NULL,
 	url text NOT NULL UNIQUE,
 	is_index boolean NOT NULL,
-- 
2.32.1 (Apple Git-133)