DDL needs no ID for languages
authorVolker Birk <vb@pep-project.org>
Mon, 05 Oct 2015 01:41:28 +0200
changeset 363a2a3e5a9e3f2
parent 362 182c36b11216
child 364 605a4990915c
DDL needs no ID for languages
db/create_system_db.sql
     1.1 --- a/db/create_system_db.sql	Mon Oct 05 01:30:38 2015 +0200
     1.2 +++ b/db/create_system_db.sql	Mon Oct 05 01:41:28 2015 +0200
     1.3 @@ -8,13 +8,10 @@
     1.4  CREATE UNIQUE INDEX wordlist_pk on wordlist (lang, id);
     1.5  
     1.6  CREATE TABLE i18n (
     1.7 -    lang text,
     1.8 -    id integer,
     1.9 +    lang text primary key,
    1.10      phrase text
    1.11  );
    1.12  
    1.13 -CREATE UNIQUE INDEX i18n_pk on i18n (lang, id);
    1.14 -
    1.15 -INSERT INTO i18n VALUES ('en', 1, 'I want to have this conversation in English language');
    1.16 -INSERT INTO i18n VALUES ('de', 2, 'Ich möchte diese Unterhaltung auf Deutsch führen');
    1.17 +INSERT INTO i18n VALUES ('en', 'I want to have this conversation in English language');
    1.18 +INSERT INTO i18n VALUES ('de', 'Ich möchte diese Unterhaltung auf Deutsch führen');
    1.19  ' add more languages here