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
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