X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F19%2Fupdate_identity.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F19%2Fupdate_identity.sql;h=c25a708c40546f92bc83c6e810da973f338722e4;hp=0000000000000000000000000000000000000000;hb=7d30b18136eecbdf2089e5d5877c7e41c6f4bcb6;hpb=3a5df5589e3cbefcaad966ba23643d58d4ec9768

diff --git a/src/core/SQL/PostgreSQL/19/update_identity.sql b/src/core/SQL/PostgreSQL/19/update_identity.sql
new file mode 100644
index 00000000..c25a708c
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/19/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