jmeeuynz_digitalso
Tables general_settings
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| physical_products_system | tinyint(1) | 1 | ||
| digital_products_system | tinyint(1) | 1 | ||
| marketplace_system | tinyint(1) | 1 | ||
| classified_ads_system | tinyint(1) | 1 | ||
| bidding_system | tinyint(1) | 1 | ||
| selling_license_keys_system | tinyint(1) | 1 | ||
| multi_vendor_system | tinyint(1) | 1 | ||
| membership_plans_system | tinyint(1) | NULL | ||
| site_lang | tinyint | 1 | ||
| timezone | varchar(100) | America/New_York | ||
| application_name | varchar(255) | NULL | ||
| selected_navigation | tinyint | 1 | ||
| fea_categories_design | varchar(30) | round_boxes | ||
| menu_limit | tinyint | 8 | ||
| recaptcha_site_key | varchar(500) | NULL | ||
| recaptcha_secret_key | varchar(500) | NULL | ||
| recaptcha_lang | varchar(30) | NULL | ||
| custom_header_codes | mediumtext | NULL | ||
| custom_footer_codes | mediumtext | NULL | ||
| mail_service | varchar(100) | swift | ||
| mail_protocol | varchar(20) | smtp | ||
| mail_encryption | varchar(100) | tls | ||
| mail_host | varchar(255) | NULL | ||
| mail_port | varchar(20) | NULL | ||
| mail_username | varchar(255) | NULL | ||
| mail_password | varchar(255) | NULL | ||
| mail_title | varchar(255) | NULL | ||
| mail_reply_to | varchar(255) | noreply@domain.com | ||
| mailjet_api_key | varchar(255) | NULL | ||
| mailjet_secret_key | varchar(255) | NULL | ||
| mailjet_email_address | varchar(255) | NULL | ||
| email_verification | tinyint(1) | NULL | ||
| facebook_app_id | varchar(500) | NULL | ||
| facebook_app_secret | varchar(500) | NULL | ||
| google_client_id | varchar(500) | NULL | ||
| google_client_secret | varchar(500) | NULL | ||
| vk_app_id | varchar(500) | NULL | ||
| vk_secure_key | varchar(500) | NULL | ||
| google_analytics | text | NULL | ||
| promoted_products | tinyint(1) | 1 | ||
| multilingual_system | tinyint(1) | 1 | ||
| product_comments | tinyint(1) | 1 | ||
| comment_approval_system | tinyint(1) | NULL | ||
| reviews | tinyint(1) | 1 | ||
| blog_comments | tinyint(1) | 1 | ||
| slider_status | tinyint | 1 | ||
| slider_type | varchar(30) | full_width | ||
| slider_effect | varchar(30) | fade | ||
| featured_categories | tinyint(1) | 1 | ||
| index_promoted_products | tinyint(1) | 1 | ||
| index_promoted_products_count | tinyint(1) | 8 | ||
| index_latest_products | tinyint(1) | 1 | ||
| index_latest_products_count | tinyint(1) | 4 | ||
| index_blog_slider | tinyint(1) | 1 | ||
| product_link_structure | varchar(20) | slug-id | ||
| site_color | varchar(100) | default | ||
| logo | varchar(255) | NULL | ||
| logo_email | varchar(255) | NULL | ||
| favicon | varchar(255) | NULL | ||
| watermark_text | varchar(255) | Modesy | ||
| watermark_font_size | smallint | 42 | ||
| watermark_vrt_alignment | varchar(20) | center | ||
| watermark_hor_alignment | varchar(20) | center | ||
| watermark_product_images | tinyint(1) | NULL | ||
| watermark_blog_images | tinyint(1) | NULL | ||
| watermark_thumbnail_images | tinyint(1) | NULL | ||
| facebook_comment | text | NULL | ||
| facebook_comment_status | tinyint(1) | NULL | ||
| cache_system | tinyint(1) | NULL | ||
| cache_static_system | tinyint(1) | 1 | ||
| refresh_cache_database_changes | tinyint(1) | NULL | ||
| cache_refresh_time | int | 1800 | ||
| rss_system | tinyint(1) | 1 | ||
| approve_before_publishing | tinyint(1) | 1 | ||
| approve_after_editing | tinyint(1) | NULL | ||
| vendor_verification_system | tinyint(1) | 1 | ||
| email_options | text | NULL | ||
| mail_options_account | varchar(100) | NULL | ||
| show_vendor_contact_information | tinyint(1) | 1 | ||
| guest_checkout | tinyint(1) | NULL | ||
| maintenance_mode_title | varchar(500) | NULL | ||
| maintenance_mode_description | varchar(2000) | NULL | ||
| maintenance_mode_status | tinyint(1) | NULL | ||
| google_adsense_code | varchar(2000) | NULL | ||
| sort_categories | varchar(30) | category_order | ||
| sort_parent_categories_by_order | tinyint(1) | 1 | ||
| pwa_status | tinyint(1) | NULL | ||
| pwa_logo | text | NULL | ||
| location_search_header | tinyint(1) | 1 | ||
| vendor_bulk_product_upload | tinyint(1) | 1 | ||
| vendors_change_shop_name | tinyint(1) | 1 | ||
| show_sold_products | tinyint(1) | 1 | ||
| newsletter_status | tinyint(1) | 1 | ||
| newsletter_popup | tinyint(1) | 1 | ||
| newsletter_image | varchar(255) | NULL | ||
| show_customer_email_seller | tinyint(1) | 1 | ||
| show_customer_phone_seller | tinyint(1) | 1 | ||
| request_documents_vendors | tinyint(1) | NULL | ||
| explanation_documents_vendors | varchar(500) | NULL | ||
| allow_free_plan_multiple_times | tinyint(1) | NULL | ||
| single_country_mode | tinyint(1) | NULL | ||
| single_country_id | int | NULL | ||
| refund_system | tinyint(1) | 1 | ||
| affiliate_status | tinyint(1) | NULL | ||
| affiliate_type | varchar(30) | site_based | ||
| affiliate_image | varchar(255) | NULL | ||
| affiliate_commission_rate | double | NULL | ||
| affiliate_discount_rate | double | NULL | ||
| auto_approve_orders | tinyint(1) | NULL | ||
| auto_approve_orders_days | smallint | 10 | ||
| logo_size | varchar(30) | 160x60 | ||
| profile_number_of_sales | tinyint(1) | 1 | ||
| last_cron_update | timestamp | NULL | ||
| version | varchar(30) | 2.5 |