71 lines
2.5 KiB
PHP
71 lines
2.5 KiB
PHP
<?php
|
|
|
|
use Illuminate\Database\Migrations\Migration;
|
|
use Illuminate\Database\Schema\Blueprint;
|
|
|
|
class CreateSettingsTable extends Migration
|
|
{
|
|
/**
|
|
* Run the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function up()
|
|
{
|
|
Schema::create('settings', function (Blueprint $table) {
|
|
$table->integer('id', true);
|
|
$table->text('login_banner', 65535)->nullable();
|
|
$table->string('timezone')->nullable();
|
|
$table->string('mail_host')->nullable();
|
|
$table->integer('mail_port')->nullable();
|
|
$table->string('mail_from_email')->nullable();
|
|
$table->text('mail_to_email', 65535)->nullable();
|
|
$table->integer('mail_authcheck')->nullable();
|
|
$table->string('mail_username')->nullable();
|
|
$table->string('mail_password', 512)->nullable();
|
|
$table->string('mail_driver')->nullable();
|
|
$table->string('mail_encryption')->nullable();
|
|
$table->string('defaultDeviceUsername')->nullable();
|
|
$table->string('defaultDevicePassword')->nullable();
|
|
$table->string('defaultEnablePassword', 512)->nullable();
|
|
$table->integer('passwordEncryption')->nullable()->default(0)->comment('0 - no encryption, 1 = encryption');
|
|
$table->integer('deviceDebugging')->nullable();
|
|
$table->integer('phpDebugging')->nullable();
|
|
$table->timestamps();
|
|
});
|
|
|
|
DB::table('settings')->insert([
|
|
'id' => '1',
|
|
'login_banner' => 'Authorization message - You must be an authorized user to login and use this system.',
|
|
'timezone' => 'Europe/Dublin',
|
|
'mail_host' => 'devmailer.rconfig.com',
|
|
'mail_port' => 1025,
|
|
'mail_from_email' => 'admin@domain.com',
|
|
'mail_to_email' => 'user@domain.com',
|
|
'mail_authcheck' => '0',
|
|
'mail_username' => null,
|
|
'mail_password' => null,
|
|
'mail_driver' => 'smtp',
|
|
'mail_encryption' => null,
|
|
'defaultDeviceUsername' => null,
|
|
'defaultDevicePassword' => null,
|
|
'defaultEnablePassword' => null,
|
|
'passwordEncryption' => '1',
|
|
'deviceDebugging' => '0',
|
|
'phpDebugging' => '1',
|
|
'created_at' => '2019-07-15 18:38:03',
|
|
'updated_at' => '2019-07-15 18:38:23',
|
|
]);
|
|
}
|
|
|
|
/**
|
|
* Reverse the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function down()
|
|
{
|
|
Schema::drop('settings');
|
|
}
|
|
}
|