8 files changed, 22 insertions, 0 deletions
diff --git a/src/db/rest/util/_api_get_user_id.sql b/src/db/rest/util/_api_get_user_id.sql
new file mode 100644
index 0000000..e86afc3
--- /dev/null
+++ b/src/db/rest/util/_api_get_user_id.sql
@@ -0,0 +1,22 @@
+CREATE FUNCTION _api.get_user_id()
+RETURNS INTEGER
+LANGUAGE plpgsql VOLATILE
+AS $BODY$
+DECLARE
+	_user_id INTEGER;
+BEGIN
+	_user_id = CURRENT_SETTING(
+		'request.jwt.claims',
+		TRUE
+	)::JSON->>'user_id';
+
+	UPDATE admin.user
+	SET seen = clock_timestamp()
+	WHERE id = _user_id;
+
+	RETURN _user_id;
+END
+$BODY$;
+
+GRANT UPDATE ON TABLE admin.user
+	TO rest_anon, rest_user;
diff --git a/db/rest/util/_api_raise.sql b/src/db/rest/util/_api_raise.sql
index 5c740c6..5c740c6 100644
--- a/db/rest/util/_api_raise.sql
+++ b/src/db/rest/util/_api_raise.sql
diff --git a/db/rest/util/_api_raise_deny.sql b/src/db/rest/util/_api_raise_deny.sql
index 17406b7..17406b7 100644
--- a/db/rest/util/_api_raise_deny.sql
+++ b/src/db/rest/util/_api_raise_deny.sql
diff --git a/db/rest/util/_api_raise_null.sql b/src/db/rest/util/_api_raise_null.sql
index be6ee29..be6ee29 100644
--- a/db/rest/util/_api_raise_null.sql
+++ b/src/db/rest/util/_api_raise_null.sql
diff --git a/db/rest/util/_api_raise_unique.sql b/src/db/rest/util/_api_raise_unique.sql
index a18d960..a18d960 100644
--- a/db/rest/util/_api_raise_unique.sql
+++ b/src/db/rest/util/_api_raise_unique.sql
diff --git a/db/rest/util/_api_serve_media.sql b/src/db/rest/util/_api_serve_media.sql
index 8b0f0b8..8b0f0b8 100644
--- a/db/rest/util/_api_serve_media.sql
+++ b/src/db/rest/util/_api_serve_media.sql
diff --git a/db/rest/util/_api_trim.sql b/src/db/rest/util/_api_trim.sql
index c972282..c972282 100644
--- a/db/rest/util/_api_trim.sql
+++ b/src/db/rest/util/_api_trim.sql
diff --git a/db/rest/util/_api_validate_text.sql b/src/db/rest/util/_api_validate_text.sql
index ff3a227..ff3a227 100644
--- a/db/rest/util/_api_validate_text.sql
+++ b/src/db/rest/util/_api_validate_text.sql