CADI AAF Integration and merging the code

[portal.git] / 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 5c9e9b5..3dabe92 100644 (file)
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -11,7 +11,7 @@
 -- -----------------------------------------------------------------------------------------------------------------
 set foreign_key_checks=1; 
 
-create database portal_os;
+create database portal;
 
 use portal;
 
@@ -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)
 );
@@ -1280,7 +1280,7 @@ create table  ep_endpoints_basic_auth_account (
 CREATE TABLE ep_app_function (
 app_id INT(11) NOT NULL,
 function_cd VARCHAR(250) NOT NULL,
-function_name VARCHAR(50) NOT NULL,
+function_name VARCHAR(250) NOT NULL,
 PRIMARY KEY (function_cd, app_id),
 INDEX fk_ep_app_function_app_id (app_id),
 CONSTRAINT fk_ep_app_function_app_id FOREIGN KEY (app_id) REFERENCES fn_app (app_id)
@@ -1755,4 +1755,4 @@ add constraint sys_c0014618 foreign key (user_id) references fn_user(user_id);
 alter table fn_menu_favorites
 add constraint sys_c0014619 foreign key (menu_id) references fn_menu_functional(menu_id);
 
-commit;
\ No newline at end of file
+commit;