Migrations

php glueful migrate:create create_users_table

<?php

namespace Glueful\Database\Migrations;

use Glueful\Database\Migrations\MigrationInterface;
use Glueful\Database\Schema\Interfaces\SchemaBuilderInterface;

class CreateUsersTable implements MigrationInterface
{
    public function getDescription(): string
    {
        return 'Create users table with auth + lifecycle fields';
    }

    public function up(SchemaBuilderInterface $schema): void
    {
        // Using callback auto-executes the create immediately
        $schema->createTable('users', function($table) {
            $table->id();                                 // Auto-increment primary key (id)
            $table->string('uuid', 12)->unique();         // External identifier
            $table->string('name', 100);
            $table->string('email')->unique();
            $table->string('password');
            $table->boolean('is_active')->default(true);
            $table->timestamps();                        // created_at / updated_at
            $table->softDeletes();                       // deleted_at
        });
    }

    public function down(SchemaBuilderInterface $schema): void
    {
        $schema->dropTable('users');
    }
}

# Run all pending migrations
php glueful migrate:run

# Rollback last batch (default 1 step)
php glueful migrate:rollback

# Rollback N individual migrations (most recent first)
php glueful migrate:rollback --steps=3

# Reset (drop all tables)
php glueful db:reset

# Fresh start: drop then re-run migrations
php glueful db:reset && php glueful migrate:run

# Show applied vs pending
php glueful migrate:status

$table->string('email')
    ->unique()                // Unique index
    ->index()                 // Plain index (optional if unique already)
    ->nullable(false)         // Explicit NOT NULL
    ->default('')             // Static default
    ->comment('Login email');

$table->decimal('price', 10, 2)
    ->unsigned()
    ->default(0)
    ->check('price >= 0');

$table->timestamp('created_at')
    ->useCurrent();           // CURRENT_TIMESTAMP

$table->timestamp('updated_at')
    ->nullable()
    ->useCurrent()
    ->useCurrentOnUpdate();

// Single
$table->index('email');

// Composite
$table->index(['user_id', 'created_at']);

// Unique
$table->unique('username');

// Named
$table->index('status', 'idx_users_status');

// Primary (composite)
$table->primary(['tenant_id', 'code']);

// Fulltext (where supported)
$table->fulltext('content');

$table->foreignId('user_id')
    ->constrained('users')   // References users.id
    ->cascadeOnDelete();

$table->string('created_by', 12)->nullable();
$table->foreign('created_by')
    ->references('uuid')
    ->on('users')
    ->nullOnDelete();

$schema->table('products')
    ->id()
    ->string('uuid', 12)->unique()
    ->string('name')
    ->string('slug')->unique()
    ->text('description')->nullable()
    ->decimal('price', 10, 2)->unsigned()->default(0)
    ->integer('stock')->default(0)
    ->boolean('is_active')->default(true)
    ->foreignId('category_id')->constrained('categories')->nullOnDelete()
    ->json('metadata')->nullable()
    ->timestamps()
    ->softDeletes()
    ->index('is_active')
    ->index(['category_id', 'is_active'])
    ->create()
    ->execute(); // Execute queued SQL

// Add columns
$schema->alterTable('users')
    ->string('phone')->nullable()
    ->date('birth_date')->nullable()
    ->execute();

// Rename & modify
$schema->alterTable('users')
    ->renameColumn('name', 'full_name')
    ->modifyColumn('email')->string(320)   // Change length
    ->execute();

// Drop column
$schema->alterTable('users')
    ->dropColumn('birth_date')
    ->execute();

// Add index & FK
$schema->alterTable('orders')
    ->foreignId('user_id')->constrained('users')->cascadeOnDelete()
    ->index('user_id')
    ->execute();

$schema->dropTable('users');          // Fails if missing
$schema->dropTableIfExists('archive');

$schema->table('posts')
    ->id()
    ->string('uuid', 12)->unique()
    ->string('title')
    ->text('content')
    ->foreignId('user_id')->constrained('users')->cascadeOnDelete()
    ->timestamps()
    ->create();

$table->timestamps();   // created_at, updated_at
$table->softDeletes();  // deleted_at

$table->foreignId('created_by')->constrained('users')->nullOnDelete();
$table->foreignId('updated_by')->constrained('users')->nullOnDelete();

// Stage operations without executing yet
$schema->table('bulk_demo')
    ->id()
    ->string('code', 32)->unique()
    ->timestamps()
    ->create();

// Preview and validate staged SQL on the SchemaBuilder
$sql = $schema->preview();      // Array of SQL statements
$result = $schema->validate();  // Validation metadata

// Execute when ready
$schema->execute();