SQuirreL SQL Client is a graphical Java program that will allow you to view the

structure of a JDBC compliant database, browse the data in tables, issue SQL
commands etc.

WWW: http://www.squirrelsql.org/index.php?page=screenshots

PR:		ports/106230
Submitted by:	Roy Boerner <roy.boerner@bsd-crew.de>

7 files changed, 265 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 4a6fbc620c3b..426f1f55e24f 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -468,6 +468,7 @@
     SUBDIR += sqlite3
     SUBDIR += sqlrelay
     SUBDIR += sqsh
+    SUBDIR += squirrel-sql
     SUBDIR += sybase-ocsd
     SUBDIR += sybase_ase
     SUBDIR += sybtcl
diff --git a/databases/squirrel-sql/Makefile b/databases/squirrel-sql/Makefile
new file mode 100644
index 000000000000..e7156ea69941
--- /dev/null
+++ b/databases/squirrel-sql/Makefile
@@ -0,0 +1,44 @@
+# New ports collection makefile for: squirrel-sql
+# Date created: 	2006/11/06
+# Whom:         	Roy Boerner
+#
+# $FreeBSD$
+#
+
+PORTNAME=	squirrel
+PORTVERSION=	2.3.1
+CATEGORIES=	databases java
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE_EXTENDED}
+MASTER_SITE_SUBDIR=	${PORTNAME}${PKGNAMESUFFIX}
+PKGNAMESUFFIX=	-sql
+DISTNAME=	squirrel-sql-2.3.1-standard
+
+MAINTAINER=	roy.boerner@bsd-crew.de
+COMMENT=	A universal SQL Client
+
+NO_BUILD=	yes
+USE_JAVA=	yes
+JAVA_VERSION=	1.4+
+WRKSRC=		${WRKDIR}/SQuirreL SQL Client
+DSTDIR=		${JAVASHAREDIR}/${PORTNAME}
+
+SUB_FILES=	squirrel-sql
+
+DESKTOP_ENTRIES="Squirrel-SQL" \
+		"${COMMENT}" \
+		"${DSTDIR}/icons/acorn.png" \
+		"squirrel-sql" \
+		"Application;" \
+		false
+
+post-extract:
+	${RM} -rf "${WRKSRC}"/Uninstaller
+	${RM} -rf "${WRKSRC}"/*.bat
+	${RM} -rf "${WRKSRC}"/*.sh
+
+do-install:
+	cd "${WRKSRC}" && ${FIND} . -type d -exec ${MKDIR} ${DSTDIR}/{} \;
+	cd "${WRKSRC}" && ${FIND} . -type f -not -path "\./bin/" -exec ${INSTALL_DATA} {} ${DSTDIR}/{} \;
+	${INSTALL_SCRIPT} ${WRKDIR}/squirrel-sql ${PREFIX}/bin
+
+.include <bsd.port.mk>
diff --git a/databases/squirrel-sql/distinfo b/databases/squirrel-sql/distinfo
new file mode 100644
index 000000000000..d846c5c88550
--- /dev/null
+++ b/databases/squirrel-sql/distinfo
@@ -0,0 +1,3 @@
+MD5 (squirrel-sql-2.3.1-standard.tar.gz) = 99dc749360ac81072bef6d7ec37648fd
+SHA256 (squirrel-sql-2.3.1-standard.tar.gz) = 81e03b79da7a0efd46ca11732e5e4dffc3a469731781a9a72d88b280efd10d5f
+SIZE (squirrel-sql-2.3.1-standard.tar.gz) = 653312
diff --git a/databases/squirrel-sql/files/squirrel-sql.in b/databases/squirrel-sql/files/squirrel-sql.in
new file mode 100644
index 000000000000..938540aa805b
--- /dev/null
+++ b/databases/squirrel-sql/files/squirrel-sql.in
@@ -0,0 +1,17 @@
+#! /bin/sh
+
+# Squirrel home.
+SQUIRREL_SQL_HOME=%%JAVASHAREDIR%%/squirrel-sql
+
+# First entry in classpath is the Squirrel application.
+TMP_CP=$SQUIRREL_SQL_HOME/squirrel-sql.jar
+
+# Then add all library jars to the classpath.
+for a in $SQUIRREL_SQL_HOME/lib/*; do
+	TMP_CP="$TMP_CP":"$a";
+done
+
+# Now add the system classpath to the classpath. 
+TMP_CP=$TMP_CP:$CLASSPATH
+
+java -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9
diff --git a/databases/squirrel-sql/files/squirrel-sql.sh b/databases/squirrel-sql/files/squirrel-sql.sh
new file mode 100644
index 000000000000..9fe2784b4f25
--- /dev/null
+++ b/databases/squirrel-sql/files/squirrel-sql.sh
@@ -0,0 +1,46 @@
+#! /bin/sh
+[ ${JAVA_HOME} ] && JAVA=${JAVA_HOME}/bin/java || JAVA=java
+
+# Are we running within Cygwin on some version of Windows?
+cygwin=false;
+case "`uname -s`" in
+	CYGWIN*) cygwin=true ;;
+esac
+
+# Squirrel home.
+SQUIRREL_SQL_HOME=`dirname "$0"`
+
+# SQuirreL home in Unix format.
+if $cygwin ; then
+	UNIX_STYLE_HOME=`cygpath "$SQUIRREL_SQL_HOME"`
+else
+	UNIX_STYLE_HOME=$SQUIRREL_SQL_HOME
+fi
+
+# First entry in classpath is the Squirrel application.
+TMP_CP=$UNIX_STYLE_HOME/squirrel-sql.jar
+
+# Then add all library jars to the classpath.
+IFS=""
+for a in $UNIX_STYLE_HOME/lib/*; do
+	TMP_CP="$TMP_CP":"$a";
+done
+
+# Now add the system classpath to the classpath. If running
+# Cygwin we also need to change the classpath to Windows format.
+if $cygwin ; then
+	TMP_CP=`cygpath -w -p $TMP_CP`
+	TMP_CP=$TMP_CP';'$CLASSPATH
+else
+	TMP_CP=$TMP_CP:$CLASSPATH
+fi
+
+#To add translation working directories to your classpath edit and uncomment this line:
+#$JAVA -Xmx256m -cp $TMP_CP:<your working dir here> net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9
+
+#To change the language edit and uncomment this line:
+#$JAVA -Xmx256m -cp $TMP_CP:<your working dir here> -Duser.language=<your language here> net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9
+
+
+$JAVA -Xmx256m -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9
+
diff --git a/databases/squirrel-sql/pkg-descr b/databases/squirrel-sql/pkg-descr
new file mode 100644
index 000000000000..958dcd173478
--- /dev/null
+++ b/databases/squirrel-sql/pkg-descr
@@ -0,0 +1,5 @@
+SQuirreL SQL Client is a graphical Java program that will allow you to view the
+structure of a JDBC compliant database, browse the data in tables, issue SQL
+commands etc.
+
+WWW: http://www.squirrelsql.org/index.php?page=screenshots
diff --git a/databases/squirrel-sql/pkg-plist b/databases/squirrel-sql/pkg-plist
new file mode 100644
index 000000000000..e97f7005232d
--- /dev/null
+++ b/databases/squirrel-sql/pkg-plist
@@ -0,0 +1,149 @@
+bin/squirrel-sql
+share/java/squirrel-sql/doc/changes.txt
+share/java/squirrel-sql/doc/faq.html
+share/java/squirrel-sql/doc/images/add_alias_1.png
+share/java/squirrel-sql/doc/images/aliases_tool_window_1.png
+share/java/squirrel-sql/doc/images/chg_driver_1.png
+share/java/squirrel-sql/doc/images/chg_driver_2.png
+share/java/squirrel-sql/doc/images/connect_window.png
+share/java/squirrel-sql/doc/images/createresultwindow.gif
+share/java/squirrel-sql/doc/images/drivers_tool_window_1.png
+share/java/squirrel-sql/doc/images/error_st_obj.gif
+share/java/squirrel-sql/doc/images/global_data_types_1.png
+share/java/squirrel-sql/doc/images/global_data_types_2.png
+share/java/squirrel-sql/doc/images/global_general.png
+share/java/squirrel-sql/doc/images/global_proxy.png
+share/java/squirrel-sql/doc/images/global_sql.png
+share/java/squirrel-sql/doc/images/logo.jpg
+share/java/squirrel-sql/doc/images/logo_1.jpg
+share/java/squirrel-sql/doc/images/ok_st_obj.gif
+share/java/squirrel-sql/doc/images/plugins_1.png
+share/java/squirrel-sql/doc/images/session_1.png
+share/java/squirrel-sql/doc/images/session_2.png
+share/java/squirrel-sql/doc/images/session_props_general.png
+share/java/squirrel-sql/doc/images/session_props_object.png
+share/java/squirrel-sql/doc/images/session_props_sql.png
+share/java/squirrel-sql/doc/images/sql_1.png
+share/java/squirrel-sql/doc/images/sql_2.png
+share/java/squirrel-sql/doc/images/toolspopup.jpg
+share/java/squirrel-sql/doc/licences/dean_jones_icons_licence.txt
+share/java/squirrel-sql/doc/licences/eclipse-icons-licence.html
+share/java/squirrel-sql/doc/licences/eclipse-icons-licence.txt
+share/java/squirrel-sql/doc/licences/log4j-licence.txt
+share/java/squirrel-sql/doc/licences/nano_xml_licence.txt
+share/java/squirrel-sql/doc/licences/squirrel_licence.txt
+share/java/squirrel-sql/doc/licences/sun_icons_licence.txt
+share/java/squirrel-sql/doc/news.txt
+share/java/squirrel-sql/doc/plugins.html
+share/java/squirrel-sql/doc/quick_start.html
+share/java/squirrel-sql/doc/readme.html
+share/java/squirrel-sql/doc/readme.txt
+share/java/squirrel-sql/doc/style.css
+share/java/squirrel-sql/doc/welcome.html
+share/java/squirrel-sql/icons/acorn.ico
+share/java/squirrel-sql/icons/acorn.png
+share/java/squirrel-sql/icons/acorn.xpm
+share/java/squirrel-sql/lib/commons-cli.jar
+share/java/squirrel-sql/lib/forms.jar
+share/java/squirrel-sql/lib/fw.jar
+share/java/squirrel-sql/lib/log4j.jar
+share/java/squirrel-sql/lib/nanoxml-2.1.jar
+share/java/squirrel-sql/log4j.properties
+share/java/squirrel-sql/plugins/codecompletion.jar
+share/java/squirrel-sql/plugins/codecompletion/changes.txt
+share/java/squirrel-sql/plugins/codecompletion/completionpopup.jpg
+share/java/squirrel-sql/plugins/codecompletion/graph.jpg
+share/java/squirrel-sql/plugins/codecompletion/licence.txt
+share/java/squirrel-sql/plugins/codecompletion/readme.html
+share/java/squirrel-sql/plugins/codecompletion/readme.txt
+share/java/squirrel-sql/plugins/codecompletion/src.jar
+share/java/squirrel-sql/plugins/editextras.jar
+share/java/squirrel-sql/plugins/editextras/changes.txt
+share/java/squirrel-sql/plugins/editextras/licence.txt
+share/java/squirrel-sql/plugins/editextras/readme.html
+share/java/squirrel-sql/plugins/editextras/readme.txt
+share/java/squirrel-sql/plugins/editextras/src.jar
+share/java/squirrel-sql/plugins/editextras/toolspopup.jpg
+share/java/squirrel-sql/plugins/graph.jar
+share/java/squirrel-sql/plugins/graph/changes.txt
+share/java/squirrel-sql/plugins/graph/graph.jpg
+share/java/squirrel-sql/plugins/graph/licence.txt
+share/java/squirrel-sql/plugins/graph/readme.html
+share/java/squirrel-sql/plugins/graph/readme.txt
+share/java/squirrel-sql/plugins/graph/src.jar
+share/java/squirrel-sql/plugins/graph/zoomprint.jpg
+share/java/squirrel-sql/plugins/laf.jar
+share/java/squirrel-sql/plugins/laf/OYOAHA-licence.html
+share/java/squirrel-sql/plugins/laf/changes.txt
+share/java/squirrel-sql/plugins/laf/jgoodies-looks-licence.txt
+share/java/squirrel-sql/plugins/laf/kunststoff_Licence.txt
+share/java/squirrel-sql/plugins/laf/laf-plugin-licence.txt
+share/java/squirrel-sql/plugins/laf/lafs/kunststoff.jar
+share/java/squirrel-sql/plugins/laf/lafs/looks-1.3.1.jar
+share/java/squirrel-sql/plugins/laf/lafs/metouia.jar
+share/java/squirrel-sql/plugins/laf/lafs/oalnf.jar
+share/java/squirrel-sql/plugins/laf/lafs/readme.txt
+share/java/squirrel-sql/plugins/laf/lafs/skinlf.jar
+share/java/squirrel-sql/plugins/laf/lafs/swingsetthemes.jar
+share/java/squirrel-sql/plugins/laf/licences.html
+share/java/squirrel-sql/plugins/laf/metouia-licence.txt
+share/java/squirrel-sql/plugins/laf/oyoaha-theme-packs/gradient.otm
+share/java/squirrel-sql/plugins/laf/oyoaha-theme-packs/readme.txt
+share/java/squirrel-sql/plugins/laf/readme.html
+share/java/squirrel-sql/plugins/laf/readme.txt
+share/java/squirrel-sql/plugins/laf/skin_look_and_feel_licence.txt
+share/java/squirrel-sql/plugins/laf/skinlf-theme-packs/readme.txt
+share/java/squirrel-sql/plugins/laf/skinlf-theme-packs/whistlerthemepack.zip
+share/java/squirrel-sql/plugins/laf/src.jar
+share/java/squirrel-sql/plugins/readme.txt
+share/java/squirrel-sql/plugins/sqlbookmark.jar
+share/java/squirrel-sql/plugins/sqlbookmark/bookmarkspopup.jpg
+share/java/squirrel-sql/plugins/sqlbookmark/changes.txt
+share/java/squirrel-sql/plugins/sqlbookmark/licence.txt
+share/java/squirrel-sql/plugins/sqlbookmark/prefs.jpg
+share/java/squirrel-sql/plugins/sqlbookmark/readme.html
+share/java/squirrel-sql/plugins/sqlbookmark/src.jar
+share/java/squirrel-sql/plugins/sqlbookmark/toolspopup.jpg
+share/java/squirrel-sql/plugins/sqlscript.jar
+share/java/squirrel-sql/plugins/sqlscript/changes.txt
+share/java/squirrel-sql/plugins/sqlscript/creattable.jpg
+share/java/squirrel-sql/plugins/sqlscript/licence.txt
+share/java/squirrel-sql/plugins/sqlscript/readme.html
+share/java/squirrel-sql/plugins/sqlscript/readme.txt
+share/java/squirrel-sql/plugins/sqlscript/src.jar
+share/java/squirrel-sql/plugins/sqlscript/toolspopup.jpg
+share/java/squirrel-sql/plugins/syntax.jar
+share/java/squirrel-sql/plugins/syntax/changes.txt
+share/java/squirrel-sql/plugins/syntax/configdlg.jpg
+share/java/squirrel-sql/plugins/syntax/corrabrev.jpg
+share/java/squirrel-sql/plugins/syntax/lib/openide-loaders.jar
+share/java/squirrel-sql/plugins/syntax/lib/openide.jar
+share/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-fold.jar
+share/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-lib.jar
+share/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-util.jar
+share/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor.jar
+share/java/squirrel-sql/plugins/syntax/lib/syntax.jar
+share/java/squirrel-sql/plugins/syntax/licence.txt
+share/java/squirrel-sql/plugins/syntax/readme.html
+share/java/squirrel-sql/plugins/syntax/src.jar
+share/java/squirrel-sql/plugins/syntax/standard-nbm-license.txt
+share/java/squirrel-sql/plugins/syntax/toolspopup.jpg
+share/java/squirrel-sql/squirrel-sql.jar
+@dirrm share/java/squirrel-sql/plugins/syntax/lib
+@dirrm share/java/squirrel-sql/plugins/syntax
+@dirrm share/java/squirrel-sql/plugins/sqlscript
+@dirrm share/java/squirrel-sql/plugins/sqlbookmark
+@dirrm share/java/squirrel-sql/plugins/laf/skinlf-theme-packs
+@dirrm share/java/squirrel-sql/plugins/laf/oyoaha-theme-packs
+@dirrm share/java/squirrel-sql/plugins/laf/lafs
+@dirrm share/java/squirrel-sql/plugins/laf
+@dirrm share/java/squirrel-sql/plugins/graph
+@dirrm share/java/squirrel-sql/plugins/editextras
+@dirrm share/java/squirrel-sql/plugins/codecompletion
+@dirrm share/java/squirrel-sql/plugins
+@dirrm share/java/squirrel-sql/lib
+@dirrm share/java/squirrel-sql/icons
+@dirrm share/java/squirrel-sql/doc/licences
+@dirrm share/java/squirrel-sql/doc/images
+@dirrm share/java/squirrel-sql/doc
+@dirrm share/java/squirrel-sql