diff options
author | Jesse Luehrs <doy@tozt.net> | 2019-08-27 03:46:40 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2019-08-27 03:46:40 -0400 |
commit | fab9d941cbcaa3181b7ccb9107d84aa72ee655d8 (patch) | |
tree | 49be737b627cba713e9f828de1dc8e37dbaa65c4 | |
parent | aedbaabbe441118e496e442d18ce6ed1495483ba (diff) | |
download | metabase-utils-fab9d941cbcaa3181b7ccb9107d84aa72ee655d8.tar.gz metabase-utils-fab9d941cbcaa3181b7ccb9107d84aa72ee655d8.zip |
also track income reported on tax returns
-rw-r--r-- | data/tax_returns.sql | 8 | ||||
-rw-r--r-- | data/taxes.sql | 6 |
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 -); |