X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;fp=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;h=3dabe92c2bb15ba19fbedafdc4bd40159af15b5a;hb=a70761c096192e38800bf38d6c7f61f52bf72007;hp=6cb26434534db6f395bcbb4498056efe443902bb;hpb=3992004ee5f2b0b1635e2aef19c375db87079b52;p=portal.git

diff --git a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
index 6cb26434..3dabe92c 100644
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -1124,7 +1124,7 @@ CREATE TABLE ep_microservice (
 	endpoint_url VARCHAR(200) NULL DEFAULT NULL,
 	security_type VARCHAR(50) NULL DEFAULT NULL,
 	username VARCHAR(50) NULL DEFAULT NULL,
-	password VARCHAR(50) NULL DEFAULT NULL,
+	password VARCHAR(50) NOT NULL,
 	active CHAR(1) NOT NULL DEFAULT 'Y',
 	PRIMARY KEY (id),
 	CONSTRAINT FK_FN_APP_EP_MICROSERVICE FOREIGN KEY (appId) REFERENCES fn_app (app_id)
@@ -1178,7 +1178,7 @@ create table ep_basic_auth_account (
 	id INT(11) NOT NULL AUTO_INCREMENT,
 	ext_app_name VARCHAR(50) NOT NULL,
 	username VARCHAR(50) NOT NULL,
-	password VARCHAR(50) NOT NULL,
+	password VARCHAR(50) null default null,
     active_yn char(1) NOT NULL default 'Y',
 	PRIMARY KEY (id)
 );