~sircmpwn/searchhut-devel

This thread contains a patchset. You're looking at the original emails, but you may wish to use the patch review UI. Review patch

[PATCH] schema: cascade delete pages on domain removal

Details
Message ID
<20220714184131.5991-1-umar@handlerug.me>
DKIM signature
missing
Download raw message
Patch: +1 -1
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)
Reply to thread Export thread (mbox)