diff options
| author |   Christopher Lott (cl778h) <clott@research.att.com> | 2017-08-24 14:34:31 -0400 |
|---|---|---|
| committer | Christopher Lott (cl778h) <clott@research.att.com> | 2017-08-24 15:01:27 -0400 |
| commit | f57e82d8c734e59977c39bc6a0139174cb7f0649 (patch) | |
| tree | a13cad24453a699a572ee8381da6de95b1ca428a /ecomp-portal-DB-common | |
| parent | 978dbcf0a196acbafad72fe1e2478ec0e384f02f (diff) | |
Repair DDL duplicate-index name issue
This blocked the portal-db container from starting, which blocked
the app servers from starting.
Issue: PORTAL-80
Change-Id: I4c0b6b378bda29355111b137cae32c8f219d9921
Signed-off-by: Christopher Lott (cl778h) <clott@research.att.com>
Diffstat (limited to 'ecomp-portal-DB-common')
| -rw-r--r-- | ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql | 3 |
1 files changed, 0 insertions, 3 deletions
diff --git a/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql b/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql index f4d3c85f..99cbdfa1 100644 --- a/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql +++ b/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql @@ -1302,9 +1302,6 @@ CREATE TABLE `ep_app_role_function` ( `function_cd` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `UNIQUE KEY` (`app_id`, `role_id`, `function_cd`), -INDEX `fk_ep_app_role_function_role_id` (`role_id`), -INDEX `fk_ep_app_role_function_app_id` (`app_id`), -INDEX `fk_ep_app_role_function_ep_app_func` (`function_cd`,`app_id`), CONSTRAINT `fk_ep_app_role_function_app_id` FOREIGN KEY (`app_id`) REFERENCES `fn_app` (`app_id`), CONSTRAINT `fk_ep_app_role_function_ep_app_func` FOREIGN KEY (`app_id`, `function_cd`) REFERENCES `ep_app_function` (`app_id`, `function_cd`), CONSTRAINT `fk_ep_app_role_function_role_id` FOREIGN KEY (`role_id`) REFERENCES `fn_role` (`role_id`) |