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 moved over. 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 Bugzilla/DB/Schema.pm file. 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 ***