From: Mischa POSLAWSKY <perl@shiar.org>
Date: Mon, 15 Jun 2020 22:24:42 +0000 (+0200)
Subject: word: validate source values as http urls
X-Git-Tag: v1.13~194
X-Git-Url: http://git.shiar.nl/sheet.git/commitdiff_plain/3e2a6f0b83acd0126dfd79a175fe53e400ec18a3?ds=sidebyside

word: validate source values as http urls
---

diff --git a/tools/word.pg.sql b/tools/word.pg.sql
index 3c05c38..1bc5dff 100644
--- a/tools/word.pg.sql
+++ b/tools/word.pg.sql
@@ -17,7 +17,7 @@ CREATE TABLE word (
 	                                CHECK (prio >= 0 OR ref IS NOT NULL),
 	grade      integer,
 	cover      boolean     NOT NULL DEFAULT FALSE,
-	source     text,
+	source     text                 CHECK (source ~ '^https?://'),
 	thumb      text[],
 	wptitle    text,
 	created    timestamptz          DEFAULT now(),