Fixed get/set device group SQL statements keysync
authorEdouard Tisserant <edouard@pep-project.org>
Mon, 03 Oct 2016 22:22:36 +0200
branchkeysync
changeset 123718438a7595d7
parent 1236 991afc1aa2a1
child 1238 191fe41c2513
Fixed get/set device group SQL statements
src/pEpEngine.c
     1.1 --- a/src/pEpEngine.c	Mon Oct 03 19:08:15 2016 +0200
     1.2 +++ b/src/pEpEngine.c	Mon Oct 03 22:22:36 2016 +0200
     1.3 @@ -323,10 +323,10 @@
     1.4                           "      where id = ?1), upper(replace(?4,' ',''))))) ;";
     1.5  
     1.6          sql_set_device_group = "update person set device_group = ?1 "
     1.7 -                               "where user_id = '" PEP_OWN_USERID "';";
     1.8 +                               "where id = '" PEP_OWN_USERID "';";
     1.9  
    1.10          sql_get_device_group = "select device_group from person "
    1.11 -                               "where user_id = '" PEP_OWN_USERID "';";
    1.12 +                               "where id = '" PEP_OWN_USERID "';";
    1.13  
    1.14          sql_set_pgp_keypair = "insert or replace into pgp_keypair (fpr) "
    1.15                                "values (upper(replace(?1,' ',''))) ;";