diff options
-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, |