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
     1 CREATE TABLE wordlist (
     2    lang text,
     3    id integer,
     4    word text,
     5    entropy integer
     6 );
     7 
     8 CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
     9 
    10 CREATE TABLE i18n (
    11     lang text,
    12     id integer,
    13     phrase text
    14 );
    15 
    16 CREATE UNIQUE INDEX i18n_pk on i18n (lang, id);
    17 
    18 INSERT INTO i18n VALUES ('en', 1, 'I want to have this conversation in English language');
    19 INSERT INTO i18n VALUES ('de', 1, 'Ich möchte diese Unterhaltung auf Deutsch führen');
    20 ' add more languages here