diff options
| author | Phil Burton <philip.burton@chiaro.co.uk> | 2019-11-01 22:56:27 +0000 | 
|---|---|---|
| committer | Phil Burton <philip.burton@chiaro.co.uk> | 2019-11-01 22:56:27 +0000 | 
| commit | fb0c574ed1725fe13c8ab073d2ead3fdc842c2ba (patch) | |
| tree | f863fd7cecad2c674cb071b3d7a44c2de6adb51d /database/migrations | |
Added laravel project
Diffstat (limited to 'database/migrations')
3 files changed, 103 insertions, 0 deletions
| diff --git a/database/migrations/2014_10_12_000000_create_users_table.php b/database/migrations/2014_10_12_000000_create_users_table.php new file mode 100644 index 0000000..a91e1d3 --- /dev/null +++ b/database/migrations/2014_10_12_000000_create_users_table.php @@ -0,0 +1,36 @@ +<?php + +use Illuminate\Database\Migrations\Migration; +use Illuminate\Database\Schema\Blueprint; +use Illuminate\Support\Facades\Schema; + +class CreateUsersTable extends Migration +{ +    /** +     * Run the migrations. +     * +     * @return void +     */ +    public function up() +    { +        Schema::create('users', function (Blueprint $table) { +            $table->bigIncrements('id'); +            $table->string('name'); +            $table->string('email')->unique(); +            $table->timestamp('email_verified_at')->nullable(); +            $table->string('password'); +            $table->rememberToken(); +            $table->timestamps(); +        }); +    } + +    /** +     * Reverse the migrations. +     * +     * @return void +     */ +    public function down() +    { +        Schema::dropIfExists('users'); +    } +} diff --git a/database/migrations/2014_10_12_100000_create_password_resets_table.php b/database/migrations/2014_10_12_100000_create_password_resets_table.php new file mode 100644 index 0000000..0ee0a36 --- /dev/null +++ b/database/migrations/2014_10_12_100000_create_password_resets_table.php @@ -0,0 +1,32 @@ +<?php + +use Illuminate\Database\Migrations\Migration; +use Illuminate\Database\Schema\Blueprint; +use Illuminate\Support\Facades\Schema; + +class CreatePasswordResetsTable extends Migration +{ +    /** +     * Run the migrations. +     * +     * @return void +     */ +    public function up() +    { +        Schema::create('password_resets', function (Blueprint $table) { +            $table->string('email')->index(); +            $table->string('token'); +            $table->timestamp('created_at')->nullable(); +        }); +    } + +    /** +     * Reverse the migrations. +     * +     * @return void +     */ +    public function down() +    { +        Schema::dropIfExists('password_resets'); +    } +} diff --git a/database/migrations/2019_08_19_000000_create_failed_jobs_table.php b/database/migrations/2019_08_19_000000_create_failed_jobs_table.php new file mode 100644 index 0000000..389bdf7 --- /dev/null +++ b/database/migrations/2019_08_19_000000_create_failed_jobs_table.php @@ -0,0 +1,35 @@ +<?php + +use Illuminate\Database\Migrations\Migration; +use Illuminate\Database\Schema\Blueprint; +use Illuminate\Support\Facades\Schema; + +class CreateFailedJobsTable extends Migration +{ +    /** +     * Run the migrations. +     * +     * @return void +     */ +    public function up() +    { +        Schema::create('failed_jobs', function (Blueprint $table) { +            $table->bigIncrements('id'); +            $table->text('connection'); +            $table->text('queue'); +            $table->longText('payload'); +            $table->longText('exception'); +            $table->timestamp('failed_at')->useCurrent(); +        }); +    } + +    /** +     * Reverse the migrations. +     * +     * @return void +     */ +    public function down() +    { +        Schema::dropIfExists('failed_jobs'); +    } +} | 
