sqlite is slightly annoying about what kinds of columns you are allowed to add to tables after already creating them. specifically i want to have the forum column on the threads table be NOT NULL DEFAULT 1 REFERENCES forums(id) but when adding columns with ALTER TABLE the default has to be NULL if the column includes a foreign key. it would therefore be slightly easier if i could delete all threads and create a new threads table.
however i can still just create a new threads table, with the column i want, and then copy all the existing rows into it, and that can all be done in pure sql so it will even still work with our exisitng migration thingy. so you're right this isn't even much of a big deal at all.
hmm there was something else involving moderators that i think would make this a bit more difficult but i have forgotten what that was about now. i'm sure i can figure out a way around it. and anyway, the worst case is that i have to manually run a python script on the server or something. there is only one deployed instance so this isn't that hard.