aboutsummaryrefslogtreecommitdiffhomepage
path: root/src/dbx/sql/last.sql
blob: fa2adbb62bb638e439fc5447d01139975f996b3a (plain) (blame)
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
DELETE FROM mintages_s;
DELETE FROM mintages_c;

INSERT INTO mintages_s (
	country,
	type,
	year,
	denomination,
	mintmark,
	mintage,
	reference
) VALUES
	('at', 0, 2017, 0.01, NULL, 37700000, NULL),
	('at', 0, 2017, 0.02, NULL, 57200000, NULL),
	('at', 0, 2017, 0.05, NULL, 35200000, NULL),
	('at', 0, 2017, 0.10, NULL, 39500000, NULL),
	('at', 0, 2017, 0.20, NULL, 30000000, NULL),
	('at', 0, 2017, 0.50, NULL, 15000000, NULL),
	('at', 0, 2017, 1.00, NULL, 8000000, NULL),
	('at', 0, 2017, 2.00, NULL, 17700000, NULL),
	('de', 0, 2017, 0.01, 'A', 81600000, NULL),
	('de', 0, 2017, 0.02, 'A', 72200000, NULL),
	('de', 0, 2017, 0.05, 'A', 30000000, NULL),
	('de', 0, 2017, 0.10, 'A', 25200000, NULL),
	('de', 0, 2017, 0.20, 'A', 21600000, NULL),
	('de', 0, 2017, 0.50, 'A', 0, NULL),
	('de', 0, 2017, 1.00, 'A', 0, NULL),
	('de', 0, 2017, 2.00, 'A', 18120000, NULL),
	('de', 0, 2017, 0.01, 'D', 85680000, NULL),
	('de', 0, 2017, 0.02, 'D', 75810000, NULL),
	('de', 0, 2017, 0.05, 'D', 31500000, NULL),
	('de', 0, 2017, 0.10, 'D', 26460000, NULL),
	('de', 0, 2017, 0.20, 'D', 22680000, NULL),
	('de', 0, 2017, 0.50, 'D', 0, NULL),
	('de', 0, 2017, 1.00, 'D', 0, NULL),
	('de', 0, 2017, 2.00, 'D', 19110000, NULL),
	('ad', 0, 2014, 0.01, NULL, 60000, NULL),
	('ad', 0, 2014, 0.02, NULL, 60000, NULL),
	('ad', 0, 2014, 0.05, NULL, 860000, NULL),
	('ad', 0, 2014, 0.10, NULL, 860000, NULL),
	('ad', 0, 2014, 0.20, NULL, 860000, NULL),
	('ad', 0, 2014, 0.50, NULL, 340000, NULL),
	('ad', 0, 2014, 1.00, NULL, 511843, NULL),
	('ad', 0, 2014, 2.00, NULL, 360000, NULL),
	('ad', 0, 2015, 0.01, NULL, 0, NULL),
	('ad', 0, 2015, 0.02, NULL, 0, NULL),
	('ad', 0, 2015, 0.05, NULL, 0, NULL),
	('ad', 0, 2015, 0.10, NULL, 0, NULL),
	('ad', 0, 2015, 0.20, NULL, 0, NULL),
	('ad', 0, 2015, 0.50, NULL, 0, NULL),
	('ad', 0, 2015, 1.00, NULL, 0, NULL),
	('ad', 0, 2015, 2.00, NULL, 1072400, NULL),
	('ad', 0, 2016, 0.01, NULL, 0, NULL),
	('ad', 0, 2016, 0.02, NULL, 0, NULL),
	('ad', 0, 2016, 0.05, NULL, 0, NULL),
	('ad', 0, 2016, 0.10, NULL, 0, NULL),
	('ad', 0, 2016, 0.20, NULL, 0, NULL),
	('ad', 0, 2016, 0.50, NULL, 0, NULL),
	('ad', 0, 2016, 1.00, NULL, 2339200, NULL),
	('ad', 0, 2016, 2.00, NULL, 0, NULL),
	('ad', 0, 2017, 0.01, NULL, 2582395, NULL),
	('ad', 0, 2017, 0.02, NULL, 1515000, NULL),
	('ad', 0, 2017, 0.05, NULL, 2191421, NULL),
	('ad', 0, 2017, 0.10, NULL, 1103000, NULL),
	('ad', 0, 2017, 0.20, NULL, 1213000, NULL),
	('ad', 0, 2017, 0.50, NULL, 968800, NULL),
	('ad', 0, 2017, 1.00, NULL, 17000, NULL),
	('ad', 0, 2017, 2.00, NULL, 794588, NULL),
	('ad', 0, 2018, 0.01, NULL, 2430000, NULL),
	('ad', 0, 2018, 0.02, NULL, 2550000, NULL),
	('ad', 0, 2018, 0.05, NULL, 1800000, NULL),
	('ad', 0, 2018, 0.10, NULL, 980000, NULL),
	('ad', 0, 2018, 0.20, NULL, 1014000, NULL),
	('ad', 0, 2018, 0.50, NULL, 890000, NULL),
	('ad', 0, 2018, 1.00, NULL, 0, NULL),
	('ad', 0, 2018, 2.00, NULL, 868000, NULL),
	('ad', 0, 2019, 0.01, NULL, 2447000, NULL),
	('ad', 0, 2019, 0.02, NULL, 1727000, NULL),
	('ad', 0, 2019, 0.05, NULL, 2100000, NULL),
	('ad', 0, 2019, 0.10, NULL, 1610000, NULL),
	('ad', 0, 2019, 0.20, NULL, 1570000, NULL),
	('ad', 0, 2019, 0.50, NULL, 930000, NULL),
	('ad', 0, 2019, 1.00, NULL, 0, NULL),
	('ad', 0, 2019, 2.00, NULL, 1058310, NULL),
	('ad', 0, 2020, 0.01, NULL, 0, NULL),
	('ad', 0, 2020, 0.02, NULL, 0, NULL),
	('ad', 0, 2020, 0.05, NULL, 0, NULL),
	('ad', 0, 2020, 0.10, NULL, 860000, NULL),
	('ad', 0, 2020, 0.20, NULL, 175000, NULL),
	('ad', 0, 2020, 0.50, NULL, 740000, NULL),
	('ad', 0, 2020, 1.00, NULL, 0, NULL),
	('ad', 0, 2020, 2.00, NULL, 1500000, NULL),
	('ad', 0, 2021, 0.01, NULL, 200000, NULL),
	('ad', 0, 2021, 0.02, NULL, 700000, NULL),
	('ad', 0, 2021, 0.05, NULL, 0, NULL),
	('ad', 0, 2021, 0.10, NULL, 1400000, NULL),
	('ad', 0, 2021, 0.20, NULL, 1420000, NULL),
	('ad', 0, 2021, 0.50, NULL, 600000, NULL),
	('ad', 0, 2021, 1.00, NULL, 50000, NULL),
	('ad', 0, 2021, 2.00, NULL, 1474500, NULL),
	('ad', 0, 2022, 0.01, NULL, 700000, NULL),
	('ad', 0, 2022, 0.02, NULL, 450000, NULL),
	('ad', 0, 2022, 0.05, NULL, 400000, NULL),
	('ad', 0, 2022, 0.10, NULL, 700000, NULL),
	('ad', 0, 2022, 0.20, NULL, 700000, NULL),
	('ad', 0, 2022, 0.50, NULL, 380000, NULL),
	('ad', 0, 2022, 1.00, NULL, 0, NULL),
	('ad', 0, 2022, 2.00, NULL, 1708000, NULL),
	('ad', 0, 2023, 0.01, NULL, 0, NULL),
	('ad', 0, 2023, 0.02, NULL, 0, NULL),
	('ad', 0, 2023, 0.05, NULL, 0, NULL),
	('ad', 0, 2023, 0.10, NULL, 0, NULL),
	('ad', 0, 2023, 0.20, NULL, 0, NULL),
	('ad', 0, 2023, 0.50, NULL, 0, NULL),
	('ad', 0, 2023, 1.00, NULL, 0, NULL),
	('ad', 0, 2023, 2.00, NULL, 2075250, NULL),
	('ad', 0, 2024, 0.01, NULL, 0, NULL),
	('ad', 0, 2024, 0.02, NULL, 900300, NULL),
	('ad', 0, 2024, 0.05, NULL, 1950000, NULL),
	('ad', 0, 2024, 0.10, NULL, 1000000, NULL),
	('ad', 0, 2024, 0.20, NULL, 700000, NULL),
	('ad', 0, 2024, 0.50, NULL, 500000, NULL),
	('ad', 0, 2024, 1.00, NULL, 1050000, NULL),
	('ad', 0, 2024, 2.00, NULL, 1601200, NULL);

INSERT INTO mintages_c (
	country,
	type,
	year,
	name,
	number,
	mintmark,
	mintage,
	reference
) VALUES
	('sk', 0, 2014, 'Slovak Republic to the EU', 1, NULL, 1000000, NULL),
  	('sk', 0, 2015, 'Ľudovít Štúr', 1, NULL, 1000000, NULL),
  	('sk', 0, 2015, 'EU Flag', 2, NULL, 1000000, NULL),
	('fr', 0, 2015, 'Peace and security', 1, NULL, 4000000, NULL),
	('fr', 0, 2015, 'Fête de la Fédération', 2, NULL, 4000000, NULL),
	('fr', 0, 2015, 'EU Flag', 3, NULL, 4000000, NULL);