diff options
-rwxr-xr-x | bin/load | 2 | ||||
-rw-r--r-- | data/schema.sql | 5 |
2 files changed, 7 insertions, 0 deletions
@@ -20,3 +20,5 @@ psql -U metabase ynab -c 'COPY transactions FROM STDIN' < transactions.tsv psql -U metabase ynab -c 'COPY subtransactions FROM STDIN' < subtransactions.tsv psql -U metabase ynab -c 'COPY scheduled_transactions FROM STDIN' < scheduled_transactions.tsv psql -U metabase ynab -c 'COPY scheduled_subtransactions FROM STDIN' < scheduled_subtransactions.tsv + +seq 1000000 | psql -U metabase ynab -c 'COPY ints FROM STDIN' 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 +); |