Добрый день. При запуске скрипта возникли предупреждения.
Подскажите, как их убрать? Какие команды mysql запустить для устранения ошибок. Можно ли обновлять систему в таком состоянии?
Спасибо заранее. Жду от Вас ответа.
root@moodle:/var/www/html/admin/cli#
php check_database_schema.php
-------------------------------------------------------------------------------
hotpot
* column 'delay3' has default '2', expected '0' (I)
* column 'grademethod' has default '0', expected '1' (I)
-------------------------------------------------------------------------------
hotpot_cache
* column 'usefilters' length is 2, expected at least 4 (I)
* column 'useglossary' length is 2, expected at least 4 (I)
-------------------------------------------------------------------------------
jitsi_record
* column 'link' has incorrect type 'X', expected 'C'
-------------------------------------------------------------------------------
block_quickmail_signatures
* column 'user_id' has default '0', expected 'NULL' (I)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
* column 'timedeleted' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_messages
* column 'sent_at' has default '0', expected 'NULL' (I)
* column 'to_send_at' has default '0', expected 'NULL' (I)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
* column 'timedeleted' should allow NULL (I)
* column 'timedeleted' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_msg_recips
* column 'sent_at' has default '0', expected 'NULL' (I)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_draft_recips
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_msg_ad_email
* column 'sent_at' has default '0', expected 'NULL' (I)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_msg_attach
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_alt_emails
* column 'firstname' length is 125, expected 100 (C)
* column 'lastname' length is 125, expected 100 (C)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
* column 'timedeleted' should allow NULL (I)
* column 'timedeleted' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_notifs
* column 'subject' should be NOT NULL (X)
* column 'body' should be NOT NULL (X)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
* column 'timedeleted' should allow NULL (I)
* column 'timedeleted' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_event_notifs
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
* column 'timedeleted' should allow NULL (I)
* column 'timedeleted' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_schedules
* column 'amount' has default '0', expected 'NULL' (I)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
* column 'timedeleted' should allow NULL (I)
* column 'timedeleted' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_rem_notifs
* column 'object_id' has default '0', expected 'NULL' (I)
* column 'schedule_id' has default '0', expected 'NULL' (I)
* column 'usermodified' has default '0', expected 'NULL' (I)
* column 'timecreated' has default '0', expected 'NULL' (I)
* column 'timemodified' has default '0', expected 'NULL' (I)
* column 'timedeleted' should allow NULL (I)
* column 'timedeleted' has default '0', expected 'NULL' (I)
-------------------------------------------------------------------------------
block_quickmail_drafts
* table is not expected
-------------------------------------------------------------------------------
block_quickmail_log
* table is not expected
-------------------------------------------------------------------------------
recordingsbn
* table is not expected
-------------------------------------------------------------------------------