src/pEpEngine.c
changeset 2514 0616c62d04a9
parent 2509 dde6a233c9dd
child 2515 62d3239ac7a9
     1.1 --- a/src/pEpEngine.c	Fri Feb 16 18:55:19 2018 +0100
     1.2 +++ b/src/pEpEngine.c	Sat Feb 17 21:23:58 2018 +0100
     1.3 @@ -10,7 +10,7 @@
     1.4  #include <time.h>
     1.5  #include <stdlib.h>
     1.6  
     1.7 -#define _PEP_SQLITE_DEBUG 0
     1.8 +#define _PEP_SQLITE_DEBUG 1
     1.9  #if _PEP_SQLITE_DEBUG
    1.10  #include <sqlite3.h>
    1.11  #endif
    1.12 @@ -993,7 +993,13 @@
    1.13                      "   timestamp integer default (datetime('now')),\n"
    1.14                      "   primary key (address, user_id)\n"
    1.15                      ");\n"
    1.16 -                    "INSERT INTO identity SELECT * FROM _identity_old;\n"
    1.17 +                    "INSERT INTO identity (address, user_id, main_key_id, "
    1.18 +                    "                      comment, flags, is_own) "
    1.19 +                    "   SELECT _identity_old.address, _identity_old.user_id, "
    1.20 +                    "          _identity_old.main_key_id, _identity_old.comment, "
    1.21 +                    "          _identity_old.flags, _identity_old.is_own "
    1.22 +                    "   FROM _identity_old "
    1.23 +                    "   WHERE 1;\n"
    1.24                      "DROP TABLE _identity_old;\n"
    1.25                      "COMMIT;\n"
    1.26                      "\n"