-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinserts.sql
More file actions
52 lines (49 loc) · 5.47 KB
/
inserts.sql
File metadata and controls
52 lines (49 loc) · 5.47 KB
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
-- admin
INSERT INTO admin (id) VALUES (1);
INSERT INTO total (id) VALUES (1);
-- currency
INSERT INTO currency (title, title_url, code, symbol) VALUES ('United States Dollar', 'united-states-dollar', 'usd', '$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Australia Dollar', 'australia-dollar', 'aud', '$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Bulgaria Lev', 'bulgaria-lev', 'bgn', 'лв');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Brazil Real', 'brazil-real', 'brl', 'R$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Canada Dollar', 'canada-dollar', 'cad', '$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Switzerland Franc', 'switzerland-franc', 'chf', 'CHF');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('China Yuan Renminbi', 'china-yuan-renminbi', 'cny', '¥');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Czech Republic Koruna', 'czech-republic-koruna', 'czk', 'Kč');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Denmark Krone', 'denmark-krone', 'dkk', 'kr');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Euro Member Countries', 'euro-member-countries', 'eur', '€');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('United Kingdom Pound', 'united-kingdom-pound', 'gbp', '£');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Hong Kong Dollar', 'hong-kong-dollar', 'hkd', '$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Croatia Kuna', 'croatia-kuna', 'hrk', 'kn');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Hungary Forint', 'hungary-forint', 'huf', 'Ft');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Indonesia Rupiah', 'indonesia-rupiah', 'idr', 'Rp');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Israel Shekel', 'israel-shekel', 'ils', '₪');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('India Rupee', 'india-rupee', 'inr', '₹');
INSERT INTO currency (title, title_url, code, symbol, multiplier_unit) VALUES ('Iceland Krona', 'iceland-krona', 'isk', 'kr', 1);
INSERT INTO currency (title, title_url, code, symbol, multiplier_unit) VALUES ('Japan Yen', 'japan-yen', 'jpy', '¥', 1);
INSERT INTO currency (title, title_url, code, symbol, multiplier_unit) VALUES ('South Korea Won', 'south-korea-won', 'krw', '₩', 1);
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Mexico Peso', 'mexico-peso', 'mxn', '$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Malaysia Ringgit', 'malaysia-ringgit', 'myr', 'RM');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Norway Krone', 'norway-krone', 'nok', 'kr');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('New Zealand Dollar', 'new-zealand-dollar', 'nzd', '$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Philippines Peso', 'philippines-peso', 'php', '₱');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Poland Zloty', 'poland-zloty', 'pln', 'zł');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Romania Leu', 'romania-leu', 'ron', 'lei');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Russia Ruble', 'russia-ruble', 'rub', '₽');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Sweden Krona', 'sweden-krona', 'sek', 'kr');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Singapore Dollar', 'singapore-dollar', 'sgd', '$');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Thailand Baht', 'thailand-baht', 'thb', '฿');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('Turkey Lira', 'turkey-lira', 'try', '₺');
INSERT INTO currency (title, title_url, code, symbol) VALUES ('South Africa Rand', 'south-africa-rand', 'zar', 'R');
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('BCH', 'bch', 'bch', 'Ƀ', TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('BSV', 'bsv', 'bsv', 'Ƀ', TRUE);
INSERT INTO currency (title, title_url, title_unit, code, symbol, symbol_unit, multiplier_unit, crypto) VALUES ('Bitcoin', 'bitcoin', 'bits', 'btc', '₿', NULL, 1000000, TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('Dash', 'dash', 'dash', 'Đ', TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('Digibyte', 'digibyte', 'dgb', 'Ɗ', TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('Dogecoin', 'dogecoin', 'doge', 'Đ', TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('ETC', 'etc', 'etc', 'Ξ', TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('Ethereum', 'ethereum', 'eth', 'Ξ', TRUE);
INSERT INTO currency (title, title_url, title_unit, code, symbol, symbol_unit, multiplier_unit, crypto) VALUES ('Litecoin', 'litecoin', 'lites', 'ltc', 'Ł', 'ł', 1000, TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('Monero', 'monero', 'xmr', 'ɱ', TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('Ripple', 'ripple', 'xrp', 'ɱ', TRUE);
INSERT INTO currency (title, title_url, code, symbol, crypto) VALUES ('Zcash', 'zcash', 'zec', 'ⓩ', TRUE);