Creating new Tenants on the demo server (with default data)

createTenant.sql

use `mifosplatform-tenants`;

INSERT INTO `tenant_server_connections` (`schema_name`) VALUES ('mifostenant-reference');

INSERT INTO `tenants` (`identifier`, `name`, `oltp_id`, `report_id`, `timezone_id`) VALUES ('reference', 'reference', ( select id from tenant_server_connections where schema_name="mifostenant-reference"), (select id from tenant_server_connections where schema_name="mifostenant-reference"), 'Asia/Kolkata');

create database `mifostenant-reference`;

use `mifostenant-reference`;

source load_sample_data.sql ;