git.shiar.nl
/
sheet.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
source: keep original file encoding
[sheet.git]
/
tools
/
word.pg.sql
diff --git
a/tools/word.pg.sql
b/tools/word.pg.sql
index 99664c9036b23f2d6ef15c3d81e717d7c5fbb90e..3c05c3865b6405ca4d00330d826053b67a65df18 100644
(file)
--- a/
tools/word.pg.sql
+++ b/
tools/word.pg.sql
@@
-3,6
+3,7
@@
CREATE TABLE login (
pass text,
email text,
fullname text,
pass text,
email text,
fullname text,
+ editlang text[],
id serial NOT NULL PRIMARY KEY
);
id serial NOT NULL PRIMARY KEY
);
@@
-12,13
+13,16
@@
CREATE TABLE word (
lang text NOT NULL DEFAULT 'en',
cat integer REFERENCES word (id),
ref integer REFERENCES word (id),
lang text NOT NULL DEFAULT 'en',
cat integer REFERENCES word (id),
ref integer REFERENCES word (id),
- prio smallint NOT NULL DEFAULT '1',
+ prio smallint DEFAULT '1'
+ CHECK (prio >= 0 OR ref IS NOT NULL),
grade integer,
cover boolean NOT NULL DEFAULT FALSE,
source text,
thumb text[],
wptitle text,
created timestamptz DEFAULT now(),
grade integer,
cover boolean NOT NULL DEFAULT FALSE,
source text,
thumb text[],
wptitle text,
created timestamptz DEFAULT now(),
+ creator integer REFERENCES login (id),
+ updated timestamptz,
id serial NOT NULL PRIMARY KEY
);
id serial NOT NULL PRIMARY KEY
);
@@
-33,10
+37,13
@@
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.updated IS 'last significant change';
+COMMENT ON COLUMN word.creator IS 'user responsible for initial submit';
CREATE OR REPLACE FUNCTION exportform(word) RETURNS text AS $$
SELECT concat(
CREATE OR REPLACE FUNCTION exportform(word) RETURNS text AS $$
SELECT concat(
- $1.prio || CASE WHEN $1.cover THEN 'c' ELSE '' END || ':',
+ $1.id, ':',
+ $1.prio, CASE WHEN $1.cover THEN 'c' ELSE '' END, ':',
array_to_string($1.form || $1.alt, '/')
);
$$ LANGUAGE SQL IMMUTABLE;
array_to_string($1.form || $1.alt, '/')
);
$$ LANGUAGE SQL IMMUTABLE;