first version of postgres backend

[quassel.git] / src / core / SQL / PostgreSQL / 14 / update_identity.sql

diff --git a/src/core/SQL/PostgreSQL/14/update_identity.sql b/src/core/SQL/PostgreSQL/14/update_identity.sql
new file mode 100644 (file)
index 0000000..c25a708
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/14/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