8 files changed, 44 insertions, 28 deletions
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 80fbf0577ef..870865aa192 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.76 2018/04/12 10:21:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.77 2018/06/07 07:36:49 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -68,6 +68,7 @@ share/doc/sqlite3/c3ref/c_sync_dataonly.html
 share/doc/sqlite3/c3ref/c_testctrl_always.html
 share/doc/sqlite3/c3ref/c_trace.html
 share/doc/sqlite3/c3ref/c_vtab_constraint_support.html
+share/doc/sqlite3/c3ref/c_win32_data_directory_type.html
 share/doc/sqlite3/c3ref/cancel_auto_extension.html
 share/doc/sqlite3/c3ref/changes.html
 share/doc/sqlite3/c3ref/clear_bindings.html
@@ -121,6 +122,7 @@ share/doc/sqlite3/c3ref/int64.html
 share/doc/sqlite3/c3ref/interrupt.html
 share/doc/sqlite3/c3ref/intro.html
 share/doc/sqlite3/c3ref/io_methods.html
+share/doc/sqlite3/c3ref/keyword_check.html
 share/doc/sqlite3/c3ref/last_insert_rowid.html
 share/doc/sqlite3/c3ref/libversion.html
 share/doc/sqlite3/c3ref/limit.html
@@ -172,6 +174,11 @@ share/doc/sqlite3/c3ref/stmt_readonly.html
 share/doc/sqlite3/c3ref/stmt_scanstatus.html
 share/doc/sqlite3/c3ref/stmt_scanstatus_reset.html
 share/doc/sqlite3/c3ref/stmt_status.html
+share/doc/sqlite3/c3ref/str.html
+share/doc/sqlite3/c3ref/str_append.html
+share/doc/sqlite3/c3ref/str_errcode.html
+share/doc/sqlite3/c3ref/str_finish.html
+share/doc/sqlite3/c3ref/str_new.html
 share/doc/sqlite3/c3ref/strglob.html
 share/doc/sqlite3/c3ref/stricmp.html
 share/doc/sqlite3/c3ref/strlike.html
@@ -202,6 +209,7 @@ share/doc/sqlite3/c3ref/wal_autocheckpoint.html
 share/doc/sqlite3/c3ref/wal_checkpoint.html
 share/doc/sqlite3/c3ref/wal_checkpoint_v2.html
 share/doc/sqlite3/c3ref/wal_hook.html
+share/doc/sqlite3/c3ref/win32_set_directory.html
 share/doc/sqlite3/c_interface.html
 share/doc/sqlite3/capi3.html
 share/doc/sqlite3/capi3ref.html
@@ -302,6 +310,7 @@ share/doc/sqlite3/images/books/kreibich.gif
 share/doc/sqlite3/images/books/newman.jpg
 share/doc/sqlite3/images/books/nishizawa2.jpg
 share/doc/sqlite3/images/books/owens.jpg
+share/doc/sqlite3/images/books/sanderson2018.jpg
 share/doc/sqlite3/images/books/symbiansql.jpg
 share/doc/sqlite3/images/books/vanderLans.jpg
 share/doc/sqlite3/images/btreemodule_balance_deeper.svg
@@ -363,6 +372,8 @@ share/doc/sqlite3/images/foreignlogos/flame.gif
 share/doc/sqlite3/images/foreignlogos/ge.gif
 share/doc/sqlite3/images/foreignlogos/google.gif
 share/doc/sqlite3/images/foreignlogos/intuit.gif
+share/doc/sqlite3/images/foreignlogos/loc.gif
+share/doc/sqlite3/images/foreignlogos/loc.jpg
 share/doc/sqlite3/images/foreignlogos/mcaffee.gif
 share/doc/sqlite3/images/foreignlogos/microsoft.gif
 share/doc/sqlite3/images/foreignlogos/monotone.gif
@@ -397,6 +408,7 @@ share/doc/sqlite3/images/harmony.gif
 share/doc/sqlite3/images/index-ex1-x-b.gif
 share/doc/sqlite3/images/indirect1b1.gif
 share/doc/sqlite3/images/joe1.jpg
+share/doc/sqlite3/images/loc.jpg
 share/doc/sqlite3/images/ne.gif
 share/doc/sqlite3/images/ne.png
 share/doc/sqlite3/images/nocopy.gif
@@ -496,6 +508,7 @@ share/doc/sqlite3/images/syntax/table-or-subquery.gif
 share/doc/sqlite3/images/syntax/type-name.gif
 share/doc/sqlite3/images/syntax/update-stmt-limited.gif
 share/doc/sqlite3/images/syntax/update-stmt.gif
+share/doc/sqlite3/images/syntax/upsert-clause.gif
 share/doc/sqlite3/images/syntax/vacuum-stmt.gif
 share/doc/sqlite3/images/syntax/with-clause.gif
 share/doc/sqlite3/images/table-ex1b2.gif
