d8d-admin-mobile-starter-public/server/migrations/001_createUsersTable.ts

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

const createUsersTable: MigrationLiveDefinition = {
  name: "create_users_table",
  up: async (api) => {
    await api.schema.createTable('users', (table) => {
      table.increments('id').primary();
      table.string('username').unique().notNullable();
      table.string('password').notNullable();
      table.string('phone').unique();
      table.string('email').unique();
      table.string('nickname');
      table.string('name');
      table.integer('is_disabled').defaultTo(DeleteStatus.NOT_DELETED);
      table.integer('is_deleted').defaultTo(DeleteStatus.NOT_DELETED);
      
      // 用户角色: teacher(教师)/admin(管理员)/student(学生)/fan(粉丝)
      table.enum('role', ['teacher', 'admin', 'student', 'fan']).notNullable().defaultTo('student');
      
      // 账户有效期，为空表示永久有效
      table.timestamp('valid_until').nullable();
      
      table.timestamps(true, true);
      
      // 添加索引
      table.index('username');
      table.index('is_disabled');
      table.index('is_deleted');
    });
  },
  down: async (api) => {
    await api.schema.dropTable('users');
  }
}

export default createUsersTable;