From b46012f212a4302b4d1325d8fdf9634e7083e76a Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.eu>
Date: Fri, 11 Oct 2024 22:47:16 +0200
Subject: First draft of recurrent costs and categories

---
 sql/ddl/pgsql.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'sql/ddl/pgsql.sql')

diff --git a/sql/ddl/pgsql.sql b/sql/ddl/pgsql.sql
index 09c7133..18dc388 100644
--- a/sql/ddl/pgsql.sql
+++ b/sql/ddl/pgsql.sql
@@ -19,14 +19,14 @@ CREATE INDEX user_id
     ON categories (user_id);
 
 
-CREATE TABLE const_expenses (
+CREATE TABLE recur_expenses (
     id          SERIAL PRIMARY KEY,
     description TEXT,
     expense     NUMERIC(10, 2) NOT NULL,
     duration    INTERVAL       NOT NULL,
     start       DATE           NOT NULL,
     "end"       DATE           NOT NULL,
-    prev_id     INTEGER REFERENCES const_expenses,
+    prev_id     INTEGER REFERENCES recur_expenses,
     category_id INTEGER        NOT NULL REFERENCES categories,
     user_id     INTEGER        NOT NULL REFERENCES users
 );
-- 
cgit v1.2.3-70-g09d2