diff options
Diffstat (limited to 'backend/core/migrations')
| -rw-r--r-- | backend/core/migrations/2024-08-31-084439_initial_setup/up.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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 |