mirror of
https://github.com/invoiceninja/invoiceninja.git
synced 2025-07-31 15:42:03 -04:00
101 lines
4.1 KiB
PHP
101 lines
4.1 KiB
PHP
<?php
|
|
|
|
use Illuminate\Support\Facades\Schema;
|
|
use Illuminate\Database\Schema\Blueprint;
|
|
use Illuminate\Database\Migrations\Migration;
|
|
|
|
class AddQuoteReminders extends Migration
|
|
{
|
|
/**
|
|
* Run the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function up()
|
|
{
|
|
Schema::table('account_email_settings', function ($table) {
|
|
$table->string('email_subject_quote_reminder1');
|
|
$table->string('email_subject_quote_reminder2');
|
|
$table->string('email_subject_quote_reminder3');
|
|
$table->string('email_subject_quote_reminder4');
|
|
|
|
$table->text('email_template_quote_reminder1');
|
|
$table->text('email_template_quote_reminder2');
|
|
$table->text('email_template_quote_reminder3');
|
|
$table->text('email_template_quote_reminder4');
|
|
|
|
$table->boolean('enable_quote_reminder1')->default(false);
|
|
$table->boolean('enable_quote_reminder2')->default(false);
|
|
$table->boolean('enable_quote_reminder3')->default(false);
|
|
$table->boolean('enable_quote_reminder4')->default(false);
|
|
|
|
$table->smallInteger('num_days_quote_reminder1')->default(7);
|
|
$table->smallInteger('num_days_quote_reminder2')->default(14);
|
|
$table->smallInteger('num_days_quote_reminder3')->default(30);
|
|
|
|
$table->smallInteger('direction_quote_reminder1')->default(1);
|
|
$table->smallInteger('direction_quote_reminder2')->default(1);
|
|
$table->smallInteger('direction_quote_reminder3')->default(1);
|
|
|
|
$table->smallInteger('field_quote_reminder1')->default(1);
|
|
$table->smallInteger('field_quote_reminder2')->default(1);
|
|
$table->smallInteger('field_quote_reminder3')->default(1);
|
|
|
|
$table->unsignedInteger('frequency_id_quote_reminder4')->nullable();
|
|
|
|
$table->decimal('late_fee_quote1_amount', 13, 2)->nullable();
|
|
$table->decimal('late_fee_quote1_percent', 13, 3)->nullable();
|
|
$table->decimal('late_fee_quote2_amount', 13, 2)->nullable();
|
|
$table->decimal('late_fee_quote2_percent', 13, 3)->nullable();
|
|
$table->decimal('late_fee_quote3_amount', 13, 2)->nullable();
|
|
$table->decimal('late_fee_quote3_percent', 13, 3)->nullable();
|
|
});
|
|
}
|
|
|
|
/**
|
|
* Reverse the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function down()
|
|
{
|
|
Schema::table('account_email_settings', function ($table) {
|
|
$table->dropColumn('email_subject_quote_reminder1');
|
|
$table->dropColumn('email_subject_quote_reminder2');
|
|
$table->dropColumn('email_subject_quote_reminder3');
|
|
$table->dropColumn('email_subject_quote_reminder4');
|
|
|
|
$table->dropColumn('email_template_quote_reminder1');
|
|
$table->dropColumn('email_template_quote_reminder2');
|
|
$table->dropColumn('email_template_quote_reminder3');
|
|
$table->dropColumn('email_template_quote_reminder4');
|
|
|
|
$table->dropColumn('enable_quote_reminder1');
|
|
$table->dropColumn('enable_quote_reminder2');
|
|
$table->dropColumn('enable_quote_reminder3');
|
|
$table->dropColumn('enable_quote_reminder4');
|
|
|
|
$table->dropColumn('num_days_quote_reminder1');
|
|
$table->dropColumn('num_days_quote_reminder2');
|
|
$table->dropColumn('num_days_quote_reminder3');
|
|
|
|
$table->dropColumn('direction_quote_reminder1');
|
|
$table->dropColumn('direction_quote_reminder2');
|
|
$table->dropColumn('direction_quote_reminder3');
|
|
|
|
$table->dropColumn('field_quote_reminder1');
|
|
$table->dropColumn('field_quote_reminder2');
|
|
$table->dropColumn('field_quote_reminder3');
|
|
|
|
$table->dropColumn('frequency_id_quote_reminder4');
|
|
|
|
$table->dropColumn('late_fee_quote1_amount');
|
|
$table->dropColumn('late_fee_quote1_percent');
|
|
$table->dropColumn('late_fee_quote2_amount');
|
|
$table->dropColumn('late_fee_quote2_percent');
|
|
$table->dropColumn('late_fee_quote3_amount');
|
|
$table->dropColumn('late_fee_quote3_percent');
|
|
});
|
|
}
|
|
}
|