sql

gistfile1.txt

INSERT INTO `lon_mining_powers` (`round`, `wallet_address`, `lon`, `acc_trader_fee`, `acc_trader_txs`, `trader_power`, `acc_referer_fee`, `acc_referer_txs`, `referer_power`, `start_block`, `end_block`, `invitee_power`, `invitee_lon`, `acc_maker_fee`, `acc_maker_txs`, `maker_power`, `tx_hash`, `phase`, `relayer_power`, `relayer_lon`, `acc_relayer_txs`)
VALUES
	(0, '0xe0f5069f617D99f9Ff40E96A36579A57890F6201', 0.000000000, 6.155428, 1, 131.995135, 0.000000, 0, 0.000000, 12333704, 12333704, 61.554280, 0.000000, 0.000000, 0, 0.000000, NULL, 1, 0.000000, 0.000000, 0),
	(0, '0xFe9941141b1D4eDa04A6BDb67735E00f3F983A9C', 0.000000000, 21.822680, 1, 293.438918, 0.000000, 0, 0.000000, 12333690, 12333690, 0.000000, 0.000000, 0.000000, 0, 0.000000, NULL, 1, 0.000000, 0.000000, 0);


update lon_mining_powers set relayer_power=16169063.787222, acc_relayer_txs=24408 where wallet_address='0x03f34be1bf910116595db1b11e9d1b2ca5d59659' and phase=1;

update lon_mining_powers set acc_maker_fee=258938.55588306, maker_power=2589385.5588306, acc_maker_txs=7188 where wallet_address='0x9c597c4da5e8f052182fe9b3d12af7e61e8d809b' and phase=1;


update lon_mining_powers set acc_trader_fee=45.163198, trader_power=949.115792, acc_trader_txs=3 where wallet_address='0xbCf2cae7da3873c93485e75DB7F9581dF7bC2F5c'  and phase=1;

update lon_mining_powers set acc_referer_fee=6.155428, referer_power=61.554280, acc_referer_txs=3 where wallet_address='0x7939BBF2De6B6DED89204859dB0967DDbAc9446e' and phase=1;


update lon_mining_powers set acc_trader_fee=12.807930, trader_power=458.040644, acc_trader_txs=3 where wallet_address='0x0c973Ae9e42363850c8fDd09a44DD739eD41Bdb1'  and phase=1;

update lon_mining_powers set acc_trader_fee=346.917236, trader_power=5759.180538, acc_trader_txs=16 where wallet_address='0xD14aae91C52E49c5dF52C01FD70Cbdf0806d16EB'  and phase=1;