Creating Database Account on MySQL Database

Create a new database account on MySQL database by executing following command:
CREATE USER 'nefusr'@'%'IDENTIFIED BY 'nefpasswd';
GRANT ALL PRIVILEGES ON *.* TO 'nefusr'@'%';
mysql -h<MYSQL_HOST> -u <USERNAME> -p <PASSWORD>
At first login to MySQL console via new user created above,
mysql -h<MYSQL_HOST> -u nefusr -p nefpasswd
Execute the below script to initialize Network Exposure Function databases.
CREATE DATABASE IF NOT EXISTS `ocpm_nef_me`;

CREATE TABLE IF NOT EXISTS `ocpm_nef_me`.`mesubscription` (

  `id` int(11) NOT NULL,

  `me_subscription` json DEFAULT NULL,

  `tltrid` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_me`. `hibernate_sequence` (

  `next_val` bigint(20) DEFAULT NULL

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

insert into `ocpm_nef_me`. `hibernate_sequence` values (0);

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_me`.`me_charging` (

  `charging_id` varchar(128) NOT NULL,

  `charging_request_data` json DEFAULT NULL,

  PRIMARY KEY (`charging_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE DATABASE IF NOT EXISTS `ocpm_capif_core`;

CREATE TABLE IF NOT EXISTS `ocpm_capif_core`.`aef_api_profile` (

  `apf_id` varchar(255) NOT NULL,

  `api_id` varchar(255) NOT NULL,

  `aef_profiles` json DEFAULT NULL,

  `api_name` varchar(255) DEFAULT NULL,

  `description` varchar(255) DEFAULT NULL,

  `supported_features` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`apf_id`,`api_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_capif_core`. `invoker_profile` (

  `invoker_id` varchar(255) NOT NULL,

  `api_invoker_certificate` varchar(255) DEFAULT NULL,

  `api_invoker_public_key` varchar(255) DEFAULT NULL,

  `notification_destination` varchar(255) DEFAULT NULL,

  `onboarding_secret` varchar(255) DEFAULT NULL,

  `request_test_notification` bit(1) DEFAULT NULL,

  `request_websocket_uri` bit(1) DEFAULT NULL,

  `websocket_uri` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`invoker_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

  

CREATE DATABASE IF NOT EXISTS `ocpm_nef_asqos`;

CREATE TABLE IF NOT EXISTS `ocpm_nef_asqos`.`app_session_id_to_sub_id` (

  `app_session_id` varchar(128) NOT NULL,

  `subsription_id` varchar(128) DEFAULT NULL,

  PRIMARY KEY (`app_session_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_asqos`.`as_qos_subscription` (

  `subscription_id` varchar(128) NOT NULL,

  `app_sessionuri` varchar(255) DEFAULT NULL,

  `as_qos_subscription` json DEFAULT NULL,

  `scs_as_id` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`subscription_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_asqos`.`scs_as_id_subscription` (

  `scs_as_id` varchar(128) NOT NULL,

  `sub_id_array` json DEFAULT NULL,

  PRIMARY KEY (`scs_as_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_asqos`.`asqos_charging` (

  `charging_id` varchar(128) NOT NULL,

  `charging_request_data` json DEFAULT NULL,

  PRIMARY KEY (`charging_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE DATABASE IF NOT EXISTS `ocpm_nef_ti`;

CREATE TABLE IF NOT EXISTS `ocpm_nef_ti`.`app_session_id_to_sub_id` (

  `app_session_id` varchar(128) NOT NULL,

  `subsription_id` varchar(128) DEFAULT NULL,

  PRIMARY KEY (`app_session_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_ti`.`tisubscription` (

  `subscription_id` varchar(128) NOT NULL,

  `app_sessionuri` varchar(255) DEFAULT NULL,

  `scs_as_id` varchar(255) DEFAULT NULL,

  `traffic_influ_sub` json DEFAULT NULL,

  PRIMARY KEY (`subscription_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_ti`.`scs_as_id_subscription` (

  `scs_as_id` varchar(128) NOT NULL,

  `sub_id_array` json DEFAULT NULL,

  PRIMARY KEY (`scs_as_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  

CREATE TABLE IF NOT EXISTS `ocpm_nef_ti`.`ti_charging` (

  `charging_id` varchar(128) NOT NULL,

  `charging_request_data` json DEFAULT NULL,

  PRIMARY KEY (`charging_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

CREATE DATABASE IF NOT EXISTS ocpm_nef_ti;

CREATE TABLE IF NOT EXISTS ocpm_nef_ti.ti_data(

scs_as_id varchar(255) NOT NULL,

subscription_id varchar(128) NOT NULL,

traffic_influ_sub json DEFAULT NULL,

af_trans_id varchar(128) UNIQUE,

af_notif_uri varchar(255) DEFAULT NULL,

influence_id varchar(128) NOT NULL UNIQUE,

supi varchar(128) DEFAULT NULL,

inter_group_id varchar(128) DEFAULT NULL,

PRIMARY KEY (subscription_id)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

CREATE DATABASE IF NOT EXISTS ocpm_nef_bdt;

CREATE TABLE IF NOT EXISTS ocpm_nef_bdt.nef_bdt

(

scs_as_id varchar(150) NOT NULL,

subscription_id varchar(128) NOT NULL,

bdt_reference_id varchar(255) NOT NULL,

subscription_expiry_ts TIMESTAMP NOT NULL,

bdt JSON NOT NULL,

resource_url varchar(255) NOT NULL,

notification_url varchar(255),

PRIMARY KEY (subscription_id)

)DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

 

CREATE DATABASE IF NOT EXISTS `ocpm_config_server_nef`;

 

CREATE TABLE IF NOT EXISTS `ocpm_config_server_nef`.`topic_info` (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'Default Topics.',

  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `modify_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `version` int(11) NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `UK_gd6b0a6mdpxc55qbibre2cldc` (`name`)

) AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

CREATE TABLE IF NOT EXISTS `ocpm_config_server_nef`.`configuration_item` (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `cfg_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `md5sum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `cfg_value` mediumtext COLLATE utf8_unicode_ci,

  `version` int(11) NOT NULL,

  `topic_info_id` bigint(20) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `FKdue8drxn6acrdt63iacireky1` (`topic_info_id`)

) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

 

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('policy', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('policySchema', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('policyElement', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('policyParam', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('policygui', 1);

 

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.global.cfg', 1);

 

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.smservice.cfg', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.public.sessionrule', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.public.sessionruleprofile', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.public.authorizeddefaultqos', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.public.pccrule', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.public.qosdata', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.public.chargingdata', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.public.pccruleprofile', 1);

 

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('amservice.system', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('public.matchlist', 1);

 

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pe.serviceTag', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pe.policyTag', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pe.logLevel', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.amservice.app', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('nrfclient.cfg', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('NRF.UDR', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('NRF.BSF', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.userservice.cfg', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('NRF.CHF', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.chfservice', 1);

insert into `ocpm_config_server_nef`.`topic_info` (name, version) values ('pcf.paservice.cfg', 1);