db/create_system_db.sql
author Volker Birk <vb@pep-project.org>
Wed, 06 May 2015 20:16:53 +0200
changeset 251 dba7f09db1ed
parent 2 f1fc3afacfd6
child 360 8919a040c219
permissions -rw-r--r--
completing rating
     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