/home/mip/mip/database/migrations/likod/2016_05_17_061117_create_clients_table.php
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateClientsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('clients', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('client_name');
$table->string('client_address');
$table->string('telephone_no', 150);
$table->string('email', 150);
$table->string('database_name')->index();
$table->string('database_host')->index();
$table->string('database_username')->index();
$table->string('database_password')->index();
$table->string('api_key')->index();
$table->string('api_secret')->index();
$table->integer('status')->unsigned()->index();
$table->integer('number_of_users')->unsigned()->index();
$table->integer('disk_size')->unsigned()->index();
$table->integer('date_picker_format')->unsigned()->index();
$table->integer('display_date_format')->unsigned()->index();
$table->integer('name_format')->unsigned()->index();
$table->integer('monthly_mail_quota')->unsigned()->index();
$table->string('root_dir')->index();
$table->string('mail_driver', 30)->index();
$table->string('mail_sender_address')->index();
$table->string('mail_sender_name')->index();
$table->string('mail_host')->index();
$table->string('mail_username')->index();
$table->string('mail_password')->index();
$table->integer('mail_port')->unsigned()->index();
$table->string('storage_type')->index();
$table->string('s3_key')->index();
$table->string('s3_secret')->index();
$table->string('s3_region')->index();
$table->string('s3_bucket_name')->index();
$table->string('cpanel_email')->index();
$table->string('cpanel_host')->index();
$table->string('cpanel_ip')->index();
$table->string('cpanel_port')->index();
$table->string('cpanel_account')->index();
$table->string('cpanel_password')->index();
$table->string('cpanel_domain')->index();
$table->string('cpanel_user_default_password')->index();
$table->string('cpanel_qouta')->index();
$table->string('cpanel_forwarder')->index();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('clients');
}
}