git.shiar.nl
/
sheet.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
word: validate source values as http urls
[sheet.git]
/
tools
/
word.pg.sql
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(),