my-idlers/database/migrations/2022_02_03_040152_create_resellers_table.php

49 lines
1.6 KiB
PHP
Raw Permalink Normal View History

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateResellersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('reseller_hosting', function (Blueprint $table) {
2022-03-05 16:58:25 +01:00
$table->char('id', 8)->primary();
$table->tinyInteger('active')->default(1);
$table->string('main_domain');
$table->integer('accounts')->default(1);
$table->string('reseller_type')->nullable();
$table->unsignedBigInteger('provider_id')->default(9999);
$table->unsignedBigInteger('location_id')->default(9999);
$table->integer('bandwidth')->nullable();
$table->integer('disk')->default(10);
$table->char('disk_type', 2)->default('GB');
$table->integer('disk_as_gb')->nullable()->default(0);
$table->integer('domains_limit')->nullable()->default(1);
$table->integer('subdomains_limit')->nullable()->default(1);
$table->integer('ftp_limit')->nullable()->default(1);
$table->integer('email_limit')->nullable()->default(1);
$table->integer('db_limit')->nullable()->default(1);
$table->tinyInteger('was_promo')->default(0);
$table->date('owned_since')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('reseller_hosting');
}
}