From b46012f212a4302b4d1325d8fdf9634e7083e76a Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann 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') 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 put type='submit' value='switch'/> An application for managing the expenses [go-rewrite]René 'Necoro' Neumann
summaryrefslogtreecommitdiff
path: root/sql/categories.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
30 hoursIntroduce change password functionalityRené 'Necoro' Neumann10-13/+290
34 hoursShow user name in user drop downRené 'Necoro' Neumann2-13/+27
34 hoursSave User as part of the contextRené 'Necoro' Neumann5-36/+47
35 hoursSQL: Fetch * instead of specific columns for simplicityRené 'Necoro' Neumann8-47/+40
35 hoursMove bootstrap parts to their own templRené 'Necoro' Neumann2-34/+75
35 hoursAdd User dropdownRené 'Necoro' Neumann2-9/+61
36 hoursMove from html/template to templRené 'Necoro' Neumann27-340/+1138
2 daysHandle login routing at login pageRené 'Necoro' Neumann2-16/+22
2 daysRestructure and change to chi as muxing frameworkRené 'Necoro' Neumann9-140/+197