5.7.185. Bugzilla::Extension::RedHat::bin::bz-schema-audit

5.7.185.1. NAME

bz-schema-audit.pl - Audit the bz_schema table against the current Bugzilla DB or compare the schemas between two Bugzilla Databases, or.

5.7.185.2. Description

This script can compare two Bugzilla databases or audit a single Bugzilla DB to ensure the bz_schema tables matches the actual DB.

To compare two databases you need to supply the path to a YAML file containing the Db details for two Bugzilla databases.

e.g.

5.7.185.3. SYNOPSIS

bz-schema-audit.pl [options]

5.7.185.4. OPTIONS

  • –help
Print a brief help message and exits.
  • –man
Prints the manual page and exits.
  • –conf=<path to YAML file>
The YAML configuration file.
  • –compare
Compare two Bugzilla DBs.
  • –types
Include type checking when auditing the schema.
  • –nulls
Include is null-able checking when auditing the schema.
  • –keys
Include primary & foreign keys checks when auditing the schema.
  • –all
Perfomr alll the audit functions
  • –verbose
Print out some data structures when reporting.

This documentation undoubtedly has bugs; if you find some, please file them here.