sys_occuption.sql 6.3 KB

12345678910111213141516171819202122232425262728
  1. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000001', '0', '企业', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  2. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000002', '10000001', '技术', '0', '1', '2021-01-16 15:42:34', '2021-02-03 11:01:00');
  3. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000003', '10000001', '产品', '0', '1', '2021-01-16 15:43:03', '2021-02-03 11:01:06');
  4. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000004', '10000001', '运营', '0', '1', '2021-01-16 15:43:19', '2021-02-03 11:01:19');
  5. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000005', '10000001', '设计', '0', '1', '2021-01-16 15:43:26', '2021-02-03 11:01:25');
  6. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000006', '10000001', '管理', '0', '1', '2021-01-16 15:43:33', '2021-02-03 11:01:32');
  7. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000007', '10000001', '销售', '0', '1', '2021-01-16 15:43:53', '2021-02-03 11:01:41');
  8. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000008', '10000001', '市场', '0', '1', '2021-01-16 15:44:01', '2021-02-03 11:01:44');
  9. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000009', '10000001', '人事', '0', '1', '2021-01-16 15:44:01', '2021-02-03 11:01:44');
  10. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000010', '10000001', '财务', '0', '1', '2021-01-16 15:44:01', '2021-02-03 11:01:44');
  11. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000011', '10000001', '行政', '0', '1', '2021-01-16 15:44:01', '2021-02-03 11:01:44');
  12. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000012', '10000001', '法务', '0', '1', '2021-01-16 15:44:01', '2021-02-03 11:01:44');
  13. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000013', '10000001', '采购', '0', '1', '2021-01-16 15:44:01', '2021-02-03 11:01:44');
  14. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000014', '10000001', '传媒', '0', '1', '2021-01-16 15:44:01', '2021-02-03 11:01:44');
  15. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000015', '0', '政府/事业单位', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  16. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000016', '10000015', '教师', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  17. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000017', '10000015', '医生', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  18. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000018', '10000015', '护士', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  19. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000019', '10000015', '公务员', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  20. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000020', '10000015', '军人', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  21. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000021', '10000015', '消防员', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  22. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000022', '10000015', '警察', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  23. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000023', '0', '其他从业人员', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  24. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000024', '10000023', '个体经营者', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  25. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000025', '10000023', '学生', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  26. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000026', '10000023', '自由职业者', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');
  27. INSERT INTO `buyao`.`sys_occupation` (`occupation_id`, `parent_occupation_id`, `name`, `sort_flag`, `state`, `gmt_create`, `gmt_modified`) VALUES ('10000027', '10000023', '其他', '0', '1', '2021-01-16 15:41:58', '2021-02-03 11:00:41');