Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
This page captures the original implementation of the original ConfigDB (PoC) as a preparation for introduction of the Configuration & Persistency Service (C&PS)
Resources
DB Details
The database used is MariaDb.
DB Schema
CREATE SCHEMA IF NOT EXISTS `onap_demo` DEFAULT CHARACTER SET utf8 ;
USE `onap_demo` ;
-- -----------------------------------------------------
-- Table `onap_demo`.`cell`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `onap_demo`.`cell`(
`cell_id` varchar(45) NOT NULL,
`last_modifiedts` datetime(6) NOT NULL,
`location` varchar(200) DEFAULT NULL,
`network_id` varchar(45) NOT NULL,
`notes` varchar(255) DEFAULT NULL,
`pci_value` bigint(20) NOT NULL,
`pnf_id` varchar(255) NOT NULL,
PRIMARY KEY (`cell_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- -----------------------------------------------------
-- Table `onap_demo`.`cell_nbr_info`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `onap_demo`.`cell_nbr_info`(
`cell_id` varchar(45) NOT NULL,
`target_cell_id` varchar(45) NOT NULL,
`ho` bit(1) NOT NULL,
PRIMARY KEY (`cell_id`,`target_cell_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
