Import SQL Workbench/J build 117 as databases/sql-workbench.

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL
query tool. It is written in Java and should run on any
operating system that provides a Java Runtime Environment.

Its main focus is on running SQL scripts (either interactively
or as a batch) and export/import features. Graphical query
building or more advanced DBA tasks are not the focus and are
not planned.

Features:

 * Edit, insert and delete data directly in the query result.
 * Powerful export command to write text files (aka "CSV"),
   XML, HTML or SQL (including BLOB data). All user tables
   can be exported into a directory with a single command.
   Export files can be compressed "on-the-fly".
 * Powerful text, XML and spreadsheet import. A set of files
   (including compressed files) can be imported from a directory
   with a single command. Foreign key constraints are detected
   to insert the data in the correct order.
 * Compare two database schemas for differences. The XML output
   can be transformed into the approriate SQL ALTER statements
   using XSLT.
 * Compare the data of two database and generate the necessary
   SQL statements to migrate one to the other.
 * Supports running SQL scripts in batch mode.
 * Supports running in console mode.
 * Search text in procedure, view and other sources using a SQL
   command or a GUI.
 * Search for data across all columns in all tables using a SQL
   command or a GUI.
 * Reformatting (Pretty-Print) of SQL Statements.
 * Select rows from related tables according to their foreign
   key definitions.
 * Tooltips for INSERT statements to show the corresponding
   value or column.
 * Copy data directly between to database servers using a SQL
   command or a GUI.
 * Macros (aka aliases) for frequently used SQL statements.
 * Variable substitution in SQL statements including smart
   prompting for values (can be combined with macros).
 * Auto completion for tables and columns in SQL statements.
 * Display database objects and their definitions.
 * Display table source.
 * Display view, procedure and trigger source code.
 * Display foreign key constraints between tables.
 * Full support for BLOB data in query results, SQL statements,
   export and import.
 * SQLWorkbench/J is free for almost everyone (published under
   a modified the Apache 2.0 license).

4 files changed, 171 insertions, 0 deletions

