| id |
int(10)
|
|
|
|
| userID |
int(11)
|
|
|
|
| app_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| from_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| from_email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| reply_to |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| currency |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| delivery_fee |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| cost_per_recipient |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| smtp_host |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| smtp_port |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| smtp_ssl |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| smtp_username |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| smtp_password |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| bounce_setup |
int(11)
|
|
|
|
| complaint_setup |
int(11)
|
|
|
|
| app_key |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| allocated_quota |
int(11)
|
|
|
|
| current_quota |
int(11)
|
|
|
|
| day_of_reset |
int(11)
|
|
|
|
| month_of_next_reset |
varchar(3)
|
utf8mb4_unicode_ci
|
|
|
| year_of_next_reset |
varchar(4)
|
utf8mb4_unicode_ci
|
|
|
| no_expiry |
int(11)
|
|
|
|
| test_email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| brand_logo_filename |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| allowed_attachments |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| reports_only |
int(11)
|
|
|
|
| campaigns_only |
int(11)
|
|
|
|
| templates_only |
int(11)
|
|
|
|
| lists_only |
int(11)
|
|
|
|
| notify_campaign_sent |
int(11)
|
|
|
|
| campaign_report_rows |
int(11)
|
|
|
|
| query_string |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| gdpr_only |
int(11)
|
|
|
|
| gdpr_options |
int(11)
|
|
|
|
| gdpr_only_ar |
int(11)
|
|
|
|
| recaptcha_sitekey |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| recaptcha_secretkey |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| custom_domain |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| custom_domain_protocol |
varchar(5)
|
utf8mb4_unicode_ci
|
|
|
| custom_domain_enabled |
int(11)
|
|
|
|
| test_email_prefix |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| templates_lists_sorting |
varchar(4)
|
utf8mb4_unicode_ci
|
|
|
| opens_tracking |
int(11)
|
|
|
|
| links_tracking |
int(11)
|
|
|
|
| is_sendybay_account_paused |
tinyint(1)
|
|
|
|
| account_paused_reason |
varchar(1000)
|
utf8mb4_unicode_ci
|
|
|
| sb_db_migration_version |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| hide_lists |
int(11)
|
|
|
|
| opt_in |
int(11)
|
|
|
|