SherifElfadaly / Laravel-Api-Skeleton

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateOauthClientsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            increments('id');

            $table->unsignedInteger('user_id')->nullable();

            $table->string('name');

            $table->string('secret', 100);

            $table->text('redirect');

            $table->boolean('personal_access_client')->default(0);

            $table->boolean('password_client')->default(0);

            $table->boolean('revoked')->default(0);

            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('oauth_clients');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateOauthAuthCodesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->string('id', 100)->primary();

            $table->unsignedInteger('user_id');

            $table->unsignedInteger('client_id');

            $table->text('scopes')->nullable();

            $table->boolean('revoked');

            $table->dateTime('expires_at')->nullable();

            $table->foreign('user_id')->references('id')->on('users');

            $table->foreign('client_id')->references('id')->on('oauth_clients');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('oauth_auth_codes');

    }

}