SysMiniappDailyVisitMenu.sql 4.0 KB

12345678910111213141516171819
  1. -- 菜单 SQL
  2. insert into sys_menu (id, menu_code, menu_name, sort, path, component, is_frame, is_cache, menu_type, visible, perms, icon, parent_id, parent_ids, tree_sort, tree_sorts, tree_level, tree_leaf, status, create_by, create_time, update_by, update_time, create_dept, update_ip, version, remark, del_flag)
  3. values('1596deb4376c48f7bdb3028dfd79d089', 'sysMiniappDailyVisit', '小程序日数据统计', '50', 'sysMiniappDailyVisit', 'system/sysminiappdailyvisit/index', 1, 0, 'C', 0, 'system:sysMiniappDailyVisit:list', '#', '3', '3/1596deb4376c48f7bdb3028dfd79d089', '50', '000030/000050', '2', 'n', '0', '1', sysdate(), '1', sysdate(), '', '127.0.0.1', 0, '', '0');
  4. -- 按钮 SQL
  5. insert into sys_menu (id, menu_code, menu_name, sort, path, component, is_frame, is_cache, menu_type, visible, perms, icon, parent_id, parent_ids, tree_sort, tree_sorts, tree_level, tree_leaf, status, create_by, create_time, update_by, update_time, create_dept, update_ip, version, remark, del_flag)
  6. values('1323341d0d9545a986ed07518c14fe02', 'sysMiniappDailyVisitQuery', '小程序日数据统计查询', '10', '#', '', 1, 0, 'F', 0, 'system:sysMiniappDailyVisit:query', '#', '1596deb4376c48f7bdb3028dfd79d089', '3/1596deb4376c48f7bdb3028dfd79d089/1323341d0d9545a986ed07518c14fe02', '10', '000030/000050/000010', '3', 'y', '0', '1', sysdate(), '1', sysdate(), '', '127.0.0.1', 0, '', '0');
  7. insert into sys_menu (id, menu_code, menu_name, sort, path, component, is_frame, is_cache, menu_type, visible, perms, icon, parent_id, parent_ids, tree_sort, tree_sorts, tree_level, tree_leaf, status, create_by, create_time, update_by, update_time, create_dept, update_ip, version, remark, del_flag)
  8. values('def0c45dd186431c8220c2c69150119c', 'sysMiniappDailyVisitAdd', '小程序日数据统计新增', '20', '#', '', 1, 0, 'F', 0, 'system:sysMiniappDailyVisit:add', '#', '1596deb4376c48f7bdb3028dfd79d089', '3/1596deb4376c48f7bdb3028dfd79d089/def0c45dd186431c8220c2c69150119c', '20', '000030/000050/000020', '3', 'y', '0', '1', sysdate(), '1', sysdate(), '', '127.0.0.1', 0, '', '0');
  9. insert into sys_menu (id, menu_code, menu_name, sort, path, component, is_frame, is_cache, menu_type, visible, perms, icon, parent_id, parent_ids, tree_sort, tree_sorts, tree_level, tree_leaf, status, create_by, create_time, update_by, update_time, create_dept, update_ip, version, remark, del_flag)
  10. values('1c0f4a6d323a4c27a088ede2ce1be8a3', 'sysMiniappDailyVisitEdit', '小程序日数据统计修改', '30', '#', '', 1, 0, 'F', 0, 'system:sysMiniappDailyVisit:edit', '#', '1596deb4376c48f7bdb3028dfd79d089', '3/1596deb4376c48f7bdb3028dfd79d089/1c0f4a6d323a4c27a088ede2ce1be8a3', '30', '000030/000050/000030', '3', 'y', '0', '1', sysdate(), '1', sysdate(), '', '127.0.0.1', 0, '', '0');
  11. insert into sys_menu (id, menu_code, menu_name, sort, path, component, is_frame, is_cache, menu_type, visible, perms, icon, parent_id, parent_ids, tree_sort, tree_sorts, tree_level, tree_leaf, status, create_by, create_time, update_by, update_time, create_dept, update_ip, version, remark, del_flag)
  12. values('c3cc716868e144ee84f48cf273fdad04', 'sysMiniappDailyVisitRemove', '小程序日数据统计删除', '10', '#', '', 1, 0, 'F', 0, 'system:sysMiniappDailyVisit:remove', '#', '1596deb4376c48f7bdb3028dfd79d089', '3/1596deb4376c48f7bdb3028dfd79d089/c3cc716868e144ee84f48cf273fdad04', '40', '000030/000050/000040', '3', 'y', '0', '1', sysdate(), '1', sysdate(), '', '127.0.0.1', 0, '', '0');
  13. insert into sys_menu (id, menu_code, menu_name, sort, path, component, is_frame, is_cache, menu_type, visible, perms, icon, parent_id, parent_ids, tree_sort, tree_sorts, tree_level, tree_leaf, status, create_by, create_time, update_by, update_time, create_dept, update_ip, version, remark, del_flag)
  14. values('f7bef13a5e454eee93b7963c22b6f777', 'sysMiniappDailyVisitExport', '小程序日数据统计查询', '50', '#', '', 1, 0, 'F', 0, 'system:sysMiniappDailyVisit:export', '#', '1596deb4376c48f7bdb3028dfd79d089', '3/1596deb4376c48f7bdb3028dfd79d089/f7bef13a5e454eee93b7963c22b6f777', '50', '000030/000050/000050', '3', 'y', '0', '1', sysdate(), '1', sysdate(), '', '127.0.0.1', 0, '', '0');