You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Richard Emberson <re...@edgedynamics.com> on 2004/12/07 16:23:14 UTC
Re: developers: table prefix patch 1
It was suggested that I post my patches enabling table prefixes in the
bug database. I could not see how to attach the two attached files
when filling out the bug report.
The second diff file follows.
Please help.
What the patch includes is a modification to the build system that
first copies and filters the source files and then compiles. Include
is not only the ability to specify the table prefix (defaults to having
no prefix) but also the ability to query from the command line build
version information (uses in a JMX env can add code to display info
in webpage).
One must set the following properties in build.properties for this to work.
table.prefix=SLIDE_
# if table.prefix is not set, then no prefix is generated
#table.prefix=
version.major=2
version.minor=2
version.release=pre1
# the following two properties could be set on the command line to ant
# during a release build step rather than setting them as properties
version.cvs.tag=
version.name=
Of course some will believe that the Slide table names such as:
OBJECT, LOCKS, PROPERTIES, etc. will never collide with other table
names and therefore such a table name prefixing is not needed, or that
all other applications should change their table names ... whatever.
My usage is a large J2EE application with lots of third party tables
and a "good" third party app in such an environment allows one to
change table names.
--
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
Re: developers: table prefix patch 1
Posted by John Rousseau <jr...@archivas.com>.
I couldn't figure this out myself until I opened a bug.
Open the bug without the patch. Once the bug is opened you can add an
attachment to it.
-John
Richard Emberson wrote:
> It was suggested that I post my patches enabling table prefixes in the
> bug database. I could not see how to attach the two attached files
> when filling out the bug report.
>
> The second diff file follows.
>
> Please help.
>
>
> What the patch includes is a modification to the build system that
> first copies and filters the source files and then compiles. Include
> is not only the ability to specify the table prefix (defaults to having
> no prefix) but also the ability to query from the command line build
> version information (uses in a JMX env can add code to display info
> in webpage).
>
>
> One must set the following properties in build.properties for this to work.
>
> table.prefix=SLIDE_
> # if table.prefix is not set, then no prefix is generated
> #table.prefix=
> version.major=2
> version.minor=2
> version.release=pre1
> # the following two properties could be set on the command line to ant
> # during a release build step rather than setting them as properties
> version.cvs.tag=
> version.name=
>
> Of course some will believe that the Slide table names such as:
> OBJECT, LOCKS, PROPERTIES, etc. will never collide with other table
> names and therefore such a table name prefixing is not needed, or that
> all other applications should change their table names ... whatever.
> My usage is a large J2EE application with lots of third party tables
> and a "good" third party app in such an environment allows one to
> change table names.
>
>
> ------------------------------------------------------------------------
>
> Index: build.xml
> ===================================================================
> RCS file: /home/cvspublic/jakarta-slide/build.xml,v
> retrieving revision 1.245
> diff -u -w -r1.245 build.xml
> --- build.xml 30 Nov 2004 10:12:36 -0000 1.245
> +++ build.xml 3 Dec 2004 16:32:05 -0000
> @@ -15,12 +15,26 @@
> <property name="compile.optimize" value="true"/>
> <!-- Should Java compilations set the 'optimize' compiler option? -->
> <property name="compile.target" value="1.3"/>
> + <!-- Set the build timestamp and year -->
> + <tstamp>
> + <format property="build.iso.date" pattern="yyyy-MM-dd'T'HH:mm"
> + timezone="PST"/>
> + <format property="build.year" pattern="yyyy"/>
> + </tstamp>
> <!-- =================================================================== -->
> <!-- Project Properties -->
> <!-- =================================================================== -->
> <property name="name" value="Jakarta-Slide"/>
> <property name="year" value="2004"/>
> +<!--
> <property name="version" value="2.2pre1"/>
> +-->
> + <!--
> + One might like the version to be X.Y.Z but the jakarta-slide-webdavlib
> + jar requires that its format be X.YZ.
> + -->
> + <property name="version"
> + value="${version.major}.${version.minor}${version.release}"/>
> <property name="release-notes" value="RELEASE-NOTES-2.2"/>
> <property name="project" value="jakarta-slide"/>
> <property name="final.name" value="${project}-server-bin-${version}"/>
> @@ -68,6 +82,7 @@
> <!-- Build Properties -->
> <!-- =================================================================== -->
> <property name="slide.build" value="./build"/>
> + <property name="generated.source.dir" value="${slide.build}/generated-src"/>
> <property name="slide.dist" value="./dist"/>
> <property name="slide.clientlib.dist" value="webdavclient/${slide.dist}"/>
> <property name="testsuite.dist" value="${slide.dist}/webdav-testsuite"/>
> @@ -217,12 +232,45 @@
> <!-- =================================================================== -->
> <target name="prepare" depends="detect">
> <mkdir dir="${slide.build}"/>
> + <mkdir dir="${generated.source.dir}"/>
> <mkdir dir="${slide.build}/classes"/>
> <mkdir dir="${slide.build}/lib"/>
> <mkdir dir="${slide.build}/doc"/>
> <mkdir dir="${slide.build}/doc/schema"/>
> <mkdir dir="${slide.build}/doc/samples"/>
> <mkdir dir="${slide.build}/doc/javadoc"/>
> +
> + <copy todir="${generated.source.dir}">
> + <fileset dir="src">
> + <exclude name="CVS"/>
> + </fileset>
> + <filterset>
> + <filter token="TABLE_PREFIX" value="${table.prefix}"/>
> + <filter token="version.major" value="${version.major}"/>
> + <filter token="version.minor" value="${version.minor}"/>
> + <filter token="version.release" value="${version.release}"/>
> + <filter token="build.iso.date" value="${build.iso.date}"/>
> + <filter token="version.cvs.tag" value="${version.cvs.tag}"/>
> + <filter token="version.name" value="${version.name}"/>
> +
> + <filter token="os.name" value="${os.name}"/>
> + <filter token="os.arch" value="${os.arch}"/>
> + <filter token="os.version" value="${os.version}"/>
> +
> + <filter token="java.version" value="${java.version}"/>
> + <filter token="java.vendor" value="${java.vendor}"/>
> + <filter token="java.vm.specification.version"
> + value="${java.vm.specification.version}"/>
> + <filter token="java.vm.version" value="${java.vm.version}"/>
> + <filter token="java.vm.vendor" value="${java.vm.vendor}"/>
> + <filter token="java.vm.name" value="${java.vm.name}"/>
> + <filter token="java.vm.info" value="${java.vm.info}"/>
> + <filter token="java.specification.version"
> + value="${java.specification.version}"/>
> + <filter token="java.class.version" value="${java.class.version}"/>
> + </filterset>
> + </copy>
> +
> </target>
> <!-- =================================================================== -->
> <!-- Build All : Main, Doc and JavaDoc -->
> @@ -231,21 +279,31 @@
> <!-- =================================================================== -->
> <!-- Build Slide -->
> <!-- =================================================================== -->
> - <target name="main" description="Builds Slide's Core">
> + <target name="main" depends="prepare" description="Builds Slide's Core">
> <copy todir="${slide.build}/classes">
> <fileset dir=".">
> <include name="LICENSE"/>
> <include name="NOTICE"/>
> </fileset>
> </copy>
> +
> <echo message="Building Slide Core API"/>
> - <javac srcdir="src/share" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" excludes="**/CVS/**,**/webdav/**,**/manager/**,**/package.html" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/share"
> + destdir="${slide.build}/classes"
> + debug="${compile.debug}"
> + deprecation="${compile.deprecation}"
> + optimize="${compile.optimize}"
> + target="${compile.target}">
> +
> <classpath refid="main.classpath"/>
> + <exclude name="**/webdav/**" />
> + <exclude name="**/manager/**" />
> + <exclude name="**/pacakge.html" />
> <exclude name="**/Slide.java" unless="jmx.present"/>
> <exclude name="**/SlideMBean.java" unless="jmx.present"/>
> </javac>
> <copy todir="${slide.build}/classes">
> - <fileset dir="src/share">
> + <fileset dir="${generated.source.dir}/share">
> <include name="**/*.properties"/>
> <exclude name="**/slide.properties"/>
> </fileset>
> @@ -255,25 +313,52 @@
> <include name="**/**"/>
> </fileset>
> </copy>
> +
> <echo message="Building Slide WebDAV Servlet"/>
> - <javac srcdir="src/webdav/server" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" includes="**/webdav/**" excludes="**/CVS/**,**/package.html" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/webdav/server"
> + destdir="${slide.build}/classes"
> + debug="${compile.debug}"
> + deprecation="${compile.deprecation}"
> + optimize="${compile.optimize}"
> + includes="**/webdav/**"
> + target="${compile.target}">
> +
> <classpath refid="webdavservlet.classpath"/>
> + <exclude name="**/pacakge.html" />
> </javac>
> +
> <echo message="Building Standard Stores"/>
> - <javac srcdir="src/stores" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" excludes="**/CVS/**,**/package.html,**/*Test*" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/stores"
> + destdir="${slide.build}/classes"
> + debug="${compile.debug}"
> + deprecation="${compile.deprecation}"
> + optimize="${compile.optimize}"
> + target="${compile.target}">
> +
> <classpath refid="stores.classpath"/>
> + <exclude name="**/pacakge.html" />
> + <exclude name="**/*Test*" />
> </javac>
> <copy todir="${slide.build}/classes">
> - <fileset dir="src/stores">
> + <fileset dir="${generated.source.dir}/stores">
> <include name="**/*.xml"/>
> </fileset>
> </copy>
> +
> <echo message="Building Default Roles"/>
> - <javac srcdir="src/roles" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" excludes="**/CVS/**,**/package.html" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/roles"
> + destdir="${slide.build}/classes"
> + debug="${compile.debug}"
> + deprecation="${compile.deprecation}"
> + optimize="${compile.optimize}"
> + target="${compile.target}">
> +
> <classpath refid="stores.classpath"/>
> + <exclude name="**/pacakge.html" />
> </javac>
> +
> <echo message="Building JAAS LoginModule"/>
> - <javac srcdir="src/jaas" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/jaas" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" target="${compile.target}">
> <classpath refid="main.classpath"/>
> </javac>
> </target>
> @@ -282,10 +367,10 @@
> <!-- This target requires Log4j -->
> <!-- =================================================================== -->
> <target name="log4j-logger" depends="main">
> - <javac srcdir="src/wrappers" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" includes="**/log4j/**" excludes="**/CVS/**" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/wrappers" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" includes="**/log4j/**" excludes="**/CVS/**" target="${compile.target}">
> <classpath refid="wrappers.classpath"/>
> </javac>
> - <copy file="src/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF"/>
> + <copy file="${generated.source.dir}/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF"/>
> <replace file="${slide.build}/classes/MANIFEST.MF" token="$$VERSION$$" value="${version}"/>
> <jar jarfile="${slide.dist}/slide/lib/${slide-log4jlogger.jar}" basedir="${slide.build}/classes" manifest="${slide.build}/classes/MANIFEST.MF" includes="LICENSE,NOTICE,**/log4j/**"/>
> </target>
> @@ -294,10 +379,10 @@
> <!-- This target requires JDK1.4 -->
> <!-- =================================================================== -->
> <target name="jdk14-logging" depends="main" if="jvm14.present">
> - <javac srcdir="src/jdk14" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" includes="**" excludes="**/CVS/**" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/jdk14" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" includes="**" excludes="**/CVS/**" target="${compile.target}">
> <classpath refid="wrappers.classpath"/>
> </javac>
> - <copy file="src/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF"/>
> + <copy file="${generated.source.dir}/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF"/>
> <replace file="${slide.build}/classes/MANIFEST.MF" token="$$VERSION$$" value="${version}"/>
> <jar jarfile="${slide.dist}/slide/lib/${slide-jdk14logger.jar}" basedir="${slide.build}/classes" manifest="${slide.build}/classes/MANIFEST.MF" includes="LICENSE,NOTICE,**/jdk14/**"/>
> </target>
> @@ -305,9 +390,11 @@
> <!-- Build documentation -->
> <!-- =================================================================== -->
> <target name="doc" depends="prepare" description="Generate documentation/website">
> - <style basedir="src/doc" destdir="${slide.build}/doc" extension=".html" style="src/doc/stylesheets/slide.xsl" includes="*.xml"/>
> + <style basedir="${generated.source.dir}/doc"
> + destdir="${slide.build}/doc" extension=".html"
> + style="${generated.source.dir}/doc/stylesheets/slide.xsl" includes="*.xml"/>
> <copy todir="${slide.build}/doc">
> - <fileset dir="src/doc">
> + <fileset dir="${generated.source.dir}/doc">
> <include name="**/*.gif"/>
> <include name="**/*.jpg"/>
> <include name="**/*.png"/>
> @@ -316,7 +403,7 @@
> </fileset>
> </copy>
> <copy todir="${slide.build}/doc/schema">
> - <fileset dir="src/schema">
> + <fileset dir="${generated.source.dir}/schema">
> <include name="**/*.xsd"/>
> <include name="**/*.dtd"/>
> </fileset>
> @@ -326,9 +413,9 @@
> <!-- Javadoc of the WebDAV Server -->
> <!-- =================================================================== -->
> <target name="webdav-server-javadoc" unless="skip.javadoc">
> - <copy todir="${slide.build}/src/webdav/server">
> + <copy todir="${generated.source.dir}/webdav/server">
> <fileset dir="${slide.build}/doc/serverjavadoc"/>
> - <fileset dir="src/webdav/server">
> + <fileset dir="${generated.source.dir}/webdav/server">
> <include name="**/webdav/**"/>
> <exclude name="**/CVS/**"/>
> <exclude name="**/Slide.java" unless="jmx.present"/>
> @@ -337,7 +424,15 @@
> </copy>
> <mkdir dir="${slide.build}/doc/serverjavadoc"/>
> <property name="copyright" value=""/>
> - <javadoc sourcepath="${slide.build}/src/webdav/server" destdir="${slide.build}/doc/serverjavadoc" doctitle="Slide ${version} WebDAV Server JavaDoc" windowtitle="Slide WebDAV Server Documentation" package="true" noindex="false" author="true" version="true" packagenames="org.apache.slide.webdav.*">
> + <javadoc sourcepath="${generated.source.dir}/webdav/server"
> + destdir="${slide.build}/doc/serverjavadoc"
> + doctitle="Slide ${version} WebDAV Server JavaDoc"
> + windowtitle="Slide WebDAV Server Documentation"
> + package="true"
> + noindex="false"
> + author="true"
> + version="true"
> + packagenames="org.apache.slide.webdav.*">
> <classpath refid="webdavservlet.classpath"/>
> </javadoc>
> <copy todir="${slide.dist}/doc/serverjavadoc">
> @@ -358,7 +453,16 @@
> <!-- =================================================================== -->
> <target name="javadoc" depends="prepare" unless="skip.javadoc" description="Generate core API documentation">
> <property name="copyright" value=""/>
> - <javadoc sourcepath="src/share" destdir="${slide.build}/doc/javadoc" doctitle="Slide ${version} API Documentation" windowtitle="Slide API Documentation" overview="src/share/overview.html" package="true" noindex="false" author="true" version="true" packagenames="org.*">
> + <javadoc sourcepath="${generated.source.dir}/share"
> + destdir="${slide.build}/doc/javadoc"
> + doctitle="Slide ${version} API Documentation"
> + windowtitle="Slide API Documentation"
> + overview="${generated.source.dir}/share/overview.html"
> + package="true"
> + noindex="false"
> + author="true"
> + version="true"
> + packagenames="org.*">
> <classpath>
> <path refid="main.classpath"/>
> <pathelement location="${jmx.jar}" />
> @@ -381,10 +485,10 @@
> <!-- Build a Slide distribution -->
> <!-- =================================================================== -->
> <target name="dist" depends="main,prepare-dist,doc,javadoc,dist-xml,log4j-logger, jdk14-logging" description="Make distribution of core components">
> - <copy file="src/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF" overwrite="yes" />
> + <copy file="${generated.source.dir}/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF" overwrite="yes" />
> <replace file="${slide.build}/classes/MANIFEST.MF" token="$$VERSION$$" value="${version}"/>
> <echo message="Building Slide main JAR file"/>
> - <copy file="src/conf/webapp/slide.properties" tofile="${slide.build}/classes/org/apache/slide/slide.properties" overwrite="yes" />
> + <copy file="${generated.source.dir}/conf/webapp/slide.properties" tofile="${slide.build}/classes/org/apache/slide/slide.properties" overwrite="yes" />
> <jar jarfile="${slide.dist}/slide/lib/${slide-kernel.jar}" basedir="${slide.build}/classes" manifest="${slide.build}/classes/MANIFEST.MF" includes="LICENSE,NOTICE,org/apache/slide/**" excludes="org/apache/slide/webdav/**,org/apache/slide/jaas/**,org/apache/slide/store/impl/**,org/apache/slide/store/util/**,org/apache/slide/store/txfile/**,org/apache/slide/store/txjndi/**,org/apache/slide/store/mem/**,org/apache/slide/search/basic/sample/**,org/apache/slide/index/**,org/apache/slide/util/logger/jdk14/**"/>
> <echo message="Building Slide Standard Stores JAR file"/>
> <jar jarfile="${slide.dist}/slide/lib/${slide-stores.jar}" basedir="${slide.build}/classes" manifest="${slide.build}/classes/MANIFEST.MF" includes="LICENSE,NOTICE,slidestore/**,org/apache/slide/store/impl/**,org/apache/slide/store/util/**,org/apache/slide/store/txfile/**,org/apache/slide/store/txjndi/**,org/apache/slide/store/mem/**,org/apache/slide/index/**"/>
> @@ -400,7 +504,7 @@
> <fileset dir="${slide.build}/doc"/>
> </copy>
> <copy todir="${slide.dist}/slide/db-schema" overwrite="yes">
> - <fileset dir="src/conf/schema"/>
> + <fileset dir="${generated.source.dir}/conf/schema"/>
> </copy>
> <copy todir="${slide.dist}">
> <fileset dir=".">
> @@ -428,19 +532,20 @@
> <target name="webapp-dist" depends="dist" description="Creates a web archive (war) without authentication">
> <filter token="AUTH" value="${authenticate}"/>
> <copy todir="${slide.dist}/slide/conf" filtering="true" overwrite="yes">
> - <fileset dir="src/conf/webapp">
> + <fileset dir="${generated.source.dir}/conf/webapp">
> <include name="web.xml"/>
> <include name="slide.properties"/>
> <include name="log4j.properties"/>
> </fileset>
> </copy>
> <war warfile="${webapp.dist}/slide.war" webxml="${slide.dist}/slide/conf/web.xml">
> - <fileset dir="src/conf/webapp">
> + <fileset dir="${generated.source.dir}/conf/webapp">
> <include name="**/Domain.xml"/>
> </fileset>
> <lib dir="${slide.dist}/slide/lib"/>
> </war>
> - <war warfile="${webapp.dist}/slide-doc.war" webxml="src/conf/webapp/webdoc.xml">
> + <war warfile="${webapp.dist}/slide-doc.war"
> + webxml="${generated.source.dir}/conf/webapp/webdoc.xml">
> <fileset dir="${slide.dist}/doc">
> </fileset>
> </war>
> @@ -451,14 +556,14 @@
> <target name="webapp-jaas-dist" depends="dist" description="Creates a web archive (war) with JAAS authentication">
> <filter token="AUTH" value=""/>
> <copy todir="${slide.dist}/slide/conf" filtering="true" overwrite="yes">
> - <fileset dir="src/conf/webapp">
> + <fileset dir="${generated.source.dir}/conf/webapp">
> <include name="web.xml"/>
> <include name="slide.properties"/>
> <include name="log4j.properties"/>
> </fileset>
> </copy>
> <war warfile="${webapp.dist}/slide.war" webxml="${slide.dist}/slide/conf/web.xml">
> - <fileset dir="src/conf/webapp">
> + <fileset dir="${generated.source.dir}/conf/webapp">
> <include name="**/Domain.xml"/>
> </fileset>
> <lib dir="${slide.dist}/slide/lib"/>
> @@ -468,9 +573,10 @@
> <include name="NOTICE"/>
> <include name="${release-notes}"/>
> </fileset>
> - <zipfileset dir="src/conf/schema" prefix="db-schema" />
> + <zipfileset dir="${generated.source.dir}/conf/schema" prefix="db-schema" />
> </war>
> - <war warfile="${webapp.dist}/slide-doc.war" webxml="src/conf/webapp/webdoc.xml">
> + <war warfile="${webapp.dist}/slide-doc.war"
> + webxml="${generated.source.dir}/conf/webapp/webdoc.xml">
> <fileset dir="${slide.dist}/doc">
> </fileset>
> </war>
> @@ -484,12 +590,15 @@
> <copy file="${slide.dist}/slide/webapp/slide-doc.war" todir="${catalina.dist}/webapps" overwrite="yes"/>
> <copy file="${slide.dist}/slide/webapp/slide.war" todir="${catalina.dist}/webapps" overwrite="yes"/>
> <!-- jaas config -->
> - <copy file="src/conf/webapp/jaas.config" todir="${catalina.dist}/conf/" overwrite="yes"/>
> + <copy file="${generated.source.dir}/conf/webapp/jaas.config" todir="${catalina.dist}/conf/" overwrite="yes"/>
> <!-- patch server.xml -->
> - <patch originalfile="${catalina.dist}/conf/server.xml" patchfile="src/conf/catalina/tomcat-jaas-server.patch"/>
> + <patch originalfile="${catalina.dist}/conf/server.xml"
> + patchfile="${generated.source.dir}/conf/catalina/tomcat-jaas-server.patch"/>
> <!-- patch startup -->
> - <patch originalfile="${catalina.dist}/bin/startup.bat" patchfile="src/conf/catalina/startup-jaas.bat.patch"/>
> - <patch originalfile="${catalina.dist}/bin/catalina.sh" patchfile="src/conf/catalina/catalina-jaas.sh.patch"/>
> + <patch originalfile="${catalina.dist}/bin/startup.bat"
> + patchfile="${generated.source.dir}/conf/catalina/startup-jaas.bat.patch"/>
> + <patch originalfile="${catalina.dist}/bin/catalina.sh"
> + patchfile="${generated.source.dir}/conf/catalina/catalina-jaas.sh.patch"/>
> <!--ant antfile="build.xml" dir="projector" target="tomcat-install"/-->
> </target>
> <!-- =================================================================== -->
> @@ -497,15 +606,15 @@
> <!-- This target requires Tomcat 4 or 5 -->
> <!-- =================================================================== -->
> <target name="catalina-wrapper" depends="dist" if="catalina.present">
> - <javac srcdir="src/wrappers" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" includes="**" excludes="**/CVS/**" target="${compile.target}">
> + <javac srcdir="${generated.source.dir}/wrappers" destdir="${slide.build}/classes" debug="${compile.debug}" deprecation="${compile.deprecation}" optimize="${compile.optimize}" includes="**" excludes="**/CVS/**" target="${compile.target}">
> <classpath refid="wrappers.classpath"/>
> <exclude name="**/catalina/**" unless="catalina.present"/>
> <exclude name="**/log4j/**"/>
> </javac>
> - <copy file="src/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF"/>
> + <copy file="${generated.source.dir}/etc/MANIFEST.MF" tofile="${slide.build}/classes/MANIFEST.MF"/>
> <replace file="${slide.build}/classes/MANIFEST.MF" token="$$VERSION$$" value="${version}"/>
> <copy todir="${slide.build}/classes/wrappers/catalina">
> - <fileset dir="src/wrappers/wrappers/catalina">
> + <fileset dir="${generated.source.dir}/wrappers/wrappers/catalina">
> <include name="slide-descriptors.xml"/>
> </fileset>
> </copy>
> @@ -517,7 +626,7 @@
> <!-- =================================================================== -->
> <target name="tomcat-4-install" depends="tomcat-install" if="catalina.present" description="Modifies Tomcat 4.x installation to include Slide">
> <copy todir="${slide.dist}/slide/catalina-conf" overwrite="yes">
> - <fileset dir="src/conf/catalina">
> + <fileset dir="${generated.source.dir}/conf/catalina">
> <include name="tomcat-4-server.patch"/>
> </fileset>
> </copy>
> @@ -530,7 +639,7 @@
> <!-- =================================================================== -->
> <target name="tomcat-5-install" depends="tomcat-install" if="catalina.present" description="Modifies Tomcat 5.x installation to include Slide">
> <copy todir="${slide.dist}/slide/catalina-conf" overwrite="yes">
> - <fileset dir="src/conf/catalina">
> + <fileset dir="${generated.source.dir}/conf/catalina">
> <include name="tomcat-5-server.patch"/>
> </fileset>
> </copy>
> @@ -547,13 +656,13 @@
> <filter token="AUTH" value=""/>
> <!-- enable authentication -->
> <copy todir="${slide.dist}/slide/catalina-conf" filtering="true" overwrite="yes">
> - <fileset dir="src/conf/webapp">
> + <fileset dir="${generated.source.dir}/conf/webapp">
> <include name="web.xml"/>
> <include name="log4j.properties"/>
> </fileset>
> </copy>
> <copy todir="${slide.dist}/slide/catalina-conf" overwrite="yes">
> - <fileset dir="src/conf/catalina">
> + <fileset dir="${generated.source.dir}/conf/catalina">
> <include name="slide.properties"/>
> </fileset>
> </copy>
> @@ -561,7 +670,7 @@
> <jar jarfile="${slide.dist}/slide/catalina-conf/${slide-kernel-bundle.jar}" basedir="${slide.build}/classes" manifest="${slide.build}/classes/MANIFEST.MF" includes="LICENSE,NOTICE,org/apache/slide/**,org/apache/util/**" excludes="org/apache/slide/webdav/**"/>
> <mkdir dir="${catalina.dist}/slide"/>
> <copy todir="${catalina.dist}/slide" overwrite="yes">
> - <fileset dir="src/conf/webapp">
> + <fileset dir="${generated.source.dir}/conf/webapp">
> <include name="Domain.xml"/>
> </fileset>
> </copy>
> @@ -573,7 +682,7 @@
> </copy>
>
> <copy todir="${catalina.dist}/slide/db-schema" overwrite="yes">
> - <fileset dir="src/conf/schema"/>
> + <fileset dir="${generated.source.dir}/conf/schema"/>
> </copy>
>
> <!-- also copy general information into Slide directory -->
> @@ -756,7 +865,7 @@
> <copy todir="${slide.dist}/${slide-src.archive}">
> <fileset dir=".">
> <include name="lib/**"/>
> - <include name="src/**"/>
> + <include name="${generated.source.dir}/**"/>
> <include name="projector/**"/>
> <include name="build.xml"/>
> <include name="build.properties.sample"/>
> Index: proposals/wck/src/org/apache/slide/simple/store/WebdavStoreAdapter.java
> ===================================================================
> RCS file: /home/cvspublic/jakarta-slide/proposals/wck/src/org/apache/slide/simple/store/WebdavStoreAdapter.java,v
> retrieving revision 1.8
> retrieving revision 1.7
> diff -u -w -r1.8 -r1.7
> --- proposals/wck/src/org/apache/slide/simple/store/WebdavStoreAdapter.java 3 Dec 2004 16:24:22 -0000 1.8
> +++ proposals/wck/src/org/apache/slide/simple/store/WebdavStoreAdapter.java 20 Oct 2004 06:30:40 -0000 1.7
> @@ -1,7 +1,7 @@
> /*
> - * $Header: /home/cvspublic/jakarta-slide/proposals/wck/src/org/apache/slide/simple/store/WebdavStoreAdapter.java,v 1.8 2004/12/03 16:24:22 ozeigermann Exp $
> - * $Revision: 1.8 $
> - * $Date: 2004/12/03 16:24:22 $
> + * $Header: /home/cvspublic/jakarta-slide/proposals/wck/src/org/apache/slide/simple/store/WebdavStoreAdapter.java,v 1.7 2004/10/20 06:30:40 ozeigermann Exp $
> + * $Revision: 1.7 $
> + * $Date: 2004/10/20 06:30:40 $
> *
> * ====================================================================
> *
> @@ -54,7 +54,7 @@
> * @see WebdavStoreBulkPropertyExtension
> * @see WebdavStoreSinglePropertyExtension
> * @see WebdavFileStore
> - * @version $Revision: 1.8 $
> + * @version $Revision: 1.7 $
> */
> public class WebdavStoreAdapter extends AbstractXAServiceBase implements Service, ContentStore, NodeStore, LockStore,
> RevisionDescriptorStore, RevisionDescriptorsStore {
> @@ -595,9 +595,7 @@
> throw new RevisionDescriptorNotFoundException(uri.toString());
> } else {
> NodeRevisionDescriptor descriptor = new NodeRevisionDescriptor(new NodeRevisionNumber(1, 0),
> - NodeRevisionDescriptors.MAIN_BRANCH, new Vector(), new ArrayList());
> - // override default collection as we will set this later
> - descriptor.removeProperty(NodeRevisionDescriptor.RESOURCE_TYPE);
> + NodeRevisionDescriptors.MAIN_BRANCH, new Vector(), new Hashtable());
> if (objectExistsInStore(uri)) {
> try {
>
> Index: src/conf/schema/DB2Server.sql
> ===================================================================
> RCS file: /home/cvspublic/jakarta-slide/src/conf/schema/DB2Server.sql,v
> retrieving revision 1.1
> diff -u -w -r1.1 DB2Server.sql
> --- src/conf/schema/DB2Server.sql 15 Jul 2004 06:38:24 -0000 1.1
> +++ src/conf/schema/DB2Server.sql 3 Dec 2004 16:32:06 -0000
> @@ -4,41 +4,41 @@
> --==============================================================
>
>
> -drop table BINDING;
> +drop table @TABLE_PREFIX@BINDING;
>
> -drop table BRANCH;
> +drop table @TABLE_PREFIX@BRANCH;
>
> -drop table "LABEL";
> +drop table "@TABLE_PREFIX@LABEL";
>
> -drop table LINKS;
> +drop table @TABLE_PREFIX@LINKS;
>
> -drop table LOCKS;
> +drop table @TABLE_PREFIX@LOCKS;
>
> -drop table OBJECT;
> +drop table @TABLE_PREFIX@OBJECT;
>
> -drop table PARENT_BINDING;
> +drop table @TABLE_PREFIX@PARENT_BINDING;
>
> -drop table PERMISSIONS;
> +drop table @TABLE_PREFIX@PERMISSIONS;
>
> -drop table PROPERTIES;
> +drop table @TABLE_PREFIX@PROPERTIES;
>
> -drop table URI;
> +drop table @TABLE_PREFIX@URI;
>
> -drop table VERSION;
> +drop table @TABLE_PREFIX@VERSION;
>
> -drop table VERSION_CONTENT;
> +drop table @TABLE_PREFIX@VERSION_CONTENT;
>
> -drop table VERSION_HISTORY;
> +drop table @TABLE_PREFIX@VERSION_HISTORY;
>
> -drop table VERSION_LABELS;
> +drop table @TABLE_PREFIX@VERSION_LABELS;
>
> -drop table VERSION_PREDS;
> +drop table @TABLE_PREFIX@VERSION_PREDS;
>
>
> --==============================================================
> -- Table: BINDING
> --==============================================================
> -create table BINDING
> +create table @TABLE_PREFIX@BINDING
> (
> URI_ID NUMERIC(10) not null,
> "NAME" VARCHAR(512) not null,
> @@ -49,7 +49,7 @@
> --==============================================================
> -- Table: BRANCH
> --==============================================================
> -create table BRANCH
> +create table @TABLE_PREFIX@BRANCH
> (
> BRANCH_ID NUMERIC(10) not null,
> BRANCH_STRING VARCHAR(512) not null,
> @@ -60,7 +60,7 @@
> --==============================================================
> -- Table: "LABEL"
> --==============================================================
> -create table "LABEL"
> +create table "@TABLE_PREFIX@LABEL"
> (
> LABEL_ID NUMERIC(10) not null,
> LABEL_STRING VARCHAR(512) not null,
> @@ -70,7 +70,7 @@
> --==============================================================
> -- Table: LINKS
> --==============================================================
> -create table LINKS
> +create table @TABLE_PREFIX@LINKS
> (
> URI_ID NUMERIC(10) not null,
> LINK_TO_ID NUMERIC(10) not null,
> @@ -80,7 +80,7 @@
> --==============================================================
> -- Table: LOCKS
> --==============================================================
> -create table LOCKS
> +create table @TABLE_PREFIX@LOCKS
> (
> LOCK_ID NUMERIC(10) not null,
> OBJECT_ID NUMERIC(10) not null,
> @@ -96,7 +96,7 @@
> --==============================================================
> -- Table: OBJECT
> --==============================================================
> -create table OBJECT
> +create table @TABLE_PREFIX@OBJECT
> (
> URI_ID NUMERIC(10) not null,
> CLASS_NAME VARCHAR(255) not null,
> @@ -106,7 +106,7 @@
> --==============================================================
> -- Table: PARENT_BINDING
> --==============================================================
> -create table PARENT_BINDING
> +create table @TABLE_PREFIX@PARENT_BINDING
> (
> URI_ID NUMERIC(10) not null,
> "NAME" VARCHAR(512) not null,
> @@ -117,7 +117,7 @@
> --==============================================================
> -- Table: PERMISSIONS
> --==============================================================
> -create table PERMISSIONS
> +create table @TABLE_PREFIX@PERMISSIONS
> (
> OBJECT_ID NUMERIC(10) not null,
> SUBJECT_ID NUMERIC(10) not null,
> @@ -133,7 +133,7 @@
> --==============================================================
> -- Table: PROPERTIES
> --==============================================================
> -create table PROPERTIES
> +create table @TABLE_PREFIX@PROPERTIES
> (
> VERSION_ID NUMERIC(10) not null,
> PROPERTY_NAMESPACE VARCHAR(50) not null,
> @@ -147,7 +147,7 @@
> --==============================================================
> -- Table: URI
> --==============================================================
> -create table URI
> +create table @TABLE_PREFIX@URI
> (
> URI_ID NUMERIC(10) not null,
> URI_STRING VARCHAR(250) not null,
> @@ -158,7 +158,7 @@
> --==============================================================
> -- Table: VERSION
> --==============================================================
> -create table VERSION
> +create table @TABLE_PREFIX@VERSION
> (
> URI_ID NUMERIC(10) not null,
> IS_VERSIONED NUMERIC(1) not null,
> @@ -168,7 +168,7 @@
> --==============================================================
> -- Table: VERSION_CONTENT
> --==============================================================
> -create table VERSION_CONTENT
> +create table @TABLE_PREFIX@VERSION_CONTENT
> (
> VERSION_ID NUMERIC(10) not null,
> CONTENT blob(1000m),
> @@ -178,7 +178,7 @@
> --==============================================================
> -- Table: VERSION_HISTORY
> --==============================================================
> -create table VERSION_HISTORY
> +create table @TABLE_PREFIX@VERSION_HISTORY
> (
> VERSION_ID NUMERIC(10) not null,
> URI_ID NUMERIC(10) not null,
> @@ -191,7 +191,7 @@
> --==============================================================
> -- Table: VERSION_LABELS
> --==============================================================
> -create table VERSION_LABELS
> +create table @TABLE_PREFIX@VERSION_LABELS
> (
> VERSION_ID NUMERIC(10) not null,
> LABEL_ID NUMERIC(10) not null,
> @@ -201,135 +201,135 @@
> --==============================================================
> -- Table: VERSION_PREDS
> --==============================================================
> -create table VERSION_PREDS
> +create table @TABLE_PREFIX@VERSION_PREDS
> (
> VERSION_ID NUMERIC(10) not null,
> PREDECESSOR_ID NUMERIC(10) not null,
> constraint "A_Key_1" unique (VERSION_ID, PREDECESSOR_ID)
> );
>
> -CREATE TRIGGER URI_TRG NO CASCADE BEFORE INSERT ON URI referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.URI_ID = COALESCE((SELECT MAX(URI_ID) FROM URI) + 1, 1);
> +CREATE TRIGGER @TABLE_PREFIX@URI_TRG NO CASCADE BEFORE INSERT ON @TABLE_PREFIX@URI referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.URI_ID = COALESCE((SELECT MAX(URI_ID) FROM @TABLE_PREFIX@URI) + 1, 1);
>
> -CREATE TRIGGER BRANCH_TRG NO CASCADE BEFORE INSERT ON BRANCH referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.BRANCH_ID = COALESCE((SELECT MAX(BRANCH_ID) FROM BRANCH) + 1, 1);
> +CREATE TRIGGER @TABLE_PREFIX@BRANCH_TRG NO CASCADE BEFORE INSERT ON @TABLE_PREFIX@BRANCH referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.BRANCH_ID = COALESCE((SELECT MAX(BRANCH_ID) FROM @TABLE_PREFIX@BRANCH) + 1, 1);
>
> -CREATE TRIGGER LABEL_TRG NO CASCADE BEFORE INSERT ON LABEL referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.LABEL_ID = COALESCE((SELECT MAX(LABEL_ID) FROM LABEL) + 1, 1);
> +CREATE TRIGGER @TABLE_PREFIX@LABEL_TRG NO CASCADE BEFORE INSERT ON @TABLE_PREFIX@LABEL referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.LABEL_ID = COALESCE((SELECT MAX(LABEL_ID) FROM @TABLE_PREFIX@LABEL) + 1, 1);
>
> -CREATE TRIGGER VERSION_HIST_TRG NO CASCADE BEFORE INSERT ON VERSION_HISTORY referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.VERSION_ID = COALESCE((SELECT MAX(VERSION_ID) FROM VERSION_HISTORY) + 1, 1);
> +CREATE TRIGGER @TABLE_PREFIX@VERSION_HIST_TRG NO CASCADE BEFORE INSERT ON @TABLE_PREFIX@VERSION_HISTORY referencing NEW AS newrow FOR EACH ROW MODE DB2SQL SET newrow.VERSION_ID = COALESCE((SELECT MAX(VERSION_ID) FROM @TABLE_PREFIX@VERSION_HISTORY) + 1, 1);
>
>
> -alter table BINDING
> +alter table @TABLE_PREFIX@BINDING
> add constraint "F_Reference_2" foreign key (URI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table BINDING
> +alter table @TABLE_PREFIX@BINDING
> add constraint "F_Reference_3" foreign key (CHILD_UURI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table LINKS
> +alter table @TABLE_PREFIX@LINKS
> add constraint "F_Reference_6" foreign key (URI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table LINKS
> +alter table @TABLE_PREFIX@LINKS
> add constraint "F_Reference_7" foreign key (LINK_TO_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table LOCKS
> +alter table @TABLE_PREFIX@LOCKS
> add constraint "F_Reference_10" foreign key (SUBJECT_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table LOCKS
> +alter table @TABLE_PREFIX@LOCKS
> add constraint "F_Reference_11" foreign key (TYPE_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table LOCKS
> +alter table @TABLE_PREFIX@LOCKS
> add constraint "F_Reference_8" foreign key (LOCK_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table LOCKS
> +alter table @TABLE_PREFIX@LOCKS
> add constraint "F_Reference_9" foreign key (OBJECT_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table OBJECT
> +alter table @TABLE_PREFIX@OBJECT
> add constraint "F_Reference_1" foreign key (URI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table PARENT_BINDING
> +alter table @TABLE_PREFIX@PARENT_BINDING
> add constraint "F_Reference_4" foreign key (URI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table PARENT_BINDING
> +alter table @TABLE_PREFIX@PARENT_BINDING
> add constraint "F_Reference_5" foreign key (PARENT_UURI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table PERMISSIONS
> +alter table @TABLE_PREFIX@PERMISSIONS
> add constraint "F_Reference_21" foreign key (OBJECT_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table PERMISSIONS
> +alter table @TABLE_PREFIX@PERMISSIONS
> add constraint "F_Reference_22" foreign key (SUBJECT_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table PERMISSIONS
> +alter table @TABLE_PREFIX@PERMISSIONS
> add constraint "F_Reference_23" foreign key (ACTION_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table PROPERTIES
> +alter table @TABLE_PREFIX@PROPERTIES
> add constraint "F_Reference_20" foreign key (VERSION_ID)
> - references VERSION_HISTORY (VERSION_ID)
> + references @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION
> +alter table @TABLE_PREFIX@VERSION
> add constraint "F_Reference_12" foreign key (URI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION_CONTENT
> +alter table @TABLE_PREFIX@VERSION_CONTENT
> add constraint "F_Reference_19" foreign key (VERSION_ID)
> - references VERSION_HISTORY (VERSION_ID)
> + references @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION_HISTORY
> +alter table @TABLE_PREFIX@VERSION_HISTORY
> add constraint "F_Reference_13" foreign key (URI_ID)
> - references URI (URI_ID)
> + references @TABLE_PREFIX@URI (URI_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION_HISTORY
> +alter table @TABLE_PREFIX@VERSION_HISTORY
> add constraint "F_Reference_14" foreign key (BRANCH_ID)
> - references BRANCH (BRANCH_ID)
> + references @TABLE_PREFIX@BRANCH (BRANCH_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION_LABELS
> +alter table @TABLE_PREFIX@VERSION_LABELS
> add constraint "F_Reference_17" foreign key (VERSION_ID)
> - references VERSION_HISTORY (VERSION_ID)
> + references @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION_LABELS
> +alter table @TABLE_PREFIX@VERSION_LABELS
> add constraint "F_Reference_18" foreign key (LABEL_ID)
> - references "LABEL" (LABEL_ID)
> + references "@TABLE_PREFIX@LABEL" (LABEL_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION_PREDS
> +alter table @TABLE_PREFIX@VERSION_PREDS
> add constraint "F_Reference_15" foreign key (VERSION_ID)
> - references VERSION_HISTORY (VERSION_ID)
> + references @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID)
> on delete restrict on update restrict;
>
> -alter table VERSION_PREDS
> +alter table @TABLE_PREFIX@VERSION_PREDS
> add constraint "F_Reference_16" foreign key (PREDECESSOR_ID)
> - references VERSION_HISTORY (VERSION_ID)
> + references @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID)
> on delete restrict on update restrict;
>
>
> Index: src/conf/schema/MySql-4.1-Schema.sql
> ===================================================================
> RCS file: /home/cvspublic/jakarta-slide/src/conf/schema/MySql-4.1-Schema.sql,v
> retrieving revision 1.2
> diff -u -w -r1.2 MySql-4.1-Schema.sql
> --- src/conf/schema/MySql-4.1-Schema.sql 25 May 2004 12:40:23 -0000 1.2
> +++ src/conf/schema/MySql-4.1-Schema.sql 3 Dec 2004 16:32:06 -0000
> @@ -1,25 +1,25 @@
> # --------------------------------------------------------
>
> -drop table if exists OBJECT;
> -drop table if exists CHILDREN;
> -drop table if exists BINDING;
> -drop table if exists PARENT_BINDING;
> -drop table if exists LINKS;
> -drop table if exists LOCKS;
> -drop table if exists VERSION_CONTENT;
> -drop table if exists PROPERTIES;
> -drop table if exists PERMISSIONS;
> -drop table if exists VERSION_PREDS;
> -drop table if exists VERSION_LABELS;
> -drop table if exists VERSION_HISTORY;
> -drop table if exists VERSION;
> -drop table if exists BRANCH;
> -drop table if exists LABEL;
> -drop table if exists URI;
> +drop table if exists @TABLE_PREFIX@OBJECT;
> +drop table if exists @TABLE_PREFIX@CHILDREN;
> +drop table if exists @TABLE_PREFIX@BINDING;
> +drop table if exists @TABLE_PREFIX@PARENT_BINDING;
> +drop table if exists @TABLE_PREFIX@LINKS;
> +drop table if exists @TABLE_PREFIX@LOCKS;
> +drop table if exists @TABLE_PREFIX@VERSION_CONTENT;
> +drop table if exists @TABLE_PREFIX@PROPERTIES;
> +drop table if exists @TABLE_PREFIX@PERMISSIONS;
> +drop table if exists @TABLE_PREFIX@VERSION_PREDS;
> +drop table if exists @TABLE_PREFIX@VERSION_LABELS;
> +drop table if exists @TABLE_PREFIX@VERSION_HISTORY;
> +drop table if exists @TABLE_PREFIX@VERSION;
> +drop table if exists @TABLE_PREFIX@BRANCH;
> +drop table if exists @TABLE_PREFIX@LABEL;
> +drop table if exists @TABLE_PREFIX@URI;
>
> # --------------------------------------------------------
>
> -CREATE TABLE URI (
> +CREATE TABLE @TABLE_PREFIX@URI (
> URI_ID bigint NOT NULL auto_increment,
> URI_STRING varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> PRIMARY KEY (URI_ID),
> @@ -28,18 +28,19 @@
>
> # --------------------------------------------------------
>
> -CREATE TABLE OBJECT (
> +CREATE TABLE @TABLE_PREFIX@OBJECT (
> URI_ID bigint NOT NULL,
> CLASS_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> PRIMARY KEY (URI_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE OBJECT ADD CONSTRAINT OBJECT_FK1 FOREIGN KEY OBJECT_FK1(URI_ID)
> -REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@OBJECT ADD CONSTRAINT @TABLE_PREFIX@OBJECT_FK1 FOREIGN KEY
> +@TABLE_PREFIX@OBJECT_FK1(URI_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE BINDING (
> +CREATE TABLE @TABLE_PREFIX@BINDING (
> URI_ID bigint NOT NULL,
> NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> CHILD_UURI_ID bigint NOT NULL,
> @@ -47,12 +48,12 @@
> KEY BINDING_IX (CHILD_UURI_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK1 FOREIGN KEY
> -BINDING_FK1(URI_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK2 FOREIGN KEY
> -BINDING_FK2(CHILD_UURI_ID) REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@BINDING ADD CONSTRAINT @TABLE_PREFIX@BINDING_FK1 FOREIGN KEY
> +@TABLE_PREFIX@BINDING_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@BINDING ADD CONSTRAINT @TABLE_PREFIX@BINDING_FK2 FOREIGN KEY
> +@TABLE_PREFIX@BINDING_FK2(CHILD_UURI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> -CREATE TABLE PARENT_BINDING (
> +CREATE TABLE @TABLE_PREFIX@PARENT_BINDING (
> URI_ID bigint NOT NULL,
> NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> PARENT_UURI_ID bigint NOT NULL,
> @@ -60,28 +61,30 @@
> KEY PARENT_BINDING_IX (PARENT_UURI_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK1 FOREIGN KEY
> -PARENT_BINDING_FK1(URI_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK2 FOREIGN KEY
> -PARENT_BINDING_FK2(PARENT_UURI_ID) REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PARENT_BINDING ADD CONSTRAINT @TABLE_PREFIX@PARENT_BINDING_FK1 FOREIGN KEY
> +@TABLE_PREFIX@PARENT_BINDING_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PARENT_BINDING ADD CONSTRAINT @TABLE_PREFIX@PARENT_BINDING_FK2 FOREIGN KEY
> +@TABLE_PREFIX@PARENT_BINDING_FK2(PARENT_UURI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE LINKS (
> +CREATE TABLE @TABLE_PREFIX@LINKS (
> URI_ID bigint NOT NULL,
> LINK_TO_ID bigint NOT NULL,
> PRIMARY KEY (URI_ID,LINK_TO_ID),
> key LINK_IX2 (LINK_TO_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE LINKS ADD CONSTRAINT LINK_FK1 FOREIGN KEY LINK_FK1(URI_ID)
> -REFERENCES URI (URI_ID);
> -ALTER TABLE LINKS ADD CONSTRAINT LINK_FK2 FOREIGN KEY LINK_FK2(LINK_TO_ID)
> -REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LINKS ADD CONSTRAINT @TABLE_PREFIX@LINK_FK1 FOREIGN
> +KEY @TABLE_PREFIX@LINK_FK1(URI_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LINKS ADD CONSTRAINT @TABLE_PREFIX@LINK_FK2 FOREIGN
> +KEY @TABLE_PREFIX@LINK_FK2(LINK_TO_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE LOCKS (
> +CREATE TABLE @TABLE_PREFIX@LOCKS (
> LOCK_ID bigint NOT NULL,
> OBJECT_ID bigint NOT NULL,
> SUBJECT_ID bigint NOT NULL,
> @@ -96,18 +99,22 @@
> KEY LOCK_IX4 (TYPE_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK1 FOREIGN KEY LOCK_FK1(LOCK_ID)
> -REFERENCES URI (URI_ID);
> -ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK2 FOREIGN KEY LOCK_FK2(OBJECT_ID)
> -REFERENCES URI (URI_ID);
> -ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK3 FOREIGN KEY LOCK_FK3(SUBJECT_ID)
> -REFERENCES URI (URI_ID);
> -ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK4 FOREIGN KEY LOCK_FK4(TYPE_ID)
> -REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LOCKS ADD CONSTRAINT @TABLE_PREFIX@LOCK_FK1 FOREIGN
> +KEY @TABLE_PREFIX@LOCK_FK1(LOCK_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LOCKS ADD CONSTRAINT @TABLE_PREFIX@LOCK_FK2 FOREIGN
> +KEY @TABLE_PREFIX@LOCK_FK2(OBJECT_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LOCKS ADD CONSTRAINT @TABLE_PREFIX@LOCK_FK3 FOREIGN
> +KEY @TABLE_PREFIX@LOCK_FK3(SUBJECT_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LOCKS ADD CONSTRAINT @TABLE_PREFIX@LOCK_FK4 FOREIGN
> +KEY @TABLE_PREFIX@LOCK_FK4(TYPE_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE BRANCH (
> +CREATE TABLE @TABLE_PREFIX@BRANCH (
> BRANCH_ID bigint NOT NULL auto_increment,
> BRANCH_STRING varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> PRIMARY KEY (BRANCH_ID)
> @@ -115,7 +122,7 @@
>
> # --------------------------------------------------------
>
> -CREATE TABLE LABEL (
> +CREATE TABLE @TABLE_PREFIX@LABEL (
> LABEL_ID bigint NOT NULL auto_increment,
> LABEL_STRING varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> PRIMARY KEY (LABEL_ID)
> @@ -123,18 +130,18 @@
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION (
> +CREATE TABLE @TABLE_PREFIX@VERSION (
> URI_ID bigint NOT NULL,
> IS_VERSIONED tinyint(1) NOT NULL,
> PRIMARY KEY (URI_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY
> -VERSION_FK1(URI_ID) REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_HISTORY (
> +CREATE TABLE @TABLE_PREFIX@VERSION_HISTORY (
> VERSION_ID bigint NOT NULL auto_increment,
> URI_ID bigint NOT NULL,
> BRANCH_ID bigint NOT NULL,
> @@ -144,53 +151,53 @@
> KEY URI_ID_IX3 (URI_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK1 FOREIGN KEY
> -VERSION_HISTORY_FK1(URI_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK2 FOREIGN KEY
> -VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES BRANCH (BRANCH_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_HISTORY ADD CONSTRAINT @TABLE_PREFIX@VERSION_HISTORY_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_HISTORY_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_HISTORY ADD CONSTRAINT @TABLE_PREFIX@VERSION_HISTORY_FK2 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES @TABLE_PREFIX@BRANCH (BRANCH_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_PREDS (
> +CREATE TABLE @TABLE_PREFIX@VERSION_PREDS (
> VERSION_ID bigint NOT NULL,
> PREDECESSOR_ID bigint NOT NULL,
> PRIMARY KEY (VERSION_ID,PREDECESSOR_ID),
> KEY PREDECESSOR_ID_IX2 (PREDECESSOR_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY
> -VERSION_PREDS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> -ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY
> -VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_PREDS_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_LABELS (
> +CREATE TABLE @TABLE_PREFIX@VERSION_LABELS (
> VERSION_ID bigint NOT NULL,
> LABEL_ID bigint NOT NULL,
> PRIMARY KEY (VERSION_ID,LABEL_ID),
> KEY LABEL_ID_IX2 (LABEL_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY
> -VERSION_LABELS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> -ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY
> -VERSION_LABELS_FK2(LABEL_ID) REFERENCES LABEL (LABEL_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_LABELS_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_LABELS_FK2(LABEL_ID) REFERENCES @TABLE_PREFIX@LABEL (LABEL_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_CONTENT (
> +CREATE TABLE @TABLE_PREFIX@VERSION_CONTENT (
> VERSION_ID bigint NOT NULL,
> CONTENT longblob NOT NULL,
> PRIMARY KEY (VERSION_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY
> -VERSION_CONTENT_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_CONTENT_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE PROPERTIES (
> +CREATE TABLE @TABLE_PREFIX@PROPERTIES (
> VERSION_ID bigint NOT NULL,
> PROPERTY_NAMESPACE varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> PROPERTY_NAME varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
> @@ -200,12 +207,12 @@
> PRIMARY KEY (VERSION_ID,PROPERTY_NAMESPACE,PROPERTY_NAME)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE PROPERTIES ADD CONSTRAINT PROPERTIES_FK1 FOREIGN KEY
> -PROPERTIES_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@PROPERTIES ADD CONSTRAINT @TABLE_PREFIX@PROPERTIES_FK1 FOREIGN KEY
> +@TABLE_PREFIX@PROPERTIES_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE PERMISSIONS (
> +CREATE TABLE @TABLE_PREFIX@PERMISSIONS (
> OBJECT_ID bigint NOT NULL,
> SUBJECT_ID bigint NOT NULL,
> ACTION_ID bigint NOT NULL,
> @@ -218,9 +225,9 @@
> KEY ACTION_ID_IX3 (ACTION_ID)
> ) TYPE=InnoDB CHARACTER SET utf8;
>
> -ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK1 FOREIGN KEY
> -PERMISSIONS_FK1(OBJECT_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK2 FOREIGN KEY
> -PERMISSIONS_FK2(SUBJECT_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK3 FOREIGN KEY
> -PERMISSIONS_FK3(ACTION_ID) REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PERMISSIONS ADD CONSTRAINT @TABLE_PREFIX@PERMISSIONS_FK1 FOREIGN KEY
> +@TABLE_PREFIX@PERMISSIONS_FK1(OBJECT_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PERMISSIONS ADD CONSTRAINT @TABLE_PREFIX@PERMISSIONS_FK2 FOREIGN KEY
> +@TABLE_PREFIX@PERMISSIONS_FK2(SUBJECT_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PERMISSIONS ADD CONSTRAINT @TABLE_PREFIX@PERMISSIONS_FK3 FOREIGN KEY
> +@TABLE_PREFIX@PERMISSIONS_FK3(ACTION_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> Index: src/conf/schema/MySqlSchema.sql
> ===================================================================
> RCS file: /home/cvspublic/jakarta-slide/src/conf/schema/MySqlSchema.sql,v
> retrieving revision 1.2
> diff -u -w -r1.2 MySqlSchema.sql
> --- src/conf/schema/MySqlSchema.sql 25 May 2004 09:52:34 -0000 1.2
> +++ src/conf/schema/MySqlSchema.sql 3 Dec 2004 16:32:06 -0000
> @@ -1,25 +1,25 @@
> # --------------------------------------------------------
>
> -drop table if exists OBJECT;
> -drop table if exists CHILDREN;
> -drop table if exists BINDING;
> -drop table if exists PARENT_BINDING;
> -drop table if exists LINKS;
> -drop table if exists LOCKS;
> -drop table if exists VERSION_CONTENT;
> -drop table if exists PROPERTIES;
> -drop table if exists PERMISSIONS;
> -drop table if exists VERSION_PREDS;
> -drop table if exists VERSION_LABELS;
> -drop table if exists VERSION_HISTORY;
> -drop table if exists VERSION;
> -drop table if exists BRANCH;
> -drop table if exists LABEL;
> -drop table if exists URI;
> +drop table if exists @TABLE_PREFIX@OBJECT;
> +drop table if exists @TABLE_PREFIX@CHILDREN;
> +drop table if exists @TABLE_PREFIX@BINDING;
> +drop table if exists @TABLE_PREFIX@PARENT_BINDING;
> +drop table if exists @TABLE_PREFIX@LINKS;
> +drop table if exists @TABLE_PREFIX@LOCKS;
> +drop table if exists @TABLE_PREFIX@VERSION_CONTENT;
> +drop table if exists @TABLE_PREFIX@PROPERTIES;
> +drop table if exists @TABLE_PREFIX@PERMISSIONS;
> +drop table if exists @TABLE_PREFIX@VERSION_PREDS;
> +drop table if exists @TABLE_PREFIX@VERSION_LABELS;
> +drop table if exists @TABLE_PREFIX@VERSION_HISTORY;
> +drop table if exists @TABLE_PREFIX@VERSION;
> +drop table if exists @TABLE_PREFIX@BRANCH;
> +drop table if exists @TABLE_PREFIX@LABEL;
> +drop table if exists @TABLE_PREFIX@URI;
>
> # --------------------------------------------------------
>
> -CREATE TABLE URI (
> +CREATE TABLE @TABLE_PREFIX@URI (
> URI_ID bigint NOT NULL auto_increment,
> URI_STRING varchar(255) NOT NULL,
> PRIMARY KEY (URI_ID),
> @@ -28,18 +28,19 @@
>
> # --------------------------------------------------------
>
> -CREATE TABLE OBJECT (
> +CREATE TABLE @TABLE_PREFIX@OBJECT (
> URI_ID bigint NOT NULL,
> CLASS_NAME varchar(255) NOT NULL,
> PRIMARY KEY (URI_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE OBJECT ADD CONSTRAINT OBJECT_FK1 FOREIGN KEY OBJECT_FK1(URI_ID)
> -REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@OBJECT ADD CONSTRAINT @TABLE_PREFIX@OBJECT_FK1 FOREIGN
> +KEY @TABLE_PREFIX@OBJECT_FK1(URI_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE BINDING (
> +CREATE TABLE @TABLE_PREFIX@BINDING (
> URI_ID bigint NOT NULL,
> NAME varchar(255) NOT NULL,
> CHILD_UURI_ID bigint NOT NULL,
> @@ -47,12 +48,12 @@
> KEY BINDING_IX (CHILD_UURI_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK1 FOREIGN KEY
> -BINDING_FK1(URI_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK2 FOREIGN KEY
> -BINDING_FK2(CHILD_UURI_ID) REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@BINDING ADD CONSTRAINT @TABLE_PREFIX@BINDING_FK1 FOREIGN KEY
> +@TABLE_PREFIX@BINDING_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@BINDING ADD CONSTRAINT @TABLE_PREFIX@BINDING_FK2 FOREIGN KEY
> +@TABLE_PREFIX@BINDING_FK2(CHILD_UURI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> -CREATE TABLE PARENT_BINDING (
> +CREATE TABLE @TABLE_PREFIX@PARENT_BINDING (
> URI_ID bigint NOT NULL,
> NAME varchar(255) NOT NULL,
> PARENT_UURI_ID bigint NOT NULL,
> @@ -60,28 +61,30 @@
> KEY PARENT_BINDING_IX (PARENT_UURI_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK1 FOREIGN KEY
> -PARENT_BINDING_FK1(URI_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK2 FOREIGN KEY
> -PARENT_BINDING_FK2(PARENT_UURI_ID) REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PARENT_BINDING ADD CONSTRAINT @TABLE_PREFIX@PARENT_BINDING_FK1 FOREIGN KEY
> +@TABLE_PREFIX@PARENT_BINDING_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PARENT_BINDING ADD CONSTRAINT @TABLE_PREFIX@PARENT_BINDING_FK2 FOREIGN KEY
> +@TABLE_PREFIX@PARENT_BINDING_FK2(PARENT_UURI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE LINKS (
> +CREATE TABLE @TABLE_PREFIX@LINKS (
> URI_ID bigint NOT NULL,
> LINK_TO_ID bigint NOT NULL,
> PRIMARY KEY (URI_ID,LINK_TO_ID),
> key LINK_IX2 (LINK_TO_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE LINKS ADD CONSTRAINT LINK_FK1 FOREIGN KEY LINK_FK1(URI_ID)
> -REFERENCES URI (URI_ID);
> -ALTER TABLE LINKS ADD CONSTRAINT LINK_FK2 FOREIGN KEY LINK_FK2(LINK_TO_ID)
> -REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LINKS ADD CONSTRAINT @TABLE_PREFIX@LINK_FK1 FOREIGN
> +KEY @TABLE_PREFIX@LINK_FK1(URI_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LINKS ADD CONSTRAINT @TABLE_PREFIX@LINK_FK2 FOREIGN
> +KEY @TABLE_PREFIX@LINK_FK2(LINK_TO_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE LOCKS (
> +CREATE TABLE @TABLE_PREFIX@LOCKS (
> LOCK_ID bigint NOT NULL,
> OBJECT_ID bigint NOT NULL,
> SUBJECT_ID bigint NOT NULL,
> @@ -96,18 +99,21 @@
> KEY LOCK_IX4 (TYPE_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK1 FOREIGN KEY LOCK_FK1(LOCK_ID)
> -REFERENCES URI (URI_ID);
> -ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK2 FOREIGN KEY LOCK_FK2(OBJECT_ID)
> -REFERENCES URI (URI_ID);
> -ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK3 FOREIGN KEY LOCK_FK3(SUBJECT_ID)
> -REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LOCKS ADD CONSTRAINT @TABLE_PREFIX@LOCK_FK1 FOREIGN
> +KEY @TABLE_PREFIX@LOCK_FK1(LOCK_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LOCKS ADD CONSTRAINT @TABLE_PREFIX@LOCK_FK2 FOREIGN
> +KEY @TABLE_PREFIX@LOCK_FK2(OBJECT_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@LOCKS ADD CONSTRAINT @TABLE_PREFIX@LOCK_FK3 FOREIGN
> +KEY @TABLE_PREFIX@LOCK_FK3(SUBJECT_ID)
> +REFERENCES @TABLE_PREFIX@URI (URI_ID);
> ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK4 FOREIGN KEY LOCK_FK4(TYPE_ID)
> REFERENCES URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE BRANCH (
> +CREATE TABLE @TABLE_PREFIX@BRANCH (
> BRANCH_ID bigint NOT NULL auto_increment,
> BRANCH_STRING varchar(255) NOT NULL,
> PRIMARY KEY (BRANCH_ID)
> @@ -115,7 +121,7 @@
>
> # --------------------------------------------------------
>
> -CREATE TABLE LABEL (
> +CREATE TABLE @TABLE_PREFIX@LABEL (
> LABEL_ID bigint NOT NULL auto_increment,
> LABEL_STRING varchar(255) NOT NULL,
> PRIMARY KEY (LABEL_ID)
> @@ -123,18 +129,18 @@
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION (
> +CREATE TABLE @TABLE_PREFIX@VERSION (
> URI_ID bigint NOT NULL,
> IS_VERSIONED tinyint(1) NOT NULL,
> PRIMARY KEY (URI_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY
> -VERSION_FK1(URI_ID) REFERENCES URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_HISTORY (
> +CREATE TABLE @TABLE_PREFIX@VERSION_HISTORY (
> VERSION_ID bigint NOT NULL auto_increment,
> URI_ID bigint NOT NULL,
> BRANCH_ID bigint NOT NULL,
> @@ -144,53 +150,53 @@
> KEY URI_ID_IX3 (URI_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK1 FOREIGN KEY
> -VERSION_HISTORY_FK1(URI_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK2 FOREIGN KEY
> -VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES BRANCH (BRANCH_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_HISTORY ADD CONSTRAINT @TABLE_PREFIX@VERSION_HISTORY_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_HISTORY_FK1(URI_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_HISTORY ADD CONSTRAINT @TABLE_PREFIX@VERSION_HISTORY_FK2 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES @TABLE_PREFIX@BRANCH (BRANCH_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_PREDS (
> +CREATE TABLE @TABLE_PREFIX@VERSION_PREDS (
> VERSION_ID bigint NOT NULL,
> PREDECESSOR_ID bigint NOT NULL,
> PRIMARY KEY (VERSION_ID,PREDECESSOR_ID),
> KEY PREDECESSOR_ID_IX2 (PREDECESSOR_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY
> -VERSION_PREDS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> -ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY
> -VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_PREDS_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_LABELS (
> +CREATE TABLE @TABLE_PREFIX@VERSION_LABELS (
> VERSION_ID bigint NOT NULL,
> LABEL_ID bigint NOT NULL,
> PRIMARY KEY (VERSION_ID,LABEL_ID),
> KEY LABEL_ID_IX2 (LABEL_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY
> -VERSION_LABELS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> -ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY
> -VERSION_LABELS_FK2(LABEL_ID) REFERENCES LABEL (LABEL_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_LABELS_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_LABELS_FK2(LABEL_ID) REFERENCES @TABLE_PREFIX@LABEL (LABEL_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE VERSION_CONTENT (
> +CREATE TABLE @TABLE_PREFIX@VERSION_CONTENT (
> VERSION_ID bigint NOT NULL,
> CONTENT longblob NOT NULL,
> PRIMARY KEY (VERSION_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY
> -VERSION_CONTENT_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY
> +@TABLE_PREFIX@VERSION_CONTENT_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE PROPERTIES (
> +CREATE TABLE @TABLE_PREFIX@PROPERTIES (
> VERSION_ID bigint NOT NULL,
> PROPERTY_NAMESPACE varchar(50) NOT NULL,
> PROPERTY_NAME varchar(50) NOT NULL,
> @@ -200,12 +206,12 @@
> PRIMARY KEY (VERSION_ID,PROPERTY_NAMESPACE,PROPERTY_NAME)
> ) TYPE=InnoDB;
>
> -ALTER TABLE PROPERTIES ADD CONSTRAINT PROPERTIES_FK1 FOREIGN KEY
> -PROPERTIES_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID);
> +ALTER TABLE @TABLE_PREFIX@PROPERTIES ADD CONSTRAINT @TABLE_PREFIX@PROPERTIES_FK1 FOREIGN KEY
> +@TABLE_PREFIX@PROPERTIES_FK1(VERSION_ID) REFERENCES @TABLE_PREFIX@VERSION_HISTORY (VERSION_ID);
>
> # --------------------------------------------------------
>
> -CREATE TABLE PERMISSIONS (
> +CREATE TABLE @TABLE_PREFIX@PERMISSIONS (
> OBJECT_ID bigint NOT NULL,
> SUBJECT_ID bigint NOT NULL,
> ACTION_ID bigint NOT NULL,
> @@ -218,9 +224,9 @@
> KEY ACTION_ID_IX3 (ACTION_ID)
> ) TYPE=InnoDB;
>
> -ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK1 FOREIGN KEY
> -PERMISSIONS_FK1(OBJECT_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK2 FOREIGN KEY
> -PERMISSIONS_FK2(SUBJECT_ID) REFERENCES URI (URI_ID);
> -ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK3 FOREIGN KEY
> -PERMISSIONS_FK3(ACTION_ID) REFERENCES URI (URI_ID);
> \ No newline at end of file
> +ALTER TABLE @TABLE_PREFIX@PERMISSIONS ADD CONSTRAINT @TABLE_PREFIX@PERMISSIONS_FK1 FOREIGN KEY
> +@TABLE_PREFIX@PERMISSIONS_FK1(OBJECT_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PERMISSIONS ADD CONSTRAINT @TABLE_PREFIX@PERMISSIONS_FK2 FOREIGN KEY
> +@TABLE_PREFIX@PERMISSIONS_FK2(SUBJECT_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> +ALTER TABLE @TABLE_PREFIX@PERMISSIONS ADD CONSTRAINT @TABLE_PREFIX@PERMISSIONS_FK3 FOREIGN KEY
> +@TABLE_PREFIX@PERMISSIONS_FK3(ACTION_ID) REFERENCES @TABLE_PREFIX@URI (URI_ID);
> Index: src/conf/schema/OracleSchema.sql
> ===================================================================
> RCS file: /home/cvspublic/jakarta-slide/src/conf/schema/OracleSchema.sql,v
> retrieving revision 1.2
> diff -u -w -r1.2 OracleSchema.sql
> --- src/conf/schema/OracleSchema.sql 13 Nov 2004 15:02:28 -0000 1.2
> +++ src/conf/schema/OracleSchema.sql 3 Dec 2004 16:32:06 -0000
> @@ -1,78 +1,78 @@
>
> ALTER SESSION SET SQL_TRACE = TRUE;
>
> -DROP TRIGGER "URI-URI_ID-TRG";
> -DROP TRIGGER "BRANCH-BRANCH_ID-TRG";
> -DROP TRIGGER "LABEL-LABEL_ID-TRG";
> -DROP TRIGGER "VERSION_HISTORY-VERSION_ID-TRG";
> -
> -DROP SEQUENCE "URI-URI_ID-SEQ";
> -DROP SEQUENCE "BRANCH-BRANCH_ID-SEQ";
> -DROP SEQUENCE "LABEL-LABEL_ID-SEQ";
> -DROP SEQUENCE "VERSION_HISTORY-VERSION_ID-SEQ";
> -
> -DROP TABLE "URI" CASCADE CONSTRAINTS;
> -DROP TABLE "OBJECT" CASCADE CONSTRAINTS;
> -DROP TABLE "BINDING" CASCADE CONSTRAINTS;
> -DROP TABLE "PARENT_BINDING" CASCADE CONSTRAINTS;
> -DROP TABLE "LINKS" CASCADE CONSTRAINTS;
> -DROP TABLE "LOCKS" CASCADE CONSTRAINTS;
> -DROP TABLE "BRANCH" CASCADE CONSTRAINTS;
> -DROP TABLE "LABEL" CASCADE CONSTRAINTS;
> -DROP TABLE "VERSION" CASCADE CONSTRAINTS;
> -DROP TABLE "VERSION_HISTORY" CASCADE CONSTRAINTS;
> -DROP TABLE "VERSION_PREDS" CASCADE CONSTRAINTS;
> -DROP TABLE "VERSION_LABELS" CASCADE CONSTRAINTS;
> -DROP TABLE "VERSION_CONTENT" CASCADE CONSTRAINTS;
> -DROP TABLE "PROPERTIES" CASCADE CONSTRAINTS;
> -DROP TABLE "PERMISSIONS" CASCADE CONSTRAINTS;
> +DROP TRIGGER "@TABLE_PREFIX@URI-URI_ID-TRG";
> +DROP TRIGGER "@TABLE_PREFIX@BRANCH-BRANCH_ID-TRG";
> +DROP TRIGGER "@TABLE_PREFIX@LABEL-LABEL_ID-TRG";
> +DROP TRIGGER "@TABLE_PREFIX@VERSION_HISTORY-VERSION_ID-TRG";
> +
> +DROP SEQUENCE "@TABLE_PREFIX@URI-URI_ID-SEQ";
> +DROP SEQUENCE "@TABLE_PREFIX@BRANCH-BRANCH_ID-SEQ";
> +DROP SEQUENCE "@TABLE_PREFIX@LABEL-LABEL_ID-SEQ";
> +DROP SEQUENCE "@TABLE_PREFIX@VERSION_HISTORY-VERSION_ID-SEQ";
> +
> +DROP TABLE "@TABLE_PREFIX@URI" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@OBJECT" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@BINDING" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@PARENT_BINDING" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@LINKS" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@LOCKS" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@BRANCH" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@LABEL" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@VERSION" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@VERSION_HISTORY" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@VERSION_PREDS" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@VERSION_LABELS" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@VERSION_CONTENT" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@PROPERTIES" CASCADE CONSTRAINTS;
> +DROP TABLE "@TABLE_PREFIX@PERMISSIONS" CASCADE CONSTRAINTS;
>
>
> // path max length: 2500
>
> -CREATE TABLE "URI" (
> +CREATE TABLE "@TABLE_PREFIX@URI" (
> "URI_ID" NUMBER(10) NOT NULL,
> "URI_STRING" VARCHAR2(4000) NOT NULL,
> PRIMARY KEY("URI_ID"),
> UNIQUE("URI_STRING")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "OBJECT" (
> +CREATE TABLE "@TABLE_PREFIX@OBJECT" (
> "URI_ID" NUMBER(10),
> "CLASS_NAME" VARCHAR2(255) NOT NULL,
> PRIMARY KEY("URI_ID"),
> - FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID")
> + FOREIGN KEY("URI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID")
> ) CACHE NOLOGGING;
>
> // node name max length: 512
>
> -CREATE TABLE "BINDING" (
> +CREATE TABLE "@TABLE_PREFIX@BINDING" (
> "URI_ID" NUMBER(10) NOT NULL,
> "NAME" VARCHAR2(4000) NOT NULL,
> "CHILD_UURI_ID" NUMBER(10) NOT NULL,
> PRIMARY KEY("URI_ID", "NAME", "CHILD_UURI_ID"),
> - FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("CHILD_UURI_ID") REFERENCES "URI"("URI_ID")
> + FOREIGN KEY("URI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("CHILD_UURI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "PARENT_BINDING" (
> +CREATE TABLE "@TABLE_PREFIX@PARENT_BINDING" (
> "URI_ID" NUMBER(10) NOT NULL,
> "NAME" VARCHAR2(4000) NOT NULL,
> "PARENT_UURI_ID" NUMBER(10) NOT NULL,
> PRIMARY KEY("URI_ID", "NAME", "PARENT_UURI_ID"),
> - FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("PARENT_UURI_ID") REFERENCES "URI"("URI_ID")
> + FOREIGN KEY("URI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("PARENT_UURI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "LINKS" (
> +CREATE TABLE "@TABLE_PREFIX@LINKS" (
> "URI_ID" NUMBER(10) NOT NULL,
> "LINK_TO_ID" NUMBER(10) NOT NULL,
> PRIMARY KEY("URI_ID", "LINK_TO_ID"),
> - FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("LINK_TO_ID") REFERENCES "URI"("URI_ID")
> + FOREIGN KEY("URI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("LINK_TO_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "LOCKS" (
> +CREATE TABLE "@TABLE_PREFIX@LOCKS" (
> "LOCK_ID" NUMBER(10) NOT NULL,
> "OBJECT_ID" NUMBER(10) NOT NULL,
> "SUBJECT_ID" NUMBER(10) NOT NULL,
> @@ -82,68 +82,68 @@
> "IS_EXCLUSIVE" NUMBER(1) NOT NULL,
> "OWNER" VARCHAR2(4000),
> PRIMARY KEY("LOCK_ID"),
> - FOREIGN KEY("LOCK_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("OBJECT_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("SUBJECT_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("TYPE_ID") REFERENCES "URI"("URI_ID")
> + FOREIGN KEY("LOCK_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("OBJECT_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("SUBJECT_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("TYPE_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "BRANCH" (
> +CREATE TABLE "@TABLE_PREFIX@BRANCH" (
> "BRANCH_ID" NUMBER(10) NOT NULL,
> "BRANCH_STRING" VARCHAR2(4000) NOT NULL,
> PRIMARY KEY("BRANCH_ID"),
> UNIQUE("BRANCH_STRING")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "LABEL" (
> +CREATE TABLE "@TABLE_PREFIX@LABEL" (
> "LABEL_ID" NUMBER(10) NOT NULL,
> "LABEL_STRING" VARCHAR2(4000) NOT NULL,
> PRIMARY KEY("LABEL_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "VERSION" (
> +CREATE TABLE "@TABLE_PREFIX@VERSION" (
> "URI_ID" NUMBER(10) NOT NULL,
> "IS_VERSIONED" NUMBER(1) NOT NULL,
> PRIMARY KEY("URI_ID"),
> - FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID")
> + FOREIGN KEY("URI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "VERSION_HISTORY" (
> +CREATE TABLE "@TABLE_PREFIX@VERSION_HISTORY" (
> "VERSION_ID" NUMBER(10) NOT NULL,
> "URI_ID" NUMBER(10) NOT NULL,
> "BRANCH_ID" NUMBER(10) NOT NULL,
> "REVISION_NO" VARCHAR2(255) NOT NULL,
> PRIMARY KEY("VERSION_ID"),
> UNIQUE("URI_ID", "BRANCH_ID", "REVISION_NO"),
> - FOREIGN KEY("URI_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("BRANCH_ID") REFERENCES "BRANCH"("BRANCH_ID")
> + FOREIGN KEY("URI_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("BRANCH_ID") REFERENCES "@TABLE_PREFIX@BRANCH"("BRANCH_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "VERSION_PREDS" (
> +CREATE TABLE "@TABLE_PREFIX@VERSION_PREDS" (
> "VERSION_ID" NUMBER(10) NOT NULL,
> "PREDECESSOR_ID" NUMBER(10) NOT NULL,
> - FOREIGN KEY("VERSION_ID") REFERENCES "VERSION_HISTORY"("VERSION_ID"),
> - FOREIGN KEY("PREDECESSOR_ID") REFERENCES "VERSION_HISTORY"("VERSION_ID"),
> + FOREIGN KEY("VERSION_ID") REFERENCES "@TABLE_PREFIX@VERSION_HISTORY"("VERSION_ID"),
> + FOREIGN KEY("PREDECESSOR_ID") REFERENCES "@TABLE_PREFIX@VERSION_HISTORY"("VERSION_ID"),
> UNIQUE("VERSION_ID", "PREDECESSOR_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "VERSION_LABELS" (
> +CREATE TABLE "@TABLE_PREFIX@VERSION_LABELS" (
> "VERSION_ID" NUMBER(10) NOT NULL,
> "LABEL_ID" NUMBER(10) NOT NULL,
> UNIQUE("VERSION_ID", "LABEL_ID"),
> - FOREIGN KEY("VERSION_ID") REFERENCES "VERSION_HISTORY"("VERSION_ID"),
> - FOREIGN KEY("LABEL_ID") REFERENCES "LABEL"("LABEL_ID")
> + FOREIGN KEY("VERSION_ID") REFERENCES "@TABLE_PREFIX@VERSION_HISTORY"("VERSION_ID"),
> + FOREIGN KEY("LABEL_ID") REFERENCES "@TABLE_PREFIX@LABEL"("LABEL_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "VERSION_CONTENT" (
> +CREATE TABLE "@TABLE_PREFIX@VERSION_CONTENT" (
> "VERSION_ID" NUMBER(10) NOT NULL,
> "CONTENT" BLOB,
> PRIMARY KEY("VERSION_ID"),
> - FOREIGN KEY("VERSION_ID") REFERENCES "VERSION_HISTORY"("VERSION_ID")
> + FOREIGN KEY("VERSION_ID") REFERENCES "@TABLE_PREFIX@VERSION_HISTORY"("VERSION_ID")
> ) CACHE NOLOGGING
> LOB ("CONTENT") STORE AS (NOCACHE NOLOGGING STORAGE(MAXEXTENTS UNLIMITED));
>
> -CREATE TABLE "PROPERTIES" (
> +CREATE TABLE "@TABLE_PREFIX@PROPERTIES" (
> "VERSION_ID" NUMBER(10) NOT NULL,
> "PROPERTY_NAMESPACE" VARCHAR2(255) NOT NULL,
> "PROPERTY_NAME" VARCHAR2(255) NOT NULL,
> @@ -151,10 +151,10 @@
> "PROPERTY_TYPE" VARCHAR2(255),
> "IS_PROTECTED" NUMBER(1) NOT NULL,
> UNIQUE("VERSION_ID", "PROPERTY_NAMESPACE", "PROPERTY_NAME"),
> - FOREIGN KEY("VERSION_ID") REFERENCES "VERSION_HISTORY"("VERSION_ID")
> + FOREIGN KEY("VERSION_ID") REFERENCES "@TABLE_PREFIX@VERSION_HISTORY"("VERSION_ID")
> ) CACHE NOLOGGING;
>
> -CREATE TABLE "PERMISSIONS" (
> +CREATE TABLE "@TABLE_PREFIX@PERMISSIONS" (
> "OBJECT_ID" NUMBER(10) NOT NULL,
> "SUBJECT_ID" NUMBER(10) NOT NULL,
> "ACTION_ID" NUMBER(10) NOT NULL,
> @@ -162,38 +162,39 @@
> "IS_INHERITABLE" NUMBER(1) NOT NULL,
> "IS_NEGATIVE" NUMBER(1) NOT NULL,
> "SUCCESSION" NUMBER(10) NOT NULL,
> - FOREIGN KEY("OBJECT_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("SUBJECT_ID") REFERENCES "URI"("URI_ID"),
> - FOREIGN KEY("ACTION_ID") REFERENCES "URI"("URI_ID"),
> + FOREIGN KEY("OBJECT_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("SUBJECT_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> + FOREIGN KEY("ACTION_ID") REFERENCES "@TABLE_PREFIX@URI"("URI_ID"),
> UNIQUE("OBJECT_ID", "SUBJECT_ID", "ACTION_ID"),
> UNIQUE("OBJECT_ID", "SUCCESSION")
> ) CACHE NOLOGGING;
>
> -CREATE SEQUENCE "URI-URI_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
> -CREATE SEQUENCE "BRANCH-BRANCH_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
> -CREATE SEQUENCE "LABEL-LABEL_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
> -CREATE SEQUENCE "VERSION_HISTORY-VERSION_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
> +CREATE SEQUENCE "@TABLE_PREFIX@URI-URI_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
> +CREATE SEQUENCE "@TABLE_PREFIX@BRANCH-BRANCH_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
> +CREATE SEQUENCE "@TABLE_PREFIX@LABEL-LABEL_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
> +CREATE SEQUENCE "@TABLE_PREFIX@VERSION_HISTORY-VERSION_ID-SEQ" START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
>
> -CREATE TRIGGER "URI-URI_ID-TRG" BEFORE INSERT ON "URI" FOR EACH ROW
> +CREATE TRIGGER "@TABLE_PREFIX@URI-URI_ID-TRG" BEFORE INSERT ON "@TABLE_PREFIX@URI" FOR EACH ROW
> BEGIN
> -SELECT "URI-URI_ID-SEQ".nextval INTO :new.URI_ID from dual;
> +SELECT "@TABLE_PREFIX@URI-URI_ID-SEQ".nextval INTO :new.URI_ID from dual;
> END;
> /
>
> -CREATE TRIGGER "BRANCH-BRANCH_ID-TRG" BEFORE INSERT ON "BRANCH" FOR EACH ROW
> +CREATE TRIGGER "@TABLE_PREFIX@BRANCH-BRANCH_ID-TRG" BEFORE INSERT ON "@TABLE_PREFIX@BRANCH" FOR EACH ROW
> BEGIN
> -SELECT "BRANCH-BRANCH_ID-SEQ".nextval INTO :new.BRANCH_ID from dual;
> +SELECT "@TABLE_PREFIX@BRANCH-BRANCH_ID-SEQ".nextval INTO :new.BRANCH_ID from dual;
> END;
> /
>
> -CREATE TRIGGER "LABEL-LABEL_ID-TRG" BEFORE INSERT ON "LABEL" FOR EACH ROW
> +CREATE TRIGGER "@TABLE_PREFIX@LABEL-LABEL_ID-TRG" BEFORE INSERT ON "@TABLE_PREFIX@LABEL" FOR EACH ROW
> BEGIN
> -SELECT "LABEL-LABEL_ID-SEQ".nextval INTO :new.LABEL_ID from dual;
> +SELECT "@TABLE_PREFIX@LABEL-LABEL_ID-SEQ".nextval INTO :new.LABEL_ID from dual;
> END;
> /
>
> -CREATE TRIGGER "VERSION_HISTORY-VERSION_ID-TRG" BEFORE INSERT ON "VERSION_HISTORY" FOR EACH ROW
> +CREATE TRIGGER "@TABLE_PREFIX@VERSION_HISTORY-VERSION_ID-TRG" BEFORE INSERT ON
> +"@TABLE_PREFIX@VERSION_HISTORY" FOR EACH ROW
> BEGIN
> -SELECT "VERSION_HISTORY-VERSION_ID-SEQ".nextval INTO :new.VERSION_ID from dual;
> +SELECT "@TABLE_PREFIX@VERSION_HISTORY-VERSION_ID-SEQ".nextval INTO :new.VERSION_ID from dual;
> END;
> /
>
>
> ------------------------------------------------------------------------
>
>
> package org.apache.slide;
>
>
> public class VersionInfo {
> public static final String VERSION_MAJOR = "@version.major@";
> public static final String VERSION_MINOR = "@version.minor@";
> public static final String RELEASE = "@version.release@";
> public static final String BUILD_DATE = "@build.iso.date@";
> public static final String VERSION_CVS_TAG = "@version.cvs.tag@";
> public static final String VERSION_NAME = "@version.name@";
> public static final String BUILD_OS_ARCH = "@os.arch@";
> public static final String BUILD_JAVA_VERSION = "@java.version@";
>
> public static void main(String[] args) {
> System.out.println("Slide version :"
> + VERSION_MAJOR
> + '.'
> + VERSION_MINOR
> + '.'
> + RELEASE
> );
> System.out.println("version cvs tag :"+VERSION_CVS_TAG);
> System.out.println("version name :"+VERSION_NAME);
> System.out.println("build os arch :"+BUILD_OS_ARCH);
> System.out.println("build java version :"+BUILD_JAVA_VERSION);
> }
> }
>
>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org