61 lines
1.7 KiB
PHP
61 lines
1.7 KiB
PHP
<?php
|
|
|
|
use Illuminate\Database\Migrations\Migration;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
return new class extends Migration
|
|
{
|
|
/**
|
|
* Mapping of old polymorphic types to new simpler values.
|
|
*/
|
|
protected $changeMap = [
|
|
'BookStack\\Bookshelf' => 'bookshelf',
|
|
'BookStack\\Book' => 'book',
|
|
'BookStack\\Chapter' => 'chapter',
|
|
'BookStack\\Page' => 'page',
|
|
];
|
|
|
|
/**
|
|
* Mapping of tables and columns that contain polymorphic types.
|
|
*/
|
|
protected $columnsByTable = [
|
|
'activities' => 'entity_type',
|
|
'comments' => 'entity_type',
|
|
'deletions' => 'deletable_type',
|
|
'entity_permissions' => 'restrictable_type',
|
|
'favourites' => 'favouritable_type',
|
|
'joint_permissions' => 'entity_type',
|
|
'search_terms' => 'entity_type',
|
|
'tags' => 'entity_type',
|
|
'views' => 'viewable_type',
|
|
];
|
|
|
|
/**
|
|
* Run the migrations.
|
|
*/
|
|
public function up(): void
|
|
{
|
|
foreach ($this->columnsByTable as $table => $column) {
|
|
foreach ($this->changeMap as $oldVal => $newVal) {
|
|
DB::table($table)
|
|
->where([$column => $oldVal])
|
|
->update([$column => $newVal]);
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Reverse the migrations.
|
|
*/
|
|
public function down(): void
|
|
{
|
|
foreach ($this->columnsByTable as $table => $column) {
|
|
foreach ($this->changeMap as $oldVal => $newVal) {
|
|
DB::table($table)
|
|
->where([$column => $newVal])
|
|
->update([$column => $oldVal]);
|
|
}
|
|
}
|
|
}
|
|
};
|