dev/2021/待发布/SQL/2021-004-wzw-004.sql

use dcp;
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME, PRIVILEGE_DISPLAY_ORDER, PRIVILEGE_PARENT_ID, PRIVILEGE_ICON, PRIVILEGE_URL, PRIVILEGE_STATUS ) (
SELECT
	2,
	'ITIM.DEVELOPMENT.ENTERPRISEMAINTENANCE',
	'企业视图管理',
	'1',
	'1',
	now( ),
	'1',
	now( ),
	8,
	( SELECT max( PRIVILEGE_ID ) FROM auth_privilege WHERE PRIVILEGE_KEY = 'ITIM.DEVELOPMENT' ),
	'fa-dashboard',
	'',
	'0' 
FROM
DUAL 
	);
	



INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME, PRIVILEGE_DISPLAY_ORDER, PRIVILEGE_PARENT_ID, PRIVILEGE_ICON, PRIVILEGE_URL, PRIVILEGE_STATUS ) (
SELECT
	2,
	'ITIM.DEVELOPMENT.ENTERPRISEMAINTENANCE.LIST',
	'企业视图信息维护',
	'1',
	'1',
	now( ),
	'1',
	now( ),
	1,
	( SELECT max( PRIVILEGE_ID ) FROM auth_privilege WHERE PRIVILEGE_KEY = 'ITIM.DEVELOPMENT.ENTERPRISEMAINTENANCE' ),
	'fa-inbox',
	'BaseUnitInfoViewList',
	'0' 
FROM
DUAL 
	);
/*国别视图权限  161  159 已执行  2021.5.13*/