aboutsummaryrefslogtreecommitdiffstats
path: root/ransim/docker/config/db
diff options
context:
space:
mode:
Diffstat (limited to 'ransim/docker/config/db')
-rw-r--r--ransim/docker/config/db/ransim_schema.sql239
1 files changed, 121 insertions, 118 deletions
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);
+