Automated way to create persistent MUC rooms?

Hi I have a text file containing a list of room names that I would like to make into MUC rooms. Does anyone know of an automated way to do this?

I am using a mysql database, is there (are there) a table(s) which contains this information?