php-telegram-bot / laravel

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateInlineQueryTable extends Migration

{

    public function up()

    {

        Schema::create(config('phptelegrambot.database.prefix', '') . 'inline_query', static function (Blueprint $table) {

            $table->bigInteger('id')->unsigned()->primary()->comment('Unique identifier for this query');

            $table->bigInteger('user_id')->nullable()->index('user_id')->comment('Unique user identifier');

            $table->char('location')->nullable()->comment('Location of the user');

            $table->text('query', 65535)->comment('Text of the query');

            $table->char('offset')->nullable()->comment('Offset of the result');

            $table->dateTime('created_at')->nullable()->comment('Entry date creation');

        });

    }

    public function down()

    {

        Schema::dropIfExists(config('phptelegrambot.database.prefix', '') . 'inline_query');

    }

}

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateShippingQueryTable extends Migration

{

    public function up()

    {

        Schema::create(config('phptelegrambot.database.prefix', '') . 'shipping_query', static function (Blueprint $table) {

            $table->bigInteger('id')->primary()->unsigned()->comment('Unique query identifier');

            $table->bigInteger('user_id')->index('user_id')->nullable()->comment('User who sent the query');

            $table->char ('invoice_payload', 255)->default('')->comment ('Bot specified invoice payload');

            $table->char ('shipping_address', 255)->default('')->comment ('User specified shipping address');

            $table->timestamp('created_at')->nullable()->comment ('Entry date creation');

        });

    }

    public function down()

    {

        Schema::dropIfExists(config('phptelegrambot.database.prefix', '') . 'shipping_query');

    }

}