Move "missing" handling to separate column.

1 files changed, 10 insertions, 0 deletions

diff --git a/db/schema_0035-bodies_str-tidying.sql b/db/schema_0035-bodies_str-tidying.sql
new file mode 100644
index 000000000..c4c7badaf
--- /dev/null
+++ b/db/schema_0035-bodies_str-tidying.sql
@@ -0,0 +1,10 @@
+begin;
+
+alter table problem add bodies_missing text;
+
+update problem
+    set bodies_missing = split_part(bodies_str, '|', 2),
+        bodies_str = split_part(bodies_str, '|', 1)
+    where bodies_str like '%|%';
+
+commit;