From be9a20159f1c9d35923b35503e94d1ae93101035 Mon Sep 17 00:00:00 2001 From: Murali Date: Fri, 8 Sep 2017 09:20:25 +0000 Subject: Support postgresql database Change-Id: I7fc413f3f1195eaa6b79e9f977706df10b79051e Jira:VNFSDK-77 Signed-off-by: Murali --- .../release/init/marketplace_tables_postgres.sql | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_postgres.sql (limited to 'vnfmarket-be/deployment/zip') 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 +); -- cgit 1.2.3-korg