| setting_id |
int(1)
|
|
|
|
| logo |
varchar(255)
|
utf8_general_ci
|
|
|
| logo2 |
varchar(255)
|
utf8_general_ci
|
|
|
| site_name |
varchar(55)
|
utf8_general_ci
|
|
|
| language |
varchar(20)
|
utf8_general_ci
|
|
|
| default_warehouse |
int(2)
|
|
|
|
| accounting_method |
tinyint(4)
|
|
|
|
| default_currency |
varchar(3)
|
utf8_general_ci
|
|
|
| default_tax_rate |
int(2)
|
|
|
|
| rows_per_page |
int(2)
|
|
|
|
| version |
varchar(10)
|
utf8_general_ci
|
|
|
| default_tax_rate2 |
int(11)
|
|
|
|
| dateformat |
int(11)
|
|
|
|
| sales_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| quote_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| purchase_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| transfer_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| delivery_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| payment_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| return_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| returnp_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| expense_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| item_addition |
tinyint(1)
|
|
|
|
| theme |
varchar(20)
|
utf8_general_ci
|
|
|
| product_serial |
tinyint(4)
|
|
|
|
| default_discount |
int(11)
|
|
|
|
| product_discount |
tinyint(1)
|
|
|
|
| discount_method |
tinyint(4)
|
|
|
|
| tax1 |
tinyint(4)
|
|
|
|
| tax2 |
tinyint(4)
|
|
|
|
| overselling |
tinyint(1)
|
|
|
|
| restrict_user |
tinyint(4)
|
|
|
|
| restrict_calendar |
tinyint(4)
|
|
|
|
| timezone |
varchar(100)
|
utf8_general_ci
|
|
|
| iwidth |
int(11)
|
|
|
|
| iheight |
int(11)
|
|
|
|
| twidth |
int(11)
|
|
|
|
| theight |
int(11)
|
|
|
|
| watermark |
tinyint(1)
|
|
|
|
| reg_ver |
tinyint(1)
|
|
|
|
| allow_reg |
tinyint(1)
|
|
|
|
| reg_notification |
tinyint(1)
|
|
|
|
| auto_reg |
tinyint(1)
|
|
|
|
| protocol |
varchar(20)
|
utf8_general_ci
|
|
|
| mailpath |
varchar(55)
|
utf8_general_ci
|
|
|
| smtp_host |
varchar(100)
|
utf8_general_ci
|
|
|
| smtp_user |
varchar(100)
|
utf8_general_ci
|
|
|
| smtp_pass |
varchar(255)
|
utf8_general_ci
|
|
|
| smtp_port |
varchar(10)
|
utf8_general_ci
|
|
|
| smtp_crypto |
varchar(10)
|
utf8_general_ci
|
|
|
| corn |
datetime
|
|
|
|
| customer_group |
int(11)
|
|
|
|
| default_email |
varchar(100)
|
utf8_general_ci
|
|
|
| mmode |
tinyint(1)
|
|
|
|
| bc_fix |
tinyint(4)
|
|
|
|
| auto_detect_barcode |
tinyint(1)
|
|
|
|
| captcha |
tinyint(1)
|
|
|
|
| reference_format |
tinyint(1)
|
|
|
|
| racks |
tinyint(1)
|
|
|
|
| attributes |
tinyint(1)
|
|
|
|
| product_expiry |
tinyint(1)
|
|
|
|
| decimals |
tinyint(2)
|
|
|
|
| qty_decimals |
tinyint(2)
|
|
|
|
| decimals_sep |
varchar(2)
|
utf8_general_ci
|
|
|
| thousands_sep |
varchar(2)
|
utf8_general_ci
|
|
|
| invoice_view |
tinyint(1)
|
|
|
|
| default_biller |
int(11)
|
|
|
|
| envato_username |
varchar(50)
|
utf8_general_ci
|
|
|
| purchase_code |
varchar(100)
|
utf8_general_ci
|
|
|
| rtl |
tinyint(1)
|
|
|
|
| each_spent |
decimal(15,4)
|
|
|
|
| ca_point |
tinyint(4)
|
|
|
|
| each_sale |
decimal(15,4)
|
|
|
|
| sa_point |
tinyint(4)
|
|
|
|
| update |
tinyint(1)
|
|
|
|
| sac |
tinyint(1)
|
|
|
|
| display_all_products |
tinyint(1)
|
|
|
|
| display_symbol |
tinyint(1)
|
|
|
|
| symbol |
varchar(50)
|
utf8_general_ci
|
|
|
| remove_expired |
tinyint(1)
|
|
|
|
| barcode_separator |
varchar(2)
|
utf8_general_ci
|
|
|
| set_focus |
tinyint(1)
|
|
|
|
| price_group |
int(11)
|
|
|
|
| barcode_img |
tinyint(1)
|
|
|
|
| ppayment_prefix |
varchar(20)
|
utf8_general_ci
|
|
|
| disable_editing |
smallint(6)
|
|
|
|
| qa_prefix |
varchar(55)
|
utf8_general_ci
|
|
|
| update_cost |
tinyint(1)
|
|
|
|
| apis |
tinyint(1)
|
|
|
|
| state |
varchar(100)
|
utf8_general_ci
|
|
|
| pdf_lib |
varchar(20)
|
utf8_general_ci
|
|
|
| use_code_for_slug |
tinyint(1)
|
|
|
|
| ws_barcode_type |
varchar(10)
|
utf8_general_ci
|
|
|
| ws_barcode_chars |
tinyint(4)
|
|
|
|
| flag_chars |
tinyint(4)
|
|
|
|
| item_code_start |
tinyint(4)
|
|
|
|
| item_code_chars |
tinyint(4)
|
|
|
|
| price_start |
tinyint(4)
|
|
|
|
| price_chars |
tinyint(4)
|
|
|
|
| price_divide_by |
int(11)
|
|
|
|
| weight_start |
tinyint(4)
|
|
|
|
| weight_chars |
tinyint(4)
|
|
|
|
| weight_divide_by |
int(11)
|
|
|
|
| ksa_qrcode |
tinyint(1)
|
|
|
|
