You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
32 lines
11 KiB
SQL
32 lines
11 KiB
SQL
create table we_chat_refunds
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
admin bigint default 0 null,
|
|
out_trade_no varchar(100) not null,
|
|
post_data text not null,
|
|
params longtext not null,
|
|
callback longtext null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index we_chat_refunds_out_trade_no_index
|
|
on we_chat_refunds (out_trade_no);
|
|
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (1, 0, '23053000000011', '{"transaction_id":"4200001881202305300809090763","out_refund_no":"23053000000011","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-05-30T16:57:37+08:00","funds_account":"AVAILABLE","out_refund_no":"23053000000011","out_trade_no":"23053000000011","promotion_detail":[],"refund_id":"50301505962023053035072822346","status":"SUCCESS","success_time":"2023-05-30T16:57:45+08:00","transaction_id":"4200001881202305300809090763","user_received_account":"支付用户零钱通"}', null, '2023-05-30 16:59:02', '2023-05-30 16:59:02');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (2, 0, '23053000000011', '{"transaction_id":"4200001881202305300809090763","out_refund_no":"23053000000011","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-05-30T16:57:37+08:00","funds_account":"AVAILABLE","out_refund_no":"23053000000011","out_trade_no":"23053000000011","promotion_detail":[],"refund_id":"50301505962023053035072822346","status":"SUCCESS","success_time":"2023-05-30T16:57:45+08:00","transaction_id":"4200001881202305300809090763","user_received_account":"支付用户零钱通"}', null, '2023-05-30 17:00:17', '2023-05-30 17:00:17');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (3, 0, '23053000000016', '{"transaction_id":"4200001863202305305655791592","out_refund_no":"23053000000016","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-05-30T17:32:54+08:00","funds_account":"AVAILABLE","out_refund_no":"23053000000016","out_trade_no":"23053000000016","promotion_detail":[],"refund_id":"50302505992023053035071691562","status":"PROCESSING","transaction_id":"4200001863202305305655791592","user_received_account":"支付用户零钱通"}', null, '2023-05-30 17:32:55', '2023-05-30 17:32:55');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (4, 0, '23053000000017', '{"transaction_id":"4200001863202305304225474765","out_refund_no":"23053000000017","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-05-30T17:33:56+08:00","funds_account":"AVAILABLE","out_refund_no":"23053000000017","out_trade_no":"23053000000017","promotion_detail":[],"refund_id":"50302005962023053035077607469","status":"PROCESSING","transaction_id":"4200001863202305304225474765","user_received_account":"支付用户零钱通"}', null, '2023-05-30 17:33:56', '2023-05-30 17:33:56');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (5, 0, '23053000000018', '{"transaction_id":"4200001863202305309332322462","out_refund_no":"23053000000018","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-05-30T17:40:48+08:00","funds_account":"AVAILABLE","out_refund_no":"23053000000018","out_trade_no":"23053000000018","promotion_detail":[],"refund_id":"50301605982023053035078819254","status":"PROCESSING","transaction_id":"4200001863202305309332322462","user_received_account":"支付用户零钱通"}', null, '2023-05-30 17:40:48', '2023-05-30 17:40:48');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (6, 0, '23060100000024', '{"transaction_id":"4200001875202306016475448464","out_refund_no":"23060100000024","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-06-01T16:48:39+08:00","funds_account":"AVAILABLE","out_refund_no":"23060100000024","out_trade_no":"23060100000024","promotion_detail":[],"refund_id":"50300605902023060135166636128","status":"PROCESSING","transaction_id":"4200001875202306016475448464","user_received_account":"支付用户零钱通"}', null, '2023-06-01 16:48:40', '2023-06-01 16:48:40');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (7, 0, '23060100000025', '{"transaction_id":"4200001875202306012554576392","out_refund_no":"23060100000025","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-06-01T16:53:06+08:00","funds_account":"AVAILABLE","out_refund_no":"23060100000025","out_trade_no":"23060100000025","promotion_detail":[],"refund_id":"50302305832023060135177440501","status":"PROCESSING","transaction_id":"4200001875202306012554576392","user_received_account":"支付用户零钱通"}', null, '2023-06-01 16:53:07', '2023-06-01 16:53:07');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (8, 0, '23060100000020', '{"transaction_id":"4200001854202306017391028977","out_refund_no":"23060100000020","total":1}', '{"code":"NOT_ENOUGH","message":"基本账户余额不足，请充值后重新发起"}', null, '2023-06-10 21:46:51', '2023-06-10 21:46:51');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (9, 0, '23060100000026', '{"transaction_id":"4200001869202306017909135918","out_refund_no":"23060100000026","total":1}', '{"code":"NOT_ENOUGH","message":"基本账户余额不足，请充值后重新发起"}', null, '2023-06-10 21:52:21', '2023-06-10 21:52:21');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (10, 0, '23061000000028', '{"transaction_id":"4200001874202306106949118449","out_refund_no":"23061000000028","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-06-10T22:07:03+08:00","funds_account":"AVAILABLE","out_refund_no":"23061000000028","out_trade_no":"23061000000028","promotion_detail":[],"refund_id":"50302605802023061035535085859","status":"PROCESSING","transaction_id":"4200001874202306106949118449","user_received_account":"支付用户零钱通"}', null, '2023-06-10 22:07:02', '2023-06-10 22:07:02');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (11, 0, '23061000000029', '{"transaction_id":"4200001865202306104894982654","out_refund_no":"23061000000029","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-06-10T22:10:31+08:00","funds_account":"AVAILABLE","out_refund_no":"23061000000029","out_trade_no":"23061000000029","promotion_detail":[],"refund_id":"50301406012023061035536279054","status":"PROCESSING","transaction_id":"4200001865202306104894982654","user_received_account":"支付用户零钱通"}', null, '2023-06-10 22:10:30', '2023-06-10 22:10:30');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (12, 0, '23061000000030', '{"transaction_id":"4200001857202306100716925903","out_refund_no":"23061000000030","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-06-10T22:19:23+08:00","funds_account":"AVAILABLE","out_refund_no":"23061000000030","out_trade_no":"23061000000030","promotion_detail":[],"refund_id":"50301905902023061035535702945","status":"PROCESSING","transaction_id":"4200001857202306100716925903","user_received_account":"支付用户零钱通"}', null, '2023-06-10 22:19:22', '2023-06-10 22:19:22');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (13, 0, '23060100000026', '{"transaction_id":"4200001869202306017909135918","out_refund_no":"23060100000026","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-06-10T23:12:12+08:00","funds_account":"AVAILABLE","out_refund_no":"23060100000026","out_trade_no":"23060100000026","promotion_detail":[],"refund_id":"50302605992023061035538149410","status":"PROCESSING","transaction_id":"4200001869202306017909135918","user_received_account":"支付用户零钱通"}', null, '2023-06-10 23:12:12', '2023-06-10 23:12:12');
|
|
INSERT INTO lkpe.we_chat_refunds (id, admin, out_trade_no, post_data, params, callback, created_at, updated_at) VALUES (14, 2, '23061000000031', '{"transaction_id":"4200001863202306101114595220","out_refund_no":"23061000000031","total":1}', '{"amount":{"currency":"CNY","discount_refund":0,"from":[],"payer_refund":1,"payer_total":1,"refund":1,"refund_fee":0,"settlement_refund":1,"settlement_total":1,"total":1},"channel":"ORIGINAL","create_time":"2023-06-10T23:18:12+08:00","funds_account":"AVAILABLE","out_refund_no":"23061000000031","out_trade_no":"23061000000031","promotion_detail":[],"refund_id":"50300405782023061059069585248","status":"PROCESSING","transaction_id":"4200001863202306101114595220","user_received_account":"支付用户零钱通"}', null, '2023-06-10 23:18:12', '2023-06-10 23:18:12');
|