diff --git a/.gitignore b/.gitignore
index 71dcc0614..9f2118b63 100644
--- a/.gitignore
+++ b/.gitignore
@@ -1,94 +1,95 @@
 .version
 Makefile
 Makefile.in
 configure
 config.cache
 config.log
 config.status
 config.nice
 config.guess
 config.sub
 install-sh
 missing
 autom4te.cache
 aclocal.m4
 TAGS
 invenio-autotools.conf
 po/POTFILES
 po/POTFILES-py
 po/POTFILES-webdoc
 po/stamp-po
 po/*.gmo
 po/*.mo
 po/*.sed
 *~
 *.pyc
 *.clisp.mem
 *.cmucl.core
 *.sbcl.core
 *.fas
 *.fasl
 *.sse2f
 *.lib
 *.x86f
 modules/webauthorprofile/bin/webauthorprofile
 modules/bibauthorid/bin/bibauthorid
 modules/bibcirculation/bin/bibcircd
 modules/bibclassify/bin/bibclassify
 modules/bibconvert/bin/bibconvert
 modules/bibdocfile/bin/bibdocfile
 modules/bibedit/bin/bibedit
 modules/bibrecord/bin/textmarc2xmlmarc
 modules/bibrecord/bin/xmlmarc2textmarc
 modules/bibrecord/bin/xmlmarclint
 modules/docextract/bin/refextract
 modules/docextract/bin/docextract
 modules/bibencode/bin/bibencode
 modules/bibexport/bin/bibexport
 modules/bibformat/bin/bibreformat
 modules/oaiharvest/bin/oaiharvest
 modules/oairepository/bin/oairepositoryupdater
 modules/bibindex/bin/bibindex
 modules/bibindex/bin/bibstat
 modules/bibmatch/bin/bibmatch
 modules/bibrank/bin/bibrank
 modules/bibrank/bin/bibrankgkb
 modules/bibrank/etc/bibrankgkb.cfg
 modules/bibrank/etc/demo_jif.cfg
 modules/bibrank/etc/template_single_tag_rank_method.cfg
 modules/bibsched/bin/bibsched
 modules/bibsched/bin/bibtaskex
 modules/bibsched/bin/bibtasklet
 modules/bibsort/bin/bibsort
 modules/bibsword/bin/bibsword
 modules/bibupload/bin/batchuploader
 modules/bibupload/bin/bibupload
 modules/elmsubmit/bin/elmsubmit
 modules/elmsubmit/etc/elmsubmit.cfg
 modules/miscutil/bin/dbdump
 modules/miscutil/bin/dbexec
 modules/miscutil/bin/inveniocfg
 modules/miscutil/bin/plotextractor
 modules/miscutil/etc/bash_completion.d/inveniocfg
 modules/miscutil/lib/build
 modules/webaccess/bin/authaction
 modules/webaccess/bin/webaccessadmin
 modules/webalert/bin/alertengine
 modules/webmessage/bin/webmessageadmin
 modules/websearch/bin/webcoll
 modules/websession/bin/inveniogc
 modules/webstat/bin/webstat
 modules/webstat/bin/webstatadmin
+modules/webstyle/bin/gotoadmin
 modules/webstyle/bin/webdoc
 modules/websubmit/bin/bibdocfile
 modules/websubmit/bin/inveniounoconv
 modules/bibcirculation/bin/bibcircd
 tags
 config.status.lineno
 configure.lineno
 *.kdevelop
 *.kdevses
 .project
 .settings
 .pydevproject
 org.eclipse.core.resources.prefs
diff --git a/configure.ac b/configure.ac
index 76d88bd58..c7571b455 100644
--- a/configure.ac
+++ b/configure.ac
@@ -1,931 +1,933 @@
 ## This file is part of Invenio.
 ## Copyright (C) 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 ## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
 ## This is Invenio main configure.ac file.  If you change this
 ## file, then please run "autoreconf" to regenerate the "configure"
 ## script.
 
 ## Initialize autoconf and automake:
 AC_INIT([invenio],
         m4_esyscmd([./git-version-gen .tarball-version]),
         [info@invenio-software.org])
 AM_INIT_AUTOMAKE([tar-ustar])
 
 ## By default we shall install into /opt/invenio.  (Do not use
 ## AC_PREFIX_DEFAULT for this, because it would not work well with
 ## the localstatedir hack below.)
 test "${prefix}" = NONE && prefix=/opt/invenio
 
 ## Remove eventual trailing slashes from the prefix value:
 test "${prefix%/}" != "" && prefix=${prefix%/}
 
 ## Check for install:
 AC_PROG_INSTALL
 
 ## Check for gettext support:
 AM_GNU_GETTEXT(external)
 AM_GNU_GETTEXT_VERSION(0.14.4)
 
 ## Check for MySQL client:
 AC_MSG_CHECKING(for mysql)
 AC_ARG_WITH(mysql, AC_HELP_STRING([--with-mysql], [path to a specific MySQL binary (optional)]), MYSQL=${withval})
 if test -n "$MYSQL"; then
    AC_MSG_RESULT($MYSQL)
 else
    AC_PATH_PROG(MYSQL, mysql)
    if test -z "$MYSQL"; then
       AC_MSG_ERROR([
       MySQL command-line client was not found in your PATH.
       Please install it first.
       Available from <http://mysql.com/>.])
    fi
 fi
 
 ## Check for Python:
 AC_MSG_CHECKING(for python)
 AC_ARG_WITH(python, AC_HELP_STRING([--with-python], [path to a specific Python binary (optional)]), PYTHON=${withval})
 if test -n "$PYTHON"; then
    AC_MSG_RESULT($PYTHON)
 else
    AC_PATH_PROG(PYTHON, python)
    if test -z "$PYTHON"; then
       AC_MSG_ERROR([
       Python was not found in your PATH.  Please either install it
       in your PATH or specify --with-python configure option.
       Python is available from <http://python.org/>.])
    fi
 fi
 
 ## Check for OpenOffice.org Python binary:
 AC_MSG_CHECKING(for OpenOffice.org Python binary)
 AC_ARG_WITH(openoffice-python, AC_HELP_STRING([--with-openoffice-python], [path to a specific OpenOffice.org Python binary (optional)]), OPENOFFICE_PYTHON=`which ${withval}`)
 
 if test -z "$OPENOFFICE_PYTHON"; then
    OPENOFFICE_PYTHON=`locate -l 1 -r "o.*office/program/python$"`
    OPENOFFICE_PYTHON="$PYTHON $OPENOFFICE_PYTHON"
    if test -n "$OPENOFFICE_PYTHON" && ($OPENOFFICE_PYTHON -c "import uno" 2> /dev/null); then
       AC_MSG_RESULT($OPENOFFICE_PYTHON)
    else
       AC_MSG_WARN([
       You have not specified the path ot the OpenOffice.org Python binary.
       OpenOffice.org and Microsoft Office document conversion and fulltext indexing
       will not be available.  We recommend you to install OpenOffice.org first
       and to rerun the configure script. OpenOffice.org is available from
       <http://www.openoffice.org/>.])
    fi
 elif ($OPENOFFICE_PYTHON -c "import uno" 2> /dev/null); then
    AC_MSG_RESULT($OPENOFFICE_PYTHON)
 else
    AC_MSG_ERROR([
    The specified OpenOffice.org Python binary is not correctly configured.
    Please specify the correct path to the specific OpenOffice Python binary
    (OpenOffice.org is available from <http://www.openoffice.org/>).])
 fi
 
 ## Check for Python version and modules:
 AC_MSG_CHECKING(for required Python modules)
 $PYTHON ${srcdir}/configure-tests.py
 if test $? -ne 0; then
    AC_MSG_ERROR([Please fix the above Python problem before continuing.])
 fi
 AC_MSG_RESULT(found)
 
 ## Check for PHP:
 AC_PATH_PROG(PHP, php)
 
 ## Check for gzip:
 AC_PATH_PROG(GZIP, gzip)
 if test -z "$GZIP"; then
    AC_MSG_WARN([
    Gzip was not found in your PATH.  It is used in
    the WebSubmit module to compress the data submitted in an archive.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  Gzip is available from
    <http://www.gzip.org/>.])
 fi
 
 ## Check for gunzip:
 AC_PATH_PROG(GUNZIP, gunzip)
 if test -z "$GUNZIP"; then
    AC_MSG_WARN([
    Gunzip was not found in your PATH.  It is used in
    the WebSubmit module to correctly deal with submitted compressed
    files.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  Gunzip is available from
    <http://www.gzip.org/>.])
 fi
 
 ## Check for tar:
 AC_PATH_PROG(TAR, tar)
 if test -z "$TAR"; then
    AC_MSG_WARN([
    Tar was not found in your PATH.  It is used in
    the WebSubmit module to pack the submitted data into an archive.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  Tar is available from
    <ftp://prep.ai.mit.edu/pub/gnu/tar/>.])
 fi
 
 ## Check for wget:
 AC_PATH_PROG(WGET, wget)
 if test -z "$WGET"; then
    AC_MSG_WARN([
    wget was not found in your PATH.  It is used for the fulltext file
    retrieval.
    You can continue without it but we recomend you to install it first
    and to rerun the configure script.  wget is available from
    <http://www.gnu.org/software/wget/>.])
 fi
 
 ## Check for md5sum:
 AC_PATH_PROG(MD5SUM, md5sum)
 if test -z "$MD5SUM"; then
    AC_MSG_WARN([
    md5sum was not found in your PATH.  It is used for the fulltext file
    checksum verification.
    You can continue without it but we recomend you to install it first
    and to rerun the configure script.  md5sum is available from
    <http://www.gnu.org/software/coreutils/>.])
 fi
 
 ## Check for ps2pdf:
 AC_PATH_PROG(PS2PDF, ps2pdf)
 if test -z "$PS2PDF"; then
    AC_MSG_WARN([
    ps2pdf was not found in your PATH.  It is used in
    the WebSubmit module to convert submitted PostScripts into PDF.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  ps2pdf is available from
    <http://www.cs.wisc.edu/~ghost/doc/AFPL/>.])
 fi
 
 ## Check for pdflatex:
 AC_PATH_PROG(PDFLATEX, pdflatex)
 if test -z "$PDFLATEX"; then
    AC_MSG_WARN([
    pdflatex was not found in your PATH.  It is used in
    the WebSubmit module to stamp PDF files.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.])
 fi
 
 
 ## Check for tiff2pdf:
 AC_PATH_PROG(TIFF2PDF, tiff2pdf)
 if test -z "$TIFF2PDF"; then
    AC_MSG_WARN([
    tiff2pdf was not found in your PATH.  It is used in
    the WebSubmit module to convert submitted TIFF file into PDF.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  tiff2pdf is available from
    <http://www.remotesensing.org/libtiff/>.])
 fi
 
 ## Check for gs:
 AC_PATH_PROG(GS, gs)
 if test -z "$GS"; then
    AC_MSG_WARN([
    gs was not found in your PATH.  It is used in
    the WebSubmit module to convert submitted PostScripts into PDF.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  gs is available from
    <http://www.cs.wisc.edu/~ghost/doc/AFPL/>.])
 fi
 
 ## Check for pdftotext:
 AC_PATH_PROG(PDFTOTEXT, pdftotext)
 if test -z "$PDFTOTEXT"; then
    AC_MSG_WARN([
    pdftotext was not found in your PATH.  It is used for the fulltext indexation
    of PDF files.
    You can continue without it but you may miss fulltext searching capability
    of Invenio.  We recomend you to install it first and to rerun the configure
    script.  pdftotext is available from <http://www.foolabs.com/xpdf/home.html>.
    ])
 fi
 
 ## Check for pdftotext:
 AC_PATH_PROG(PDFINFO, pdfinfo)
 if test -z "$PDFINFO"; then
    AC_MSG_WARN([
    pdfinfo was not found in your PATH.  It is used for gathering information on
    PDF files.
    You can continue without it but you may miss this feature of Invenio.
    We recomend you to install it first and to rerun the configure
    script.  pdftotext is available from <http://www.foolabs.com/xpdf/home.html>.
    ])
 fi
 
 ## Check for pdftk:
 AC_PATH_PROG(PDFTK, pdftk)
 if test -z "$PDFTK"; then
    AC_MSG_WARN([
    pdftk was not found in your PATH.  It is used for the fulltext file stamping.
    You can continue without it but you may miss this feature of Invenio.
    We recomend you to install it first and to rerun the configure
    script.  pdftk is available from <http://www.accesspdf.com/pdftk/>.
    ])
 fi
 
 ## Check for pdf2ps:
 AC_PATH_PROG(PDF2PS, pdf2ps)
 if test -z "$PDF2PS"; then
    AC_MSG_WARN([
    pdf2ps was not found in your PATH.  It is used in
    the WebSubmit module to convert submitted PDFs into PostScript.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  pdf2ps is available from
    <http://www.cs.wisc.edu/~ghost/doc/AFPL/>.])
 fi
 
 ## Check for pdftops:
 AC_PATH_PROG(PDFTOPS, pdftops)
 if test -z "$PDFTOPS"; then
    AC_MSG_WARN([
    pdftops was not found in your PATH.  It is used in
    the WebSubmit module to convert submitted PDFs into PostScript.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  pdftops is available from
    <http://poppler.freedesktop.org/>.])
 fi
 
 ## Check for pdfopt:
 AC_PATH_PROG(PDFOPT, pdfopt)
 if test -z "$PDFOPT"; then
    AC_MSG_WARN([
    pdfopt was not found in your PATH.  It is used in
    the WebSubmit module to linearized submitted PDFs.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  pdfopt is available from
    <http://www.cs.wisc.edu/~ghost/doc/AFPL/>.])
 fi
 
 ## Check for pdfimages:
 AC_PATH_PROG(PDFTOPPM, pdftoppm)
 if test -z "$PDFTOPPM"; then
    AC_MSG_WARN([
    pdftoppm was not found in your PATH.  It is used in
    the WebSubmit module to extract images from PDFs for OCR.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  pdftoppm is available from
    <http://poppler.freedesktop.org/>.])
 fi
 
 ## Check for pdfimages:
 AC_PATH_PROG(PAMFILE, pdftoppm)
 if test -z "$PAMFILE"; then
    AC_MSG_WARN([
    pamfile was not found in your PATH.  It is used in
    the WebSubmit module to retrieve the size of images extracted from PDFs
    for OCR.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  pamfile is available as part of the netpbm utilities
    from:
    <http://netpbm.sourceforge.net/>.])
 fi
 
 ## Check for ocroscript:
 AC_PATH_PROG(OCROSCRIPT, ocroscript)
 if test -z "$OCROSCRIPT"; then
    AC_MSG_WARN([
    If you plan to run OCR on your PDFs, then please install
    ocroscript now.  Otherwise you can safely continue.  You have also an
    option to install ocroscript later and edit invenio-local.conf to let
    Invenio know the path to ocroscript.
    ocroscript is available as part of OCROpus from
    <http://code.google.com/p/ocropus/>.
    NOTE: Since OCROpus is being actively developed and its api is continuosly
    changing, please install relase 0.3.1])
 fi
 
 ## Check for pstotext:
 AC_PATH_PROG(PSTOTEXT, pstotext)
 if test -z "$PSTOTEXT"; then
    AC_MSG_WARN([
    pstotext was not found in your PATH.  It is used for the fulltext indexation
    of PDF and PostScript files.
    Please install pstotext.  Otherwise you can safely continue.  You have also an
    option to install pstotext later and edit invenio-local.conf to let
    Invenio know the path to pstotext.
    pstotext is available from <http://www.cs.wisc.edu/~ghost/doc/AFPL/>.
    ])
 fi
 
 ## Check for ps2ascii:
 AC_PATH_PROG(PSTOASCII, ps2ascii)
 if test -z "$PSTOASCII"; then
    AC_MSG_WARN([
    ps2ascii was not found in your PATH.  It is used for the fulltext indexation
    of PostScript files.
    Please install ps2ascii.  Otherwise you can safely continue.  You have also an
    option to install ps2ascii later and edit invenio-local.conf to let
    Invenio know the path to ps2ascii.
    ps2ascii is available from <http://www.cs.wisc.edu/~ghost/doc/AFPL/>.
    ])
 fi
 
 ## Check for any2djvu:
 AC_PATH_PROG(ANY2DJVU, any2djvu)
 if test -z "$ANY2DJVU"; then
    AC_MSG_WARN([
    any2djvu was not found in your PATH.  It is used in
    the WebSubmit module to convert documents to DJVU.
    Please install any2djvu.  Otherwise you can safely continue.  You have also an
    option to install any2djvu later and edit invenio-local.conf to let
    Invenio know the path to any2djvu.
    any2djvu is available from
    <http://djvu.sourceforge.net/>.])
 fi
 
 ## Check for DJVUPS:
 AC_PATH_PROG(DJVUPS, djvups)
 if test -z "$DJVUPS"; then
    AC_MSG_WARN([
    djvups was not found in your PATH.  It is used in
    the WebSubmit module to convert documents from DJVU.
    Please install djvups.  Otherwise you can safely continue.  You have also an
    option to install djvups later and edit invenio-local.conf to let
    Invenio know the path to djvups.
    djvups is available from
    <http://djvu.sourceforge.net/>.])
 fi
 
 ## Check for DJVUTXT:
 AC_PATH_PROG(DJVUTXT, djvutxt)
 if test -z "$DJVUTXT"; then
    AC_MSG_WARN([
    djvutxt was not found in your PATH.  It is used in
    the WebSubmit module to extract text from DJVU documents.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  djvutxt is available from
    <http://djvu.sourceforge.net/>.])
 fi
 
 ## Check for file:
 AC_PATH_PROG(FILE, file)
 if test -z "$FILE"; then
    AC_MSG_WARN([
    File was not found in your PATH.  It is used in
    the WebSubmit module to check the validity of the submitted files.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  File is available from
    <ftp://ftp.astron.com/pub/file/>.])
 fi
 
 ## Check for convert:
 AC_PATH_PROG(CONVERT, convert)
 if test -z "$CONVERT"; then
    AC_MSG_WARN([
    Convert was not found in your PATH.  It is used in
    the WebSubmit module to create an icon from a submitted picture.
    You can continue without it but you will miss some Invenio
    functionality.  We recommend you to install it first and to rerun
    the configure script.  Convert is available from
    <http://www.imagemagick.org/>.])
 fi
 
 ## Check for CLISP:
 AC_MSG_CHECKING(for clisp)
 AC_ARG_WITH(clisp, AC_HELP_STRING([--with-clisp], [path to a specific CLISP binary (optional)]), CLISP=${withval})
 if test -n "$CLISP"; then
    AC_MSG_RESULT($CLISP)
 else
    AC_PATH_PROG(CLISP, clisp)
    if test -z "$CLISP"; then
       AC_MSG_WARN([
       GNU CLISP was not found in your PATH.  It is used by the WebStat
       module to produce statistics about Invenio usage.  (Alternatively,
       SBCL or CMUCL can be used instead of CLISP.)
       You can continue without it but you will miss this feature.  We
       recommend you to install it first (if you don't have neither CMUCL
       nor SBCL) and to rerun the configure script.
       GNU CLISP is available from <http://clisp.cons.org/>.])
    fi
 fi
 
 ## Check for CMUCL:
 AC_MSG_CHECKING(for cmucl)
 AC_ARG_WITH(cmucl, AC_HELP_STRING([--with-cmucl], [path to a specific CMUCL binary (optional)]), CMUCL=${withval})
 if test -n "$CMUCL"; then
    AC_MSG_RESULT($CMUCL)
 else
    AC_PATH_PROG(CMUCL, cmucl)
    if test -z "$CMUCL"; then
       AC_MSG_CHECKING(for lisp) # CMUCL can also be installed under `lisp' exec name
       AC_PATH_PROG(CMUCL, lisp)
    fi
    if test -z "$CMUCL"; then
       AC_MSG_WARN([
       CMUCL was not found in your PATH.  It is used by the WebStat
       module to produce statistics about Invenio usage.  (Alternatively,
       CLISP or SBCL can be used instead of CMUCL.)
       You can continue without it but you will miss this feature.  We
       recommend you to install it first (if you don't have neither CLISP
       nor SBCL) and to rerun the configure script.
       CMUCL is available from <http://www.cons.org/cmucl/>.])
    fi
 fi
 
 ## Check for SBCL:
 AC_MSG_CHECKING(for sbcl)
 AC_ARG_WITH(sbcl, AC_HELP_STRING([--with-sbcl], [path to a specific SBCL binary (optional)]), SBCL=${withval})
 if test -n "$SBCL"; then
    AC_MSG_RESULT($SBCL)
 else
    AC_PATH_PROG(SBCL, sbcl)
    if test -z "$SBCL"; then
       AC_MSG_WARN([
       SBCL was not found in your PATH.  It is used by the WebStat
       module to produce statistics about Invenio usage.  (Alternatively,
       CLISP or CMUCL can be used instead of SBCL.)
       You can continue without it but you will miss this feature.  We
       recommend you to install it first (if you don't have neither CLISP
       nor CMUCL) and to rerun the configure script.
       SBCL is available from <http://sbcl.sourceforge.net/>.])
    fi
 fi
 
 ## Check for gnuplot:
 AC_PATH_PROG(GNUPLOT, gnuplot)
 if test -z "$GNUPLOT"; then
    AC_MSG_WARN([
    Gnuplot was not found in your PATH.  It is used by the BibRank
    module to produce graphs about download and citation history.
    You can continue without it but you will miss these graphs.  We
    recommend you to install it first and to rerun the configure script.
    Gnuplot is available from <http://www.gnuplot.info/>.])
 fi
 
 ## Check for ffmpeg:
 AC_PATH_PROG(FFMPEG, ffmpeg)
 AC_PATH_PROG(FFPROBE, ffprobe)
 if test -z "$FFMPEG"; then
    AC_MSG_WARN([
    FFmpeg was not found in your PATH. It is used by the BibEncode
    module to for video encoding.
    You can continue without but you will not be able to use BibEncode
    and no video submission workflows are thereby possible.
    We recommend you to install it first if you would like to support video
    submissions and to rerun the configure script.
    FFmpeg is available from <http://www.ffmpeg.org/>.])
 fi
 
 ## Check for mediainfo:
 AC_PATH_PROG(MEDIAINFO, mediainfo)
 if test -z "$MEDIAINFO"; then
    AC_MSG_WARN([
    Mediainfo was not found in your PATH. It is used by the BibEncode
    module to for video encoding and media metadata handling.
    You can continue without but you will not be able to use BibEncode
    and no video submission workflows are thereby possible.
    We recommend you to install it first if you would like to support video
    submissions and to rerun the configure script.
    Mediainfo is available from <http://mediainfo.sourceforge.net/>.])
 fi
 
 ## Check for ffmpeg
 
 ## Substitute variables:
 AC_SUBST(VERSION)
 AC_SUBST(OPENOFFICE_PYTHON)
 AC_SUBST(MYSQL)
 AC_SUBST(PYTHON)
 AC_SUBST(GZIP)
 AC_SUBST(GUNZIP)
 AC_SUBST(TAR)
 AC_SUBST(WGET)
 AC_SUBST(MD5SUM)
 AC_SUBST(PS2PDF)
 AC_SUBST(GS)
 AC_SUBST(PDFTOTEXT)
 AC_SUBST(PDFTK)
 AC_SUBST(PDF2PS)
 AC_SUBST(PDFTOPS)
 AC_SUBST(PDFOPT)
 AC_SUBST(PDFTOPPM)
 AC_SUBST(OCROSCRIPT)
 AC_SUBST(PSTOTEXT)
 AC_SUBST(PSTOASCII)
 AC_SUBST(ANY2DJVU)
 AC_SUBST(DJVUPS)
 AC_SUBST(DJVUTXT)
 AC_SUBST(FILE)
 AC_SUBST(CONVERT)
 AC_SUBST(GNUPLOT)
 AC_SUBST(CLISP)
 AC_SUBST(CMUCL)
 AC_SUBST(SBCL)
 AC_SUBST(CACHEDIR)
 AC_SUBST(FFMPEG)
 AC_SUBST(MEDIAINFO)
 AC_SUBST(FFPROBE)
 AC_SUBST(localstatedir, `eval echo "${localstatedir}"`)
 
 ## Define output files:
 AC_CONFIG_FILES([config.nice  \
      Makefile \
      po/Makefile.in \
      config/Makefile \
      config/invenio-autotools.conf \
      modules/Makefile \
      modules/webauthorprofile/Makefile \
      modules/webauthorprofile/lib/Makefile \
      modules/webauthorprofile/bin/Makefile \
      modules/webauthorprofile/bin/webauthorprofile \
      modules/bibauthorid/Makefile \
      modules/bibauthorid/bin/Makefile \
      modules/bibauthorid/bin/bibauthorid \
      modules/bibauthorid/doc/Makefile \
      modules/bibauthorid/doc/admin/Makefile \
      modules/bibauthorid/doc/hacking/Makefile \
      modules/bibauthorid/lib/Makefile \
      modules/bibauthorid/etc/Makefile \
      modules/bibauthorid/etc/name_authority_files/Makefile \
      modules/bibauthorid/web/Makefile \
      modules/bibcatalog/Makefile \
      modules/bibcatalog/doc/Makefile \
      modules/bibcatalog/doc/admin/Makefile \
      modules/bibcatalog/doc/hacking/Makefile
      modules/bibcatalog/lib/Makefile \
      modules/bibcheck/Makefile \
      modules/bibcheck/doc/Makefile \
      modules/bibcheck/doc/admin/Makefile \
      modules/bibcheck/doc/hacking/Makefile \
      modules/bibcheck/etc/Makefile \
      modules/bibcheck/web/Makefile \
      modules/bibcheck/web/admin/Makefile \
      modules/bibcirculation/Makefile \
      modules/bibcirculation/bin/Makefile \
      modules/bibcirculation/bin/bibcircd \
      modules/bibcirculation/doc/Makefile \
      modules/bibcirculation/doc/admin/Makefile \
      modules/bibcirculation/doc/hacking/Makefile
      modules/bibcirculation/lib/Makefile \
      modules/bibcirculation/web/Makefile \
      modules/bibcirculation/web/admin/Makefile \
      modules/bibclassify/Makefile \
      modules/bibclassify/bin/Makefile \
      modules/bibclassify/bin/bibclassify \
      modules/bibclassify/doc/Makefile \
      modules/bibclassify/doc/admin/Makefile \
      modules/bibclassify/doc/hacking/Makefile \
      modules/bibclassify/etc/Makefile \
      modules/bibclassify/lib/Makefile \
      modules/bibconvert/Makefile \
      modules/bibconvert/bin/Makefile \
      modules/bibconvert/bin/bibconvert \
      modules/bibconvert/doc/Makefile \
      modules/bibconvert/doc/admin/Makefile \
      modules/bibconvert/doc/hacking/Makefile \
      modules/bibconvert/etc/Makefile \
      modules/bibconvert/lib/Makefile \
      modules/bibdocfile/Makefile \
      modules/bibdocfile/bin/bibdocfile \
      modules/bibdocfile/bin/Makefile \
      modules/bibdocfile/doc/Makefile \
      modules/bibdocfile/doc/hacking/Makefile \
      modules/bibdocfile/lib/Makefile \
      modules/bibrecord/Makefile \
      modules/bibrecord/bin/Makefile \
      modules/bibrecord/bin/xmlmarc2textmarc \
      modules/bibrecord/bin/textmarc2xmlmarc \
      modules/bibrecord/bin/xmlmarclint \
      modules/bibrecord/doc/Makefile \
      modules/bibrecord/doc/admin/Makefile \
      modules/bibrecord/doc/hacking/Makefile \
      modules/bibrecord/etc/Makefile \
      modules/bibrecord/lib/Makefile \
      modules/bibedit/Makefile \
      modules/bibedit/bin/Makefile \
      modules/bibedit/bin/bibedit \
      modules/bibedit/doc/Makefile \
      modules/bibedit/doc/admin/Makefile \
      modules/bibedit/doc/hacking/Makefile \
      modules/bibedit/etc/Makefile \
      modules/bibedit/lib/Makefile \
      modules/bibedit/web/Makefile \
      modules/bibencode/Makefile \
      modules/bibencode/bin/Makefile \
      modules/bibencode/bin/bibencode \
      modules/bibencode/lib/Makefile \
      modules/bibencode/etc/Makefile \
      modules/bibencode/www/Makefile \
      modules/bibexport/Makefile \
      modules/bibexport/bin/Makefile \
      modules/bibexport/bin/bibexport \
      modules/bibexport/doc/Makefile \
      modules/bibexport/doc/admin/Makefile \
      modules/bibexport/doc/hacking/Makefile
      modules/bibexport/etc/Makefile \
      modules/bibexport/lib/Makefile \
      modules/bibexport/web/Makefile \
      modules/bibexport/web/admin/Makefile \
      modules/bibformat/Makefile \
      modules/bibformat/bin/Makefile \
      modules/bibformat/bin/bibreformat \
      modules/bibformat/doc/Makefile \
      modules/bibformat/doc/admin/Makefile \
      modules/bibformat/doc/hacking/Makefile \
      modules/bibformat/etc/Makefile \
      modules/bibformat/etc/format_templates/Makefile \
      modules/bibformat/etc/output_formats/Makefile \
      modules/bibformat/lib/Makefile \
      modules/bibformat/lib/elements/Makefile \
      modules/bibformat/web/Makefile \
      modules/bibformat/web/admin/Makefile \
      modules/oaiharvest/Makefile \
      modules/oaiharvest/bin/Makefile \
      modules/oaiharvest/bin/oaiharvest \
      modules/oaiharvest/doc/Makefile \
      modules/oaiharvest/doc/admin/Makefile \
      modules/oaiharvest/doc/hacking/Makefile \
      modules/oaiharvest/lib/Makefile \
      modules/oaiharvest/web/Makefile \
      modules/oaiharvest/web/admin/Makefile \
      modules/oairepository/Makefile \
      modules/oairepository/bin/Makefile \
      modules/oairepository/bin/oairepositoryupdater \
      modules/oairepository/doc/Makefile \
      modules/oairepository/doc/admin/Makefile \
      modules/oairepository/doc/hacking/Makefile \
      modules/oairepository/etc/Makefile \
      modules/oairepository/lib/Makefile \
      modules/oairepository/web/Makefile \
      modules/oairepository/web/admin/Makefile \
      modules/bibindex/Makefile \
      modules/bibindex/bin/Makefile \
      modules/bibindex/bin/bibindex \
      modules/bibindex/bin/bibstat \
      modules/bibindex/doc/Makefile \
      modules/bibindex/doc/admin/Makefile \
      modules/bibindex/doc/hacking/Makefile \
      modules/bibindex/lib/Makefile \
      modules/bibindex/web/Makefile \
      modules/bibindex/web/admin/Makefile \
      modules/bibknowledge/Makefile \
      modules/bibknowledge/lib/Makefile \
      modules/bibknowledge/doc/Makefile \
      modules/bibknowledge/doc/admin/Makefile \
      modules/bibknowledge/doc/hacking/Makefile \
      modules/bibmatch/Makefile \
      modules/bibmatch/bin/Makefile \
      modules/bibmatch/bin/bibmatch \
      modules/bibmatch/doc/Makefile \
      modules/bibmatch/doc/admin/Makefile \
      modules/bibmatch/doc/hacking/Makefile \
      modules/bibmatch/etc/Makefile \
      modules/bibmatch/lib/Makefile \
      modules/bibmerge/Makefile \
      modules/bibmerge/bin/Makefile \
      modules/bibmerge/doc/Makefile \
      modules/bibmerge/doc/admin/Makefile \
      modules/bibmerge/doc/hacking/Makefile \
      modules/bibmerge/lib/Makefile \
      modules/bibmerge/web/Makefile \
      modules/bibmerge/web/admin/Makefile \
      modules/bibrank/Makefile \
      modules/bibrank/bin/Makefile \
      modules/bibrank/bin/bibrank \
      modules/bibrank/bin/bibrankgkb \
      modules/bibrank/doc/Makefile \
      modules/bibrank/doc/admin/Makefile \
      modules/bibrank/doc/hacking/Makefile \
      modules/bibrank/etc/Makefile \
      modules/bibrank/etc/bibrankgkb.cfg \
      modules/bibrank/etc/demo_jif.cfg \
      modules/bibrank/etc/template_single_tag_rank_method.cfg \
      modules/bibrank/lib/Makefile \
      modules/bibrank/web/Makefile \
      modules/bibrank/web/admin/Makefile \
      modules/bibsched/Makefile \
      modules/bibsched/bin/Makefile \
      modules/bibsched/bin/bibsched \
      modules/bibsched/bin/bibtaskex \
      modules/bibsched/bin/bibtasklet \
      modules/bibsched/doc/Makefile \
      modules/bibsched/doc/admin/Makefile \
      modules/bibsched/doc/hacking/Makefile \
      modules/bibsched/lib/Makefile \
      modules/bibsched/lib/tasklets/Makefile \
      modules/bibupload/Makefile \
      modules/bibsort/Makefile \
      modules/bibsort/bin/Makefile \
      modules/bibsort/bin/bibsort \
      modules/bibsort/lib/Makefile \
      modules/bibsort/etc/Makefile \
      modules/bibsort/doc/Makefile \
      modules/bibsort/doc/admin/Makefile \
      modules/bibsort/doc/hacking/Makefile \
      modules/bibsort/web/Makefile \
      modules/bibsort/web/admin/Makefile \
      modules/bibsword/Makefile \
      modules/bibsword/bin/Makefile \
      modules/bibsword/bin/bibsword \
      modules/bibsword/doc/Makefile \
      modules/bibsword/doc/admin/Makefile \
      modules/bibsword/doc/hacking/Makefile \
      modules/bibsword/lib/Makefile \
      modules/bibsword/etc/Makefile \
      modules/bibupload/bin/Makefile \
      modules/bibupload/bin/bibupload \
      modules/bibupload/bin/batchuploader \
      modules/bibupload/doc/Makefile \
      modules/bibupload/doc/admin/Makefile \
      modules/bibupload/doc/hacking/Makefile \
      modules/bibupload/lib/Makefile \
      modules/elmsubmit/Makefile \
      modules/elmsubmit/bin/Makefile \
      modules/elmsubmit/bin/elmsubmit \
      modules/elmsubmit/doc/Makefile \
      modules/elmsubmit/doc/admin/Makefile \
      modules/elmsubmit/doc/hacking/Makefile \
      modules/elmsubmit/etc/Makefile \
      modules/elmsubmit/etc/elmsubmit.cfg \
      modules/elmsubmit/lib/Makefile \
      modules/miscutil/Makefile \
      modules/miscutil/bin/Makefile \
      modules/miscutil/bin/dbdump \
      modules/miscutil/bin/dbexec \
      modules/miscutil/bin/inveniocfg \
      modules/miscutil/bin/plotextractor \
      modules/miscutil/demo/Makefile \
      modules/miscutil/doc/Makefile \
      modules/miscutil/doc/hacking/Makefile \
      modules/miscutil/etc/Makefile \
      modules/miscutil/etc/bash_completion.d/Makefile \
      modules/miscutil/etc/bash_completion.d/inveniocfg \
      modules/miscutil/etc/ckeditor_scientificchar/Makefile \
      modules/miscutil/etc/ckeditor_scientificchar/dialogs/Makefile \
      modules/miscutil/etc/ckeditor_scientificchar/lang/Makefile \
      modules/miscutil/lib/Makefile \
      modules/miscutil/lib/upgrades/Makefile \
      modules/miscutil/sql/Makefile \
      modules/miscutil/web/Makefile \
      modules/webaccess/Makefile \
      modules/webaccess/bin/Makefile \
      modules/webaccess/bin/authaction \
      modules/webaccess/bin/webaccessadmin \
      modules/webaccess/doc/Makefile \
      modules/webaccess/doc/admin/Makefile \
      modules/webaccess/doc/hacking/Makefile \
      modules/webaccess/lib/Makefile \
      modules/webaccess/web/Makefile \
      modules/webaccess/web/admin/Makefile \
      modules/webalert/Makefile \
      modules/webalert/bin/Makefile \
      modules/webalert/bin/alertengine \
      modules/webalert/doc/Makefile \
      modules/webalert/doc/admin/Makefile \
      modules/webalert/doc/hacking/Makefile \
      modules/webalert/lib/Makefile \
      modules/webalert/web/Makefile \
      modules/webbasket/Makefile \
      modules/webbasket/doc/Makefile \
      modules/webbasket/doc/admin/Makefile \
      modules/webbasket/doc/hacking/Makefile \
      modules/webbasket/lib/Makefile \
      modules/webbasket/web/Makefile \
      modules/webcomment/Makefile \
      modules/webcomment/doc/Makefile \
      modules/webcomment/doc/admin/Makefile \
      modules/webcomment/doc/hacking/Makefile \
      modules/webcomment/lib/Makefile \
      modules/webcomment/web/Makefile \
      modules/webcomment/web/admin/Makefile \
      modules/webhelp/Makefile \
      modules/webhelp/web/Makefile \
      modules/webhelp/web/admin/Makefile \
      modules/webhelp/web/admin/howto/Makefile \
      modules/webhelp/web/hacking/Makefile \
      modules/webjournal/Makefile \
      modules/webjournal/etc/Makefile \
      modules/webjournal/doc/Makefile \
      modules/webjournal/doc/admin/Makefile \
      modules/webjournal/doc/hacking/Makefile \
      modules/webjournal/lib/Makefile \
      modules/webjournal/lib/elements/Makefile \
      modules/webjournal/lib/widgets/Makefile \
      modules/webjournal/web/Makefile \
      modules/webjournal/web/admin/Makefile \
      modules/weblinkback/Makefile \
      modules/weblinkback/lib/Makefile \
      modules/weblinkback/web/Makefile \
      modules/weblinkback/web/admin/Makefile \
      modules/webmessage/Makefile \
      modules/webmessage/bin/Makefile \
      modules/webmessage/bin/webmessageadmin \
      modules/webmessage/doc/Makefile \
      modules/webmessage/doc/admin/Makefile \
      modules/webmessage/doc/hacking/Makefile \
      modules/webmessage/lib/Makefile \
      modules/webmessage/web/Makefile \
      modules/websearch/Makefile \
      modules/websearch/bin/Makefile \
      modules/websearch/bin/webcoll \
      modules/websearch/doc/Makefile \
      modules/websearch/doc/admin/Makefile \
      modules/websearch/doc/hacking/Makefile \
      modules/websearch/lib/Makefile \
      modules/websearch/web/Makefile \
      modules/websearch/web/admin/Makefile \
      modules/websession/Makefile \
      modules/websession/bin/Makefile \
      modules/websession/bin/inveniogc \
      modules/websession/doc/Makefile \
      modules/websession/doc/admin/Makefile \
      modules/websession/doc/hacking/Makefile \
      modules/websession/lib/Makefile \
      modules/websession/web/Makefile \
      modules/webstat/Makefile \
      modules/webstat/bin/Makefile \
      modules/webstat/bin/webstat \
      modules/webstat/bin/webstatadmin \
      modules/webstat/doc/Makefile \
      modules/webstat/doc/admin/Makefile \
      modules/webstat/doc/hacking/Makefile \
      modules/webstat/etc/Makefile \
      modules/webstat/lib/Makefile \
      modules/webstyle/Makefile \
      modules/webstyle/bin/Makefile \
+     modules/webstyle/bin/gotoadmin \
      modules/webstyle/bin/webdoc \
      modules/webstyle/css/Makefile \
      modules/webstyle/doc/Makefile \
      modules/webstyle/doc/admin/Makefile \
      modules/webstyle/doc/hacking/Makefile \
      modules/webstyle/etc/Makefile \
      modules/webstyle/img/Makefile \
      modules/webstyle/lib/Makefile \
+     modules/webstyle/lib/goto_plugins/Makefile \
      modules/websubmit/Makefile \
      modules/websubmit/bin/Makefile \
      modules/websubmit/bin/inveniounoconv \
      modules/websubmit/doc/Makefile \
      modules/websubmit/doc/admin/Makefile \
      modules/websubmit/doc/hacking/Makefile \
      modules/websubmit/etc/Makefile \
      modules/websubmit/lib/Makefile \
      modules/websubmit/lib/functions/Makefile \
      modules/websubmit/web/Makefile \
      modules/websubmit/web/admin/Makefile \
      modules/docextract/Makefile \
      modules/docextract/bin/Makefile \
      modules/docextract/bin/docextract \
      modules/docextract/bin/refextract \
      modules/docextract/doc/Makefile \
      modules/docextract/lib/Makefile \
      modules/docextract/etc/Makefile \
      modules/docextract/doc/admin/Makefile \
      modules/docextract/doc/hacking/Makefile \
      ])
 
 ## Finally, write output files:
 AC_OUTPUT
 
 ## Write help:
 AC_MSG_RESULT([****************************************************************************])
 AC_MSG_RESULT([** Your Invenio installation is now ready for building.                   **])
 AC_MSG_RESULT([** You have entered the following parameters:                             **])
 AC_MSG_RESULT([**   - Invenio main install directory: ${prefix}])
 AC_MSG_RESULT([**   - Python executable: $PYTHON])
 AC_MSG_RESULT([**   - MySQL client executable: $MYSQL])
 AC_MSG_RESULT([**   - CLISP executable: $CLISP])
 AC_MSG_RESULT([**   - CMUCL executable: $CMUCL])
 AC_MSG_RESULT([**   - SBCL executable: $SBCL])
 AC_MSG_RESULT([** Here are the steps to continue the building process:                   **])
 AC_MSG_RESULT([**   1) Type 'make' to build your Invenio system.                         **])
 AC_MSG_RESULT([**   2) Type 'make install' to install your Invenio system.               **])
 AC_MSG_RESULT([** After that you can start customizing your installation as documented   **])
 AC_MSG_RESULT([** in the INSTALL file (i.e. edit invenio.conf, run inveniocfg, etc).     **])
 AC_MSG_RESULT([** Good luck, and thanks for choosing Invenio.                            **])
 AC_MSG_RESULT([**              -- Invenio Development Team <info@invenio-software.org>   **])
 AC_MSG_RESULT([****************************************************************************])
 
 ## end of file
diff --git a/modules/webstyle/bin/Makefile.am b/modules/miscutil/lib/upgrades/invenio_2013_01_08_new_goto_table.py
similarity index 51%
copy from modules/webstyle/bin/Makefile.am
copy to modules/miscutil/lib/upgrades/invenio_2013_01_08_new_goto_table.py
index 96f288a6a..c5cab5b61 100644
--- a/modules/webstyle/bin/Makefile.am
+++ b/modules/miscutil/lib/upgrades/invenio_2013_01_08_new_goto_table.py
@@ -1,22 +1,43 @@
+# -*- coding: utf-8 -*-
+##
 ## This file is part of Invenio.
-## Copyright (C) 2007, 2008, 2010, 2011 CERN.
+## Copyright (C) 2013 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
-## General Public License for more details.  
+## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
-bin_SCRIPTS = webdoc
+from invenio.dbquery import run_sql
+
+depends_on = ['invenio_release_1_1_0']
+
+def info():
+    return "New goto table"
 
-EXTRA_DIST = webdoc.in
+def do_upgrade():
+    run_sql("""
+CREATE TABLE IF NOT EXISTS goto (
+  label varchar(150) NOT NULL,
+  plugin varchar(150) NOT NULL,
+  parameters text NOT NULL,
+  creation_date datetime NOT NULL,
+  modification_date datetime NOT NULL,
+  PRIMARY KEY (label),
+  KEY (creation_date),
+  KEY (modification_date)
+) ENGINE=MyISAM;
+""")
 
-CLEANFILES = *~ *.tmp
+def estimate():
+    """  Estimate running time of upgrade in seconds (optional). """
+    return 1
diff --git a/modules/miscutil/sql/tabcreate.sql b/modules/miscutil/sql/tabcreate.sql
index 18206e1bd..76f8d6d69 100644
--- a/modules/miscutil/sql/tabcreate.sql
+++ b/modules/miscutil/sql/tabcreate.sql
@@ -1,4240 +1,4253 @@
 -- This file is part of Invenio.
--- Copyright (C) 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012 CERN.
+-- Copyright (C) 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 CERN.
 --
 -- Invenio is free software; you can redistribute it and/or
 -- modify it under the terms of the GNU General Public License as
 -- published by the Free Software Foundation; either version 2 of the
 -- License, or (at your option) any later version.
 --
 -- Invenio is distributed in the hope that it will be useful, but
 -- WITHOUT ANY WARRANTY; without even the implied warranty of
 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 -- General Public License for more details.
 --
 -- You should have received a copy of the GNU General Public License
 -- along with Invenio; if not, write to the Free Software Foundation, Inc.,
 -- 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
 -- tables for bibliographic records:
 
 CREATE TABLE IF NOT EXISTS bibrec (
   id mediumint(8) unsigned NOT NULL auto_increment,
   creation_date datetime NOT NULL default '0000-00-00',
   modification_date datetime NOT NULL default '0000-00-00',
   PRIMARY KEY  (id),
   KEY creation_date (creation_date),
   KEY modification_date (modification_date)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib00x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib01x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib02x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib03x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib04x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib05x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib06x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib07x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib08x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib09x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib10x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib11x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib12x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib13x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib14x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib15x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib16x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib17x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib18x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib19x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib20x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib21x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib22x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib23x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib24x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib25x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib26x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib27x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib28x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib29x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib30x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib31x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib32x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib33x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib34x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib35x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib36x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib37x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib38x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib39x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib40x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib41x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib42x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib43x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib44x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib45x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib46x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib47x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib48x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib49x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib50x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib51x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib52x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib53x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib54x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib55x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib56x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib57x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib58x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib59x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib60x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib61x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib62x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib63x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib64x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib65x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib66x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib67x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib68x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib69x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib70x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib71x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib72x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib73x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib74x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib75x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib76x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib77x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib78x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib79x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib80x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib81x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib82x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib83x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib84x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib85x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(100)) -- URLs need usually a larger index for speedy lookups
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib86x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib87x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib88x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib89x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib90x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib91x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib92x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib93x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib94x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib95x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib96x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib97x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib98x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bib99x (
   id mediumint(8) unsigned NOT NULL auto_increment,
   tag varchar(6) NOT NULL default '',
   value text NOT NULL,
   PRIMARY KEY  (id),
   KEY kt (tag),
   KEY kv (value(35))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib00x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib01x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib02x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib03x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib04x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib05x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib06x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib07x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib08x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib09x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib10x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib11x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib12x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib13x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib14x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib15x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib16x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib17x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib18x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib19x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib20x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib21x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib22x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib23x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib24x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib25x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib26x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib27x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib28x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib29x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib30x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib31x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib32x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib33x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib34x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib35x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib36x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib37x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib38x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib39x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib40x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib41x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib42x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib43x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib44x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib45x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib46x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib47x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib48x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib49x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib50x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib51x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib52x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib53x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib54x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib55x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib56x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib57x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib58x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib59x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib60x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib61x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib62x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib63x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib64x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib65x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib66x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib67x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib68x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib69x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib70x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib71x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib72x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib73x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib74x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib75x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib76x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib77x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib78x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib79x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib80x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib81x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib82x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib83x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib84x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib85x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib86x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib87x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib88x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib89x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib90x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib91x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib92x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib93x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib94x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib95x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib96x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib97x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib98x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bib99x (
   id_bibrec mediumint(8) unsigned NOT NULL default '0',
   id_bibxxx mediumint(8) unsigned NOT NULL default '0',
   field_number smallint(5) unsigned default NULL,
   KEY id_bibxxx (id_bibxxx),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 -- tables for bibliographic records formatted:
 
 CREATE TABLE IF NOT EXISTS bibfmt (
   id_bibrec int(8) unsigned NOT NULL default '0',
   format varchar(10) NOT NULL default '',
   last_updated datetime NOT NULL default '0000-00-00',
   value longblob,
   PRIMARY KEY  (id_bibrec, format),
   KEY format (format),
   KEY last_updated (last_updated)
 ) ENGINE=MyISAM;
 
 -- tables for index files:
 
 CREATE TABLE IF NOT EXISTS idxINDEX (
   id mediumint(9) unsigned NOT NULL,
   name varchar(50) NOT NULL default '',
   description varchar(255) NOT NULL default '',
   last_updated datetime NOT NULL default '0000-00-00 00:00:00',
   stemming_language varchar(10) NOT NULL default '',
   indexer varchar(10) NOT NULL default 'native',
   PRIMARY KEY  (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxINDEXNAME (
   id_idxINDEX mediumint(9) unsigned NOT NULL,
   ln char(5) NOT NULL default '',
   type char(3) NOT NULL default 'sn',
   value varchar(255) NOT NULL,
   PRIMARY KEY  (id_idxINDEX,ln,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxINDEX_field (
   id_idxINDEX mediumint(9) unsigned NOT NULL,
   id_field mediumint(9) unsigned NOT NULL,
   regexp_punctuation varchar(255) NOT NULL default "[\.\,\:\;\?\!\"]",
   regexp_alphanumeric_separators varchar(255) NOT NULL default "[\!\"\#\$\%\&\'\(\)\*\+\,\-\.\/\:\;\<\=\>\?\@\[\\\]\^\_\`\{\|\}\~]",
   PRIMARY KEY  (id_idxINDEX,id_field)
 ) ENGINE=MyISAM;
 
 -- this comment line here is just to fix the SQL display mode in Emacs '
 
 CREATE TABLE IF NOT EXISTS idxWORD01F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD01R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD02F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD02R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD03F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD03R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD04F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD04R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD05F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD05R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD06F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD06R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD07F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD07R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD08F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD08R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD09F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD09R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD10F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD10R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD11F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD11R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD12F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD12R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD13F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD13R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD14F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD14R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD15F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD15R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD16F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD16R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD17F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD17R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD18F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxWORD18R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR01F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR01R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR02F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR02R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR03F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR03R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR04F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR04R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR05F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR05R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR06F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR06R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR07F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR07R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR08F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR08R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR09F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR09R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR10F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR10R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR11F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR11R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR12F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR12R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR13F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR13R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR14F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR14R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR15F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR15R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR16F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR16R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR17F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR17R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR18F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(100) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPAIR18R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE01F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE01R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE02F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE02R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE03F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE03R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE04F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE04R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE05F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE05R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE06F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE06R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE07F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE07R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE08F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE08R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE09F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE09R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE10F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE10R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE11F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE11R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE12F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE12R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE13F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE13R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE14F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE14R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE15F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE15R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE16F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE16R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE17F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE17R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE18F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term text default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   KEY term (term(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS idxPHRASE18R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 -- tables for ranking:
 
 CREATE TABLE IF NOT EXISTS rnkMETHOD (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(20) NOT NULL default '',
   last_updated datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS rnkMETHODNAME (
   id_rnkMETHOD mediumint(9) unsigned NOT NULL,
   ln char(5) NOT NULL default '',
   type char(3) NOT NULL default 'sn',
   value varchar(255) NOT NULL,
   PRIMARY KEY  (id_rnkMETHOD,ln,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS rnkMETHODDATA (
   id_rnkMETHOD mediumint(9) unsigned NOT NULL,
   relevance_data longblob,
   PRIMARY KEY  (id_rnkMETHOD)
 ) ENGINE=MyISAM;
 
 
 CREATE TABLE IF NOT EXISTS collection_rnkMETHOD (
   id_collection mediumint(9) unsigned NOT NULL,
   id_rnkMETHOD mediumint(9) unsigned NOT NULL,
   score tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY  (id_collection,id_rnkMETHOD)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS rnkWORD01F (
   id mediumint(9) unsigned NOT NULL auto_increment,
   term varchar(50) default NULL,
   hitlist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY term (term)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS rnkWORD01R (
   id_bibrec mediumint(9) unsigned NOT NULL,
   termlist longblob,
   type enum('CURRENT','FUTURE','TEMPORARY') NOT NULL default 'CURRENT',
   PRIMARY KEY  (id_bibrec,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS rnkAUTHORDATA (
   aterm varchar(50) default NULL,
   hitlist longblob,
   UNIQUE KEY aterm (aterm)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS rnkPAGEVIEWS (
   id_bibrec mediumint(8) unsigned default NULL,
   id_user int(15) unsigned default '0',
   client_host int(10) unsigned default NULL,
   view_time datetime default '0000-00-00 00:00:00',
   KEY view_time (view_time),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS rnkDOWNLOADS (
   id_bibrec mediumint(8) unsigned default NULL,
   download_time datetime default '0000-00-00 00:00:00',
   client_host int(10) unsigned default NULL,
   id_user int(15) unsigned default NULL,
   id_bibdoc mediumint(9) unsigned default NULL,
   file_version smallint(2) unsigned default NULL,
   file_format varchar(10) NULL default NULL,
   KEY download_time (download_time),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 -- a table for citations. record-cites-record
 
 CREATE TABLE IF NOT EXISTS rnkCITATIONDATA (
   id mediumint(8) unsigned NOT NULL auto_increment,
   object_name varchar(255) NOT NULL,
   object_value longblob,
   last_updated datetime NOT NULL default '0000-00-00',
   PRIMARY KEY id (id),
   UNIQUE KEY object_name (object_name)
 ) ENGINE=MyISAM;
 
 -- a table for missing citations. This should be scanned by a program
 -- occasionally to check if some publication has been cited more than
 -- 50 times (or such), and alert cataloguers to create record for that
 -- external citation
 --
 -- id_bibrec is the id of the record. extcitepubinfo is publication info
 -- that looks in general like hep-th/0112088
 CREATE TABLE IF NOT EXISTS rnkCITATIONDATAEXT (
   id_bibrec int(8) unsigned,
   extcitepubinfo varchar(255) NOT NULL,
   PRIMARY KEY (id_bibrec, extcitepubinfo),
   KEY extcitepubinfo (extcitepubinfo)
 ) ENGINE=MyISAM;
 
 -- tables for self-citations computation
 
 CREATE TABLE IF NOT EXISTS `rnkRECORDSCACHE` (
   `id_bibrec` int(10) unsigned NOT NULL,
   `authorid` bigint(10) NOT NULL,
   PRIMARY KEY (`id_bibrec`,`authorid`)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS `rnkEXTENDEDAUTHORS` (
   `id` int(10) unsigned NOT NULL,
   `authorid` bigint(10) NOT NULL,
   PRIMARY KEY (`id`,`authorid`)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS `rnkSELFCITES` (
   `id_bibrec` int(10) unsigned NOT NULL,
   `count` int(10) unsigned NOT NULL,
   `references` text NOT NULL,
   `last_updated` datetime NOT NULL,
   PRIMARY KEY (`id_bibrec`)
 ) ENGINE=MyISAM;
 
 -- a table for storing invalid or ambiguous references encountered
 CREATE TABLE IF NOT EXISTS rnkCITATIONDATAERR (
   `type` ENUM('multiple-matches', 'not-well-formed'),
   citinfo varchar(255) NOT NULL default '',
   PRIMARY KEY (`type`, citinfo)
 ) ENGINE=MyISAM;
 
 -- tables for collections and collection tree:
 
 CREATE TABLE IF NOT EXISTS collection (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   dbquery text,
   nbrecs int(10) unsigned default '0',
   reclist longblob,
   PRIMARY KEY  (id),
   UNIQUE KEY name (name),
   KEY dbquery (dbquery(50))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS collectionname (
   id_collection mediumint(9) unsigned NOT NULL,
   ln char(5) NOT NULL default '',
   type char(3) NOT NULL default 'sn',
   value varchar(255) NOT NULL,
   PRIMARY KEY  (id_collection,ln,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS collection_collection (
   id_dad mediumint(9) unsigned NOT NULL,
   id_son mediumint(9) unsigned NOT NULL,
   type char(1) NOT NULL default 'r',
   score tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY (id_dad,id_son)
 ) ENGINE=MyISAM;
 
 -- tables for OAI sets:
 
 CREATE TABLE IF NOT EXISTS oaiREPOSITORY (
   id mediumint(9) unsigned NOT NULL auto_increment,
   setName varchar(255) NOT NULL default '',
   setSpec varchar(255) NOT NULL default 'GLOBAL_SET',
   setCollection varchar(255) NOT NULL default '',
   setDescription text NOT NULL default '',
   setDefinition text NOT NULL default '',
   setRecList longblob,
   p1 text NOT NULL default '',
   f1 text NOT NULL default '',
   m1 text NOT NULL default '',
   p2 text NOT NULL default '',
   f2 text NOT NULL default '',
   m2 text NOT NULL default '',
   p3 text NOT NULL default '',
   f3 text NOT NULL default '',
   m3 text NOT NULL default '',
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS oaiHARVEST (
   id mediumint(9) unsigned NOT NULL auto_increment,
   baseurl varchar(255) NOT NULL default '',
   metadataprefix varchar(255) NOT NULL default 'oai_dc',
   arguments text,
   comment text,
   bibconvertcfgfile varchar(255),
   name varchar(255) NOT NULL,
   lastrun datetime,
   frequency mediumint(12) NOT NULL default '0',
   postprocess varchar(20) NOT NULL default 'h',
   bibfilterprogram varchar(255) NOT NULL default '',
   setspecs text NOT NULL default '',
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS oaiHARVESTLOG (
   id_oaiHARVEST mediumint(9) unsigned NOT NULL REFERENCES oaiHARVEST, -- source we harvest from
   id_bibrec mediumint(8) unsigned NOT NULL default '0', -- internal record id ( filled by bibupload )
   bibupload_task_id int NOT NULL default 0, -- bib upload task number
   oai_id varchar(40) NOT NULL default "", -- OAI record identifier we harvested
   date_harvested datetime NOT NULL default '0000-00-00', -- when we harvested
   date_inserted datetime NOT NULL default '0000-00-00', -- when it was inserted
   inserted_to_db char(1) NOT NULL default 'P', -- where it was inserted (P=prod, H=holding-pen, etc)
   PRIMARY KEY (bibupload_task_id, oai_id, date_harvested)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibHOLDINGPEN (
   changeset_id INT NOT NULL AUTO_INCREMENT, -- the identifier of the changeset stored in the holding pen
   changeset_date datetime NOT NULL DEFAULT '0000:00:00 00:00:00', -- when was the changeset inserted
   changeset_xml TEXT NOT NULL DEFAULT '',
   oai_id varchar(40) NOT NULL DEFAULT '', -- OAI identifier of concerned record
   id_bibrec mediumint(8) unsigned NOT NULL default '0', -- record ID of concerned record (filled by bibupload)
   PRIMARY KEY (changeset_id),
   KEY changeset_date (changeset_date),
   KEY id_bibrec (id_bibrec)
 ) ENGINE=MyISAM;
 
 -- tables for portal elements:
 
 CREATE TABLE IF NOT EXISTS collection_portalbox (
   id_collection mediumint(9) unsigned NOT NULL,
   id_portalbox mediumint(9) unsigned NOT NULL,
   ln char(5) NOT NULL default '',
   position char(3) NOT NULL default 'top',
   score tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY  (id_collection,id_portalbox,ln)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS portalbox (
   id mediumint(9) unsigned NOT NULL auto_increment,
   title text NOT NULL,
   body text NOT NULL,
   UNIQUE KEY id (id)
 ) ENGINE=MyISAM;
 
 -- tables for search examples:
 
 CREATE TABLE IF NOT EXISTS collection_example (
   id_collection mediumint(9) unsigned NOT NULL,
   id_example mediumint(9) unsigned NOT NULL,
   score tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY  (id_collection,id_example)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS example (
   id mediumint(9) unsigned NOT NULL auto_increment,
   type text NOT NULL default '',
   body text NOT NULL,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 -- tables for collection formats:
 
 CREATE TABLE IF NOT EXISTS collection_format (
   id_collection mediumint(9) unsigned NOT NULL,
   id_format mediumint(9) unsigned NOT NULL,
   score tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY  (id_collection,id_format)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS format (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   code varchar(6) NOT NULL,
   description varchar(255) default '',
   content_type varchar(255) default '',
   visibility tinyint NOT NULL default '1',
   last_updated datetime NOT NULL default '0000-00-00',
   PRIMARY KEY  (id),
   UNIQUE KEY code (code)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS formatname (
   id_format mediumint(9) unsigned NOT NULL,
   ln char(5) NOT NULL default '',
   type char(3) NOT NULL default 'sn',
   value varchar(255) NOT NULL,
   PRIMARY KEY  (id_format,ln,type)
 ) ENGINE=MyISAM;
 
 -- tables for collection detailed page options
 
 CREATE TABLE IF NOT EXISTS collectiondetailedrecordpagetabs (
   id_collection mediumint(9) unsigned NOT NULL,
   tabs varchar(255) NOT NULL default '',
   PRIMARY KEY (id_collection)
 ) ENGINE=MyISAM;
 
 -- tables for search options and MARC tags:
 
 CREATE TABLE IF NOT EXISTS collection_field_fieldvalue (
   id_collection mediumint(9) unsigned NOT NULL,
   id_field mediumint(9) unsigned NOT NULL,
   id_fieldvalue mediumint(9) unsigned,
   type char(3) NOT NULL default 'src',
   score tinyint(4) unsigned NOT NULL default '0',
   score_fieldvalue tinyint(4) unsigned NOT NULL default '0',
   KEY id_collection (id_collection),
   KEY id_field (id_field),
   KEY id_fieldvalue (id_fieldvalue)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS field (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   code varchar(255) NOT NULL,
   PRIMARY KEY  (id),
   UNIQUE KEY code (code)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS fieldname (
   id_field mediumint(9) unsigned NOT NULL,
   ln char(5) NOT NULL default '',
   type char(3) NOT NULL default 'sn',
   value varchar(255) NOT NULL,
   PRIMARY KEY  (id_field,ln,type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS fieldvalue (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   value text NOT NULL,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS field_tag (
   id_field mediumint(9) unsigned NOT NULL,
   id_tag mediumint(9) unsigned NOT NULL,
   score tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY  (id_field,id_tag)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS tag (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   value char(6) NOT NULL,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 -- tables for file management
 
 CREATE TABLE IF NOT EXISTS bibdoc (
   id mediumint(9) unsigned NOT NULL auto_increment,
   status text NOT NULL default '',
   docname varchar(250) COLLATE utf8_bin NOT NULL default 'file',
   creation_date datetime NOT NULL default '0000-00-00',
   modification_date datetime NOT NULL default '0000-00-00',
   text_extraction_date datetime NOT NULL default '0000-00-00',
   more_info mediumblob NULL default NULL,
   PRIMARY KEY  (id),
   KEY docname (docname),
   KEY creation_date (creation_date),
   KEY modification_date (modification_date)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibrec_bibdoc (
   id_bibrec mediumint(9) unsigned NOT NULL default '0',
   id_bibdoc mediumint(9) unsigned NOT NULL default '0',
   type varchar(255),
   KEY  (id_bibrec),
   KEY  (id_bibdoc)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibdoc_bibdoc (
   id_bibdoc1 mediumint(9) unsigned NOT NULL,
   id_bibdoc2 mediumint(9) unsigned NOT NULL,
   type varchar(255),
   KEY  (id_bibdoc1),
   KEY  (id_bibdoc2)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bibdocfsinfo (
   id_bibdoc mediumint(9) unsigned NOT NULL,
   version tinyint(4) unsigned NOT NULL,
   format varchar(50) NOT NULL,
   last_version boolean NOT NULL,
   cd datetime NOT NULL,
   md datetime NOT NULL,
   checksum char(32) NOT NULL,
   filesize bigint(15) unsigned NOT NULL,
   mime varchar(100) NOT NULL,
   master_format varchar(50) NULL default NULL,
   PRIMARY KEY (id_bibdoc, version, format),
   KEY (last_version),
   KEY (format),
   KEY (cd),
   KEY (md),
   KEY (filesize),
   KEY (mime)
 ) ENGINE=MyISAM;
 
 -- tables for publication requests:
 
 CREATE TABLE IF NOT EXISTS publreq (
   id int(11) NOT NULL auto_increment,
   host varchar(255) NOT NULL default '',
   date varchar(255) NOT NULL default '',
   name varchar(255) NOT NULL default '',
   email varchar(255) NOT NULL default '',
   address text NOT NULL,
   publication text NOT NULL,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 -- table for sessions and users:
 
 CREATE TABLE IF NOT EXISTS session (
   session_key varchar(32) NOT NULL default '',
   session_expiry datetime NOT NULL default '0000-00-00 00:00:00',
   session_object longblob,
   uid int(15) unsigned NOT NULL,
   UNIQUE KEY session_key (session_key),
   KEY uid (uid),
   KEY session_expiry (session_expiry)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS user (
   id int(15) unsigned NOT NULL auto_increment,
   email varchar(255) NOT NULL default '',
   password blob NOT NULL,
   note varchar(255) default NULL,
   settings blob default NULL,
   nickname varchar(255) NOT NULL default '',
   last_login datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY id (id),
   KEY email (email),
   KEY nickname (nickname)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS userEXT (
   id varbinary(255) NOT NULL,
   method varchar(50) NOT NULL,
   id_user int(15) unsigned NOT NULL,
   PRIMARY KEY (id, method),
   UNIQUE KEY (id_user, method)
 ) ENGINE=MyISAM;
 
 
 -- tables for usergroups
 
 CREATE TABLE IF NOT EXISTS usergroup (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL default '',
   description text default '',
   join_policy char(2) NOT NULL default '',
   login_method varchar(255) NOT NULL default 'INTERNAL',
   PRIMARY KEY  (id),
   UNIQUE KEY login_method_name (login_method(70), name),
   KEY name (name)
 ) ENGINE=MyISAM;
 
 
 CREATE TABLE IF NOT EXISTS user_usergroup (
   id_user int(15) unsigned NOT NULL default '0',
   id_usergroup int(15) unsigned NOT NULL default '0',
   user_status char(1) NOT NULL default '',
   user_status_date datetime NOT NULL default '0000-00-00 00:00:00',
   KEY id_user (id_user),
   KEY id_usergroup (id_usergroup)
 ) ENGINE=MyISAM;
 
 -- tables for access control engine
 
 CREATE TABLE IF NOT EXISTS accROLE (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(32),
   description varchar(255),
   firerole_def_ser blob NULL,
   firerole_def_src text NULL,
   PRIMARY KEY (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS user_accROLE (
   id_user int(15) unsigned NOT NULL,
   id_accROLE int(15) unsigned NOT NULL,
   expiration datetime NOT NULL default '9999-12-31 23:59:59',
   PRIMARY KEY (id_user, id_accROLE)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS accMAILCOOKIE (
   id int(15) unsigned NOT NULL auto_increment,
   data blob NOT NULL,
   expiration datetime NOT NULL default '9999-12-31 23:59:59',
   kind varchar(32) NOT NULL,
   onetime boolean NOT NULL default 0,
   status char(1) NOT NULL default 'W',
   PRIMARY KEY (id),
   KEY expiration (expiration)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS accACTION (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(32),
   description varchar(255),
   allowedkeywords varchar(255),
   optional ENUM ('yes', 'no') NOT NULL default 'no',
   PRIMARY KEY (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS accARGUMENT (
   id int(15) unsigned NOT NULL auto_increment,
   keyword varchar (32),
   value varchar(255),
   PRIMARY KEY (id),
   KEY KEYVAL (keyword, value)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS accROLE_accACTION_accARGUMENT (
   id_accROLE int(15),
   id_accACTION int(15),
   id_accARGUMENT int(15),
   argumentlistid mediumint(8),
   KEY id_accROLE     (id_accROLE),
   KEY id_accACTION   (id_accACTION),
   KEY id_accARGUMENT (id_accARGUMENT)
 ) ENGINE=MyISAM;
 
 -- tables for personal/collaborative features (baskets, alerts, searches, messages, usergroups):
 
 CREATE TABLE IF NOT EXISTS user_query (
   id_user int(15) unsigned NOT NULL default '0',
   id_query int(15) unsigned NOT NULL default '0',
   hostname varchar(50) default 'unknown host',
   date datetime default NULL,
   KEY id_user (id_user,id_query)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS query (
   id int(15) unsigned NOT NULL auto_increment,
   type char(1) NOT NULL default 'r',
   urlargs text NOT NULL,
   PRIMARY KEY  (id),
   KEY urlargs (urlargs(100))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS user_query_basket (
   id_user int(15) unsigned NOT NULL default '0',
   id_query int(15) unsigned NOT NULL default '0',
   id_basket int(15) unsigned NOT NULL default '0',
   frequency varchar(5) NOT NULL default '',
   date_creation date default NULL,
   date_lastrun date default '0000-00-00',
   alert_name varchar(30) NOT NULL default '',
   alert_desc text default NULL,
   alert_recipient text default NULL,
   notification char(1) NOT NULL default 'y',
   PRIMARY KEY  (id_user,id_query,frequency,id_basket),
   KEY alert_name (alert_name)
 ) ENGINE=MyISAM;
 
 -- baskets
 CREATE TABLE IF NOT EXISTS bskBASKET (
   id int(15) unsigned NOT NULL auto_increment,
   id_owner int(15) unsigned NOT NULL default '0',
   name varchar(50) NOT NULL default '',
   date_modification datetime NOT NULL default '0000-00-00 00:00:00',
   nb_views int(15) NOT NULL default '0',
   PRIMARY KEY  (id),
   KEY id_owner (id_owner),
   KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bskREC (
   id_bibrec_or_bskEXTREC int(16) NOT NULL default '0',
   id_bskBASKET int(15) unsigned NOT NULL default '0',
   id_user_who_added_item int(15) NOT NULL default '0',
   score int(15) NOT NULL default '0',
   date_added datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (id_bibrec_or_bskEXTREC,id_bskBASKET),
   KEY id_bibrec_or_bskEXTREC (id_bibrec_or_bskEXTREC),
   KEY id_bskBASKET (id_bskBASKET),
   KEY score (score),
   KEY date_added (date_added)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bskEXTREC (
   id int(15) unsigned NOT NULL auto_increment,
   external_id int(15) NOT NULL default '0',
   collection_id int(15) unsigned NOT NULL default '0',
   original_url text,
   creation_date datetime NOT NULL default '0000-00-00 00:00:00',
   modification_date datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bskEXTFMT (
    id int(15) unsigned NOT NULL auto_increment,
    id_bskEXTREC int(15) unsigned NOT NULL default '0',
    format varchar(10) NOT NULL default '',
    last_updated datetime NOT NULL default '0000-00-00 00:00:00',
    value longblob,
    PRIMARY KEY (id),
    KEY id_bskEXTREC (id_bskEXTREC),
    KEY format (format)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS user_bskBASKET (
   id_user int(15) unsigned NOT NULL default '0',
   id_bskBASKET int(15) unsigned NOT NULL default '0',
   topic varchar(50) NOT NULL default '',
   PRIMARY KEY  (id_user,id_bskBASKET),
   KEY id_user (id_user),
   KEY id_bskBASKET (id_bskBASKET)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS usergroup_bskBASKET (
   id_usergroup int(15) unsigned NOT NULL default '0',
   id_bskBASKET int(15) unsigned NOT NULL default '0',
   topic varchar(50) NOT NULL default '',
   date_shared datetime NOT NULL default '0000-00-00 00:00:00',
   share_level char(2) NOT NULL default '',
   PRIMARY KEY  (id_usergroup,id_bskBASKET),
   KEY id_usergroup (id_usergroup),
   KEY id_bskBASKET (id_bskBASKET)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bskRECORDCOMMENT (
   id int(15) unsigned NOT NULL auto_increment,
   id_bibrec_or_bskEXTREC int(16) NOT NULL default '0',
   id_bskBASKET int(15) unsigned NOT NULL default '0',
   id_user int(15) unsigned NOT NULL default '0',
   title varchar(255) NOT NULL default '',
   body text NOT NULL,
   date_creation datetime NOT NULL default '0000-00-00 00:00:00',
   priority int(15) NOT NULL default '0',
   in_reply_to_id_bskRECORDCOMMENT int(15) unsigned NOT NULL default '0',
   reply_order_cached_data blob NULL default NULL,
   PRIMARY KEY  (id),
   KEY id_bskBASKET (id_bskBASKET),
   KEY id_bibrec_or_bskEXTREC (id_bibrec_or_bskEXTREC),
   KEY date_creation (date_creation),
   KEY in_reply_to_id_bskRECORDCOMMENT (in_reply_to_id_bskRECORDCOMMENT),
   INDEX (reply_order_cached_data(40))
 ) ENGINE=MyISAM;
 
 -- tables for messaging system
 
 CREATE TABLE IF NOT EXISTS msgMESSAGE (
   id int(15) unsigned NOT NULL auto_increment,
   id_user_from int(15) unsigned NOT NULL default '0',
   sent_to_user_nicks text NOT NULL default '',
   sent_to_group_names text NOT NULL default '',
   subject text NOT NULL default '',
   body text default NULL,
   sent_date datetime NOT NULL default '0000-00-00 00:00:00',
   received_date datetime NULL default '0000-00-00 00:00:00',
   PRIMARY KEY id (id),
   KEY id_user_from (id_user_from)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS user_msgMESSAGE (
   id_user_to int(15) unsigned NOT NULL default '0',
   id_msgMESSAGE int(15) unsigned NOT NULL default '0',
   status char(1) NOT NULL default 'N',
   PRIMARY KEY id (id_user_to, id_msgMESSAGE),
   KEY id_user_to (id_user_to),
   KEY id_msgMESSAGE (id_msgMESSAGE)
 ) ENGINE=MyISAM;
 
 -- tables for WebComment
 
 CREATE TABLE IF NOT EXISTS cmtRECORDCOMMENT (
   id int(15) unsigned NOT NULL auto_increment,
   id_bibrec int(15) unsigned NOT NULL default '0',
   id_user int(15) unsigned NOT NULL default '0',
   title varchar(255) NOT NULL default '',
   body text NOT NULL default '',
   date_creation datetime NOT NULL default '0000-00-00 00:00:00',
   star_score tinyint(5) unsigned NOT NULL default '0',
   nb_votes_yes int(10) NOT NULL default '0',
   nb_votes_total int(10) unsigned NOT NULL default '0',
   nb_abuse_reports int(10) NOT NULL default '0',
   status char(2) NOT NULL default 'ok',
   round_name varchar(255) NOT NULL default '',
   restriction varchar(50) NOT NULL default '',
   in_reply_to_id_cmtRECORDCOMMENT int(15) unsigned NOT NULL default '0',
   reply_order_cached_data blob NULL default NULL,
   PRIMARY KEY  (id),
   KEY id_bibrec (id_bibrec),
   KEY id_user (id_user),
   KEY status (status),
   KEY in_reply_to_id_cmtRECORDCOMMENT (in_reply_to_id_cmtRECORDCOMMENT),
   INDEX (reply_order_cached_data(40))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS cmtACTIONHISTORY (
   id_cmtRECORDCOMMENT int(15) unsigned NULL,
   id_bibrec int(15) unsigned NULL,
   id_user int(15) unsigned NULL default NULL,
   client_host int(10) unsigned default NULL,
   action_time datetime NOT NULL default '0000-00-00 00:00:00',
   action_code char(1) NOT NULL,
   KEY id_cmtRECORDCOMMENT (id_cmtRECORDCOMMENT),
   KEY client_host (client_host),
   KEY id_user (id_user),
   KEY action_code (action_code)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS cmtSUBSCRIPTION (
   id_bibrec mediumint(8) unsigned NOT NULL,
   id_user int(15) unsigned NOT NULL,
   creation_time datetime NOT NULL default '0000-00-00 00:00:00',
   KEY id_user (id_bibrec, id_user)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS cmtCOLLAPSED (
   id_bibrec int(15) unsigned NOT NULL default '0',
   id_cmtRECORDCOMMENT int(15) unsigned NULL,
   id_user int(15) unsigned NOT NULL,
   PRIMARY KEY (id_user, id_bibrec, id_cmtRECORDCOMMENT)
 ) ENGINE=MyISAM;
 
 -- tables for BibKnowledge:
 
 CREATE TABLE IF NOT EXISTS knwKB (
   id mediumint(8) unsigned NOT NULL auto_increment,
   name varchar(255) default '',
   description text default '',
   kbtype char default NULL,
   PRIMARY KEY  (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS knwKBRVAL (
   id mediumint(8) unsigned NOT NULL auto_increment,
   m_key varchar(255) NOT NULL default '',
   m_value text NOT NULL default '',
   id_knwKB mediumint(8) NOT NULL default '0',
   PRIMARY KEY  (id),
   KEY id_knwKB (id_knwKB),
   KEY m_key (m_key(30)),
   KEY m_value (m_value(30))
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS knwKBDDEF (
   id_knwKB mediumint(8) unsigned NOT NULL,
   id_collection mediumint(9),
   output_tag text default '',
   search_expression text default '',
   PRIMARY KEY  (id_knwKB)
 ) ENGINE=MyISAM;
 
 -- tables for WebSubmit:
 
 CREATE TABLE IF NOT EXISTS sbmACTION (
   lactname text,
   sactname char(3) NOT NULL default '',
   dir text,
   cd date default NULL,
   md date default NULL,
   actionbutton text,
   statustext text,
   PRIMARY KEY  (sactname)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmALLFUNCDESCR (
   function varchar(40) NOT NULL default '',
   description tinytext,
   PRIMARY KEY  (function)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmAPPROVAL (
   doctype varchar(10) NOT NULL default '',
   categ varchar(50) NOT NULL default '',
   rn varchar(50) NOT NULL default '',
   status varchar(10) NOT NULL default '',
   dFirstReq datetime NOT NULL default '0000-00-00 00:00:00',
   dLastReq datetime NOT NULL default '0000-00-00 00:00:00',
   dAction datetime NOT NULL default '0000-00-00 00:00:00',
   access varchar(20) NOT NULL default '0',
   note text NOT NULL default '',
   PRIMARY KEY  (rn)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmCPLXAPPROVAL (
   doctype varchar(10) NOT NULL default '',
   categ varchar(50) NOT NULL default '',
   rn varchar(50) NOT NULL default '',
   type varchar(10) NOT NULL,
   status varchar(10) NOT NULL,
   id_group int(15) unsigned NOT NULL default '0',
   id_bskBASKET int(15) unsigned NOT NULL default '0',
   id_EdBoardGroup int(15) unsigned NOT NULL default '0',
   dFirstReq datetime NOT NULL default '0000-00-00 00:00:00',
   dLastReq datetime NOT NULL default '0000-00-00 00:00:00',
   dEdBoardSel datetime NOT NULL default '0000-00-00 00:00:00',
   dRefereeSel datetime NOT NULL default '0000-00-00 00:00:00',
   dRefereeRecom datetime NOT NULL default '0000-00-00 00:00:00',
   dEdBoardRecom datetime NOT NULL default '0000-00-00 00:00:00',
   dPubComRecom datetime NOT NULL default '0000-00-00 00:00:00',
   dProjectLeaderAction datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (rn, type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmCOLLECTION (
   id int(11) NOT NULL auto_increment,
   name varchar(100) NOT NULL default '',
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmCOLLECTION_sbmCOLLECTION (
   id_father int(11) NOT NULL default '0',
   id_son int(11) NOT NULL default '0',
   catalogue_order int(11) NOT NULL default '0'
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmCOLLECTION_sbmDOCTYPE (
   id_father int(11) NOT NULL default '0',
   id_son char(10) NOT NULL default '0',
   catalogue_order int(11) NOT NULL default '0'
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmCATEGORIES (
   doctype varchar(10) NOT NULL default '',
   sname varchar(75) NOT NULL default '',
   lname varchar(75) NOT NULL default '',
   score tinyint unsigned NOT NULL default 0,
   PRIMARY KEY (doctype, sname),
   KEY doctype (doctype),
   KEY sname (sname)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmCHECKS (
   chname varchar(15) NOT NULL default '',
   chdesc text,
   cd date default NULL,
   md date default NULL,
   chefi1 text,
   chefi2 text,
   PRIMARY KEY  (chname)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmDOCTYPE (
   ldocname text,
   sdocname varchar(10) default NULL,
   cd date default NULL,
   md date default NULL,
   description text
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmFIELD (
   subname varchar(13) default NULL,
   pagenb int(11) default NULL,
   fieldnb int(11) default NULL,
   fidesc varchar(15) default NULL,
   fitext text,
   level char(1) default NULL,
   sdesc text,
   checkn text,
   cd date default NULL,
   md date default NULL,
   fiefi1 text,
   fiefi2 text
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmFIELDDESC (
   name varchar(15) NOT NULL default '',
   alephcode varchar(50) default NULL,
   marccode varchar(50) NOT NULL default '',
   type char(1) default NULL,
   size int(11) default NULL,
   rows int(11) default NULL,
   cols int(11) default NULL,
   maxlength int(11) default NULL,
   val text,
   fidesc text,
   cd date default NULL,
   md date default NULL,
   modifytext text,
   fddfi2 text,
   cookie int(11) default '0',
   PRIMARY KEY  (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmFORMATEXTENSION (
   FILE_FORMAT text NOT NULL,
   FILE_EXTENSION text NOT NULL
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmFUNCTIONS (
   action varchar(10) NOT NULL default '',
   doctype varchar(10) NOT NULL default '',
   function varchar(40) NOT NULL default '',
   score int(11) NOT NULL default '0',
   step tinyint(4) NOT NULL default '1'
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmFUNDESC (
   function varchar(40) NOT NULL default '',
   param varchar(40) default NULL
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmGFILERESULT (
   FORMAT text NOT NULL,
   RESULT text NOT NULL
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmIMPLEMENT (
   docname varchar(10) default NULL,
   actname char(3) default NULL,
   displayed char(1) default NULL,
   subname varchar(13) default NULL,
   nbpg int(11) default NULL,
   cd date default NULL,
   md date default NULL,
   buttonorder int(11) default NULL,
   statustext text,
   level char(1) NOT NULL default '',
   score int(11) NOT NULL default '0',
   stpage int(11) NOT NULL default '0',
   endtxt varchar(100) NOT NULL default ''
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmPARAMETERS (
   doctype varchar(10) NOT NULL default '',
   name varchar(40) NOT NULL default '',
   value text NOT NULL default '',
   PRIMARY KEY  (doctype,name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmPUBLICATION (
   doctype varchar(10) NOT NULL default '',
   categ varchar(50) NOT NULL default '',
   rn varchar(50) NOT NULL default '',
   status varchar(10) NOT NULL default '',
   dFirstReq datetime NOT NULL default '0000-00-00 00:00:00',
   dLastReq datetime NOT NULL default '0000-00-00 00:00:00',
   dAction datetime NOT NULL default '0000-00-00 00:00:00',
   accessref varchar(20) NOT NULL default '',
   accessedi varchar(20) NOT NULL default '',
   access varchar(20) NOT NULL default '',
   referees varchar(50) NOT NULL default '',
   authoremail varchar(50) NOT NULL default '',
   dRefSelection datetime NOT NULL default '0000-00-00 00:00:00',
   dRefRec datetime NOT NULL default '0000-00-00 00:00:00',
   dEdiRec datetime NOT NULL default '0000-00-00 00:00:00',
   accessspo varchar(20) NOT NULL default '',
   journal varchar(100) default NULL,
   PRIMARY KEY  (doctype,categ,rn)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmPUBLICATIONCOMM (
   id int(11) NOT NULL auto_increment,
   id_parent int(11) default '0',
   rn varchar(100) NOT NULL default '',
   firstname varchar(100) default NULL,
   secondname varchar(100) default NULL,
   email varchar(100) default NULL,
   date varchar(40) NOT NULL default '',
   synopsis varchar(255) NOT NULL default '',
   commentfulltext text,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmPUBLICATIONDATA (
   doctype varchar(10) NOT NULL default '',
   editoboard varchar(250) NOT NULL default '',
   base varchar(10) NOT NULL default '',
   logicalbase varchar(10) NOT NULL default '',
   spokesperson varchar(50) NOT NULL default '',
   PRIMARY KEY  (doctype)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmREFEREES (
   doctype varchar(10) NOT NULL default '',
   categ varchar(10) NOT NULL default '',
   name varchar(50) NOT NULL default '',
   address varchar(50) NOT NULL default '',
   rid int(11) NOT NULL auto_increment,
   PRIMARY KEY  (rid)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmSUBMISSIONS (
   email varchar(50) NOT NULL default '',
   doctype varchar(10) NOT NULL default '',
   action varchar(10) NOT NULL default '',
   status varchar(10) NOT NULL default '',
   id varchar(30) NOT NULL default '',
   reference varchar(40) NOT NULL default '',
   cd datetime NOT NULL default '0000-00-00 00:00:00',
   md datetime NOT NULL default '0000-00-00 00:00:00'
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS sbmCOOKIES (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(100) NOT NULL,
   value text,
   uid int(15) NOT NULL,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
 
 -- Scheduler tables
 
 CREATE TABLE IF NOT EXISTS schTASK (
   id int(15) unsigned NOT NULL auto_increment,
   proc varchar(255) NOT NULL,
   host varchar(255) NOT NULL default '',
   user varchar(50) NOT NULL,
   runtime datetime NOT NULL,
   sleeptime varchar(20),
   arguments mediumblob,
   status varchar(50),
   progress varchar(255),
   priority tinyint(4) NOT NULL default 0,
   sequenceid int(8) NULL default NULL,
   PRIMARY KEY  (id),
   KEY status (status),
   KEY runtime (runtime),
   KEY priority (priority),
   KEY sequenceid (sequenceid)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS hstTASK (
   id int(15) unsigned NOT NULL,
   proc varchar(255) NOT NULL,
   host varchar(255) NOT NULL default '',
   user varchar(50) NOT NULL,
   runtime datetime NOT NULL,
   sleeptime varchar(20),
   arguments mediumblob,
   status varchar(50),
   progress varchar(255),
   priority tinyint(4) NOT NULL default 0,
   sequenceid int(8) NULL default NULL,
   PRIMARY KEY  (id),
   KEY status (status),
   KEY runtime (runtime),
   KEY priority (priority),
   KEY sequenceid (sequenceid)
 ) ENGINE=MyISAM;
 
 -- Batch Upload History
 
 CREATE TABLE IF NOT EXISTS hstBATCHUPLOAD (
   id int(15) unsigned NOT NULL auto_increment,
   user varchar(50) NOT NULL,
   submitdate datetime NOT NULL,
   filename varchar(255) NOT NULL,
   execdate datetime NOT NULL,
   id_schTASK int(15) unsigned NOT NULL,
   batch_mode varchar(15) NOT NULL,
   PRIMARY KEY (id),
   KEY user (user)
 ) ENGINE=MyISAM;
 
 -- External collections
 
 CREATE TABLE IF NOT EXISTS collection_externalcollection (
   id_collection         mediumint(9) unsigned NOT NULL default '0',
   id_externalcollection mediumint(9) unsigned NOT NULL default '0',
   type tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY (id_collection, id_externalcollection)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS externalcollection (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL default '',
   PRIMARY KEY (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 -- WebStat tables:
 
 CREATE TABLE IF NOT EXISTS staEVENT (
   id varchar(255) NOT NULL,
   number smallint(2) unsigned ZEROFILL NOT NULL auto_increment,
   name varchar(255),
   creation_time TIMESTAMP DEFAULT NOW(),
   cols varchar(255),
   PRIMARY KEY  (id),
   UNIQUE KEY number (number)
 ) ENGINE=MyISAM;
 
 -- BibClassify tables:
 
 CREATE TABLE IF NOT EXISTS clsMETHOD (
   id mediumint(9) unsigned NOT NULL,
   name varchar(50) NOT NULL default '',
   location varchar(255) NOT NULL default '',
   description varchar(255) NOT NULL default '',
   last_updated datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS collection_clsMETHOD (
   id_collection mediumint(9) unsigned NOT NULL,
   id_clsMETHOD mediumint(9) unsigned NOT NULL,
   PRIMARY KEY  (id_collection, id_clsMETHOD)
 ) ENGINE=MyISAM;
 
 -- WebJournal tables:
 
 CREATE TABLE IF NOT EXISTS jrnJOURNAL (
   id mediumint(9) unsigned NOT NULL auto_increment,
   name varchar(50) NOT NULL default '',
   PRIMARY KEY (id),
   UNIQUE KEY name (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS jrnISSUE (
   id_jrnJOURNAL mediumint(9) unsigned NOT NULL,
   issue_number varchar(50) NOT NULL default '',
   issue_display varchar(50) NOT NULL default '',
   date_released datetime NOT NULL default '0000-00-00 00:00:00',
   date_announced datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY (id_jrnJOURNAL,issue_number)
 ) ENGINE=MyISAM;
 
 -- tables recording history of record's metadata and fulltext documents:
 
 CREATE TABLE IF NOT EXISTS hstRECORD (
   id_bibrec mediumint(8) unsigned NOT NULL,
   marcxml longblob NOT NULL,
   job_id mediumint(15) unsigned NOT NULL,
   job_name varchar(255) NOT NULL,
   job_person varchar(255) NOT NULL,
   job_date datetime NOT NULL,
   job_details blob NOT NULL,
   KEY (id_bibrec),
   KEY (job_id),
   KEY (job_name),
   KEY (job_person),
   KEY (job_date)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS hstDOCUMENT (
   id_bibdoc mediumint(9) unsigned NOT NULL,
   docname varchar(250) NOT NULL,
   docformat varchar(50) NOT NULL,
   docversion tinyint(4) unsigned NOT NULL,
   docsize bigint(15) unsigned NOT NULL,
   docchecksum char(32) NOT NULL,
   doctimestamp datetime NOT NULL,
   action varchar(50) NOT NULL,
   job_id mediumint(15) unsigned NULL default NULL,
   job_name varchar(255) NULL default NULL,
   job_person varchar(255) NULL default NULL,
   job_date datetime NULL default NULL,
   job_details blob NULL default NULL,
   KEY (action),
   KEY (id_bibdoc),
   KEY (docname),
   KEY (docformat),
   KEY (doctimestamp),
   KEY (job_id),
   KEY (job_name),
   KEY (job_person),
   KEY (job_date)
 ) ENGINE=MyISAM;
 
 -- BibCirculation tables:
 
 CREATE TABLE IF NOT EXISTS crcBORROWER (
   id int(15) unsigned NOT NULL auto_increment,
   ccid int(15) unsigned NULL default NULL,
   name varchar(255) NOT NULL default '',
   email varchar(255) NOT NULL default '',
   phone varchar(60) default NULL,
   address varchar(60) default NULL,
   mailbox varchar(30) default NULL,
   borrower_since datetime NOT NULL default '0000-00-00 00:00:00',
   borrower_until datetime NOT NULL default '0000-00-00 00:00:00',
   notes text,
   PRIMARY KEY  (id),
   UNIQUE KEY (ccid),
   KEY (name),
   KEY (email)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS crcILLREQUEST (
   id int(15) unsigned NOT NULL auto_increment,
   id_crcBORROWER int(15) unsigned NOT NULL default '0',
   barcode varchar(30) NOT NULL default '',
   period_of_interest_from datetime NOT NULL default '0000-00-00 00:00:00',
   period_of_interest_to datetime NOT NULL default '0000-00-00 00:00:00',
   id_crcLIBRARY int(15) unsigned NOT NULL default '0',
   request_date datetime NOT NULL default '0000-00-00 00:00:00',
   expected_date datetime NOT NULL default '0000-00-00 00:00:00',
   arrival_date datetime NOT NULL default '0000-00-00 00:00:00',
   due_date datetime NOT NULL default '0000-00-00 00:00:00',
   return_date datetime NOT NULL default '0000-00-00 00:00:00',
   status varchar(20) NOT NULL default '',
   cost varchar(30) NOT NULL default '',
   budget_code varchar(60) NOT NULL default '',
   item_info text,
   request_type text,
   borrower_comments text,
   only_this_edition varchar(10) NOT NULL default '',
   library_notes text,
   PRIMARY KEY (id),
   KEY id_crcborrower (id_crcBORROWER),
   KEY id_crclibrary (id_crcLIBRARY)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS crcITEM (
   barcode varchar(30) NOT NULL default '',
   id_bibrec int(15) unsigned NOT NULL default '0',
   id_crcLIBRARY int(15) unsigned NOT NULL default '0',
   collection varchar(60) default NULL,
   location varchar(60) default NULL,
   description varchar(60) default NULL,
   loan_period varchar(30) NOT NULL default '',
   status varchar(20) NOT NULL default '',
   expected_arrival_date varchar(60) NOT NULL default '',
   creation_date datetime NOT NULL default '0000-00-00 00:00:00',
   modification_date datetime NOT NULL default '0000-00-00 00:00:00',
   number_of_requests int(3) unsigned NOT NULL default '0',
   PRIMARY KEY (barcode),
   KEY id_bibrec (id_bibrec),
   KEY id_crclibrary (id_crcLIBRARY)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS crcLIBRARY (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(80) NOT NULL default '',
   address varchar(255) NOT NULL default '',
   email varchar(255) NOT NULL default '',
   phone varchar(30) NOT NULL default '',
   type varchar(30) default NULL,
   notes text,
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS crcLOAN (
   id int(15) unsigned NOT NULL auto_increment,
   id_crcBORROWER int(15) unsigned NOT NULL default '0',
   id_bibrec int(15) unsigned NOT NULL default '0',
   barcode varchar(30) NOT NULL default '',
   loaned_on datetime NOT NULL default '0000-00-00 00:00:00',
   returned_on date NOT NULL default '0000-00-00',
   due_date datetime NOT NULL default '0000-00-00 00:00:00',
   number_of_renewals int(3) unsigned NOT NULL default '0',
   overdue_letter_number int(3) unsigned NOT NULL default '0',
   overdue_letter_date datetime NOT NULL default '0000-00-00 00:00:00',
   status varchar(20) NOT NULL default '',
   type varchar(20) NOT NULL default '',
   notes text,
   PRIMARY KEY (id),
   KEY id_crcborrower (id_crcBORROWER),
   KEY id_bibrec (id_bibrec),
   KEY barcode (barcode)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS crcLOANREQUEST (
   id int(15) unsigned NOT NULL auto_increment,
   id_crcBORROWER int(15) unsigned NOT NULL default '0',
   id_bibrec int(15) unsigned NOT NULL default '0',
   barcode varchar(30) NOT NULL default '',
   period_of_interest_from datetime NOT NULL default '0000-00-00 00:00:00',
   period_of_interest_to datetime NOT NULL default '0000-00-00 00:00:00',
   status varchar(20) NOT NULL default '',
   notes text,
   request_date datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY (id),
   KEY id_crcborrower (id_crcBORROWER),
   KEY id_bibrec (id_bibrec),
   KEY barcode (barcode)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS crcPURCHASE (
   id int(15) unsigned NOT NULL auto_increment,
   id_bibrec int(15) unsigned NOT NULL default '0',
   id_crcVENDOR int(15) unsigned NOT NULL default '0',
   ordered_date datetime NOT NULL default '0000-00-00 00:00:00',
   expected_date datetime NOT NULL default '0000-00-00 00:00:00',
   price varchar(20) NOT NULL default '0',
   status varchar(20) NOT NULL default '',
   notes text,
   PRIMARY KEY (id),
   KEY id_bibrec (id_bibrec),
   KEY id_crcVENDOR (id_crcVENDOR)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS crcVENDOR (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(80) NOT NULL default '',
   address varchar(255) NOT NULL default '',
   email varchar(255) NOT NULL default '',
   phone varchar(30) NOT NULL default '',
   notes text,
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 -- BibExport tables:
 
 CREATE TABLE IF NOT EXISTS expJOB (
   id int(15) unsigned NOT NULL auto_increment,
   jobname varchar(50) NOT NULL default '',
   jobfreq mediumint(12) NOT NULL default '0',
   output_format mediumint(12) NOT NULL default '0',
   deleted mediumint(12) NOT NULL default '0',
   lastrun datetime NOT NULL default '0000-00-00 00:00:00',
   output_directory text,
   PRIMARY KEY (id),
   UNIQUE KEY jobname (jobname)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS expQUERY (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   search_criteria text NOT NULL,
   output_fields text NOT NULL,
   notes text,
   deleted mediumint(12) NOT NULL default '0',
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS expJOB_expQUERY (
   id_expJOB int(15) NOT NULL,
   id_expQUERY int(15) NOT NULL,
   PRIMARY KEY (id_expJOB,id_expQUERY),
   KEY id_expJOB (id_expJOB),
   KEY id_expQUERY (id_expQUERY)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS expQUERYRESULT (
   id int(15) unsigned NOT NULL auto_increment,
   id_expQUERY int(15) NOT NULL,
   result text NOT NULL,
   status mediumint(12) NOT NULL default '0',
   status_message text NOT NULL,
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS expJOBRESULT (
   id int(15) unsigned NOT NULL auto_increment,
   id_expJOB int(15) NOT NULL,
   execution_time datetime NOT NULL default '0000-00-00 00:00:00',
   status mediumint(12) NOT NULL default '0',
   status_message text NOT NULL,
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS expJOBRESULT_expQUERYRESULT (
   id_expJOBRESULT int(15) NOT NULL,
   id_expQUERYRESULT int(15) NOT NULL,
   PRIMARY KEY (id_expJOBRESULT, id_expQUERYRESULT),
   KEY id_expJOBRESULT (id_expJOBRESULT),
   KEY id_expQUERYRESULT (id_expQUERYRESULT)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS user_expJOB (
   id_user int(15) NOT NULL,
   id_expJOB int(15) NOT NULL,
   PRIMARY KEY (id_user, id_expJOB),
   KEY id_user (id_user),
   KEY id_expJOB (id_expJOB)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS swrREMOTESERVER (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(50) unique NOT NULL,
   host varchar(50) NOT NULL,
   username varchar(50) NOT NULL,
   password varchar(50) NOT NULL,
   email varchar(50) NOT NULL,
   realm varchar(50) NOT NULL,
   url_base_record varchar(50) NOT NULL,
   url_servicedocument varchar(80) NOT NULL,
   xml_servicedocument longblob,
   last_update int(15) unsigned NOT NULL,
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS swrCLIENTDATA (
   id int(15) unsigned NOT NULL auto_increment,
   id_swrREMOTESERVER int(15) NOT NULL,
   id_record int(15) NOT NULL,
   report_no varchar(50) NOT NULL,
   id_remote varchar(50) NOT NULL,
   id_user int(15) NOT NULL,
   user_name varchar(100) NOT NULL,
   user_email varchar(100) NOT NULL,
   xml_media_deposit longblob NOT NULL,
   xml_metadata_submit longblob NOT NULL,
   submission_date datetime NOT NULL default '0000-00-00 00:00:00',
   publication_date datetime NOT NULL default '0000-00-00 00:00:00',
   removal_date datetime NOT NULL default '0000-00-00 00:00:00',
   link_medias varchar(150) NOT NULL,
   link_metadata varchar(150) NOT NULL,
   link_status varchar(150) NOT NULL,
   status varchar(150) NOT NULL default 'submitted',
   last_update datetime NOT NULL,
   PRIMARY KEY (id)
 ) ENGINE=MyISAM;
 
 -- tables for exception management
 
 -- This table is used to log exceptions
 -- to discover the full details of an exception either check the email
 -- that are sent to CFG_SITE_ADMIN_EMAIL or look into invenio.err
 CREATE TABLE IF NOT EXISTS hstEXCEPTION (
   id int(15) unsigned NOT NULL auto_increment,
   name varchar(50) NOT NULL, -- name of the exception
   filename varchar(255) NULL, -- file where the exception was raised
   line int(9) NULL, -- line at which the exception was raised
   last_seen datetime NOT NULL default '0000-00-00 00:00:00', -- last time this exception has been seen
   last_notified datetime NOT NULL default '0000-00-00 00:00:00', -- last time this exception has been notified
   counter int(15) NOT NULL default 0, -- internal counter to decide when to notify this exception
   total int(15) NOT NULL default 0, -- total number of times this exception has been seen
   PRIMARY KEY (id),
   KEY (last_seen),
   KEY (last_notified),
   KEY (total),
   UNIQUE KEY (name(50), filename(255), line)
 ) ENGINE=MyISAM;
 
 -- tables for BibAuthorID module:
 
 CREATE TABLE IF NOT EXISTS `aidPERSONIDPAPERS` (
   `personid` BIGINT( 16 ) UNSIGNED NOT NULL ,
   `bibref_table` ENUM(  '100',  '700' ) NOT NULL ,
   `bibref_value` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
   `bibrec` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
   `name` VARCHAR( 256 ) NOT NULL ,
   `flag` SMALLINT( 2 ) NOT NULL DEFAULT  '0' ,
   `lcul` SMALLINT( 2 ) NOT NULL DEFAULT  '0' ,
   `last_updated` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
   INDEX `personid-b` (`personid`) ,
   INDEX `reftable-b` (`bibref_table`) ,
   INDEX `refvalue-b` (`bibref_value`) ,
   INDEX `rec-b` (`bibrec`) ,
   INDEX `name-b` (`name`) ,
   INDEX `pn-b` (`personid`, `name`) ,
   INDEX `timestamp-b` (`last_updated`) ,
   INDEX `flag-b` (`flag`) ,
   INDEX `ptvrf-b` (`personid`, `bibref_table`, `bibref_value`, `bibrec`, `flag`)
 ) ENGINE=MYISAM;
 
 CREATE TABLE IF NOT EXISTS `aidRESULTS` (
   `personid` VARCHAR( 256 ) NOT NULL ,
   `bibref_table` ENUM(  '100',  '700' ) NOT NULL ,
   `bibref_value` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
   `bibrec` MEDIUMINT( 8 ) UNSIGNED NOT NULL ,
   INDEX `personid-b` (`personid`) ,
   INDEX `reftable-b` (`bibref_table`) ,
   INDEX `refvalue-b` (`bibref_value`) ,
   INDEX `rec-b` (`bibrec`)
 ) ENGINE=MYISAM;
 
 CREATE TABLE IF NOT EXISTS `aidPERSONIDDATA` (
   `personid` BIGINT( 16 ) UNSIGNED NOT NULL ,
   `tag` VARCHAR( 64 ) NOT NULL ,
   `data` VARCHAR( 256 ) NOT NULL ,
   `opt1` MEDIUMINT( 8 ) NULL DEFAULT NULL ,
   `opt2` MEDIUMINT( 8 ) NULL DEFAULT NULL ,
   `opt3` VARCHAR( 256 ) NULL DEFAULT NULL ,
   INDEX `personid-b` (`personid`) ,
   INDEX `tag-b` (`tag`) ,
   INDEX `data-b` (`data`) ,
   INDEX `opt1` (`opt1`)
 ) ENGINE=MYISAM;
 
 CREATE TABLE IF NOT EXISTS `aidUSERINPUTLOG` (
   `id` bigint(15) NOT NULL AUTO_INCREMENT,
   `transactionid` bigint(15) NOT NULL,
   `timestamp` datetime NOT NULL,
   `userid` int,
   `userinfo` varchar(255) NOT NULL,
   `personid` bigint(15) NOT NULL,
   `action` varchar(50) NOT NULL,
   `tag` varchar(50) NOT NULL,
   `value` varchar(200) NOT NULL,
   `comment` text,
   PRIMARY KEY (`id`),
   INDEX `transactionid-b` (`transactionid`),
   INDEX `timestamp-b` (`timestamp`),
   INDEX `userinfo-b` (`userinfo`),
   INDEX `userid-b` (`userid`),
   INDEX `personid-b` (`personid`),
   INDEX `action-b` (`action`),
   INDEX `tag-b` (`tag`),
   INDEX `value-b` (`value`)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS `aidCACHE` (
   `id` int(15) NOT NULL auto_increment,
   `object_name` varchar(120) NOT NULL,
   `object_key` varchar(120) NOT NULL,
   `object_value` text,
   `last_updated` datetime NOT NULL,
   PRIMARY KEY  (`id`),
   INDEX `name-b` (`object_name`),
   INDEX `key-b` (`object_key`),
   INDEX `last_updated-b` (`last_updated`)
 ) ENGINE=MyISAM;
 
 -- refextract tables:
 
 CREATE TABLE IF NOT EXISTS `xtrJOB` (
   `id` tinyint(4) NOT NULL AUTO_INCREMENT,
   `name` varchar(30) NOT NULL,
   `last_updated` datetime NOT NULL,
   `last_recid` mediumint(8) unsigned NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM;
 
 -- tables for bibsort module
 
 CREATE TABLE IF NOT EXISTS bsrMETHOD (
   id mediumint(8) unsigned NOT NULL auto_increment,
   name varchar(20) NOT NULL,
   definition varchar(255) NOT NULL,
   washer varchar(255) NOT NULL,
   PRIMARY KEY (id),
   UNIQUE KEY (name)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bsrMETHODNAME (
   id_bsrMETHOD mediumint(8) unsigned NOT NULL,
   ln char(5) NOT NULL default '',
   type char(3) NOT NULL default 'sn',
   value varchar(255) NOT NULL,
   PRIMARY KEY (id_bsrMETHOD, ln, type)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bsrMETHODDATA (
   id_bsrMETHOD mediumint(8) unsigned NOT NULL,
   data_dict longblob,
   data_dict_ordered longblob,
   data_list_sorted longblob,
   last_updated datetime,
   PRIMARY KEY (id_bsrMETHOD)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS bsrMETHODDATABUCKET (
   id_bsrMETHOD mediumint(8) unsigned NOT NULL,
   bucket_no tinyint(2) NOT NULL,
   bucket_data longblob,
   bucket_last_value varchar(255),
   last_updated datetime,
   PRIMARY KEY (id_bsrMETHOD, bucket_no)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS collection_bsrMETHOD (
   id_collection mediumint(9) unsigned NOT NULL,
   id_bsrMETHOD mediumint(9) unsigned NOT NULL,
   score tinyint(4) unsigned NOT NULL default '0',
   PRIMARY KEY (id_collection, id_bsrMETHOD)
 ) ENGINE=MyISAM;
 
 -- tables for sequence storage
 CREATE TABLE IF NOT EXISTS seqSTORE (
   id int(15) NOT NULL auto_increment,
   seq_name varchar(15),
   seq_value varchar(20),
   PRIMARY KEY (id),
   UNIQUE KEY seq_name_value (seq_name, seq_value)
 ) ENGINE=MyISAM;
 
 -- tables for linkbacks:
 
 CREATE TABLE IF NOT EXISTS lnkENTRY (
   id int(15) NOT NULL auto_increment,
   origin_url varchar(100) NOT NULL, -- url of the originating resource
   id_bibrec mediumint(8) unsigned NOT NULL, -- bibrecord
   additional_properties longblob,
   type varchar(30) NOT NULL,
   status varchar(30) NOT NULL default 'PENDING',
   insert_time datetime default '0000-00-00 00:00:00',
   PRIMARY KEY (id),
   INDEX (id_bibrec),
   INDEX (type),
   INDEX (status),
   INDEX (insert_time)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS lnkENTRYURLTITLE (
   id int(15) unsigned NOT NULL auto_increment,
   url varchar(100) NOT NULL,
   title varchar(100) NOT NULL,
   manual_set boolean NOT NULL default 0,
   broken_count int(5) default 0,
   broken boolean NOT NULL default 0,
   PRIMARY KEY (id),
   UNIQUE (url),
   INDEX (title)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS lnkENTRYLOG (
   id_lnkENTRY int(15) unsigned NOT NULL,
   id_lnkLOG int(15) unsigned NOT NULL,
   FOREIGN KEY (id_lnkENTRY) REFERENCES lnkENTRY(id),
   FOREIGN KEY (id_lnkLOG) REFERENCES lnkLOG(id)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS lnkLOG (
   id int(15) unsigned NOT NULL auto_increment,
   id_user int(15) unsigned,
   action varchar(30) NOT NULL,
   log_time datetime default '0000-00-00 00:00:00',
   PRIMARY KEY (id),
   INDEX (id_user),
   INDEX (action),
   INDEX (log_time)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS lnkADMINURL (
   id int(15) unsigned NOT NULL auto_increment,
   url varchar(100) NOT NULL,
   list varchar(30) NOT NULL,
   PRIMARY KEY (id),
   UNIQUE (url),
   INDEX (list)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS lnkADMINURLLOG (
   id_lnkADMINURL int(15) unsigned NOT NULL,
   id_lnkLOG int(15) unsigned NOT NULL,
   FOREIGN KEY (id_lnkADMINURL) REFERENCES lnkADMINURL(id),
   FOREIGN KEY (id_lnkLOG) REFERENCES lnkLOG(id)
 ) ENGINE=MyISAM;
 
 -- table for API key
 CREATE TABLE IF NOT EXISTS webapikey (
   id varchar(150) NOT NULL,
   secret varchar(150) NOT NULL,
   id_user int(15) NOT NULL,
   status varchar(25) NOT NULL default 'OK',
   description varchar(255) default NULL,
   PRIMARY KEY (id),
   KEY (id_user),
   KEY (status)
 ) ENGINE=MyISAM;
 
 CREATE TABLE IF NOT EXISTS `wapCACHE` (
   `object_name` varchar(120) NOT NULL,
   `object_key` varchar(120) NOT NULL,
   `object_value` longtext,
   `object_status` varchar(120),
   `last_updated` datetime NOT NULL,
   PRIMARY KEY  (`object_name`,`object_key`),
   INDEX `last_updated-b` (`last_updated`),
   INDEX `status-b` (`object_status`)
 ) ENGINE=MyISAM;
 
+-- tables for goto:
+CREATE TABLE IF NOT EXISTS goto (
+  label varchar(150) NOT NULL,
+  plugin varchar(150) NOT NULL,
+  parameters text NOT NULL,
+  creation_date datetime NOT NULL,
+  modification_date datetime NOT NULL,
+  PRIMARY KEY (label),
+  KEY (creation_date),
+  KEY (modification_date)
+) ENGINE=MyISAM;
+
+-- tables for invenio_upgrader
 CREATE TABLE IF NOT EXISTS upgrade (
   upgrade varchar(255) NOT NULL,
   applied DATETIME NOT NULL,
   PRIMARY KEY (upgrade)
 ) ENGINE=MyISAM;
 
 -- maint-1.1 upgrade recipes:
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_release_1_1_0',NOW());
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_10_31_tablesorter_location',NOW());
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_11_01_lower_user_email',NOW());
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_11_21_aiduserinputlog_userid_check',NOW());
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_11_15_hstRECORD_marcxml_longblob',NOW());
 
 -- master upgrade recipes:
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_10_29_idxINDEX_new_indexer_column',NOW());
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_11_04_circulation_and_linkback_updates',NOW());
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_11_07_xtrjob_last_recid',NOW());
 INSERT INTO upgrade (upgrade, applied) VALUES ('invenio_2012_11_27_new_selfcite_tables',NOW());
 
 -- end of file
diff --git a/modules/webstyle/bin/Makefile.am b/modules/webstyle/bin/Makefile.am
index 96f288a6a..418d1594c 100644
--- a/modules/webstyle/bin/Makefile.am
+++ b/modules/webstyle/bin/Makefile.am
@@ -1,22 +1,22 @@
 ## This file is part of Invenio.
 ## Copyright (C) 2007, 2008, 2010, 2011 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
-## General Public License for more details.  
+## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
-bin_SCRIPTS = webdoc
+bin_SCRIPTS = webdoc gotoadmin
 
-EXTRA_DIST = webdoc.in
+EXTRA_DIST = webdoc.in gotoadmin.in
 
 CLEANFILES = *~ *.tmp
diff --git a/modules/webstyle/bin/Makefile.am b/modules/webstyle/bin/gotoadmin.in
similarity index 70%
copy from modules/webstyle/bin/Makefile.am
copy to modules/webstyle/bin/gotoadmin.in
index 96f288a6a..d06c5b11e 100644
--- a/modules/webstyle/bin/Makefile.am
+++ b/modules/webstyle/bin/gotoadmin.in
@@ -1,22 +1,31 @@
+#!@PYTHON@
+## -*- mode: python; coding: utf-8; -*-
+
 ## This file is part of Invenio.
-## Copyright (C) 2007, 2008, 2010, 2011 CERN.
+## Copyright (C) 2012 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
-## General Public License for more details.  
+## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
-bin_SCRIPTS = webdoc
+"""GOTO CLI interface."""
+
+try:
+    from invenio.goto_engine import main
+except ImportError, e:
+    print "Error: %s" % e
+    import sys
+    sys.exit(1)
 
-EXTRA_DIST = webdoc.in
+main()
 
-CLEANFILES = *~ *.tmp
diff --git a/modules/webstyle/doc/admin/webstyle-admin-guide.webdoc b/modules/webstyle/doc/admin/webstyle-admin-guide.webdoc
index 66057297f..609d44d8d 100644
--- a/modules/webstyle/doc/admin/webstyle-admin-guide.webdoc
+++ b/modules/webstyle/doc/admin/webstyle-admin-guide.webdoc
@@ -1,523 +1,569 @@
 ## -*- mode: html; coding: utf-8; -*-
 
 ## This file is part of Invenio.
 ## Copyright (C) 2007, 2008, 2009, 2010, 2011, 2012 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 ## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
 <!-- WebDoc-Page-Title: WebStyle Admin Guide -->
 <!-- WebDoc-Page-Navtrail: <a class="navtrail" href="<CFG_SITE_URL>/help/admin<lang:link/>">_(Admin Area)_</a> -->
 <!-- WebDoc-Page-Revision: $Id$ -->
 
 <h2>Contents</h2>
 
 <ul style="list-style-type:None">
 <li><strong>1. <a href="#overview_page_layout">Overview</a></strong>
      <ul style="list-style-type:None">
      <li>1.1&nbsp;&nbsp;<a href="#overview_css">CSS Style Sheet and Images</a></li>
      <li>1.2&nbsp;&nbsp;<a href="#overview_page_layout">HTML Page Layout</a>
          <ul style="list-style-type:None">
              <li>1.2.1&nbsp;&nbsp;&nbsp;&nbsp;<a href="#overview_page_layout_stat">Layout of HTML Static Pages</a></li>
              <li>1.2.2&nbsp;&nbsp;&nbsp;&nbsp;<a href="#overview_page_layout_dyn">Layout of Python Dynamic Pages</a></li>
          </ul>
      </li>
      <li>1.3&nbsp;&nbsp;<a href="#overview_bib">Look of Bibliographic References</a></li>
      <li>1.4&nbsp;&nbsp;<a href="#overview_spec_conf">Specific Configurations</a></li>
     </ul>
 </li>
 <li><strong>2. <a href="#det_page">Detailed Record Pages</a></strong>
      <ul style="list-style-type:None">
      <li>2.1&nbsp;&nbsp;<a href="#det_page">Available tabs</a></li>
      <li>2.2&nbsp;&nbsp;<a href="#det_show_hide_tabs">Showing/Hiding tabs</a></li>
      <li>2.3&nbsp;&nbsp;<a href="#det_page_cust_cont_tabs">Customizing content of tabs</a></li>
      <li>2.4&nbsp;&nbsp;<a href="#det_page_cust_look_tabs">Customizing look of tabs</a></li>
      </ul>
 </li>
+<li><strong>3. <a href="#red">Custom Redirections</a></strong>
+     <ul style="list-style-type:None">
+     <li>3.1&nbsp;&nbsp;<a href="#red_cli">Command Line Interface</a></li>
+     </ul>
+</li>
 </ul>
 
 <h2><a name="overview">1. Overview</a></h2>
 <p>This document describes how to change the look and feel of your CDS
 Invenio installation.
 
 <h3><a name="overview_css">1.1 CSS Style Sheet and Images</a></h3>
 
 <p>The most obvious modification you may want to do is the
 modification of <a href="<CFG_SITE_URL>/img/invenio.css">CSS style sheet</a>.
 You may also customize default <a href="<CFG_SITE_URL>/img/">images</a>.</p>
 
 <h3><a name="overview_page_layout">1.2 HTML Page Layout</a></h3>
 
 <p>The customization of the general page look and feel is currently
 different depending on whether you customize HTML-like static pages
 or dynamic Python pages.</p>
 
 <p>Dynamic HTML pages are used to build the 'interactive' parts of the
 website, such as the search and browse pages, as well as the admin
 pages. The content of these pages is defined at run time, depending on
 the users parameters. You can modify them to provide a totally
 different experience to your users when browsing <CFG_SITE_NAME>. Most
 probably, you will only want to customize 'webstyle_templates.py',
 which define the headers and footer of a page.</p>
 
 <p>Static HTML pages are used for basic pages that do not embed
 dynamic content, such as this guide.  They help reducing the load of
 the server and speed up pages serving.  As you will see, even HTML
 static pages can still contain some values defined at run time, but
 these are reduced to the minimum compared to dynamic pages. Most
 probably you will not want to modify these pages, since the small
 amount of dynamic content they have allow these pages to inherit from
 the customizations you have made elsewhere, such as in the CSS, and the
 page header and footer.</p>
 
 <h4><a name="overview_page_layout_stat">1.2.1 Layout of HTML Static Pages</a></h4>
 
 <p>Static HTML pages are all located in the /opt/invenio/lib/webdoc/
 installation directory. These files are organized in 3 directories:</p>
 <ul>
 <li><b>help:</b> Help pages available to users of your website</li>
 <li><b>admin:</b> Mostly guides for admin users</li>
 <li><b>hacking:</b> Mostly guides for administrators and developers</li>
 </ul>
 <p>
 These directories do not contain the <code>.html</code> files, but
 <code>.webdoc</code> files. These '<em>WebDoc</em>' files are
 basically HTML with the following main differences:
 </p>
 <ul>
 <li>They only contain the body of your page (only content of the
     <code>&lt;body&gt;</code> tag)
 </li>
 <li>You can make use of special tags such as
     <code>&lt;CFG_SITE_URL&gt;</code> and <code>&lt;CFG_SITE_SUPPORT_EMAIL&gt;</code>,
     that will be replaced by <CFG_SITE_URL> and <CFG_SITE_SUPPORT_EMAIL>, the values that
     you should have configured in your <code>config.py</code> file.
 </li>
 <li>You can internationalize the content. For example:
 <pre>
 &lt;lang&gt;
     &lt;en&gt;Book&lt;/en&gt;
     &lt;fr&gt;Livre&lt;/fr&gt;
     &lt;de&gt;Buch&lt;/de&gt;
 &lt;/lang&gt;
 </pre>
 will be replaced by "Book" if the user has chosen to display the English version of your site,
  "Livre" in French or "Buch" in German.
 </li>
 </ul>
 <p>Read the <a href="<CFG_SITE_URL>/help/hacking/webstyle-webdoc-syntax">WebDoc syntax guide</a> to learn more about details of the WebDoc syntax.</p>
 
 <p>The advantage of not using raw HTML for these static pages is that
 they can for example reuse the header and footer that you have defined
 for dynamic pages, and make use of the variables you have defined in
 your invenio.conf file. In that way you should not need to adapt them to
 your needs: <b>they</b> will adapt themselves to your needs.</p>
 
 <p>Any modification should be immediatly visible when looking at the
 pages from the web: the pages are built "dynamically" and then cached.
 If you want to force the cache of the pages, use the WebDoc CLI
 (type <code>/opt/invenio/bin/webdoc --help</code> to learn more about it).</p>
 
 <h4><a name="overview_page_layout_dyn">1.2.2 Layout of Python Dynamic Pages</a></h4>
 
 <p>The dynamic Python-powered pages can be customized by making use of
 Invenio templating system that uses a notion of a template skin.
 How this works?</p>
 
 <p>When you edit <code>invenio-local.conf</code> during installation
 or later during runtime (when during runtime, you have to
 run <code>inveniocfg --update-config-py</code> after editing the conf
 file), you may choose to use your own templates instead of the
 provided default ones by editing
 <code>CFG_WEBSTYLE_TEMPLATE_SKIN</code> variable.  Let us say you
 put <code>ithaca</code> there in order to use your
 own <code>ithaca</code> style.  Now, when you start Apache, then
 instead of Invenio's usual template files such
 as <code>webbasket_templates.py</code> the system will look for file
 named <code>webbasket_templates_ithaca.py</code> and will load the
 template functions from there instead, provided that they exist.
 (Otherwise it would fall back to the default ones.)</p>
 
 <p>How do you create such an <code>ithaca</code> style templates file?
 We do not use one of many existing templating frameworks in Python but
 a very simple programmer-friendly templating system that enables you
 to use the full power of Python to inherit from the default templates
 the output generating functions you want to reuse and to write anew
 only the functions you would like to modify.</p>
 
 <p>Let's show an example of how to modify the page footer.  Create a
 file named <code>webstyle_templates_ithaca.py</code> with the
 following content:</p>
 
 <blockquote>
 <pre>
 from invenio.config import CFG_SITE_LANG
 from invenio.webstyle_templates import Template as DefaultTemplate
 
 class Template(DefaultTemplate):
     """Ithaca style templates."""
 
     def tmpl_pagefooter(self, req=None, ln=CFG_SITE_LANG, lastupdated=None,
                         pagefooteradd=""):
         """
         Ithaca style page footer.  See the default function for
         the meaning of parameters.
         """
         out = ""
         out += """&lt;hr>This site has no footer.
                   &lt;/body>
                   &lt;/html>"""
         return out
 
 </pre>
 </blockquote>
 
 <p>After the file was created, restart Apache and lo, your new ithaca
 style footer will be seen in action.</p>
 
 <p>(A side comment: note that <code>tmpl_page_footer()</code> is an
 ideal place to put any local code you may want to execute at the end
 of web request processing when the main page content was just served
 to the user.  As an example, if you are using Google Analytics, you
 may want to put just after the above <code>out = ""</code> statement
 your GA script code:</p>
 </blockquote>
 <pre>
         [...]
         out += """
 &lt;script type="text/javascript">
 
   var _gaq = _gaq || [];
   _gaq.push(['_setAccount', 'UA-XXXXX-X']);
   _gaq.push(['_trackPageview']);
 
   (function() {
     var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
     ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
     var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
   })();
 
 &lt;/script>
 """
 </pre>
 </blockquote>
 End of the side comment.)
 
 <p>Some further remarks on this templating system:</p>
 
 <ul>
 
 <li>We have observed that in practice the HTML page designers were
     ofter Python programmers, therefore we have adopted a
     programmer-friendly templating system.</li>
 
 <li>You have to know a bit of Python in order to use it.  If you don't
     know Python, do not worry, because you can basically copy and
     paste the original <code>tmpl_foo()</code> function definition "as
     is" into the above-cited example and then you would only modify
     its HTML snippets.  The important thing is to preserve the imports
     (<code>from invenio.config import CFG_SITE_LANG</code>) as in the original
     <code>webstyle_templates.py</code> file and to preserve the
     leading whitespace Pythonic indentation.</li>
 
 <li>You do not have to learn "yet another templating language", you
     can use the full power of Python. The <code>tmpl_foo()</code>
     functions do not contain any business logic in them, their only
     purpose is to make the HTML presentation of data supplied to them.
     But, should you need to carry out a little data transformation,
     you can do it within the <code>tmpl_foo()</code> function itself,
     thanks to the full Python power.</li>
 
 <li>If you feel like doing so, you can modify all
     the <code>tmpl_foo()</code> functions across all Invenio
     modules in a way that will completely change the presentation of
     elements including their content, position and order on the
     screen.</li>
 
 <li>In practice, it is sufficient to modify the CSS and the
     webstyle_templates_ithaca.py (and possibly
     websearch_templates_ithaca.py) files to achieve most important
     customizations.</li>
 
 <li>If you would like to discover which method of which template
     generate which region on the web page, you can switch on
     the <tt>CFG_WEBSTYLE_INSPECT_TEMPLATES</tt> configuration variable
     in your <tt>invenio-local.conf</tt> file and rerun <code>sudo -u
     apache /opt/invenio/bin/inveniocfg
     --update-config-py</code>. Then, after optionally running
     <code>bibreformat -a</code> and <code>webcoll -f</code> (if you
     want to debug search pages) and after having restarted your Apache
     server (in every case), you will find in your browser that a
     place-mark has been put next to every region of every page, and
     that you can hover your mouse pointer over any region of the page
     in order to discover which module/method/parameters have been used
     to generate it.  This is useful for debugging Python templates
     and/or for understanding which part of code generates which HTML
     snippet in the output.</li>
 
 <li>We expect to provide possibly more than one skin with the default
     distribution, so if you have modified Invenio look and feel in
     an interesting way, please consider donating us your templates.</li>
 
 <li>When upgrading from one Invenio release to another, you may
     find out that the default templates have changed in a way that
     requires changes to your templates (such as an addition of
     parameters to cover the new functionality).  This is inevitable in
     any templating system; unless you introduce new parameters, you
     would not see them being printed.  Therefore, if you have
     modified <code>tmpl_foo()</code> and <code>tmpl_bar()</code>, and
     you are ugrading to a new release, you may at least briefly check
     whether the function arguments are the same.  A quick check of the
     body would be helpful too, in case the new release fixed some
     display-related problems in these functions.
     <br/><br/>
 
     In order to help you in this task, we provide a tool to check
     incompatibilities between your customized templates and the default
     templates.<br/>
 
     This tool can be run before doing a <code>'make install'</code>,
     therefore giving you a chance to fix your templates before
     upgrading. Just run <code>'make check-custom-templates'</code> to
     get the list of problems found with your templates. <br /><br />
 
     You can also run this tool any time after the new default
     templates have been installed, in order to ensure that
     modifications you have done to your templates are valid. To do so
     move to your Invenio installation directory, and run: <br/>
     <code>$ python /opt/invenio/lib/python/invenio/template.py
     --check-custom-templates</code>
 </li>
 
 </ul>
 
 <h3><a name="overview_bib">1.3 Look of Bibliographic
 References</a></h3>
 
 <p>Bibliographic metadata is formatted using
 <a href="bibformat-admin">BibFormat</a>. Read the
 <a href="bibformat-admin-guide">BibFormat documentation</a>
 for more information.</p>
 
 <h3><a name="overview_spec_conf">1.4 Specific Configurations</a></h3>
 
 <p>Note that the search interface pages may be modified to a large
 extent in the <a href="websearch-admin">WebSearch Admin
 Interface</a> by adding HTML portalboxes on various places on the page
 (right top, before/after page title, before/after narrow by collection
 boxes, etc).</p>
 
 <h2><a name="det_page">2. Detailed Record Pages</a></h2>
 
 <p>The web pages displaying the details of a record (such as
 <a href="<CFG_SITE_URL>/<CFG_SITE_RECORD>/1"><CFG_SITE_URL>/<CFG_SITE_RECORD>/1</a>) do not only show metadata, but
 also users' comments and reviews, statistics, etc. This information is
 organized into tabs.</p>
 
 <p>The content of these tabs can be customized on a collection basis. It
 is also possible to show/hide tabs depending on the displayed
 collection.</p>
 
 <p>The detailed record pages also feature a mini panel at the bottom of
 the page that links to popular functions (The mini panel is only
 displayed when <em>Information</em> tab is selected).</p>
 
 <pre>
 
   +--------------Detailed record page-------------+
   |                    header                     |
   |nav. breadcrumb                                |
   |                                               |
   |   .--------------------------------------.    |
   | .-|Info.|Ref.|Discussion.|Stats.|Files |-.  |
   | | '--------------------------------------' |  |
   | |                                          |  |
   | |                  content                 |  |
   | |                                          |  |
   | '------------------------------------------'  |
   |                                               |
   | .---------------(Mini Panel)---------------.  |
   | |   Mini    |      Mini     |    Mini      |  |
   | |   File    |     Review    |   Actions    |  |
   | '------------------------------------------'  |
   +-----------------------------------------------+
 </pre>
 
 <h4><a name="det_page_avail_tabs">2.1 Available tabs</a></h4>
 
 The following tabs are available:
 <table border="1">
   <tr>
     <th>Name</th>
     <th>Description</th>
     <th>URL (eg. for record '10')</th>
   </tr>
   <tr>
     <td>Information</td>
     <td>Show the formatted metadata of the record</td>
     <td><a href="<CFG_SITE_URL>/<CFG_SITE_RECORD>/10"><CFG_SITE_URL>/<CFG_SITE_RECORD>/10</a></td>
   </tr>
   <tr>
     <td>References</td>
     <td>Displays the references (bibliography) of the record</td>
     <td><a href="<CFG_SITE_URL>/<CFG_SITE_RECORD>/10/references"><CFG_SITE_URL>/<CFG_SITE_RECORD>/10/references</a></td>
   </tr>
   <tr>
     <td>Discussion</td>
     <td>Displays the users' comments and reviews</td>
     <td><a href="<CFG_SITE_URL>/<CFG_SITE_RECORD>/10/comments"><CFG_SITE_URL>/<CFG_SITE_RECORD>/10/comments</a><br/>
         <a href="<CFG_SITE_URL>/<CFG_SITE_RECORD>/10/reviews"><CFG_SITE_URL>/<CFG_SITE_RECORD>/10/reviews</a></td>
   </tr>
   <tr>
     <td>Usage Statistics</td>
     <td>Statistics data and graph about file downloads/views</td>
     <td><a href="<CFG_SITE_URL>/<CFG_SITE_RECORD>/10/usage"><CFG_SITE_URL>/<CFG_SITE_RECORD>/10/usage</a></td>
   </tr>
   <tr><td>Files</td>
     <td>Link(s) to full-text and associated file(s)</td>
     <td><a href="<CFG_SITE_URL>/<CFG_SITE_RECORD>/10/files"><CFG_SITE_URL>/<CFG_SITE_RECORD>/10/files</a></td>
   </tr>
 </table>
 
 <p>The mini panel is only displayed when the <em>Information</em> tab is
 selected. It is divided into the following sections:</p>
 <ul>
  <li>Files  : quick access to full-text file(s)</li>
  <li>Review : quick access to reviewing feature</li>
  <li>Actions: quick access to several other features</li>
 </ul>
 
 <h4><a name="det_page_show_hide_tabs">2.2 Showing/Hiding tabs</a></h4>
 
 <p>The <a href="websearch-admin">WebSearch admin web
 interface</a> lets you decide for each collection which tabs are to be
 displayed. Choose a collection to edit in the collection tree and go
 to its <em>detailed record page options</em>. From there you can select which
 tabs to show for that collection.</p>
 
 <p>If you want to apply these settings to the subcollections, select
 <em><input type="checkbox" checked="checked" disabled="disabled">Also apply to subcollections</input></em>
 before you click on the
 <input type="submit" value="Modify" class="formbutton" disabled="disabled"/>
 button.</p>
 
 <p>Note that these settings only affect the tabs, not the content of the
 tabs: even if a tab is not displayed, it is still possible to access
 its content using its usual url. This is useful if you decide to
 completely change the detailed record pages, dropping the tab-metaphor
 (eg. for a side bar) but still want to access the comments, reviews,
 etc pages.</p>
 
 <p>Here are some behaviours you should expect when changing the tabs
 configuration:</p>
 <ul>
   <li>Given that search results pages always link to <CFG_SITE_URL>/<CFG_SITE_RECORD>/10,
   and given the above comment about accessibility of tabs when they
   are not displayed, the content of the <em>Information</em> will always be
   show when clicking on <a href="#" class="moreinfo">detailed record</a> link in search results, even
   if the <em>Information</em> tab is set not to be displayed.</li>
 
   <li>If you select only 1 tab, none of the tabs will be displayed at the
   top of the page. This also means that whatever tabs you have
   selected, you users will always see the content of the 'Information'
   tabs (see above behaviour).</li>
 
   <li>If you select 0 tab, only the content of <em>Information</em> tab is shown.
   None of the tabs, nor the border that usually surrounds the content
   of the tabs, nor the minipanel are shown. You should choose this
   option if you decide to drop the tabs metaphor for the detailed
   record pages. You can then build your own user interface on this
   almost blank page (See <a href="#det_page_cust_cont_tabs">Customizing content of tabs</a>).</li>
 
   <li>Note that <em>Discussion</em> tab will not be shown if you have disabled
   both the commenting and reviewing features in your installation
   (<code>CFG_WEBCOMMENT_ALLOW_COMMENTS</code> and
   <code>CFG_WEBCOMMENT_ALLOW_REVIEWS</code> variable in your config file).</li>
 </ul>
 
 <h4><a name="det_page_cust_cont_tabs">2.3 Customizing content of tabs</a></h4>
 
 <p>The contents of tabs are defined in the following ways:</p>
 <dl>
 <dt><strong><em>Information</em> tab</strong></dt>
   <dd>The content of this tab is defined by function
   <code>tmpl_detailed_record_metadata(..)</code> in <code>websearch_templates.py</code>.
   By default <code>tmpl_detailed_record_metadata</code> simply returns the result
   of the formatting of the metadata by BibFormat using the "HD" output
   format. It can therefore be collection-specific.</dd>
 
 <dt><strong><em>References</em> tab</strong></dt>
   <dd>The content of this tab is defined by function
   <code>tmpl_detailed_record_references(..)</code> in <code>websearch_templates.py</code>.
   By default <code>tmpl_detailed_record_metadata</code> simply returns the result
   of the formatting of the metadata by BibFormat using the "HDREF"
   output format. If the result returned by BibFormat is empty, the tab
   is disabled (visible, but not clickable). It can therefore be
   collection-specific.</dd>
 
 <dt><strong><em>Discussion</em> tab</strong></dt>
   <dd>The content of this tab is mainly defined by function
   <code>tmpl_get_comments(..)</code> in <code>webcomment_templates.py</code>. Other
   functions in this file are also involved in the display.</dd>
 
 <dt><strong><em>Usage Statistics</em> tab</strong></dt>
   <dd>The content of this tab is defined by function
   <code>tmpl_detailed_record_statistics(..)</code> in <code>websearch_templates.py</code>.
   If the returned content is empty, then the tabs will be disabled
   (visible, but cannot be clicked).</dd>
 
 <dt><strong><em>Files</em> tab</strong></dt>
   <dd>The content of this tab is defined by function <code>tmpl_filelist(..)</code>
   in <code>websubmit_templates.py</code>.</dd>
 </dl>
 <br/>
 <p>The content of the mini panel is defined in the following ways:</p>
 <dl>
 <dt><strong><em>Files</em></strong></dt>
   <dd>The content of this section is defined by the output format
   'HDFILE'. It can therefore be collection-specific.</dd>
 
 <dt><strong><em>Review</em></strong></dt>
   <dd>The content of this section is defined by function
   <code>tmpl_mini_review(..)</code> inside <code>webcomment_templates.py</code></dd>
 
 <dt><strong><em>Actions</em></strong></dt>
   <dd>The content of this section is defined by the output format
   <code>HDACT</code>. It can therefore be collection-specific.</dd>
 </dl>
 
 <h4><a name="det_page_cust_look_tabs">2.4 Customizing look of tabs</a></h4>
 
 <p>You can customize how tabs look like, as well change the look of the
 border that surrounds the content of tabs. The mini panel can
 similarly be customized.</p>
 
 <p>Have a look at the following classes in the CDS css stylesheet:</p>
 <ul>
    <li><code>detailedrecordtabs</code></li>
    <li><code>detailedrecordbox</code></li>
    <li><code>detailedrecordminipanel</code></li>
    <li><code>top-left, top-right, bottom-left, bottom-right</code></li>
    <li><code>detailedrecordminipanel{actions,review,file}, detailedrecordshortreminder</code></li>
 </ul>
 
 <p>Note that a tab might be greyed out (disabled) when its content is
 empty.  This is the case for the <em>References</em> tab (see <a href="#det_page_cust_cont_tabs">Customizing
 content of tabs</a> -&gt; 'References tab') and the <em>Files</em> tab (if no
 file could be found for the record).<p>
 
 <p>For more advanced modifications (like changing the HTML code of the
 tabs), you can modify the <code>detailed_record_container(..)</code> and
 <code>detailed_record_mini_panel(..)</code> functions inside your
 <code>webstyle_templates.py</code> file.</p>
+
+<h3><a name="red">Custom Redirections</a></h3>
+<p>It is possible to create custom redirections to URLs within Invenio, by registering a given
+<em>unique label</em> to be used after path <strong>/goto/</strong>.
+</p>
+<p>FIXME</p>
+
+<h4><a name="red_cli">Command Line Interface</a></h4>
+<pre>
+Usage: gotoadmin [options]
+
+Options:
+  -h, --help            show this help message and exit
+
+  Plugin Administration Options:
+    --list-plugins      List available GOTO plugins and their documentation
+    --list-broken-plugins
+                        List broken GOTO plugins
+
+  Redirection Manipultation Options:
+    -r LABEL, --register-redirection=LABEL
+                        Register a redirection with the provided LABEL
+    -u LABEL, --update-redirection=LABEL
+                        Update the redirection specified by the provided LABEL
+    -g LABEL, --get-redirection=LABEL
+                        Get all information about a redirection specified by
+                        LABEL
+    -d LABEL, --drop-redirection=LABEL
+                        Drop an existing redirection specified by LABEL
+
+  Specific Options:
+    -P PLUGIN, --plugin=PLUGIN
+                        Specify the plugin to use when registering or updating
+                        a redirection
+    -j PARAMETERS, --json-parameters=PARAMETERS
+                        Specify the parameters to provide to the plugin
+                        (serialized in JSON)
+    -p PARAM=VALUE, --parameter=PARAM=VALUE
+                        Specify a single PARAM=VALUE parameter to be provided
+                        to the plugin (alternative to the JSON serialization)
+</pre>
diff --git a/modules/webstyle/lib/Makefile.am b/modules/webstyle/lib/Makefile.am
index 7818c4be4..aa829b7cf 100644
--- a/modules/webstyle/lib/Makefile.am
+++ b/modules/webstyle/lib/Makefile.am
@@ -1,42 +1,46 @@
 ## This file is part of Invenio.
 ## Copyright (C) 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 ## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
+SUBDIRS = goto_plugins
+
 pylibdir=$(libdir)/python/invenio
 wsgiwebdir=$(localstatedir)/www-wsgi/
 
 pylib_DATA = webdoc.py \
              webdoc_unit_tests.py \
              webdoc_webinterface.py \
              webpage.py \
              template.py \
              webstyle_templates.py \
              webstyle_regression_tests.py \
              webinterface_handler.py \
              webinterface_unit_tests.py \
              webinterface_layout.py \
              ckeditor_invenio_connector.py \
              webinterface_handler_wsgi.py \
              webinterface_handler_wsgi_utils.py \
              webinterface_handler_config.py \
              httptest_webinterface.py \
-             ping_webinterface.py
+             ping_webinterface.py \
+             goto_webinterface.py \
+             goto_engine.py
 
 wsgiweb_DATA = invenio.wsgi
 
 EXTRA_DIST = $(pylib_DATA) $(wsgiweb_DATA)
 
 CLEANFILES = *~ *.tmp *.pyc
diff --git a/modules/webstyle/lib/goto_engine.py b/modules/webstyle/lib/goto_engine.py
new file mode 100644
index 000000000..ae734e3b2
--- /dev/null
+++ b/modules/webstyle/lib/goto_engine.py
@@ -0,0 +1,253 @@
+## This file is part of Invenio.
+## Copyright (C) 2012 CERN.
+##
+## Invenio is free software; you can redistribute it and/or
+## modify it under the terms of the GNU General Public License as
+## published by the Free Software Foundation; either version 2 of the
+## License, or (at your option) any later version.
+##
+## Invenio is distributed in the hope that it will be useful, but
+## WITHOUT ANY WARRANTY; without even the implied warranty of
+## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+## General Public License for more details.
+##
+## You should have received a copy of the GNU General Public License
+## along with Invenio; if not, write to the Free Software Foundation, Inc.,
+## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
+
+"""
+Redirecting engine.
+"""
+
+import os
+import optparse
+
+from invenio.config import CFG_PYLIBDIR
+from invenio.dbquery import run_sql, IntegrityError
+from invenio.jsonutils import json, json_unicode_to_utf8
+from invenio.pluginutils import PluginContainer, get_callable_documentation
+from invenio.textutils import wait_for_user
+
+CFG_GOTO_PLUGINS = PluginContainer(os.path.join(CFG_PYLIBDIR, 'invenio',
+'goto_plugins', 'goto_plugin_*.py'), plugin_builder=lambda name, code: code.goto)
+
+def register_redirection(label, plugin, parameters=None, update_on_duplicate=False):
+    """
+    Register a redirection from /goto/<LABEL> to the URL returned by running the
+    given plugin (as available in CFG_GOTO_PLUGINS), with the given parameters.
+
+    @param label: the uniquely identifying label for this redirection
+    @type label: string
+
+    @param plugin: the algorithm that should resolve the redirection, usually:
+        "goto_plugin_FOO"
+    @type plugin: string
+
+    @param parameters: further parameters that should be passed to the plugin.
+        This should be a dictionary or None. Note that these parameters could
+        be overridden by the query parameters.
+    @type parameters: dict or None
+
+    @param update_on_duplicate: if False (default), if the label already exist it
+        L{register_redirection} will raise a ValueError exception. If True, it
+        will implicitly call L{update_redirection}.
+    @type update_on_duplicate: bool
+
+    @raises: ValueError in case of duplicate label and L{update_on_duplicate} is
+        set to False.
+
+    @note: parameters are going to be serialized to JSON before being stored
+        in the DB. Hence only JSON-serializable values should be put there.
+    """
+    if run_sql("SELECT label FROM goto WHERE label=%s", (label, )):
+        raise ValueError("%s label already exists" % label)
+    if plugin not in CFG_GOTO_PLUGINS:
+        raise ValueError("%s plugin does not exist" % plugin)
+    if parameters is None:
+        parameters = {}
+    try:
+        parameters.items() ## dummy test to see if it exposes the dict interface
+        json_parameters = json.dumps(parameters)
+    except Exception, err:
+        raise ValueError("The parameters %s do not specify a valid JSON map: %s" % (parameters, err))
+    try:
+        run_sql("INSERT INTO goto(label, plugin, parameters, creation_date, modification_date) VALUES(%s, %s, %s, NOW(), NOW())", (label, plugin, json_parameters))
+    except IntegrityError:
+        if run_sql("SELECT label FROM goto WHERE label=%s", (label,)):
+            if update_on_duplicate:
+                update_redirection(label=label, plugin=plugin, parameters=parameters)
+            else:
+                raise ValueError("%s label already exists" % label)
+        else:
+            ## This is due to some other issue
+            raise
+
+def update_redirection(label, plugin, parameters=None):
+    """
+    Update an existing redirection from /goto/<LABEL> to the URL returned by
+    running the given plugin (as available in CFG_GOTO_PLUGINS), with the given
+    parameters.
+
+    @param label: the uniquely identifying label for this redirection
+    @type label: string
+
+    @param plugin: the algorithm that should resolve the redirection, usually:
+        "goto_plugin_FOO"
+    @type plugin: string
+
+    @param parameters: further parameters that should be passed to the plugin.
+        This should be a dictionary or None. Note that these parameters could
+        be overridden by the query parameters.
+    @type parameters: dict or None
+
+    @raises: ValueError in case the label does not already exist.
+
+    @note: parameters are going to be serialized to JSON before being stored
+        in the DB. Hence only JSON-serializable values should be put there.
+    """
+    if not run_sql("SELECT label FROM goto WHERE label=%s", (label, )):
+        raise ValueError("%s label does not already exist" % label)
+    if plugin not in CFG_GOTO_PLUGINS:
+        raise ValueError("%s plugin does not exist" % plugin)
+    if parameters is None:
+        parameters = {}
+    try:
+        parameters.items() ## dummy test to see if it exposes the dict interface
+        json_parameters = json.dumps(parameters)
+    except Exception, err:
+        raise ValueError("The parameters %s do not specify a valid JSON map: %s" % (parameters, err))
+    run_sql("UPDATE goto SET plugin=%s, parameters=%s, modification_date=NOW() WHERE label=%s", (plugin, json_parameters, label))
+
+def drop_redirection(label):
+    """
+    Delete an existing redirection identified by label.
+
+    @param label: the uniquely identifying label for this redirection
+    @type label: string
+    """
+    run_sql("DELETE FROM goto WHERE label=%s", (label, ))
+
+def get_redirection_data(label):
+    """
+    Returns all information about a given redirection identified by label.
+
+    @param label: the label identifying the redirection
+    @type label: string
+
+    @returns: a dictionary with the following keys:
+        * label: the label
+        * plugin: the name of the plugin
+        * parameters: the parameters that are passed to the plugin
+            (deserialized from JSON)
+        * creation_date: datetime object on when the redirection was first
+            created.
+        * modification_date: datetime object on when the redirection was
+            last modified.
+    @rtype: dict
+
+    @raises ValueError: in case the label does not exist.
+    """
+    res = run_sql("SELECT label, plugin, parameters, creation_date, modification_date FROM goto WHERE label=%s", (label, ))
+    if res:
+        return {'label': res[0][0],
+                 'plugin': CFG_GOTO_PLUGINS[res[0][1]],
+                 'parameters': json_unicode_to_utf8(json.loads(res[0][2])),
+                 'creation_date': res[0][3],
+                 'modification_date': res[0][4]}
+    else:
+        raise ValueError("%s label does not exist" % label)
+
+def is_redirection_label_already_taken(label):
+    """
+    Returns True in case the given label is already taken.
+    """
+    return bool(run_sql("SELECT label FROM goto WHERE label=%s", (label,)))
+
+def main():
+    """
+    Entry point for the CLI
+    """
+    def get_json_parameters_from_cli(option, dummy_opt_str, value, dummy_parser):
+        try:
+            option.parameters = json_unicode_to_utf8(json.loads(value))
+        except Exception, err:
+            raise optparse.OptionValueError("Cannot parse as a valid JSON serialization the provided parameters: %s. %s" % (value, err))
+
+    def get_parameter_from_cli(option, dummy_opt_str, value, dummy_parser):
+        if not hasattr(option, 'parameters'):
+            option.parameters = {}
+        param, value = value.split('=', 1)
+        try:
+            value = int(value)
+        except:
+            pass
+        option.parameters[param] = value
+
+    parser = optparse.OptionParser()
+
+    plugin_group = optparse.OptionGroup(parser, "Plugin Administration Options")
+    plugin_group.add_option("--list-plugins", action="store_const", dest="action", const="list-goto-plugins", help="List available GOTO plugins and their documentation")
+    plugin_group.add_option("--list-broken-plugins", action="store_const", dest="action", const="list-broken-goto-plugins", help="List broken GOTO plugins")
+    parser.add_option_group(plugin_group)
+
+    redirection_group = optparse.OptionGroup(parser, "Redirection Manipultation Options")
+    redirection_group.add_option("-r", "--register-redirection", metavar="LABEL", action="store", dest="register", help="Register a redirection with the provided LABEL")
+    redirection_group.add_option("-u", "--update-redirection", metavar="LABEL", action="store", dest="update", help="Update the redirection specified by the provided LABEL")
+    redirection_group.add_option("-g", "--get-redirection", metavar="LABEL", action="store", dest="get_redirection", help="Get all information about a redirection specified by LABEL")
+    redirection_group.add_option("-d", "--drop-redirection", metavar="LABEL", action="store", dest="drop_redirection", help="Drop an existing redirection specified by LABEL")
+    parser.add_option_group(redirection_group)
+
+    specific_group = optparse.OptionGroup(parser, "Specific Options")
+    specific_group.add_option("-P", "--plugin", metavar="PLUGIN", action="store", dest="plugin", help="Specify the plugin to use when registering or updating a redirection")
+    specific_group.add_option("-j", "--json-parameters", metavar="PARAMETERS", action="callback", type="string", callback=get_json_parameters_from_cli, help="Specify the parameters to provide to the plugin (serialized in JSON)")
+    specific_group.add_option("-p", "--parameter", metavar="PARAM=VALUE", action="callback", callback=get_parameter_from_cli, help="Specify a single PARAM=VALUE parameter to be provided to the plugin (alternative to the JSON serialization)", type="string")
+    parser.add_option_group(specific_group)
+
+    (options, dummy_args) = parser.parse_args()
+    if options.action == "list-goto-plugins":
+        print "GOTO plugins found:"
+        for component, goto in CFG_GOTO_PLUGINS.items():
+            print component + ' -> ' + get_callable_documentation(goto)
+    elif options.action == 'list-broken-goto-plugins':
+        print "Broeken GOTO plugins found:"
+        for component, error in CFG_GOTO_PLUGINS.get_broken_plugins().items():
+            print component + '->' + str(error)
+    elif options.register:
+        label = options.register
+        plugin = options.plugin
+        parameters = getattr(options, 'parameters', {})
+        if not plugin in CFG_GOTO_PLUGINS:
+            parser.error("%s is not a valid plugin" % plugin)
+        if is_redirection_label_already_taken(label):
+            parser.error("The specified label %s is already taken" % label)
+        register_redirection(label, plugin, parameters)
+        print "The redirection %s was successfully registered for the plugin %s with parameters %s" % (label, plugin, parameters)
+    elif options.update:
+        label = options.update
+        if not is_redirection_label_already_taken(label):
+            parser.error("The specified label %s does not exist" % label)
+        redirection_data = get_redirection_data(label)
+        plugin = options.plugin or redirection_data['plugin']
+        parameters = options.parameters or redirection_data['parameters']
+        if not plugin in CFG_GOTO_PLUGINS:
+            parser.error("%s is not a valid plugin" % plugin)
+        update_redirection(label, plugin, parameters=None)
+        print "The redirection %s was successfully updated for the plugin %s with parameters %s" % (label, plugin, parameters)
+    elif options.get_redirection:
+        label = options.get_redirection
+        if not is_redirection_label_already_taken(label):
+            parser.error("The specified label %s does not exist" % label)
+        print get_redirection_data(label)
+    elif options.drop_redirection:
+        label = options.drop_redirection
+        if is_redirection_label_already_taken(label):
+            wait_for_user("Are you sure you want to drop the redirection: %s\n%s" % (label, get_redirection_data(label)))
+            drop_redirection(label)
+            print "The redirection %s was successfully dropped" % label
+        else:
+            print "The specified label %s is not registered with any redirection" % label
+    else:
+        parser.print_help()
+
+if __name__ == "__main__":
+    main()
diff --git a/modules/webstyle/bin/Makefile.am b/modules/webstyle/lib/goto_plugins/Makefile.am
similarity index 70%
copy from modules/webstyle/bin/Makefile.am
copy to modules/webstyle/lib/goto_plugins/Makefile.am
index 96f288a6a..d6504f949 100644
--- a/modules/webstyle/bin/Makefile.am
+++ b/modules/webstyle/lib/goto_plugins/Makefile.am
@@ -1,22 +1,27 @@
 ## This file is part of Invenio.
-## Copyright (C) 2007, 2008, 2010, 2011 CERN.
+## Copyright (C) 2012 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
-## General Public License for more details.  
+## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
-bin_SCRIPTS = webdoc
+pylibdir=$(libdir)/python/invenio/goto_plugins
 
-EXTRA_DIST = webdoc.in
+pylib_DATA = __init__.py \
+	goto_plugin_latest_record.py \
+	goto_plugin_cern_hr_documents.py \
+	goto_plugin_simple.py
 
-CLEANFILES = *~ *.tmp
+EXTRA_DIST = $(pylib_DATA)
+
+CLEANFILES = *~ *.tmp *.pyc
diff --git a/modules/webstyle/lib/goto_plugins/__init__.py b/modules/webstyle/lib/goto_plugins/__init__.py
new file mode 100644
index 000000000..e69de29bb
diff --git a/modules/webstyle/lib/goto_plugins/goto_plugin_cern_hr_documents.py b/modules/webstyle/lib/goto_plugins/goto_plugin_cern_hr_documents.py
new file mode 100644
index 000000000..f7230d577
--- /dev/null
+++ b/modules/webstyle/lib/goto_plugins/goto_plugin_cern_hr_documents.py
@@ -0,0 +1,155 @@
+# -*- coding: utf-8 -*-
+##
+## This file is part of Invenio.
+## Copyright (C) 2012 CERN.
+##
+## Invenio is free software; you can redistribute it and/or
+## modify it under the terms of the GNU General Public License as
+## published by the Free Software Foundation; either version 2 of the
+## License, or (at your option) any later version.
+##
+## Invenio is distributed in the hope that it will be useful, but
+## WITHOUT ANY WARRANTY; without even the implied warranty of
+## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+## General Public License for more details.
+##
+## You should have received a copy of the GNU General Public License
+## along with Invenio; if not, write to the Free Software Foundation, Inc.,
+## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
+
+"""
+This implements a redirection for CERN HR Documents in the CERN Document
+Server. It's useful as a reference on how goto plugins could be implemented.
+"""
+
+import time
+import re
+
+from invenio.search_engine import perform_request_search
+from invenio.search_engine_utils import get_fieldvalues
+from invenio.bibdocfile import BibRecDocs
+
+def make_cern_ssr_docname(lang, edition, modif=0):
+    if modif:
+        return "CERN_SSR_%(lang)s_ed%(edition)02d_modif%(modif)02d" % {
+            'lang': lang,
+            'edition': edition,
+            'modif': modif
+        }
+    else:
+        return "CERN_SSR_%(lang)s_ed%(edition)02d" % {
+            'lang': lang,
+            'edition': edition,
+        }
+
+_RE_REVISION = re.compile(r"rev(\d\d)")
+def _get_revision(docname):
+    """
+    Return the revision in a docname. E.g.:
+    CERN_Circ_Op_en_02_rev01_Implementation measures.pdf -> 1
+    CERN_Circ_Op_en_02_rev02_Implementation measures.PDF -> 2
+    """
+    g = _RE_REVISION.search(docname)
+    if g:
+        return int(g.group(1))
+    return 0
+
+def _register_document(documents, docname, key):
+    """
+    Register in the documents mapping the docname to key, but only if the
+    docname has a revision higher of the docname already associated with a key
+    """
+    if key in documents:
+        if _get_revision(docname) > _get_revision(documents[key]):
+            documents[key] = docname
+    else:
+        documents[key] = docname
+
+def goto(type, document='', number=0, lang='en', modif=0):
+    today = time.strftime('%Y-%m-%d')
+    if type == 'SSR':
+        ## We would like a CERN Staff Rules and Regulations
+        recids = perform_request_search(cc='Staff Rules and Regulations', f="925__a:1996-01-01->%s 925__b:%s->9999-99-99" % (today, today))
+        recid = recids[-1]
+        reportnumber = get_fieldvalues(recid, '037__a')[0]
+        edition = int(reportnumber[-2:]) ## e.g. CERN-STAFF-RULES-ED08
+        return BibRecDocs(recid).get_bibdoc(make_cern_ssr_docname(lang, edition, modif)).get_file('.pdf').get_url()
+    elif type == "OPER-CIRC":
+        recids = perform_request_search(cc="Operational Circulars", p="reportnumber=\"CERN-OPER-CIRC-%s-*\"" % number, sf="925__a")
+        recid = recids[-1]
+        documents = {}
+        bibrecdocs = BibRecDocs(recid)
+        for docname in bibrecdocs.get_bibdoc_names():
+            ldocname = docname.lower()
+            if 'implementation' in ldocname:
+                _register_document(documents, docname, 'implementation_en')
+            elif 'application' in ldocname:
+                _register_document(documents, docname, 'implementation_fr')
+            elif 'archiving' in ldocname:
+                _register_document(documents, docname, 'archiving_en')
+            elif 'archivage' in ldocname:
+                _register_document(documents, docname, 'archiving_fr')
+            elif 'annexe' in ldocname or 'annexes_fr' in ldocname:
+                _register_document(documents, docname, 'annex_fr')
+            elif 'annexes_en' in ldocname or 'annex' in ldocname:
+                _register_document(documents, docname, 'annex_en')
+            elif '_en_' in ldocname or '_eng_' in ldocname or '_angl_' in ldocname:
+                _register_document(documents, docname, 'en')
+            elif '_fr_' in ldocname:
+                _register_document(documents, docname, 'fr')
+        return bibrecdocs.get_bibdoc(documents[document]).get_file('.pdf').get_url()
+    elif type == 'ADMIN-CIRC':
+        recids = perform_request_search(cc="Administrative Circulars", p="reportnumber=\"CERN-ADMIN-CIRC-%s-*\"" % number, sf="925__a")
+        recid = recids[-1]
+        documents = {}
+        bibrecdocs = BibRecDocs(recid)
+        for docname in bibrecdocs.get_bibdoc_names():
+            ldocname = docname.lower()
+            if 'implementation' in ldocname:
+                _register_document(documents, docname, 'implementation-en')
+            elif 'application' in ldocname:
+                _register_document(documents, docname, 'implementation-fr')
+            elif 'archiving' in ldocname:
+                _register_document(documents, docname, 'archiving-en')
+            elif 'archivage' in ldocname:
+                _register_document(documents, docname, 'archiving-fr')
+            elif 'annexe' in ldocname or 'annexes_fr' in ldocname:
+                _register_document(documents, docname, 'annex-fr')
+            elif 'annexes_en' in ldocname or 'annex' in ldocname:
+                _register_document(documents, docname, 'annex-en')
+            elif '_en_' in ldocname or '_eng_' in ldocname or '_angl_' in ldocname:
+                _register_document(documents, docname, 'en')
+            elif '_fr_' in ldocname:
+                _register_document(documents, docname, 'fr')
+        return bibrecdocs.get_bibdoc(documents[document]).get_file('.pdf').get_url()
+
+def register_hr_redirections():
+    """
+    Run this only once
+    """
+
+    from invenio.goto_engine import register_redirection
+    plugin = 'goto_plugin_cern_hr_documents'
+
+    ## Staff rules and regulations
+    for modif in range(1, 20):
+        for lang in ('en', 'fr'):
+            register_redirection('hr-srr-modif%02d-%s' % (modif, lang), plugin, parameters={'type': 'SSR', 'lang': lang, 'modif': modif})
+    for lang in ('en', 'fr'):
+        register_redirection('hr-srr-%s' % lang, plugin, parameters={'type': 'SSR', 'lang': lang, 'modif': 0})
+
+    ## Operational Circulars
+    for number in range(1, 10):
+        for lang in ('en', 'fr'):
+            register_redirection('hr-oper-circ-%s-%s' % (number, lang), plugin, parameters={'type': 'OPER-CIRC', 'document': lang, 'number': number})
+    for number, special_document in ((2, 'implementation'), (2, 'annex'), (3, 'archiving'), (3, 'annex')):
+        for lang in ('en', 'fr'):
+            register_redirection('hr-circ-%s-%s-%s' % (number, special_document, lang), plugin, parameters={'type': 'OPER-CIRC', 'document': '%s-%s' % (special_document, lang), 'number': number})
+
+    ## Administrative Circulars:
+    for number in range(1, 32):
+        for lang in ('en', 'fr'):
+            register_redirection('hr-admin-circ-%s-%s' % (number, lang), plugin, parameters={'type': 'ADMIN-CIRC', 'document': lang, 'number': number})
+
+if __name__ == "__main__":
+    register_hr_redirections()
diff --git a/modules/webstyle/lib/goto_plugins/goto_plugin_latest_record.py b/modules/webstyle/lib/goto_plugins/goto_plugin_latest_record.py
new file mode 100644
index 000000000..e2a6407f9
--- /dev/null
+++ b/modules/webstyle/lib/goto_plugins/goto_plugin_latest_record.py
@@ -0,0 +1,59 @@
+# -*- coding: utf-8 -*-
+##
+## This file is part of Invenio.
+## Copyright (C) 2012 CERN.
+##
+## Invenio is free software; you can redistribute it and/or
+## modify it under the terms of the GNU General Public License as
+## published by the Free Software Foundation; either version 2 of the
+## License, or (at your option) any later version.
+##
+## Invenio is distributed in the hope that it will be useful, but
+## WITHOUT ANY WARRANTY; without even the implied warranty of
+## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+## General Public License for more details.
+##
+## You should have received a copy of the GNU General Public License
+## along with Invenio; if not, write to the Free Software Foundation, Inc.,
+## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
+
+"""
+Demostrative PURL implementing a redirection to the very last record
+(of a collection)
+"""
+
+from invenio.config import CFG_SITE_NAME, CFG_SITE_RECORD
+from invenio.search_engine import perform_request_search
+from invenio.bibdocfile import BibRecDocs, InvenioBibDocFileError
+
+def goto(cc=CFG_SITE_NAME, p='', f='', sf='', so='d', docname='', format=''):
+    """
+    Redirect the user to the latest record in the given collection,
+    optionally within the specified pattern and field. If docname
+    and format are specified, redirect the user to the corresponding
+    docname and format. If docname it is not specified, but there is
+    only a single bibdoc attached to the record will redirect to that
+    one.
+    """
+    recids = perform_request_search(cc=cc, p=p, f=f, sf=sf, so=so)
+    if recids:
+        ## We shall take the last recid. This is the last one
+        recid = recids[-1]
+        url = '/%s/%s' % (CFG_SITE_RECORD, recid)
+        if format:
+            bibrecdocs = BibRecDocs(recid)
+            if not docname:
+                if len(bibrecdocs.get_bibdoc_names()) == 1:
+                    docname = bibrecdocs.get_bibdoc_names()[0]
+                else:
+                    return url
+            try:
+                bibdoc = BibRecDocs(recid).get_bibdoc(docname)
+            except InvenioBibDocFileError:
+                return url
+            try:
+                bibdocfile = bibdoc.get_file(format=format)
+                return bibdocfile.get_url()
+            except InvenioBibDocFileError:
+                return url
+        return url
diff --git a/modules/webstyle/bin/Makefile.am b/modules/webstyle/lib/goto_plugins/goto_plugin_simple.py
similarity index 59%
copy from modules/webstyle/bin/Makefile.am
copy to modules/webstyle/lib/goto_plugins/goto_plugin_simple.py
index 96f288a6a..136ebbb65 100644
--- a/modules/webstyle/bin/Makefile.am
+++ b/modules/webstyle/lib/goto_plugins/goto_plugin_simple.py
@@ -1,22 +1,34 @@
+# -*- coding: utf-8 -*-
+##
 ## This file is part of Invenio.
-## Copyright (C) 2007, 2008, 2010, 2011 CERN.
+## Copyright (C) 2012 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
-## General Public License for more details.  
+## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
-bin_SCRIPTS = webdoc
+"""
+Simple plugin to register an internal redirection
+"""
+from invenio.config import CFG_SITE_URL, CFG_SITE_SECURE_URL
+
+def goto(url):
+    """
+    Redirect to url (assuming it is internal to the system)
+    """
+    if url.startswith('/'):
+        url = CFG_SITE_URL + url
+    if url.startswith(CFG_SITE_URL) or url.startswith(CFG_SITE_SECURE_URL):
+        return url
 
-EXTRA_DIST = webdoc.in
 
-CLEANFILES = *~ *.tmp
diff --git a/modules/webstyle/lib/goto_webinterface.py b/modules/webstyle/lib/goto_webinterface.py
new file mode 100644
index 000000000..02cfe3d21
--- /dev/null
+++ b/modules/webstyle/lib/goto_webinterface.py
@@ -0,0 +1,79 @@
+## This file is part of Invenio.
+## Copyright (C) 2012 CERN.
+##
+## Invenio is free software; you can redistribute it and/or
+## modify it under the terms of the GNU General Public License as
+## published by the Free Software Foundation; either version 2 of the
+## License, or (at your option) any later version.
+##
+## Invenio is distributed in the hope that it will be useful, but
+## WITHOUT ANY WARRANTY; without even the implied warranty of
+## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+## General Public License for more details.
+##
+## You should have received a copy of the GNU General Public License
+## along with Invenio; if not, write to the Free Software Foundation, Inc.,
+## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
+
+"""
+Implements persistent URLs
+"""
+
+import inspect
+
+from invenio.config import CFG_SITE_URL
+from invenio.webinterface_handler import WebInterfaceDirectory
+from invenio.webinterface_handler_config import SERVER_RETURN, HTTP_NOT_FOUND
+from invenio.urlutils import redirect_to_url
+from invenio.goto_engine import get_redirection_data
+from invenio.webuser import collect_user_info
+from invenio.errorlib import register_exception
+
+class WebInterfaceGotoPages(WebInterfaceDirectory):
+    def _lookup(self, component, path):
+        try:
+            redirection_data = get_redirection_data(component)
+            goto_plugin = redirection_data['plugin']
+            args, dummy_varargs, dummy_varkw, defaults = inspect.getargspec(goto_plugin)
+            args = args and list(args) or []
+            args.reverse()
+            defaults = defaults and list(defaults) or []
+            defaults.reverse()
+            params_to_pass = {}
+            for arg, default in map(None, args, defaults):
+                params_to_pass[arg] = default
+
+            def goto_handler(req, form):
+                ## Let's put what is in the GET query
+                for key, value in dict(form).items():
+                    if key in params_to_pass:
+                        params_to_pass[key] = str(value)
+
+                ## Let's override the params_to_pass to the call with the
+                ## arguments in the configuration
+                configuration_parameters = redirection_data['parameters'] or {}
+                params_to_pass.update(configuration_parameters)
+
+                ## Let's add default parameters if the plugin expects them
+                if 'component' in params_to_pass:
+                    params_to_pass['component'] = component
+                if 'path' in params_to_pass:
+                    params_to_pass['path'] = path
+                if 'user_info' in params_to_pass:
+                    params_to_pass['user_info'] = collect_user_info(req)
+                if 'req' in params_to_pass:
+                    params_to_pass['req'] = req
+                try:
+                    new_url = goto_plugin(**params_to_pass)
+                except Exception, err:
+                    register_exception(req=req, alert_admin=True)
+                    raise SERVER_RETURN(HTTP_NOT_FOUND)
+                if new_url:
+                    if new_url.startswith('/'):
+                        new_url = CFG_SITE_URL + new_url
+                    redirect_to_url(req, new_url)
+                else:
+                    raise SERVER_RETURN(HTTP_NOT_FOUND)
+            return goto_handler, []
+        except ValueError:
+            return None, []
diff --git a/modules/webstyle/lib/webinterface_layout.py b/modules/webstyle/lib/webinterface_layout.py
index b11bbedc3..7780669e2 100644
--- a/modules/webstyle/lib/webinterface_layout.py
+++ b/modules/webstyle/lib/webinterface_layout.py
@@ -1,361 +1,369 @@
 # -*- coding: utf-8 -*-
 
 ## This file is part of Invenio.
 ## Copyright (C) 2006, 2007, 2008, 2009, 2010, 2011, 2012 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 ## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
 """
 Global organisation of the application's URLs.
 
 This module binds together Invenio's modules and maps them to
 their corresponding URLs (ie, /search to the websearch modules,...)
 """
 
 from invenio.webinterface_handler import create_handler
 from invenio.errorlib import register_exception
 from invenio.webinterface_handler import WebInterfaceDirectory
 from invenio import webinterface_handler_config as apache
 from invenio.config import CFG_DEVEL_SITE, CFG_OPENAIRE_SITE
 
 class WebInterfaceDumbPages(WebInterfaceDirectory):
     """This class implements a dumb interface to use as a fallback in case of
     errors importing particular module pages."""
     _exports = ['']
     def __call__(self, req, form):
         try:
             from invenio.webpage import page
         except ImportError:
             page = lambda * args: args[1]
         req.status = apache.HTTP_INTERNAL_SERVER_ERROR
         msg = "<p>This functionality is experiencing a temporary failure.</p>"
         msg += "<p>The administrator has been informed about the problem.</p>"
         try:
             from invenio.config import CFG_SITE_ADMIN_EMAIL
             msg += """<p>You can contact <code>%s</code>
                          in case of questions.</p>""" % \
                       CFG_SITE_ADMIN_EMAIL
         except ImportError:
             pass
         msg += """<p>We hope to restore the service soon.</p>
                   <p>Sorry for the inconvenience.</p>"""
         try:
             return page('Service failure', msg)
         except:
             return msg
 
     def _lookup(self, component, path):
         return WebInterfaceDumbPages(), path
     index = __call__
 
 try:
     from invenio.websearch_webinterface import WebInterfaceSearchInterfacePages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceSearchInterfacePages = WebInterfaceDumbPages
 
 try:
     from invenio.websearch_webinterface import WebInterfaceRSSFeedServicePages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceRSSFeedServicePages = WebInterfaceDumbPages
 
 try:
     from invenio.websearch_webinterface import WebInterfaceUnAPIPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceUnAPIPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibdocfile_webinterface import bibdocfile_legacy_getfile
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     bibdocfile_legacy_getfile = WebInterfaceDumbPages
 
 try:
     from invenio.websubmit_webinterface import WebInterfaceSubmitPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceSubmitPages = WebInterfaceDumbPages
 
 try:
     from invenio.websession_webinterface import WebInterfaceYourAccountPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourAccountPages = WebInterfaceDumbPages
 
 try:
     from invenio.websession_webinterface import WebInterfaceYourTicketsPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourTicketsPages = WebInterfaceDumbPages
 
 try:
     from invenio.websession_webinterface import WebInterfaceYourGroupsPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourGroupsPages = WebInterfaceDumbPages
 
 try:
     from invenio.webalert_webinterface import WebInterfaceYourAlertsPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourAlertsPages = WebInterfaceDumbPages
 
 try:
     from invenio.webbasket_webinterface import WebInterfaceYourBasketsPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourBasketsPages = WebInterfaceDumbPages
 
 try:
     from invenio.webcomment_webinterface import WebInterfaceCommentsPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceCommentsPages = WebInterfaceDumbPages
 
 try:
     from invenio.weblinkback_webinterface import WebInterfaceRecentLinkbacksPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceRecentLinkbacksPages = WebInterfaceDumbPages
 
 try:
     from invenio.webmessage_webinterface import WebInterfaceYourMessagesPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourMessagesPages = WebInterfaceDumbPages
 
 try:
     from invenio.errorlib_webinterface import WebInterfaceErrorPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceErrorPages = WebInterfaceDumbPages
 
 try:
     from invenio.oai_repository_webinterface import WebInterfaceOAIProviderPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceOAIProviderPages = WebInterfaceDumbPages
 
 try:
     from invenio.webstat_webinterface import WebInterfaceStatsPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceStatsPages = WebInterfaceDumbPages
 try:
     from invenio.bibcirculation_webinterface import WebInterfaceYourLoansPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourLoansPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibcirculation_webinterface import WebInterfaceILLPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceILLPages = WebInterfaceDumbPages
 
 try:
     from invenio.webjournal_webinterface import WebInterfaceJournalPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceJournalPages = WebInterfaceDumbPages
 
 try:
     from invenio.webdoc_webinterface import WebInterfaceDocumentationPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceDocumentationPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibexport_method_fieldexporter_webinterface import \
          WebInterfaceFieldExporterPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceFieldExporterPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibknowledge_webinterface import WebInterfaceBibKnowledgePages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceBibKnowledgePages = WebInterfaceDumbPages
 
 try:
     from invenio.batchuploader_webinterface import \
          WebInterfaceBatchUploaderPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceBatchUploaderPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibsword_webinterface import \
          WebInterfaceSword
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceSword = WebInterfaceDumbPages
 
 try:
     from invenio.ping_webinterface import \
          WebInterfacePingPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCE')
     WebInterfacePingPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibauthorid_webinterface import WebInterfaceBibAuthorIDPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceBibAuthorIDPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibcirculationadmin_webinterface import \
          WebInterfaceBibCirculationAdminPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceBibCirculationAdminPages = WebInterfaceDumbPages
 
 try:
     from invenio.bibsched_webinterface import \
          WebInterfaceBibSchedPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceBibSchedPages = WebInterfaceDumbPages
 
 try:
     from invenio.webauthorprofile_webinterface import WebAuthorPages
     WebInterfaceWebAuthorPages = WebAuthorPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceWebAuthorPages = WebInterfaceDumbPages
 
 try:
     from invenio.docextract_webinterface import WebInterfaceDocExtract
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceDocExtract = WebInterfaceDumbPages
 
 try:
     from invenio.webcomment_webinterface import WebInterfaceYourCommentsPages
 except:
     register_exception(alert_admin=True, subject='EMERGENCY')
     WebInterfaceYourAlertsPages = WebInterfaceDumbPages
 
+try:
+    from invenio.goto_webinterface import WebInterfaceGotoPages
+except:
+    register_exception(alert_admin=True, subject='EMERGENCY')
+    WebInterfaceGotoPages = WebInterfaceDumbPages
+
 if CFG_OPENAIRE_SITE:
     try:
         from invenio.openaire_deposit_webinterface import \
             WebInterfaceOpenAIREDepositPages
     except:
         register_exception(alert_admin=True, subject='EMERGENCY')
         WebInterfaceOpenAIREDepositPages = WebInterfaceDumbPages
     openaire_exports = ['deposit']
 else:
     openaire_exports = []
 
 if CFG_DEVEL_SITE:
     try:
         from invenio.httptest_webinterface import WebInterfaceHTTPTestPages
     except:
         register_exception(alert_admin=True, subject='EMERGENCY')
         WebInterfaceHTTPTestPages = WebInterfaceDumbPages
     test_exports = ['httptest']
 else:
     test_exports = []
 
 class WebInterfaceAdminPages(WebInterfaceDirectory):
     """This class implements /admin2 admin pages."""
     _exports = ['index', 'bibcirculation', 'bibsched']
     def index(self, req, form):
         return "FIXME: return /help/admin content"
     bibcirculation = WebInterfaceBibCirculationAdminPages()
     bibsched = WebInterfaceBibSchedPages()
 
 class WebInterfaceInvenio(WebInterfaceSearchInterfacePages):
     """ The global URL layout is composed of the search API plus all
     the other modules."""
 
     _exports = WebInterfaceSearchInterfacePages._exports + \
                [
                    'youraccount',
                    'youralerts',
                    'yourbaskets',
                    'yourmessages',
                    'yourloans',
                    'yourcomments',
                    'ill',
                    'yourgroups',
                    'yourtickets',
                    'comments',
                    'error',
                    'oai2d', ('oai2d.py', 'oai2d'),
                    ('getfile.py', 'getfile'),
                    'submit',
                    'rss',
                    'stats',
                    'journal',
                    'help',
                    'unapi',
                    'exporter',
                    'kb',
                    'batchuploader',
                    'bibsword',
                    'ping',
                    'person',
                    'admin2',
                    'linkbacks',
                    'author',
                    'textmining',
+                   'goto',
                ] + test_exports + openaire_exports
 
     def __init__(self):
         self.getfile = bibdocfile_legacy_getfile
         if CFG_DEVEL_SITE:
             self.httptest = WebInterfaceHTTPTestPages()
         if CFG_OPENAIRE_SITE:
             self.deposit = WebInterfaceOpenAIREDepositPages()
 
     submit = WebInterfaceSubmitPages()
     youraccount = WebInterfaceYourAccountPages()
     youralerts = WebInterfaceYourAlertsPages()
     yourbaskets = WebInterfaceYourBasketsPages()
     yourmessages = WebInterfaceYourMessagesPages()
     yourloans = WebInterfaceYourLoansPages()
     ill = WebInterfaceILLPages()
     yourgroups = WebInterfaceYourGroupsPages()
     yourtickets = WebInterfaceYourTicketsPages()
     comments = WebInterfaceCommentsPages()
     error = WebInterfaceErrorPages()
     oai2d = WebInterfaceOAIProviderPages()
     rss = WebInterfaceRSSFeedServicePages()
     stats = WebInterfaceStatsPages()
     journal = WebInterfaceJournalPages()
     help = WebInterfaceDocumentationPages()
     unapi = WebInterfaceUnAPIPages()
     exporter = WebInterfaceFieldExporterPages()
     kb = WebInterfaceBibKnowledgePages()
     admin2 = WebInterfaceAdminPages()
     batchuploader = WebInterfaceBatchUploaderPages()
     bibsword = WebInterfaceSword()
     ping = WebInterfacePingPages()
     person = WebInterfaceBibAuthorIDPages()
     linkbacks = WebInterfaceRecentLinkbacksPages()
     #redirects author to the new webauthor
     author = WebInterfaceWebAuthorPages()
     #author = WebInterfaceAuthorPages()
     textmining = WebInterfaceDocExtract()
     yourcomments = WebInterfaceYourCommentsPages()
+    goto = WebInterfaceGotoPages()
 
 # This creates the 'handler' function, which will be invoked directly
 # by mod_python.
 invenio_handler = create_handler(WebInterfaceInvenio())
diff --git a/modules/webstyle/lib/webstyle_regression_tests.py b/modules/webstyle/lib/webstyle_regression_tests.py
index fc017aa51..d0fd10918 100644
--- a/modules/webstyle/lib/webstyle_regression_tests.py
+++ b/modules/webstyle/lib/webstyle_regression_tests.py
@@ -1,68 +1,133 @@
 # -*- coding: utf-8 -*-
 ##
 ## This file is part of Invenio.
-## Copyright (C) 2010, 2011 CERN.
+## Copyright (C) 2010, 2011, 2013 CERN.
 ##
 ## Invenio is free software; you can redistribute it and/or
 ## modify it under the terms of the GNU General Public License as
 ## published by the Free Software Foundation; either version 2 of the
 ## License, or (at your option) any later version.
 ##
 ## Invenio is distributed in the hope that it will be useful, but
 ## WITHOUT ANY WARRANTY; without even the implied warranty of
 ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 ## General Public License for more details.
 ##
 ## You should have received a copy of the GNU General Public License
 ## along with Invenio; if not, write to the Free Software Foundation, Inc.,
 ## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
 
 """WebStyle Regression Test Suite."""
 
 __revision__ = "$Id$"
 
 import unittest
 import httplib
 import os
 import urlparse
 import mechanize
+from urllib2 import urlopen, HTTPError
 
-from invenio.config import CFG_SITE_URL, CFG_PREFIX, CFG_DEVEL_SITE
+from invenio.config import CFG_SITE_URL, CFG_SITE_SECURE_URL, CFG_PREFIX, CFG_DEVEL_SITE
 from invenio.bibdocfile import calculate_md5
 from invenio.testutils import make_test_suite, run_test_suite
+from invenio.goto_engine import CFG_GOTO_PLUGINS, register_redirection, drop_redirection, update_redirection
 
+def get_final_url(url):
+    """Perform a GET request to the given URL, discarding the result and return
+    the final one in case of redirections"""
+    response = urlopen(url)
+    response.read()
+    return response.url
 
-class WebStyleWSGIUtilsTest(unittest.TestCase):
+class WebStyleWSGIUtilsTests(unittest.TestCase):
     """Test WSGI Utils."""
 
     if CFG_DEVEL_SITE:
         def test_iteration_over_posted_file(self):
             """webstyle - posting a file via form upload"""
             path = os.path.join(CFG_PREFIX, 'lib', 'webtest', 'invenio', 'test.gif')
             body = open(path).read()
             br = mechanize.Browser()
             br.open(CFG_SITE_URL + '/httptest/post1').read()
             br.select_form(nr=0)
             br.form.add_file(open(path))
             body2 = br.submit().read()
             self.assertEqual(body, body2, "Body sent differs from body received")
             pass
 
     if CFG_DEVEL_SITE:
         def test_posting_file(self):
             """webstyle - direct posting of a file"""
             path = os.path.join(CFG_PREFIX, 'lib', 'webtest', 'invenio', 'test.gif')
             body = open(path).read()
             md5 = calculate_md5(path)
             mimetype = 'image/gif'
             connection = httplib.HTTPConnection(urlparse.urlsplit(CFG_SITE_URL)[1])
             connection.request('POST', '/httptest/post2', body, {'Content-MD5': md5, 'Content-Type': mimetype, 'Content-Disposition': 'filename=test.gif'})
             response = connection.getresponse()
             body2 = response.read()
             self.assertEqual(body, body2, "Body sent differs from body received")
 
 
-TEST_SUITE = make_test_suite(WebStyleWSGIUtilsTest)
+class WebStyleGotoTests(unittest.TestCase):
+    """Test the goto framework"""
+    def tearDown(self):
+        drop_redirection('first_record')
+        drop_redirection('invalid_external')
+        drop_redirection('latest_article')
+        drop_redirection('latest_pdf_article')
+
+    def test_plugin_availability(self):
+        """webstyle - test GOTO plugin availability"""
+        self.failUnless('goto_plugin_simple' in CFG_GOTO_PLUGINS)
+        self.failUnless('goto_plugin_latest_record' in CFG_GOTO_PLUGINS)
+        self.failUnless('goto_plugin_cern_hr_documents' in CFG_GOTO_PLUGINS)
+        self.failIf(CFG_GOTO_PLUGINS.get_broken_plugins())
+
+    def test_simple_relative_redirection(self):
+        """webstyle - test simple relative redirection via goto_plugin_simple"""
+        register_redirection('first_record', 'goto_plugin_simple', parameters={'url': '/record/1'})
+        self.assertEqual(get_final_url(CFG_SITE_URL + '/goto/first_record'), CFG_SITE_URL + '/record/1')
+
+    def test_simple_absolute_redirection(self):
+        """webstyle - test simple absolute redirection via goto_plugin_simple"""
+        register_redirection('first_record', 'goto_plugin_simple', parameters={'url': CFG_SITE_URL + '/record/1'})
+        self.assertEqual(get_final_url(CFG_SITE_URL + '/goto/first_record'), CFG_SITE_URL + '/record/1')
+
+    def test_simple_absolute_redirection_https(self):
+        """webstyle - test simple absolute redirection to https via goto_plugin_simple"""
+        register_redirection('first_record', 'goto_plugin_simple', parameters={'url': CFG_SITE_SECURE_URL + '/record/1'})
+        self.assertEqual(get_final_url(CFG_SITE_URL + '/goto/first_record'), CFG_SITE_SECURE_URL + '/record/1')
+
+    def test_invalid_external_redirection(self):
+        """webstyle - test simple absolute redirection to https via goto_plugin_simple"""
+        register_redirection('invalid_external', 'goto_plugin_simple', parameters={'url': 'http://www.google.com'})
+        self.assertRaises(HTTPError, get_final_url, CFG_SITE_URL + '/goto/google')
+
+    def test_latest_article_redirection(self):
+        """webstyle - test redirecting to latest article via goto_plugin_latest_record"""
+        register_redirection('latest_article', 'goto_plugin_latest_record', parameters={'cc': 'Articles'})
+        self.assertEqual(get_final_url(CFG_SITE_URL + '/goto/latest_article'), CFG_SITE_URL + '/record/108')
+
+    def FIXME_test_latest_pdf_article_redirection(self):
+        """webstyle - test redirecting to latest article via goto_plugin_latest_record"""
+        register_redirection('latest_pdf_article', 'goto_plugin_latest_record', parameters={'cc': 'Articles', 'format': '.pdf'})
+        self.assertEqual(get_final_url(CFG_SITE_URL + '/goto/latest_pdf_article'), CFG_SITE_URL + '/record/97/files/0002060.pdf')
+
+    def FIXME_test_URL_argument_in_redirection(self):
+        """webstyle - test redirecting while passing arguments on the URL"""
+        register_redirection('latest_article', 'goto_plugin_latest_record', parameters={'cc': 'Articles'})
+        self.assertEqual(get_final_url(CFG_SITE_URL + '/goto/latest_article?format=.pdf'), CFG_SITE_URL + '/record/97/files/0002060.pdf')
+
+    def test_updating_redirection(self):
+        """webstyle - test updating redirection"""
+        register_redirection('first_record', 'goto_plugin_simple', parameters={'url': '/record/1'})
+        update_redirection('first_record', 'goto_plugin_simple', parameters={'url': '/record/2'})
+        self.assertEqual(get_final_url(CFG_SITE_URL + '/goto/first_record'), CFG_SITE_URL + '/record/2')
+
+
+TEST_SUITE = make_test_suite(WebStyleWSGIUtilsTests, WebStyleGotoTests)
 
 if __name__ == "__main__":
     run_test_suite(TEST_SUITE, warn_user=True)