load some tax data

2 files changed, 10 insertions, 0 deletions

diff --git a/bin/load b/bin/load
index 5212098..6c23baf 100755
--- a/bin/load
+++ b/bin/load
@@ -22,3 +22,7 @@ psql -U metabase money < "$(dirname "$0")/../data/investments-sheet-schema.sql"
 
 psql -U metabase money -c 'COPY investment_categories FROM STDIN' < investment_categories.tsv
 psql -U metabase money -c 'COPY holdings FROM STDIN' < holdings.tsv
+
+psql -U metabase money < "$(dirname "$0")/../data/taxes.sql"
+
+psql -U metabase money -c 'COPY taxes FROM STDIN' < /media/persistent/metabase/extra_data/taxes.tsv
diff --git a/data/taxes.sql b/data/taxes.sql
new file mode 100644
index 0000000..69b3132
--- /dev/null
+++ b/data/taxes.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS taxes;
+
+CREATE TABLE taxes (
+    year date PRIMARY KEY,
+    total_tax bigint
+);