|
|
## Update a Customer password in database (identified by email)
|
|
|
```sql
|
|
|
UPDATE `customer_entity` SET `password_hash` = CONCAT(SHA2('xxxxxxxxPASSWORD', 256), ':xxxxxxxx:1') WHERE `email` = 'example@crefopay.de';
|
|
|
``` |
|
|
\ No newline at end of file |
|
|
```
|
|
|
|
|
|
## Update incrementID (sequential order number) to a new value`
|
|
|
```sql
|
|
|
ALTER TABLE `sequence_invoice_1` AUTO_INCREMENT={$newValue};
|
|
|
``` |