UPDATE `employees`  SET `head_id`='0';
UPDATE `customer`  SET `head_id`='0';
UPDATE `suppliers`  SET `head_id`='0';
UPDATE `products` SET `stock` = '0';

DELETE FROM `action_log`;              ALTER TABLE `action_log` AUTO_INCREMENT=1;
DELETE FROM `a_head_entry`;         ALTER TABLE `a_head_entry` AUTO_INCREMENT=1;
DELETE FROM `a_voucher_entry`;      ALTER TABLE `a_voucher_entry` AUTO_INCREMENT=1;
DELETE FROM `customer_visit`;      ALTER TABLE `customer_visit` AUTO_INCREMENT=1;
DELETE FROM `a_heads`;              ALTER TABLE `a_heads` AUTO_INCREMENT=1;
DELETE FROM `user_login_session`;              ALTER TABLE `user_login_session` AUTO_INCREMENT=1;
DELETE FROM `product_stock_log`;              ALTER TABLE `product_stock_log` AUTO_INCREMENT=1;
DELETE FROM `purchase_details`;              ALTER TABLE `purchase_details` AUTO_INCREMENT=1;
DELETE FROM `production_product_source`;              ALTER TABLE `production_product_source` AUTO_INCREMENT=1;
DELETE FROM `production_product`;              ALTER TABLE `production_product` AUTO_INCREMENT=1;
DELETE FROM `sale_products`;              ALTER TABLE `sale_products` AUTO_INCREMENT=1;
DELETE FROM `purchase`;              ALTER TABLE `purchase` AUTO_INCREMENT=1;
DELETE FROM `purchase_order_details`;              ALTER TABLE `purchase_order_details` AUTO_INCREMENT=1;
DELETE FROM `purchase_requisition_details`;              ALTER TABLE `purchase_requisition_details` AUTO_INCREMENT=1;
DELETE FROM `doctor`;              ALTER TABLE `doctor` AUTO_INCREMENT=1;
DELETE FROM `purchase_order`;              ALTER TABLE `purchase_order` AUTO_INCREMENT=1;
DELETE FROM `sale_return_details`;              ALTER TABLE `sale_return_details` AUTO_INCREMENT=1;
DELETE FROM `sale_return`;              ALTER TABLE `sale_return` AUTO_INCREMENT=1;
DELETE FROM `doctor_products`;      ALTER TABLE `doctor_products` AUTO_INCREMENT=1;
DELETE FROM `doctor`;             ALTER TABLE `doctor` AUTO_INCREMENT=1;
DELETE FROM `honorarium_evaluation`;             ALTER TABLE `honorarium_evaluation` AUTO_INCREMENT=1;
DELETE FROM `sale_draft`;           ALTER TABLE `sale_draft` AUTO_INCREMENT=1;
DELETE FROM `deposit_request`;      ALTER TABLE `deposit_request` AUTO_INCREMENT=1;


