From 916cedd9b633a1d1ffaf9b6f27bd839671f3e743 Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Sat, 24 Aug 2019 13:53:11 -0400 Subject: months should be dates --- data/schema.sql | 4 ++-- 1 file 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, -- cgit v1.2.3