db/create_system_db.sql
author Volker Birk <vb@pep-project.org>
Mon, 05 Oct 2015 02:06:43 +0200
changeset 364 605a4990915c
parent 363 a2a3e5a9e3f2
child 457 7802147af797
permissions -rw-r--r--
Makefile for system.db
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@363
    11
    lang text primary key,
vb@251
    12
    phrase text
vb@251
    13
);
vb@251
    14
vb@363
    15
INSERT INTO i18n VALUES ('en', 'I want to have this conversation in English language');
vb@363
    16
INSERT INTO i18n VALUES ('de', 'Ich möchte diese Unterhaltung auf Deutsch führen');
vb@364
    17
-- add more languages here