summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorisaacgl <isaacg@amdocs.com>2017-12-31 12:02:23 +0200
committerMurali Mohan Murthy Potham <murali.p@huawei.com>2018-01-30 12:47:33 +0000
commit78f52545d56ff50d5e6d7b07b2db289a43d44a32 (patch)
tree21fad06c9035521670820dfc443bf64c3ba9500c
parent60c8d061a529a82db167429053436757223a450d (diff)
missing pk
Issue-ID: VNFSDK-140 Change-Id: I76ed0b0546e6326efa67d2c4b5b8a8e4c0018946 Signed-off-by: isaacgl <isaacg@amdocs.com>
-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)
);