renames categories -> buckets, refactors category_transfers -> bucket_transactions

2 files changed, 4 insertions, 9 deletions

diff --git a/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql b/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql
index 3b2c73e..f6ead07 100644
--- a/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql
+++ b/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql
@@ -1,7 +1,7 @@
 DROP TABLE accounts;
 DROP TABLE account_transfers;
 DROP TABLE buckets;
-DROP TABLE bucket_transfers;
+DROP TABLE bucket_transactions;
 DROP TABLE drips;
 DROP TABLE pipes;
 DROP TABLE transactions;
diff --git a/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql b/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql
index b37c626..e645d43 100644
--- a/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql
+++ b/schist_core/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql
@@ -32,17 +32,12 @@ CREATE TABLE buckets(
     name TEXT NOT NULL
 );
 
-CREATE TABLE bucket_transfers(
+CREATE TABLE bucket_transactions(
     id INTEGER NOT NULL PRIMARY KEY,
     amount INTEGER NOT NULL,
+    bucket_id INTEGER NOT NULL,
     description TEXT NOT NULL,
-    from_bucket_id INTEGER NOT NULL,
-    to_bucket_id INTEGER NOT NULL,
-    FOREIGN KEY (from_bucket_id)
-        REFERENCES buckets (id)
-        ON UPDATE CASCADE
-        ON DELETE RESTRICT,
-    FOREIGN KEY (to_bucket_id)
+    FOREIGN KEY (bucket_id)
         REFERENCES buckets (id)
         ON UPDATE CASCADE
         ON DELETE RESTRICT