diff --git a/databases/sql-workbench/DESCR b/databases/sql-workbench/DESCR
new file mode 100644
index 00000000000..e94740b092a
--- /dev/null
+++ b/databases/sql-workbench/DESCR
@@ -0,0 +1,50 @@
+SQL Workbench/J is a free, DBMS-independent, cross-platform SQL
+query tool. It is written in Java and should run on any
+operating system that provides a Java Runtime Environment.
+
+Its main focus is on running SQL scripts (either interactively
+or as a batch) and export/import features. Graphical query
+building or more advanced DBA tasks are not the focus and are
+not planned.
+
+Features:
+
+ * Edit, insert and delete data directly in the query result.
+ * Powerful export command to write text files (aka "CSV"),
+   XML, HTML or SQL (including BLOB data). All user tables
+   can be exported into a directory with a single command.
+   Export files can be compressed "on-the-fly".
+ * Powerful text, XML and spreadsheet import. A set of files
+   (including compressed files) can be imported from a directory
+   with a single command. Foreign key constraints are detected
+   to insert the data in the correct order.
+ * Compare two database schemas for differences. The XML output
+   can be transformed into the approriate SQL ALTER statements
+   using XSLT.
+ * Compare the data of two database and generate the necessary
+   SQL statements to migrate one to the other.
+ * Supports running SQL scripts in batch mode.
+ * Supports running in console mode.
+ * Search text in procedure, view and other sources using a SQL
+   command or a GUI.
+ * Search for data across all columns in all tables using a SQL
+   command or a GUI.
+ * Reformatting (Pretty-Print) of SQL Statements.
+ * Select rows from related tables according to their foreign
+   key definitions.
+ * Tooltips for INSERT statements to show the corresponding
+   value or column.
+ * Copy data directly between to database servers using a SQL
+   command or a GUI.
+ * Macros (aka aliases) for frequently used SQL statements.
+ * Variable substitution in SQL statements including smart
+   prompting for values (can be combined with macros).
+ * Auto completion for tables and columns in SQL statements.
+ * Display database objects and their definitions.
+ * Display table source.
+ * Display view, procedure and trigger source code.
+ * Display foreign key constraints between tables.
+ * Full support for BLOB data in query results, SQL statements,
+   export and import.
+ * SQLWorkbench/J is free for almost everyone (published under
+   a modified the Apache 2.0 license).
diff --git a/databases/sql-workbench/Makefile b/databases/sql-workbench/Makefile
new file mode 100644
index 00000000000..1cacb15ade0
--- /dev/null
+++ b/databases/sql-workbench/Makefile
@@ -0,0 +1,31 @@
+# $NetBSD: Makefile,v 1.1.1.1 2015/07/20 20:19:16 asau Exp $
+
+PKGNAME=	sql-workbench-117
+DISTNAME=	Workbench-Build117
+CATEGORIES=	databases
+MASTER_SITES=	http://www.sql-workbench.net/
+EXTRACT_SUFX=	.zip
+
+MAINTAINER=	asau@inbox.ru
+HOMEPAGE=	http://www.sql-workbench.net/
+COMMENT=	JDBC-based cross-platform SQL query tool.
+
+EXTRACT_DIR=	$(WRKSRC)
+
+USE_JAVA=	run
+USE_JAVA2=	7
+
+INSTALLATION_DIRS=	bin share/$(PKGBASE)
+
+pre-extract:
+	mkdir -p $(WRKSRC)
+
+do-build:
+	printf "#!/bin/sh\n$(PKG_JAVA_HOME)/bin/java -Dvisualvm.display.name=SQLWorkbench -Xmx512m -jar $(PREFIX)/share/$(PKGBASE)/sqlworkbench.jar \$${1:+\"\$$@\"}\n" > $(WRKDIR)/sqlworkbench.sh
+
+do-install:
+	cd $(WRKSRC) && pax -rwpm . $(DESTDIR)$(PREFIX)/share/$(PKGBASE)
+	$(INSTALL_SCRIPT) $(WRKDIR)/sqlworkbench.sh $(DESTDIR)$(PREFIX)/bin/sqlworkbench
+
+.include "../../mk/java-vm.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/sql-workbench/PLIST b/databases/sql-workbench/PLIST
new file mode 100644
index 00000000000..fc52aa779b9
--- /dev/null
+++ b/databases/sql-workbench/PLIST
@@ -0,0 +1,85 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2015/07/20 20:19:16 asau Exp $
+bin/sqlworkbench
+share/sql-workbench/LICENSE
+share/sql-workbench/SQLWorkbench-Manual.pdf
+share/sql-workbench/SQLWorkbench.desktop
+share/sql-workbench/SQLWorkbench.exe
+share/sql-workbench/SQLWorkbench.vbs
+share/sql-workbench/SQLWorkbench64.exe
+share/sql-workbench/history.html
+share/sql-workbench/log4j.xml
+share/sql-workbench/manual/annotations.html
+share/sql-workbench/manual/command-copy.html
+share/sql-workbench/manual/command-export.html
+share/sql-workbench/manual/command-import.html
+share/sql-workbench/manual/compare-commands.html
+share/sql-workbench/manual/console-mode.html
+share/sql-workbench/manual/data-pumper.html
+share/sql-workbench/manual/dbexplorer.html
+share/sql-workbench/manual/dbms-specific.html
+share/sql-workbench/manual/editor-bookmarks.html
+share/sql-workbench/manual/editor.html
+share/sql-workbench/manual/history.html
+share/sql-workbench/manual/html-publish.css
+share/sql-workbench/manual/images/CopyProfile16.gif
+share/sql-workbench/manual/images/Delete16.gif
+share/sql-workbench/manual/images/ExecuteSel16.gif
+share/sql-workbench/manual/images/NewFolder16.gif
+share/sql-workbench/manual/images/NewProfile16.gif
+share/sql-workbench/manual/images/Open16.gif
+share/sql-workbench/manual/images/Remove16.gif
+share/sql-workbench/manual/images/caution.png
+share/sql-workbench/manual/images/colfilter16.gif
+share/sql-workbench/manual/images/filter16.gif
+share/sql-workbench/manual/images/important.png
+share/sql-workbench/manual/images/note.png
+share/sql-workbench/manual/information.html
+share/sql-workbench/manual/install.html
+share/sql-workbench/manual/ix01.html
+share/sql-workbench/manual/jdbc-setup.html
+share/sql-workbench/manual/license.html
+share/sql-workbench/manual/macros.html
+share/sql-workbench/manual/options.html
+share/sql-workbench/manual/profiles.html
+share/sql-workbench/manual/settings.html
+share/sql-workbench/manual/shortcuts.html
+share/sql-workbench/manual/troubleshooting.html
+share/sql-workbench/manual/understand-alternate-delim.html
+share/sql-workbench/manual/using-fk.html
+share/sql-workbench/manual/using-scripting.html
+share/sql-workbench/manual/using-variables.html
+share/sql-workbench/manual/using.html
+share/sql-workbench/manual/wb-commands.html
+share/sql-workbench/manual/workbench-manual-single.html
+share/sql-workbench/manual/workbench-manual.html
+share/sql-workbench/sqlwbconsole.cmd
+share/sql-workbench/sqlwbconsole.exe
+share/sql-workbench/sqlwbconsole.sh
+share/sql-workbench/sqlwbconsole64.exe
+share/sql-workbench/sqlworkbench.cmd
+share/sql-workbench/sqlworkbench.jar
+share/sql-workbench/sqlworkbench.sh
+share/sql-workbench/workbench32.png
+share/sql-workbench/xslt/jdbctypes2oracle.xslt
+share/sql-workbench/xslt/liquibase_common.xslt
+share/sql-workbench/xslt/wbdiff2derby.xslt
+share/sql-workbench/xslt/wbdiff2html.xslt
+share/sql-workbench/xslt/wbdiff2liquibase.xslt
+share/sql-workbench/xslt/wbdiff2mssql.xslt
+share/sql-workbench/xslt/wbdiff2oracle.xslt
+share/sql-workbench/xslt/wbdiff2pg.xslt
+share/sql-workbench/xslt/wbdiff2simple_html.xslt
+share/sql-workbench/xslt/wbexport2dbunit.xslt
+share/sql-workbench/xslt/wbexport2dbunitflat.xslt
+share/sql-workbench/xslt/wbexport2insert.xslt
+share/sql-workbench/xslt/wbexport2lbinsert.xslt
+share/sql-workbench/xslt/wbexport2text.xslt
+share/sql-workbench/xslt/wbreport2benerator.xslt
+share/sql-workbench/xslt/wbreport2ctl.xslt
+share/sql-workbench/xslt/wbreport2html.xslt
+share/sql-workbench/xslt/wbreport2liquibase.xslt
+share/sql-workbench/xslt/wbreport2liquibase_multi.xslt
+share/sql-workbench/xslt/wbreport2oracle.xslt
+share/sql-workbench/xslt/wbreport2pg.xslt
+share/sql-workbench/xslt/wbreport2proc.xslt
+share/sql-workbench/xslt/wbreport2wiki.xslt
diff --git a/databases/sql-workbench/distinfo b/databases/sql-workbench/distinfo
new file mode 100644
index 00000000000..8e2114079d5
--- /dev/null
+++ b/databases/sql-workbench/distinfo
@@ -0,0 +1,5 @@
+$NetBSD: distinfo,v 1.1.1.1 2015/07/20 20:19:16 asau Exp $
+
+SHA1 (Workbench-Build117.zip) = c948a6ab4eb57637a05c28dd5228c5a939152261
+RMD160 (Workbench-Build117.zip) = 42cd165d00f99d931e38fb40f60c365ba73f83fc
+Size (Workbench-Build117.zip) = 5483109 bytes