From 916cedd9b633a1d1ffaf9b6f27bd839671f3e743 Mon Sep 17 00:00:00 2001
From: Jesse Luehrs <doy@tozt.net>
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(-)

(limited to 'data/schema.sql')

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-54-g00ecf

