X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F15%2Finsert_identity.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F15%2Finsert_identity.sql;h=631826894bd35cf1177d320ec18cd561d30f8259;hb=18cda6df43b5960686256fb6a899a63baebff70d;hp=0000000000000000000000000000000000000000;hpb=91361e82b8cd46e7c4bfc4475e6ecb1d0b268310;p=quassel.git

diff --git a/src/core/SQL/PostgreSQL/15/insert_identity.sql b/src/core/SQL/PostgreSQL/15/insert_identity.sql
new file mode 100644
index 00000000..63182689
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/15/insert_identity.sql
@@ -0,0 +1,3 @@
+INSERT INTO identity (userid, identityname, realname, awaynick, awaynickenabled, awayreason, awayreasonenabled, autoawayenabled, autoawaytime, autoawayreason, autoawayreasonenabled, detachawayenabled, detachawayreason, detachawayreasonenabled, ident, kickreason, partreason, quitreason, sslcert, sslkey)
+VALUES (:userid, :identityname, :realname, :awaynick, :awaynickenabled, :awayreason, :awayreasonenabled, :autoawayenabled, :autoawaytime, :autoawayreason, :autoawayreasonenabled, :detachawayenabled, :detachawayreason, :detachawayreasonenabled, :ident, :kickreason, :partreason, :quitreason, :sslcert, :sslkey)
+RETURNING identityid