Fix database structure definition, primary keys must be marked as this
authorMichael <heluecht@pirati.ca>
Thu, 16 May 2019 19:53:07 +0000 (19:53 +0000)
committerMichael <heluecht@pirati.ca>
Thu, 16 May 2019 19:53:07 +0000 (19:53 +0000)
config/dbstructure.config.php

index baca2be..57e4378 100755 (executable)
@@ -41,8 +41,8 @@ return [
        "2fa_recovery_codes" => [
                "comment" => "Two-factor authentication recovery codes",
                "fields" => [
-                       "uid" => ["type" => "int unsigned", "not null" => "1", "comment" => "User ID"],
-                       "code" => ["type" => "varchar(50)", "not null" => "1", "comment" => "Recovery code string"],
+                       "uid" => ["type" => "mediumint unsigned", "not null" => "1", "primary" => "1", "relation" => ["user" => "uid"], "comment" => "User ID"],
+                       "code" => ["type" => "varchar(50)", "not null" => "1", "primary" => "1", "comment" => "Recovery code string"],
                        "generated" => ["type" => "datetime", "not null" => "1", "comment" => "Datetime the code was generated"],
                        "used" => ["type" => "datetime", "comment" => "Datetime the code was used"],
                ],