Trust table now use primary key instead of separate index
authorEdouard Tisserant
Wed, 25 May 2016 13:44:44 +0200
changeset 68423c6795d6de1
parent 683 f9c1d380895a
child 685 84b0077c771c
Trust table now use primary key instead of separate index
src/pEpEngine.c
     1.1 --- a/src/pEpEngine.c	Wed May 25 12:48:18 2016 +0200
     1.2 +++ b/src/pEpEngine.c	Wed May 25 13:44:44 2016 +0200
     1.3 @@ -165,11 +165,8 @@
     1.4                  "       references pgp_keypair (fpr)\n"
     1.5                  "       on delete cascade,\n"
     1.6                  "   comm_type integer not null,\n"
     1.7 -                "   comment text\n"
     1.8 -                ");\n"
     1.9 -                "create unique index if not exists trust_index on trust (\n"
    1.10 -                "   user_id,\n"
    1.11 -                "   pgp_keypair_fpr\n"
    1.12 +                "   comment text,\n"
    1.13 +                "   primary key (user_id, pgp_keypair_fpr)\n"
    1.14                  ");\n"
    1.15                  // blacklist
    1.16                  "create table if not exists blacklist_keys (\n"