# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1689561035 -7200
# Node ID 4a437dd62cc9d237430bf8f30cd3d18f1edbe7d5
# Parent  e6a5f196fc1f5e41c8a09ad8f312f2e9d48e7787
mod_storage_sql: Use UUIDv7 as keys

Potentially allows sorting on those directly as they will be in
increasing order.

diff -r e6a5f196fc1f -r 4a437dd62cc9 plugins/mod_storage_sql.lua
--- a/plugins/mod_storage_sql.lua	Sun Aug 15 14:44:21 2021 +0200
+++ b/plugins/mod_storage_sql.lua	Mon Jul 17 04:30:35 2023 +0200
@@ -366,7 +366,7 @@
 				item_count = item_count - result:affected();
 			end
 		else
-			key = uuid.generate();
+			key = uuid.v7();
 		end
 		local t, encoded_value = assert(serialize(value));
 		engine:insert(insert_sql, host, user or "", store, when, with, key, t, encoded_value);