summaryrefslogtreecommitdiff
path: root/sql/ddl/pgsql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/ddl/pgsql.sql')
-rw-r--r--sql/ddl/pgsql.sql4
1 files changed, 2 insertions, 2 deletions
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
);