summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJesse Luehrs <doy@tozt.net>2019-08-27 03:46:40 -0400
committerJesse Luehrs <doy@tozt.net>2019-08-27 03:46:40 -0400
commitfab9d941cbcaa3181b7ccb9107d84aa72ee655d8 (patch)
tree49be737b627cba713e9f828de1dc8e37dbaa65c4
parentaedbaabbe441118e496e442d18ce6ed1495483ba (diff)
downloadmetabase-utils-fab9d941cbcaa3181b7ccb9107d84aa72ee655d8.tar.gz
metabase-utils-fab9d941cbcaa3181b7ccb9107d84aa72ee655d8.zip
also track income reported on tax returns
-rw-r--r--data/tax_returns.sql8
-rw-r--r--data/taxes.sql6
2 files changed, 8 insertions, 6 deletions
diff --git a/data/tax_returns.sql b/data/tax_returns.sql
new file mode 100644
index 0000000..6a7ee19
--- /dev/null
+++ b/data/tax_returns.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS taxes;
+DROP TABLE IF EXISTS tax_returns;
+
+CREATE TABLE tax_returns (
+ year date PRIMARY KEY,
+ total_income bigint,
+ total_tax bigint
+);
diff --git a/data/taxes.sql b/data/taxes.sql
deleted file mode 100644
index 69b3132..0000000
--- a/data/taxes.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP TABLE IF EXISTS taxes;
-
-CREATE TABLE taxes (
- year date PRIMARY KEY,
- total_tax bigint
-);