aboutsummaryrefslogtreecommitdiff
path: root/server
diff options
context:
space:
mode:
authorJoris2020-01-18 16:18:26 +0100
committerJoris2020-01-18 16:18:26 +0100
commitbc48d7428607c84003658d5b88d41cf923d010fd (patch)
tree276ef115d9eff72f3d673bb4bb639108272d81be /server
parentfff99e6fb1c03235e219a94ce52acf5a50d3fb62 (diff)
Add deploy command
Diffstat (limited to 'server')
-rw-r--r--server/migrations/2.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/server/migrations/2.sql b/server/migrations/2.sql
index efed046..c1d502f 100644
--- a/server/migrations/2.sql
+++ b/server/migrations/2.sql
@@ -35,10 +35,10 @@ UPDATE
SET
category = (SELECT category FROM payment_category WHERE payment_category.name = LOWER(payment.name))
WHERE
- EXISTS (SELECT category FROM payment_category WHERE payment_category.name = LOWER(payment.name))
+ EXISTS (SELECT category FROM payment_category WHERE payment_category.name = LOWER(payment.name));
DELETE FROM payment WHERE category = -1;
-- Remove
-DROP TABLE payment_category
+DROP TABLE payment_category;