X-Git-Url: http://git.shiar.nl/sheet.git/blobdiff_plain/3d0e1e761a53934cfdadf6e7e28ced4ec6e603e3..d91598a4f20dc03e12905d7c15e63bfa16116529:/tools/word.pg.sql?ds=inline 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';