diff options
author | Borislav Glozman <Borislav.Glozman@amdocs.com> | 2018-09-16 13:19:41 +0000 |
---|---|---|
committer | Gerrit Code Review <gerrit@onap.org> | 2018-09-16 13:19:41 +0000 |
commit | b350b9446f7ca93686b6405b13b35c49e1035698 (patch) | |
tree | b38a721d24028d96a5d0dfdea4d42bcd18fa8a58 /kubernetes/vnfsdk/resources/config/marketplace_tables_postgres.sql | |
parent | 95f819a35f8ca316647b4a8341a589985f3c21d8 (diff) | |
parent | fb56f0f4bf91c10fc2e898993c70c49613b67bcc (diff) |
Merge "Upgrade VNFSDK to use common Postgres charts"
Diffstat (limited to 'kubernetes/vnfsdk/resources/config/marketplace_tables_postgres.sql')
-rw-r--r-- | kubernetes/vnfsdk/resources/config/marketplace_tables_postgres.sql | 25 |
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) +); |