summaryrefslogtreecommitdiffstats
path: root/sql/message_insert.sql
diff options
context:
space:
mode:
authorAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:08:06 +0100
committerAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:08:06 +0100
commit3d772413a194c5b33d4202285d46b285920c475b (patch)
treeb28802aa22cc489fe26019ebe58af7c3e38561a6 /sql/message_insert.sql
parent39081f84a402aebb52d98a43e4675c90135cea9b (diff)
downloadts3db_postgres-3d772413a194c5b33d4202285d46b285920c475b.tar.gz
ts3db_postgres-3d772413a194c5b33d4202285d46b285920c475b.tar.xz
ts3db_postgres-3d772413a194c5b33d4202285d46b285920c475b.zip
modified sql statements to work with postgresql
Diffstat (limited to '')
-rw-r--r--sql/message_insert.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/message_insert.sql b/sql/message_insert.sql
index 69f7ef2..40f6e78 100644
--- a/sql/message_insert.sql
+++ b/sql/message_insert.sql
@@ -1 +1 @@
-insert into messages (server_id, message_from_client_id, message_from_client_uid, message_to_client_id, message_subject, message_msg, message_timestamp) values (:server_id:, :message_from_client_id:, :message_from_client_uid:, :message_to_client_id:, :message_subject:, :message_msg:, :message_timestamp:) \ No newline at end of file
+insert into messages (server_id, message_from_client_id, message_from_client_uid, message_to_client_id, message_subject, message_msg, message_timestamp) values (:server_id:, :message_from_client_id:, :message_from_client_uid:, :message_to_client_id:, :message_subject:, :message_msg:, :message_timestamp:) returning message_id as last_inserted_id