5 files changed, 163 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 1c906c881b9c..1e495a5181ce 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -184,6 +184,7 @@
     SUBDIR += p5-ResourcePool-Resource-DBI
     SUBDIR += p5-SQL-Abstract
     SUBDIR += p5-SQL-Statement
+    SUBDIR += p5-SQL-Translator
     SUBDIR += p5-Search-InvertedIndex
     SUBDIR += p5-Search-Namazu
     SUBDIR += p5-T2
diff --git a/databases/p5-SQL-Translator/Makefile b/databases/p5-SQL-Translator/Makefile
new file mode 100644
index 000000000000..09f03f45573a
--- /dev/null
+++ b/databases/p5-SQL-Translator/Makefile
@@ -0,0 +1,91 @@
+# New ports collection makefile for:	SQL-Translator
+# Date created:				12 Apr 2004
+# Whom:					Lars Thegler <lars@thegler.dk>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	SQL-Translator
+PORTVERSION=	0.05
+CATEGORIES=	databases perl5
+MASTER_SITES=	${MASTER_SITE_PERL_CPAN}
+MASTER_SITE_SUBDIR=	SQL
+PKGNAMEPREFIX=	p5-
+
+MAINTAINER=	lars@thegler.dk
+COMMENT=	Manipulate structured data definitions (SQL and more)
+
+BUILD_DEPENDS=	${SITE_PERL}/Class/Base.pm:${PORTSDIR}/devel/p5-Class-Base \
+		${SITE_PERL}/${PERL_ARCH}/GD.pm:${PORTSDIR}/graphics/p5-GD \
+		${SITE_PERL}/GraphViz.pm:${PORTSDIR}/graphics/p5-GraphViz \
+		${SITE_PERL}/IO/Scalar.pm:${PORTSDIR}/devel/p5-IO-stringy \
+		${SITE_PERL}/Parse/RecDescent.pm:${PORTSDIR}/devel/p5-Parse-RecDescent \
+		${SITE_PERL}/Pod/Usage.pm:${PORTSDIR}/textproc/p5-PodParser \
+		${SITE_PERL}/Spreadsheet/ParseExcel.pm:${PORTSDIR}/textproc/p5-Spreadsheet-ParseExcel \
+		${SITE_PERL}/${PERL_ARCH}/Template.pm:${PORTSDIR}/www/p5-Template-Toolkit \
+		${SITE_PERL}/Text/RecordParser.pm:${PORTSDIR}/textproc/p5-Text-RecordParser \
+		${SITE_PERL}/XML/Writer.pm:${PORTSDIR}/textproc/p5-XML-Writer \
+		${SITE_PERL}/XML/XPath.pm:${PORTSDIR}/textproc/p5-XML-XPath \
+		${SITE_PERL}/YAML.pm:${PORTSDIR}/textproc/p5-YAML \
+		${SITE_PERL}/${PERL_ARCH}/Storable.pm:${PORTSDIR}/devel/p5-Storable
+RUN_DEPENDS=	${BUILD_DEPENDS}
+
+PERL_CONFIGURE=	yes
+
+MAN1=		sqlt-diagram.1 \
+		sqlt-diff.1 \
+		sqlt-dumper.1 \
+		sqlt-graph.1 \
+		sqlt.1
+MAN3=		SQL::Translator.3 \
+		SQL::Translator::Parser.3 \
+		SQL::Translator::Parser::DBI.3 \
+		SQL::Translator::Parser::DBI::MySQL.3 \
+		SQL::Translator::Parser::DBI::PostgreSQL.3 \
+		SQL::Translator::Parser::DBI::SQLite.3 \
+		SQL::Translator::Parser::DBI::Sybase.3 \
+		SQL::Translator::Parser::Excel.3 \
+		SQL::Translator::Parser::MySQL.3 \
+		SQL::Translator::Parser::Oracle.3 \
+		SQL::Translator::Parser::PostgreSQL.3 \
+		SQL::Translator::Parser::SQLite.3 \
+		SQL::Translator::Parser::Storable.3 \
+		SQL::Translator::Parser::Sybase.3 \
+		SQL::Translator::Parser::XML.3 \
+		SQL::Translator::Parser::XML::SQLFairy.3 \
+		SQL::Translator::Parser::YAML.3 \
+		SQL::Translator::Parser::xSV.3 \
+		SQL::Translator::Producer.3 \
+		SQL::Translator::Producer::ClassDBI.3 \
+		SQL::Translator::Producer::Diagram.3 \
+		SQL::Translator::Producer::GraphViz.3 \
+		SQL::Translator::Producer::HTML.3 \
+		SQL::Translator::Producer::MySQL.3 \
+		SQL::Translator::Producer::Oracle.3 \
+		SQL::Translator::Producer::POD.3 \
+		SQL::Translator::Producer::PostgreSQL.3 \
+		SQL::Translator::Producer::SQLite.3 \
+		SQL::Translator::Producer::Storable.3 \
+		SQL::Translator::Producer::Sybase.3 \
+		SQL::Translator::Producer::TTSchema.3 \
+		SQL::Translator::Producer::XML.3 \
+		SQL::Translator::Producer::XML::SQLFairy.3 \
+		SQL::Translator::Producer::YAML.3 \
+		SQL::Translator::Schema.3 \
+		SQL::Translator::Schema::Constants.3 \
+		SQL::Translator::Schema::Constraint.3 \
+		SQL::Translator::Schema::Field.3 \
+		SQL::Translator::Schema::Index.3 \
+		SQL::Translator::Schema::Procedure.3 \
+		SQL::Translator::Schema::Table.3 \
+		SQL::Translator::Schema::Trigger.3 \
+		SQL::Translator::Schema::View.3 \
+		SQL::Translator::Utils.3
+
+.include <bsd.port.pre.mk>
+
+.if ${PERL_LEVEL} < 500600
+IGNORE=		"Perl 5.6 or newer required. Install lang/perl5 or lang/perl5.8 and try again."
+.endif
+
+.include <bsd.port.post.mk>
diff --git a/databases/p5-SQL-Translator/distinfo b/databases/p5-SQL-Translator/distinfo
new file mode 100644
index 000000000000..3dd2af1203b1
--- /dev/null
+++ b/databases/p5-SQL-Translator/distinfo
@@ -0,0 +1,2 @@
+MD5 (SQL-Translator-0.05.tar.gz) = d1e5f7283a4822cda991114cb5a636ef
+SIZE (SQL-Translator-0.05.tar.gz) = 156662
diff --git a/databases/p5-SQL-Translator/pkg-descr b/databases/p5-SQL-Translator/pkg-descr
new file mode 100644
index 000000000000..87ac64a6b352
--- /dev/null
+++ b/databases/p5-SQL-Translator/pkg-descr
@@ -0,0 +1,9 @@
+SQL::Translator is a group of Perl modules that converts vendor-specific
+SQL table definitions into other formats, such as other vendor-specific
+SQL, ER diagrams, documentation (POD and HTML), XML, and Class::DBI
+classes.SQL::Translator is a group of Perl modules that converts
+vendor-specific SQL table definitions into other formats, such as
+other vendor-specific SQL, ER diagrams, documentation (POD and
+HTML), XML, and Class::DBI classes.
+
+WWW: http://search.cpan.org/dist/SQL-Translator/
diff --git a/databases/p5-SQL-Translator/pkg-plist b/databases/p5-SQL-Translator/pkg-plist
new file mode 100644
index 000000000000..f703eae306d5
--- /dev/null
+++ b/databases/p5-SQL-Translator/pkg-plist
@@ -0,0 +1,60 @@
+bin/sqlt
+bin/sqlt-diagram
+bin/sqlt-diff
+bin/sqlt-dumper
+bin/sqlt-graph
+%%SITE_PERL%%/SQL/Translator.pm
+%%SITE_PERL%%/SQL/Translator/Parser.pm
+%%SITE_PERL%%/SQL/Translator/Parser/DBI.pm
+%%SITE_PERL%%/SQL/Translator/Parser/DBI/MySQL.pm
+%%SITE_PERL%%/SQL/Translator/Parser/DBI/PostgreSQL.pm
+%%SITE_PERL%%/SQL/Translator/Parser/DBI/SQLite.pm
+%%SITE_PERL%%/SQL/Translator/Parser/DBI/Sybase.pm
+%%SITE_PERL%%/SQL/Translator/Parser/Excel.pm
+%%SITE_PERL%%/SQL/Translator/Parser/MySQL.pm
+%%SITE_PERL%%/SQL/Translator/Parser/Oracle.pm
+%%SITE_PERL%%/SQL/Translator/Parser/PostgreSQL.pm
+%%SITE_PERL%%/SQL/Translator/Parser/SQLite.pm
+%%SITE_PERL%%/SQL/Translator/Parser/Storable.pm
+%%SITE_PERL%%/SQL/Translator/Parser/Sybase.pm
+%%SITE_PERL%%/SQL/Translator/Parser/XML.pm
+%%SITE_PERL%%/SQL/Translator/Parser/XML/SQLFairy.pm
+%%SITE_PERL%%/SQL/Translator/Parser/YAML.pm
+%%SITE_PERL%%/SQL/Translator/Parser/xSV.pm
+%%SITE_PERL%%/SQL/Translator/Producer.pm
+%%SITE_PERL%%/SQL/Translator/Producer/ClassDBI.pm
+%%SITE_PERL%%/SQL/Translator/Producer/Diagram.pm
+%%SITE_PERL%%/SQL/Translator/Producer/GraphViz.pm
+%%SITE_PERL%%/SQL/Translator/Producer/HTML.pm
+%%SITE_PERL%%/SQL/Translator/Producer/MySQL.pm
+%%SITE_PERL%%/SQL/Translator/Producer/Oracle.pm
+%%SITE_PERL%%/SQL/Translator/Producer/POD.pm
+%%SITE_PERL%%/SQL/Translator/Producer/PostgreSQL.pm
+%%SITE_PERL%%/SQL/Translator/Producer/SQLite.pm
+%%SITE_PERL%%/SQL/Translator/Producer/Storable.pm
+%%SITE_PERL%%/SQL/Translator/Producer/Sybase.pm
+%%SITE_PERL%%/SQL/Translator/Producer/TTSchema.pm
+%%SITE_PERL%%/SQL/Translator/Producer/XML.pm
+%%SITE_PERL%%/SQL/Translator/Producer/XML/SQLFairy.pm
+%%SITE_PERL%%/SQL/Translator/Producer/YAML.pm
+%%SITE_PERL%%/SQL/Translator/Schema.pm
+%%SITE_PERL%%/SQL/Translator/Schema/Constants.pm
+%%SITE_PERL%%/SQL/Translator/Schema/Constraint.pm
+%%SITE_PERL%%/SQL/Translator/Schema/Field.pm
+%%SITE_PERL%%/SQL/Translator/Schema/Index.pm
+%%SITE_PERL%%/SQL/Translator/Schema/Procedure.pm
+%%SITE_PERL%%/SQL/Translator/Schema/Table.pm
+%%SITE_PERL%%/SQL/Translator/Schema/Trigger.pm
+%%SITE_PERL%%/SQL/Translator/Schema/View.pm
+%%SITE_PERL%%/SQL/Translator/Utils.pm
+%%SITE_PERL%%/%%PERL_ARCH%%/auto/SQL/Translator/.packlist
+@dirrm %%SITE_PERL%%/%%PERL_ARCH%%/auto/SQL/Translator
+@unexec rmdir %D/%%SITE_PERL%%/%%PERL_ARCH%%/auto/SQL 2>/dev/null || true
+@dirrm %%SITE_PERL%%/SQL/Translator/Schema
+@dirrm %%SITE_PERL%%/SQL/Translator/Producer/XML
+@dirrm %%SITE_PERL%%/SQL/Translator/Producer
+@dirrm %%SITE_PERL%%/SQL/Translator/Parser/XML
+@dirrm %%SITE_PERL%%/SQL/Translator/Parser/DBI
+@dirrm %%SITE_PERL%%/SQL/Translator/Parser
+@dirrm %%SITE_PERL%%/SQL/Translator
+@unexec rmdir %D/%%SITE_PERL%%/SQL 2>/dev/null || true