diff options
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) ); |