Install script to create database

[bufke]

KoboToolbox requires two databases. Most users would deploy one postgresql server and create the second database. It would be nice if this could be automated. It should default to disabled.

Requirements:

• Disabled by default
• An optional prefix for database name
• Assumes the helm chart has credentials and permissions to create database
• Only create when the database doesn't already exist
• Only run on install, not update

Questions:

1. Should it create both?
2. Is there a way to set the DB string just once? Often it's set multiple times.

Bonus requirements:

• Deploy the mongo db indexes

import pymongo
settings.MONGO_DB.instances.create_index([("_userform_id", pymongo.ASCENDING)])
settings.MONGO_DB.instances.create_index([("_userform_id", pymongo.ASCENDING), ("_id", pymongo.DESCENDING)])