X-Git-Url: http://git.shiar.nl/sheet.git/blobdiff_plain/1615f765ad664475d41a68e6cf8bc1da708fe03d..cf905894dcf3c4c9cdff7732f8d69c1e893bc1da:/tools/word.pg.sql diff --git a/tools/word.pg.sql b/tools/word.pg.sql index 31a117e..55de8ec 100644 --- a/tools/word.pg.sql +++ b/tools/word.pg.sql @@ -1,7 +1,7 @@ CREATE TABLE word ( form text NOT NULL, alt text[], - lang text NOT NULL DEFAULT 'eng', + lang text NOT NULL DEFAULT 'en', cat integer REFERENCES word (id), ref integer REFERENCES word (id), prio smallint NOT NULL DEFAULT '1', @@ -16,9 +16,9 @@ CREATE TABLE word ( COMMENT ON COLUMN word.form IS 'preferred textual representation'; COMMENT ON COLUMN word.alt IS 'alternate forms with equivalent meaning'; -COMMENT ON COLUMN word.lang IS 'ISO 639-3 language code'; +COMMENT ON COLUMN word.lang IS 'ISO 639 language code matching wikipedia subdomain'; COMMENT ON COLUMN word.cat IS 'hierarchical classification'; -COMMENT ON COLUMN word.ref IS 'reference to equivalent eng translation'; +COMMENT ON COLUMN word.ref IS 'reference to equivalent en translation'; COMMENT ON COLUMN word.prio IS 'difficulty level or importance; lower values have precedence'; COMMENT ON COLUMN word.grade IS 'ascending hierarchical order, preceding default alphabetical'; COMMENT ON COLUMN word.cover IS 'highlight if selected';