From 5fe29a25ae58319013253c1871ad20adb1b83b46 Mon Sep 17 00:00:00 2001
From: Murali <murali.p@huawei.com>
Date: Thu, 14 Sep 2017 06:17:44 +0000
Subject: Add profile to build postgres docker

Change-Id: I564d868a98a7518773ea9ac7331eeb2047818d78
Jira:VNFSDK-77
Signed-off-by: Murali <murali.p@huawei.com>
---
 .../docker-postgres/src/main/docker/Dockerfile     | 13 ++++++++++++
 .../main/docker/marketplace_tables_postgres.sql    | 24 ++++++++++++++++++++++
 2 files changed, 37 insertions(+)
 create mode 100644 vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/Dockerfile
 create mode 100644 vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql

(limited to 'vnfmarket-be/deployment/docker/docker-postgres/src')

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
+);
-- 
cgit