diff options
| author | Alexander Sulfrian <alexander@sulfrian.net> | 2014-10-09 00:37:36 +0200 |
|---|---|---|
| committer | Alexander Sulfrian <alexander@sulfrian.net> | 2014-10-09 00:43:34 +0200 |
| commit | 6e67f7db177ba29080722601c44af570154d2005 (patch) | |
| tree | 97e71febbe420b7cb69cb76c8c9e50610b247ee1 /sql/ban_insert.sql | |
| parent | d03126200a1ed3db14ba06406a7a9f7309c44738 (diff) | |
| download | ts3db_postgres-6e67f7db177ba29080722601c44af570154d2005.tar.gz ts3db_postgres-6e67f7db177ba29080722601c44af570154d2005.tar.xz ts3db_postgres-6e67f7db177ba29080722601c44af570154d2005.zip | |
Diffstat (limited to 'sql/ban_insert.sql')
| -rw-r--r-- | sql/ban_insert.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/ban_insert.sql b/sql/ban_insert.sql index 71b2c1e..76633eb 100644 --- a/sql/ban_insert.sql +++ b/sql/ban_insert.sql @@ -8,7 +8,8 @@ INSERT INTO bans ban_invoker_client_id, ban_invoker_uid, ban_invoker_name, - ban_reason) + ban_reason, + ban_hash) VALUES (:server_id:, :ban_ip:, @@ -19,6 +20,7 @@ VALUES :ban_invoker_client_id:, :ban_invoker_uid:, :ban_invoker_name:, - :ban_reason:) + :ban_reason:, + :ban_hash:) RETURNING ban_id AS last_inserted_id; |