db/create_system_db.sql
author Edouard Tisserant
Sat, 02 Jul 2016 18:15:42 +0200
changeset 790 33f46c1babcc
parent 576 ebd20b67dbdd
child 795 bb7b7207d7c6
permissions -rw-r--r--
Declared fr, es, and ca in system.db added stub es.csv and ca.csv
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à');
vb@364
    43
-- add more languages here
vb@457
    44