Although the FOREIGN KEY AND PRIMARY KEY should be seperate with a comma. SQLite still generates my tables correctly.