# Analysis: master.sql

**File size:** 135,109 bytes
**Total tables:** 63
**Tables with secret columns:** 7
**Total INSERT statements:** 44

## All Tables (with row counts)

| # | Table | INSERT count | Secret columns |
|---|-------|--------------|----------------|
| 1 | `OTP_Log` | 1 | - |
| 2 | `alibaba_config` | 0 | - |
| 3 | `aliexpress_config` | 0 | - |
| 4 | `amazon_config` | 0 | - |
| 5 | `botcatcher_config` | 0 | - |
| 6 | `bpom_config` | 1 | - |
| 7 | `config_log` | 1 | - |
| 8 | `crawler_machine_log` | 1 | - |
| 9 | `email_instant_config` | 0 | password |
| 10 | `engine_log` | 1 | - |
| 11 | `error_log` | 0 | - |
| 12 | `excel_config` | 1 | - |
| 13 | `facebook_config` | 0 | - |
| 14 | `gender_config` | 1 | - |
| 15 | `getcraft_config` | 1 | - |
| 16 | `google_config` | 1 | - |
| 17 | `google_search_config` | 1 | - |
| 18 | `gtrends_config` | 1 | - |
| 19 | `gtrends_keyphrases_config` | 1 | - |
| 20 | `halal_config` | 1 | - |
| 21 | `hitcatcher_config` | 1 | - |
| 22 | `influencer_crawling` | 1 | - |
| 23 | `instagram_config` | 1 | - |
| 24 | `instagram_email_config` | 0 | - |
| 25 | `instagram_search_config` | 1 | - |
| 26 | `migrations` | 1 | - |
| 27 | `model_has_permissions` | 0 | - |
| 28 | `model_has_roles` | 0 | - |
| 29 | `password_resets` | 0 | token |
| 30 | `permissions` | 0 | - |
| 31 | `phrase_clustering_config` | 1 | - |
| 32 | `query_template` | 1 | - |
| 33 | `regex_config` | 1 | - |
| 34 | `role_has_permissions` | 0 | - |
| 35 | `roles` | 0 | - |
| 36 | `running_log` | 1 | - |
| 37 | `running_template` | 1 | - |
| 38 | `running_template_sequence` | 1 | - |
| 39 | `shopee_categories_config` | 0 | - |
| 40 | `shopee_merchant_config` | 1 | - |
| 41 | `shopee_messaging_config` | 0 | password |
| 42 | `shopee_product_config` | 1 | - |
| 43 | `shopee_search_config` | 1 | - |
| 44 | `sociabuzz_config` | 1 | - |
| 45 | `social_google_accounts` | 0 | access_token, refresh_token |
| 46 | `socialblade_config` | 1 | - |
| 47 | `socialblade_toplist_config` | 1 | - |
| 48 | `source_table_log` | 1 | - |
| 49 | `tokopedia_categories_config` | 0 | - |
| 50 | `tokopedia_merchant_config` | 1 | - |
| 51 | `tokopedia_messaging_config` | 0 | password |
| 52 | `tokopedia_product_config` | 1 | - |
| 53 | `tokopedia_search_config` | 1 | - |
| 54 | `tokopedia_upload_config` | 0 | - |
| 55 | `twitter_config` | 1 | - |
| 56 | `twitter_search_config` | 1 | - |
| 57 | `twitterapi_config` | 1 | - |
| 58 | `users` | 1 | password |
| 59 | `voluspa_login` | 2 | password |
| 60 | `wikipedia_show_config` | 1 | - |
| 61 | `wikipedia_summary_box_config` | 1 | - |
| 62 | `youtube_config` | 1 | - |
| 63 | `youtube_search_config` | 1 | - |

## Secret Column Details

### `email_instant_config`
- Secret columns: password
- INSERT statements: 0

### `password_resets`
- Secret columns: token
- INSERT statements: 0

### `shopee_messaging_config`
- Secret columns: password
- INSERT statements: 0

### `social_google_accounts`
- Secret columns: access_token, refresh_token
- INSERT statements: 0

### `tokopedia_messaging_config`
- Secret columns: password
- INSERT statements: 0

### `users`
- Secret columns: password
- INSERT statements: 1
- Sample INSERT data (first 1 rows):

```
INSERT INTO `users` VALUES
```

### `voluspa_login`
- Secret columns: password
- INSERT statements: 2
- Sample INSERT data (first 2 rows):

```
INSERT INTO `voluspa_login` VALUES
	Insert into voluspa_login values (NOW(), "", nip1, username1, phone1, password1, "User");
```