migration

name	migration
description	Generate database migration file for CatchAdmin module.

Step 2: Generate Migration

创建数据库迁移文件。

File Location

modules/{Module}/database/migrations/{timestamp}_create_{table}_table.php

Template

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('{table}', function (Blueprint $table) {
            $table->id();
            
            // Business fields (generated from definition)
            
            // CatchAdmin standard fields
            $table->unsignedInteger('creator_id')->default(0);
            $table->unsignedInteger('created_at')->default(0);
            $table->unsignedInteger('updated_at')->default(0);
            $table->unsignedInteger('deleted_at')->default(0);
            
            // Indexes
            $table->index(['status', 'deleted_at']);
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('{table}');
    }
};

Field Type Mapping

Type	Migration Code
string(n)	$table->string('name', n)
text	$table->text('description')->nullable()
integer	$table->unsignedInteger('count')->default(0)
decimal(m,n)	$table->decimal('price', m, n)
tinyint	$table->tinyInteger('status')->default(1)
foreign_key	$table->unsignedBigInteger('category_id')->default(0)->index()
date	$table->date('birth_date')->nullable()
datetime	$table->dateTime('published_at')->nullable()
json	$table->json('options')->nullable()

Important

• CatchAdmin 使用 unsigned integer 作为时间戳，不使用 Laravel 默认的 timestamps()
• 软删除使用 deleted_at unsigned integer，不使用 softDeletes()
• 外键字段需要添加 index()