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'@'%';

Login to MySQL console as a new user created above:

mysql -h<MYSQL_HOST> -u<USERNAME> -p<PASSWORD>

Execute the below script to initial Network Exposure Function databases. At first login to MySQL console via new user created above,

mysql -h<MYSQL_HOST> -unefusr -pnefpasswd

CREATE DATABASE IF NOT EXISTS `ocpm_config_server`;
 
 
CREATE TABLE IF NOT EXISTS `ocpm_config_server`.`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`.`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`.`topic_info` (name, version) values ('policy', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('policySchema', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('policyElement', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('policyParam', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('policygui', 1);
 
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.global.cfg', 1);
 
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.smservice.cfg', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.public.sessionrule', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.public.sessionruleprofile', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.public.authorizeddefaultqos', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.public.pccrule', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.public.qosdata', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.public.chargingdata', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.public.pccruleprofile', 1);
 
insert into `ocpm_config_server`.`topic_info` (name, version) values ('amservice.system', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('public.matchlist', 1);
 
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pe.serviceTag', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pe.policyTag', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pe.logLevel', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.amservice.app', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('nrfclient.cfg', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('NRF.UDR', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('NRF.BSF', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.userservice.cfg', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('NRF.CHF', 1);
insert into `ocpm_config_server`.`topic_info` (name, version) values ('pcf.chfservice', 1);
 
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 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,
  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;