first version of postgres backend

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

diff --git a/src/core/SQL/PostgreSQL/14/insert_network.sql b/src/core/SQL/PostgreSQL/14/insert_network.sql
new file mode 100644 (file)
index 0000000..4f94b43
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/14/insert_network.sql
@@ -0,0 +1,3 @@
+INSERT INTO network (userid, networkname, identityid, servercodec, encodingcodec, decodingcodec, userandomserver, perform, useautoidentify, autoidentifyservice, autoidentifypassword, useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels)
+VALUES (:userid, :networkname, :identityid, :servercodec, :encodingcodec, :decodingcodec, :userandomserver, :perform, :useautoidentify, :autoidentifyservice, :autoidentifypassword, :useautoreconnect, :autoreconnectinterval, :autoreconnectretries, :unlimitedconnectretries, :rejoinchannels)
+RETURNING networkid