diff options
Diffstat (limited to 'src/main/resources/schema.sql')
| -rw-r--r-- | src/main/resources/schema.sql | 11 |
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 +); |