From 828b9ae9f6217f7e5e97ec704134c786dd401bad Mon Sep 17 00:00:00 2001
From: Joe Carstairs <me@joeac.net>
Date: Wed, 30 Oct 2024 07:27:13 +0000
Subject: Separates date_utc and datetime_utc

---
 backend/core/migrations/2024-08-31-084439_initial_setup/up.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'backend/core/migrations')

diff --git a/backend/core/migrations/2024-08-31-084439_initial_setup/up.sql b/backend/core/migrations/2024-08-31-084439_initial_setup/up.sql
index 3584ae7..9038b54 100644
--- a/backend/core/migrations/2024-08-31-084439_initial_setup/up.sql
+++ b/backend/core/migrations/2024-08-31-084439_initial_setup/up.sql
@@ -13,6 +13,7 @@ CREATE TABLE budget_updates(
     date TEXT NOT NULL,
     new_budget INTEGER NOT NULL,
     new_period INTEGER NOT NULL,
+    UNIQUE (category_id, date),
     FOREIGN KEY (category_id)
         REFERENCES categories (id)
         ON UPDATE CASCADE
-- 
cgit v1.2.3