Trang chủ Khám phá Trợ giúp
Đăng nhập
cnbg
/
cnbg-be
4
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu khéo về 0 Wiki
Tree: a5d6d54b61
Branches Tags
cnbg-be
/
db
/
v2.0
/
2-create.sql

2-create.sql 4.9 KB
Lịch sử Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546 
  1. CREATE TABLE `hnqzx`.`wm_import_user`  (
    2. 

  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
    3. 

  3.   `score_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '积分包ID',
    4. 

  4.   `import_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
    5. 

  5.   `import_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
    6. 

  6.   `import_id_card_number` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',
    7. 

  7.   `user_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '签名',
    8. 

  8.   `cert_status` int(2) NULL DEFAULT NULL COMMENT '认证状态',
    9. 

  9.   `cert_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '认证结果描述',
    10. 

  10.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    11. 

  11.   `create_user` int(11) NULL DEFAULT NULL COMMENT '创建人',
    12. 

  12.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否删除',
    13. 

  13.   `real_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否禁用',
    14. 

  14.   PRIMARY KEY (`id`) USING BTREE
    15. 

  15. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '导入任务成员表' ROW_FORMAT = Dynamic;
    16. 

  16. 

  17. 

  18. ALTER TABLE `wm_score_package` ADD `score_package_status` varchar(11) DEFAULT NULL  COMMENT '积分包状态';
    19. 

  19. ALTER TABLE `wm_task` ADD `task_status_info` varchar(500) DEFAULT NULL  COMMENT 'cso审核审核意见';
    20. 

  20. 

  21. 

  22. 

  23. INSERT INTO `hnqzx`.`sys_dict`( `type`, `description`, `create_time`, `update_time`, `remarks`, `system`, `del_flag`, `tenant_id`)
    24. 

  24. VALUES ( 'enable_type', '终止类型', '2021-02-03 11:50:09', '2021-02-03 11:50:09', '终止类型', '0', '0', 1);
    25. 

  25. INSERT INTO `hnqzx`.`sys_dict`( `type`, `description`, `create_time`, `update_time`, `remarks`, `system`, `del_flag`, `tenant_id`)
    26. 

  26. VALUES ( 'score_package_status', '积分包状态', '2021-02-03 14:17:23', '2021-02-03 14:17:23', '积分包状态', '0', '0', 1);
    27. 

  27. 

  28. 

  29. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    30. 

  30. VALUES (239, 63, '1', '全部收回', 'enable_type', '全部收回', 2, '2021-02-03 11:55:36', '2021-02-03 11:55:36', '全部收回', '0', 1);
    31. 

  31. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    32. 

  32. VALUES (240, 63, '2', '部分收回', 'enable_type', '部分收回', 3, '2021-02-03 11:55:49', '2021-02-03 11:55:49', '部分收回', '0', 1);
    33. 

  33. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    34. 

  34. VALUES (241, 63, '0', '未终止', 'enable_type', '未终止', 1, '2021-02-03 13:57:39', '2021-02-03 13:57:39', '未终止', '0', 1);
    35. 

  35. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    36. 

  36. VALUES (242, 64, '1', '已分派待申领', 'score_package_status', '已分派待申领', 1, '2021-02-03 14:17:45', '2021-02-03 14:17:45', '已分派待申领', '0', 1);
    37. 

  37. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    38. 

  38. VALUES (243, 64, '2', '已申领待审批', 'score_package_status', '已申领待审批', 2, '2021-02-03 14:18:03', '2021-02-03 14:18:03', '已申领待审批', '0', 1);
    39. 

  39. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    40. 

  40. VALUES (244, 64, '3', '进行中', 'score_package_status', '进行中', 3, '2021-02-03 14:18:23', '2021-02-03 14:18:23', '进行中', '0', 1);
    41. 

  41. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    42. 

  42. VALUES (245, 64, '4', '已完成待结算', 'score_package_status', '已完成待结算', 4, '2021-02-03 14:18:42', '2021-02-03 14:18:42', '已完成待结算', '0', 1);
    43. 

  43. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    44. 

  44. VALUES (246, 64, '5', '已提交结算申请', 'score_package_status', '已提交结算申请', 5, '2021-02-03 14:19:02', '2021-02-03 14:19:02', '已提交结算申请', '0', 1);
    45. 

  45. INSERT INTO `hnqzx`.`sys_dict_item`(`id`, `dict_id`, `value`, `label`, `type`, `description`, `sort`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`)
    46. 

  46. VALUES (247, 64, '6', '已终止', 'score_package_status', '已终止', 6, '2021-02-03 14:19:19', '2021-02-03 14:19:19', '已终止', '0', 1);
    47.