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
+);