diff --git a/src/database/migrations/2014_10_12_000000_create_users_table.php b/src/database/migrations/2014_10_12_000000_create_users_table.php --- a/src/database/migrations/2014_10_12_000000_create_users_table.php +++ b/src/database/migrations/2014_10_12_000000_create_users_table.php @@ -22,7 +22,8 @@ $table->string('password')->nullable(); $table->string('password_ldap')->nullable(); $table->smallinteger('status'); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->primary('id'); } diff --git a/src/database/migrations/2014_10_12_100000_create_password_resets_table.php b/src/database/migrations/2014_10_12_100000_create_password_resets_table.php deleted file mode 100644 --- a/src/database/migrations/2014_10_12_100000_create_password_resets_table.php +++ /dev/null @@ -1,33 +0,0 @@ -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/src/database/migrations/2019_09_17_102627_wallet_controllers.php b/src/database/migrations/2019_09_17_102627_wallet_controllers.php --- a/src/database/migrations/2019_09_17_102627_wallet_controllers.php +++ b/src/database/migrations/2019_09_17_102627_wallet_controllers.php @@ -20,7 +20,8 @@ $table->bigIncrements('id'); $table->bigInteger('user_id'); $table->string('wallet_id', 36); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->unique(['user_id', 'wallet_id']); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); diff --git a/src/database/migrations/2019_09_17_102628_create_sku_entitlements.php b/src/database/migrations/2019_09_17_102628_create_sku_entitlements.php --- a/src/database/migrations/2019_09_17_102628_create_sku_entitlements.php +++ b/src/database/migrations/2019_09_17_102628_create_sku_entitlements.php @@ -26,7 +26,8 @@ $table->string('period', strlen('monthly'))->default('monthly'); $table->string('handler_class')->nullable(); $table->boolean('active')->default(false); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); } ); diff --git a/src/database/migrations/2019_09_17_132012_create_user_settings_table.php b/src/database/migrations/2019_09_17_132012_create_user_settings_table.php --- a/src/database/migrations/2019_09_17_132012_create_user_settings_table.php +++ b/src/database/migrations/2019_09_17_132012_create_user_settings_table.php @@ -21,7 +21,8 @@ $table->bigInteger('user_id'); $table->string('key'); $table->string('value'); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->foreign('user_id')->references('id')->on('users') ->onDelete('cascade')->onUpdate('cascade'); diff --git a/src/database/migrations/2019_09_23_071701_create_domains_table.php b/src/database/migrations/2019_09_23_071701_create_domains_table.php --- a/src/database/migrations/2019_09_23_071701_create_domains_table.php +++ b/src/database/migrations/2019_09_23_071701_create_domains_table.php @@ -19,7 +19,8 @@ $table->string('namespace')->unique(); $table->smallinteger('status'); $table->tinyinteger('type'); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); }); } diff --git a/src/database/migrations/2019_10_10_095050_create_quota_table.php b/src/database/migrations/2019_10_10_095050_create_quota_table.php deleted file mode 100644 --- a/src/database/migrations/2019_10_10_095050_create_quota_table.php +++ /dev/null @@ -1,38 +0,0 @@ -bigIncrements('id'); - $table->bigInteger('user_id'); - $table->unsignedInteger('value')->default(2147483648); - $table->timestamps(); - - $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); - }); - */ - } - - /** - * Reverse the migrations. - * - * @return void - */ - public function down() - { - Schema::dropIfExists('quotas'); - } -} diff --git a/src/database/migrations/2020_02_26_000000_create_user_aliases_table.php b/src/database/migrations/2020_02_26_000000_create_user_aliases_table.php --- a/src/database/migrations/2020_02_26_000000_create_user_aliases_table.php +++ b/src/database/migrations/2020_02_26_000000_create_user_aliases_table.php @@ -20,7 +20,8 @@ $table->bigIncrements('id'); $table->bigInteger('user_id'); $table->string('alias')->unique(); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->foreign('user_id')->references('id')->on('users') ->onDelete('cascade')->onUpdate('cascade'); diff --git a/src/database/migrations/2020_03_16_100000_create_payments.php b/src/database/migrations/2020_03_16_100000_create_payments.php --- a/src/database/migrations/2020_03_16_100000_create_payments.php +++ b/src/database/migrations/2020_03_16_100000_create_payments.php @@ -24,7 +24,8 @@ $table->text('description'); $table->string('provider', 16); $table->string('type', 16); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->foreign('wallet_id')->references('id')->on('wallets')->onDelete('cascade'); } diff --git a/src/database/migrations/2020_03_30_100000_create_discounts.php b/src/database/migrations/2020_03_30_100000_create_discounts.php --- a/src/database/migrations/2020_03_30_100000_create_discounts.php +++ b/src/database/migrations/2020_03_30_100000_create_discounts.php @@ -22,7 +22,8 @@ $table->json('description'); $table->string('code', 32)->nullable(); $table->boolean('active')->default(false); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->primary('id'); } diff --git a/src/database/migrations/2020_04_21_100000_create_wallet_settings.php b/src/database/migrations/2020_04_21_100000_create_wallet_settings.php --- a/src/database/migrations/2020_04_21_100000_create_wallet_settings.php +++ b/src/database/migrations/2020_04_21_100000_create_wallet_settings.php @@ -21,7 +21,8 @@ $table->string('wallet_id'); $table->string('key'); $table->string('value'); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->foreign('wallet_id')->references('id')->on('wallets')->onDelete('cascade'); $table->unique(['wallet_id', 'key']); diff --git a/src/database/migrations/2020_05_21_080131_create_transactions_table.php b/src/database/migrations/2020_05_21_080131_create_transactions_table.php --- a/src/database/migrations/2020_05_21_080131_create_transactions_table.php +++ b/src/database/migrations/2020_05_21_080131_create_transactions_table.php @@ -25,7 +25,8 @@ $table->integer('amount')->nullable(); $table->string('description')->nullable(); $table->string('transaction_id', 36)->nullable()->index(); - $table->timestamps(); + $table->timestamp('created_at')->useCurrent(); + $table->timestamp('updated_at')->useCurrent(); $table->index(['object_id', 'object_type']); } diff --git a/src/database/migrations/2020_06_18_150000_update_user_aliases_unique_key.php b/src/database/migrations/2020_06_18_150000_update_user_aliases_unique_key.php --- a/src/database/migrations/2020_06_18_150000_update_user_aliases_unique_key.php +++ b/src/database/migrations/2020_06_18_150000_update_user_aliases_unique_key.php @@ -4,6 +4,7 @@ use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; +// phpcs:ignore class UpdateUserAliasesUniqueKey extends Migration { /**