summaryrefslogtreecommitdiff
path: root/rust/core/migrations
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-11-17 09:29:32 +0000
committerJoe Carstairs <me@joeac.net>2024-11-17 09:30:04 +0000
commit10f071447594f2bdcec84a461df9ad648f71f44b (patch)
tree645924a4948f39a4d9e2ec270d79fc6c2a3a937a /rust/core/migrations
parent1ae19eb3315c40e3f9062592c27fa76c11cf626c (diff)
Renames app to 'schist'
Diffstat (limited to 'rust/core/migrations')
-rw-r--r--rust/core/migrations/2024-08-31-084439_initial_setup/down.sql6
-rw-r--r--rust/core/migrations/2024-08-31-084439_initial_setup/up.sql71
2 files changed, 0 insertions, 77 deletions
diff --git a/rust/core/migrations/2024-08-31-084439_initial_setup/down.sql b/rust/core/migrations/2024-08-31-084439_initial_setup/down.sql
deleted file mode 100644
index 8cf4b1e..0000000
--- a/rust/core/migrations/2024-08-31-084439_initial_setup/down.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP TABLE accounts;
-DROP TABLE budget_updates;
-DROP TABLE categories;
-DROP TABLE transaction_categorisations;
-DROP TABLE category_transfers;
-DROP TABLE transactions;
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
-);