summaryrefslogtreecommitdiffstats
path: root/ecd-app-common/db-scripts/README.md
blob: 474e438d14110ccf7033c2f81ef6208092897558 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
# ECOMP-C Dashboard Database Scripts

This directory has a DDL to create tables and and DML scripts to populate tables
in Postgresql for the ECOMP-C Dashboard web application.

## Internal deployments

To create a database for internal use:
- Run the common DDL script
- Run the common DML script
- Run the internal-use-only DML script, which can be found in a different project

## Open-source deployments

To create a database for ONAP use:
- Run the common DDL script
- Run the common DML script

## Notes on Postgresql:

Set default schema for user:
	ALTER USER <the-user-name> SET search_path to <the-schema-name>;
	(the above statement is not needed for version 9.4 and above)