Add xsqlmenu-2.10: X based GUI for MySQL

This is a powerful frontend for the MiniSQL or MySQL database
engines, that allows the user to search the database through easy
to use searchforms, select databases and tables from a menu, modify
records just by clicking them in a browser and much more.  Xsqlmenu
supports having multiple tablewindows open at the same time (even
from different databases !).  Also free SQL SELECT statements are
allowed (although they have a few restrictions to avoid confusion).

6 files changed, 94 insertions, 0 deletions

diff --git a/databases/xsqlmenu/Makefile b/databases/xsqlmenu/Makefile
new file mode 100644
index 00000000000..1438577eecf
--- /dev/null
+++ b/databases/xsqlmenu/Makefile
@@ -0,0 +1,24 @@
+# $NetBSD: Makefile,v 1.1.1.1 2001/03/27 02:18:07 hubertf Exp $
+#
+
+DISTNAME=	xsqlmenu-2.10
+CATEGORIES=	databases
+MASTER_SITES=	http://www.jlab.org/~saw/xsqlmenu/
+
+MAINTAINER=	hubertf@netbsd.org
+HOMEPAGE=	http://www.jlab.org/~saw/xsqlmenu/
+COMMENT=	X based GUI for MySQL
+
+DEPENDS+=	xforms-0.8*:../../x11/xforms
+
+USE_GMAKE=	yes
+MAKE_ENV+=	MAKE=gmake
+
+do-install:
+	${INSTALL_PROGRAM} ${WRKSRC}/xsqlmenu ${PREFIX}/bin
+	${INSTALL_DATA_DIR} ${PREFIX}/share/doc/xsqlmenu
+	${INSTALL_DATA} ${WRKSRC}/xsqlmenu.README ${PREFIX}/share/doc/xsqlmenu
+	${INSTALL_DATA} ${WRKSRC}/xsqlmenu.lsm ${PREFIX}/share/doc/xsqlmenu
+	${INSTALL_DATA} ${WRKSRC}/[A-Z][A-Z]* ${PREFIX}/share/doc/xsqlmenu
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/xsqlmenu/files/md5 b/databases/xsqlmenu/files/md5
new file mode 100644
index 00000000000..87b3fb0bd23
--- /dev/null
+++ b/databases/xsqlmenu/files/md5
@@ -0,0 +1,3 @@
+$NetBSD: md5,v 1.1.1.1 2001/03/27 02:18:07 hubertf Exp $
+
+SHA1 (xsqlmenu-2.10.tar.gz) = d97c3237d5bfd2213648067196b5f6d4a57fe706
diff --git a/databases/xsqlmenu/files/patch-sum b/databases/xsqlmenu/files/patch-sum
new file mode 100644
index 00000000000..04eac7f68cf
--- /dev/null
+++ b/databases/xsqlmenu/files/patch-sum
@@ -0,0 +1,3 @@
+$NetBSD: patch-sum,v 1.1.1.1 2001/03/27 02:18:07 hubertf Exp $
+
+SHA1 (patch-aa) = 854bdd562eaa93bfaa3979baa87049898794154b
diff --git a/databases/xsqlmenu/patches/patch-aa b/databases/xsqlmenu/patches/patch-aa
new file mode 100644
index 00000000000..34d7d450a13
--- /dev/null
+++ b/databases/xsqlmenu/patches/patch-aa
@@ -0,0 +1,47 @@
+$NetBSD: patch-aa,v 1.1.1.1 2001/03/27 02:18:07 hubertf Exp $
+
+--- Makefile.orig	Mon Aug 28 05:57:00 2000
++++ Makefile
+@@ -8,13 +8,13 @@
+ all: xsqlmenu
+ 
+ #XFORMSBASE = /opt/lib
+-XFORMSBASE = /usr/X11R6/lib
++XFORMSBASE = ${PREFIX}
+ ifeq (${DB},msql)
+ # Set MSQLBASE to the place where your MiniSQL distribution resides !
+ #MSQLBASE = /opt/lib/Hughes
+ MSQLBASE = /usr/local/Hughes
+ else
+-MYSQLPREFIX = /usr
++MYSQLPREFIX = ${LOCALBASE}
+ endif
+ 
+ ifeq (${DB},msql)
+@@ -26,18 +26,21 @@
+ .msql:
+ 	touch .msql
+ 	rm -f .mysql
+-	make clean
++	gmake clean
+ TYPE=.msql
+ else
+-CFLAGS  = -O -Wall -I$(MYSQLPREFIX)/include/mysql -DUSE_MYSQL
+-LDFLAGS = -L $(MYSQLPREFIX)/lib/mysql -lmysqlclient -L$(XFORMSBASE) -lforms \
+-	-lXpm -L/usr/X11R6/lib -lX11 -lm
++CFLAGS  = -O -Wall -I$(MYSQLPREFIX)/include/mysql -DUSE_MYSQL \
++	  -I${X11BASE}/include/X11 \
++	  -I${X11BASE}/include \
++	  -I${LOCALBASE}/include
++LDFLAGS = -L$(MYSQLPREFIX)/lib/mysql -Wl,-R$(MYSQLPREFIX)/lib/mysql -lmysqlclient -L$(XFORMSBASE) -Wl,-R$(XFORMSBASE) -lforms \
++	-lXpm -L${X11BASE}/lib -Wl,-R${X11BASE}/lib -lX11 -lm
+ LDSTATICFLAGS= -L $(MYSQLPREFIX)/lib/mysql -lmysqlclient $(XFORMSBASE)/libforms.a \
+           $(XFORMSBASE)/libXpm.a -L/usr/X11R6/lib -lX11 -lm
+ .mysql:
+ 	touch .mysql
+ 	rm -f .msql
+-	make clean
++	gmake clean
+ TYPE=.mysql
+ endif
+ 
diff --git a/databases/xsqlmenu/pkg/DESCR b/databases/xsqlmenu/pkg/DESCR
new file mode 100644
index 00000000000..5e4adac6194
--- /dev/null
+++ b/databases/xsqlmenu/pkg/DESCR
@@ -0,0 +1,7 @@
+This is a powerful frontend for the MiniSQL or MySQL database
+engines, that allows the user to search the database through easy
+to use searchforms, select databases and tables from a menu, modify
+records just by clicking them in a browser and much more.  Xsqlmenu
+supports having multiple tablewindows open at the same time (even
+from different databases !).  Also free SQL SELECT statements are
+allowed (although they have a few restrictions to avoid confusion).
diff --git a/databases/xsqlmenu/pkg/PLIST b/databases/xsqlmenu/pkg/PLIST
new file mode 100644
index 00000000000..7f7d8ba156c
--- /dev/null
+++ b/databases/xsqlmenu/pkg/PLIST
@@ -0,0 +1,10 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2001/03/27 02:18:07 hubertf Exp $
+bin/xsqlmenu
+share/doc/xsqlmenu/AUTHORS
+share/doc/xsqlmenu/CHANGES
+share/doc/xsqlmenu/COPYING
+share/doc/xsqlmenu/INSTALL
+share/doc/xsqlmenu/TODO
+share/doc/xsqlmenu/xsqlmenu.README
+share/doc/xsqlmenu/xsqlmenu.lsm
+@dirrm share/doc/xsqlmenu