A number of things:

	. changed maintainership to ports@;
	. build with TCL support (``package require sqlite'');
	. run the vendor's tests after build (sorry, Maxim) -- zero errors;
	. generate from the TCL sources and install the HTML documentation;
	  (unless NOPORTDOCS is set);
	. build and install two usefull tools, which come with the software:
		gdbmdump and gdbmstat;
	. build and install the shared version of -lsqlite -- usefull and
	  needed for dynamic loading into TCL interpreter;
	. lastly: the new functionality (TCL, tools, docs) called for the
	  PORTREVISION bump.

Approved by: after the previous maintainer suggested the first point above,
	the rest was easy :-)

5 files changed, 98 insertions, 0 deletions

diff --git a/databases/sqlite2/files/Makefile.bsd b/databases/sqlite2/files/Makefile.bsd
new file mode 100644
index 0000000..a7b9955
--- /dev/null
+++ b/databases/sqlite2/files/Makefile.bsd
@@ -0,0 +1,36 @@
+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	 =	build.c dbbe.c dbbegdbm.c dbbemem.c delete.c expr.c insert.c \
+		main.c parse.y printf.c random.c select.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}
+
+INCDIR	 =	${PREFIX}/include
+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
new file mode 100644
index 0000000..77d95a5
--- /dev/null
+++ b/databases/sqlite2/files/Makefile.docs
@@ -0,0 +1,25 @@
+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
new file mode 100644
index 0000000..ce5498d
--- /dev/null
+++ b/databases/sqlite2/files/patch-docs
@@ -0,0 +1,30 @@
+--- 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
new file mode 100644
index 0000000..e2a38cc
--- /dev/null
+++ b/databases/sqlite2/files/patch-test
@@ -0,0 +1,6 @@
+--- 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
diff --git a/databases/sqlite2/files/pkgIndex.tcl b/databases/sqlite2/files/pkgIndex.tcl
new file mode 100644
index 0000000..df0b6bb0
--- /dev/null
+++ b/databases/sqlite2/files/pkgIndex.tcl
@@ -0,0 +1 @@
+package ifneeded sqlite 1.0 [list load $dir/../libsqlite.so]