diff options
| author | Joris | 2020-01-18 16:18:26 +0100 |
|---|---|---|
| committer | Joris | 2020-01-18 16:18:26 +0100 |
| commit | bc48d7428607c84003658d5b88d41cf923d010fd (patch) | |
| tree | 276ef115d9eff72f3d673bb4bb639108272d81be /server/migrations | |
| parent | fff99e6fb1c03235e219a94ce52acf5a50d3fb62 (diff) | |
Add deploy command
Diffstat (limited to 'server/migrations')
| -rw-r--r-- | server/migrations/2.sql | 4 |
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; |