-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathbitsync_data.sql
68 lines (66 loc) · 10.3 KB
/
bitsync_data.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
60
61
62
63
64
65
66
67
68
-- 初始化基础数据
insert into combo(name, price, sms_quantity) values
('套餐一', '1000', '40'),
('套餐二', '2000', '100'),
('套餐三', '5000', '300'),
('套餐四', '10000', '666');
insert into exchange(exchange_id, name_cn, name_en, official_website) values
(1, '火币网', 'huobi', 'https://www.huobipro.com'),
(2, '龙交所', 'dragonex', 'https://dragonex.im'),
(3, 'okex', 'okex', 'https://www.okex.com'),
(4, '币安', 'binance', 'https://www.binance.com'),
(5, 'gate', 'gate', 'https://gate.io'),
(6, 'bithumb', 'bithumb', 'https://www.bithumb.com');
insert into coin(name, name_cn, full_name, icoin, official_website, white_paper, issue_date, issue_amount, flow_amount, ico_price, blockchain_browser, introduction) values
('btc', '比特币', 'Bitcoin', '', 'https://bitcoin.org', '', '2009-01-03', 21000000, 0, '', '', ''),
('xrp', '瑞波币', 'Ripple', '', 'https://ripple.com', '', '2011-04-18', 100000000000, 100000000000, '', '', ''),
('eth', '以太坊', 'Ethereum', '', 'https://www.ethereum.org/', null, '2014-07-24', 963115000, 963115000, '', '', ''),
('bch', '比特现金', 'Bitcoin Cash', '', 'https://www.bitcoincash.org/', 'http://blockdozer.com/insight/', '2017-07-24', 21000000, 0, '', 'https://blockchair.com/bitcoin-cash/blocks', ''),
('eos', 'EOS', 'Enterprise Operation System', '', 'https://eos.io/', 'https://github.com/EOSIO/Documentation/blob/master/zh-CN/TechnicalWhitePaper.md', '2017-07-02', 1000000000, 536000000, '', 'https://etherscan.io/token/EOS', ''),
('ltc', '莱特币', 'Litecoin', '', 'https://litecoin.com/', '', '2011-11-09', 84000000, 54282600, '', 'http://explorer.litecoin.net/chain/Litecoin', ''),
('ada', '卡尔达诺', 'Cardano', '', 'https://cardanofoundation.org', 'https://whycardano.com/', '2017-10-02', 45000000000, 31112484646, '', 'https://cardanoexplorer.com', ''),
('neo', '小蚁', 'NEO', '', 'https://neo.org', 'http://docs.neo.org/zh-cn/', '2014-06-01', 100000000, 65000000, '', 'https://neotracker.io/', ''),
('trx', '波场', 'Tron', '', 'https://tron.network', 'https://etherscan.io/address/0xf230b790e05390fc8295f4d3f60332c93bed42e2', '2017-09-14', 100000000000, 65748192475, '', 'https://dn-peiwo-web.qbox.me/Tron-Whitepaper-1008-V19-5.pdf', ''),
('dash', '达世币', 'Dash', '', 'https://www.dash.org/', 'https://dashpay.atlassian.net/wiki/spaces/DOC/pages/5472261/Whitepaper', '2014-01-18', 18900000, 7750400, '', 'https://chainz.cryptoid.info/dash', ''),
('etc', '以太经典', 'Ethereum Classic', '', 'https://ethereumclassic.github.io/', '', '2015-11-01', 98336600, 98336600, '', 'http://gastracker.io/', ''),
('ht', '火币全球通用积分', 'Huobi Token', '', 'https://www.huobipro.com/', '', '2018-01-24', 500000000, 300000000, '', 'https://etherscan.io/address/0x6f259637dcd74c767781e37bc6133cd6a68aa161', ''),
('ven', '唯链', 'Vechain', '', 'https://www.vechain.com/', 'https://cdn.vechain.com/vechain_ico_ideas_of_development_cn.pdf', '2017-08-23', 1000000000, 277100000, '', 'https://etherscan.io/token/0xd850942ef8811f2a866692a623011bde52a462c1', ''),
('qtum', '量子链', 'Qtum Blockchain', '', 'https://www.qtum.org/', 'https://www.qtum.org/zh/white-papers', '2017-03-16', 100286796, 73786796, '', 'https://qtum.info/', ''),
('ae', 'AE', 'Aeternity', '', 'https://aeternity.com/', 'https://github.com/aeternity/protocol', null, 0, 0, '', 'https://etherscan.io/address/0x5ca9a71b1d01849c0a95490cc00559717fcf0d1d', ''),
('iost', 'IOST', 'Internet of Services', '', 'http://iost.io/', 'https://docsend.com/view/ihwqcdg', '2018-01-11', 21000000000, 11000000000, '', 'https://etherscan.io/address/0xfa1a856cfa3409cfa145fa4e20eb270df3eb21ab', ''),
('wicc', '维基链', 'waykichain', '', 'http://www.waykichain.net/', '', '2018-01-05', 210000000, 140000000, '', 'http://47.106.77.165:8080/', ''),
('omg', 'OMG', 'OmiseGO', '', 'https://omg.omise.co/', 'https://cdn.omise.co/omg/whitepaper.pdf', '2017-06-27', 140245400, 102042600, '', 'https://etherscan.io/token/OmiseGo%20%20https://ethplorer.io/address/0xd26114cd6ee289accf82350c8d8487fedb8a0c07', ''),
('zec', 'ZEC', 'Zcash', '', 'https://z.cash/', 'http://zerocash-project.org/media/pdf/zerocash-extended-20140518.pdf', '2016-10-28', 2825100, 2825100, '', 'https://explorer.zcha.in/', ''),
('soc', 'SOC', 'All Sports Blockchain', '', 'https://www.allsportschain.com/', 'https://www.allsportschain.com/paper/all_sports_blockchain_open_platform_white_paper_zh-tw.pdf', '2018-1-26', 1500000000, 600000000, '', 'https://etherscan.io/address/0x2d0e95bd4795d7ace0da3c0ff7b706a5970eb9d3', ''),
('btm', '比原链', 'Bytom', '', 'http://bytom.io', 'http://bytom.io/BytomWhitePaperV1.0_Economic.pdf', '2017-08-09', 2100000000, 987000000, '', 'https://etherscan.io/token/0xcb97e65f07da24d46bcdd078ebebd7c6e6e3d750', ''),
('zil', 'ZIL', 'Zilliqa', '', 'https://www.zilliqa.com', 'https://docs.zilliqa.com/whitepaper.pdf', '2018-01-25', 21000000000, 0, '', 'https://etherscan.io/address/0x05f4a42e251f2d52b8ed15E9FEdAacFcEF1FAD27', ''),
('hsr', 'HSR', 'Hshare', '', 'https://h.cash', 'https://h.cash/themes/zh-cn/dist/pdf/HcashWhitepaper-Rev0.8.1.pdf', '2017-08-21', 84000000, 42000000, '', 'http://explorer.h.cash/', ''),
('theta', 'THETA', 'Theta', '', 'https://www.thetatoken.org/', 'https://s3.us-east-2.amazonaws.com/assets.thetatoken.org/Theta-white-paper-latest.pdf', '2018-01-15', 1000000000, 618750000, '', 'https://etherscan.io/address/0x3883f5e181fccaf8410fa61e12b59bad963fb645', ''),
('elf', 'ELF', 'Ælf', '', 'http://aelf.io/', 'https://grid.hoopox.com/aelf_whitepaper_ZH.pdf?v=1', '2017-12-21', 1000000000, 260000000, '', '', ''),
('steem', 'STEEM', 'Steem', '', 'https://steem.io/', 'https://smt.steem.io/smt-whitepaper.pdf', '2016-03-24', 271352720, 254378626, '', 'https://steemd.com/', ''),
('hb10', 'HB10', 'HB10', '', 'https://www.huobipro.com', '', '2018-06-11', 0, 0, '', '', ''),
('dta', 'DTA', 'DATA', '', 'https://www.data.eco', 'https://docsend.com/view/pk5w8wx', '2018-01-17', 11500000000, 0, '', 'https://etherscan.io/address/0x69b148395ce0015c13e36bffbad63f49ef874e03', ''),
('act', 'ACT', 'Achain', '', 'https://www.achain.com/', 'https://www.achain.com/Achain%20Whitepaper%202.0_CHS.pdf', '2017-08-27', 21000000, 0, '', 'https://browser.achain.com/', ''),
('itc', '万物链', 'IoT Chain', '', 'https://iotchain.io/', 'https://iotchain.io/whitepaper/ITCWHITEPAPER.pdf', '2017-12-01', 100000000, 50000000, '', '', ''),
('ocn', 'OCN', 'Odyssey', '', 'http://www.ocoins.cc', 'http://www.ocoins.cc/pdf/ODYSSEY+WHITEPAPER+V1.3+EN.pdf?v=2018020703', '2018-01-29', 10000000000, 0, '', 'https://etherscan.io/address/0x4092678e4E78230F46A1534C0fbc8fA39780892B', ''),
('ela', '亦来云', 'Elastos', '', 'https://www.elastos.org/', 'https://www.elastos.org/static/file/elastos_whitepaper_0.2.pdf', '2018-01-29', 33379033, 4964975, '', 'https://blockchain.elastos.org/', ''),
('nas', '星云币', 'Nebulas', '', 'https://nebulas.io/cn/', 'https://nebulas.io/docs/NebulasTechnicalWhitepaperZh.pdf', null, 100000000, 300000000, '', '', ''),
('mds', 'MDS', 'MediShares', '', 'http://www.medishares.org/cn/', 'http://doc.medishares.org/whitepaper/MediShares.Whitepaper.CN.pdf', '2017-12-13', 2000000000, 1000000000, '', '', ''),
('cmt', 'CMT', 'CyberMiles', '', 'https://cm.5miles.com/zh-tw', 'https://cm.5miles.com/file/project/Project%20white%20paper_zh-tw.pdf', '2017-12-07', 1000000000, 450000000, '', '', ''),
('bts', '比特股', 'BitShares', '', 'https://bitshares.org', 'http://docs.bitshares.org/bitshares/index.html', '2014-07-19', 3600000000, 2600000000, '', 'http://www.cryptofresh.com', ''),
('ctxc', 'CTXC', 'Cortex', '', 'http://cortexlabs.ai/', 'http://cortexlabs.ai/Cortex_AI_on_Blockchain_EN.pdf', null, 299792458, 149792458, '', 'https://etherscan.io/address/0xEa11755Ae41D889CeEc39A63E6FF75a02Bc1C00d', ''),
('let', 'LET', 'LinkEye Token', '', 'https://www.linkeye.com', 'https://www.linkeye.com/static/whitePaper/LinkEye201710.pdf', '2018-01-16', 1000000000, 0, '', 'https://browser.achain.com/', ''),
('cvc', 'CVC', 'Civic', '', 'https://www.civic.com/', 'https://tokensale.civic.com/CivicTokenSaleWhitePaper.pdf', '2017-07-18', 1000000000, 342700000, '', 'https://etherscan.io/token/civic', ''),
('gnt', 'GNT', 'Golem', '', 'https://golem.network/', 'https://golem.network/doc/Golemwhitepaper.pdf', '2016-11-11', 1000000000, 833032000, '', 'https://etherscan.io/address/0xa74476443119a942de498590fe1f2454d7d4ac0d', ''),
('xem', '新经币', 'XEM', '', 'https://nem.io/', 'https://nem.io/wp-content/themes/nem/files/NEM_techRef.pdf', '2014-01-19', 9000000000, 9000000000, '', 'http://chain.nem.ninja/', ''),
('storj', 'STORJ', 'Storj', '', 'https://storj.io/tokensale.html', 'https://storj.io/storj.pdf', '2017-07-03', 425000000, 105413700, '', 'https://etherscan.io/address/0xb64ef51c888972c908cfacf59b47c1afbc0ab8ac', ''),
('smt', 'SMT', 'Smartmesh', '', 'https://smartmesh.io/zh/', 'https://smartmesh.io/SmartMeshWhitePaperZH.pdf', '2017-12-13', 3140000000, 1410000000, '', 'https://etherscan.io/token/0x21f15966e07a10554c364b988e91dab01d32794a', ''),
('dt', '龙币', 'Dragon Token', '', 'https://dragonex.im/', '', '2017-11-02', 37339500, 37339500, '', '', ''),
('cht', 'CHT', 'CoinHot Token', '', 'https://www.coinhot.io/', '', '2017-12-30', 369280000, 369280000, '', '', ''),
('safe', '安网3', 'SAFE', '', 'https://www.anwang.com/', 'https://www.anwang.com/download/aw3_bps.pdf', '2017-01-20', 37000000, 26000000, '', '', ''),
('gas', '比特币', 'NeoGas', '', 'https://neo.org/', '', '2009-01-03', 1000000000, 9137000, '', 'https://neotracker.io/asset/602c79718b16e442de58778e148d0b1084e3b2dffd5de6b7b16cee7969282de7',''),
('icx', 'ICON', 'ICON', '', 'https://icon.foundation/cn/', 'http://docs.icon.foundation/ICON-Whitepaper-EN-Draft.pdf', '2017-10-28', 400230000, 378545005, '', 'https://etherscan.io/token/0xb5a5f22694352c15b00323844ad545abb2b11028', ''),
('knc', 'KNC', 'Kyber Network', '', 'https://kyber.network/', 'https://kyber.network/assets/KyberNetworkWhitepaper.pdf', '2017-09-25', 226000000, 134132700, '', 'https://etherscan.io/token/KyberNetwork', ''),
('abt', '区块基石', 'ArcBlock', '', 'https://arcblock.io', 'https://www.arcblock.io/file/whitepaper/WhitePaperEnV2_en-US.pdf?v=4', '2018-02-25', 186000000, 0, '', 'https://etherscan.io/address/0xb98d4c97425d9908e66e53a6fdf673acca0be986', ''),
('lrc', '路印', 'Loopring', '', 'http://loopring.org/', 'https://github.com/Loopring/whitepaper/raw/master/zh_whitepaper.pdf', '2009-01-03', 1395076054, 0, '', '', ''),
('usdt', '泰达币', 'Tether USD', '', 'https://tether.to/', '', '2014-11-15', 0, 0, '', '', '');