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
     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 primary key,
    12     phrase text
    13 );
    14 
    15 INSERT INTO i18n VALUES ('en', 'I want to have this conversation in English language');
    16 INSERT INTO i18n VALUES ('de', 'Ich möchte diese Unterhaltung auf Deutsch führen');
    17 -- add more languages here