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;
|