summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql
blob: f0a228dfd4e2b4a4a477cc2749f3c2f8ea0259b7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
use ecomp_sdk;

SET FOREIGN_KEY_CHECKS=0;

UPDATE fn_menu 
SET ACTION='admin#/role_function_list'
WHERE LABEL='Role Functions';


UPDATE fn_menu 
SET ACTION='admin#/usage_list'
WHERE LABEL='Usage';


UPDATE fn_menu 
SET ACTION='admin#/admin'
WHERE LABEL='Roles';

UPDATE fn_menu 
SET ACTION='admin#/jcs_admin'
WHERE LABEL='Cache Admin';

UPDATE fn_menu 
SET ACTION='admin#/admin_menu_edit'
WHERE LABEL='Menus';

delete FROM fn_restricted_url WHERE RESTRICTED_URL='V2';

commit;