From 10f071447594f2bdcec84a461df9ad648f71f44b Mon Sep 17 00:00:00 2001
From: Joe Carstairs <me@joeac.net>
Date: Sun, 17 Nov 2024 09:29:32 +0000
Subject: Renames app to 'schist'

---
 .../2024-08-31-084439_initial_setup/up.sql         | 71 ----------------------
 1 file changed, 71 deletions(-)
 delete mode 100644 rust/core/migrations/2024-08-31-084439_initial_setup/up.sql

(limited to 'rust/core/migrations/2024-08-31-084439_initial_setup/up.sql')

diff --git a/rust/core/migrations/2024-08-31-084439_initial_setup/up.sql b/rust/core/migrations/2024-08-31-084439_initial_setup/up.sql
deleted file mode 100644
index 9038b54..0000000
--- a/rust/core/migrations/2024-08-31-084439_initial_setup/up.sql
+++ /dev/null
@@ -1,71 +0,0 @@
-PRAGMA foreign_keys = ON;
-
-CREATE TABLE accounts(
-    id INTEGER NOT NULL PRIMARY KEY,
-    name TEXT NOT NULL,
-    opening_balance INTEGER NOT NULL,
-    opening_date TEXT NOT NULL
-);
-
-CREATE TABLE budget_updates(
-    id INTEGER NOT NULL PRIMARY KEY,
-    category_id INTEGER NOT NULL,
-    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
-        ON DELETE RESTRICT
-);
-
-CREATE TABLE categories(
-    id INTEGER NOT NULL PRIMARY KEY,
-    name TEXT NOT NULL
-);
-
-CREATE TABLE category_transfers(
-    id INTEGER NOT NULL PRIMARY KEY,
-    description TEXT NOT NULL,
-    quantity INTEGER NOT NULL,
-    from_category_id INTEGER NOT NULL,
-    to_category_id INTEGER NOT NULL,
-    FOREIGN KEY (from_category_id)
-        REFERENCES categories (id)
-        ON UPDATE CASCADE
-        ON DELETE RESTRICT,
-    FOREIGN KEY (to_category_id)
-        REFERENCES categories (id)
-        ON UPDATE CASCADE
-        ON DELETE RESTRICT
-);
-
-CREATE TABLE transactions(
-    id INTEGER NOT NULL PRIMARY KEY,
-    description TEXT NOT NULL,
-    payee TEXT NOT NULL,
-    quantity INTEGER NOT NULL,
-    date TEXT NOT NULL,
-    account_id INTEGER NOT NULL,
-    FOREIGN KEY (account_id)
-        REFERENCES accounts (id)
-        ON UPDATE CASCADE
-        ON DELETE RESTRICT
-);
-
-CREATE TABLE transaction_categorisations(
-    id INTEGER NOT NULL PRIMARY KEY,
-    description TEXT NOT NULL,
-    quantity INTEGER NOT NULL,
-    transaction_id INTEGER NOT NULL,
-    category_id INTEGER NOT NULL,
-    FOREIGN KEY (transaction_id)
-        REFERENCES transactions (id)
-        ON UPDATE CASCADE
-        ON DELETE RESTRICT,
-    FOREIGN KEY (category_id)
-        REFERENCES categories (id)
-        ON UPDATE CASCADE
-        ON DELETE RESTRICT
-);
-- 
cgit v1.2.3

