gistfile1.txt

+------------------------------------------------+------------------+------------+
| id                                             | id               | numeric_id |
+------------------------------------------------+------------------+------------+
| home::admin                                    | NULL             |          1 |
| local::/usr/local/rms/evt/rdrive/current/data/ | NULL             |          2 |
| home::oe                                       | NULL             |          5 |
| amazon::rd-admin                               | NULL             |         14 |
| home::oe2                                      | NULL             |          7 |
| f56d8484097968dd2aa1b49d2632c001               | amazon::rd-admin |          3 |
| f8861a63a562cc6026b0531cd0de388d               | amazon::rd-oe    |          4 |
| 00ee3efa8103d1eb1c6949503ecd78df               | amazon::rd-oe2   |          6 |
| c5d2bbbaaee821cc0560571e3b9be375               | amazon::rd-oe4   |          8 |
| 8ca6cfbdfa7733114588b0ca4f749518               | amazon::rd-test1 |          9 |
| 86ed5df9b4dcfe5e9de00be99a83988b               | amazon::rd-test2 |         10 |
| 253697b102f2a67bdfe58e86d30f4311               | amazon::rd-test3 |         11 |
| 733e449e7289a408e947ae378642865e               | amazon::rd-test4 |         12 |
| 1f2bb69e732b192f3e65a816311a5a5f               | amazon::rd-test5 |         13 |
+------------------------------------------------+------------------+------------+
14 rows in set (0.00 sec)



select st.id as old_id, CONCAT('amazon::', ex.bucket) as new_id, st.numeric_id from oc_storages st left join oc_files_external_mount ex on st.id = md5(CONCAT('amazon::', ex.access_
key_id , md5(ex.secret_access_key), ex.bucket))  order by 2; 

+------------------------------------------------+------------+
| id                                             | numeric_id |
+------------------------------------------------+------------+
| home::admin                                    |          1 |
| local::/usr/local/rms/evt/rdrive/current/data/ |          2 |
| home::oe                                       |          5 |
| amazon::rd-admin                               |         14 |
| home::oe2                                      |          7 |
+------------------------------------------------+------------+


insert into oc_storage_ver4 select old_id as id, numeric_id from oc_storage_ver2 where new_id is NULL;                                                                                                           
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

MariaDB [orfs_local]> select * from oc_storage_ver4;
+------------------------------------------------+------------+
| id                                             | numeric_id |
+------------------------------------------------+------------+
| amazon::rd-admin                               |          3 |
| amazon::rd-oe                                  |          4 |
| amazon::rd-oe2                                 |          6 |
| amazon::rd-oe4                                 |          8 |
| amazon::rd-test1                               |          9 |
| amazon::rd-test2                               |         10 |
| amazon::rd-test3                               |         11 |
| amazon::rd-test4                               |         12 |
| amazon::rd-test5                               |         13 |
| home::admin                                    |          1 |
| local::/usr/local/rms/evt/rdrive/current/data/ |          2 |
| home::oe                                       |          5 |
| amazon::rd-admin                               |         14 |
| home::oe2                                      |          7 |
+------------------------------------------------+------------+