superdesk_superservice/sql/huangxiaotian/权限模块/权限按钮数据插入.sql

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:system:role') a), (NOW()), '1', '1', '0', 'pc:system:role:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:system:role') a), (NOW()),  '1', '2', '0', 'pc:system:role:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:system:role') a), (NOW()),  '1', '3', '0', 'pc:system:role:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:project') a), (NOW()), '1', '1', '0', 'pc:organization:project:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:project') a), (NOW()), '1', '2', '0', 'pc:organization:project:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:project') a), (NOW()), '1', '3', '0', 'pc:organization:project:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('审核', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:project') a), (NOW()), '1', '4', '0', 'pc:organization:project:approve');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:build') a), (NOW()), '1', '1', '0', 'pc:organization:build:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:build') a), (NOW()), '1', '2', '0', 'pc:organization:build:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:build') a), (NOW()), '1','3', '0', 'pc:organization:build:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('审核', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:build') a), (NOW()), '1', '4', '0', 'pc:organization:build:approve');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:company') a), (NOW()), '1', '1', '0', 'pc:organization:company:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:company') a), (NOW()), '1', '2', '0', 'pc:organization:company:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:company') a), (NOW()), '1', '3', '0', 'pc:organization:company:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:dept') a), (NOW()), '1', '1', '0', 'pc:organization:dept:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:dept') a), (NOW()), '1', '2', '0', 'pc:organization:dept:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:dept') a), (NOW()), '1', '3', '0', 'pc:organization:dept:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:enterprise-data') a), (NOW()), '1', '1', '0', 'pc:organization:enterprise-data:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:enterprise-data') a), (NOW()), '1', '2', '0', 'pc:organization:enterprise-data:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:enterprise-data') a), (NOW()), '1', '3', '0', 'pc:organization:enterprise-data:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:floor') a), (NOW()), '1', '1', '0', 'pc:organization:floor:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:floor') a), (NOW()), '1', '2', '0', 'pc:organization:floor:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:floor') a), (NOW()), '1', '3', '0', 'pc:organization:floor:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:enterprise') a), (NOW()), '1', '1', '0', 'pc:organization:enterprise:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:enterprise') a), (NOW()), '1', '2', '0', 'pc:organization:enterprise:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:enterprise') a), (NOW()), '1', '3', '0', 'pc:organization:enterprise:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:organization:enterprise-account') a), (NOW()), '1', '2', '0', 'pc:organization:enterprise-account:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:wechat') a), (NOW()), '1', '1', '0', 'pc:setting:wechat:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:wechat') a), (NOW()), '1', '2', '0', 'pc:setting:wechat:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:wechat') a), (NOW()), '1', '3', '0', 'pc:setting:wechat:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:service') a), (NOW()), '1', '1', '0', 'pc:setting:service:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:service') a), (NOW()), '1', '2', '0', 'pc:setting:service:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:service') a), (NOW()), '1', '3', '0', 'pc:setting:service:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:project') a), (NOW()), '1', '1', '0', 'pc:setting:project:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:project') a), (NOW()), '1', '2', '0', 'pc:setting:project:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:setting:project') a), (NOW()), '1', '3', '0', 'pc:setting:project:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:dictionary') a), (NOW()), '1', '1', '0', 'pc:basics:dictionary:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:dictionary') a), (NOW()), '1', '2', '0', 'pc:basics:dictionary:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:dictionary') a), (NOW()), '1', '3', '0', 'pc:basics:dictionary:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:wxtemplate') a), (NOW()), '1', '1', '0', 'pc:basics:wxtemplate:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:wxtemplate') a), (NOW()), '1', '2', '0', 'pc:basics:wxtemplate:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:wxtemplate') a), (NOW()), '1', '3', '0', 'pc:basics:wxtemplate:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:email') a), (NOW()), '1', '1', '0', 'pc:basics:email:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:email') a), (NOW()), '1', '2', '0', 'pc:basics:email:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:email') a), (NOW()), '1', '3', '0', 'pc:basics:email:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:sms') a), (NOW()), '1', '1', '0', 'pc:basics:sms:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:sms') a), (NOW()), '1', '2', '0', 'pc:basics:sms:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:basics:sms') a), (NOW()), '1', '3', '0', 'pc:basics:sms:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:notice:list') a), (NOW()), '1', '1', '0', 'pc:notice:list:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:notice:list') a), (NOW()), '1', '2', '0', 'pc:notice:list:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:notice:list') a), (NOW()), '1', '3', '0', 'pc:notice:list:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('新增', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:washcar:list') a), (NOW()), '1', '1', '0', 'pc:washcar:list:add');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('修改', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:washcar:list') a), (NOW()), '1', '2', '0', 'pc:washcar:list:edit');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('删除', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:washcar:list') a), (NOW()), '1', '3', '0', 'pc:washcar:list:delete');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('审核', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:release:approval') a), (NOW()), '1', '4', '0', 'pc:release:approval:approve');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());

INSERT INTO `tb_app_function` (`FUNCTION_NAME`, `RIGHT_TYPE`, `PARENTCODE`,`LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ('审核', '2', (SELECT a.ID FROM (SELECT ID FROM tb_app_function WHERE PERMS='pc:dormitory:checkout') a), (NOW()), '1', '4', '0', 'pc:dormitory:checkout:approve');
update `tb_app_function` set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());