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/edit: precalculate image width and height
[sheet.git]
/
tools
/
word.pg.sql
diff --git
a/tools/word.pg.sql
b/tools/word.pg.sql
index fb1e5d11a586d388a5641a7d2edf091eb1091192..ec552c968b4a0add4f328d6e676deb434eccad60 100644
(file)
--- a/
tools/word.pg.sql
+++ b/
tools/word.pg.sql
@@
-20,6
+20,7
@@
CREATE TABLE word (
source text CHECK (source ~ '^https?://'),
thumb text[],
wptitle text,
source text CHECK (source ~ '^https?://'),
thumb text[],
wptitle text,
+ story text,
creator integer REFERENCES login (id),
created timestamptz DEFAULT now(),
updated timestamptz,
creator integer REFERENCES login (id),
created timestamptz DEFAULT now(),
updated timestamptz,
@@
-37,6
+38,7
@@
COMMENT ON COLUMN word.cover IS 'highlight if selected';
COMMENT ON COLUMN word.source IS 'URI of downloaded image';
COMMENT ON COLUMN word.thumb IS 'ImageMagick convert options to create thumbnail from source image';
COMMENT ON COLUMN word.wptitle IS 'reference Wikipedia article';
COMMENT ON COLUMN word.source IS 'URI of downloaded image';
COMMENT ON COLUMN word.thumb IS 'ImageMagick convert options to create thumbnail from source image';
COMMENT ON COLUMN word.wptitle IS 'reference Wikipedia article';
+COMMENT ON COLUMN word.story IS 'paragraph defining or describing the entity, wikipedia intro';
COMMENT ON COLUMN word.updated IS 'last significant change';
COMMENT ON COLUMN word.creator IS 'user responsible for initial submit';
COMMENT ON COLUMN word.updated IS 'last significant change';
COMMENT ON COLUMN word.creator IS 'user responsible for initial submit';
@@
-59,6
+61,7
@@
CREATE OR REPLACE VIEW _word_ref AS
coalesce(r.source, w.source ) source,
coalesce(r.thumb, w.thumb ) thumb,
coalesce(r.wptitle, w.wptitle) wptitle,
coalesce(r.source, w.source ) source,
coalesce(r.thumb, w.thumb ) thumb,
coalesce(r.wptitle, w.wptitle) wptitle,
+ coalesce(r.story, w.story ) story,
r.creator, r.created, r.updated,
CASE WHEN r.source IS NULL THEN w.id ELSE r.id END id -- image id
FROM word r
r.creator, r.created, r.updated,
CASE WHEN r.source IS NULL THEN w.id ELSE r.id END id -- image id
FROM word r