Red Hat Bugzilla – Bug 408761
Update Bugzilla/DB/Schema.pm to add in changes from rh_bugzilla_2_18 schema
Last modified: 2013-06-24 00:17:24 EDT
Description of problem:
We need to add tables/columns current in rh_bugzilla_2_18 that are being
actively used by Red Hat. This will allow a clean migration of our current
snapshots to a fresh 3.0 database created by checksetup.pl.
We can use Noura's output from her db schema script to determine that needs to be
The critical things we need to look at when migrating our data are:
1. The tables/columns that are in purple will need to be added to the
2. The columns that are in yellow that have a NOT NULL constraint will need to
be set to NULL when we import the data. Then we will need to go back and set
the values to something appropriate and re-instate the NOT NULL restriction. The
alternative would be to somehow insert appropriate values for the new columns
when the data is imported. That may prove to be more difficult to implement.
3. The new tables marked with yellow may need some default list to be populated
so cannot be left empty when the data base is created. So we may need to alter
checksetup.pl to auto-populate the new tables but leave the old ones empty for
our imported data.
Attaching the output file containing the comparison.
Created attachment 275761 [details]
HTML file comparing 3.0 schema with RH 2.18 schema
*** This bug has been marked as a duplicate of 420611 ***