[Python] Does SQLITE support Unique Key Statements?

I am trying to move a db from mariadb to SQlite. I have created a dump-file out of the mariadb, which contains statements like the following example below:

CREATE TABLE IF NOT EXISTS Persons (PersonID int,name varchar(255),

LastName varchar(255), FirstName varchar(255), Address varchar(255),

City varchar(255),UNIQUE KEY `ID1234567` (`name`))


When trying to execute the statement on my sqlite db, I always get an

OperationalError: near "KEY": syntax error
​

My question is, does SQLIte support statements of that kind? or do i need to filter them out?



The website of sqlite shows this chart.

is there any way to include these key statements or are they completely not supported in sqlite? If not, what is the reason for this?

Continue reading...