Ok, so today I spent the day testing the code to automatically create partitions with a trigger, and trying to fix a bug with it, but then it turned out that this should not ever be done. In the process I did tidy up the code for setting up the databases.