Eliminar un tenant o un vertical es posible pero es un proceso manual que requiere de los siguientes pasos.
Tendremos Tendrás que acceder a la base de datos de configuración de plataforma (config db), y ejecutar las siguientes instrucciones:
| Code Block |
|---|
use onesaitplatform_config_master; #DELETE TENANT delete from master_user where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT"); delete from master_user_token where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT"); delete from vertical_tenant where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT"); delete from master_device_token where tenant="NOMBRE_TENANT"; delete from tenant where tenant.name="NOMBRE_TENANT"; #DELETE VERTICAL delete from master_user where tenant_id in (select tenant_id from vertical_tenant inner join vertical on vertical.id=vertical_id where vertical.name="NOMBRE_VERTICAL"); delete from master_user_token where tenant_id in (select tenant_id from vertical_tenant inner join vertical on vertical.id=vertical_id where vertical.name="NOMBRE_VERTICAL"); delete from vertical_tenant where vertical_id in (select vertical.id from vertical where vertical.name="NOMBRE_VERTICAL"); delete from master_device_token where vertical="NOMBRE_VERTICAL"; drop schema onesaitplatform_config_NOMBRE_VERTICAL; |
Por último deberemos hacer debeshacer lo siguiente:
Parar cacheservice.
Parar controlpanelservice.
Arrancar cacheservice y controlpanelservice.