55 lines
2.4 KiB
PHP
55 lines
2.4 KiB
PHP
<?php namespace SureSoftware\PowerSEO\Updates;
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
use Schema;
|
|
use October\Rain\Database\Updates\Migration;
|
|
use System\Classes\PluginManager;
|
|
|
|
class MigrateBlogpostSeo extends Migration
|
|
{
|
|
|
|
public function up()
|
|
{
|
|
if (PluginManager::instance()->hasPlugin('RainLab.Blog') &&
|
|
PluginManager::instance()->hasPlugin('AnandPatel.SeoExtension')) {
|
|
Schema::table('rainlab_blog_posts', function ($table) {
|
|
$table->renameColumn('seo_title', 'powerseo_title');
|
|
$table->renameColumn('seo_description', 'powerseo_description');
|
|
$table->renameColumn('seo_keywords', 'powerseo_keywords');
|
|
$table->renameColumn('canonical_url', 'powerseo_canonical_url');
|
|
$table->renameColumn('redirect_url', 'powerseo_redirect_url');
|
|
$table->renameColumn('robot_index', 'powerseo_robot_index');
|
|
$table->renameColumn('robot_follow', 'powerseo_robot_follow');
|
|
});
|
|
|
|
//add in old columns to prevent anandpatel.seoextension having a seizure on uninstall
|
|
Schema::table('rainlab_blog_posts', function ($table) {
|
|
$table->string('seo_title')->nullable();
|
|
$table->string('seo_description')->nullable();
|
|
$table->string('seo_keywords')->nullable();
|
|
$table->string('canonical_url')->nullable();
|
|
$table->string('redirect_url')->nullable();
|
|
$table->string('robot_index')->nullable();
|
|
$table->string('robot_follow')->nullable();
|
|
});
|
|
}
|
|
}
|
|
|
|
public function down()
|
|
{
|
|
if (PluginManager::instance()->hasPlugin('RainLab.Blog') &&
|
|
PluginManager::instance()->hasPlugin('AnandPatel.SeoExtension')) {
|
|
|
|
Schema::table('rainlab_blog_posts', function ($table) {
|
|
$table->renameColumn('powerseo_seo_title', 'seo_title');
|
|
$table->renameColumn('powerseo_seo_description', 'seo_description');
|
|
$table->renameColumn('powerseo_seo_keywords', 'seo_keywords');
|
|
$table->renameColumn('powerseo_canonical_url', 'canonical_url');
|
|
$table->renameColumn('powerseo_redirect_url', 'redirect_url');
|
|
$table->renameColumn('powerseo_robot_index', 'robot_index');
|
|
$table->renameColumn('powerseo_robot_follow', 'robot_follow');
|
|
});
|
|
}
|
|
}
|
|
}
|