Remove expired ports:
2019-07-12 misc/tcb: Abandonware that uses sys/dir.h
2019-07-12 editors/xed: Abandonware using sys/dir.h
2019-07-12 databases/gtksql: Abandonware using sys/dir.h

Mark as deprecated a bunch of abandonware using sys/dir.h

sys/dir.h is going to be phased out soon, so mark as deprecated non maintained
abandonware using it.

PR:		21519

- Fix build
- Add new necessary dependencies
- Replace portions of CPPFLAGS and LDFLAGS with sed patches for
  ${WRKSRC}/configure
- Add sed patch to rename some deprecated structure names after
  v3.7.1 update of x11-toolkits/scintilla

PR:		217697
Submitted by:	lightside@gmx.com
Approved by:	mat (mentor)
Differential Revision: https://reviews.freebsd.org/D9974

Update WWW: SF redirects to https://sourceforge.net/projects/<PROJECT_NAME>/

- Mark BROKEN: incomplete definition of type 'struct CharacterRange'

- Add LICENSE_FILE
- Switch to options helpers
- Bump PORTREVISION for x11-toolkits/scintilla library change

- Fix trailing whitespace in pkg-descrs, categories [a-f]*

Approved by:	portmgr blanket

Remove USE_SQLITE from bsd.databases.mk, replaced by USES=sqlite.

While there replace USE_SQLITE=x by USES=sqlite:x.

PR:		208971
Submitted by:	mat
Exp-run by:	antoine
With hat:	portmgr
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D5951

Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight

Convert LICENSE= "GPLxx # or later" to "GPLxx+"

Approved by:	portmgr blanket

Unbreak by working-around the short-comings of the current scintilla
port -- the installed shared library no longer links with Gnome shared
libraries, which it is using requiring any users of -lscintilla to link
with them explicitly..

Deprecate ports broken for more than 6 months

Cleanup plist

Mark BROKEN: Fails to configure

configure: error: C compiler cannot create executables
See `config.log' for more details.
===>  Script "configure" failed unexpectedly.

Reported by:	pkg-fallout

Add OPTIONS_DEFINE=DOCS for ports with %%PORTDOCS%% in the plist.

Where possible, correct a few instances where PORTDOCS was being used
to flag stuff in EXAMPLESDIR. For some ports, mostly those owned by
ruby@, PORTDOCS is applied to pretty much everything whether it's
documentation or example.

Bump PORTREVISION on all ports with USE_SQLITE=yes or USE_SQLITE=3 that
have not been bumped yet after the latest libsqlite3.so library version
change.

Approved by:	portmgr (implicit)

Convert to USES=pgsql

With hat:	portmgr

- Fix build
- Stage support

PR:		184234
Submitted by:	Ports Fury

In preparation for making libtool generate libraries with a sane name, fix all
LIB_DEPENDS in databases

- Remove manual creation and removal of share/applications, as it's now in the
mtree (categories starting with d)

Approved by:	portmgr (bdrewery)

databases/gtksql: Fix leftovers

Ever since this port was updated to verson 0.4.5, it has suffered from
leftover files caused by installing two sets of PORTDOCS.  The custom
version added in the post-install target is accounted for, but the
distfiles's makefile also has a target that installs the same files
plus two others in a non-standard location.  The fix is to disable
the distfile's install target and keep the one in post-install.

Explicitly link libraries on 10 unmaintained ports

The following ports will not build with a binutils 2.22+ linker built
with standard options.  This has been obvious with DPorts, but difficult
to see on FreeBSD.  However, setting the ports compiler as a recent gcc
(e.g lang/gcc48) is an excellent way to detect the unspecified but needed
libraries as these recent GCC compilers use the latest binutils linkers.
These patches were tested on FreeBSD 8.4 and DragonFly 3.5

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

- Update devel/automake to 1.14
- Update devel/gettext to 0.18.3
- Fix known-broken (from exp-runs) ports
- Clean up a lot of cruft in the devel/gettext port itself,
  based on work from tijl@

PR:		178883
Submitted by:	ade
Sponsored by:	Wadsworth 6X

- Convert USE_GETTEXT to USES (part 4)

Approved by:	portmgr (bapt)

Convert databases to USES=pkgconfig

- Update to version 4.5, now GTK+2 based
- Convert to OptionsNG, respect NLS option
- Add support for sqlite3
- Add license info
- Respect CFLAGS during build
- Update COMMENT, pkg-descr to describe actual state

PR:		ports/176402
Reported by:	Aldis Berjoza <graudeejs@gmail.com>

- Reassign to the heap at maintainer's request

Approved by:	portmgr

Pointyhat confirms that these don't work with newer MySQL, so
mark them:

BROKEN=         Needs modification to work with newer MySQL
EXPIRATION_DATE=        2011-11-30

Remove references to mysql 323 and 40, most commonly of the form:

IGNORE_WITH_MYSQL=     323 40

- Get Rid MD5 support

Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)

- Remove USE_XLIB/USE_X_PREFIX/USE_XPM in favor of USE_XORG
- Bump PORTREVISION

Approved by:    portmgr (xorg cleanup)

- Welcome X.org 7.2 \o/.
- Set X11BASE to ${LOCALBASE} for recent ${OSVERSION}.
- Bump PORTREVISION for ports intalling files in ${X11BASE}.

Remove USE_REINPLACE from all categories starting with D

Bump PORTREVISION on glib12/gtk12 consumer ports to ease the upgrade path.

Discussed with: kris
Approved by:    portmgr (implicit)

SHA256ify

Approved by:    krion@

Fix build when WITH_PGSQL is set.

PR:             ports/84522
Submitted by:   Dominik Brettnacher <domi@saargate.de> (maintainer)
Approved by:    portmgr (clement)

- Change last few occurences of USE_GTK=yes to USE_GNOME=gtk12

Approved by:    portmgr (marcus)

Split the postgresql ports into a server and a client part.

All ports depending on postgresql shall use the USE_PGSQL=yes knob
defined in Mk/bsd.ports.mk. Bumping portrevisions where needed.

PR:             75344
Approved by:    portmgr@ (kris), ade & sean (mentors)

SIZEify (maintainer timeout)

Bump PORTREVISION on all ports that depend on gettext to aid with upgrading.

(Part 2)

gtksql fixes: PERL/REINPLACE, postgres, LOCALBASE

        1. the port now uses REINPLACE_CMD instead of perl
        2. the MySQL and Postgres dependencies are now LOCALBASE-clean
        3. PGSQLCFLAGS is updated to track changes in the Postgres tree

PR:             ports/50502
Submitted by:   Dominik Brettnacher <domi@saargate.de>

De-pkg-comment.

Chase libpq version bump.

Project site moved

PR:             ports/40534
Submitted by:   maintainer
Noticed by:     Tilman Linneweh <tilman@arved.de>

NOPORTDOCS support for pkg-plist    

Fix include directory for postgresql7.1's new layout.    

typo clean up police: \s -> \t    

Switch from mysql322-{client,server} to mysql323-{client,server}.    

Fix typo that prevents Gtksql from being used with Postgres.    

Convert category databases to new layout.  

Implement USE_GTK, part 1.    

old postgresql port has been removed.   use postgresql7, which has proven
stability now.    

- Use GTK_CONFIG/GLIB_CONFIG instead of hardcoded gtk12-config/glib12-config   -
Support CC/CFLAGS/PREIFX/LOCALBASE/X11BASE/MAKE/etc. properly