diff options
| author |   Murali <murali.p@huawei.com> | 2017-09-14 06:17:44 +0000 |
|---|---|---|
| committer | Murali <murali.p@huawei.com> | 2017-09-14 06:17:44 +0000 |
| commit | 5fe29a25ae58319013253c1871ad20adb1b83b46 (patch) | |
| tree | 662864dd6968a73b14809e0317f787a5c8b728ae /vnfmarket-be/deployment/docker/docker-postgres/src | |
| parent | fc4025185f90cf7088513e8ee72c17942604ab2e (diff) | |
Add profile to build postgres docker
Change-Id: I564d868a98a7518773ea9ac7331eeb2047818d78
Jira:VNFSDK-77
Signed-off-by: Murali <murali.p@huawei.com>
Diffstat (limited to 'vnfmarket-be/deployment/docker/docker-postgres/src')
| -rw-r--r-- | vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/Dockerfile | 13 | ||||
| -rw-r--r-- | vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql | 24 |
2 files changed, 37 insertions, 0 deletions
diff --git a/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/Dockerfile b/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/Dockerfile new file mode 100644 index 00000000..704d08c3 --- /dev/null +++ b/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/Dockerfile @@ -0,0 +1,13 @@ +# +# This file was auto-generated by gen-all-dockerfiles.sh; do not modify manually. +# +# vnf-sdk-marketplace/target/Dockerfile +# + +# 10-basebuild.txt + +FROM postgres:9.4 +ENV POSTGRES_USER postgres +ENV POSTGRES_PASSWORD postgres +ADD marketplace_tables_postgres.sql /docker-entrypoint-initdb.d + diff --git a/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql b/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql new file mode 100644 index 00000000..edd66813 --- /dev/null +++ b/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql @@ -0,0 +1,24 @@ +CREATE DATABASE "marketplaceDB"; + +\c marketplaceDB; + +DROP TABLE IF EXISTS CSAR_PACKAGE_TABLE; + +CREATE TABLE CSAR_PACKAGE_TABLE ( + CSARID VARCHAR(200) NOT NULL, + DOWNLOADURI VARCHAR(200) NULL, + REPORT VARCHAR(200) NULL, + SIZE VARCHAR(100) NULL, + FORMAT VARCHAR(100) NULL, + CREATETIME VARCHAR(100) NULL, + DELETIONPENDING VARCHAR(100) NULL, + MODIFYTIME VARCHAR(100) NULL, + SHORTDESC TEXT NULL, + NAME VARCHAR(100) NULL, + VERSION VARCHAR(20) NULL, + PROVIDER VARCHAR(300) NULL, + TYPE VARCHAR(300) NULL, + DETAILS TEXT NULL, + REMARKS TEXT NULL, + DOWNLOADCOUNT INT NULL +); |