Manage database partitions automatically

For time-based partitioning, we have to implement a way to manage and create partitions automatically.

• Should partitions be reflected in db/structure.sql?
• How do we create partitions automatically?