Description

I created a table "Recents" in an sqlite database using the app, and the generated sql is the following (I removed the quotation marks):

CREATE TABLE Recents (
  id INTEGER NOT NULL AUTO_INCREMENT,
  path TEXT NOT NULL,
  accessTime INTEGER NOT NULL,
  PRIMARY KEY (id)
);
CREATE INDEX accessTime ON Recents (accessTime);

But this is invalid sql for sqlite.
The correct sql would be:

CREATE TABLE Recents (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    path TEXT NOT NULL,
    accessTime INTEGER NOT NULL
);

CREATE INDEX accessTime ON Recents (accessTime);

Can you please fix the system that generated the "Create Code"

HeidiSQL version and OS

12.21.0.7346 Windows

Database server version

Sqlite

Reproduction recipe

Create a table using the app gui in an sqlite database that would have the configuration as in the description form above.

Error/Backtrace