AccountTransfer model

2 files changed, 19 insertions, 0 deletions

diff --git a/rust/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql b/rust/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql
index b9b1675..ba65012 100644
--- a/rust/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql
+++ b/rust/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql
@@ -1,4 +1,5 @@
 DROP TABLE accounts;
+DROP TABLE account_transfers;
 DROP TABLE budget_drips;
 DROP TABLE categories;
 DROP TABLE transaction_categorisations;
diff --git a/rust/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql b/rust/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql
index a684ce7..a09bf7b 100644
--- a/rust/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql
+++ b/rust/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql
@@ -7,6 +7,24 @@ CREATE TABLE accounts(
     opening_date TEXT NOT NULL
 );
 
+CREATE TABLE account_transfers(
+    id INTEGER NOT NULL PRIMARY KEY,
+    date TEXT NOT NULL,
+    description TEXT NOT NULL,
+    quantity INTEGER NOT NULL,
+    from_account_id INTEGER NOT NULL,
+    to_account_id INTEGER NOT NULL,
+    FOREIGN KEY (from_account_id)
+        REFERENCES accounts (id)
+        ON UPDATE CASCADE
+        ON DELETE RESTRICT,
+    FOREIGN KEY (to_account_id)
+        REFERENCES accounts (id)
+        ON UPDATE CASCADE
+        ON DELETE RESTRICT
+);
+
+
 CREATE TABLE budget_drips(
     id INTEGER NOT NULL PRIMARY KEY,
     category_id INTEGER NOT NULL,