db/create_system_db.sql
author Krista Grothoff <krista@pep-project.org>
Thu, 09 Mar 2017 12:41:34 +0100
branchENGINE-174
changeset 1637 4078d6ed8b3b
parent 1513 e7f7e42385b5
child 1781 bf2480adf5f2
permissions -rw-r--r--
merge from default
     1 -- This file is under GNU General Public License 3.0
     2 -- See LICENSE.txt
     3 
     4 -- DDL
     5 
     6 CREATE TABLE i18n_language (
     7     lang text primary key,
     8     name text
     9 );
    10 
    11 CREATE TABLE wordlist (
    12     lang text
    13         references i18n_language (lang),
    14     id integer,
    15     word text,
    16     entropy integer
    17 );
    18 
    19 CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
    20 
    21 CREATE TABLE i18n_token (
    22     lang text
    23         references i18n_language (lang),
    24     id integer,
    25     phrase text
    26 );
    27 
    28 CREATE UNIQUE INDEX i18n_token_pk on i18n_token (lang, id);
    29 
    30 -- DML
    31 
    32 INSERT INTO i18n_language VALUES ('en', 'English');
    33 INSERT INTO i18n_token VALUES ('en', 1000, 'I want to display the trustwords in English language');
    34 
    35 INSERT INTO i18n_language VALUES ('de', 'Deutsch');
    36 INSERT INTO i18n_token VALUES ('de', 1000, 'Ich möchte die Trustwords auf Deutsch haben');
    37 
    38 INSERT INTO i18n_language VALUES ('fr', 'Français');
    39 INSERT INTO i18n_token VALUES ('fr', 1000, 'Je voudrais afficher les trustwords en Français');
    40 
    41 INSERT INTO i18n_language VALUES ('es', 'Español');
    42 INSERT INTO i18n_token VALUES ('es', 1000, 'Quiero mostrar las trustwords en español');
    43 
    44 INSERT INTO i18n_language VALUES ('ca', 'Català');
    45 INSERT INTO i18n_token VALUES ('ca', 1000, 'Vull mostrar les trustwords en català');
    46 
    47 INSERT INTO i18n_language VALUES ('tr', 'Türkçe');
    48 INSERT INTO i18n_token VALUES ('tr', 1000, 'Güvenlik kelimelerini Türkçe görüntülemek istiyorum');
    49 -- add more languages here
    50