The wp_index_now_log table did not expand during installation

[comm644]

WP 6.4.2
sqlite-database-integration installed

When installing the plugin, the table did not expand.

[comm644]

found out:

CREATE TABLE is designed for MySQL and breaks when running on Sqlite

this is how it works:

CREATE TABLE wp_index_now_log (
                        log_id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
                        created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
                        level varchar(255) NOT NULL DEFAULT 'debug',
                        search_engine varchar(255) NOT NULL DEFAULT 'site',
                        direction varchar(255) NOT NULL DEFAULT 'incoming',
                        status_code INT(11)  NOT NULL,
                        message text NOT NULL
                                )