2021-09-09_001(宫德财).sql 17 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. INSERT INTO `common_business_feature`(`id`, `name`, `name_en`, `code`, `index`, `category_code`, `parent_id`, `service_code`, `tenant_id`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('4cdb12601c9e11ea9ff31831bf20000', '收购业务管理', NULL, NULL, 1, 'WORKFLOW', '-1', 'acquisition', NULL, '0', 1, '2019-12-29 00:53:31', 'sysadmin', '2020-02-25 14:55:24', 'sysadmin', '1', 2, 0);
  2. INSERT INTO `common_business_feature`(`id`, `name`, `name_en`, `code`, `index`, `category_code`, `parent_id`, `service_code`, `tenant_id`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('336ed1191c9f11ea9ff31831bf228ttt', '仓库设置', NULL, 'PROCUREMENT-PRICE-APPROVE', 1, 'WORKFLOW', '4cdb12601c9e11ea9ff31831bf20000', 'acquisition', NULL, '0', 1, '2019-12-29 00:53:31', 'sysadmin', '2020-02-25 14:55:24', 'sysadmin', '1', 2, 0);
  3. INSERT INTO `common_business_feature`(`id`, `name`, `name_en`, `code`, `index`, `category_code`, `parent_id`, `service_code`, `tenant_id`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('336ed1191c9f11ea9ff31831bf244tt', '付款管理', NULL, 'PAYMENT-MANAGEMENT-APPROVE', 1, 'WORKFLOW', '4cdb12601c9e11ea9ff31831bf20000', 'acquisitionPay', NULL, '0', 1, '2019-12-29 00:53:31', 'sysadmin', '2020-02-25 14:55:24', 'sysadmin', '1', 2, 0);
  4. INSERT INTO `common_parameter_plugin`(`plugin_id`, `tenant_id`, `plugin_name`, `plugin_code`, `plugin_sort`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('sg8646425cac43fa91908ad03035390c', '', '收购管理', 'acquisitionManagement', 10, '0', 0, '2020-02-22 20:29:04', 'sysadmin', '2020-02-22 20:29:04', 'sysadmin', '0', 1, 0);
  5. INSERT INTO `common_parameter_service`(`service_id`, `tenant_id`, `service_name`, `service_code`, `service_sort`, `plugin_id`, `parent_service_code`, `resource_id`, `form_flag`, `customization_flag`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq1', NULL, '仓库设置', 'acquisition', NULL, 'acquisitionManagement', '-1', NULL, '0', NULL, '0', 0, '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '0', 1, 0);
  6. INSERT INTO `common_parameter_service`(`service_id`, `tenant_id`, `service_name`, `service_code`, `service_sort`, `plugin_id`, `parent_service_code`, `resource_id`, `form_flag`, `customization_flag`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq2', NULL, '付款管理', 'acquisitionPay', NULL, 'acquisitionManagement', '-1', NULL, '0', NULL, '0', 0, '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '0', 1, 0);
  7. INSERT INTO `common_parameter_service`(`service_id`, `tenant_id`, `service_name`, `service_code`, `service_sort`, `plugin_id`, `parent_service_code`, `resource_id`, `form_flag`, `customization_flag`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq3', NULL, '客户管理', 'acquisitionCustomer', NULL, 'acquisitionManagement', '-1', NULL, '0', NULL, '0', 0, '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '0', 1, 0);
  8. INSERT INTO `common_parameter_service`(`service_id`, `tenant_id`, `service_name`, `service_code`, `service_sort`, `plugin_id`, `parent_service_code`, `resource_id`, `form_flag`, `customization_flag`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq4', NULL, '质检管理', 'acquisitionQuality', NULL, 'acquisitionManagement', '-1', NULL, '0', NULL, '0', 0, '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '0', 1, 0);
  9. INSERT INTO `common_parameter_service`(`service_id`, `tenant_id`, `service_name`, `service_code`, `service_sort`, `plugin_id`, `parent_service_code`, `resource_id`, `form_flag`, `customization_flag`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq5', NULL, '检斤管理', 'acquisitionWeight', NULL, 'acquisitionManagement', '-1', NULL, '0', NULL, '0', 0, '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '0', 1, 0);
  10. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq001', 'acquisition-Add', '', '仓库设置添加', 'acquisition.add', 'acquisition/acquisitionManagement', 'acquisitionManagement', 'acquisition', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  11. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq002', 'acquisition-Print', '', '仓库设置编辑', 'acquisition.print', 'acquisition/acquisitionManagement', 'acquisitionManagement', 'acquisition', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  12. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq003', 'acquisition-View', '', '仓库设置查看', 'acquisition.view', 'acquisition/acquisitionManagement', 'acquisitionManagement', 'acquisition', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  13. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq004', 'acquisition-Delete', '', '仓库设置删除', 'acquisition.delete', 'acquisition/acquisitionManagement', 'acquisitionManagement', 'acquisition', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  14. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq005', 'acquisitionCustomer-Add', '', '客户管理添加', 'acquisitionCustomer.add', 'acquisitionCustomer/acquisitionManagement', 'acquisitionManagement', 'acquisitionCustomer', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  15. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq006', 'acquisitionCustomer-Edit', '', '客户管理编辑', 'acquisitionCustomer.edit', 'acquisitionCustomer/acquisitionManagement', 'acquisitionManagement', 'acquisitionCustomer', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  16. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq007', 'acquisitionCustomer-View', '', '客户管理查看', 'acquisitionCustomer.view', 'acquisitionCustomer/acquisitionManagement', 'acquisitionManagement', 'acquisitionCustomer', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  17. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq008', 'acquisitionCustomer-Delete', '', '客户管理删除', 'acquisitionCustomer.delete', 'acquisitionCustomer/acquisitionManagement', 'acquisitionManagement', 'acquisitionCustomer', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  18. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq009', 'acquisitionQuality-Add', '', '质检管理添加', 'acquisitionQuality.add', 'acquisitionQuality/acquisitionManagement', 'acquisitionManagement', 'acquisitionQuality', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  19. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq010', 'acquisitionQuality-Edit', '', '质检管理编辑', 'acquisitionQuality.edit', 'acquisitionQuality/acquisitionManagement', 'acquisitionManagement', 'acquisitionQuality', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  20. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq011', 'acquisitionQuality-View', '', '质检管理查看', 'acquisitionQuality.view', 'acquisitionQuality/acquisitionManagement', 'acquisitionManagement', 'acquisitionQuality', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  21. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq012', 'acquisitionQuality-Delete', '', '质检管理删除', 'acquisitionQuality.delete', 'acquisitionQuality/acquisitionManagement', 'acquisitionManagement', 'acquisitionQuality', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  22. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq013', 'acquisitionQuality-Print', '', '质检管理打印', 'acquisitionQuality.print', 'acquisitionQuality/acquisitionManagement', 'acquisitionManagement', 'acquisitionQuality', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  23. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq014', 'acquisitionWeight-Mao', '', '检斤管理毛重', 'acquisitionWeight.mao', 'acquisitionWeight/acquisitionManagement', 'acquisitionManagement', 'acquisitionWeight', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  24. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq015', 'acquisitionWeight-View', '', '检斤管理查看', 'acquisitionWeight.view', 'acquisitionWeight/acquisitionManagement', 'acquisitionManagement', 'acquisitionWeight', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  25. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq016', 'acquisitionWeight-Weight', '', '检斤管理皮重', 'acquisitionWeight.weight', 'acquisitionWeight/acquisitionManagement', 'acquisitionManagement', 'acquisitionWeight', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  26. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq017', 'acquisitionWeight-Print', '', '检斤管理打印', 'acquisitionWeight.print', 'acquisitionWeight/acquisitionManagement', 'acquisitionManagement', 'acquisitionWeight', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  27. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq018', 'acquisitionPay-Add', '', '付款管理结算', 'acquisitionPay.add', 'acquisitionPay/acquisitionManagement', 'acquisitionManagement', 'acquisitionPay', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  28. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq020', 'acquisitionPay-View', '', '付款管理查看', 'acquisitionPay.view', 'acquisitionPay/acquisitionManagement', 'acquisitionManagement', 'acquisitionPay', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  29. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq021', 'acquisitionPay-Delete', '', '付款管理删除', 'acquisitionPay.delete', 'acquisitionPay/acquisitionManagement', 'acquisitionManagement', 'acquisitionPay', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);
  30. INSERT INTO `common_resource_menu`(`id`, `resource_id`, `tenant_id`, `resource_name`, `menu_name`, `parent_menu_name`, `plugin_code`, `service_code`, `service_item_code`, `delete_flag`, `update_count`, `create_date`, `create_user_id`, `update_date`, `update_user_id`, `update_flag`, `now_version_no`, `prev_version_no`) VALUES ('acq022', 'acquisitionPay-Print', '', '付款管理打印', 'acquisitionPay.print', 'acquisitionPay/acquisitionManagement', 'acquisitionManagement', 'acquisitionPay', NULL, '0', 0, '2021-06-05 10:14:32', '1', '2021-06-15 10:14:37', '1', '0', 1, 0);