From b3a46ff36e6e36946dc148e3a50f4479464b4b8d Mon Sep 17 00:00:00 2001 From: Thomas Voss Date: Fri, 13 Jun 2025 22:13:12 +0200 Subject: Support running test code in last.sql --- src/dbx/sql/000-genesis.sql | 29 ----------------------------- 1 file changed, 29 deletions(-) (limited to 'src/dbx/sql/000-genesis.sql') diff --git a/src/dbx/sql/000-genesis.sql b/src/dbx/sql/000-genesis.sql index 6daad31..327ff58 100644 --- a/src/dbx/sql/000-genesis.sql +++ b/src/dbx/sql/000-genesis.sql @@ -37,35 +37,6 @@ CREATE TABLE mintages_c ( 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, -- cgit v1.2.3