charge-java/database/1.sql

-- charge_admin
insert into charge_admin.t_permission (id, pid, name, value, weight, create_time, update_time)
values
    (36, 0, '横幅广告', 'banner.list', 1, null, null),
    (37, 36, '查看', 'banner.list', 1, null, null),
    (38, 36, '编辑', 'banner.modify', 2, null, null),
    (39, 36, '删除', 'banner.delete', 3, null, null),
    (40, 36, '新增', 'banner.add', 1, null, null),
    (41, 0, '发票', 'invoice.list', 1, null, null),
    (42, 41, '查看', 'invoice.list', 1, null, null),
    (43, 41, '编辑', 'invoice.modify', 2, null, null),
    (44, 41, '删除', 'invoice.delete', 3, null, null),
    (45, 41, '新增', 'invoice.add', 1, null, null),
    (46, 0, '活动', 'activity.list', 1, null, null),
    (47, 46, '查看', 'activity.list', 1, null, null),
    (48, 46, '编辑', 'activity.modify', 2, null, null),
    (49, 46, '删除', 'activity.delete', 3, null, null),
    (50, 46, '新增', 'activity.add', 1, null, null),
    (51, 0, '退款', 'refund.list', 1, null, null),
    (52, 51, '查看', 'refund.list', 1, null, null),
    (53, 51, '编辑', 'refund.modify', 2, null, null),
    (54, 51, '删除', 'refund.delete', 3, null, null),
    (55, 51, '新增', 'refund.add', 1, null, null);


-- charge_app
insert into charge_app.t_data_dict ( code, name, weight, value, remark, create_time, update_time)
values
    ( 'Banner.status', '有效', 1, '1', null, '2023-10-29 15:44:18', '2023-10-29 15:44:18'),
    ( 'Banner.status', '无效', 2, '0', null, '2023-10-29 15:44:18', '2023-10-29 15:44:18'),
    ( 'Activity.discountType', '服务费折扣', 1, 'RechargeRights', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.discountType', '优惠券', 1, 'Coupon', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.applyStation', '全部站点 ', 1, '0', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.applyStation', '部分站点  ', 1, '1', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.status', '未开始  ', 1, '0', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.status', '进行中  ', 1, '1', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.status', '已结束  ', 1, '2', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.status', '已取消  ', 1, '3', null, '2023-10-29 20:29:11', '2023-10-29 20:29:11'),
    ( 'Activity.allowStacke', '允许', 1, '1', null, '2023-10-29 20:34:38', '2023-10-29 20:34:38'),
    ( 'Activity.allowStacke', '不允许', 1, '0', null, '2023-10-29 20:34:38', '2023-10-29 20:34:38'),
    ( 'Activity.targetUsers', '全部', 1, '0', null, '2023-10-29 20:34:38', '2023-10-29 20:34:38'),
    ( 'Activity.targetUsers', '新用户', 1, '1', null, '2023-10-29 20:34:38', '2023-10-29 20:34:38'),
    ( 'Activity.targetUsers', '老用户', 1, '2', null, '2023-10-29 20:34:38', '2023-10-29 20:34:38'),
    ( 'Invoice.status', '待开票', 1, '0', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Invoice.status', '已开票 ', 1, '1', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Invoice.type', '个人', 1, 'INDIVIDUAL', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Invoice.type', '企业', 1, 'ORGANIZATION', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Invoice.status', '已作废 ', 1, '2', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Invoice.status', '开票中 ', 1, '3', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Refund.status', '退款成功 ', 1, 'SUCCESS', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Refund.status', '退款关闭 ', 1, 'CLOSED', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Refund.status', '退款处理中 ', 1, 'PROCESSING', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47'),
    ( 'Refund.status', '退款异常 ', 1, 'ABNORMAL', null, '2023-10-29 21:51:47', '2023-10-29 21:51:47')

;