홈 탐색 도움말
가입하기 로그인
gdc
/
DB-SQL
1
0
포크 0
파일 이슈 0 풀 리퀘스트 0 위키
트리: 481cf94691
브랜치 태그
DB-SQL
/
2021-09-09_001(宫德财).sql

2021-09-09_001(宫德财).sql 17 KB
히스토리 Raw

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. 

  2. 

  3. 

  4. 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);
    5. 

  5. 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);
    6. 

  6. 

  7. 

  8. 

  9. 

  10. 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);
    11. 

  11. 

  12. 

  13. 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);
    14. 

  14. 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);
    15. 

  15. 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);
    16. 

  16. 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);
    17. 

  17. 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);
    18. 

  18. 

  19. 

  20. 

  21. 

  22. 

  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 ('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);
    24. 

  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 ('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);
    25. 

  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 ('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);
    26. 

  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 ('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);
    27. 

  27. 

  28. 

  29. 

  30. 

  31. 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);
    32. 

  32. 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);
    33. 

  33. 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);
    34. 

  34. 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);
    35. 

  35. 

  36. 

  37. 

  38. 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);
    39. 

  39. 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);
    40. 

  40. 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);
    41. 

  41. 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);
    42. 

  42. 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);
    43. 

  43. 

  44. 

  45. 

  46. 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);
    47. 

  47. 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);
    48. 

  48. 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);
    49. 

  49. 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);
    50. 

  50. 

  51. 

  52. 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);
    53. 

  53. 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);
    54. 

  54. 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);
    55. 

  55. 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);
    56. 

  56.