From 9764b6bb545a8edd4979c481627c38c1892f207e Mon Sep 17 00:00:00 2001
From: Niranjana <niranjana.y60@wipro.com>
Date: Mon, 22 Mar 2021 11:39:08 +0000
Subject: Update schema and format java files

Issue-ID: INT-1892
Signed-off-by: Niranjana <niranjana.y60@wipro.com>
Change-Id: Ib35c35cf7ac7a858311618e741c9327d7630aed6
---
 ransim/docker/config/db/ransim_schema.sql | 239 +++++++++++++++---------------
 1 file changed, 121 insertions(+), 118 deletions(-)

(limited to 'ransim/docker/config/db/ransim_schema.sql')

diff --git a/ransim/docker/config/db/ransim_schema.sql b/ransim/docker/config/db/ransim_schema.sql
index c329432..a155a8f 100644
--- a/ransim/docker/config/db/ransim_schema.sql
+++ b/ransim/docker/config/db/ransim_schema.sql
@@ -1,6 +1,6 @@
 CREATE USER 'uroot'@'%' IDENTIFIED BY 'psecret';
-CREATE SCHEMA IF NOT EXISTS `ransim_db` DEFAULT CHARACTER SET utf8 ;
-USE `ransim_db` ;
+CREATE SCHEMA IF NOT EXISTS `ransim_db` DEFAULT CHARACTER SET utf8;
+USE `ransim_db`;
 grant all privileges on ransim_db.* TO 'uroot'@'%' identified by 'psecret';
 flush privileges;
 drop table if exists nearrtric;
