Hi,
A (long?) while ago I said, "let me play with sqlite3", since it was
introduced into the ports. First thing I noticed was there was no man
page for it. Looking closer it seems there is a man page but it isn't
getting installed. This simple man page was helpful in getting me
started with sqlite3. Not sure if this is on purpose or just an
oversight.
Below patch installs sqlite3.1 man page included in tar-ball.
comments/OK?
--patrick
Index: Makefile
===================================================================
RCS file: /cvs/obsd/ports/databases/sqlite3/Makefile,v
retrieving revision 1.49
diff -u -p Makefile
--- Makefile 2 Apr 2010 20:07:11 -0000 1.49
+++ Makefile 20 Apr 2010 02:49:04 -0000
@@ -3,7 +3,7 @@
COMMENT-main= embedded SQL implementation
COMMENT-tcl= TCL bindings for Sqlite3
COMMENT-lemon= LEMON LALR(1) parser generator
-V= 3.6.23
+V= 3.6.23p0
DISTNAME= sqlite-${V}
PKGNAME-main= sqlite3-${V}
PKGNAME-tcl= sqlite3-tcl-${V}
Index: patches/patch-Makefile_in
===================================================================
RCS file: /cvs/obsd/ports/databases/sqlite3/patches/patch-Makefile_in,v
retrieving revision 1.15
diff -u -p patches/patch-Makefile_in
--- patches/patch-Makefile_in 2 Apr 2010 20:07:11 -0000 1.15
+++ patches/patch-Makefile_in 20 Apr 2010 02:49:04 -0000
@@ -1,7 +1,15 @@
$OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47 sthen Exp $
---- Makefile.in.orig Mon Mar 8 15:08:54 2010
-+++ Makefile.in Fri Mar 26 19:44:15 2010
-@@ -176,11 +176,11 @@ OBJS0 = alter.lo analyze.lo attach.lo auth.lo backup.l
+--- Makefile.in.orig Mon Mar 8 07:08:54 2010
++++ Makefile.in Mon Apr 19 19:25:55 2010
+@@ -146,6 +146,7 @@ libdir = @libdir@
+ pkgconfigdir = $(libdir)/pkgconfig
+ bindir = @bindir@
+ includedir = @includedir@
++mandir = @mandir@
+ INSTALL = @INSTALL@
+ LIBTOOL = ./libtool
+ ALLOWRELEASE = @ALLOWRELEASE@
+@@ -176,11 +177,11 @@ OBJS0 = alter.lo analyze.lo attach.lo auth.lo backup.l
table.lo tokenize.lo trigger.lo update.lo \
util.lo vacuum.lo \
vdbe.lo vdbeapi.lo vdbeaux.lo vdbeblob.lo vdbemem.lo vdbetrace.lo \
@@ -15,7 +23,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47
# Determine the real value of LIBOBJ based on the 'configure' script
#
-@@ -277,7 +277,8 @@ SRC = \
+@@ -277,7 +278,8 @@ SRC = \
$(TOP)/src/vdbeInt.h \
$(TOP)/src/vtab.c \
$(TOP)/src/walker.c \
@@ -25,7 +33,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47
# Generated source code files
#
-@@ -448,7 +449,7 @@ HDR += \
+@@ -448,7 +450,7 @@ HDR += \
# hidden when the library is built via the amalgamation).
#
TESTFIXTURE_SRC0 = $(TESTSRC2) libsqlite3.la
@@ -34,7 +42,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47
TESTFIXTURE_SRC = $(TESTSRC) $(TOP)/src/tclsqlite.c
$(TESTFIXTURE_SRC$(USE_AMALGAMATION))
-@@ -469,7 +470,7 @@ libsqlite3.la: $(LIBOBJ)
+@@ -469,7 +471,7 @@ libsqlite3.la: $(LIBOBJ)
libtclsqlite3.la: tclsqlite.lo libsqlite3.la
$(LTLINK) -o $@ tclsqlite.lo \
@@ -43,7 +51,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47
-rpath "$(TCLLIBDIR)" \
-version-info "8:6:8" \
-avoid-version
-@@ -509,6 +510,9 @@ lemon$(BEXE): $(TOP)/tool/lemon.c $(TOP)/src/lempar.c
+@@ -509,6 +511,9 @@ lemon$(BEXE): $(TOP)/tool/lemon.c $(TOP)/src/lempar.c
sqlite3.lo: sqlite3.c
$(LTCOMPILE) $(TEMP_STORE) -c sqlite3.c
@@ -53,7 +61,7 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47
# Rules to build individual files
#
alter.lo: $(TOP)/src/alter.c $(HDR)
-@@ -690,8 +694,9 @@ select.lo: $(TOP)/src/select.c $(HDR)
+@@ -690,8 +695,9 @@ select.lo: $(TOP)/src/select.c $(HDR)
status.lo: $(TOP)/src/status.c $(HDR)
$(LTCOMPILE) $(TEMP_STORE) -c $(TOP)/src/status.c
@@ -65,7 +73,16 @@ $OpenBSD: patch-Makefile_in,v 1.14 2009/08/03 09:55:47
table.lo: $(TOP)/src/table.c $(HDR)
$(LTCOMPILE) $(TEMP_STORE) -c $(TOP)/src/table.c
-@@ -820,6 +825,8 @@ clean:
+@@ -796,6 +802,8 @@ install: sqlite3$(BEXE) lib_install sqlite3.h sqlite3.
+ $(INSTALL) -m 0644 $(TOP)/src/sqlite3ext.h $(DESTDIR)$(includedir)
+ $(INSTALL) -d $(DESTDIR)$(pkgconfigdir)
+ $(INSTALL) -m 0644 sqlite3.pc $(DESTDIR)$(pkgconfigdir)
++ $(INSTALL) -d $(DESTDIR)$(mandir)/man1
++ $(INSTALL) -m 0644 sqlite3.1 $(DESTDIR)$(mandir)/man1
+
+ pkgIndex.tcl:
+ echo 'package ifneeded sqlite3 $(RELEASE) [list load
$(TCLLIBDIR)/libtclsqlite3.so sqlite3]' > $@
+@@ -820,6 +828,8 @@ clean:
distclean: clean
rm -f config.log config.status libtool Makefile sqlite3.pc
Index: pkg/PLIST-main
===================================================================
RCS file: /cvs/obsd/ports/databases/sqlite3/pkg/PLIST-main,v
retrieving revision 1.3
diff -u -p pkg/PLIST-main
--- pkg/PLIST-main 23 Jul 2008 17:31:18 -0000 1.3
+++ pkg/PLIST-main 20 Apr 2010 02:49:04 -0000
@@ -9,3 +9,4 @@ lib/libsqlite3.a
lib/libsqlite3.la
lib/pkgconfig/
lib/pkgconfig/sqlite3.pc
+...@man man/man1/sqlite3.1
