aboutsummaryrefslogtreecommitdiffstats
path: root/ransim/docker/config
diff options
context:
space:
mode:
authoryashwanth <gandhapu.yashwanth@wipro.com>2021-04-25 23:42:58 -0700
committeryashwanth <gandhapu.yashwanth@wipro.com>2021-04-26 21:32:50 -0700
commit959c9cf80775c4b1e5d78f299a441ce9fe9bd9d3 (patch)
tree707d64d01adaac8e0c38cd7de60fdf8fe605ae38 /ransim/docker/config
parentbe0bc4456438b1be97105fec3f85f79a66403558 (diff)
TrackingArea Type change
Issue-ID: INT-1913 Signed-off-by: yashwanth <gandhapu.yashwanth@wipro.com> Change-Id: Iba23a9dcee04a1c8604f88e7cc3bae795a9410ff
Diffstat (limited to 'ransim/docker/config')
-rw-r--r--ransim/docker/config/db/ransim_schema.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/ransim/docker/config/db/ransim_schema.sql b/ransim/docker/config/db/ransim_schema.sql
index a155a8f..7b129fe 100644
--- a/ransim/docker/config/db/ransim_schema.sql
+++ b/ransim/docker/config/db/ransim_schema.sql
@@ -57,7 +57,7 @@ create table nearrtric (
-- -----------------------------------------------------
create table trackingarea (
nearrtricid integer not null,
- tracking_area varchar(255)
+ tracking_area integer
) engine = InnoDB;
-- -----------------------------------------------------
-- Table `ransim_db`.`rannfnssi`
@@ -179,7 +179,7 @@ create table rrmpolicymember (
-- Table `ransim_db`.`tacells`
-- -----------------------------------------------------
create table tacells (
- trackingarea varchar(255) not null,
+ trackingarea integer not null,
cells varchar(255),
primary key (trackingarea)
) engine = InnoDB;
@@ -225,10 +225,10 @@ create table sliceprofile (
-- -----------------------------------------------------
-- tacells
-INSERT INTO tacells(trackingarea,cells) VALUES('TA1', '15289,15290,15296,15687,15689,15155,15174,15175');
-INSERT INTO tacells(trackingarea,cells) VALUES('TA2', '15176,15825,15826,15425,15426,13999,14000');
-INSERT INTO tacells(trackingarea,cells) VALUES('TA3', '11561,11562,11568,11569,10896,10897,14655,14656');
-INSERT INTO tacells(trackingarea,cells) VALUES('TA4', '13905,13910,15360,15361,15548,15549,14427');
+INSERT INTO tacells(trackingarea,cells) VALUES(101, '15289,15290,15296,15687,15689,15155,15174,15175');
+INSERT INTO tacells(trackingarea,cells) VALUES(202, '15176,15825,15826,15425,15426,13999,14000');
+INSERT INTO tacells(trackingarea,cells) VALUES(303, '11561,11562,11568,11569,10896,10897,14655,14656');
+INSERT INTO tacells(trackingarea,cells) VALUES(404, '13905,13910,15360,15361,15548,15549,14427');
--nearrtric
INSERT INTO nearrtric (nearrtricid, gnbid, resourcetype) VALUES(11, 98763, 'NearRTRIC');