From a70761c096192e38800bf38d6c7f61f52bf72007 Mon Sep 17 00:00:00 2001
From: hb123f <hbindu@research.att.com>
Date: Wed, 20 Mar 2019 12:20:44 -0400
Subject: CADI AAF Integration and merging the code

Issue-ID: PORTAL-319

CADI AAF Integration and code merge

Change-Id: I6e44f3b2741858d8d403b77a49ec9a0153084801
Signed-off-by: hb123f <hbindu@research.att.com>
---
 ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql')

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)
 );
-- 
cgit 1.2.3-korg