@@ -32,7 +32,7 @@ CREATE TABLE IF NOT EXISTS `ransim_db`.`cell`(
   `pci_value` bigint(20) NOT NULL,
   `pnf_id` varchar(255) NOT NULL,
   PRIMARY KEY (`cell_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE = InnoDB DEFAULT CHARSET = utf8;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`cell_nbr_info`
 -- -----------------------------------------------------
@@ -40,184 +40,186 @@ CREATE TABLE IF NOT EXISTS `ransim_db`.`cell_nbr_info`(
   `cell_id` varchar(45) NOT NULL,
   `target_cell_id` varchar(45) NOT NULL,
   `ho` bit(1) NOT NULL,
-  PRIMARY KEY (`cell_id`,`target_cell_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  PRIMARY KEY (`cell_id`, `target_cell_id`)
+) ENGINE = InnoDB DEFAULT CHARSET = utf8;
 -- Guilin - Slicing Usecase
 -- -----------------------------------------------------
 -- Table `ransim_db`.`nearrtric`
 -- -----------------------------------------------------
 create table nearrtric (
-       nearrtricid integer not null,
-        gnbid integer,
-        resourcetype varchar(255),
-        primary key (nearrtricid)
-    ) engine=InnoDB;
+  nearrtricid integer not null,
+  gnbid integer,
+  resourcetype varchar(255),
+  primary key (nearrtricid)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`trackingarea`
 -- -----------------------------------------------------
 create table trackingarea (
-       nearrtricid integer not null,
-        tracking_area varchar(255)
-    ) engine=InnoDB;
+  nearrtricid integer not null,
+  tracking_area varchar(255)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`rannfnssi`
 -- -----------------------------------------------------
- create table rannfnssi (
-       nearrtricid integer not null,
-        rannfnssilist varchar(255)
-    ) engine=InnoDB;
+create table rannfnssi (
+  nearrtricid integer not null,
+  rannfnssilist varchar(255)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`nssai`
 -- -----------------------------------------------------
 create table nssai (
-       rannfnssiid varchar(255) not null,
-        nssailist varchar(255)
-    ) engine=InnoDB;
+  rannfnssiid varchar(255) not null,
+  nssailist varchar(255)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`gnbcucpfunction`
 -- -----------------------------------------------------
 create table gnbcucpfunction (
-       gnbcuname varchar(255) not null,
-        gnbid integer,
-        gnbidlength integer,
-        nftype varchar(255),
-        plmnid varchar(255),
-        nearrtricid integer,
-        primary key (gnbcuname)
-    ) engine=InnoDB;
+  gnbcuname varchar(255) not null,
+  gnbid integer,
+  gnbidlength integer,
+  nftype varchar(255),
+  plmnid varchar(255),
+  nearrtricid integer,
+  primary key (gnbcuname)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`gnbcuupfunction`
 -- -----------------------------------------------------
 create table gnbcuupfunction (
-	   gnbcuupid integer not null,
-        gnbid integer,
-        gnbidlength integer,
-        resourcetype varchar(255),
-        nearrtricid integer,
-        primary key (gnbcuupid)
-    ) engine=InnoDB;
+  gnbcuupid integer not null,
+  gnbid integer,
+  gnbidlength integer,
+  resourcetype varchar(255),
+  nearrtricid integer,
+  primary key (gnbcuupid)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`gnbdufunction`
 -- -----------------------------------------------------
 create table gnbdufunction (
-       gnbduid integer not null,
-        gnbduname varchar(255),
-        gnbid integer,
-        gnbidlength integer,
-        nftype varchar(255),
-        plmnid varchar(255),
-        nearrtricid integer,
-        primary key (gnbduid)
-    ) engine=InnoDB;
+  gnbduid integer not null,
+  gnbduname varchar(255),
+  gnbid integer,
+  gnbidlength integer,
+  nftype varchar(255),
+  plmnid varchar(255),
+  nearrtricid integer,
+  primary key (gnbduid)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`nrcellcu`
 -- -----------------------------------------------------
 create table nrcellcu (
-       celllocalid integer not null,
-        gnbcuname varchar(255),
-	   resourcetype varchar(255),
-        primary key (celllocalid)
-    ) engine=InnoDB;
+  celllocalid integer not null,
+  gnbcuname varchar(255),
+  resourcetype varchar(255),
+  primary key (celllocalid)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`nrcelldu`
 -- -----------------------------------------------------
 create table nrcelldu (
-       celllocalid integer not null,
-        administrativestate varchar(255),
-        resourcetype varchar(255),
-        cellstate varchar(255),
-        nrpci integer,
-        nrtac integer,
-        operationalstate varchar(255),
-        gnbduid integer,
-        primary key (celllocalid)
-    ) engine=InnoDB;
+  celllocalid integer not null,
+  administrativestate varchar(255),
+  resourcetype varchar(255),
+  cellstate varchar(255),
+  nrpci integer,
+  nrtac integer,
+  operationalstate varchar(255),
+  gnbduid integer,
+  prb integer,
+  primary key (celllocalid)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`raninventory`
 -- -----------------------------------------------------
 create table raninventory (
-       rannfnssiid varchar(255) not null,
-        isshareable varchar(255),
-        nsstid varchar(255),
-        slicetype varchar(255),
-        subnetstatus varchar(255),
-	   talist varchar(500),
-        primary key (rannfnssiid)
-    ) engine=InnoDB;
+  rannfnssiid varchar(255) not null,
+  isshareable varchar(255),
+  nsstid varchar(255),
+  slicetype varchar(255),
+  subnetstatus varchar(255),
+  talist varchar(500),
+  primary key (rannfnssiid)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`rannssi`
 -- -----------------------------------------------------
 create table rannssi (
-       rannfnssiid varchar(255) not null,
-       rannssilist varchar(255)
-    ) engine=InnoDB;
+  rannfnssiid varchar(255) not null,
+  rannssilist varchar(255)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`rrmpolicyratio`
 -- -----------------------------------------------------
 create table rrmpolicyratio (
-       rrmpolicyid integer not null,
-        quotatype varchar(255),
-        rrmpolicydedicatedratio integer,
-        rrmpolicymaxratio integer,
-        rrmpolicyminratio integer,
-        resourceid varchar(255),
-        resourcetype varchar(255),
-        slicetype varchar(255),
-        primary key (rrmpolicyid)
-    ) engine=InnoDB;
+  rrmpolicyid integer not null,
+  quotatype varchar(255),
+  rrmpolicydedicatedratio integer,
+  rrmpolicymaxratio integer,
+  rrmpolicyminratio integer,
+  resourceid varchar(255),
+  resourcetype varchar(255),
+  slicetype varchar(255),
+  primary key (rrmpolicyid)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`rrmpolicymember`
 -- -----------------------------------------------------
 create table rrmpolicymember (
-       plmnid varchar(255) not null,
-        snssai varchar(255) not null,
-        rrm_policy_rrmpolicyid integer,
-        primary key (plmnid, snssai)
-    ) engine=InnoDB;
+  plmnid varchar(255) not null,
+  snssai varchar(255) not null,
+  rrm_policy_rrmpolicyid integer,
+  primary key (plmnid, snssai)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`tacells`
 -- -----------------------------------------------------
 create table tacells (
-       trackingarea varchar(255) not null,
-        cells varchar(255),
-        primary key (trackingarea)
-    ) engine=InnoDB;
+  trackingarea varchar(255) not null,
+  cells varchar(255),
+  primary key (trackingarea)
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`plmninfo`
 -- -----------------------------------------------------
 create table plmninfo (
-       plmnid varchar(255) not null,
-        globalSubscriberId varchar(255),
-        snssai varchar(255),
-        status varchar(255),
-        subscriptionServiceType varchar(255),
-        gnbcuupid integer,
-        nrcellcu_celllocalid integer,
-        nrcelldu_celllocalid integer,
-        nearrtricid integer,
-           uLThptPerSlice integer,
-           dLThptPerSlice integer,
-           maxNumberOfConns integer,
-        lastUpdatedTS TIMESTAMP DEFAULT CURRENT_TIMESTAMP()
-    ) engine=InnoDB;
+  plmnid varchar(255) not null,
+  globalSubscriberId varchar(255),
+  snssai varchar(255),
+  status varchar(255),
+  subscriptionServiceType varchar(255),
+  gnbcuupid integer,
+  nrcellcu_celllocalid integer,
+  nrcelldu_celllocalid integer,
+  nearrtricid integer,
+  uLThptPerSlice integer,
+  dLThptPerSlice integer,
+  maxNumberOfConns integer,
+  lastUpdatedTS TIMESTAMP DEFAULT CURRENT_TIMESTAMP()
+) engine = InnoDB;
 -- -----------------------------------------------------
 -- Table `ransim_db`.`sliceprofile`
 -- -----------------------------------------------------
 create table sliceprofile (
-       sliceprofileid varchar(255) not null,
-        coveragearealist varchar(255),
-        ulthptperslice  integer,
-        dlthptperslice integer,
-        latency integer,
-        maxnumberofconns integer,
-        maxnoofues integer,
-        plmnidlist varchar(255),
-        resourcesharinglevel varchar(255),
-        snssai varchar(255),
-        uemobilitylevel varchar(255),
-        rannfnssiid varchar(255),
-        primary key (sliceprofileid)
-    ) engine=InnoDB;
+  sliceprofileid varchar(255) not null,
+  coveragearealist varchar(255),
+  ulthptperslice integer,
+  dlthptperslice integer,
+  latency integer,
+  maxnumberofconns integer,
+  maxnoofues integer,
+  plmnidlist varchar(255),
+  resourcesharinglevel varchar(255),
+  snssai varchar(255),
+  uemobilitylevel varchar(255),
+  rannfnssiid varchar(255),
+  primary key (sliceprofileid)
+) engine = InnoDB;
+
 -- -----------------------------------------------------
 --Pre-loaded data
 -- -----------------------------------------------------
@@ -273,7 +275,7 @@ INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15426,'RRC Conne
 
 INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(13999,'RRC Connected Users','cucpserver1');
 
-INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(14000,'RRC Connected Users','cucpserver1'); 
+INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(14000,'RRC Connected Users','cucpserver1');
 
 INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(11561,'RRC Connected Users','cucpserver2');
 
@@ -366,3 +368,4 @@ INSERT INTO nrcelldu(celllocalId,resourcetype,administrativestate,cellstate, nrp
 INSERT INTO nrcelldu(celllocalId,resourcetype,administrativestate,cellstate, nrpci, nrtac, operationalstate,gnbduid) VALUES(15549,'PRB','UNLOCKED','ACTIVE',12,310,'ENABLED',6);
 
 INSERT INTO nrcelldu(celllocalId,resourcetype,administrativestate,cellstate, nrpci, nrtac, operationalstate,gnbduid) VALUES(14427,'PRB','UNLOCKED','ACTIVE',12,310,'ENABLED',6);
+
-- 
cgit 1.2.3-korg

