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.

