#
# spec file for package phpPgAdmin (Version 4.2)
#
# Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.

# Please submit bugfixes or comments via http://bugs.opensuse.org/
#



Name:           phpPgAdmin
Summary:        phpPgAdmin is a web-based administration tool for PostgreSQL
BuildRequires:  apache2
Version:        4.2
Release:        55
License:        GPL v2 or later
Group:          Productivity/Databases/Tools
Requires:       php5-pgsql apache2-mod_php5
Url:            http://phppgadmin.sourceforge.net
Source0:        %{name}-%{version}.tar.bz2
Patch1:         phpPgAdmin-CVE-2008-5587.patch
BuildRoot:      %{_tmppath}/%{name}-%{version}-build
BuildArch:      noarch

%description
phpPgAdmin is a web-based administration tool for PostgreSQL. It is
perfect for PostgreSQL DBAs, newbies and hosting services.

Currently it can:

- Administer multiple servers

- Support for PostgreSQL 7.0.x, 7.1.x, 7.2.x, 7.3.x, 7.4.x, 8.0.x
   and 8.1.x

- Manage all aspects (Users, Groups, Databases, Schemas, Tables,
   Views, Reports)

- Easy data manipulation (browse tables, views, reports; Select,
   insert, update and delete; execute SQL statements)

- Dump table data in a variety of formats

- Import SQL scripts, COPY data, XML, CSV and Tabbed

- Available in 26 languages



Authors:
--------
    Dan Wilson
    Robert Treat
    Christopher Kings-Lynne

%prep
%setup -q
%patch1

%build

%install
mkdir -p %buildroot/srv/www/htdocs/%{name}
cp -a * %buildroot/srv/www/htdocs/%{name}/
rm -f %buildroot/srv/www/htdocs/%{name}/lang/php2po
rm -f %buildroot/srv/www/htdocs/%{name}/lang/po2php

%clean
rm -rf $RPM_BUILD_ROOT

%files
%defattr(0644,root,root,0755)
%doc CREDITS DEVELOPERS INSTALL TODO TRANSLATORS
/srv/www/htdocs/%{name}
%exclude /srv/www/htdocs/%{name}/conf/config.inc.php
%config(noreplace) /srv/www/htdocs/%{name}/conf/config.inc.php

%changelog
* Tue Feb 03 2009 max@suse.de
- Added phpPgAdmin-CVE-2008-5587.patch to fix a directory
  traversal vulnerability (bnc#462762).
* Tue Apr 08 2008 tpatzig@suse.de
- update to Version 4.2
  * Add Analyze to Table Level Actions (ioguix)
  * Add support for multiple actions on main pages (ioguix, Robert Treat)
  * Added favicon for Mozilla and a backwards compatible version for IE.
  * Allow browsers to save different usernames and passwords for different servers.
  * Pagination selection available for reports
  * You can configure reports db, schema and table names
  * Add support for creating a table using an exsting one (ioguix)
  * Auto-expand a node in the tree browser if there are no other nodes (Tomasz Pala)
  * Add column about fields constraints type + links in table properties page (ioguix)
  * Support for built-in Full Text Search (Ivan Zolotukhin)
  * Addd alter name, owner & comment on views (ioguix)
  * Add column about called procedure + links to their definition in the triggers
  properties page (ioguix)
  * Add Support for Enum type creation (ioguix,xzilla)
  * Add alter name, owner, comment and properties for sequences (ioguix)
  * Add function costing options (xzilla)
  * Add alter owner & schema on function (xzilla)
  * Add a popup window for the session requests history (karl, ioguix)
  * Add alter table, view, sequence schema (ioguix)
  * several bugfixes
* Sat Aug 04 2007 tpatzig@suse.de
- update to Version 4.1.3
  * Send encrypted passwords over the wire wherever possible.
  * Alter sequence, nextval and setval (Guillaume)
  * Autovacuum configuration support (Robert Treat)
  * Basic ROLE support (Chris Kings-Lynne, Javier Carlos)
  * Add support for SSL connections (Eric Kinolik)
  * Display Prepared Transactions (Javier Carlos)
  * Add automatic lookup of foreign key values in insert/update fields (John Jawed)
  * several bugfixes
* Wed Oct 18 2006 tpatzig@suse.de
- initial build of phpPgAdmin Version 4.0.1