Sorry, I accidentally included 'INTEGER' before 'REFERENCES'.  Should have been

CREATE TABLE category(
    category_id         INTEGER PRIMARY KEY AUTOINCREMENT,
    category_name       TEXT
);

CREATE TABLE recipes_in_categories(
    r_i_c_id            INTEGER PRIMARY KEY AUTOINCREMENT,
    recipe_id           REFERENCES recipe_data(recipe_id),
    category_id         REFERENCES category(category_id)
);

Simon.

Reply via email to