Database & Migrations

php artisan make:migration create_invoices_table --path=packages/order/database/migrations

php artisan make:migration add_api_key_to_companies

Schema::create('my_table', function (Blueprint $table) {
    $table->string('id')->primary();              // KSUID primary key
    $table->string('name');
    $table->text('description')->nullable();
    $table->string('company_id')->index();         // Multi-tenant scoping
    $table->string('organization_id')->index();    // Organization scoping
    $table->string('created_by')->nullable();      // Audit trail
    $table->timestamps();                          // created_at, updated_at
    $table->softDeletes();                         // deleted_at (if needed)
});

// Reference another KSUID-based table
$table->string('product_id');
$table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');

# Run all pending migrations
php artisan migrate

# Rollback the last batch
php artisan migrate:rollback

# Fresh install (destructive - drops all tables)
php artisan migrate:fresh --seed

# Check migration status
php artisan migrate:status

$table->jsonb('options')->nullable();    // Variant options
$table->jsonb('properties')->nullable(); // Activity log changes
$table->jsonb('extra_permissions');      // Additional permissions

Product::whereJsonContains('tags', 'electronics')->get();

php artisan db:seed                           # Run all seeders
php artisan db:seed --class=PaymentMethodSeeder  # Run specific seeder

SELECT 'roles_without_company' AS issue, count(*) AS rows
FROM iam_roles r LEFT JOIN team_companies c ON c.id = r.company_id
WHERE r.company_id IS NOT NULL AND c.id IS NULL
UNION ALL
SELECT 'role_pivots_without_company', count(*)
FROM iam_model_has_roles r LEFT JOIN team_companies c ON c.id = r.company_id
WHERE c.id IS NULL
UNION ALL
SELECT 'permission_pivots_without_company', count(*)
FROM iam_model_has_permissions r LEFT JOIN team_companies c ON c.id = r.company_id
WHERE c.id IS NULL
UNION ALL
SELECT 'roles_wrong_organization', count(*)
FROM iam_roles r JOIN team_companies c ON c.id = r.company_id
WHERE r.organization_id IS DISTINCT FROM c.organization_id
UNION ALL
SELECT 'profiles_wrong_owner', count(*)
FROM iam_profiles p LEFT JOIN team_companies c ON c.id = p.company_id
WHERE c.id IS NULL OR p.organization_id IS DISTINCT FROM c.organization_id
UNION ALL
SELECT 'assignments_wrong_profile_scope', count(*)
FROM iam_user_profiles u LEFT JOIN iam_profiles p ON p.id = u.profile_id
WHERE p.id IS NULL OR u.company_id IS DISTINCT FROM p.company_id
   OR u.organization_id IS DISTINCT FROM p.organization_id
UNION ALL
SELECT 'agents_wrong_company', count(*)
FROM team_agents a LEFT JOIN team_companies c ON c.id = a.company_id
WHERE c.id IS NULL OR a.organization_id IS DISTINCT FROM c.organization_id
UNION ALL
SELECT 'agents_wrong_profile_scope', count(*)
FROM team_agents a LEFT JOIN iam_profiles p ON p.id = a.profile_id
WHERE a.profile_id IS NOT NULL AND
  (p.id IS NULL OR a.company_id IS DISTINCT FROM p.company_id
   OR a.organization_id IS DISTINCT FROM p.organization_id)
UNION ALL
SELECT 'invitations_wrong_company', count(*)
FROM team_invitations i LEFT JOIN team_companies c ON c.id = i.company_id
WHERE c.id IS NULL OR i.organization_id IS DISTINCT FROM c.organization_id
UNION ALL
SELECT 'refreshes_wrong_company', count(*)
FROM notification_client_refreshes r LEFT JOIN team_companies c ON c.id = r.company_id
WHERE c.id IS NULL OR r.organization_id IS DISTINCT FROM c.organization_id;

php artisan optimize:clear
php artisan migrate --force
php artisan permissions:discover --guard=client-api
php artisan permissions:discover --guard=client-agent
php artisan permission:cache-reset
php artisan config:cache
php artisan route:cache