db/create_system_db.sql
author Thomas
Thu, 27 Jun 2019 09:29:20 +0200
branchsequoia_windows
changeset 3878 37426cf0d1fe
parent 1782 a070b3ce5af4
permissions -rw-r--r--
Merge with ENGINE-581
vb@1513
     1
-- This file is under GNU General Public License 3.0
vb@1513
     2
-- See LICENSE.txt
vb@1513
     3
vb@457
     4
-- DDL
vb@457
     5
vb@457
     6
CREATE TABLE i18n_language (
vb@457
     7
    lang text primary key,
vb@457
     8
    name text
vb@457
     9
);
vb@457
    10
vb@2
    11
CREATE TABLE wordlist (
vb@457
    12
    lang text
vb@457
    13
        references i18n_language (lang),
vb@457
    14
    id integer,
vb@457
    15
    word text,
vb@457
    16
    entropy integer
vb@2
    17
);
vb@2
    18
vb@2
    19
CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
vb@251
    20
vb@457
    21
CREATE TABLE i18n_token (
vb@457
    22
    lang text
vb@457
    23
        references i18n_language (lang),
vb@457
    24
    id integer,
vb@251
    25
    phrase text
vb@251
    26
);
vb@251
    27
vb@457
    28
CREATE UNIQUE INDEX i18n_token_pk on i18n_token (lang, id);
vb@457
    29
vb@457
    30
-- DML
vb@457
    31
vb@457
    32
INSERT INTO i18n_language VALUES ('en', 'English');
vb@576
    33
INSERT INTO i18n_token VALUES ('en', 1000, 'I want to display the trustwords in English language');
vb@457
    34
vb@457
    35
INSERT INTO i18n_language VALUES ('de', 'Deutsch');
vb@576
    36
INSERT INTO i18n_token VALUES ('de', 1000, 'Ich möchte die Trustwords auf Deutsch haben');
vb@457
    37
Edouard@790
    38
INSERT INTO i18n_language VALUES ('fr', 'Français');
Edouard@790
    39
INSERT INTO i18n_token VALUES ('fr', 1000, 'Je voudrais afficher les trustwords en Français');
Edouard@790
    40
Edouard@790
    41
INSERT INTO i18n_language VALUES ('es', 'Español');
Edouard@790
    42
INSERT INTO i18n_token VALUES ('es', 1000, 'Quiero mostrar las trustwords en español');
Edouard@790
    43
Edouard@790
    44
INSERT INTO i18n_language VALUES ('ca', 'Català');
Edouard@790
    45
INSERT INTO i18n_token VALUES ('ca', 1000, 'Vull mostrar les trustwords en català');
Edouard@795
    46
lix@796
    47
INSERT INTO i18n_language VALUES ('tr', 'Türkçe');
dirk@1028
    48
INSERT INTO i18n_token VALUES ('tr', 1000, 'Güvenlik kelimelerini Türkçe görüntülemek istiyorum');
edouard@1781
    49
edouard@1781
    50
INSERT INTO i18n_language VALUES ('nl', 'Nederlands');
edouard@1782
    51
INSERT INTO i18n_token VALUES ('nl', 1000, 'Ik wil de trustwords in de nederlandse taal laten zien');
vb@364
    52
-- add more languages here
vb@457
    53