bcdfeath

Personally, I hate to put anything in master, model, & msdb. What I have done with your code is to create a single combined database on each SQL instance named...

On second hand, why not name the schema Sweetness because that is what the software is?

Absolutely agree. The KISS solution is to use a unique schema name for all the installed work. Otherwise there has to be a full bore maintenance routine that does check...

Making the schema name configurable would turn into a maintenance death march for you. If that happens you will have to start charging for the software just for the headaches....