patch-ab: regen

Makefile: bump
Makefile.common: document why this needs to be done

4 files changed, 21 insertions, 14 deletions

diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index b5e259c3c9e..3fe08f6e866 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,5 +1,6 @@
-# $NetBSD: Makefile,v 1.19 2009/05/21 11:44:42 adam Exp $
+# $NetBSD: Makefile,v 1.20 2009/10/28 16:46:51 tnn Exp $
 
+PKGREVISION=		1
 PKG_DESTDIR_SUPPORT=	user-destdir
 
 .include "Makefile.common"
diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common
index 108c00d3c5b..7a6f4c85e35 100644
--- a/databases/sqlite3/Makefile.common
+++ b/databases/sqlite3/Makefile.common
@@ -1,7 +1,9 @@
-# $NetBSD: Makefile.common,v 1.45 2009/10/28 06:42:37 adam Exp $
+# $NetBSD: Makefile.common,v 1.46 2009/10/28 16:46:51 tnn Exp $
 
 # used by databases/sqlite3-tcl/Makefile
 
+# When updating this package, you must regenerate patch-ab!
+# It's required to avoid a build dependency on tcl.
 DISTNAME=	sqlite-3.6.19
 PKGNAME=	${DISTNAME:S/-/3-/}
 CATEGORIES=	databases
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index daa43244ed6..a00450c9368 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.43 2009/10/28 06:42:37 adam Exp $
+$NetBSD: distinfo,v 1.44 2009/10/28 16:46:51 tnn Exp $
 
 SHA1 (sqlite-3.6.19.tar.gz) = 1f85a324edfb42ec00bb6dbbec5a178346c950ee
 RMD160 (sqlite-3.6.19.tar.gz) = 119db76399eca04f21051c6ff156ccbb0c8d35b5
 Size (sqlite-3.6.19.tar.gz) = 2942005 bytes
 SHA1 (patch-aa) = bc0670df079e1a49422ba540d8272e503d20a33f
-SHA1 (patch-ab) = ef83eef8bd79efe40d4a8eb6408c148653925f21
+SHA1 (patch-ab) = 0abd0c57bcdcd1132ed546cf6128112f9b1101fe
diff --git a/databases/sqlite3/patches/patch-ab b/databases/sqlite3/patches/patch-ab
index 8469ae74155..77c7888a4d6 100644
--- a/databases/sqlite3/patches/patch-ab
+++ b/databases/sqlite3/patches/patch-ab
@@ -1,8 +1,8 @@
-$NetBSD: patch-ab,v 1.3 2009/10/11 16:06:21 tnn Exp $
+$NetBSD: patch-ab,v 1.4 2009/10/28 16:46:51 tnn Exp $
 
---- sqlite3.h.orig	2009-10-11 18:02:11.000000000 +0200
+--- sqlite3.h.orig	2009-10-28 17:39:08.000000000 +0100
 +++ sqlite3.h
-@@ -0,0 +1,5759 @@
+@@ -0,0 +1,5763 @@
 +/*
 +** 2001 September 15
 +**
@@ -124,9 +124,9 @@ $NetBSD: patch-ab,v 1.3 2009/10/11 16:06:21 tnn Exp $
 +**
 +** Requirements: [H10011] [H10014]
 +*/
-+#define SQLITE_VERSION        "3.6.18"
-+#define SQLITE_VERSION_NUMBER 3006018
-+#define SQLITE_SOURCE_ID      "2009-09-11 14:05:07 b084828a771ec40be85f07c590ca99de4f6c24ee"
++#define SQLITE_VERSION        "3.6.19"
++#define SQLITE_VERSION_NUMBER 3006019
++#define SQLITE_SOURCE_ID      "2009-10-14 11:33:55 c1d499afc50d54b376945b4efb65c56c787a073d"
 +
 +/*
 +** CAPI3REF: Run-Time Library Version Numbers {H10020} <S60100>
@@ -1321,8 +1321,9 @@ $NetBSD: patch-ab,v 1.3 2009/10/11 16:06:21 tnn Exp $
 +** on the [database connection] specified by the first parameter.
 +** Only changes that are directly specified by the [INSERT], [UPDATE],
 +** or [DELETE] statement are counted.  Auxiliary changes caused by
-+** triggers are not counted. Use the [sqlite3_total_changes()] function
-+** to find the total number of changes including changes caused by triggers.
++** triggers or [foreign key actions] are not counted. Use the
++** [sqlite3_total_changes()] function to find the total number of changes
++** including changes caused by triggers and foreign key actions.
 +**
 +** Changes to a view that are simulated by an [INSTEAD OF trigger]
 +** are not counted.  Only real table changes are counted.
@@ -1374,8 +1375,8 @@ $NetBSD: patch-ab,v 1.3 2009/10/11 16:06:21 tnn Exp $
 +**
 +** This function returns the number of row changes caused by [INSERT],
 +** [UPDATE] or [DELETE] statements since the [database connection] was opened.
-+** The count includes all changes from all 
-+** [CREATE TRIGGER | trigger] contexts.  However,
++** The count includes all changes from all [CREATE TRIGGER | trigger] 
++** contexts and changes made by [foreign key actions]. However,
 +** the count does not include changes used to implement [REPLACE] constraints,
 +** do rollbacks or ABORT processing, or [DROP TABLE] processing.  The
 +** count does not include rows of views that fire an [INSTEAD OF trigger],
@@ -4516,6 +4517,9 @@ $NetBSD: patch-ab,v 1.3 2009/10/11 16:06:21 tnn Exp $
 +**
 +** If the flags parameter is non-zero, then the BLOB is opened for read
 +** and write access. If it is zero, the BLOB is opened for read access.
++** It is not possible to open a column that is part of an index or primary 
++** key for writing. ^If [foreign key constraints] are enabled, it is 
++** not possible to open a column that is part of a [child key] for writing.
 +**
 +** Note that the database name is not the filename that contains
 +** the database but rather the symbolic name of the database that