dev/2020/2020-017(OK)/2020-017-ljy-002.sql

/*为权限生成layercode*/
SELECT
	CONCAT(
	"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 ",
	APPLICATION_ID,
	",'",
	PRIVILEGE_KEY,
	"','",
	PRIVILEGE_NAME,
	"','",
	PRIVILEGE_TYPE_DICT,
	"','1',now(),'1',now(),",
	PRIVILEGE_DISPLAY_ORDER,
	",(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION'),'",
	PRIVILEGE_ICON,
	"','",
	PRIVILEGE_URL,
	"','",
	PRIVILEGE_STATUS,
	"' FROM DUAL);"
) AS psql
FROM
	auth_privilege
WHERE
	application_id = 2
	AND privilege_key = 'ITIM.COOPERATION.SHARE.STUDYRESULT'
ORDER BY
	privilege_layer_code;

SELECT
	CONCAT(
	"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 ",
	APPLICATION_ID,
	",'",
	PRIVILEGE_KEY,
	"','",
	PRIVILEGE_NAME,
	"','",
	PRIVILEGE_TYPE_DICT,
	"','1',now(),'1',now(),",
	PRIVILEGE_DISPLAY_ORDER,
	",(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION'),'",
	PRIVILEGE_ICON,
	"','",
	PRIVILEGE_URL,
	"','",
	PRIVILEGE_STATUS,
	"' FROM DUAL);"
) AS psql
FROM
	auth_privilege
WHERE
	application_id = 2
	AND privilege_key = 'ITIM.COOPERATION.SHARE.SURVEY'
ORDER BY
	privilege_layer_code;

-- 159,161已执行 2020/11/24