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
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@1028
    45
INSERT INTO i18n_token VALUES ('tr', 1000, 'Güvenlik kelimelerini Türkçe görüntülemek istiyorum');
vb@364
    46
-- add more languages here
vb@457
    47