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