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)
     1 -- DDL
     2 
     3 CREATE TABLE i18n_language (
     4     lang text primary key,
     5     name text
     6 );
     7 
     8 CREATE TABLE wordlist (
     9     lang text
    10         references i18n_language (lang),
    11     id integer,
    12     word text,
    13     entropy integer
    14 );
    15 
    16 CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
    17 
    18 CREATE TABLE i18n_token (
    19     lang text
    20         references i18n_language (lang),
    21     id integer,
    22     phrase text
    23 );
    24 
    25 CREATE UNIQUE INDEX i18n_token_pk on i18n_token (lang, id);
    26 
    27 -- DML
    28 
    29 INSERT INTO i18n_language VALUES ('en', 'English');
    30 INSERT INTO i18n_token VALUES ('en', 1000, 'I want to display the trustwords in English language');
    31 
    32 INSERT INTO i18n_language VALUES ('de', 'Deutsch');
    33 INSERT INTO i18n_token VALUES ('de', 1000, 'Ich möchte die Trustwords auf Deutsch haben');
    34 
    35 INSERT INTO i18n_language VALUES ('fr', 'Français');
    36 INSERT INTO i18n_token VALUES ('fr', 1000, 'Je voudrais afficher les trustwords en Français');
    37 
    38 INSERT INTO i18n_language VALUES ('es', 'Español');
    39 INSERT INTO i18n_token VALUES ('es', 1000, 'Quiero mostrar las trustwords en español');
    40 
    41 INSERT INTO i18n_language VALUES ('ca', 'Català');
    42 INSERT INTO i18n_token VALUES ('ca', 1000, 'Vull mostrar les trustwords en català');
    43 
    44 INSERT INTO i18n_language VALUES ('tr', 'Türkçe');
    45 INSERT INTO i18n_token VALUES ('tr', 1000, 'Güvenlik kelimelerini Türk görüntülemek istiyorum');
    46 -- add more languages here
    47