db/create_system_db.sql
author Volker Birk <vb@pep-project.org>
Mon, 01 Jun 2015 22:25:40 +0200
changeset 308 e3e4305cfa34
parent 251 dba7f09db1ed
child 360 8919a040c219
permissions -rw-r--r--
skip whitespace while testing for PGP message
vb@2
     1
CREATE TABLE wordlist (
vb@2
     2
   lang text,
vb@2
     3
   id integer,
vb@2
     4
   word text,
vb@2
     5
   entropy integer
vb@2
     6
);
vb@2
     7
vb@2
     8
CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
vb@251
     9
vb@251
    10
CREATE TABLE i18n (
vb@251
    11
    lang text,
vb@251
    12
    id integer,
vb@251
    13
    phrase text
vb@251
    14
);
vb@251
    15
vb@251
    16
CREATE UNIQUE INDEX i18n_pk on i18n (lang, id);
vb@251
    17
vb@251
    18
INSERT INTO i18n VALUES ('en', 1, 'I want to have this conversation in English language');
vb@251
    19
INSERT INTO i18n VALUES ('de', 1, 'Ich möchte diese Unterhaltung auf Deutsch führen');
vb@251
    20
' add more languages here