 /
 delete from krim_entity_emp_info_t where entity_id not in ('1', '1100', '1131')
 /
-delete from krim_entity_ent_typ_t where entity_id not in ('1', '1100', '1131')
+delete from krim_entity_ent_typ_t where entity_id not in ('1', '1100', '1131', 'KR1000')
 /
 delete from krim_entity_ext_id_t where entity_id not in ('1', '1100', '1131')
 /

-- delete all entity and principal data except for principalID/entityID = 1 which is the 'kr' system user
-- and principalID=admin/entityID = 1100 which is the 'admin' user
-- also keep the 'notsys' user, as it is required for KEN

delete from krim_entity_addr_t where entity_id not in ('1', '1100', '1131')
/

/
delete from KRIM_ENTITY_VISA_T where entity_id not in ('1', '1100', '1131')
/
delete from krim_entity_t where entity_id not in ('1', '1100', '1131', 'KR1000')
/

delete from krim_prncpl_t where prncpl_id not in ('1', 'admin', 'notsys', 'KR1000')
/

delete from krim_role_perm_t where role_perm_id = '856'
