Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Eliminar un tenant o un vertical es posible pero es un proceso manual que requiere de los siguientes pasos.

Tendremos que acceder a la base de datos de configuración de plataforma (config db), y ejecutar las siguientes instrucciones:

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 lo siguiente:

  1. Parar cacheservice

  2. Parar controlpanelservice

  3. Arrancar cacheservice y controlpanelservice

  • No labels