Table comparison: sma_permissions
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
group_id |
int(11) |
NO |
int(11) |
NO |
|
products-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
products-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
products-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
products-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
products-cost |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
products-price |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes-pdf |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes-email |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-pdf |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-email |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-pdf |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-email |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
transfers-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
transfers-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
transfers-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
transfers-pdf |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
transfers-email |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
transfers-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
customers-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
customers-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
customers-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
customers-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
suppliers-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
suppliers-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
suppliers-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
suppliers-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-deliveries |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-add_delivery |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-edit_delivery |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-delete_delivery |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-email_delivery |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-pdf_delivery |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-gift_cards |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-add_gift_card |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-edit_gift_card |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-delete_gift_card |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
pos-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-return_sales |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-warehouse_stock |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-quantity_alerts |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-expiry_alerts |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-products |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-daily_sales |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-monthly_sales |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-sales |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-payments |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-purchases |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-profit_loss |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-customers |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-suppliers |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-staff |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-register |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
sales-payments |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-payments |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
purchases-expenses |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
products-adjustments |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
bulk_actions |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
customers-deposits |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
customers-delete_deposit |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
products-barcode |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
purchases-return_purchases |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
reports-expenses |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
reports-daily_purchases |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-monthly_purchases |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
products-stock_count |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
edit_price |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
returns-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
returns-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
returns-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
returns-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
returns-email |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
returns-pdf |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
reports-tax |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes2-index |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes2-add |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes2-edit |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes2-pdf |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes2-email |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
quotes2-delete |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-list-printers |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-add-printers |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-logo |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-moneda |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-impuesto |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-almacenes |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-plantilla |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-permisos |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-logs |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-change-backups |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-system-settigns |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-post-settigns |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-promos |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-grupo-clientes |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-grupo-precios |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-expense |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-unidad |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-marca |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-variante |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-categorias |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-tarjetas |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
ajustes-cuotas-tarjetas |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
protect_delete |
tinyint(3) unsigned |
NO |
tinyint(3) unsigned |
NO |
|
misc-close_register |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
show_groups |
tinyint(3) unsigned |
NO |
tinyint(3) unsigned |
NO |