summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--vnfmarket-be/deployment/docker/docker-postgres/src/main/docker/marketplace_tables_postgres.sql3
-rw-r--r--vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_mysql.sql3
-rw-r--r--vnfmarket-be/deployment/zip/src/main/release/init/marketplace_tables_postgres.sql3
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)
);