Creating Database Account on MySQL Database

Create a new database account on MySQL database by executing following command:

 
CREATE USER 'bsfusr'@'%' IDENTIFIED BY 'bsfpasswd';
GRANT ALL PRIVILEGES ON *.* TO 'bsfusr'@'%';

Login to MySQL console as a new user created above:

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

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

mysql -h<MYSQL_HOST> -ubsfusr -pbsfpasswd

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_bsf`;
CREATE TABLE IF NOT EXISTS ocpm_bsf.pcf_binding (
  binding_id binary(16) not null,
  ipv4_addr varchar(64),
  ip_domain varchar(128),
  ipv6_prefix varchar(64),
  mac_addr_48 varchar(64),
  dnn varchar(128),
  supi varchar(64),
  gpsi varchar(64),
  snssai_sd varchar(64),
  snssai_sst integer,
  created_date_time datetime(6) not null,
  json_content longblob not null,
  primary key (binding_id),
  key idx_created_date_time (created_date_time),
  key idx_ipv4Addr (ipv4_addr, created_date_time),
  key idx_ipv6Prefix (ipv6_prefix, created_date_time),
  key idx_macAddr48 (mac_addr_48, created_date_time),
  key idx_supi (supi, created_date_time),
  key idx_gpsi (gpsi, created_date_time)
);