db/create_system_db.sql
author Krista Grothoff <krista@pep-project.org>
Mon, 24 Oct 2016 21:33:35 +0200
branchENGINE-128
changeset 1334 85973d7d2859
parent 1028 a1ba15c1ac04
child 1126 129b561095a6
child 1513 e7f7e42385b5
permissions -rw-r--r--
ENGINE-128: closing branch
     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çe görüntülemek istiyorum');
    46 -- add more languages here
    47