--
-- DB Refresh Environment Script
--

--
-- Host & URL Properties
--
--update MAXPROPVALUE set PROPVALUE='localhost:7001' where PROPNAME='mxe.hostname';

--update MAXPROPVALUE set PROPVALUE='maxmifprd1c01.corp.kwiktrip.com' where PROPNAME= 'WAS.WebServerHostName';
--update MAXPROPVALUE set PROPVALUE='[NEWHOSTNAME]' where PROPNAME= 'WAS.DeploymentManagerHostName';

update MAXPROPVALUE set PROPVALUE='jdbc:sqlserver://;serverName=SQL16TST9C01.corp.kwiktrip.com;databaseName=maxtst76;portNumber=1433;integratedSecurity=false;sendStringParametersAsUnicode=false;selectMethod=cursor;' where PROPNAME='mxe.db.url';
--update MAXPROPVALUE set PROPVALUE='[DBHOST]' where PROPNAME='Database.SQL.ServerHostName';

update MAXPROPVALUE set PROPVALUE='noreply@noemail.com' where PROPNAME='mxe.adminEmail';
update MAXPROPVALUE set PROPVALUE='noreply@noemail.com' where PROPNAME='mxe.workflow.admin';

update MAXPROPVALUE set PROPVALUE = 'www.ibm.com' where PROPNAME = 'mxe.help.host';
update MAXPROPVALUE set PROPVALUE = '80' where PROPNAME = 'mxe.help.port';

update MAXPROPVALUE set PROPVALUE='https://maxtstmif1c01.corp.kwiktrip.com/meaweb' where PROPNAME='mxe.int.webappurl';
update MAXPROPVALUE set PROPVALUE='https://maxtest.corp.kwiktrip.com/maxrest/oslc' where  PROPNAME='mxe.oslc.restwebappurl';
update MAXPROPVALUE set PROPVALUE='https://maxtest.corp.kwiktrip.com/maximo/oslc/' where  PROPNAME='mxe.oslc.webappurl';
update MAXPROPVALUE set PROPVALUE='http://maxtstbirt01.corp.kwiktrip.com:9080/maximo/report' where  PROPNAME='mxe.report.birt.viewerurl';

--
-- Update all user emails and smtp host
--
update EMAIL set EMAILADDRESS='noreply@noemail.com';
update MAXPROPVALUE set PROPVALUE='nosmtp' where PROPNAME='mail.smtp.host';

--
-- Integration Properties
--
update MAXPROPVALUE set PROPVALUE= 'C:\IBM\MIF' where PROPNAME='mxe.int.globaldir';

--
-- Clear all endpoint(s) connectivity
--
--update maximo.maxendpointdtl set value = null where property='USERNAME';
--update maximo.maxendpointdtl set value = null where property='PASSWORD';
--update maximo.maxendpointdtl set value = null where property='URL' and value like 'jdbc%';

--
-- Disabled Integrations, work flows, escalations, and cron tasks
--
update MAXEXTSYSTEM set enabled = '0';
update WFPROCESS set enabled = '0', active = '0';
update ESCALATION set  active = '0';
update CRONTASKINSTANCE set  active = '0' where not crontaskname in('REPORTLOCKRELEASE','REPORTOUTPUTCLEANUP','AsyncImmediateJobCron','AsyncJobCleanupCron');

--
-- Remove scheduled reports
--
delete from CRONTASKINSTANCE where crontaskname = 'REPORTSCHEDULE';

--
-- Attached Documents Doclinks
--
update maxpropvalue set propvalue = '\\corp.kwiktrip.com\dfs\applications\goanywherejobs\maximo\DOCLINKS75=https://maxtest.corp.kwiktrip.com/' where propname = 'mxe.doclink.path01';

--
-- Update Reporting BIRT Data Source
--
update REPORTDSPARAM set url = 'jdbc:sqlserver://ktdbmaxtstrpt:1433;databaseName=maxtst76;integratedSecurity=false;'

--
-- Change all labor rates to same rate
--
--update laborcraftrate set rate = 50;

--
-- Cleanup Tables
--
truncate table MAXINTERROR;
truncate table MAXINTERRORMSG;
truncate table MAXINTMSGTRK;
truncate table MAXINTMSGTRKDTL;
truncate table reportusagelog;
truncate table reportsched;
truncate table crontaskhistory;
truncate table taskscheduler;
truncate table logintracking;
truncate table maxsession;
truncate table serversession;