ProxyPanel/database/migrations/2020_08_21_145711_create_ss_node_table.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateSsNodeTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('ss_node', function (Blueprint $table) {
            $table->increments('id');
            $table->boolean('type')->default(1)->comment('服务类型：1-Shadowsocks(R)、2-V2ray、3-Trojan、4-VNet');
            $table->string('name', 128)->comment('名称');
            $table->char('country_code', 5)->default('un')->comment('国家代码');
            $table->string('server')->nullable()->comment('服务器域名地址');
            $table->ipAddress('ip')->nullable()->comment('服务器IPV4地址');
            $table->ipAddress('ipv6')->nullable()->comment('服务器IPV6地址');
            $table->unsignedTinyInteger('level')->default(0)->comment('等级：0-无等级，全部可见');
            $table->unsignedBigInteger('speed_limit')->default(0)->comment('节点限速，为0表示不限速，单位Byte');
            $table->unsignedSmallInteger('client_limit')->default(0)->comment('设备数限制');
            $table->string('relay_server')->nullable()->comment('中转地址');
            $table->unsignedSmallInteger('relay_port')->nullable()->comment('中转端口');
            $table->string('description')->nullable()->comment('节点简单描述');
            $table->string('geo')->nullable()->comment('节点地理位置');
            $table->string('method', 32)->default('aes-256-cfb')->comment('加密方式');
            $table->string('protocol', 64)->default('origin')->comment('协议');
            $table->string('protocol_param', 128)->nullable()->comment('协议参数');
            $table->string('obfs', 64)->default('plain')->comment('混淆');
            $table->string('obfs_param')->nullable()->comment('混淆参数');
            $table->float('traffic_rate', 6)->unsigned()->default(1.00)->comment('流量比率');
            $table->boolean('is_subscribe')->default(1)->index()->comment('是否允许用户订阅该节点：0-否、1-是');
            $table->boolean('is_ddns')->default(0)->comment('是否使用DDNS：0-否、1-是');
            $table->boolean('is_relay')->default(0)->comment('是否中转节点：0-否、1-是');
            $table->boolean('is_udp')->default(1)->comment('是否启用UDP：0-不启用、1-启用');
            $table->unsignedSmallInteger('push_port')->default(1000)->comment('消息推送端口');
            $table->boolean('detection_type')->default(1)->comment('节点检测: 0-关闭、1-只检测TCP、2-只检测ICMP、3-检测全部');
            $table->boolean('compatible')->default(0)->comment('兼容SS');
            $table->boolean('single')->default(0)->comment('启用单端口功能：0-否、1-是');
            $table->unsignedSmallInteger('port')->nullable()->comment('单端口的端口号或连接端口号');
            $table->string('passwd')->nullable()->comment('单端口的连接密码');
            $table->unsignedTinyInteger('sort')->default(0)->comment('排序值，值越大越靠前显示');
            $table->boolean('status')->default(1)->comment('状态：0-维护、1-正常');
            $table->unsignedSmallInteger('v2_alter_id')->default(16)->comment('V2Ray额外ID');
            $table->unsignedSmallInteger('v2_port')->default(0)->comment('V2Ray服务端口');
            $table->string('v2_method', 32)->default('aes-128-gcm')->comment('V2Ray加密方式');
            $table->string('v2_net', 16)->default('tcp')->comment('V2Ray传输协议');
            $table->string('v2_type', 32)->default('none')->comment('V2Ray伪装类型');
            $table->string('v2_host')->nullable()->comment('V2Ray伪装的域名');
            $table->string('v2_path')->nullable()->comment('V2Ray的WS/H2路径');
            $table->boolean('v2_tls')->default(0)->comment('V2Ray连接TLS：0-未开启、1-开启');
            $table->text('tls_provider')->nullable()->comment('V2Ray节点的TLS提供商授权信息');
            $table->dateTime('created_at')->comment('创建时间');
            $table->dateTime('updated_at')->comment('最后更新时间');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('ss_node');
    }
}