Page MenuHomePhorge
Files F2270320

2021_11_25_100000_create_shared_folders_table.php
No OneTemporary
Actions

2021_11_25_100000_create_shared_folders_table.php
View Options

<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
// phpcs:ignore
class CreateSharedFoldersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(
'shared_folders',
function (Blueprint $table) {
$table->unsignedBigInteger('id');
$table->string('email')->unique();
$table->string('name');
$table->string('type', 8);
$table->smallInteger('status');
$table->unsignedBigInteger('tenant_id')->nullable();
$table->timestamps();
$table->softDeletes();
$table->primary('id');
$table->foreign('tenant_id')->references('id')->on('tenants')->onDelete('set null');
}
);
Schema::create(
'shared_folder_settings',
function (Blueprint $table) {
$table->bigIncrements('id');
$table->unsignedBigInteger('shared_folder_id');
$table->string('key');
$table->text('value');
$table->timestamps();
$table->foreign('shared_folder_id')->references('id')->on('shared_folders')
->onDelete('cascade')->onUpdate('cascade');
$table->unique(['shared_folder_id', 'key']);
}
);
\App\Sku::where('title', 'shared_folder')->update([
'active' => true,
'cost' => 0,
'title' => 'shared-folder',
]);
if (!\App\Sku::where('title', 'beta-shared-folders')->first()) {
\App\Sku::create([
'title' => 'beta-shared-folders',
'name' => 'Shared folders',
'description' => 'Access to shared folders',
'cost' => 0,
'units_free' => 0,
'period' => 'monthly',
'handler_class' => 'App\Handlers\Beta\SharedFolders',
'active' => true,
]);
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('shared_folder_settings');
Schema::dropIfExists('shared_folders');
// there's no need to remove the SKU
}
}

File Metadata

Mime Type
text/x-php
Expires
Sat, Oct 11, 10:33 AM (1 d, 19 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
320706
Default Alt Text
2021_11_25_100000_create_shared_folders_table.php (2 KB)

Event Timeline