subscription migration (#838)

Oleksii Moskalenko · web-flow · commit 7980e331f6d5 · 2020-06-29T21:05:00.000+08:00
diff --git a/core/src/main/resources/db/migration/V2.2__Subscription_Migration.sql b/core/src/main/resources/db/migration/V2.2__Subscription_Migration.sql
@@ -0,0 +1,3 @@
+UPDATE stores
+    SET subscriptions = array_to_string(string_to_array(subscriptions, ':') || '{false}', ':')
+    WHERE array_length(string_to_array(subscriptions, ':'), 1) = 2;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+UPDATE stores`
	`2`	`+ SET subscriptions = array_to_string(string_to_array(subscriptions, ':') \|\| '{false}', ':')`
	`3`	`+ WHERE array_length(string_to_array(subscriptions, ':'), 1) = 2;`