summaryrefslogtreecommitdiffstats
path: root/kubernetes/vnfsdk/resources/config
diff options
context:
space:
mode:
authorjasmineWen <jasmine.wen@amdocs.com>2018-08-29 15:55:28 +0000
committerjasmineWen <jasmine.wen@amdocs.com>2018-09-14 17:49:13 +0000
commitfb56f0f4bf91c10fc2e898993c70c49613b67bcc (patch)
treec459ca605dd588d46f4700b609bb4a95a9f57bd8 /kubernetes/vnfsdk/resources/config
parent48e8fe5f53f34428e4dffe7b4760586d7e48c8cd (diff)
Upgrade VNFSDK to use common Postgres charts
Issue-ID: OOM-1185 Change-Id: Ie011e87bc9322149076ec62cab3a8b3315e1d817 Signed-off-by: jasmineWen <jasmine.wen@amdocs.com>
Diffstat (limited to 'kubernetes/vnfsdk/resources/config')
-rw-r--r--kubernetes/vnfsdk/resources/config/marketplace_tables_postgres.sql25
1 files changed, 25 insertions, 0 deletions
diff --git a/kubernetes/vnfsdk/resources/config/marketplace_tables_postgres.sql b/kubernetes/vnfsdk/resources/config/marketplace_tables_postgres.sql
new file mode 100644
index 0000000000..c05d7f2d00
--- /dev/null
+++ b/kubernetes/vnfsdk/resources/config/marketplace_tables_postgres.sql
@@ -0,0 +1,25 @@
+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,
+ CONSTRAINT csar_package_table_pkey PRIMARY KEY (CSARID)
+);