diff options
| author | Jesse Luehrs <doy@tozt.net> | 2019-08-24 13:53:11 -0400 |
|---|---|---|
| committer | Jesse Luehrs <doy@tozt.net> | 2019-08-24 13:53:11 -0400 |
| commit | 916cedd9b633a1d1ffaf9b6f27bd839671f3e743 (patch) | |
| tree | 55ac214f43f2883fa069963b3434afd68701e957 | |
| parent | c9c3cee56131d25ea7dd47f31f619d0fed57b326 (diff) | |
| download | ynab-export-916cedd9b633a1d1ffaf9b6f27bd839671f3e743.tar.gz ynab-export-916cedd9b633a1d1ffaf9b6f27bd839671f3e743.zip | |
months should be dates
| -rw-r--r-- | data/schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/data/schema.sql b/data/schema.sql index 8628605..7da6862 100644 --- a/data/schema.sql +++ b/data/schema.sql @@ -36,11 +36,11 @@ CREATE TABLE categories ( ); CREATE TABLE months ( - month text PRIMARY KEY + month date PRIMARY KEY ); CREATE TABLE categories_by_month ( - month text REFERENCES months(month), + month date REFERENCES months(month), id text REFERENCES categories(id), category_group_id text REFERENCES category_groups(id) NOT NULL, name text NOT NULL, |