summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_1707_to_1710_Common.sql
blob: 36c19658b0c5a1a8ad75777512e78387a416639c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
use ecomp_sdk;

SET FOREIGN_KEY_CHECKS=0;

alter table fn_menu 
drop foreign key fk_fn_menu_ref_223_fn_funct;
alter table fn_menu 
drop index fn_menu_function_cd;

alter table fn_restricted_url 
drop foreign key fk_restricted_url_function_cd;
alter table fn_restricted_url 
drop index fk_restricted_url_function_cd;

alter table fn_role
modify role_name varchar(300) NOT NULL;

commit;