So for SQLite, change the bookid line in the CREATE TABLE statement above to this: bookid integer PRIMARY KEY, And, SQLite3 will create a table with equivalent settings to MariaDB and PostgreSQL. The ...