diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-01-18 01:36:06 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-01-18 01:36:06 +0000 |
| commit | 04acfa679fd846ac829ded5562093b3766c85154 (patch) | |
| tree | a9625eb96c8c4ed246b1f4d172c06d85df577dfe /src/sql/accessLogInsert.sql | |
| parent | 34051da2f27ffa40d0b6d20ae891a497fe73bfe5 (diff) | |
| download | webstat-04acfa679fd846ac829ded5562093b3766c85154.tar.bz2 webstat-04acfa679fd846ac829ded5562093b3766c85154.tar.xz webstat-04acfa679fd846ac829ded5562093b3766c85154.zip | |
Diffstat (limited to 'src/sql/accessLogInsert.sql')
| -rw-r--r-- | src/sql/accessLogInsert.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/sql/accessLogInsert.sql b/src/sql/accessLogInsert.sql index 42f809b..518045e 100644 --- a/src/sql/accessLogInsert.sql +++ b/src/sql/accessLogInsert.sql @@ -1,3 +1,3 @@ INSERT INTO access_log(hostname, virtual_host, remoteip, request_time, method, path, query_string, protocol, status, - size, duration, referrer, user_agent) - VALUES (?, ?, ?, TO_TIMESTAMP(? / 1000000.0) at time zone 'utc', ?, ?, ?, ?, ?, ?, ? * '1us'::interval, ?, ?) + size, duration, referrer, user_agent, content_type) + VALUES (?, ?, ?, TO_TIMESTAMP(? / 1000000.0) at time zone 'utc', ?, ?, ?, ?, ?, ?, ? * '1us'::interval, ?, ?, ?) |