d8d-admin-mobile-starter-public/server/migrations/014_createZichanTransLogTable.ts

import type { MigrationLiveDefinition } from '@d8d-appcontainer/types'
import { DeleteStatus } from "../../client/share/types.ts";
import { DisabledStatus } from "../../client/share/monitorTypes.ts";

// 定义资产流转表迁移
const createZichanTransLogTable: MigrationLiveDefinition = {
  name: "create_zichan_trans_log_table",
  up: async (api) => {
    await api.schema.createTable('zichan_trans_log', (table) => {
      table.increments('id').primary();
      table.integer('asset_transfer').comment('资产流转类型');
      table.integer('asset_id').unsigned().references('id').inTable('zichan_info').onDelete('CASCADE').comment('资产ID');
      table.string('person').comment('人员');
      table.string('department').comment('部门');
      table.string('phone').comment('电话');
      table.text('transfer_reason').comment('流转事由');
      table.timestamp('transfer_time').comment('流转时间');
      table.integer('is_disabled').defaultTo(DisabledStatus.ENABLED).comment('是否被禁用 (0否 1是)');
      table.integer('is_deleted').defaultTo(DeleteStatus.NOT_DELETED).comment('是否被删除 (0否 1是)');
      table.timestamps(true, true);
      
      // 添加索引
      table.index('asset_id');
      table.index('asset_transfer');
      table.index('transfer_time');
      table.index('is_deleted');
    });
  },
  down: async (api) => {
    await api.schema.dropTable('zichan_trans_log');
  }
};

export default createZichanTransLogTable