The module Schema reported tables for which the schema and database are different.

Comments

nardberjean’s picture

Issue tags: +schema

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)