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