Found this schema module complains after D5 to D6 upgrade.
project_release_supported_versions
column recommended_release - difference on: not null
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'default' => 0)
column latest_release - difference on: not null
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'default' => 0)
column latest_security_release - difference on: not null
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'default' => 0)
We should run an update hook and correct the 'not null' and descriptions to make the schema consistent.
Comments
Comment #1
hass commentedPatch attached
Comment #2
hass commentedSchema is clean after running this update hook.
Comment #3
hass commentedComment #3.0
hass commentedA
Comment #4
hass commentedThe bug also exist in D7
Comment #5
drummThis patch doesn't apply for D7.
Comment #6
hass commentedHere is the fully tested D7 patch. After running this I have no longer any schema mismatches.
Comment #8
drummUpdate runs well, and Drupal.org's database doesn't have any NULL values for these columns. Committed.
Comment #9
hass commentedD6 patch is in #1.
Comment #10
hass commented