Hey, I created a new .sq file, which has CREATE TABLE LastModificationDate(lastModificationDate TEXT NOT NULL); This causes a crash when testing against our production app as it says LastModificationDate. no such table: LastModificationDate: , while compiling: SELECT * FROM LastModificationDate I'm not sure how I am meant to migrate this new table, in the .sqm file I don't think I'm altering anything as its actually just a new table, so should I be creating the table in the .sqm? If so, how does that work with the functions that exist in LastModificationDate such as insert/get/delete

you need to create the table in a migration file. You dont need to create queries in a migration file

@alec just saw your message, thanks. So I created a 1.sqm file with CREATE TABLE LastModificationDate(lastModificationDate TEXT NOT NULL); Then in my LastModificationDate.sq, i just have the queries such as insert, get, delete?

you need the create table in both .sq and .sqm

Thanks. I actually just tried rebuild it with only CREATE TABLE in 1.sqm, and just the queries in the LastModificationDate.sq and it seemed to build correctly.

i see, you have

deriveSchemaFromMigrations = true

No I don't, should I add it?