diff options
-rwxr-xr-x | bin/load | 4 | ||||
-rw-r--r-- | data/taxes.sql | 6 |
2 files changed, 10 insertions, 0 deletions
@@ -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 +); |