41 lines
1.6 KiB
PHP
Executable File
41 lines
1.6 KiB
PHP
Executable File
<?php
|
|
|
|
use Illuminate\Database\Capsule\Manager as Capsule;
|
|
use Illuminate\Database\Schema\Blueprint;
|
|
|
|
class CreatePageBuilderTables
|
|
{
|
|
public function up()
|
|
{
|
|
// Pages
|
|
if (!Capsule::schema()->hasTable('pages')) {
|
|
Capsule::schema()->create('pages', function (Blueprint $table) {
|
|
$table->increments('pages_id');
|
|
$table->string('pages_title');
|
|
$table->string('pages_slug')->unique();
|
|
$table->longText('pages_content')->nullable();
|
|
$table->string('pages_meta_title')->nullable();
|
|
$table->text('pages_meta_description')->nullable();
|
|
$table->text('pages_meta_keywords')->nullable();
|
|
$table->boolean('pages_is_published')->default(false);
|
|
$table->boolean('pages_public')->default(true);
|
|
$table->timestamp('pages_published_at')->nullable();
|
|
$table->string('pages_theme')->nullable()->index(); // Alterado de pages_theme_id para pages_theme (slug)
|
|
$table->string('pages_layout')->default('default');
|
|
$table->string('pages_css_classes')->nullable();
|
|
$table->text('pages_custom_css')->nullable();
|
|
$table->text('pages_custom_js')->nullable();
|
|
$table->integer('pages_created_by')->unsigned()->nullable();
|
|
$table->integer('pages_updated_by')->unsigned()->nullable();
|
|
$table->timestamps();
|
|
$table->softDeletes();
|
|
});
|
|
}
|
|
}
|
|
|
|
public function down()
|
|
{
|
|
Capsule::schema()->dropIfExists('pages');
|
|
}
|
|
}
|