@@ -508,6 +521,7 @@ share/doc/sqlite3/isolation.html
 share/doc/sqlite3/json1.html
 share/doc/sqlite3/keyword_index.html
 share/doc/sqlite3/lang.html
+share/doc/sqlite3/lang_UPSERT.html
 share/doc/sqlite3/lang_aggfunc.html
 share/doc/sqlite3/lang_altertable.html
 share/doc/sqlite3/lang_analyze.html
@@ -545,6 +559,7 @@ share/doc/sqlite3/lemon.html
 share/doc/sqlite3/limits.html
 share/doc/sqlite3/loadext.html
 share/doc/sqlite3/lockingv3.html
+share/doc/sqlite3/locrsf.html
 share/doc/sqlite3/lts.html
 share/doc/sqlite3/malloc.html
 share/doc/sqlite3/mingw.html
@@ -620,6 +635,7 @@ share/doc/sqlite3/releaselog/3_21_0.html
 share/doc/sqlite3/releaselog/3_22_0.html
 share/doc/sqlite3/releaselog/3_23_0.html
 share/doc/sqlite3/releaselog/3_23_1.html
+share/doc/sqlite3/releaselog/3_24_0.html
 share/doc/sqlite3/releaselog/3_2_0.html
 share/doc/sqlite3/releaselog/3_2_1.html
 share/doc/sqlite3/releaselog/3_2_2.html
@@ -881,6 +897,7 @@ share/doc/sqlite3/syntax/table-or-subquery.html
 share/doc/sqlite3/syntax/type-name.html
 share/doc/sqlite3/syntax/update-stmt-limited.html
 share/doc/sqlite3/syntax/update-stmt.html
+share/doc/sqlite3/syntax/upsert-clause.html
 share/doc/sqlite3/syntax/vacuum-stmt.html
 share/doc/sqlite3/syntax/with-clause.html
 share/doc/sqlite3/syntaxdiagrams.html
@@ -900,6 +917,7 @@ share/doc/sqlite3/version3.html
 share/doc/sqlite3/versionnumbers.html
 share/doc/sqlite3/vfs.html
 share/doc/sqlite3/vtab.html
+share/doc/sqlite3/vtablist.html
 share/doc/sqlite3/wal.html
 share/doc/sqlite3/walformat.html
 share/doc/sqlite3/whentouse.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 6d193265c6c..4eb9b65cee4 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.77 2018/04/12 10:21:38 adam Exp $
+$NetBSD: distinfo,v 1.78 2018/06/07 07:36:49 adam Exp $
 
-SHA1 (sqlite-doc-3230100.zip) = a7bf3d789f2fc4e74c2eca01f9aa21124e705222
-RMD160 (sqlite-doc-3230100.zip) = 77cac27945c3e84b5eec4c51fcf23157fff465a3
-SHA512 (sqlite-doc-3230100.zip) = d3a42621480a928446c5f71d0f2ee68e245b071971da38438f9070bd5bcbe1930ea5bd20e06c68543df75badd2e4565abc94420df50b7152c9cd129587471471
-Size (sqlite-doc-3230100.zip) = 8882546 bytes
+SHA1 (sqlite-doc-3240000.zip) = 9684d06b7e6ec1868b1ef075993dc29d952dac97
+RMD160 (sqlite-doc-3240000.zip) = 66f10080117b2b8cc4034db6fb6377355db68c08
+SHA512 (sqlite-doc-3240000.zip) = 31e9046cea569d7ad1b3af176e1bb18cd59474afb6849871ead6e7c9c096f046162fb313a38684a8c944fad9f689c4c3c692be1d7dc6a8ef5a6685bbc7dfdab6
+Size (sqlite-doc-3240000.zip) = 9030826 bytes
diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index ca639588309..a3326dcb963 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.92 2018/04/14 07:34:14 adam Exp $
+# $NetBSD: Makefile,v 1.93 2018/06/07 07:36:49 adam Exp $
 
-PKGREVISION= 1
 .include "../../databases/sqlite3/Makefile.common"
 
 DISTNAME=	sqlite-autoconf-${SQLITE3_DISTVERSION}
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 9806cc113b3..524784edeb2 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.89 2018/04/12 10:21:38 adam Exp $
+$NetBSD: distinfo,v 1.90 2018/06/07 07:36:49 adam Exp $
 
