ALTER TABLE `sales_header`   ADD `synced` TINYINT NOT NULL DEFAULT '0' AFTER `customer_pin`, ADD `synced_on` DATETIME NULL AFTER `synced`; 
ALTER TABLE `vendorinvoices` ADD `synced` TINYINT NOT NULL DEFAULT '0' AFTER `totalAmount`,  ADD `synced_on` DATETIME NULL AFTER `synced`; 

CREATE TABLE `sync_data` (
  `id` int(11) NOT NULL,
  `sync_type` varchar(50) NOT NULL,
  `server_time` datetime NOT NULL,
  `added_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `sync_data`
ALTER TABLE `sync_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

