summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_1710_to_1707_Common.sql
blob: a378d506bc3da6cca83e703848902a95cb2f637a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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;