telephone field unique

[VirtualSpy]

laravel version 9.36.4 , Aimeos version 2022.10.3 and PHP version 8.1.3 (Win)

I have made mandatory to telephone in billing & delivery address so, i want to know how to make telephone field unique like email from address form , means i want every user have diifferent telephone for order booking

[aimeos]

You can make the telephone field in the users table unique when a new user account is created in the ./setup/default/schema/customer.php of your own Aimeos extension:

Code: Select all

return [
  'table' => [
    'users' => function ( \Aimeos\Upscheme\Schema\Table $table ) {
        $table->unique( ['telephone'], 'unq_usr_telephone' );
    },
  ],
];

During checkout, the customer needs to be logged in to be able to check that. Then, it's done by the database when the customer record is updated after the address step.