summaryrefslogtreecommitdiff
path: root/src/db/rest/user/api_user_update.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--src/db/rest/user/api_user_update.sql (renamed from db/rest/user/api_user_update.sql)3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/rest/user/api_user_update.sql b/src/db/rest/user/api_user_update.sql
index 28e4368..2e7cd50 100644
--- a/db/rest/user/api_user_update.sql
+++ b/src/db/rest/user/api_user_update.sql
@@ -145,7 +145,8 @@ BEGIN
email = NEW.email,
gender = NEW.gender,
birth_date = NEW.birth_date,
- profile_bio = NEW.profile_bio
+ profile_bio = NEW.profile_bio,
+ modified = clock_timestamp()
WHERE id = OLD.id;
END IF;