diff options
| author |   hb123f <hbindu@research.att.com> | 2019-03-20 12:20:44 -0400 |
|---|---|---|
| committer | hb123f <hbindu@research.att.com> | 2019-03-20 14:13:55 -0400 |
| commit | a70761c096192e38800bf38d6c7f61f52bf72007 (patch) | |
| tree | cdc5264cec030bc7e677ff1d74c939c56ee51d0d /ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | |
| parent | 3992004ee5f2b0b1635e2aef19c375db87079b52 (diff) | |
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>
Diffstat (limited to 'ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql')
| -rw-r--r-- | ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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) ); |