From 2361adeb0ca77904138e3466d51c2f44cf6df613 Mon Sep 17 00:00:00 2001 From: Joe Carstairs Date: Mon, 28 Jul 2025 13:22:53 +0100 Subject: Tidier folders --- .../2024-08-31-084439_initial_setup/down.sql | 7 -- .../2024-08-31-084439_initial_setup/up.sql | 93 ---------------------- 2 files changed, 100 deletions(-) delete mode 100644 schist_models/migrations/2024-08-31-084439_initial_setup/down.sql delete mode 100644 schist_models/migrations/2024-08-31-084439_initial_setup/up.sql (limited to 'schist_models/migrations') diff --git a/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql b/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql deleted file mode 100644 index ba65012..0000000 --- a/schist_models/migrations/2024-08-31-084439_initial_setup/down.sql +++ /dev/null @@ -1,7 +0,0 @@ -DROP TABLE accounts; -DROP TABLE account_transfers; -DROP TABLE budget_drips; -DROP TABLE categories; -DROP TABLE transaction_categorisations; -DROP TABLE category_transfers; -DROP TABLE transactions; diff --git a/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql b/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql deleted file mode 100644 index a09bf7b..0000000 --- a/schist_models/migrations/2024-08-31-084439_initial_setup/up.sql +++ /dev/null @@ -1,93 +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 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, - date TEXT NOT NULL, - quantity INTEGER NOT NULL, - FOREIGN KEY (category_id) - REFERENCES categories (id) - ON UPDATE CASCADE - ON DELETE RESTRICT, - UNIQUE(category_id, date) -); - -CREATE TABLE categories( - id INTEGER NOT NULL PRIMARY KEY, - name TEXT NOT NULL, - balance INTEGER NOT NULL, - balance_date TEXT NOT NULL, - budget_period INTEGER NOT NULL, - budget_period_unit TEXT NOT NULL, - budget_quantity INTEGER 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