| 123456789 |
- -- 新增企业管理功能
- INSERT INTO `tb_app_function` (`SYSTEMCODE`, `FUNCTION_NAME`, `URL`, `RIGHT_TYPE`, `PARENTCODE`, `TREECODE`, `LASTUPDATEBY`, `LASTUPDATETIME`, `STATUS`, `ORDER_NUMBER`, `IS_APP`, `PERMS`) VALUES ( NULL, '企业管理', '', '0', '0', '477', '1', '2019-03-19', '1', '2', '0', 'pc:company');
- update tb_app_function set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());
- INSERT INTO `tb_app_menu` (`MENU_NAME`, `FUNCTION_ID`, `TREECODE`, `PARENTCODE`, `DESCRIPTION`, `ORDER_NUMBER`, `CREATE_TIME`, `REMARK`, `IS_APP`, `ICON_URL`, `MENU_CODE`, `menu_icon_url`)
- VALUES ( '企业管理', (select id from tb_app_function where FUNCTION_NAME='企业管理'), '394', '0', '', NULL, '2019-03-19 17:28:07', NULL, '0', '', '', '');
- update tb_app_menu set TREECODE=last_insert_id() where id=(select LAST_INSERT_ID());
|
