zetaloop
20 lines
999 B
SQL
20 lines
999 B
SQL
INSERT INTO wallets (user_id, balance, frozen_balance) VALUES
|
|
(100000, 99999.00, 0.00),
|
|
(100001, 2580.00, 0.00),
|
|
(100002, 1890.00, 0.00),
|
|
(100003, 3200.00, 0.00),
|
|
(100004, 5600.00, 0.00),
|
|
(100005, 4200.00, 0.00),
|
|
(100006, 500.00, 0.00),
|
|
(100007, 300.00, 0.00),
|
|
(100008, 1500.00, 0.00);
|
|
|
|
INSERT INTO wallet_transactions (id, user_id, type, amount, balance_after, description, order_id) VALUES
|
|
(100001, 100006, 'topup', 500.00, 500.00, '充值', null),
|
|
(100002, 100006, 'payment', -99.00, 401.00, 'LOL 钻石上分', 100001),
|
|
(100003, 100001, 'income', 84.15, 2580.00, 'LOL 钻石上分（扣佣）', 100001),
|
|
(100004, 100006, 'payment', -199.00, 202.00, 'LOL 大师冲击', 100002),
|
|
(100005, 100007, 'topup', 300.00, 300.00, '充值', null),
|
|
(100006, 100007, 'payment', -30.00, 270.00, 'LOL 排位陪玩', 100004),
|
|
(100007, 100001, 'income', 25.50, 2605.50, 'LOL 排位陪玩（扣佣）', 100004);
|