summaryrefslogtreecommitdiffstats
path: root/vnfmarket-be/deployment/zip/src
diff options
context:
space:
mode:
authorMurali <murali.p@huawei.com>2017-09-08 09:20:25 +0000
committerMurali <murali.p@huawei.com>2017-09-08 09:20:25 +0000
commitbe9a20159f1c9d35923b35503e94d1ae93101035 (patch)
treef32482bff55649110ec1df5a09676f0ba7ed04c7 /vnfmarket-be/deployment/zip/src
parenta3428bbc9d8b4547e94a9455211e7fbda529d4f5 (diff)
Support postgresql database
Change-Id: I7fc413f3f1195eaa6b79e9f977706df10b79051e Jira:VNFSDK-77 Signed-off-by: Murali <murali.p@huawei.com>
Diffstat (limited to 'vnfmarket-be/deployment/zip/src')
-rw-r--r--vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_postgres.sql24
1 files changed, 24 insertions, 0 deletions
diff --git a/vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_postgres.sql b/vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_postgres.sql
new file mode 100644
index 00000000..edd66813
--- /dev/null
+++ b/vnfmarket-be/deployment/zip/src/main/release/init/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
+);