summaryrefslogtreecommitdiffstats
path: root/ecd-app-common/db-scripts/README.md
diff options
context:
space:
mode:
Diffstat (limited to 'ecd-app-common/db-scripts/README.md')
-rw-r--r--ecd-app-common/db-scripts/README.md23
1 files changed, 23 insertions, 0 deletions
diff --git a/ecd-app-common/db-scripts/README.md b/ecd-app-common/db-scripts/README.md
new file mode 100644
index 0000000..474e438
--- /dev/null
+++ b/ecd-app-common/db-scripts/README.md
@@ -0,0 +1,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) \ No newline at end of file