word: validate source values as http urls

diff --git a/tools/word.pg.sql b/tools/word.pg.sql
index 3c05c3865b6405ca4d00330d826053b67a65df18..1bc5dffcc78e25f5dea4d0dee6164a6069f71ef9 100644 (file)
--- 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(),