aboutsummaryrefslogtreecommitdiffhomepage
path: root/src/dbx/sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/dbx/sql')
-rw-r--r--src/dbx/sql/000-genesis.sql64
-rw-r--r--src/dbx/sql/last.sql157
2 files changed, 173 insertions, 48 deletions
diff --git a/src/dbx/sql/000-genesis.sql b/src/dbx/sql/000-genesis.sql
index 6daad31..c16c6ae 100644
--- a/src/dbx/sql/000-genesis.sql
+++ b/src/dbx/sql/000-genesis.sql
@@ -7,68 +7,36 @@ CREATE TABLE migration (
INSERT INTO migration (id, latest) VALUES (1, -1);
CREATE TABLE mintages_s (
- country CHAR(2) NOT NULL COLLATE BINARY
+ country CHAR(2) NOT NULL COLLATE BINARY
CHECK(length(country) = 2),
- type INTEGER NOT NULL -- Codes correspond to contants in mintages.go
+ -- Codes correspond to contants in mintages.go
+ type INTEGER NOT NULL
CHECK(type BETWEEN 0 AND 2),
- year INTEGER NOT NULL,
- mintmark TEXT,
- [€0,01] INTEGER,
- [€0,02] INTEGER,
- [€0,05] INTEGER,
- [€0,10] INTEGER,
- [€0,20] INTEGER,
- [€0,50] INTEGER,
- [€1,00] INTEGER,
- [€2,00] INTEGER,
- reference TEXT
+ year INTEGER NOT NULL,
+ denomination REAL NOT NULL,
+ mintmark TEXT,
+ mintage INTEGER,
+ reference TEXT
);
CREATE TABLE mintages_c (
country CHAR(2) NOT NULL COLLATE BINARY
CHECK(length(country) = 2),
- type INTEGER NOT NULL -- Codes correspond to contants in mintages.go
+ -- Codes correspond to contants in mintages.go
+ type INTEGER NOT NULL
CHECK(type BETWEEN 0 AND 2),
- name TEXT NOT NULL,
year INTEGER NOT NULL,
+ name TEXT NOT NULL,
number INTEGER NOT NULL,
mintmark TEXT,
mintage INTEGER,
reference TEXT
);
--- TODO: Remove dummy data
-INSERT INTO mintages_s (
- country,
- type,
- year,
- mintmark,
- [€0,01],
- [€0,02],
- [€0,05],
- [€0,10],
- [€0,20],
- [€0,50],
- [€1,00],
- [€2,00],
- reference
-) VALUES
- ("ad", 0, 2014, NULL, 60000, 60000, 860000, 860000, 860000, 340000, 511843, 360000, NULL),
- ("ad", 0, 2015, NULL, 0, 0, 0, 0, 0, 0, 0, 1072400, NULL),
- ("ad", 0, 2016, NULL, 0, 0, 0, 0, 0, 0, 2339200, 0, NULL),
- ("ad", 0, 2017, NULL, 2582395, 1515000, 2191421, 1103000, 1213000, 968800, 17000, 794588, NULL),
- ("ad", 0, 2018, NULL, 2430000, 2550000, 1800000, 980000, 1014000, 890000, 0, 868000, NULL),
- ("ad", 0, 2019, NULL, 2447000, 1727000, 2100000, 1610000, 1570000, 930000, 0, 1058310, NULL),
- ("ad", 0, 2020, NULL, 0, 0, 0, 860000, 175000, 740000, 0, 1500000, NULL),
- ("ad", 0, 2021, NULL, 200000, 700000, 0, 1400000, 1420000, 600000, 50000, 1474500, NULL),
- ("ad", 0, 2022, NULL, 700000, 450000, 400000, 700000, 700000, 380000, 0, 1708000, NULL),
- ("ad", 0, 2023, NULL, 0, 0, 0, 0, 0, 0, 0, 2075250, NULL),
- ("ad", 0, 2024, NULL, 0, 900300, 1950000, 1000000, 700000, 500000, 1050000, 1601200, NULL),
- ("ad", 0, 2025, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-
CREATE TABLE users (
- email TEXT COLLATE BINARY,
- username TEXT COLLATE BINARY,
- password TEXT COLLATE BINARY,
- adminp INTEGER
+ email TEXT COLLATE BINARY,
+ username TEXT COLLATE BINARY,
+ password TEXT COLLATE BINARY,
+ adminp INTEGER,
+ translates TEXT COLLATE BINARY
); \ No newline at end of file
diff --git a/src/dbx/sql/last.sql b/src/dbx/sql/last.sql
new file mode 100644
index 0000000..22ebab8
--- /dev/null
+++ b/src/dbx/sql/last.sql
@@ -0,0 +1,157 @@
+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
+ ('de', 0, 2015, C_('Hessen', 'CC Name'), 1, 'A', 6000000, NULL),
+ ('de', 0, 2015, C_('German Reunification', 'CC Name'), 2, 'A', 6000000, NULL),
+ ('de', 0, 2015, C_('EU Flag', 'CC Name'), 3, 'A', 6000000, NULL),
+ ('de', 0, 2015, C_('Hessen', 'CC Name'), 1, 'D', 6300000, NULL),
+ ('de', 0, 2015, C_('German Reunification', 'CC Name'), 2, 'D', 6300000, NULL),
+ ('de', 0, 2015, C_('EU Flag', 'CC Name'), 3, 'D', 6300000, NULL),
+ ('de', 0, 2015, C_('Hessen', 'CC Name'), 1, 'F', 7200000, NULL),
+ ('de', 0, 2015, C_('German Reunification', 'CC Name'), 2, 'F', 7200000, NULL),
+ ('de', 0, 2015, C_('EU Flag', 'CC Name'), 3, 'F', 7200000, NULL),
+ ('de', 0, 2015, C_('Hessen', 'CC Name'), 1, 'G', 4200000, NULL),
+ ('de', 0, 2015, C_('German Reunification', 'CC Name'), 2, 'G', 4200000, NULL),
+ ('de', 0, 2015, C_('EU Flag', 'CC Name'), 3, 'G', 4200000, NULL),
+ ('de', 0, 2015, C_('Hessen', 'CC Name'), 1, 'J', 6300000, NULL),
+ ('de', 0, 2015, C_('German Reunification', 'CC Name'), 2, 'J', 6300000, NULL),
+ ('de', 0, 2015, C_('EU Flag', 'CC Name'), 3, 'J', 6300000, NULL),
+ ('sk', 0, 2014, C_('Slovak Republic to the EU', 'CC Name'), 1, NULL, 1000000, NULL),
+ ('sk', 0, 2015, C_('Ľudovít Štúr', 'CC Name'), 1, NULL, 1000000, NULL),
+ ('sk', 0, 2015, C_('EU Flag', 'CC Name'), 2, NULL, 1000000, NULL),
+ ('nl', 0, 2015, C_('EU Flag', 'CC Name'), 2, NULL, NULL, NULL),
+ ('fr', 0, 2015, C_('Peace and security', 'CC Name'), 1, NULL, 4000000, NULL),
+ ('fr', 0, 2015, C_('Fête de la Fédération', 'CC Name'), 2, NULL, 4000000, NULL),
+ ('fr', 0, 2015, C_('EU Flag', 'CC Name'), 3, NULL, 4000000, NULL); \ No newline at end of file