From 9764b6bb545a8edd4979c481627c38c1892f207e Mon Sep 17 00:00:00 2001 From: Niranjana Date: Mon, 22 Mar 2021 11:39:08 +0000 Subject: Update schema and format java files Issue-ID: INT-1892 Signed-off-by: Niranjana 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