Run further obfuscation code on Pentaho sandbox database
--------------------------------------------------------
Key: MIFOSADMIN-335
URL: http://mifosforge.jira.com/browse/MIFOSADMIN-335
Project: mifos administration
Issue Type: Task
Reporter: Ryan Whitney
Assignee: Sumit Shah
Priority: Blocker
Fix For: Cloud Release A - Iteration 6
Please run the following SQL commands on the Pentaho Sandbox database to
further obfuscate the customer data.
# Obfuscate products
update prd_offering set PRD_OFFERING_NAME = concat("loan-",PRD_OFFERING_ID),
PRD_OFFERING_SHORT_NAME = concat("l",PRD_OFFERING_ID), DESCRIPTION =
concat("loan-",PRD_OFFERING_ID) WHERE PRD_TYPE_ID = 1;
update prd_offering set PRD_OFFERING_NAME = concat("savings-",PRD_OFFERING_ID),
PRD_OFFERING_SHORT_NAME = concat("s",PRD_OFFERING_ID), DESCRIPTION =
concat("savings-",PRD_OFFERING_ID) WHERE PRD_TYPE_ID = 2;
#obfuscate Fees
update fees set FEE_NAME = concat("fee-", FEE_ID);
#Obfuscate Funds
update fund set FUND_NAME = concat('fund-', FUND_ID);
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
