diff --git a/databases/ruby-sqlite3/Makefile b/databases/ruby-sqlite3/Makefile
index c3a4abc1b3d6..28e3b8a50a05 100644
--- a/databases/ruby-sqlite3/Makefile
+++ b/databases/ruby-sqlite3/Makefile
@@ -1,40 +1,38 @@
 # New ports collection makefile for:	sqlite3-ruby
 # Date created:		26 June 2003
 # Whom:			Akinori MUSHA aka knu <knu@idaemons.org>
 #
 # $FreeBSD$
 #
 
 PORTNAME=	sqlite3
 PORTVERSION=	0.9.0
 CATEGORIES=	databases ruby
 MASTER_SITES=	http://rubyforge.org/frs/download.php/2488/
 PKGNAMEPREFIX=	${RUBY_PKGNAMEPREFIX}
 DISTNAME=	${PORTNAME}-ruby-${PORTVERSION}
 DIST_SUBDIR=	ruby
 
 MAINTAINER=	knu@FreeBSD.org
 COMMENT=	Ruby interface to the SQLite DB engine version 3
 
 BUILD_DEPENDS=	swig:${PORTSDIR}/devel/swig13
 LIB_DEPENDS=	sqlite3.8:${PORTSDIR}/databases/sqlite3
 
-BROKEN=		Incomplete pkg-plist
-
 USE_BZIP2=	yes
 USE_RUBY=	yes
 USE_RUBY_SETUP=	yes
 
 CONFIGURE_ARGS=	-- --with-sqlite3-dir="${LOCALBASE}"
 
 DOCS=	ChangeLog LICENSE README api/* doc/*
 
 post-install:
 .if !defined(NOPORTDOCS)
 	${MKDIR} ${RUBY_MODDOCDIR}
 .for f in ${DOCS}
 	${CP} -R ${WRKSRC}/${f} ${RUBY_MODDOCDIR}/
 .endfor
 .endif
 
 .include <bsd.port.mk>
diff --git a/databases/ruby-sqlite3/pkg-plist b/databases/ruby-sqlite3/pkg-plist
index 14a80f8c858e..5a485ee42d63 100644
--- a/databases/ruby-sqlite3/pkg-plist
+++ b/databases/ruby-sqlite3/pkg-plist
@@ -1,111 +1,112 @@
+%%RUBY_SITEARCHLIBDIR%%/sqlite3_api.so
 %%RUBY_SITELIBDIR%%/sqlite3.rb
 %%RUBY_SITELIBDIR%%/sqlite3/constants.rb
 %%RUBY_SITELIBDIR%%/sqlite3/database.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/dl/api.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/dl/driver.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/native/driver.rb
 %%RUBY_SITELIBDIR%%/sqlite3/errors.rb
 %%RUBY_SITELIBDIR%%/sqlite3/pragmas.rb
 %%RUBY_SITELIBDIR%%/sqlite3/resultset.rb
 %%RUBY_SITELIBDIR%%/sqlite3/statement.rb
 %%RUBY_SITELIBDIR%%/sqlite3/translator.rb
 %%RUBY_SITELIBDIR%%/sqlite3/value.rb
 %%RUBY_SITELIBDIR%%/sqlite3/version.rb
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver/native
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver/dl
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/ChangeLog
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/LICENSE
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/README
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/blank.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/DL.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/DL/PtrData.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/Kernel.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/AbortException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/AuthorizationException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Blob.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/BusyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/CantOpenException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/ColumnType.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/ErrorCode.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/TextRep.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ConstraintException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/CorruptException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Database.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Database/FunctionProxy.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL/API.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/EmptyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Error.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Exception.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/FullException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/IOException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/InternalException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/InterruptException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/LockedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MemoryException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MismatchException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MisuseException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/NotFoundException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/PermissionException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Pragmas.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ProtocolException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ReadOnlyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet/FieldsContainer.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet/TypesContainer.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/SQLException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/SchemaChangedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Statement.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/TooBigException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Translator.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/UnsupportedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Value.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Version.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/String.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/created.rid
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.rb
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.yml
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/constants_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/database_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl/api_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl/driver_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/native/driver_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/errors_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/pragmas_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/resultset_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/statement_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/translator_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/value_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/version_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_class_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_file_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_method_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/rdoc-style.css
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/native
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/faq
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Database
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Constants
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/DL
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%
diff --git a/databases/rubygem-sqlite3-ruby/Makefile b/databases/rubygem-sqlite3-ruby/Makefile
index c3a4abc1b3d6..28e3b8a50a05 100644
--- a/databases/rubygem-sqlite3-ruby/Makefile
+++ b/databases/rubygem-sqlite3-ruby/Makefile
@@ -1,40 +1,38 @@
 # New ports collection makefile for:	sqlite3-ruby
 # Date created:		26 June 2003
 # Whom:			Akinori MUSHA aka knu <knu@idaemons.org>
 #
 # $FreeBSD$
 #
 
 PORTNAME=	sqlite3
 PORTVERSION=	0.9.0
 CATEGORIES=	databases ruby
 MASTER_SITES=	http://rubyforge.org/frs/download.php/2488/
 PKGNAMEPREFIX=	${RUBY_PKGNAMEPREFIX}
 DISTNAME=	${PORTNAME}-ruby-${PORTVERSION}
 DIST_SUBDIR=	ruby
 
 MAINTAINER=	knu@FreeBSD.org
 COMMENT=	Ruby interface to the SQLite DB engine version 3
 
 BUILD_DEPENDS=	swig:${PORTSDIR}/devel/swig13
 LIB_DEPENDS=	sqlite3.8:${PORTSDIR}/databases/sqlite3
 
-BROKEN=		Incomplete pkg-plist
-
 USE_BZIP2=	yes
 USE_RUBY=	yes
 USE_RUBY_SETUP=	yes
 
 CONFIGURE_ARGS=	-- --with-sqlite3-dir="${LOCALBASE}"
 
 DOCS=	ChangeLog LICENSE README api/* doc/*
 
 post-install:
 .if !defined(NOPORTDOCS)
 	${MKDIR} ${RUBY_MODDOCDIR}
 .for f in ${DOCS}
 	${CP} -R ${WRKSRC}/${f} ${RUBY_MODDOCDIR}/
 .endfor
 .endif
 
 .include <bsd.port.mk>
diff --git a/databases/rubygem-sqlite3-ruby/pkg-plist b/databases/rubygem-sqlite3-ruby/pkg-plist
index 14a80f8c858e..5a485ee42d63 100644
--- a/databases/rubygem-sqlite3-ruby/pkg-plist
+++ b/databases/rubygem-sqlite3-ruby/pkg-plist
@@ -1,111 +1,112 @@
+%%RUBY_SITEARCHLIBDIR%%/sqlite3_api.so
 %%RUBY_SITELIBDIR%%/sqlite3.rb
 %%RUBY_SITELIBDIR%%/sqlite3/constants.rb
 %%RUBY_SITELIBDIR%%/sqlite3/database.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/dl/api.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/dl/driver.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/native/driver.rb
 %%RUBY_SITELIBDIR%%/sqlite3/errors.rb
 %%RUBY_SITELIBDIR%%/sqlite3/pragmas.rb
 %%RUBY_SITELIBDIR%%/sqlite3/resultset.rb
 %%RUBY_SITELIBDIR%%/sqlite3/statement.rb
 %%RUBY_SITELIBDIR%%/sqlite3/translator.rb
 %%RUBY_SITELIBDIR%%/sqlite3/value.rb
 %%RUBY_SITELIBDIR%%/sqlite3/version.rb
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver/native
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver/dl
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/ChangeLog
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/LICENSE
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/README
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/blank.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/DL.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/DL/PtrData.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/Kernel.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/AbortException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/AuthorizationException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Blob.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/BusyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/CantOpenException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/ColumnType.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/ErrorCode.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/TextRep.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ConstraintException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/CorruptException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Database.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Database/FunctionProxy.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL/API.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/EmptyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Error.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Exception.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/FullException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/IOException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/InternalException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/InterruptException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/LockedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MemoryException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MismatchException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MisuseException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/NotFoundException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/PermissionException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Pragmas.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ProtocolException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ReadOnlyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet/FieldsContainer.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet/TypesContainer.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/SQLException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/SchemaChangedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Statement.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/TooBigException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Translator.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/UnsupportedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Value.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Version.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/String.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/created.rid
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.rb
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.yml
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/constants_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/database_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl/api_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl/driver_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/native/driver_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/errors_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/pragmas_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/resultset_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/statement_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/translator_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/value_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/version_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_class_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_file_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_method_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/rdoc-style.css
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/native
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/faq
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Database
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Constants
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/DL
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%
diff --git a/databases/rubygem-sqlite3/Makefile b/databases/rubygem-sqlite3/Makefile
index c3a4abc1b3d6..28e3b8a50a05 100644
--- a/databases/rubygem-sqlite3/Makefile
+++ b/databases/rubygem-sqlite3/Makefile
@@ -1,40 +1,38 @@
 # New ports collection makefile for:	sqlite3-ruby
 # Date created:		26 June 2003
 # Whom:			Akinori MUSHA aka knu <knu@idaemons.org>
 #
 # $FreeBSD$
 #
 
 PORTNAME=	sqlite3
 PORTVERSION=	0.9.0
 CATEGORIES=	databases ruby
 MASTER_SITES=	http://rubyforge.org/frs/download.php/2488/
 PKGNAMEPREFIX=	${RUBY_PKGNAMEPREFIX}
 DISTNAME=	${PORTNAME}-ruby-${PORTVERSION}
 DIST_SUBDIR=	ruby
 
 MAINTAINER=	knu@FreeBSD.org
 COMMENT=	Ruby interface to the SQLite DB engine version 3
 
 BUILD_DEPENDS=	swig:${PORTSDIR}/devel/swig13
 LIB_DEPENDS=	sqlite3.8:${PORTSDIR}/databases/sqlite3
 
-BROKEN=		Incomplete pkg-plist
-
 USE_BZIP2=	yes
 USE_RUBY=	yes
 USE_RUBY_SETUP=	yes
 
 CONFIGURE_ARGS=	-- --with-sqlite3-dir="${LOCALBASE}"
 
 DOCS=	ChangeLog LICENSE README api/* doc/*
 
 post-install:
 .if !defined(NOPORTDOCS)
 	${MKDIR} ${RUBY_MODDOCDIR}
 .for f in ${DOCS}
 	${CP} -R ${WRKSRC}/${f} ${RUBY_MODDOCDIR}/
 .endfor
 .endif
 
 .include <bsd.port.mk>
diff --git a/databases/rubygem-sqlite3/pkg-plist b/databases/rubygem-sqlite3/pkg-plist
index 14a80f8c858e..5a485ee42d63 100644
--- a/databases/rubygem-sqlite3/pkg-plist
+++ b/databases/rubygem-sqlite3/pkg-plist
@@ -1,111 +1,112 @@
+%%RUBY_SITEARCHLIBDIR%%/sqlite3_api.so
 %%RUBY_SITELIBDIR%%/sqlite3.rb
 %%RUBY_SITELIBDIR%%/sqlite3/constants.rb
 %%RUBY_SITELIBDIR%%/sqlite3/database.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/dl/api.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/dl/driver.rb
 %%RUBY_SITELIBDIR%%/sqlite3/driver/native/driver.rb
 %%RUBY_SITELIBDIR%%/sqlite3/errors.rb
 %%RUBY_SITELIBDIR%%/sqlite3/pragmas.rb
 %%RUBY_SITELIBDIR%%/sqlite3/resultset.rb
 %%RUBY_SITELIBDIR%%/sqlite3/statement.rb
 %%RUBY_SITELIBDIR%%/sqlite3/translator.rb
 %%RUBY_SITELIBDIR%%/sqlite3/value.rb
 %%RUBY_SITELIBDIR%%/sqlite3/version.rb
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver/native
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver/dl
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3/driver
 @dirrm %%RUBY_SITELIBDIR%%/sqlite3
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/ChangeLog
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/LICENSE
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/README
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/blank.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/DL.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/DL/PtrData.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/Kernel.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/AbortException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/AuthorizationException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Blob.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/BusyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/CantOpenException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/ColumnType.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/ErrorCode.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Constants/TextRep.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ConstraintException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/CorruptException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Database.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Database/FunctionProxy.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL/API.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native/Driver.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/EmptyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Error.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Exception.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/FullException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/IOException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/InternalException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/InterruptException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/LockedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MemoryException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MismatchException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/MisuseException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/NotFoundException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/PermissionException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Pragmas.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ProtocolException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ReadOnlyException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet/FieldsContainer.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet/TypesContainer.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/SQLException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/SchemaChangedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Statement.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/TooBigException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Translator.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/UnsupportedException.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Value.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/SQLite3/Version.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/classes/String.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/created.rid
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.rb
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/faq/faq.yml
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/constants_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/database_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl/api_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl/driver_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/native/driver_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/errors_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/pragmas_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/resultset_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/statement_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/translator_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/value_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3/version_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/files/lib/sqlite3_rb.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_class_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_file_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/fr_method_index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/index.html
 %%PORTDOCS%%%%RUBY_MODDOCDIR%%/rdoc-style.css
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/native
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver/dl
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3/driver
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib/sqlite3
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files/lib
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/files
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/faq
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/ResultSet
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/Native
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver/DL
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Driver
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Database
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3/Constants
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/SQLite3
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes/DL
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%/classes
 %%PORTDOCS%%@dirrm %%RUBY_MODDOCDIR%%