diff options
author | 2017-09-11 12:13:10 +0000 | |
---|---|---|
committer | 2017-09-11 12:13:10 +0000 | |
commit | 5ee588e9f10fc3806ea869d365cdfacad3929b70 (patch) | |
tree | 72b040fa2de9c56cd1bdae02033a7f9b8c32afc5 /vnfmarket-be/deployment/docker/docker-postgres/marketplace_tables_postgres.sql | |
parent | caf8a4b51fb6583189c9544112e245e7a01b8dca (diff) |
Move the dockers under same pom
Change-Id: I2acf544df7f2093b658e9a36eb94ac4a8a2da21e
Jira:VNFSDK-77
Signed-off-by: Murali <murali.p@huawei.com>
Diffstat (limited to 'vnfmarket-be/deployment/docker/docker-postgres/marketplace_tables_postgres.sql')
-rw-r--r-- | vnfmarket-be/deployment/docker/docker-postgres/marketplace_tables_postgres.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/vnfmarket-be/deployment/docker/docker-postgres/marketplace_tables_postgres.sql b/vnfmarket-be/deployment/docker/docker-postgres/marketplace_tables_postgres.sql new file mode 100644 index 00000000..edd66813 --- /dev/null +++ b/vnfmarket-be/deployment/docker/docker-postgres/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 +); |