X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F16%2Fupdate_identity.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F16%2Fupdate_identity.sql;h=c25a708c40546f92bc83c6e810da973f338722e4;hb=9ce9e3fe0329a6736383a7a3a5bc1618f80885ca;hp=0000000000000000000000000000000000000000;hpb=e4972a0ebce0d555d752ab2f34ffd6a6dcdef1dd;p=quassel.git

diff --git a/src/core/SQL/PostgreSQL/16/update_identity.sql b/src/core/SQL/PostgreSQL/16/update_identity.sql
new file mode 100644
index 00000000..c25a708c
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/16/update_identity.sql
@@ -0,0 +1,21 @@
+UPDATE identity
+SET    identityname = :identityname,
+       realname = :realname,
+       awaynick = :awaynick,
+       awaynickenabled = :awaynickenabled,
+       awayreason = :awayreason,
+       awayreasonenabled = :awayreasonenabled,
+       autoawayenabled = :autoawayenabled,
+       autoawaytime = :autoawaytime,
+       autoawayreason = :autoawayreason,
+       autoawayreasonenabled = :autoawayreasonenabled,
+       detachawayenabled = :detachawayenabled,
+       detachawayreason = :detachawayreason,
+       detachawayreasonenabled = :detachawayreasonenabled,
+       ident = :ident,
+       kickreason = :kickreason,
+       partreason = :partreason,
+       quitreason = :quitreason,
+       sslcert = :sslcert,
+       sslkey = :sslkey
+WHERE  identityid = :identityid