Community & Support

How do I fix my Database schema?

Database schema Inconsistent
The Schema comparison report shows:

* 39 modules with matching tables
* 76 extra tables
* 1 warnings
* 4 module with mis-matching tables

The database schema comparison report provides more details.

I also have this in my headers:

* Field smf_calendar.startDate: no Schema type for mysql type date.
* Field smf_calendar.endDate: no Schema type for mysql type date.
* Field smf_calendar_holidays.eventDate: no Schema type for mysql type date.
* Field smf_log_activity.date: no Schema type for mysql type date.
* Field smf_log_online.logTime: no Schema type for mysql type timestamp.
* Field smf_members.birthdate: no Schema type for mysql type date.