aboutsummaryrefslogtreecommitdiffstats
path: root/data/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/schema.sql')
-rw-r--r--data/schema.sql4
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,