diff options
3 files changed, 6 insertions, 3 deletions
diff --git a/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql b/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql index edd66813..f654efd3 100644 --- a/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql +++ b/vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql @@ -20,5 +20,6 @@ CREATE TABLE CSAR_PACKAGE_TABLE ( TYPE VARCHAR(300) NULL, DETAILS TEXT NULL, REMARKS TEXT NULL, - DOWNLOADCOUNT INT NULL + DOWNLOADCOUNT INT NULL, + CONSTRAINT csar_package_table_pkey PRIMARY KEY (CSARID) ); diff --git a/vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_mysql.sql b/vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_mysql.sql index 6255256d..7b84b18c 100644 --- a/vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_mysql.sql +++ b/vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_mysql.sql @@ -20,5 +20,6 @@ CREATE TABLE CSAR_PACKAGE_TABLE ( TYPE VARCHAR(300) NULL, DETAILS TEXT NULL, REMARKS TEXT NULL, - DOWNLOADCOUNT INT NULL + DOWNLOADCOUNT INT NULL, + CONSTRAINT csar_package_table_pkey PRIMARY KEY (CSARID) ); 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 index edd66813..f654efd3 100644 --- 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 @@ -20,5 +20,6 @@ CREATE TABLE CSAR_PACKAGE_TABLE ( TYPE VARCHAR(300) NULL, DETAILS TEXT NULL, REMARKS TEXT NULL, - DOWNLOADCOUNT INT NULL + DOWNLOADCOUNT INT NULL, + CONSTRAINT csar_package_table_pkey PRIMARY KEY (CSARID) ); |