my code stock.com

Truncate em todas as tabelas necessárias para ter uma base limpa.
Delete todas as entradas do ERP (contas e estoque) e Atendimentos.
Laudos e Pacientes permanecem.

Snippet options

Download: Download snippet as clean-smartris.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

SET FOREIGN_KEY_CHECKS = 0;



TRUNCATE TABLE erp_shopping_tracking;

TRUNCATE TABLE erp_shopping_requests_items;

TRUNCATE TABLE erp_inventory_log;
TRUNCATE TABLE erp_inventory;

TRUNCATE TABLE erp_shopping_items;
TRUNCATE TABLE erp_shopping_delivery;

TRUNCATE TABLE erp_shopping_tracking;
TRUNCATE TABLE erp_shopping;
TRUNCATE TABLE erp_shopping_requests;



TRUNCATE TABLE invoice_tracking;

TRUNCATE TABLE check_copy;

TRUNCATE TABLE nf_items;

TRUNCATE TABLE lot_items;
TRUNCATE TABLE lot;

TRUNCATE TABLE disallowances;
TRUNCATE TABLE invoice_items;

TRUNCATE TABLE invoice_payments;

TRUNCATE TABLE erp_cash_flow_group;

TRUNCATE TABLE invoice;

TRUNCATE TABLE schedule_item_attachments;

TRUNCATE TABLE schedule_item_tracking;
TRUNCATE TABLE schedule_items;

TRUNCATE TABLE schedule_sequence;
TRUNCATE TABLE schedule_request_item;
TRUNCATE TABLE schedule_requests;
TRUNCATE TABLE schedule;



TRUNCATE TABLE erp_cash_flow_attachments;

TRUNCATE TABLE erp_cash_flow_related;

TRUNCATE TABLE erp_cash_flow_tags;

TRUNCATE TABLE erp_cash_flow_tracking;

TRUNCATE TABLE erp_cash_flow;



SET FOREIGN_KEY_CHECKS = 1;

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.