From 4df89dfce2ef6ad2a0d28e8750822c594529ae25 Mon Sep 17 00:00:00 2001
From: niranjana <niranjana.y60@wipro.com>
Date: Thu, 20 Feb 2020 15:14:34 +0530
Subject: Implement adaptive SON functionality

Issue-ID: DCAEGEN2-2023
Signed-off-by: niranjana <niranjana.y60@wipro.com>
Change-Id: I419b04f669f0b021396a4b04f11139eb4918de09
---
 src/main/resources/schema.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'src/main/resources/schema.sql')

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
+);
-- 
cgit 1.2.3-korg

