1: <?php
2:
3: use Illuminate\Database\Migrations\Migration;
4: use Illuminate\Database\Schema\Blueprint;
5: use Illuminate\Database\Capsule\Manager as Capsule;
6:
7: class CreateWebAuthnKeysTable extends Migration
8: {
9: /**
10: * Run the migrations.
11: *
12: * @return void
13: */
14: public function up()
15: {
16: Capsule::schema()->create('security_web_authn_keys', function (Blueprint $table) {
17: $table->id('Id');
18: $table->bigInteger('UserId')->default(0);
19: $table->string('Name')->default('');
20: $table->text('KeyData');
21: $table->integer('CreationDateTime')->default(0);
22: $table->integer('LastUsageDateTime')->default(0);
23: $table->timestamp(\Aurora\System\Classes\Model::CREATED_AT)->nullable();
24: $table->timestamp(\Aurora\System\Classes\Model::UPDATED_AT)->nullable();
25: });
26: }
27:
28: /**
29: * Reverse the migrations.
30: *
31: * @return void
32: */
33: public function down()
34: {
35: Capsule::schema()->dropIfExists('security_web_authn_keys');
36: }
37: }
38: