Tables missing from database after updating

After updating the bp-better-messages plugin from version 2.0.67 to 2.0.68

I am getting the following error

WordPress database error: [Table 'db_name.wp_bm_threads' doesn't exist]
WordPress database error: [Table 'db_name.wp_bm_message_recipients' doesn't exist]

I tried the following steps in order:

1. Deactivated then deleted the bp-better-messages plugin
2. Removed all tables with prefix bm from the database
3. Removed options from wp_options table containing the word bp-messages or better-messages.
4. Re-installed the plugin

Next time when I install the plugin again, i see the same error as mentioned above

I put log statements inside the plugin code and here is the wordpress error

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL,
                      <code>date_sent</code> datetime NOT NULL,
                 ' at line 5 for query CREATE TABLE IF NOT EXISTS <code>wp_bm_message_messages</code> (
                      <code>id</code> bigint(20) NOT NULL AUTO_INCREMENT,
                      <code>thread_id</code> bigint(20) NOT NULL,
                      <code>sender_id</code> bigint(20) NOT NULL,
                      <code>message</code> longtext CHARACTER SET utf8mb3 COLLATE  NOT NULL,
                      <code>date_sent</code> datetime NOT NULL,
                      PRIMARY KEY (<code>id</code>),
                      KEY <code>sender_id</code> (<code>sender_id</code>),
                      KEY <code>thread_id</code> (<code>thread_id</code>)
                    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3