Skip to content

J
jiedao-api-boot-master
Switch branch/tag
Find file
Normal viewHistoryPermalink
system_dict_update_20240815.sql 17.8 KB
Newer Older
zhangfeng's avatar
会员功能新增sql脚本整理
bc3631f0
 
zhangfeng committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 
SET FOREIGN_KEY_CHECKS = 0;

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2751, 0, '上门领取', '1', 'way_of_receiving', 0, 'default', '', NULL, '1', '2024-07-23 13:16:51', '1', '2024-07-23 13:16:51', b'0', 'Collect at home');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2752, 0, '包邮到家', '2', 'way_of_receiving', 0, 'default', '', NULL, '1', '2024-07-23 13:17:49', '1', '2024-07-23 13:17:49', b'0', 'Free home delivery');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2753, 2, '邮寄到付', '3', 'way_of_receiving', 0, 'default', '', NULL, '1', '2024-07-23 13:18:24', '1', '2024-07-23 13:18:24', b'0', 'Collect by post');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2754, 1, '未启用', '2', 'gift_status', 0, 'default', '', NULL, '1', '2024-07-23 13:23:20', '1', '2024-07-23 13:41:16', b'0', 'Not enabled');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2755, 0, '已启用', '1', 'gift_status', 0, 'default', '', NULL, '1', '2024-07-23 13:23:45', '1', '2024-07-23 13:41:07', b'0', 'Enabled');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2756, 2, '已关闭', '3', 'gift_status', 0, 'default', '', NULL, '1', '2024-07-23 13:24:42', '1', '2024-07-23 13:24:42', b'0', 'Disabled');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2757, 3, '已过期', '4', 'gift_status', 0, 'default', '', NULL, '1', '2024-07-23 13:25:25', '1', '2024-07-23 13:25:25', b'0', 'Expired');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2758, 1, '启用', '1', 'gift_enable_status', 0, 'default', '', NULL, '1', '2024-07-25 14:40:30', '1', '2024-07-25 14:40:30', b'0', 'enable');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2759, 1, '不启用', '2', 'gift_enable_status', 0, 'default', '', NULL, '1', '2024-07-25 14:41:15', '1', '2024-07-25 14:41:15', b'0', 'disable');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2760, 0, '新增', '1', 'member_user_score_log_operate_type', 0, 'default', '', NULL, '1', '2024-07-26 14:20:48', '1', '2024-07-26 14:20:48', b'0', 'add');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2761, 1, '减少', '2', 'member_user_score_log_operate_type', 0, 'default', '', NULL, '1', '2024-07-26 14:21:06', '1', '2024-07-26 14:21:06', b'0', 'reduce');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2762, 1, '人工操作', '1', 'member_score_source', 0, 'default', '', NULL, '1', '2024-07-26 14:23:18', '1', '2024-07-26 14:23:18', b'0', 'manual operation');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2763, 2, '兑换礼品', '2', 'member_score_source', 0, 'default', '', NULL, '1', '2024-07-26 14:23:32', '1', '2024-07-26 14:23:32', b'0', 'redeem reward');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2764, 3, '系统过期', '3', 'member_score_source', 0, 'default', '', NULL, '1', '2024-07-26 14:23:47', '1', '2024-07-26 14:23:47', b'0', 'system expired');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2765, 1, '后台', '1', 'redeem_reward_entrance', 0, 'default', '', NULL, '1', '2024-07-26 14:27:57', '1', '2024-08-06 09:17:29', b'1', 'background');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2766, 2, '网页端', '3', 'redeem_reward_entrance', 0, 'default', '', NULL, '1', '2024-07-26 14:28:08', '1', '2024-08-06 09:18:29', b'0', 'web');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2767, 3, '客户端', '2', 'redeem_reward_entrance', 0, 'default', '', NULL, '1', '2024-07-26 14:28:17', '1', '2024-08-06 09:18:23', b'0', 'app');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2768, 1, '兑换中', '1', 'reward_redeem_status', 0, 'default', '', NULL, '1', '2024-07-26 15:04:08', '1', '2024-07-26 15:04:08', b'0', 'redeeming');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2769, 2, '已兑换', '2', 'reward_redeem_status', 0, 'default', '', NULL, '1', '2024-07-26 15:04:26', '1', '2024-07-26 15:04:26', b'0', 'redeemed');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2770, 3, '已取消', '3', 'reward_redeem_status', 0, 'default', '', NULL, '1', '2024-07-26 15:04:38', '1', '2024-07-26 15:04:38', b'0', 'canceled');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2771, 0, '订单V值', '1', 'score_rule_type', 0, 'default', '', NULL, '1', '2024-07-29 13:22:22', '1', '2024-07-29 13:23:19', b'0', 'order v');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2772, 1, '注册', '2', 'score_rule_type', 0, 'default', '', NULL, '1', '2024-07-29 13:23:54', '1', '2024-07-29 13:23:54', b'0', 'register');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2773, 2, '推荐', '3', 'score_rule_type', 0, 'default', '', NULL, '1', '2024-07-29 13:24:25', '1', '2024-07-29 13:24:25', b'0', 'recommend');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2774, 3, '分享活动', '4', 'score_rule_type', 0, 'default', '', NULL, '1', '2024-07-29 13:24:53', '1', '2024-07-29 13:24:53', b'0', 'share');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2775, 0, '后台', '1', 'platform_type', 0, 'default', '', NULL, '1', '2024-07-29 13:37:00', '1', '2024-07-29 13:38:49', b'0', 'backend');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2776, 1, 'APP', '2', 'platform_type', 0, 'default', '', NULL, '1', '2024-07-29 13:37:15', '1', '2024-07-29 13:38:01', b'0', 'APP');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2777, 2, 'WEB', '3', 'platform_type', 0, 'default', '', NULL, '1', '2024-07-29 13:37:55', '1', '2024-07-29 13:37:55', b'0', 'WEB');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2781, 33, '礼品兑换记录', '33', 'download_type', 0, 'default', '', NULL, '1', '2024-07-30 14:11:06', '1', '2024-07-30 14:11:06', b'0', 'RewardRedeemRecord');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2782, 4, '兑换礼品撤销', '4', 'member_score_source', 0, 'default', '', NULL, '1', '2024-08-01 11:14:32', '1', '2024-08-01 11:14:32', b'0', 'redeem reward cancel');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2783, 5, '订单V值', '5', 'member_score_source', 0, 'default', '', NULL, '1', '2024-08-01 11:18:40', '1', '2024-08-01 13:48:33', b'0', 'oder V');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2784, 7, '推荐', '7', 'member_score_source', 0, 'default', '', NULL, '1', '2024-08-01 14:01:43', '1', '2024-08-01 14:01:43', b'0', 'recommend');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2785, 6, '注册', '6', 'member_score_source', 0, 'default', '', NULL, '1', '2024-08-01 14:02:25', '1', '2024-08-01 14:02:25', b'0', 'register');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2786, 8, '分享活动', '8', 'member_score_source', 0, 'default', '', NULL, '1', '2024-08-01 14:02:45', '1', '2024-08-01 14:13:23', b'0', 'share');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2787, 0, '是', '0', 'yes_or_no', 0, 'default', '', NULL, '1', '2024-08-06 15:16:26', '1', '2024-08-06 15:16:26', b'0', 'YES');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2788, 0, '否', '1', 'yes_or_no', 0, 'default', '', NULL, '1', '2024-08-06 15:16:37', '1', '2024-08-06 15:16:37', b'0', 'NO');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2789, 1, 'APP', '2', 'client_platform', 0, 'default', '', NULL, '1', '2024-08-08 09:24:26', '1', '2024-08-08 09:51:47', b'0', 'APP');

