# GCP Bucket cfu-main-db-archives — SQL Dumps Analysis
# Date: 2026-09-22

## Source: cfu-main-db-archives bucket (3 files, 357 MB)

## 1. MasterSupplierTFO.sql — 🔴 FINANCE APP WITH CREDENTIALS

### jwt_secret table (schema — data empty)
```sql
CREATE TABLE jwt_secret (secret_key, expires_at, active_status, last_update)
```

### m_user table — 12 users with argon2 passwords

| Username | Password (argon2) | Last Login Host | Active | Updated By |
|----------|-------------------|-----------------|--------|------------|
| sa | argon2$4$32768$4$32$2rDx5... | 10.36.1.15:34148 | Y | Admin |
| anastasia1 | argon2$4$32768$4$32$264v... | 10.36.3.181:52042 | Y | admin |
| anastasia2 | argon2$4$32768$4$32$d8sJ... | 10.36.3.181:37412 | Y | admin |
| deborani1 | argon2$4$32768$4$32$OYAx... | 10.36.1.37:49286 | Y | admin |
| deborani2 | argon2$4$32768$4$32$YAyw... | 10.36.1.37:59302 | Y | admin |
| delian1 | argon2$4$32768$4$32$v/Kl... | 10.36.1.37:56474 | Y | admin |
| delian2 | argon2$4$32768$4$32$skkz... | 10.36.5.15:39828 | Y | admin |
| deview1 | argon2$4$32768$4$32$D6/x... | 10.36.1.37:33756 | Y | prod |
| deview2 | argon2$4$32768$4$32$pDGW... | 10.36.1.37:53620 | Y | prod |
| srineng1 | argon2$4$32768$4$32$+wSP... | 10.36.1.37:49286 | Y | admin |
| srineng2 | argon2$4$32768$4$32$viLt... | 10.36.1.37:59302 | Y | admin |

### Internal IPs discovered
- 10.36.1.15 (sa)
- 10.36.1.37 (deborani, delian, deview, srineng)
- 10.36.3.181 (anastasia)
- 10.36.5.15 (delian2)

### Supplier codes: 1050, 1048
### OTP table (empty)
### App: "finance" (m_apps)

## 2. Locksmith.sql — Investment Portfolio Management

### locksmith_user (1 record)
- password_hash: 0a5bfe3efd47d3520d4723f90b52e0e4a1b3b09a6afd8f53b4dc2fccc164919a
- second_field: bb17bccf6bc34c0427ba1c4ac91c68067b940c70094c9f263cd7ddbeaa619a23

### locksmith_token (1 record — LIVE tokens!)
- authtoken: 14ec34d8e3fb1254b48fcbbe32776fc8e4155eb6afb90d0107e394bb4b192469
- accesstoken: c056a8b573c18a9f4e85ec978dccdfe9ead996c1878193da4ae9811d94e5ec70
- authtoken_datetime: 2024-07-22 15:39:59
- accesstoken_datetime: 2024-10-01 11:02:21
- refresh_token: 930f7bac642b3c2971a1c59cec1ce24e0431974a9193471e59d3787a8f946552

### Tables: 30+ (assetclass, costbase, bonds, stocks, trades, portfolios)
### Data: UBS, Credit Suisse holdings — AAPL, AMZN, BAC, BNTX, GILD, etc.
### Financial PII: trade lists, holdings, performance bonds

## 3. great-wall_Cloud_SQL_Export (338 MB) — MySQL 8.0.31-google

### m_member table
- mem_password field exists (varchar 500)
- Workforce management + HR system
- MASTER_KARYAWAN (employee master)
- WFH_FLAG, MST_SKEMA (work from home scheduling)
- m_itempromo, m_joinpromo (pharma promotions)
- t_invcon_header/detail (inventory control)
- bridgeTransactions_BFJ (thousands of Shopee transaction IDs)
- Shopee order data (product names, prices, J&T Express shipping)

### Shopee Transaction Data
Thousands of Shopee orders with:
- Transaction IDs (200627U3M3ERWV, etc.)
- Product names (Kojiesan Soap, Bio Oil, Redoxon, Selsun, etc.)
- Prices in IDR
- Shipping: J&T Express
- Shopee vouchers
- Outlet IDs (2383797600, 2379354941, 2376149437)