The module Schema reported tables for which the schema and database are different.
admin/build/schema/compare
Top of page warning:
* bt_tracker_users.bytes_downloaded is type int but its default 1 is PHP type boolean
* bt_torrents.announce_url is type text and may not have a default value
* bt_torrents_files.path is type text and may not have a default value
Mismatch (3):
* bt_torrents
o column announce_url - difference on: default declared: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'size' => 'big', 'not null' => TRUE, 'default' => '') actual: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'size' => 'big', 'not null' => TRUE)
* bt_torrents_files
o column path - difference on: default declared: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'not null' => TRUE, 'default' => '') actual: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'not null' => TRUE)
* bt_tracker_users
o column passkey_status - difference on: length declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'length' => 2, 'not null' => TRUE, 'default' => 0) actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'not null' => TRUE, 'default' => 0)
Comments
Comment #1
nardberjean commentedadmin/build/schema/compare
Top of page warning:
* bt_tracker_users.bytes_downloaded is type int but its default 1 is PHP type boolean
* bt_torrents.announce_url is type text and may not have a default value
* bt_torrents_files.path is type text and may not have a default value
Mismatch (3):
*
bt_torrents
o column announce_url - difference on: default
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'size' => 'big', 'not null' => TRUE, 'default' => '')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'size' => 'big', 'not null' => TRUE)
*
bt_torrents_files
o column path - difference on: default
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'not null' => TRUE, 'default' => '')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'text', 'not null' => TRUE)
*
bt_tracker_users
o column passkey_status - difference on: length
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'length' => 2, 'not null' => TRUE, 'default' => 0)
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'not null' => TRUE, 'default' => 0)