db/create_system_db.sql
author Dirk Zimmermann <dirk@pep-project.org>
Wed, 17 Aug 2016 09:31:44 +0200
changeset 1027 ad235776cf40
parent 962 aff7b6e41fde
child 1028 a1ba15c1ac04
permissions -rw-r--r--
Change turkish language trustwords dialog (via Berna/Dean)
vb@457
     1
-- DDL
vb@457
     2
vb@457
     3
CREATE TABLE i18n_language (
vb@457
     4
    lang text primary key,
vb@457
     5
    name text
vb@457
     6
);
vb@457
     7
vb@2
     8
CREATE TABLE wordlist (
vb@457
     9
    lang text
vb@457
    10
        references i18n_language (lang),
vb@457
    11
    id integer,
vb@457
    12
    word text,
vb@457
    13
    entropy integer
vb@2
    14
);
vb@2
    15
vb@2
    16
CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
vb@251
    17
vb@457
    18
CREATE TABLE i18n_token (
vb@457
    19
    lang text
vb@457
    20
        references i18n_language (lang),
vb@457
    21
    id integer,
vb@251
    22
    phrase text
vb@251
    23
);
vb@251
    24
vb@457
    25
CREATE UNIQUE INDEX i18n_token_pk on i18n_token (lang, id);
vb@457
    26
vb@457
    27
-- DML
vb@457
    28
vb@457
    29
INSERT INTO i18n_language VALUES ('en', 'English');
vb@576
    30
INSERT INTO i18n_token VALUES ('en', 1000, 'I want to display the trustwords in English language');
vb@457
    31
vb@457
    32
INSERT INTO i18n_language VALUES ('de', 'Deutsch');
vb@576
    33
INSERT INTO i18n_token VALUES ('de', 1000, 'Ich möchte die Trustwords auf Deutsch haben');
vb@457
    34
Edouard@790
    35
INSERT INTO i18n_language VALUES ('fr', 'Français');
Edouard@790
    36
INSERT INTO i18n_token VALUES ('fr', 1000, 'Je voudrais afficher les trustwords en Français');
Edouard@790
    37
Edouard@790
    38
INSERT INTO i18n_language VALUES ('es', 'Español');
Edouard@790
    39
INSERT INTO i18n_token VALUES ('es', 1000, 'Quiero mostrar las trustwords en español');
Edouard@790
    40
Edouard@790
    41
INSERT INTO i18n_language VALUES ('ca', 'Català');
Edouard@790
    42
INSERT INTO i18n_token VALUES ('ca', 1000, 'Vull mostrar les trustwords en català');
Edouard@795
    43
lix@796
    44
INSERT INTO i18n_language VALUES ('tr', 'Türkçe');
dirk@1027
    45
INSERT INTO i18n_token VALUES ('tr', 1000, 'Güvenlik kelimelerini Türk görüntülemek istiyorum');
vb@364
    46
-- add more languages here
vb@457
    47