diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/categories.sql | 2 | ||||
| -rw-r--r-- | sql/rexps.sql | 2 | ||||
| -rw-r--r-- | sql/sexps.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/sql/categories.sql b/sql/categories.sql index e7d9579..2694adc 100644 --- a/sql/categories.sql +++ b/sql/categories.sql @@ -1,5 +1,5 @@ -- name: GetCategoriesOrdered :many -SELECT id, name +SELECT * FROM categories WHERE user_id = $1 ORDER BY name ASC;
\ No newline at end of file diff --git a/sql/rexps.sql b/sql/rexps.sql index 87dc23f..e76c809 100644 --- a/sql/rexps.sql +++ b/sql/rexps.sql @@ -1,4 +1,4 @@ -- name: GetRecurExpenses :many -SELECT id, description, expense, duration, start, "end" +SELECT * FROM recur_expenses WHERE user_id = $1;
\ No newline at end of file diff --git a/sql/sexps.sql b/sql/sexps.sql index 8279326..884e1f3 100644 --- a/sql/sexps.sql +++ b/sql/sexps.sql @@ -1,4 +1,4 @@ -- name: GetSingleExpenses :many -SELECT id, description +SELECT * FROM single_expenses WHERE user_id = $1;
\ No newline at end of file |