What is the criteria for tables inside 000, 001, 002...011 in sqlmigration?

[ohyoona]

For example, inside the 003_add dashboards.go file, there is logic to create the dashboards, rules, notification channels, planned maintenance, and ttl_status tables.

[grandwizard28]

Hi @ohyoona,
As part of our efforts to streamline, re-architect, re-design, revamp our codebase architecture, we have decided to put all our sql migrations at one place.

Migrations till number 9 have been picked verbatim from various older and disorganized parts of the codebase. For instance, add_dashboards migrations was taken from the now removed dashboards.InitDB function which was unfortunately adding other tables as well. Since we picked it from the dashboards module, we decided to name it add_dashboards.

While we agree the current migration names do not accurately reflect what is happening in the migration, our plan is to now add sensible and understandable migrations on top of it.