diff options
author | yashwanth <gandhapu.yashwanth@wipro.com> | 2021-04-25 23:42:58 -0700 |
---|---|---|
committer | Morgan Richomme <morgan.richomme@orange.com> | 2021-04-27 14:23:04 +0000 |
commit | e6194765959c1c2152b0392b2bbbd81c83db3329 (patch) | |
tree | 8ef0c2f79bdd35a6201f1340258116b053f6d026 /ransim/docker/config/db/ransim_schema.sql | |
parent | 9764b6bb545a8edd4979c481627c38c1892f207e (diff) |
TrackingArea Type changehonolulu
Issue-ID: INT-1913
Signed-off-by: yashwanth <gandhapu.yashwanth@wipro.com>
Change-Id: Iba23a9dcee04a1c8604f88e7cc3bae795a9410ff
(cherry picked from commit 959c9cf80775c4b1e5d78f299a441ce9fe9bd9d3)
Diffstat (limited to 'ransim/docker/config/db/ransim_schema.sql')
-rw-r--r-- | ransim/docker/config/db/ransim_schema.sql | 12 |
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'); |