svn commit: r435995 - in head/databases: . phpliteadmin phpliteadmin/files

[Nikolai Lifanov]

Author: lifanov
Date: Sun Mar 12 16:44:33 2017
New Revision: 435995
URL: https://svnweb.freebsd.org/changeset/ports/435995

Log:
  New port: databases/phpliteadmin , web-based SQLite database admin tool written in PHP
  
  Features
  
      Lightweight - consists of a single 200KB source file for portability
      Supports SQLite3 and SQLite2 databases
      Translated and available in over 10 languages - and counting
      Specify and manage an unlimited number of databases
      Specify a directory and optionally its subdirectories to scan for databases
      Create and delete databases
      Add, delete, rename, empty, and drop tables
      Browse, add, edit, and delete records
      Add, delete, and edit table columns
      Manage table indexes
      Manage table triggers
      Import and export tables, structure, indexes, and data (SQL, CSV)
      View data as bar, pie, and line charts
      Graphical search tool to find records based on specified field values
      Create and run your own custom SQL queries in the free-form query editor/builder
      Easily apply core SQLite functions to column values using the GUI
      Write your own PHP functions to be available to apply to column values
      Design your own theme using CSS or install a pre-made theme from the community
      All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases
      Allows multiple installations on the same server, each with a different password
      Secure password-protected interface with login screen and cookies
  
  PR:		214806
  Submitted by:	olevole at olevole.ru

Added:
  head/databases/phpliteadmin/
  head/databases/phpliteadmin/Makefile   (contents, props changed)
  head/databases/phpliteadmin/distinfo   (contents, props changed)
  head/databases/phpliteadmin/files/
  head/databases/phpliteadmin/files/pkg-message.in   (contents, props changed)
  head/databases/phpliteadmin/pkg-descr   (contents, props changed)
Modified:
  head/databases/Makefile

Modified: head/databases/Makefile
==============================================================================
--- head/databases/Makefile	Sun Mar 12 16:11:48 2017	(r435994)
+++ head/databases/Makefile	Sun Mar 12 16:44:33 2017	(r435995)
@@ -645,6 +645,7 @@
     SUBDIR += php71-pdo_sqlite
     SUBDIR += php71-pgsql
     SUBDIR += php71-sqlite3
+    SUBDIR += phpliteadmin
     SUBDIR += phpminiadmin
     SUBDIR += phpmyadmin
     SUBDIR += phppgadmin

Added: head/databases/phpliteadmin/Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/phpliteadmin/Makefile	Sun Mar 12 16:44:33 2017	(r435995)
@@ -0,0 +1,33 @@
+# Created by: olevole at olevole.ru
+# $FreeBSD$
+
+PORTNAME=	phpLiteAdmin
+DISTVERSION=	1.9.7.1
+CATEGORIES=	databases www
+MASTER_SITES=	https://bitbucket.org/phpliteadmin/public/downloads/
+DISTNAME=	${PORTNAME}_v${DISTVERSION:S/./-/g}
+
+MAINTAINER=	olevole at olevole.ru
+COMMENT=	Web-based database management tool for Sqlite
+
+LICENSE=	GPLv3
+
+USES=		php:web zip
+
+NO_ARCH=	yes
+NO_BUILD=	yes
+USE_PHP=	pdo_sqlite session
+
+PLIST_FILES=	${WWWDIR}/phpliteadmin.php \
+		${WWWDIR}/phpliteadmin.config.sample.php
+
+SUB_FILES=	pkg-message
+
+do-install:
+	@${MKDIR} ${STAGEDIR}/${WWWDIR}
+	${INSTALL_DATA} ${WRKDIR}/phpliteadmin.php \
+		${STAGEDIR}${WWWDIR}
+	${INSTALL_DATA} ${WRKDIR}/phpliteadmin.config.sample.php \
+		${STAGEDIR}${WWWDIR}
+
+.include <bsd.port.mk>

Added: head/databases/phpliteadmin/distinfo
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/phpliteadmin/distinfo	Sun Mar 12 16:44:33 2017	(r435995)
@@ -0,0 +1,3 @@
+TIMESTAMP = 1488554930
+SHA256 (phpLiteAdmin_v1-9-7-1.zip) = d44e1ed5d8e6680aca97df8a406817231c05ab3484e8ced0b4e56c922e46d64d
+SIZE (phpLiteAdmin_v1-9-7-1.zip) = 54002

Added: head/databases/phpliteadmin/files/pkg-message.in
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/phpliteadmin/files/pkg-message.in	Sun Mar 12 16:44:33 2017	(r435995)
@@ -0,0 +1,7 @@
+
+phpliteadmin has been installed into:
+
+    %%WWWDIR%%
+
+Please copy phpliteadmin.config.sample.php to phpliteadmin.config.php and
+ edit as you needs.

Added: head/databases/phpliteadmin/pkg-descr
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/phpliteadmin/pkg-descr	Sun Mar 12 16:44:33 2017	(r435995)
@@ -0,0 +1,19 @@
+phpLiteAdmin is a web-based SQLite database admin tool written in PHP with
+support for SQLite3 and SQLite2.
+
+Features
+
+-   Lightweight - consists of a single 200KB source file for portability
+-   Specify and manage an unlimited number of databases
+-   Specify a directory and optionally its subdirectories to scan for databases
+-   Create and delete databases
+-   Add, delete, rename, empty, and drop tables
+-   Browse, add, edit, and delete records
+-   Add, delete, and edit table columns
+-   Manage table indexes
+-   Manage table triggers
+-   Import and export tables, structure, indexes, and data (SQL, CSV)
+-   View data as bar, pie, and line charts
+-   And many other...
+
+WWW: https://www.phpliteadmin.org/