aboutsummaryrefslogtreecommitdiffstats
path: root/src/main/resources/schema.sql
diff options
context:
space:
mode:
authorniranjana <niranjana.y60@wipro.com>2020-02-20 15:14:34 +0530
committerniranjana <niranjana.y60@wipro.com>2020-02-20 17:52:48 +0530
commit4df89dfce2ef6ad2a0d28e8750822c594529ae25 (patch)
treeddb160ae43b5d1bc5e1a3174a64026c227477a50 /src/main/resources/schema.sql
parent8e924858d792abf90c689d65ec89daa67ed72298 (diff)
Implement adaptive SON functionality
Issue-ID: DCAEGEN2-2023 Signed-off-by: niranjana <niranjana.y60@wipro.com> Change-Id: I419b04f669f0b021396a4b04f11139eb4918de09
Diffstat (limited to 'src/main/resources/schema.sql')
-rw-r--r--src/main/resources/schema.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 72cdbcf..5d23f81 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -33,3 +33,14 @@ CREATE TABLE HANDOVER_METRICS(
ho_details TEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
+CREATE TABLE PCI_UPDATE(
+ cell_id TEXT PRIMARY KEY NOT NULL,
+ old_pci BIGINT NOT NULL,
+ new_pci BIGINT,
+ negative_ack_count INT DEFAULT 0
+);
+CREATE TABLE FIXED_PCI_CELLS(
+ cell_id TEXT PRIMARY KEY NOT NULL,
+ fixed_pci BIGINT NOT NULL,
+ created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+);