X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FPortalDDLMySql_2_1_Common.sql;h=6cb26434534db6f395bcbb4498056efe443902bb;hb=1c3cc6fb0e4d2f4f2278240ff0387596c776b9c9;hp=5c9e9b58dc724dadca69628ec2023d5897b430d8;hpb=11b79e5093d8e7fa45b0ce4eceda0b56c27f13fa;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 5c9e9b58..6cb26434 100644 --- 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; @@ -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;