From bc48d7428607c84003658d5b88d41cf923d010fd Mon Sep 17 00:00:00 2001
From: Joris
Date: Sat, 18 Jan 2020 16:18:26 +0100
Subject: Add deploy command

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

(limited to 'server/migrations/2.sql')

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;
-- 
cgit v1.2.3

