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') 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