CREATE TABLE Test (ID AutoIncrement Constraint PrimaryKey PRIMARY KEY, OtherField TEXT);

Roger