INSERT INTO `jiedao`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2790, 2, 'WEB', '3', 'client_platform', 0, 'default', '', NULL, '1', '2024-08-08 09:24:42', '1', '2024-08-08 09:51:52', b'0', 'WEB');

UPDATE `jiedao`.`system_dict_data` SET `sort` = 0, `label` = '大于', `value` = '1', `dict_type` = 'quantitative_relation_symbol', `status` = 0, `color_type` = 'default', `css_class` = '', `remark` = NULL, `creator` = '1', `create_time` = '2024-07-23 10:27:47', `updater` = '1', `update_time` = '2024-07-23 10:27:47', `deleted` = b'0', `label_en` = 'Greater than' WHERE `id` = 2748;

UPDATE `jiedao`.`system_dict_data` SET `sort` = 1, `label` = '等于', `value` = '2', `dict_type` = 'quantitative_relation_symbol', `status` = 0, `color_type` = 'default', `css_class` = '', `remark` = NULL, `creator` = '1', `create_time` = '2024-07-23 10:28:04', `updater` = '1', `update_time` = '2024-07-23 10:28:04', `deleted` = b'0', `label_en` = 'Equal' WHERE `id` = 2749;

UPDATE `jiedao`.`system_dict_data` SET `sort` = 2, `label` = '小于', `value` = '3', `dict_type` = 'quantitative_relation_symbol', `status` = 0, `color_type` = 'default', `css_class` = '', `remark` = NULL, `creator` = '1', `create_time` = '2024-07-23 10:28:58', `updater` = '1', `update_time` = '2024-07-23 10:28:58', `deleted` = b'0', `label_en` = 'Less than' WHERE `id` = 2750;

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (427, '数量关系符号', 'quantitative_relation_symbol', 0, NULL, '1', '2024-07-23 10:27:02', '1', '2024-07-23 10:27:02', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (428, '领取方式', 'way_of_receiving', 0, NULL, '1', '2024-07-23 13:14:40', '1', '2024-07-23 13:14:40', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (429, '礼品状态', 'gift_status', 0, NULL, '1', '2024-07-23 13:19:44', '1', '2024-07-23 13:19:44', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (430, '礼品启用状态', 'gift_enable_status', 0, NULL, '1', '2024-07-25 14:37:35', '1', '2024-07-25 14:37:35', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (431, '会员积分日志操作类型', 'member_user_score_log_operate_type', 0, NULL, '1', '2024-07-26 14:20:27', '1', '2024-07-26 14:20:27', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (432, '会员积分来源', 'member_score_source', 0, NULL, '1', '2024-07-26 14:22:30', '1', '2024-07-26 14:22:30', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (433, '礼品兑换入口', 'redeem_reward_entrance', 0, NULL, '1', '2024-07-26 14:27:40', '1', '2024-08-06 09:18:11', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (434, '礼品兑换状态', 'reward_redeem_status', 0, NULL, '1', '2024-07-26 15:03:53', '1', '2024-07-26 15:03:53', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (435, '积分规则指标类型', 'score_rule_type', 0, NULL, '1', '2024-07-29 13:21:38', '1', '2024-07-29 13:21:38', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (436, '平台入口', 'platform_type', 0, NULL, '1', '2024-07-29 13:36:23', '1', '2024-07-29 13:36:23', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (437, '快递公司', 'express_company', 1, NULL, '1', '2024-07-29 15:34:43', '1', '2024-07-30 11:09:44', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (438, '是否开启', 'yes_or_no', 0, NULL, '1', '2024-08-06 15:15:58', '1', '2024-08-06 15:15:58', b'0');

INSERT INTO `jiedao`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (439, 'c端平台', 'client_platform', 0, NULL, '1', '2024-08-08 09:23:52', '1', '2024-08-08 09:27:56', b'0');

SET FOREIGN_KEY_CHECKS = 1;