Code Review
/
portal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
MariaDB Connector and Sonar Scans; clean nl
[portal.git]
/
ecomp-portal-DB-common
/
EcompPortalDDLMySql_1710_Common.sql
diff --git
a/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql
b/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql
index
99cbdfa
..
1ff699f
100644
(file)
--- 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,
CREATE TABLE ep_app_function (
app_id INT(11) NOT NULL,
-function_cd VARCHAR(50) NOT NULL,
+function_cd VARCHAR(
2
50) NOT NULL,
function_name VARCHAR(50) NOT NULL,
PRIMARY KEY (function_cd, app_id),
INDEX fk_ep_app_function_app_id (app_id),
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,
`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(
2
50) 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`),
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`),