References:
https://gitlab.cern.ch/cta/CTA/issues/479 (on the CTA side)
Jira: CASTOR-5526: support the migration to CTA (on the CASTOR side)

The latter won't be updated further, all required code will
be committed here and gitlab tickets will be updated accordingly.

This commit works towards issue cta/CTA#436.

CatalogueTest now asserts new archive file identifiers are unique as opposed to strictly incrementing sequentially by 1

Woah!  Got carried away with const.  This commit Removes the const
qualifier from the ArchiveFileItor::next() method because next()
modifies the iterator.

To loop through an ArchiveFileItor:

  auto itor = catalogue.getArchiveFilesForRepackItor(vid, startFSeq);
  while(itor.hasMore()) {
    const auto archiveFile = itor.next();
    // Do something with archiveFile
  }

Modified MysqlCatalogue.cpp to use autocommitMode default of Stmt::executeQuery() and Stmt::executeNonQuery()

Modified RdbmsArchiveFileItorImpl.cpp to use autocommitMode default of Stmt::executeQuery() and Stmt::executeNonQuery()

Modified DropSchemaCmd to use autocommitMode default of Stmt::executeQuery() and Stmt::executeNonQuery()

Modified CreateSchemaCmd to use autocommitMode default of Stmt::executeQuery() and Stmt::executeNonQuery()

Modified RdbmsCatalogue to use autocommitMode default of Stmt::executeQuery() and Stmt::executeNonQuery()

Please note that OracleCatalogue::filesWrittenToTape() now updates the TAPE
table row with AUTOCOMMIT_ON before going on to handle the individual file
entries.  This can be improved when Conn:setAutocommit() becomes available.

implementation of "cta-admin archivefile ls -all".  A
missing order by clause meant that non deterministic
listings were given.

This commit adds the missing "order by" clause.

Following on from GitLab issue cta/CTA#371, replaced INTEGER with NUMERIC(20, 0) within oracle_catalogue_schema_header.sql

Following on from GitLab issue cta/CTA#371, replaced INTEGER with NUMERIC(20, 0) within mysql_catalogue_schema_header.sql

Changed common_catalogue_schema.sql for cta/CTA#371 'Change INTEGER columns of CTA catalogue schema to NUMERIC(20,0)'

Fixed cta/CTA#364 RdbmsArchiveFileItorImpl constructor should NOT return database connection to pool

Added the first version of the specification of the Catalogue::getTapeFilesForRepack() method - there's no implementation yet