- modify person_key and keys table definitions to ignore deleted keys

[plcapi.git] / tools / plcdb.3-4.conf

diff --git a/tools/plcdb.3-4.conf b/tools/plcdb.3-4.conf
index cd16108..37f86d7 100644 (file)
--- a/tools/plcdb.3-4.conf
+++ b/tools/plcdb.3-4.conf
@@ -22,9 +22,9 @@ address_address_type = 'address_id:addresses.address_id:addresses.address_type_i
 
 key_types = 'key_type:key_types.key_type'
 
-keys = 'key_id:keys.key_id, key_type:keys.key_type, key:keys.key, is_blacklisted:keys.is_blacklisted'
+keys = 'key_id:keys.key_id:person_keys.key_id:person_keys.deleted=false, key_type:keys.key_type, key:keys.key, is_blacklisted:keys.is_blacklisted'
 
-person_key = 'person_id:person_keys.person_id, key_id:person_keys.key_id'
+person_key = 'person_id:person_keys.person_id:person_keys.deleted=false, key_id:person_keys.key_id'
 
 roles = 'role_id:roles.role_id, name:roles.name'