diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql')
-rw-r--r-- | ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql new file mode 100644 index 00000000..a378d506 --- /dev/null +++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql @@ -0,0 +1,21 @@ +use ecomp_sdk; + +alter table fn_menu +add index fn_menu_function_cd (function_cd ASC); +alter table fn_menu +add constraint fk_fn_menu_ref_223_fn_funct +foreign key (function_cd) +references fn_function (function_cd); + +alter table fn_restricted_url +add index fk_restricted_url_function_cd (function_cd ASC); +alter table fn_restricted_url +add constraint fk_restricted_url_function_cd +foreign key (function_cd) +references fn_function (function_cd); + + +alter table fn_role +modify role_name varchar(50) NOT NULL; + +commit;
\ No newline at end of file |