d8d-admin-mobile-starter-public/server/migrations/027_add_task_no_field.ts

import type { MigrationLiveDefinition } from '@d8d-appcontainer/types'

const addTaskNoField: MigrationLiveDefinition = {
  name: 'add_task_no_field',
  up: async (api) => {
    await api.schema.alterTable('inspection_tasks', (table) => {
      table.string('task_no').notNullable().comment('任务编号');
    });
  },
  down: async (api) => {
    await api.schema.alterTable('inspection_tasks', (table) => {
      table.dropColumn('task_no');
    });
  }
};

export default addTaskNoField