If you does't know what is this you probably in wrong project

```sql
--- for all ip
CREATE USER 'kaunteruser'@'%' IDENTIFIED BY 'your_password';

--- for specific ip
CREATE USER 'kaunteruser'@'localhost' IDENTIFIED BY 'your_password';

GRANT ALL PRIVILEGES ON kaunter_erahn.* TO 'kaunteruser'@'%';
FLUSH PRIVILEGES;
``` 

# ADDITIONAL NOTE

## customers/v2/index.blade.php is modal to register customer 

## Min Komoditi = RM5000

# System Flowchart

## Proses Gadaian
1) Pelanggan datang bawa marhun
2) Teller daftar maklumat pelanggan jika pelanggan baharu
3) Serah marhun ke penilai untuk timbang
4) Teller daftar marhun di sistem berdasarkan maklumat dari penilai
5) Penilai print SAG dan serah marhun ke Khazanah (PC/PPC) - __khazanah can still scan still scan though__
6) Khazanah scan barcode dekat SAG untuk masuk ke dalam peti besi
* table involved - gadai.semakbarcode (default is blank, after is Lulus)
7) DONE

## Setup new branch command:
1. Duplicate previous branch table - use erahn_{{name}}
```sql
SET FOREIGN_KEY_CHECKS = 0;

SET SESSION group_concat_max_len = 1000000;

SELECT GROUP_CONCAT(
    CONCAT('TRUNCATE TABLE `', table_name, '`')
    SEPARATOR '; '
) INTO @sql
FROM information_schema.tables
WHERE table_schema = DATABASE();

SELECT @sql; --- copy the output and paste it

SET FOREIGN_KEY_CHECKS = 1;
```
2. Add new cawangan kod on master_erahn.arrahn_master_db and and kaunter_erahn.cawangan
3. Register new cawangan detail in erahn_{{name}}.cawangan