truncate table error_log;
truncate table tbl_brand;
truncate table tbl_cashbook;
truncate table tbl_category;
truncate table tbl_chair;
truncate table tbl_chair_allocation;
truncate table tbl_customer;
truncate table tbl_employee;
truncate table tbl_login_log;
truncate table tbl_product;
truncate table tbl_product_group;
truncate table tbl_purchase;
truncate table tbl_purchase_item;
truncate table tbl_sale_item;
truncate table tbl_service;
truncate table tbl_service_group;
truncate table tbl_service_head;
truncate table tbl_service_item;
truncate table tbl_stock;
truncate table tbl_subcategory;
truncate table tbl_supplier;
truncate table tbl_tax;
------------------------



ALTER TABLE `tbl_sale_item` CHANGE `sale_item_product` `sale_item_stock` TINYINT(4) NOT NULL;
ALTER TABLE `tbl_stock` CHANGE `stock_type` `stock_from` TINYINT(2) NOT NULL DEFAULT '1' COMMENT '1-From Purchase,2-From Product';
ALTER TABLE `tbl_supplier` ADD `supplier_credit` DECIMAL(10,2) NOT NULL AFTER `supplier_payment_method`;
ALTER TABLE `tbl_purchase` CHANGE `purchase_frieght` `purchase_freight` DECIMAL(10,2) NOT NULL;
ALTER TABLE `tbl_purchase` DROP `purchase_invoice_tax_amount`, DROP `purchase_invoice_discount_percentage`, DROP `purchase_invoice_discount_amount`;