laravel-vuexy-website-admin/database/migrations/create_sitemap_urls_table.php
2025-03-22 12:41:56 -06:00

33 lines
879 B
PHP

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*/
public function up(): void
{
Schema::create('sitemap_urls', function (Blueprint $table) {
$table->id();
$table->string('url')->unique();
$table->enum('changefreq', ['always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly'])->default('weekly');
$table->decimal('priority', 2, 1)->default(0.5);
$table->timestamp('lastmod')->nullable();
$table->boolean('is_active')->default(true);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('sitemap_urls');
}
};