d8d-admin-mobile-starter-public/server/migrations/006_createThemeSettingsTable.ts

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

const createThemeSettingsTable: MigrationLiveDefinition = {
  name: "create_theme_settings_table",
  up: async (api) => {
    await api.schema.createTable('theme_settings', (table) => {
      table.increments('id').primary();
      table.integer('user_id').unsigned().references('id').inTable('users').onDelete('CASCADE');
      table.jsonb('settings').comment('主题设置');
      table.timestamps(true, true);
      
      // 添加索引
      table.index('user_id');
    });
  },
  down: async (api) => {
    await api.schema.dropTable('theme_settings');
  }
}

export default createThemeSettingsTable;