audio/mp3butler Depends on audio/p5-MusicBrainz-Client which is DEPRECATED

audio/p5-MusicBrainz-Client	Disappeared from CPAN
editors/doxymacs	Depends on www/w3-4, which is DEPRECATED
graphics/libart		Does not fetch, no more public distfiles
java/jboss4		Does not build with new ant
korean/hanterm		Depends on korean/johabfonts, which is DEPRECATED, fails to build with new utmpx
korean/johabfonts	No more public distfiles, installs into /
korean/hlatex-psfonts-uhc-extra	Depends on korean/hlatex, which is DEPRECATED
korean/texinfo		Depends on korean/hlatex, which is DEPRECATED
korean/hlatex		No more public distfiles
mail/jboss-mailservices	Depends on java/jboss4, which is DEPRECATED
misc/p5-Geography-NationalGrid-TW	Depends on misc/p5-Geography-NationalGrid, which is DEPRECATED
misc/p5-Geography-NationalGrid	Disappeared from CPAN
multimedia/fxtv		Depends on multimedia/mplex, which is DEPRECATED
multimedia/mplex	Upstream disapeared and distfile is not available
net/py-timeoutsocket	Upstream disapear and distfile is no more available
textproc/p5-XML-LibRSVG	Unmaintained and not used anymore
textproc/javacc		No more public distfiles
www/w3-4/Makefile	Upstream disapeared and distfile is not available
www/commonist		Depends on textproc/javacc, which is DEPRECATED
www/newsfeed		Depends on net/py-timeoutsocket, which is DEPRECATED
x11/fbsd-icons		Upstream disapear and distfile is no more available
x11-themes/geramik	Depends on x11-toolkits/qtpixmap, which is DEPRECATED
x11-toolkits/qtpixmap	No more public distfiles
x11-wm/fvwm95-i18n	Depends on x11/fbsd-icons, which is DEPRECATED
x11-wm/fvwm95		Depends on x11/fbsd-icons, which is DEPRECATED

1 files changed, 0 insertions, 86 deletions

diff --git a/java/jboss4/files/patch-serial-autoinc b/java/jboss4/files/patch-serial-autoinc
deleted file mode 100644
index f39743e63678..000000000000
--- a/java/jboss4/files/patch-serial-autoinc
+++ /dev/null
@@ -1,86 +0,0 @@
-$FreeBSD$
-
-This patch allows JBoss to correctly create tables when
-using the auto-increment feature with Postgresql.
-
-diff -ruN ./server/src/etc/conf/default/standardjbosscmp-jdbc.xml /home/jonc/ports/jboss4/work/jboss-4.0.2-src/server/src/etc/conf/default/standardjbosscmp-jdbc.xml
---- ./server/src/etc/conf/default/standardjbosscmp-jdbc.xml	Thu Jan 27 07:51:35 2005
-+++ /home/jonc/ports/jboss4/work/jboss-4.0.2-src/server/src/etc/conf/default/standardjbosscmp-jdbc.xml	Tue May 17 16:13:34 2005
-@@ -1293,7 +1293,7 @@
-          <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
-          <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
-          <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
--         <auto-increment-template>?1</auto-increment-template>
-+         <auto-increment-template>?1 serial</auto-increment-template>
-          <alias-header-prefix>t</alias-header-prefix>
-          <alias-header-suffix>_</alias-header-suffix>
-          <alias-max-length>32</alias-max-length>
-@@ -1420,7 +1420,7 @@
-          <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
-          <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
-          <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
--         <auto-increment-template>?1</auto-increment-template>
-+         <auto-increment-template>?1 serial</auto-increment-template>
-          <alias-header-prefix>t</alias-header-prefix>
-          <alias-header-suffix>_</alias-header-suffix>
-          <alias-max-length>32</alias-max-length>
-@@ -1674,7 +1674,7 @@
-          <row-locking-template/>
-          <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
-          <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
--         <auto-increment-template>?1 IDENTITY</auto-increment-template>
-+         <auto-increment-template>?1 ?2 ?3 IDENTITY</auto-increment-template>
-          <add-column-template>ALTER TABLE ?1 ADD COLUMN ?2 ?3</add-column-template>
-          <drop-column-template>ALTER TABLE ?1 DROP COLUMN ?2</drop-column-template>
-          <alias-header-prefix>t</alias-header-prefix>
-@@ -1973,7 +1973,7 @@
-               <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
-          -->
-          <fk-constraint-template>ALTER TABLE ?1 ADD INDEX (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
--         <auto-increment-template>?1 auto_increment</auto-increment-template>
-+         <auto-increment-template>?1 ?2 ?3 auto_increment</auto-increment-template>
-          <alter-column-template>ALTER TABLE ?1 MODIFY ?2 ?3</alter-column-template>
-          <alias-header-prefix>t</alias-header-prefix>
-          <alias-header-suffix>_</alias-header-suffix>
-@@ -2113,7 +2113,7 @@
-          <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3 ORDER BY ?4</row-locking-template>
-          <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
-          <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
--         <auto-increment-template>?1 IDENTITY</auto-increment-template>
-+         <auto-increment-template>?1 ?2 ?3 IDENTITY</auto-increment-template>
-          <alter-column-template>ALTER TABLE ?1 ALTER COLUMN ?2 ?3</alter-column-template>
-          <alias-header-prefix>t</alias-header-prefix>
-          <alias-header-suffix>_</alias-header-suffix>
-@@ -2245,7 +2245,7 @@
-          <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3 ORDER BY ?4</row-locking-template>
-          <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
-          <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
--         <auto-increment-template>?1 IDENTITY</auto-increment-template>
-+         <auto-increment-template>?1 ?2 ?3 IDENTITY</auto-increment-template>
-          <alias-header-prefix>t</alias-header-prefix>
-          <alias-header-suffix>_</alias-header-suffix>
-          <alias-max-length>32</alias-max-length>
-diff -ruN ./server/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCStartCommand.java /home/jonc/ports/jboss4/work/jboss-4.0.2-src/server/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCStartCommand.java
---- ./server/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCStartCommand.java	Tue Oct 26 22:28:23 2004
-+++ /home/jonc/ports/jboss4/work/jboss-4.0.2-src/server/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCStartCommand.java	Tue May 17 16:13:34 2005
-@@ -916,14 +916,18 @@
-       // apply auto-increment template
-       if(type.getAutoIncrement()[0])
-       {
--         String columnClause = SQLUtil.getCreateTableColumnsClause(type);
-          JDBCFunctionMappingMetaData autoIncrement =
-             manager.getMetaData().getTypeMapping().getAutoIncrementTemplate();
-          if(autoIncrement == null)
-          {
-             throw new IllegalStateException("auto-increment template not found");
-          }
--         String[] args = new String[]{columnClause};
-+         String[] args = new String[]
-+							{
-+								type.getColumnNames () [0],
-+								type.getSQLTypes () [0],
-+								type.getNotNull () [0] ? " not null " : ""
-+							};
-          autoIncrement.getFunctionSql(args, sqlBuffer);
-       }
-       else