Remove the site specific data from the state and the Configuration Databases

F.5 Remove the site specific data from the state and the Configuration Databases

This section details the steps for deleting the site specific data from the state and the configuration databases.

Delete the following data from the NRF application database:


$ DELETE FROM NfScreening WHERE recordOwner = '<NRF’s NF Instance ID of
Site under deletion>';
$ DELETE FROM NrfSystemOptions WHERE recordOwner = '<NRF’s NF Instance
ID of Site under deletion>';
$ DELETE FROM NfInstances WHERE recordOwner = '<NRF’s NF Instance ID of
Site under deletion>';
$ DELETE FROM NfStatusMonitor WHERE recordOwner = '<NRF’s NF Instance
ID of Site under deletion>';
$ DELETE FROM NfSubscriptions WHERE recordOwner = '<NRF’s NF Instance
ID of Site under deletion>';
$ DELETE FROM NrfEventTransactions WHERE recordCreator = '<NRF’s NF
Instance ID of Site under deletion>';
$ DELETE FROM SiteJsonSchemaVersionInfo WHERE SiteId = '<NRF’s NF
Instance ID of Site under deletion>';
$ DELETE FROM SiteIdToNrfInstanceIdMapping WHERE recordOwner = '<NRF’s
NF Instance ID of Site under deletion>';

Delete the following data from the NRF network database:


$ DELETE FROM ReleaseConfig WHERE SiteId = '<NRF’s NF Instance ID of
Site under deletion>';
$ DELETE FROM NfScreening_backup WHERE recordOwner = '<NRF’s NF
Instance ID of Site under deletion>';
$ DELETE FROM NrfSystemOptions_backup WHERE recordOwner = '<NRF’s NF
Instance ID of Site under deletion>';
$ DELETE FROM SiteIdToNrfInstanceIdMapping_backup WHERE recordOwner =
'<NRF’s NF Instance ID of Site under deletion>';

Delete the following data from NRF site-specific common configuration database (commonConfigurationDB):
```
DROP TABLE IF EXISTS common_configuration;
DROP TABLE IF EXISTS common_configuration_backup;
```
Delete the following data from the NRF site-specific Leader Election database (leaderElectionDB):
```
DROP TABLE IF EXISTS NrfAuditorLeaderPod;
DROP TABLE IF EXISTS perf_info_leader_election;
```