20 files changed, 112 insertions, 328 deletions

diff --git a/databases/sqlite/Makefile b/databases/sqlite/Makefile
index a08f79690cde..132e4d543f16 100644
--- a/databases/sqlite/Makefile
+++ b/databases/sqlite/Makefile
@@ -7,59 +7,51 @@
 #
 
 PORTNAME=	sqlite
-PORTVERSION=	1.0.32
+PORTVERSION=	2.7.1
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/
+DISTNAME=	${PORTNAME}-${PORTVERSION}
 
-MAINTAINER=	ports@FreeBSD.org
+MAINTAINER=	gerhard.haering@gmx.de
 
-LIB_DEPENDS=	gdbm.2:${PORTSDIR}/databases/gdbm \
-		tcl${TCL_VER:S/.//}:${PORTSDIR}/lang/tcl${TCL_VER:S/.//}
-BUILD_DEPENDS=	lemon:${PORTSDIR}/devel/lemon
+LIB_DEPENDS=	tcl${TCL_VER:S/.//}:${PORTSDIR}/lang/tcl${TCL_VER:S/.//}
 
-MAKEFILE=	${FILESDIR}/Makefile.bsd
-MAKE_ARGS+=	-j2
+USE_GMAKE=	YES
+GNU_CONFIGURE=	YES
+USE_REINPLACE=  YES
+CONFIGURE_ARGS= --prefix=${PREFIX} --with-hints=freebsd.hints
+INSTALLS_SHLIB=	YES
+
+WRKSRC=		${WRKDIR}/${PORTNAME}
+MAKE_ARGS+=	TCLSH=tclsh${TCL_VER}
 MAKE_ENV+=	TCL_VER=${TCL_VER}
 TCL_VER?=	8.3
 
-GDBM_TOOLS=	gdbmdump gdbmstat
+DOCFILES=	arch.html arch.png c_interface.html changes.html \
+		crosscompile.html download.html faq.html index.html \
+		lang.html lemon.html mingw.html opcode.html report1.txt \
+		speed.html sqlite.html tclsqlite.html vdbe.html
 
-post-build:	test
-.for p in ${GDBM_TOOLS}
-	cd ${WRKSRC}/tool && ${MAKE} CFLAGS="${CFLAGS} -I${PREFIX}/include" \
-		LDADD="-L${PREFIX}/lib -lgdbm" PROG=$p NOMAN=1 \
-		-f bsd.prog.mk
-.endfor
-	cd ${WRKSRC} && ${MAKE} VPATH=${WRKSRC}/src \
-		CFLAGS="${CFLAGS} -I${WRKSRC} -I${WRKSRC}/src" \
-		LDADD="-L${WRKSRC} -lsqlite" PROG=sqlite SRCS=shell.c NOMAN=1 \
-		-f bsd.prog.mk
-.ifndef NOPORTDOCS
-	cd ${WRKSRC}/www && ${SETENV} ${MAKE_ENV} \
-		${MAKE} ${MAKE_ARGS} -f ${FILESDIR}/Makefile.docs
-.endif
+DOCSDIR=	${PREFIX}/share/doc/${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e "s/tclsh \$$(TOP)/\$$(TCLSH) \$$(TOP)/g" ${WRKSRC}/Makefile.in
+	${ECHO} "config_TARGET_TCL_INC=\"-I${PREFIX}/include/tcl${TCL_VER}\"" >${WRKSRC}/freebsd.hints
+	${ECHO} "config_TARGET_TCL_LIBS=\"-L${PREFIX}/lib -ltcl${TCL_VER:S/.//}\"" >>${WRKSRC}/freebsd.hints
+	#${ECHO} "config_TARGET_CFLAGS=\"-DTHREADSAFE=1 -pthread\"" >>${WRKSRC}/freebsd.hints
+
+post-build:
+	# Build the docs
+	cd ${WRKSRC} && ${MAKE} ${MAKE_ARGS} doc
 
 post-install:
-.for p in ${GDBM_TOOLS}
-	cd ${WRKSRC}/tool && ${MAKE} BINDIR="${PREFIX}/bin" \
-		PROG=$p NOMAN=1 -f bsd.prog.mk install
+	${INSTALL_DATA} ${FILESDIR}/pkgIndex.tcl ${PREFIX}/lib/
+.if !defined(NOPORTDOCS)
+	@${MKDIR} ${DOCSDIR}
+#	@${INSTALL_DATA} ${FILESDIR}/example.tcl ${DOCSDIR}
+.for file in ${DOCFILES}
+	@${INSTALL_DATA} ${WRKSRC}/doc//${file} ${DOCSDIR}
 .endfor
-	cd ${WRKSRC} && ${MAKE} PROG=sqlite NOMAN=1 BINDIR="${PREFIX}/bin" \
-		-f bsd.prog.mk install
-	${MKDIR} ${PREFIX}/lib/sqlite
-	${INSTALL_DATA} ${FILESDIR}/pkgIndex.tcl ${PREFIX}/lib/sqlite/
-.ifndef NOPORTDOCS
-	${MKDIR} ${PREFIX}/share/doc/sqlite
-	${INSTALL_DATA} ${WRKSRC}/www/*.html ${WRKSRC}/www/*.png \
-		${PREFIX}/share/doc/sqlite
 .endif
 
-test:
-	# -------------------------------------------------------
-	# Running the vendor's tests -- there should be 0 errors.
-	# -------------------------------------------------------
-	cd ${WRKSRC} && ${PREFIX}/bin/tclsh${TCL_VER} ${WRKSRC}/test/all.test \
-		${WRKSRC}/libsqlite.so
-	# -------------------------------------------------------
-
 .include <bsd.port.mk>
diff --git a/databases/sqlite/distinfo b/databases/sqlite/distinfo
index 311a0ded1b81..898ae5ffcc69 100644
--- a/databases/sqlite/distinfo
+++ b/databases/sqlite/distinfo
@@ -1 +1 @@
-MD5 (sqlite-1.0.32.tar.gz) = 308be6d8b9e9514150ef4f89902b2fbc
+MD5 (sqlite-2.7.1.tar.gz) = 4910d3603365ab042cf78a1ec6304bb6
diff --git a/databases/sqlite/files/Makefile.bsd b/databases/sqlite/files/Makefile.bsd
deleted file mode 100644
index 2b8d83f17612..000000000000
--- a/databases/sqlite/files/Makefile.bsd
+++ /dev/null
@@ -1,38 +0,0 @@
-TCL_VER	?=	8.3
-TCL_DVER =	${TCL_VER:S/.//}
-PREFIX	?=	/usr/local
-
-CFLAGS	+=	-DHAVE_READLINE=1 -DOS_UNIX=1 -DOS_WIN=0
-CFLAGS	+=	-I${PREFIX}/include/tcl${TCL_VER} -I${PREFIX}/include
-CFLAGS	+=	-I${.CURDIR}/src -I${.CURDIR}
-
-LDADD	+=	-lreadline -L${PREFIX}/lib -ltcl${TCL_DVER} -lm -lgdbm
-
-.PATH:	${.CURDIR}/src
-
-SRCS	 =	btree.c build.c dbbe.c dbbegdbm.c dbbemem.c delete.c expr.c \
-		insert.c main.c pager.c parse.y printf.c random.c select.c \
-		shell.c table.c tokenize.c update.c util.c vdbe.c where.c \
-		tclsqlite.c
-
-INCS	 =	sqlite.h
-
-LIB	 =	sqlite
-SHLIB_MAJOR=	1
-SHLIB_MINOR=	0
-
-sqlite.h:	sqlite.h.in VERSION
-	sed -e s/--VERS--/`cat ${.CURDIR}/VERSION`/ \
-            -e s/--ENCODING--/ISO8859/ \
-                 ${.CURDIR}/src/sqlite.h.in > sqlite.h
-
-parse.h parse.c: parse.y
-	lemon o=parse ${.ALLSRC}
-
-INCSDIR	 =	${PREFIX}/include
-INCDIR	 =	${INCSDIR}		# for pre-bsd.incs.mk API
-LIBDIR	 =	${PREFIX}/lib
-
-.include <bsd.lib.mk>
-
-${OBJS} ${SOBJS}: parse.h sqlite.h
diff --git a/databases/sqlite/files/Makefile.docs b/databases/sqlite/files/Makefile.docs
deleted file mode 100644
index 77d95a57d548..000000000000
--- a/databases/sqlite/files/Makefile.docs
+++ /dev/null
@@ -1,25 +0,0 @@
-TCL_VER	?=	8.3
-
-SRCS	!=	echo ${.CURDIR}/*.tcl
-DOCS	 =	${SRCS:Nopcode.tcl:.tcl=.html}
-CODE	!=	echo ${.CURDIR}/../src/*.[chy]
-
-all:	${DOCS} opcode.html
-
-opcode.html:: opcode.tcl vdbe.c
-	tclsh${TCL_VER} ${.ALLSRC} > opcode.html
-
-.SUFFIXES:	.tcl .html
-
-.tcl.html:
-	tclsh${TCL_VER} $*.tcl > $*.html
-
-${DOCS}:	last_change
-
-.PATH: ${.CURDIR}/../src
-
-last_change: ${CODE}
-	awk '/\$$Id:/ && NF > 4 { \
-		if ($$2 == "\$$Id:") print $$5 "," $$6; \
-		else print $$6 "," $$7 \
-	}' ${.ALLSRC} | sort -t, | tail -1 > lc && mv lc last_change
diff --git a/databases/sqlite/files/patch-docs b/databases/sqlite/files/patch-docs
deleted file mode 100644
index ce5498da4d16..000000000000
--- a/databases/sqlite/files/patch-docs
+++ /dev/null
@@ -1,30 +0,0 @@
---- www/index.tcl	Thu Apr  5 12:49:44 2001
-+++ www/index.tcl	Fri Jun  8 17:46:08 2001
-@@ -117,12 +117,6 @@
- 
--puts {<h2>Download</h2>
-+puts "<!-- h2>Download</h2 --><h3>This installation of Sqlite $vers was made"
-+puts {by the <A href="http://www.freebsd.org/cgi/ports.cgi?query=sqlite">FreeBSD
-+Port</A>.</h3>}
- 
--<p>You can download a tarball containing all source
--code for SQLite
--}
--puts "version $vers"
--puts {
--(including the TCL scripts that generate the
--HTML files for this website) at <a href="sqlite.tar.gz">sqlite.tar.gz</a>.}
--puts "This is a [file size sqlite.tar.gz] byte download."
- puts {</p>
---- www/dynload.tcl	Sun Feb 11 11:58:22 2001
-+++ www/dynload.tcl	Mon Jun 11 19:09:47 2001
-@@ -15,3 +15,3 @@
- <i>This note was contributed by 
--<a href="bsaunder@tampabay.rr.com.nospam">Bill Saunders</a>.  Thanks, Bill!</i>
-+<a href="mailto:bsaunder@tampabay.rr.com.nospam">Bill Saunders</a>.  Thanks, Bill!</i>
- 
-@@ -67,3 +67,3 @@
- Have fun....</p></li>
--</ul>
-+</ol>
- 
diff --git a/databases/sqlite/files/patch-test b/databases/sqlite/files/patch-test
deleted file mode 100644
index 3adee03362f9..000000000000
--- a/databases/sqlite/files/patch-test
+++ /dev/null
@@ -1,12 +0,0 @@
---- test/all.test	Tue Feb  6 08:29:31 2001
-+++ test/all.test	Fri Jun  8 16:28:34 2001
-@@ -27,2 +27,3 @@
- set testdir [file dirname $argv0]
-+load [lindex $argv 0]
- source $testdir/tester.tcl
---- test/tableapi.test.orig	Wed Apr 11 23:28:43 2001
-+++ test/tableapi.test	Mon Sep  3 21:24:06 2001
-@@ -30,2 +30,3 @@
- source $testdir/tester.tcl
-+set ::big_str ""
- 
diff --git a/databases/sqlite/files/pkgIndex.tcl b/databases/sqlite/files/pkgIndex.tcl
index df0b6bb0a82d..dba694a3bc8b 100644
--- a/databases/sqlite/files/pkgIndex.tcl
+++ b/databases/sqlite/files/pkgIndex.tcl
@@ -1 +1 @@
-package ifneeded sqlite 1.0 [list load $dir/../libsqlite.so]
+package ifneeded sqlite 0.0 [list load [file join $dir libtclsqlite.so.0] sqlite]
diff --git a/databases/sqlite/pkg-comment b/databases/sqlite/pkg-comment
index 750bd919d8c7..b10cb4bd83ea 100644
--- a/databases/sqlite/pkg-comment
+++ b/databases/sqlite/pkg-comment
@@ -1 +1 @@
-SQL library that uses GDBM as its underlying file storage mechanism
+An SQL database engine in a C library, including a Tcl wrapper
diff --git a/databases/sqlite/pkg-descr b/databases/sqlite/pkg-descr
index 9637e448f5bb..391d99ee6abf 100644
--- a/databases/sqlite/pkg-descr
+++ b/databases/sqlite/pkg-descr
@@ -1,8 +1,7 @@
-SQLite is an SQL database library that uses GDBM as its underlying
-file storage mechanism. Programs that link the SQLite library can
-have SQL database access without running a separate RDBMS process.
-The distribution comes with a standalone command-line access program
-(sqlite) that can be used to administer an SQLite database and which
-serves as an example of how to use the SQLite library.
+SQLite is an SQL database engine in a C library. Programs that link the SQLite
+library can have SQL database access without running a separate RDBMS process.
+The distribution comes with a standalone command-line access program (sqlite)
+that can be used to administer an SQLite database and which serves as an
+example of how to use the SQLite library.
 
 WWW: http://www.hwaci.com/sw/sqlite/
diff --git a/databases/sqlite/pkg-plist b/databases/sqlite/pkg-plist
index 1004425fe405..9109d356510d 100644
--- a/databases/sqlite/pkg-plist
+++ b/databases/sqlite/pkg-plist
@@ -1,25 +1,31 @@
 bin/sqlite
-bin/gdbmdump
-bin/gdbmstat
+include/sqlite.h
 lib/libsqlite.a
-lib/libsqlite_p.a
+lib/libsqlite.la
 lib/libsqlite.so
-lib/libsqlite.so.1.0
-lib/sqlite/pkgIndex.tcl
-@dirrm lib/sqlite
-include/sqlite.h
+lib/libsqlite.so.0
+@comment lib/sqlite/libtclsqlite.so.0
+@comment lib/sqlite/libtclsqlite.so
+@comment lib/sqlite/libtclsqlite.la
+@comment lib/sqlite/libtclsqlite.a
+@comment lib/sqlite/pkgIndex.tcl
+@comment @dirrm lib/sqlite
 %%PORTDOCS%%share/doc/sqlite/arch.html
 %%PORTDOCS%%share/doc/sqlite/arch.png
 %%PORTDOCS%%share/doc/sqlite/c_interface.html
 %%PORTDOCS%%share/doc/sqlite/changes.html
 %%PORTDOCS%%share/doc/sqlite/crosscompile.html
-%%PORTDOCS%%share/doc/sqlite/dynload.html
-%%PORTDOCS%%share/doc/sqlite/fileformat.html
+%%PORTDOCS%%share/doc/sqlite/download.html
+%%PORTDOCS%%share/doc/sqlite/faq.html
 %%PORTDOCS%%share/doc/sqlite/index.html
 %%PORTDOCS%%share/doc/sqlite/lang.html
+%%PORTDOCS%%share/doc/sqlite/lemon.html
 %%PORTDOCS%%share/doc/sqlite/mingw.html
 %%PORTDOCS%%share/doc/sqlite/opcode.html
+%%PORTDOCS%%share/doc/sqlite/report1.txt
+%%PORTDOCS%%share/doc/sqlite/speed.html
 %%PORTDOCS%%share/doc/sqlite/sqlite.html
 %%PORTDOCS%%share/doc/sqlite/tclsqlite.html
 %%PORTDOCS%%share/doc/sqlite/vdbe.html
+@comment %%PORTDOCS%%share/doc/sqlite/example.tcl
 %%PORTDOCS%%@dirrm share/doc/sqlite
diff --git a/databases/sqlite2/Makefile b/databases/sqlite2/Makefile
index a08f79690cde..132e4d543f16 100644
--- a/databases/sqlite2/Makefile
+++ b/databases/sqlite2/Makefile
@@ -7,59 +7,51 @@
 #
 
 PORTNAME=	sqlite
-PORTVERSION=	1.0.32
+PORTVERSION=	2.7.1
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/
+DISTNAME=	${PORTNAME}-${PORTVERSION}
 
-MAINTAINER=	ports@FreeBSD.org
+MAINTAINER=	gerhard.haering@gmx.de
 
-LIB_DEPENDS=	gdbm.2:${PORTSDIR}/databases/gdbm \
-		tcl${TCL_VER:S/.//}:${PORTSDIR}/lang/tcl${TCL_VER:S/.//}
-BUILD_DEPENDS=	lemon:${PORTSDIR}/devel/lemon
+LIB_DEPENDS=	tcl${TCL_VER:S/.//}:${PORTSDIR}/lang/tcl${TCL_VER:S/.//}
 
-MAKEFILE=	${FILESDIR}/Makefile.bsd
-MAKE_ARGS+=	-j2
+USE_GMAKE=	YES
+GNU_CONFIGURE=	YES
+USE_REINPLACE=  YES
+CONFIGURE_ARGS= --prefix=${PREFIX} --with-hints=freebsd.hints
+INSTALLS_SHLIB=	YES
+
+WRKSRC=		${WRKDIR}/${PORTNAME}
+MAKE_ARGS+=	TCLSH=tclsh${TCL_VER}
 MAKE_ENV+=	TCL_VER=${TCL_VER}
 TCL_VER?=	8.3
 
-GDBM_TOOLS=	gdbmdump gdbmstat
+DOCFILES=	arch.html arch.png c_interface.html changes.html \
+		crosscompile.html download.html faq.html index.html \
+		lang.html lemon.html mingw.html opcode.html report1.txt \
+		speed.html sqlite.html tclsqlite.html vdbe.html
 
-post-build:	test
-.for p in ${GDBM_TOOLS}
-	cd ${WRKSRC}/tool && ${MAKE} CFLAGS="${CFLAGS} -I${PREFIX}/include" \
-		LDADD="-L${PREFIX}/lib -lgdbm" PROG=$p NOMAN=1 \
-		-f bsd.prog.mk
-.endfor
-	cd ${WRKSRC} && ${MAKE} VPATH=${WRKSRC}/src \
-		CFLAGS="${CFLAGS} -I${WRKSRC} -I${WRKSRC}/src" \
-		LDADD="-L${WRKSRC} -lsqlite" PROG=sqlite SRCS=shell.c NOMAN=1 \
-		-f bsd.prog.mk
-.ifndef NOPORTDOCS
-	cd ${WRKSRC}/www && ${SETENV} ${MAKE_ENV} \
-		${MAKE} ${MAKE_ARGS} -f ${FILESDIR}/Makefile.docs
-.endif
+DOCSDIR=	${PREFIX}/share/doc/${PORTNAME}
+
+post-patch:
+	${REINPLACE_CMD} -e "s/tclsh \$$(TOP)/\$$(TCLSH) \$$(TOP)/g" ${WRKSRC}/Makefile.in
+	${ECHO} "config_TARGET_TCL_INC=\"-I${PREFIX}/include/tcl${TCL_VER}\"" >${WRKSRC}/freebsd.hints
+	${ECHO} "config_TARGET_TCL_LIBS=\"-L${PREFIX}/lib -ltcl${TCL_VER:S/.//}\"" >>${WRKSRC}/freebsd.hints
+	#${ECHO} "config_TARGET_CFLAGS=\"-DTHREADSAFE=1 -pthread\"" >>${WRKSRC}/freebsd.hints
+
+post-build:
+	# Build the docs
+	cd ${WRKSRC} && ${MAKE} ${MAKE_ARGS} doc
 
 post-install:
-.for p in ${GDBM_TOOLS}
-	cd ${WRKSRC}/tool && ${MAKE} BINDIR="${PREFIX}/bin" \
-		PROG=$p NOMAN=1 -f bsd.prog.mk install
+	${INSTALL_DATA} ${FILESDIR}/pkgIndex.tcl ${PREFIX}/lib/
+.if !defined(NOPORTDOCS)
+	@${MKDIR} ${DOCSDIR}
+#	@${INSTALL_DATA} ${FILESDIR}/example.tcl ${DOCSDIR}
+.for file in ${DOCFILES}
+	@${INSTALL_DATA} ${WRKSRC}/doc//${file} ${DOCSDIR}
 .endfor
-	cd ${WRKSRC} && ${MAKE} PROG=sqlite NOMAN=1 BINDIR="${PREFIX}/bin" \
-		-f bsd.prog.mk install
-	${MKDIR} ${PREFIX}/lib/sqlite
-	${INSTALL_DATA} ${FILESDIR}/pkgIndex.tcl ${PREFIX}/lib/sqlite/
-.ifndef NOPORTDOCS
-	${MKDIR} ${PREFIX}/share/doc/sqlite
-	${INSTALL_DATA} ${WRKSRC}/www/*.html ${WRKSRC}/www/*.png \
-		${PREFIX}/share/doc/sqlite
 .endif
 
-test:
-	# -------------------------------------------------------
-	# Running the vendor's tests -- there should be 0 errors.
-	# -------------------------------------------------------
-	cd ${WRKSRC} && ${PREFIX}/bin/tclsh${TCL_VER} ${WRKSRC}/test/all.test \
-		${WRKSRC}/libsqlite.so
-	# -------------------------------------------------------
-
 .include <bsd.port.mk>
diff --git a/databases/sqlite2/distinfo b/databases/sqlite2/distinfo
index 311a0ded1b81..898ae5ffcc69 100644
--- a/databases/sqlite2/distinfo
+++ b/databases/sqlite2/distinfo
@@ -1 +1 @@
-MD5 (sqlite-1.0.32.tar.gz) = 308be6d8b9e9514150ef4f89902b2fbc
+MD5 (sqlite-2.7.1.tar.gz) = 4910d3603365ab042cf78a1ec6304bb6
diff --git a/databases/sqlite2/files/Makefile.bsd b/databases/sqlite2/files/Makefile.bsd
deleted file mode 100644
index 2b8d83f17612..000000000000
--- a/databases/sqlite2/files/Makefile.bsd
+++ /dev/null
@@ -1,38 +0,0 @@
-TCL_VER	?=	8.3
-TCL_DVER =	${TCL_VER:S/.//}
-PREFIX	?=	/usr/local
-
-CFLAGS	+=	-DHAVE_READLINE=1 -DOS_UNIX=1 -DOS_WIN=0
-CFLAGS	+=	-I${PREFIX}/include/tcl${TCL_VER} -I${PREFIX}/include
-CFLAGS	+=	-I${.CURDIR}/src -I${.CURDIR}
-
-LDADD	+=	-lreadline -L${PREFIX}/lib -ltcl${TCL_DVER} -lm -lgdbm
-
-.PATH:	${.CURDIR}/src
-
-SRCS	 =	btree.c build.c dbbe.c dbbegdbm.c dbbemem.c delete.c expr.c \
-		insert.c main.c pager.c parse.y printf.c random.c select.c \
-		shell.c table.c tokenize.c update.c util.c vdbe.c where.c \
-		tclsqlite.c
-
-INCS	 =	sqlite.h
-
-LIB	 =	sqlite
-SHLIB_MAJOR=	1
-SHLIB_MINOR=	0
-
-sqlite.h:	sqlite.h.in VERSION
-	sed -e s/--VERS--/`cat ${.CURDIR}/VERSION`/ \
-            -e s/--ENCODING--/ISO8859/ \
-                 ${.CURDIR}/src/sqlite.h.in > sqlite.h
-
-parse.h parse.c: parse.y
-	lemon o=parse ${.ALLSRC}
-
-INCSDIR	 =	${PREFIX}/include
-INCDIR	 =	${INCSDIR}		# for pre-bsd.incs.mk API
-LIBDIR	 =	${PREFIX}/lib
-
-.include <bsd.lib.mk>
-
-${OBJS} ${SOBJS}: parse.h sqlite.h
diff --git a/databases/sqlite2/files/Makefile.docs b/databases/sqlite2/files/Makefile.docs
deleted file mode 100644
index 77d95a57d548..000000000000
--- a/databases/sqlite2/files/Makefile.docs
+++ /dev/null
@@ -1,25 +0,0 @@
-TCL_VER	?=	8.3
-
-SRCS	!=	echo ${.CURDIR}/*.tcl
-DOCS	 =	${SRCS:Nopcode.tcl:.tcl=.html}
-CODE	!=	echo ${.CURDIR}/../src/*.[chy]
-
-all:	${DOCS} opcode.html
-
-opcode.html:: opcode.tcl vdbe.c
-	tclsh${TCL_VER} ${.ALLSRC} > opcode.html
-
-.SUFFIXES:	.tcl .html
-
-.tcl.html:
-	tclsh${TCL_VER} $*.tcl > $*.html
-
-${DOCS}:	last_change
-
-.PATH: ${.CURDIR}/../src
-
-last_change: ${CODE}
-	awk '/\$$Id:/ && NF > 4 { \
-		if ($$2 == "\$$Id:") print $$5 "," $$6; \
-		else print $$6 "," $$7 \
-	}' ${.ALLSRC} | sort -t, | tail -1 > lc && mv lc last_change
diff --git a/databases/sqlite2/files/patch-docs b/databases/sqlite2/files/patch-docs
deleted file mode 100644
index ce5498da4d16..000000000000
--- a/databases/sqlite2/files/patch-docs
+++ /dev/null
@@ -1,30 +0,0 @@
---- www/index.tcl	Thu Apr  5 12:49:44 2001
-+++ www/index.tcl	Fri Jun  8 17:46:08 2001
-@@ -117,12 +117,6 @@
- 
--puts {<h2>Download</h2>
-+puts "<!-- h2>Download</h2 --><h3>This installation of Sqlite $vers was made"
-+puts {by the <A href="http://www.freebsd.org/cgi/ports.cgi?query=sqlite">FreeBSD
-+Port</A>.</h3>}
- 
--<p>You can download a tarball containing all source
--code for SQLite
--}
--puts "version $vers"
--puts {
--(including the TCL scripts that generate the
--HTML files for this website) at <a href="sqlite.tar.gz">sqlite.tar.gz</a>.}
--puts "This is a [file size sqlite.tar.gz] byte download."
- puts {</p>
---- www/dynload.tcl	Sun Feb 11 11:58:22 2001
-+++ www/dynload.tcl	Mon Jun 11 19:09:47 2001
-@@ -15,3 +15,3 @@
- <i>This note was contributed by 
--<a href="bsaunder@tampabay.rr.com.nospam">Bill Saunders</a>.  Thanks, Bill!</i>
-+<a href="mailto:bsaunder@tampabay.rr.com.nospam">Bill Saunders</a>.  Thanks, Bill!</i>
- 
-@@ -67,3 +67,3 @@
- Have fun....</p></li>
--</ul>
-+</ol>
- 
diff --git a/databases/sqlite2/files/patch-test b/databases/sqlite2/files/patch-test
deleted file mode 100644
index 3adee03362f9..000000000000
--- a/databases/sqlite2/files/patch-test
+++ /dev/null
@@ -1,12 +0,0 @@
---- test/all.test	Tue Feb  6 08:29:31 2001
-+++ test/all.test	Fri Jun  8 16:28:34 2001
-@@ -27,2 +27,3 @@
- set testdir [file dirname $argv0]
-+load [lindex $argv 0]
- source $testdir/tester.tcl
---- test/tableapi.test.orig	Wed Apr 11 23:28:43 2001
-+++ test/tableapi.test	Mon Sep  3 21:24:06 2001
-@@ -30,2 +30,3 @@
- source $testdir/tester.tcl
-+set ::big_str ""
- 
diff --git a/databases/sqlite2/files/pkgIndex.tcl b/databases/sqlite2/files/pkgIndex.tcl
index df0b6bb0a82d..dba694a3bc8b 100644
--- a/databases/sqlite2/files/pkgIndex.tcl
+++ b/databases/sqlite2/files/pkgIndex.tcl
@@ -1 +1 @@
-package ifneeded sqlite 1.0 [list load $dir/../libsqlite.so]
+package ifneeded sqlite 0.0 [list load [file join $dir libtclsqlite.so.0] sqlite]
diff --git a/databases/sqlite2/pkg-comment b/databases/sqlite2/pkg-comment
index 750bd919d8c7..b10cb4bd83ea 100644
--- a/databases/sqlite2/pkg-comment
+++ b/databases/sqlite2/pkg-comment
@@ -1 +1 @@
-SQL library that uses GDBM as its underlying file storage mechanism
+An SQL database engine in a C library, including a Tcl wrapper
diff --git a/databases/sqlite2/pkg-descr b/databases/sqlite2/pkg-descr
index 9637e448f5bb..391d99ee6abf 100644
--- a/databases/sqlite2/pkg-descr
+++ b/databases/sqlite2/pkg-descr
@@ -1,8 +1,7 @@
-SQLite is an SQL database library that uses GDBM as its underlying
-file storage mechanism. Programs that link the SQLite library can
-have SQL database access without running a separate RDBMS process.
-The distribution comes with a standalone command-line access program
-(sqlite) that can be used to administer an SQLite database and which
-serves as an example of how to use the SQLite library.
+SQLite is an SQL database engine in a C library. Programs that link the SQLite
+library can have SQL database access without running a separate RDBMS process.
+The distribution comes with a standalone command-line access program (sqlite)
+that can be used to administer an SQLite database and which serves as an
+example of how to use the SQLite library.
 
 WWW: http://www.hwaci.com/sw/sqlite/
diff --git a/databases/sqlite2/pkg-plist b/databases/sqlite2/pkg-plist
index 1004425fe405..9109d356510d 100644
--- a/databases/sqlite2/pkg-plist
+++ b/databases/sqlite2/pkg-plist
@@ -1,25 +1,31 @@
 bin/sqlite
-bin/gdbmdump
-bin/gdbmstat
+include/sqlite.h
 lib/libsqlite.a
-lib/libsqlite_p.a
+lib/libsqlite.la
 lib/libsqlite.so
-lib/libsqlite.so.1.0
-lib/sqlite/pkgIndex.tcl
-@dirrm lib/sqlite
-include/sqlite.h
+lib/libsqlite.so.0
+@comment lib/sqlite/libtclsqlite.so.0
+@comment lib/sqlite/libtclsqlite.so
+@comment lib/sqlite/libtclsqlite.la
+@comment lib/sqlite/libtclsqlite.a
+@comment lib/sqlite/pkgIndex.tcl
+@comment @dirrm lib/sqlite
 %%PORTDOCS%%share/doc/sqlite/arch.html
 %%PORTDOCS%%share/doc/sqlite/arch.png
 %%PORTDOCS%%share/doc/sqlite/c_interface.html
 %%PORTDOCS%%share/doc/sqlite/changes.html
 %%PORTDOCS%%share/doc/sqlite/crosscompile.html
-%%PORTDOCS%%share/doc/sqlite/dynload.html
-%%PORTDOCS%%share/doc/sqlite/fileformat.html
+%%PORTDOCS%%share/doc/sqlite/download.html
+%%PORTDOCS%%share/doc/sqlite/faq.html
 %%PORTDOCS%%share/doc/sqlite/index.html
 %%PORTDOCS%%share/doc/sqlite/lang.html
+%%PORTDOCS%%share/doc/sqlite/lemon.html
 %%PORTDOCS%%share/doc/sqlite/mingw.html
 %%PORTDOCS%%share/doc/sqlite/opcode.html
+%%PORTDOCS%%share/doc/sqlite/report1.txt
+%%PORTDOCS%%share/doc/sqlite/speed.html
 %%PORTDOCS%%share/doc/sqlite/sqlite.html
 %%PORTDOCS%%share/doc/sqlite/tclsqlite.html
 %%PORTDOCS%%share/doc/sqlite/vdbe.html
+@comment %%PORTDOCS%%share/doc/sqlite/example.tcl
 %%PORTDOCS%%@dirrm share/doc/sqlite