The user profile is an InterMine ObjectStore which stores Profile information such as username and password, tags, queries, lists and templates.
First you must create the empty database in Postgres. Use this command, replacing HOST and USER with the correct values:
# create the new database
~/git/flymine $ createdb userprofile-biotestmine
These commands are needed in the webapp to initialise a userprofile database:
# this comment populates superuser, default templates etc.
~/git/flymine $ ./gradlew buildUserDB
If you already have a userprofile database and want to keep the data it contains, you can do this:
# run in production and userprofile database. when releasing a new product
select * from intermine_metadata where key='serialNumber';
Default templates and tags are defined in default-template-queries.xml.
These are loaded when you build a userprofile database.