X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-common%2FEcompPortalDDLMySql_1710_Common.sql;h=1ff699f49c52e50562a7d841a44275f1c227acde;hb=23634dba70b166ad3c79b5eadfbd32b5375d44be;hp=99cbdfa12b40a210c85218c5896bad072f5fa0e3;hpb=4ba6a0f20a190030700917a6065a6779ca9d308f;p=portal.git diff --git a/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql b/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql index 99cbdfa1..1ff699f4 100644 --- a/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql +++ b/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql @@ -1284,7 +1284,7 @@ create table ep_endpoints_basic_auth_account ( CREATE TABLE ep_app_function ( app_id INT(11) NOT NULL, -function_cd VARCHAR(50) NOT NULL, +function_cd VARCHAR(250) NOT NULL, function_name VARCHAR(50) NOT NULL, PRIMARY KEY (function_cd, app_id), INDEX fk_ep_app_function_app_id (app_id), @@ -1299,7 +1299,7 @@ CREATE TABLE `ep_app_role_function` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `app_id` INT(11) NOT NULL, `role_id` INT(11) NOT NULL, -`function_cd` VARCHAR(50) NOT NULL, +`function_cd` VARCHAR(250) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `UNIQUE KEY` (`app_id`, `role_id`, `function_cd`), CONSTRAINT `fk_ep_app_role_function_app_id` FOREIGN KEY (`app_id`) REFERENCES `fn_app` (`app_id`),