-
Notifications
You must be signed in to change notification settings - Fork 7
/
db_currency_sample.sql
59 lines (58 loc) · 17.7 KB
/
db_currency_sample.sql
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
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
INSERT INTO `currency` (`uid`, `currency_code`, `currency_name`, `enabled`, `payout_fee`, `project_fee`, `api_url`, `url_wallet`, `url_tx`, `img_url`, `payment_id_field`, `rate_per_mhash`, `btc_per_coin`, `user_withdraw_note`, `admin_withdraw_note`, `timestamp`) VALUES
(1, 'DOGE', 'Dogecoin', 1, 0.5, 0, 'https://api.coingecko.com/api/v3/coins/dogecoin', 'https://dogechain.info/address/', 'https://dogechain.info/tx/', 'https://assets.coingecko.com/coins/images/5/thumb/dogecoin.png?1547792256', 0, 0.77211796624739, 0.00000051108795656559, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:04'),
(2, 'GRC', 'Gridcoin', 1, 0.0001, 0, 'https://api.coingecko.com/api/v3/coins/gridcoin-research', 'https://www.gridcoinstats.eu/address/', 'https://www.gridcoinstats.eu/tx/', 'https://assets.coingecko.com/coins/images/243/thumb/gridcoin.png?1547034012', 0, 0.32929381301345, 0.0000011983832613972, 'Withdraws are automatic, sent in 30 minutes', 'Exchange: Bittrex, Sender: Automated', '2019-03-17 18:37:04'),
(3, 'XMR', 'Monero', 1, 0.00005, 0, 'https://api.coingecko.com/api/v3/coins/monero', '', 'https://moneroblocks.info/tx/', 'https://assets.coingecko.com/coins/images/69/thumb/monero_logo.png?1547033729', 1, 0.000029999999999999, 0.013154006453232, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:04'),
(4, 'LTC', 'Litecoin', 1, 0.0001, 0, 'https://api.coingecko.com/api/v3/coins/litecoin', 'https://live.blockcypher.com/ltc/address/', 'https://live.blockcypher.com/ltc/tx/', 'https://assets.coingecko.com/coins/images/2/thumb/litecoin.png?1547033580', 0, 0.000025904728876888, 0.015233519542798, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:04'),
(5, 'BTC', 'Bitcoin', 1, 0.00005, 0, 'https://api.coingecko.com/api/v3/coins/bitcoin', 'https://bitinfocharts.com/bitcoin/address/', 'https://bitinfocharts.com/bitcoin/tx/', 'https://assets.coingecko.com/coins/images/1/thumb/bitcoin.png?1547033579', 0, 0.00000039462019359696, 1, 'Personally I think you never reach withdraw amount', '', '2019-03-17 18:37:04'),
(8, 'BURST', 'Burst', 1, 0.01, 0, 'https://api.coingecko.com/api/v3/coins/burst', '', 'https://explore.burst.cryptoguru.org/transaction/', 'https://assets.coingecko.com/coins/images/154/thumb/burst.png?1547564133', 0, 0.37201918757188, 0.0000010607522589697, 'Withdraws are automatic, sent in 30 minutes', '', '2019-03-17 18:37:05'),
(12, 'GAS', 'Gas', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/gas', '', 'https://neoscan.io/transaction/', 'https://assets.coingecko.com/coins/images/858/thumb/gas.png?1547034659', 0, 0.00058192535506013, 0.000678128543748, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(13, 'XRP', 'Ripple', 1, 0.000012, 0, 'https://api.coingecko.com/api/v3/coins/ripple', 'https://xrpcharts.ripple.com/#/graph/', 'https://xrpcharts.ripple.com/#/graph/', 'https://assets.coingecko.com/coins/images/44/thumb/XRP.png?1547033685', 1, 0.0049869371525976, 0.000079130773362846, '<span style=''color:red;font-weight:bold;''>Please note, withdraws below 20 XRP<br>require existing Ripple address<br>with positive balance.<br>Withdraws to nonexistent addresses<br>will be cancelled with refund</span>', '', '2019-03-17 18:37:05'),
(57, 'TRX', 'Tron', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/tron', 'https://tronscan.org/#/address/', 'https://tronscan.org/#/transaction/', 'https://assets.coingecko.com/coins/images/1094/thumb/tron-logo.png?1547035066', 0, 0.068557747163066, 0.0000057560262687505, 'Withdraws are automatic, sent in 30 minutes', '', '2019-03-17 18:37:05'),
(46, 'XLM', 'Stellar', 1, 0.00001, 0, 'https://api.coingecko.com/api/v3/coins/stellar', 'https://stellarchain.io/address/', 'https://stellarchain.io/tx/', 'https://assets.coingecko.com/coins/images/100/thumb/Stellar_symbol_black_RGB.png?1552356157', 1, 0.014509966456364, 0.000027196492478718, '<span style=''color:red;font-weight:bold;''>Please note, withdraws below 1 XLM<br>require existing stellar address<br>with positive balance.<br>Withdraws to nonexistent addresses<br>will be cancelled with refund</span>', '', '2019-03-17 18:37:05'),
(70, 'DGB', 'DigiByte', 1, 0.1, 0, 'https://api.coingecko.com/api/v3/coins/digibyte', '', '', 'https://assets.coingecko.com/coins/images/63/thumb/digibyte.png?1547033717', 0, 0.10979136499516, 0.0000035942734987798, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(104, 'GBYTE', 'ByteBall', 1, 0.000001, 0, 'https://api.coingecko.com/api/v3/coins/byteball', 'https://explorer.byteball.org/#', 'https://explorer.byteball.org/#', 'https://assets.coingecko.com/coins/images/561/thumb/byteball.png?1547564361', 0, 0.000040490726763859, 0.00974594, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(105, 'BAN', 'Banano', 1, 0.01, 0, 'https://api.coingecko.com/api/v3/coins/banano', 'https://creeper.banano.cc/explorer/account/', 'https://creeper.banano.cc/explorer/block/', 'https://assets.coingecko.com/coins/images/6226/thumb/5WdpYmfA.jpeg?1547042258', 0, 2.0545345697949, 0.00000019207279322458, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(106, 'RDD', 'Reddcoin', 1, 0.01, 0, 'https://api.coingecko.com/api/v3/coins/reddcoin', 'https://live.reddcoin.com/address/', 'https://live.reddcoin.com/tx/', 'https://assets.coingecko.com/coins/images/40/thumb/reddcoin.png?1547033681', 0, 1.2342831531653, 0.00000031971609803225, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(107, 'NANO', 'Nano', 1, 0.0001, 0, 'https://api.coingecko.com/api/v3/coins/nano', '', '', 'https://assets.coingecko.com/coins/images/756/thumb/nano-coin-logo.png?1547034501', 0, 0.001535538430365, 0.00025699141473337, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(108, 'GRLC', 'Garlicoin', 1, 0.01, 0, 'https://api.coingecko.com/api/v3/coins/garlicoin', '', '', 'https://assets.coingecko.com/coins/images/2699/thumb/garlicoin.png?1548126827', 0, 0.49703124823678, 0.00000079395449480667, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(109, 'ETN', 'Electroneum', 1, 0.01, 0, 'https://api.coingecko.com/api/v3/coins/electroneum', '', '', 'https://assets.coingecko.com/coins/images/1109/thumb/electroneum.png?1547224846', 0, 0.24296701395871, 0.0000016241718872341, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(119, 'VITAE', 'Vitae', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/vitae', '', '', 'https://assets.coingecko.com/coins/images/5504/thumb/vitae.png?1548760073', 0, 0.0036832407991621, 0.00010713939574266, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:05'),
(110, 'BTX', 'Bitcore', 1, 0.1, 0, 'https://api.coingecko.com/api/v3/coins/bitcore', '', '', 'https://assets.coingecko.com/coins/images/680/thumb/bitcore.png?1547034432', 0, 0.0064297582191414, 0.000061374033073619, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(111, 'WOW', 'Wownero', 1, 2, 0, 'https://api.coingecko.com/api/v3/coins/wownero', '', '', 'https://assets.coingecko.com/coins/images/6103/thumb/wownero.png?1547042103', 1, 0.17856117357329, 0.00000221, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(112, 'FSC', 'FriendshipCoin', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/friendshipcoin', 'https://explore.friendshipcoin.com/address/', 'https://explore.friendshipcoin.com/tx/', 'https://assets.coingecko.com/coins/images/4743/thumb/friendshipcoin-logo.png?1547040055', 0, 19.731009679848, 0.00000002, 'Withdraws suspended, waiting for coin swap', '', '2019-03-17 18:37:05'),
(113, 'SHND', 'StrongHands', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/stronghands', 'https://www.coinexplorer.net/SHND/address/', 'https://www.coinexplorer.net/SHND/transaction/', 'https://assets.coingecko.com/coins/images/859/thumb/stronghands-home-logo-1.png?1547034661', 0, 22110.019669899, 0.000000000017848025442248, 'Withdraws are automatic, sent in 30 minutes', '', '2019-03-17 18:37:05'),
(114, 'BCN', 'Bytecoin', 1, 1, 0, 'https://api.coingecko.com/api/v3/coins/bytecoin', '', 'https://explorer.bytecoin.org/tx?hash=', 'https://assets.coingecko.com/coins/images/92/thumb/bytecoin-logo.png?1547033763', 1, 1.982272059277, 0.00000019907468894098, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(115, 'ADA', 'Cardano', 1, 0.2, 0, 'https://api.coingecko.com/api/v3/coins/cardano', '', '', 'https://assets.coingecko.com/coins/images/975/thumb/cardano.png?1547034860', 0, 0.031092406284318, 0.0000126918511867, '', '', '2019-03-17 18:37:05'),
(116, 'JSE', 'JSEcoin', 1, 31, 0, 'https://api.coingecko.com/api/v3/coins/jsecoin', 'https://etherscan.io/address/', 'https://etherscan.io/tx/', 'https://assets.coingecko.com/coins/images/6480/thumb/icon400.png?1547042701', 0, 1.8791443713965, 0.00000020999993380163, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(117, 'MNX', 'MinexCoin', 1, 0.001, 0, 'https://api.coingecko.com/api/v3/coins/minexcoin', 'https://minexexplorer.com/address?hash=', 'https://minexexplorer.com/transactions/view?hash=', 'https://assets.coingecko.com/coins/images/1111/thumb/minexcoin.png?1548085060', 0, 0.0058876802889952, 0.000067024732021294, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:05'),
(118, 'CLO', 'Callisto', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/callisto', 'https://explorer.callisto.network/account/', 'https://explorer.callisto.network/tx/', 'https://assets.coingecko.com/coins/images/4051/thumb/OTnvoGWF_400x400.jpg?1547039186', 0, 0.38734138194399, 0.0000010187917222179, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(120, 'XMY', 'Myriad', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/myriadcoin', '', '', 'https://assets.coingecko.com/coins/images/66/thumb/myriadcoin.png?1547033722', 0, 1.1045741567966, 0.00000035726002746744, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(121, 'PINK', 'PinkCoin', 1, 0.0001, 0, 'https://api.coingecko.com/api/v3/coins/pinkcoin', 'https://chainz.cryptoid.info/pink/address.dws?', 'https://chainz.cryptoid.info/pink/tx.dws?', 'https://assets.coingecko.com/coins/images/102/thumb/pinkcoin.png?1547033777', 0, 0.89249775212566, 0.00000044215259103689, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(122, 'PAC', 'PACCoin', 1, 10, 0, 'https://api.coingecko.com/api/v3/coins/paccoin', 'http://usa.pacblockexplorer.com:3002/address/', 'http://usa.pacblockexplorer.com:3002/tx/', 'https://assets.coingecko.com/coins/images/808/thumb/paccoin.png?1548330452', 0, 2.144703850293, 0.00000018399752186906, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(123, 'VET', 'VeChain', 1, 3, 0, 'https://api.coingecko.com/api/v3/coins/vechain', '', '', 'https://assets.coingecko.com/coins/images/1167/thumb/VeChain-Logo-768x725.png?1547035194', 0, 0.30088630751057, 0.0000013115259277231, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(124, 'VTHO', 'VeThor Token', 1, 60, 0, 'https://api.coingecko.com/api/v3/coins/vethor-token', '', '', 'https://assets.coingecko.com/coins/images/5230/thumb/vethor-token.png?1548760043', 0, 1.9860280099204, 0.00000019869820144822, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(125, 'TKS', 'Tokes', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/tokes', '', '', 'https://assets.coingecko.com/coins/images/1248/thumb/tokes-platform-token-logo.png?1547035273', 0, 0.0047763276881743, 0.00008262, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:06'),
(126, 'STEEM', 'Steem', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/steem', '', '', 'https://assets.coingecko.com/coins/images/398/thumb/steem.png?1547034126', 1, 0.0033379241426489, 0.00011822323597917, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(127, 'SBD', 'Steem Dollars', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/steem-dollars', '', '', 'https://assets.coingecko.com/coins/images/652/thumb/steem_dollars.png?1547034385', 1, 0.0015315138918621, 0.00025766674118585, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(128, 'ONION', 'DeepOnion', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/deeponion', 'http://explorer.deeponion.org/address/', 'explorer.deeponion.org/tx/', 'https://assets.coingecko.com/coins/images/1148/thumb/DeepOnion-coin.png?1547035159', 1, 0.0058433342552552, 0.000067533393839666, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(129, 'ETH', 'Ethereum', 1, 0.000021, 0, 'https://api.coingecko.com/api/v3/coins/ethereum', 'https://etherscan.io/address/', 'https://etherscan.io/tx/', 'https://assets.coingecko.com/coins/images/279/thumb/ethereum.png?1547034048', 0, 0.000011325504434984, 0.034843498217879, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(130, 'ETC', 'Ethereum Classic', 1, 0.000021, 0, 'https://api.coingecko.com/api/v3/coins/ethereum-classic', '', '', 'https://assets.coingecko.com/coins/images/453/thumb/ethereum-classic-logo.png?1547034169', 0, 0.00035667640914675, 0.0011063815365333, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(131, 'LINDA', 'Linda', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/linda', '', '', 'https://assets.coingecko.com/coins/images/782/thumb/linda.png?1547975972', 0, 5.2699615657699, 0.000000074881038252755, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(132, 'XVG', 'Verge', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/verge', '', '', 'https://assets.coingecko.com/coins/images/203/thumb/verge.png?1547033961', 0, 0.22395645156207, 0.0000017620398557154, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:06'),
(133, 'TEL', 'Telcoin', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/telcoin', '', '', 'https://assets.coingecko.com/coins/images/1899/thumb/tel.png?1547036203', 0, 3.1810406116727, 0.00000012405380558454, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:06'),
(134, 'DCC', 'Distributed Credit Chain', 1, 20, 0, 'https://api.coingecko.com/api/v3/coins/distributed-credit-chain', 'https://etherscan.io/address/', 'https://etherscan.io/tx/', 'https://assets.coingecko.com/coins/images/4820/thumb/dcc-logo.png?1547040189', 0, 1.1655027535604, 0.00000033858366476739, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(135, 'SHMN', 'StrongHands Masternode', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/stronghands-masternode', '', '', 'https://assets.coingecko.com/coins/images/5593/thumb/shmn.png?1547698160', 0, 0.0050268328107784, 0.000078502748838359, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:06'),
(138, 'GAME', 'GameCredits', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/gamecredits', '', '', 'https://assets.coingecko.com/coins/images/193/thumb/gamecredits.png?1548126763', 0, 0.015775860575196, 0.000025014178574665, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:07'),
(136, 'WEB', 'Webchain', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/webchain', '', '', 'https://assets.coingecko.com/coins/images/5127/thumb/webchain-logo.png?1547040516', 0, 1.1274862674199, 0.00000035, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:07'),
(137, 'BBP', 'BiblePay', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/biblepay', '', '', 'https://assets.coingecko.com/coins/images/928/thumb/bible.png?1547034776', 0, 7.8924038719392, 0.00000005, 'Withdraw takes up to 24h', '', '2019-03-17 18:37:07'),
(139, 'ZEN', 'Horizen', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/zencash', '', '', 'https://assets.coingecko.com/coins/images/691/thumb/NHatlQGR_400x400.jpg?1547034452', 0, 0.00024701329050741, 0.0015975666442333, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:08'),
(140, 'EXP', 'Expanse', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/expanse', 'https://explorer.expanse.tech/account/', 'https://explorer.expanse.tech/tx/0x', 'https://assets.coingecko.com/coins/images/339/thumb/expanse.png?1548125867', 0, 0.015286242882218, 0.000025815381623695, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:09'),
(141, 'XMG', 'Magi', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/magi', '', '', 'https://assets.coingecko.com/coins/images/176/thumb/magi.png?1547033909', 0, 0.11581050913536, 0.0000034074644567508, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:10'),
(142, 'MOON', 'MoonCoin', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/mooncoin', '', '', 'https://assets.coingecko.com/coins/images/294/thumb/moon.png?1547034067', 0, 157.77877309703, 0.0000000025010981252484, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:10'),
(143, 'SPRTS', 'Sprouts', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/sprouts', '', '', 'https://assets.coingecko.com/coins/images/435/thumb/xTEzjFG.png?1547034157', 0, 44069.976056124, 0.0000000000089544, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:11'),
(144, 'SSX', 'StakeShare', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/stakeshare', '', '', 'https://assets.coingecko.com/coins/images/6835/thumb/DQwMMCZh_400x400.jpg?1547043147', 0, 0.092221413062848, 0.0000042790516919105, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:12'),
(145, 'LINX', 'Linx', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/linx', '', '', 'https://assets.coingecko.com/coins/images/1276/thumb/linx.png?1547975985', 0, 0.77376508548424, 0.00000051, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:12'),
(146, 'BEAN', 'BeanCash', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/bean-cash', '', '', 'https://assets.coingecko.com/coins/images/254/thumb/bitbean.png?1547034024', 0, 1.715692095012, 0.00000023000641825199, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:13'),
(147, 'PHR', 'Phore', 1, 0, 0, 'https://api.coingecko.com/api/v3/coins/phore', '', '', 'https://assets.coingecko.com/coins/images/1129/thumb/phore.png?1548331050', 0, 0.010333076553992, 0.00003819, 'That coin never requested before. Withdraw can take several days.', '', '2019-03-17 18:37:14');