source: keep original file encoding

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

diff --git a/tools/word.pg.sql b/tools/word.pg.sql
index 101af7a19491142d9d91920240d22c04017547ec..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,7 +13,8 @@ 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,
        grade      integer,
        cover      boolean     NOT NULL DEFAULT FALSE,
        source     text,


@@ -40,7 +42,8 @@ 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;