public function up()
{
Schema::create('security_codes', function ($table) {
$table->increments('id');
$table->unsignedInteger('account_id')->index();
$table->unsignedInteger('user_id')->nullable();
$table->unsignedInteger('contact_id')->nullable();
$table->smallInteger('attempts');
$table->string('code')->nullable();
$table->string('bot_user_id')->unique();
$table->timestamp('created_at')->useCurrent();
});
Schema::table('security_codes', function ($table) {
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->foreign('contact_id')->references('id')->on('contacts')->onDelete('cascade');
$table->foreign('account_id')->references('id')->on('accounts')->onDelete('cascade');
});
Schema::table('users', function ($table) {
$table->string('bot_user_id')->nullable();
});
Schema::table('contacts', function ($table) {
$table->string('bot_user_id')->nullable();
});
Schema::table('accounts', function ($table) {
$table->boolean('include_item_taxes_inline')->default(false);
});
}