diff options
author | Jesse Luehrs <doy@tozt.net> | 2019-08-25 14:53:39 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2019-08-25 14:53:39 -0400 |
commit | c53491ee5ad694440c2feca36f11cda870fadfa1 (patch) | |
tree | bcc285dad0422b43a96656ab4beb55f3e725f9d0 /data | |
parent | 953d4db1263477ae27f2c985d5c4ba98b44e1c37 (diff) | |
download | ynab-export-c53491ee5ad694440c2feca36f11cda870fadfa1.tar.gz ynab-export-c53491ee5ad694440c2feca36f11cda870fadfa1.zip |
also create a utility table for counting
Diffstat (limited to 'data')
-rw-r--r-- | data/schema.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/data/schema.sql b/data/schema.sql index 9061489..59526ef 100644 --- a/data/schema.sql +++ b/data/schema.sql @@ -1,3 +1,4 @@ +DROP TABLE IF EXISTS ints; DROP TABLE IF EXISTS scheduled_subtransactions; DROP TABLE IF EXISTS scheduled_transactions; DROP TABLE IF EXISTS subtransactions; @@ -124,3 +125,7 @@ CREATE TABLE scheduled_subtransactions ( category_id text REFERENCES categories(id), transfer_account_id text REFERENCES accounts(id) ); + +CREATE TABLE ints ( + i integer PRIMARY KEY +); |