word/edit: allow unnamed and/or untranslated entries

[sheet.git] / tools / word.pg.sql

diff --git a/tools/word.pg.sql b/tools/word.pg.sql
index a142ebc6cab2215e16012ebccb52f4cbf33cb8d1..821814d1f18a828d983a479a137e9ef32173f905 100644 (file)
--- a/tools/word.pg.sql
+++ b/tools/word.pg.sql
@@ -8,9 +8,9 @@ CREATE TABLE login (
 );
 
 CREATE TABLE word (
 );
 
 CREATE TABLE word (

-       form       text        NOT NULL,
+       form       text,

        alt        text[],
        alt        text[],

-       lang       text        NOT NULL DEFAULT 'en',
+       lang       text                 DEFAULT 'en',

        cat        integer              REFERENCES word (id),
        ref        integer              REFERENCES word (id),
        prio       smallint             DEFAULT '1'
        cat        integer              REFERENCES word (id),
        ref        integer              REFERENCES word (id),
        prio       smallint             DEFAULT '1'