db/create_system_db.sql
changeset 251 dba7f09db1ed
parent 2 f1fc3afacfd6
child 360 8919a040c219
     1.1 --- a/db/create_system_db.sql	Wed May 06 13:46:08 2015 +0200
     1.2 +++ b/db/create_system_db.sql	Wed May 06 20:16:53 2015 +0200
     1.3 @@ -6,3 +6,15 @@
     1.4  );
     1.5  
     1.6  CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
     1.7 +
     1.8 +CREATE TABLE i18n (
     1.9 +    lang text,
    1.10 +    id integer,
    1.11 +    phrase text
    1.12 +);
    1.13 +
    1.14 +CREATE UNIQUE INDEX i18n_pk on i18n (lang, id);
    1.15 +
    1.16 +INSERT INTO i18n VALUES ('en', 1, 'I want to have this conversation in English language');
    1.17 +INSERT INTO i18n VALUES ('de', 1, 'Ich möchte diese Unterhaltung auf Deutsch führen');
    1.18 +' add more languages here