(no commit message)

diff --git a/1-add.sql b/1-add.sql
index 126b4cc281b1ce08c81d11dc8ef68161c590ba1e..f1c502b0bc9d0cd6c9478363fbacf57dc58363c8 100644 (file)
--- a/1-add.sql
+++ b/1-add.sql
@@ -1,3 +1,4 @@
+-- make "external" an JSON object if null\r
 UPDATE node_data\r
 JOIN nodes ON nodes.id = node_data.node_id\r
 SET external = "{}"\r
@@ -5,6 +6,7 @@ WHERE
   node_data.external IS NULL\r
   AND nodes.available_for_rent = 1;\r
 \r
+-- add "export_portals" array to "external" if it does not exist\r
 UPDATE node_data\r
 JOIN nodes ON nodes.id = node_data.node_id\r
 SET external = JSON_SET(external, '$.export_portals', JSON_ARRAY())\r
@@ -12,6 +14,7 @@ WHERE
   NOT JSON_CONTAINS_PATH(external, 'all', '$.export_portals')\r
   AND nodes.available_for_rent = 1;\r
 \r
+-- add "hpm-api" value to external.export_portals\r
 UPDATE node_data\r
 JOIN nodes ON nodes.id = node_data.node_id\r
 SET external = JSON_ARRAY_APPEND(external, '$.export_portals', 'hpm-api')\r