-SHA1 (sqlite-autoconf-3230100.tar.gz) = 0edbfd75ececb95e8e6448d6ff33df82774c9646
-RMD160 (sqlite-autoconf-3230100.tar.gz) = 53070f0336914a525fa5aea282e9e5bebc703ff8
-SHA512 (sqlite-autoconf-3230100.tar.gz) = 52cae7ed0678b763d40373ae260672b906861379428529a58a017cbc82419a6b109e0b2ac7ff5532e6d941693cc4ab68e6563f424b92b3b27c8916859a6e4826
-Size (sqlite-autoconf-3230100.tar.gz) = 2675362 bytes
+SHA1 (sqlite-autoconf-3240000.tar.gz) = da68915e3563b5244cbcdb6c7e20fb35559bcfc6
+RMD160 (sqlite-autoconf-3240000.tar.gz) = e1d3566adf3c61065420bc02956e37fe8b3e546e
+SHA512 (sqlite-autoconf-3240000.tar.gz) = eaec866de26003ec36559aab15dd18dc0e6029453002a4eec5e176bb35a712b8b06c235436e6c1a226b67c7eb90d7a26c2b3b3d9a5e6e92a5af485236b77c878
+Size (sqlite-autoconf-3240000.tar.gz) = 2699252 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index 9bf9d8d9293..dbbddfc6e9c 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.123 2018/04/14 07:33:53 adam Exp $
+# $NetBSD: Makefile,v 1.124 2018/06/07 07:36:49 adam Exp $
 
-PKGREVISION= 1
 .include "Makefile.common"
 
 DISTNAME=	sqlite-autoconf-${SQLITE3_DISTVERSION}
diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common
index 24174455b69..b5fe4293429 100644
--- a/databases/sqlite3/Makefile.common
+++ b/databases/sqlite3/Makefile.common
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.53 2018/04/12 10:21:38 adam Exp $
+# $NetBSD: Makefile.common,v 1.54 2018/06/07 07:36:49 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=	3230100
-SQLITE3_VERSION=	3.23.1
+SQLITE3_DISTVERSION=	3240000
+SQLITE3_VERSION=	3.24.0
 
 MASTER_SITES=	http://www.sqlite.org/2018/
 MASTER_SITES+=	http://www.hwaci.com/sw/sqlite/2018/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 431b37fc4f2..93c60c8d8ce 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.142 2018/04/12 10:21:38 adam Exp $
+$NetBSD: distinfo,v 1.143 2018/06/07 07:36:49 adam Exp $
 
-SHA1 (sqlite-autoconf-3230100.tar.gz) = 0edbfd75ececb95e8e6448d6ff33df82774c9646
-RMD160 (sqlite-autoconf-3230100.tar.gz) = 53070f0336914a525fa5aea282e9e5bebc703ff8
-SHA512 (sqlite-autoconf-3230100.tar.gz) = 52cae7ed0678b763d40373ae260672b906861379428529a58a017cbc82419a6b109e0b2ac7ff5532e6d941693cc4ab68e6563f424b92b3b27c8916859a6e4826
-Size (sqlite-autoconf-3230100.tar.gz) = 2675362 bytes
+SHA1 (sqlite-autoconf-3240000.tar.gz) = da68915e3563b5244cbcdb6c7e20fb35559bcfc6
+RMD160 (sqlite-autoconf-3240000.tar.gz) = e1d3566adf3c61065420bc02956e37fe8b3e546e
+SHA512 (sqlite-autoconf-3240000.tar.gz) = eaec866de26003ec36559aab15dd18dc0e6029453002a4eec5e176bb35a712b8b06c235436e6c1a226b67c7eb90d7a26c2b3b3d9a5e6e92a5af485236b77c878
+Size (sqlite-autoconf-3240000.tar.gz) = 2699252 bytes
diff --git a/devel/lemon/distinfo b/devel/lemon/distinfo
index be63051f8ba..8d9a3bd6798 100644
--- a/devel/lemon/distinfo
+++ b/devel/lemon/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.18 2018/04/12 10:21:38 adam Exp $
+$NetBSD: distinfo,v 1.19 2018/06/07 07:36:49 adam Exp $
 
-SHA1 (sqlite-src-3230100.zip) = 90bea4e46a01e9c27356b19c3150a8bf146c09fc
-RMD160 (sqlite-src-3230100.zip) = ac5656f535e1316d890c8a4008d651781bb1aaeb
-SHA512 (sqlite-src-3230100.zip) = 69a87b76860c3b172d9e68b0fc0b8c157b606375e2b7d793ce4bd4b898ef737cd721189bc6a3342c749e224e60fa96203d449668c49dff2ebdc682b49630a59b
-Size (sqlite-src-3230100.zip) = 10849436 bytes
+SHA1 (sqlite-src-3240000.zip) = fb558c49ee21a837713c4f1e7e413309aabdd9c7
+RMD160 (sqlite-src-3240000.zip) = be4281044f05b6ebfe87cc7304d47fd854ad29c4
+SHA512 (sqlite-src-3240000.zip) = 812c2df7179abb1e445b5b3e161c940b120c53366a7b2c1f0bfc3599cd9921e5543ba39ca3f297eeaefec318f10c15f630f00f9cf04133c7cd419a04f3bbdd0e
+Size (sqlite-src-3240000.zip) = 10980065 bytes