|
setting_id
|
int(1)
|
|
|
|
|
logo
|
varchar(255)
|
|
|
|
|
logo2
|
varchar(255)
|
|
|
|
|
site_name
|
varchar(55)
|
|
|
|
|
language
|
varchar(20)
|
|
|
|
|
default_warehouse
|
int(2)
|
|
|
|
|
accounting_method
|
tinyint(4)
|
|
|
0
|
|
default_currency
|
varchar(3)
|
|
|
|
|
default_tax_rate
|
int(2)
|
|
|
|
|
rows_per_page
|
int(2)
|
|
|
|
|
version
|
varchar(10)
|
|
|
1.0
|
|
default_tax_rate2
|
int(11)
|
|
|
0
|
|
dateformat
|
int(11)
|
|
|
|
|
sales_prefix
|
varchar(20)
|
|
|
|
|
quote_prefix
|
varchar(20)
|
|
|
|
|
purchase_prefix
|
varchar(20)
|
|
|
|
|
transfer_prefix
|
varchar(20)
|
|
|
|
|
delivery_prefix
|
varchar(20)
|
|
|
|
|
payment_prefix
|
varchar(20)
|
|
|
|
|
return_prefix
|
varchar(20)
|
|
|
|
|
returnp_prefix
|
varchar(20)
|
|
|
|
|
expense_prefix
|
varchar(20)
|
|
|
|
|
item_addition
|
tinyint(1)
|
|
|
0
|
|
theme
|
varchar(20)
|
|
|
|
|
product_serial
|
tinyint(4)
|
|
|
|
|
default_discount
|
int(11)
|
|
|
|
|
product_discount
|
tinyint(1)
|
|
|
0
|
|
discount_method
|
tinyint(4)
|
|
|
|
|
tax1
|
tinyint(4)
|
|
|
|
|
tax2
|
tinyint(4)
|
|
|
|
|
overselling
|
tinyint(1)
|
|
|
0
|
|
restrict_user
|
tinyint(4)
|
|
|
0
|
|
restrict_calendar
|
tinyint(4)
|
|
|
0
|
|
timezone
|
varchar(100)
|
|
|
|
|
iwidth
|
int(11)
|
|
|
0
|
|
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)
|
|
|
mail
|
|
mailpath
|
varchar(55)
|
|
|
/usr/sbin/sendmail
|
|
smtp_host
|
varchar(100)
|
|
|
|
|
smtp_user
|
varchar(100)
|
|
|
|
|
smtp_pass
|
varchar(255)
|
|
|
|
|
smtp_port
|
varchar(10)
|
|
|
25
|
|
smtp_crypto
|
varchar(10)
|
|
|
|
|
corn
|
datetime
|
|
|
|
|
customer_group
|
int(11)
|
|
|
|
|
default_email
|
varchar(100)
|
|
|
|
|
mmode
|
tinyint(1)
|
|
|
|
|
bc_fix
|
tinyint(4)
|
|
|
0
|
|
auto_detect_barcode
|
tinyint(1)
|
|
|
0
|
|
captcha
|
tinyint(1)
|
|
|
1
|
|
reference_format
|
tinyint(1)
|
|
|
1
|
|
racks
|
tinyint(1)
|
|
|
0
|
|
attributes
|
tinyint(1)
|
|
|
0
|
|
product_expiry
|
tinyint(1)
|
|
|
0
|
|
decimals
|
tinyint(2)
|
|
|
2
|
|
qty_decimals
|
tinyint(2)
|
|
|
2
|
|
decimals_sep
|
varchar(2)
|
|
|
.
|
|
thousands_sep
|
varchar(2)
|
|
|
,
|
|
invoice_view
|
tinyint(1)
|
|
|
0
|
|
default_biller
|
int(11)
|
|
|
|
|
envato_username
|
varchar(50)
|
|
|
|
|
purchase_code
|
varchar(100)
|
|
|
|
|
rtl
|
tinyint(1)
|
|
|
0
|
|
each_spent
|
decimal(15,4)
|
|
|
|
|
ca_point
|
tinyint(4)
|
|
|
|
|
each_sale
|
decimal(15,4)
|
|
|
|
|
sa_point
|
tinyint(4)
|
|
|
|
|
update
|
tinyint(1)
|
|
|
0
|
|
sac
|
tinyint(1)
|
|
|
0
|
|
display_all_products
|
tinyint(1)
|
|
|
0
|
|
display_symbol
|
tinyint(1)
|
|
|
|
|
symbol
|
varchar(50)
|
|
|
|
|
remove_expired
|
tinyint(1)
|
|
|
0
|
|
barcode_separator
|
varchar(2)
|
|
|
-
|
|
set_focus
|
tinyint(1)
|
|
|
0
|
|
price_group
|
int(11)
|
|
|
|
|
barcode_img
|
tinyint(1)
|
|
|
1
|
|
ppayment_prefix
|
varchar(20)
|
|
|
POP
|
|
disable_editing
|
smallint(6)
|
|
|
90
|
|
qa_prefix
|
varchar(55)
|
|
|
|
|
update_cost
|
tinyint(1)
|
|
|
|
|
apis
|
tinyint(1)
|
|
|
0
|
|
state
|
varchar(100)
|
|
|
|
|
pdf_lib
|
varchar(20)
|
|
|
dompdf
|
|
use_code_for_slug
|
tinyint(1)
|
|
|
|
|
ws_barcode_type
|
varchar(10)
|
|
|
weight
|
|
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)
|
|
|
|