Migrate up

@return void
498246
public function up()
    {
        if ($this->hasTable('users_groups')) {
            return;
        }

        $table = $this->table('users_groups');
        $table->addColumn('user_id', 'integer', ['limit' => 11, 'signed' => false, 'null' => false])
            ->addColumn('group_id', 'integer', ['limit' => 11, 'signed' => false, 'null' => false]);
        $table->addIndex('user_id', ['name' => 'FK_USER_ID', 'unique' => false])
            ->addIndex('group_id', ['name' => 'FK_GROUP_ID', 'unique' => false]);
        $table->create();

        $this->unsignedIntId($table);
        $table->save();

        $UsersGroups = \Cake\ORM\TableRegistry::get('UsersGroups');
        $UsersGroups->save($UsersGroups->newEntity([
            'user_id' => 1,
            'group_id' => 1
        ]));
    }
51894
public function up()
    {
        Schema::create('laralum_files_settings', function (Blueprint $table) {
            $table->increments('id');
            $table->string('public_url');
            $table->boolean('public_routes');
            $table->timestamps();
        });

        Settings::create([
            'public_url'     => 'files',
            'public_routes'  => true,
        ]);
    }
444790
public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            if (Schema::hasColumn('users', 'deleted_at') == false) {
                $table->softDeletes();
            }
        });
    }
992379
public function up()
    {
        Schema::create('queues', function (Blueprint $table) {
            $table->increments('id');
            $table->string('queue', 255)->nullable()->default(null);
            $table->integer('status')->default(0);
            $table->integer('retries')->default(0);
            $table->timestamp('timestamp');
            $table->longText('payload')->nullable();
            $table->timestamps();
        });
    }
1200239
public function up()
    {
        if (! Schema::hasTable('promotions')) {
            Schema::create('promotions', function($table) {
                $table->increments('id');
                $table->string('name', 255);
                $table->string('short_description', 255);
                $table->text('long_description')->nullable();
                $table->date('start_date');
                $table->date('end_date');
                $table->boolean('active')->default(true);
                $table->text('options')->nullable();
                 // created_at | updated_at DATETIME
                $table->timestamps();
            });
        }
    }
315831
public function up()
    {

        Schema::create('userattitudes_counters', function (Blueprint $table) {
            $table->string('item_type', 32);
            $table->integer('item_id')->unsigned();
            $table->integer('count')->unsigned()->nullable()->default(null);
        });

    }
1238971
public function up()
    {

        Schema::create('character_standings', function (Blueprint $table) {

            $table->increments('id');

            $table->bigInteger('character_id');
            $table->integer('from_id');
            $table->enum('from_type', ['agent', 'npc_corp', 'faction']);
            $table->float('standing');

            $table->index('character_id');
            $table->index('from_id');

            $table->timestamps();
        });
    }
682410
public function up()
    {
        Schema::create('objects', function (Blueprint $table) {
            $table->engine = 'InnoDB';
            $table->increments('id');
            $table->integer('image_id')->unsigned()->nullable();
            $table->json('status');
            $table->json('title');
            $table->json('slug');
            $table->json('summary');
            $table->json('body');
            $table->timestamps();
        });
    }
780393
public function up()
    {
        Schema::create('lfm_categories', function (Blueprint $table) {
            $table->integer('id', true);
            $table->integer('user_id')->nullable()->unsigned()->default(0);
            $table->string('title')->nullable()->default(null);;
            $table->longText('title_disc')->nullable()->default(null);
            $table->text('description')->nullable()->default(null);
            $table->string('parent_category_id',255)->nullable()->default(null);
            $table->integer('created_by')->unsigned()->nullable()->default(null);
            $table->timestamps();
            $table->softDeletes();
        });

    }
1026976
public function up()
    {
        \Schema::table(Config::get('b3cod4x.usertable'), function (Blueprint $table){
            $table->string('guid')->unique()->nullable();
            $table->string('claimCode')->unique()->nullable();
        });

    }
368929
public function up()
	{
		Schema::create('user', function(Blueprint $table)
		{
			$table->increments('id_user');
			$table->string('name');
			$table->string('username')->unique();
			$table->string('password', 60);
			$table->rememberToken();
			$table->timestamps();
		});
		
		DB::table('user')->insert(
			['name' => 'Administrator', 'username' => 'admin', 'password' => bcrypt('admin'), 
				'created_at' => date('Y-m-d'), 'updated_at' => date('Y-m-d')]
		);
	}
824720
public function up()
    {
          Schema::create('user_activations', function (Blueprint $table) {
              $table->integer('user_id')->unsigned();
              $table->string('token')->index();
              $table->timestamps();
         });
        //add activation column check to users table
        Schema::table('users', function (Blueprint $table) {
            $table->boolean('activated')->default(false)->index();
        });
    }
52282
public function up()
    {
        Schema::table('users', function($table) {
            $table->boolean('active')->default(false);
            $table->string('avatar')->nullable();
        });
    }
673666
public function up(): void
    {
        Schema::create('hc_user', function (Blueprint $table) {
            $table->increments('count');
            $table->uuid('id')->unique();
            $table->datetime('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
            $table->datetime('updated_at')->default(DB::raw('CURRENT_TIMESTAMP'));
            $table->datetime('deleted_at')->nullable();

            $table->string('email', 100)->unique();
            $table->string('password', 60);
            $table->string('remember_token', 100)->nullable();
            $table->datetime('activated_at')->nullable();
            $table->datetime('last_login')->nullable();
            $table->datetime('last_activity')->nullable();

            $table->timestamp('email_verified_at')->nullable();
        });
    }
277444
public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->engine = 'InnoDB';

            $table->increments('id');
            $table->string('username');
            $table->string('password');
            $table->rememberToken();
            $table->string('email');
            $table->string('api_key');
            $table->boolean('active')->default(1);
            $table->tinyInteger('level')->default(2);
            $table->timestamps();

            $table->index('remember_token');
            $table->index('active');
            $table->unique('username');
            $table->unique('api_key');
            $table->unique('email');
        });
    }
1060081
public function up() {
		$db = Database::get();
		$result = $db->get_row('show table status where NAME="file"', []);

		if (isset($result['engine']) and $result['engine'] == 'InnoDB') {
			return;
		}
	
		if (isset($result['Engine']) and $result['Engine'] == 'InnoDB') {
            		return;
        	}

		$db->query("
			ALTER TABLE `file` ENGINE='InnoDB';
		", []);
	}
532683
public function migrateUp()
    {
        $this->builder->table(
            $this->table,
            function ($table) {
                $table->bigInteger('language_id')->unsigned()->nullable()->index();
            }
        );
    }