diff options
| author | Joe Carstairs <me@joeac.net> | 2024-10-30 07:27:13 +0000 |
|---|---|---|
| committer | Joe Carstairs <me@joeac.net> | 2024-10-30 08:50:45 +0000 |
| commit | 828b9ae9f6217f7e5e97ec704134c786dd401bad (patch) | |
| tree | c920b8874682e89ba05b6e1ca20275bfd5878d87 /backend/core/migrations | |
| parent | 6e9f0069f5d1e4cfbf7f9feb8536795a78c818f6 (diff) | |
Separates date_utc and datetime_utc
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 |