summaryrefslogtreecommitdiffstats
path: root/data/tax_returns.sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/tax_returns.sql')
-rw-r--r--data/tax_returns.sql8
1 files changed, 8 insertions, 0 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
+);